GET https://dev.boaz-connect.fr/fr/status/demo-baignade

Query Metrics

21 Database Queries
12 Different statements
10.88 ms Query time
3 Invalid entities
22 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.49 ms
(22.88%)
2
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_.parameter_id = ? AND m0_.created_at >= ? AND m0_.created_at < ? ORDER BY m0_.updated_at DESC LIMIT 1
Parameters:
[
  10
  25
  "2026-06-17 00:00:00"
  "2026-06-18 00:00:00"
]
1.86 ms
(17.09%)
4
SELECT s0_.id AS id_0, s0_.value AS value_1, s0_.role AS role_2, s0_.day AS day_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.created_by AS created_by_6, s0_.updated_by AS updated_by_7, s0_.place_id AS place_id_8, s0_.user_id AS user_id_9, s0_.profile_id AS profile_id_10 FROM status s0_ WHERE s0_.updated_at >= ? AND s0_.place_id = ? AND s0_.role = ? ORDER BY s0_.created_at DESC LIMIT 1
Parameters:
[
  "2026-06-17 00:00:00"
  10
  "ROLE_EXPLOITANT"
]
1.36 ms
(12.50%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.description AS description_5, t0.role AS role_6, t0.parent_id AS parent_id_7 FROM taxonomy t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "exploitant"
]
1.11 ms
(10.23%)
3
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.role AS role_4, t0.password AS password_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.position AS position_8, t0.user AS user_9, t0.active AS active_10, t0.phone AS phone_11, t0.picture AS picture_12, t0.plain_password AS plain_password_13, t0.deleted AS deleted_14, t0.language AS language_15, t0.type AS type_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.created_by AS created_by_19, t0.updated_by AS updated_by_20, t0.function_id AS function_id_21, t0.company_id AS company_id_22 FROM user t0 WHERE t0.id = ?
Parameters:
[
  91
]
0.90 ms
(8.25%)
1
SELECT r0_.id AS id_0, r0_.subject AS subject_1, r0_.content AS content_2, r0_.images AS images_3, r0_.date AS date_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.created_by AS created_by_7, r0_.updated_by AS updated_by_8, r0_.event_type_id AS event_type_id_9, r0_.module_id AS module_id_10, r0_.checklist_id AS checklist_id_11 FROM report r0_ INNER JOIN report_place r2_ ON r0_.id = r2_.report_id INNER JOIN place p1_ ON p1_.id = r2_.place_id WHERE p1_.id = ? AND r0_.event_type_id = ? ORDER BY r0_.created_at DESC LIMIT 1
Parameters:
[
  10
  27
]
0.82 ms
(7.56%)
1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.role AS role_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_.language AS language_14, u0_.type AS type_15, u0_.created_at AS created_at_16, u0_.updated_at AS updated_at_17, u0_.created_by AS created_by_18, u0_.updated_by AS updated_by_19, u0_.function_id AS function_id_20, u0_.company_id AS company_id_21 FROM user u0_ WHERE u0_.email = ? OR u0_.username = ?
Parameters:
[
  "hello@charlined.fr"
  "hello@charlined.fr"
]
0.55 ms
(5.03%)
1
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.control_code AS control_code_20, t0.link AS link_21, t0.boazcreate AS boazcreate_22, t0.pict3d AS pict3d_23, t0.drive_directory AS drive_directory_24, t0.opening_days AS opening_days_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.created_by AS created_by_28, t0.updated_by AS updated_by_29, t0.client_id AS client_id_30 FROM place t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "demo-baignade"
]
0.42 ms
(3.90%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.description AS description_5, t0.role AS role_6, t0.parent_id AS parent_id_7 FROM taxonomy t0 INNER JOIN place_taxonomy ON t0.id = place_taxonomy.taxonomy_id WHERE place_taxonomy.place_id = ?
Parameters:
[
  10
]
0.40 ms
(3.70%)
1
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, t0.type AS type_8 FROM parameter t0 WHERE t0.slug = ? AND t0.category = ? LIMIT 1
Parameters:
[
  "quality"
  "water"
]
0.37 ms
(3.41%)
1
SELECT t0.id AS id_1, t0.value AS value_2, t0.raw AS raw_3, t0.source AS source_4, t0.timestamp AS timestamp_5, t0.forecast AS forecast_6, t0.strymo_id AS strymo_id_7, t0.kind AS kind_8, t0.day AS day_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.place_id AS place_id_12, t0.parameter_id AS parameter_id_13, t0.document_id AS document_id_14, t0.report_id AS report_id_15 FROM metric t0 WHERE t0.report_id = ?
Parameters:
[
  1019
]
0.30 ms
(2.74%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo AS logo_4, t0.cover AS cover_5, t0.color AS color_6, t0.active AS active_7, t0.domain AS domain_8, t0.preview_code AS preview_code_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13 FROM client t0 WHERE t0.id = ?
Parameters:
[
  8
]
0.30 ms
(2.73%)
1
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, t0.type AS type_8 FROM parameter t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "quality"
]

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\Taxonomy 7
App\Entity\User 5
App\Entity\Status 4
App\Entity\Company 1
App\Entity\Place 1
App\Entity\Client 1
App\Entity\Parameter 1
App\Entity\Metric 1
App\Entity\Report 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Taxonomy No errors.
App\Entity\Company No 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\Message No errors.
App\Entity\Notification No errors.
App\Entity\Document No errors.
App\Entity\Client 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\Widget No errors.
App\Entity\Structure No errors.
App\Entity\News No errors.
App\Entity\Parameter No errors.
App\Entity\Task No errors.
App\Entity\Tutorial No errors.
App\Entity\Checklist No errors.
App\Entity\TaskDone No errors.
App\Entity\Todo
  • The association App\Entity\Todo#project refers to the inverse side field App\Entity\Taxonomy#todos which does not exist.
App\Entity\Chat No errors.