Symfony Profiler

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

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 = 'site-de-grenelle' LIMIT 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
FROM
  parameter t0
WHERE
  t0.category = ?

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 = 'water';

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

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 = 1 AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = 2 ORDER BY ABS(m0_.timestamp - 1774573803) ASC LIMIT 1;

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

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 = 1 AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = 4 ORDER BY ABS(m0_.timestamp - 1774573803) ASC LIMIT 1;

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

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 = 1 AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = 5 ORDER BY ABS(m0_.timestamp - 1774573803) ASC LIMIT 1;

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

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 = 1 AND m0_.value IS NOT NULL AND m0_.forecast IS NULL AND m0_.parameter_id = 25 ORDER BY ABS(m0_.timestamp - 1774573803) ASC LIMIT 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
FROM
  parameter t0
WHERE
  t0.slug = ?
  AND t0.category = ?
LIMIT
  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 FROM parameter t0 WHERE t0.slug = 'quality' AND t0.category = 'water' LIMIT 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
WHERE
  t0.slug = ?
LIMIT
  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 WHERE t0.slug = 'chef-bassin' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.value AS value_1,
  s0_.day AS day_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4,
  s0_.created_by AS created_by_5,
  s0_.updated_by AS updated_by_6,
  s0_.place_id AS place_id_7,
  s0_.user_id AS user_id_8,
  s0_.profile_id AS profile_id_9
FROM
  status s0_
WHERE
  s0_.updated_at >= ?
  AND s0_.place_id = ?
  AND s0_.profile_id = ?
ORDER BY
  s0_.created_at DESC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.value AS value_1, s0_.day AS day_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.created_by AS created_by_5, s0_.updated_by AS updated_by_6, s0_.place_id AS place_id_7, s0_.user_id AS user_id_8, s0_.profile_id AS profile_id_9 FROM status s0_ WHERE s0_.updated_at >= '2026-03-27 00:00:00' AND s0_.place_id = 1 AND s0_.profile_id = 21 ORDER BY s0_.created_at DESC LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.value AS value_1,
  s0_.day AS day_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4,
  s0_.created_by AS created_by_5,
  s0_.updated_by AS updated_by_6,
  s0_.place_id AS place_id_7,
  s0_.user_id AS user_id_8,
  s0_.profile_id AS profile_id_9
FROM
  status s0_
WHERE
  s0_.updated_at >= ?
  AND s0_.place_id = ?
  AND s0_.profile_id IS NULL
ORDER BY
  s0_.created_at DESC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.value AS value_1, s0_.day AS day_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.created_by AS created_by_5, s0_.updated_by AS updated_by_6, s0_.place_id AS place_id_7, s0_.user_id AS user_id_8, s0_.profile_id AS profile_id_9 FROM status s0_ WHERE s0_.updated_at >= '2026-03-27 00:00:00' AND s0_.place_id = 1 AND s0_.profile_id IS NULL ORDER BY s0_.created_at DESC LIMIT 1;

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

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 = 1 AND m0_.parameter_id = 25 AND m0_.created_at >= '2026-03-27 00:00:00' AND m0_.created_at < '2026-03-27 02:10:03' ORDER BY m0_.updated_at DESC LIMIT 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
WHERE
  t0.slug = ?
LIMIT
  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 WHERE t0.slug = 'water-quality-report' LIMIT 1;

SELECT
  r0_.id AS id_0,
  r0_.subject AS subject_1,
  r0_.content AS content_2,
  r0_.images AS images_3,
  r0_.created_at AS created_at_4,
  r0_.updated_at AS updated_at_5,
  r0_.created_by AS created_by_6,
  r0_.updated_by AS updated_by_7,
  r0_.event_type_id AS event_type_id_8
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

SELECT r0_.id AS id_0, r0_.subject AS subject_1, r0_.content AS content_2, r0_.images AS images_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5, r0_.created_by AS created_by_6, r0_.updated_by AS updated_by_7, r0_.event_type_id AS event_type_id_8 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 = 1 AND r0_.event_type_id = 27 ORDER BY r0_.created_at DESC LIMIT 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 = ?

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 = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.roles AS roles_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.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.created_by AS created_by_17,
  t0.updated_by AS updated_by_18,
  t0.function_id AS function_id_19,
  t0.company_id AS company_id_20
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_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.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.function_id AS function_id_19, t0.company_id AS company_id_20 FROM user t0 WHERE t0.email = 'reset' LIMIT 1;