Symfony Profiler

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 = ?

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 = 'exploitant.test@test.fr' OR u0_.username = 'exploitant.test@test.fr';

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

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 = 'demo-aquapark' LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.slug AS slug_2,
  t0_.active AS active_3,
  t0_.description AS description_4,
  t0_.role AS role_5,
  t0_.parent_id AS parent_id_6
FROM
  taxonomy t0_
  INNER JOIN taxonomy t1_ ON t0_.parent_id = t1_.id
WHERE
  t1_.slug = ?
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.active AS active_3, t0_.description AS description_4, t0_.role AS role_5, t0_.parent_id AS parent_id_6 FROM taxonomy t0_ INNER JOIN taxonomy t1_ ON t0_.parent_id = t1_.id WHERE t1_.slug = 'report' ORDER BY t0_.name ASC;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.slug AS slug_2,
  t0_.active AS active_3,
  t0_.description AS description_4,
  t0_.role AS role_5,
  t0_.parent_id AS parent_id_6
FROM
  taxonomy t0_
  INNER JOIN taxonomy t1_ ON t0_.parent_id = t1_.id
WHERE
  t1_.slug = ?
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.active AS active_3, t0_.description AS description_4, t0_.role AS role_5, t0_.parent_id AS parent_id_6 FROM taxonomy t0_ INNER JOIN taxonomy t1_ ON t0_.parent_id = t1_.id WHERE t1_.slug = 'accident-report' ORDER BY t0_.name ASC;

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
  r0_.event_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND p1_.id = ?
ORDER BY
  r0_.created_at DESC

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 r0_.event_type_id IN (53, 52, 23, 25, 29, 51, 49, 28, 26, 27, 36, 61, 48) AND p1_.id = 8 ORDER BY r0_.created_at DESC;

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 = ?

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

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 = ?

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

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 = ?

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

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 = ?

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

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 = ?

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

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 = ?

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

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 = ?

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

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 = ?

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

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 = ?

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

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 = ?

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

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 = ?

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

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
  r0_.event_type_id IN (?, ?, ?, ?)
  AND p1_.id = ?
ORDER BY
  r0_.created_at DESC

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 r0_.event_type_id IN (68, 69, 67, 54) AND p1_.id = 8 ORDER BY r0_.created_at DESC;