GET https://boaz-connect.fr/fr/place/site-de-grenelle/weather/refresh?card=0&type=forecast

Response
200 OK
Browse referrer URL
IP
104.28.40.31
Profiled on
Token
5ebebe

Query Metrics

25 Database Queries
7 Different statements
1712.35 ms Query time
2 Invalid entities
327 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.20 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.city AS city_4, t0.country AS country_5, t0.postalcode AS postalcode_6, t0.address AS address_7, t0.active AS active_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.webcam_url AS webcam_url_11, t0.weather_station_id AS weather_station_id_12, t0.water_station_id AS water_station_id_13, t0.opening_hours AS opening_hours_14, t0.max_people AS max_people_15, t0.picture AS picture_16, t0.strymo_station_id AS strymo_station_id_17, t0.jauge_url AS jauge_url_18, t0.preview_code AS preview_code_19, t0.link AS link_20, t0.boazcreate AS boazcreate_21, t0.pict3d AS pict3d_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26, t0.client_id AS client_id_27 FROM place t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "site-de-grenelle"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.88 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.unit AS unit_4, t0.description AS description_5, t0.category AS category_6, t0.strymo_id AS strymo_id_7 FROM parameter t0 WHERE t0.category = ?
Parameters: 
[
  "weather"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 156.13 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = ? ORDER BY ABS(m0_.timestamp - ?) ASC LIMIT 1
Parameters: 
[
  1
  1
  1774562189
]
View formatted query    View runnable query    Explain query    View query backtrace
4 108.96 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = ? ORDER BY ABS(m0_.timestamp - ?) ASC LIMIT 1
Parameters: 
[
  1
  3
  1774562189
]
View formatted query    View runnable query    Explain query    View query backtrace
5 101.05 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = ? ORDER BY ABS(m0_.timestamp - ?) ASC LIMIT 1
Parameters: 
[
  1
  6
  1774562190
]
View formatted query    View runnable query    Explain query    View query backtrace
6 140.85 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = ? ORDER BY ABS(m0_.timestamp - ?) ASC LIMIT 1
Parameters: 
[
  1
  7
  1774562190
]
View formatted query    View runnable query    Explain query    View query backtrace
7 1.00 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = ? ORDER BY ABS(m0_.timestamp - ?) ASC LIMIT 1
Parameters: 
[
  1
  8
  1774562190
]
View formatted query    View runnable query    Explain query    View query backtrace
8 101.99 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = ? ORDER BY ABS(m0_.timestamp - ?) ASC LIMIT 1
Parameters: 
[
  1
  9
  1774562190
]
View formatted query    View runnable query    Explain query    View query backtrace
9 110.42 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = ? ORDER BY ABS(m0_.timestamp - ?) ASC LIMIT 1
Parameters: 
[
  1
  11
  1774562190
]
View formatted query    View runnable query    Explain query    View query backtrace
10 1.14 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = ? ORDER BY ABS(m0_.timestamp - ?) ASC LIMIT 1
Parameters: 
[
  1
  12
  1774562190
]
View formatted query    View runnable query    Explain query    View query backtrace
11 39.99 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = ? ORDER BY ABS(m0_.timestamp - ?) ASC LIMIT 1
Parameters: 
[
  1
  13
  1774562190
]
View formatted query    View runnable query    Explain query    View query backtrace
12 40.59 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = ? ORDER BY ABS(m0_.timestamp - ?) ASC LIMIT 1
Parameters: 
[
  1
  14
  1774562190
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.92 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = ? ORDER BY ABS(m0_.timestamp - ?) ASC LIMIT 1
Parameters: 
[
  1
  15
  1774562190
]
View formatted query    View runnable query    Explain query    View query backtrace
14 100.85 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = ? ORDER BY ABS(m0_.timestamp - ?) ASC LIMIT 1
Parameters: 
[
  1
  23
  1774562190
]
View formatted query    View runnable query    Explain query    View query backtrace
15 100.89 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = ? ORDER BY ABS(m0_.timestamp - ?) ASC LIMIT 1
Parameters: 
[
  1
  24
  1774562190
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.90 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = ? ORDER BY ABS(m0_.timestamp - ?) ASC LIMIT 1
Parameters: 
[
  1
  26
  1774562190
]
View formatted query    View runnable query    Explain query    View query backtrace
17 99.80 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = ? ORDER BY ABS(m0_.timestamp - ?) ASC LIMIT 1
Parameters: 
[
  1
  27
  1774562190
]
View formatted query    View runnable query    Explain query    View query backtrace
18 0.76 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.unit AS unit_4, t0.description AS description_5, t0.category AS category_6, t0.strymo_id AS strymo_id_7 FROM parameter t0 WHERE t0.slug = ? AND t0.category = ? LIMIT 1
Parameters: 
[
  "temperature"
  "weather"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.45 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.unit AS unit_4, t0.description AS description_5, t0.category AS category_6, t0.strymo_id AS strymo_id_7 FROM parameter t0 WHERE t0.slug = ? AND t0.category = ? LIMIT 1
Parameters: 
[
  "cloud"
  "weather"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.44 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.unit AS unit_4, t0.description AS description_5, t0.category AS category_6, t0.strymo_id AS strymo_id_7 FROM parameter t0 WHERE t0.slug = ? AND t0.category = ? LIMIT 1
Parameters: 
[
  "rain"
  "weather"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.42 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.unit AS unit_4, t0.description AS description_5, t0.category AS category_6, t0.strymo_id AS strymo_id_7 FROM parameter t0 WHERE t0.slug = ? AND t0.category = ? LIMIT 1
Parameters: 
[
  "wind_speed"
  "weather"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.45 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.unit AS unit_4, t0.description AS description_5, t0.category AS category_6, t0.strymo_id AS strymo_id_7 FROM parameter t0 WHERE t0.slug = ? AND t0.category = ? LIMIT 1
Parameters: 
[
  "uv"
  "weather"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 300.51 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.forecast IS NOT NULL AND m0_.forecast >= ? AND m0_.value IS NOT NULL AND m0_.kind = ? ORDER BY m0_.forecast ASC, m0_.parameter_id ASC
Parameters: 
[
  1
  "2026-03-26 22:56:30"
  "hourly"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 300.39 ms 
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.raw AS raw_2, m0_.source AS source_3, m0_.timestamp AS timestamp_4, m0_.forecast AS forecast_5, m0_.strymo_id AS strymo_id_6, m0_.kind AS kind_7, m0_.day AS day_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10, m0_.place_id AS place_id_11, m0_.parameter_id AS parameter_id_12, m0_.document_id AS document_id_13, m0_.report_id AS report_id_14 FROM metric m0_ WHERE m0_.place_id = ? AND m0_.forecast IS NOT NULL AND m0_.forecast >= ? AND m0_.forecast <= ? AND m0_.value IS NOT NULL AND m0_.kind = ? ORDER BY m0_.forecast ASC, m0_.parameter_id ASC
Parameters: 
[
  1
  "2026-03-26 00:00:00"
  "2026-04-02 23:59:59"
  "daily"
]
View formatted query    View runnable query    Explain query    View query backtrace
25 1.37 ms 
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.firstname AS firstname_5, u0_.lastname AS lastname_6, u0_.position AS position_7, u0_.user AS user_8, u0_.active AS active_9, u0_.phone AS phone_10, u0_.picture AS picture_11, u0_.plain_password AS plain_password_12, u0_.deleted AS deleted_13, u0_.created_at AS created_at_14, u0_.updated_at AS updated_at_15, u0_.created_by AS created_by_16, u0_.updated_by AS updated_by_17, u0_.function_id AS function_id_18, u0_.company_id AS company_id_19 FROM user u0_ WHERE u0_.email = ? OR u0_.username = ?
Parameters: 
[
  "eric@caravanemedia.com"
  "eric@caravanemedia.com"
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Metric 309
App\Entity\Parameter 15
App\Entity\Place 1
App\Entity\Client 1
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\Place
  • The association App\Entity\Place#category refers to the inverse side field App\Entity\Taxonomy#places which does not exist.
App\Entity\Client No errors.
App\Entity\User No errors.
App\Entity\Report
  • The field App\Entity\Report#taskDones is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TaskDone#report does not contain the required 'inversedBy="taskDones"' attribute.
App\Entity\Water No errors.
App\Entity\Weather No errors.
App\Entity\Status No errors.
App\Entity\Webcam No errors.
App\Entity\Metric No errors.
App\Entity\Message No errors.
App\Entity\Notification No errors.
App\Entity\Document No errors.
App\Entity\Taxonomy No errors.
App\Entity\Widget No errors.
App\Entity\Structure No errors.
App\Entity\Parameter No errors.
App\Entity\Company No errors.