Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 5
• Events
• Routing
• Cache
• Translation 1
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 2
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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

[
  1
  10
  1774561909
]

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 = 10 ORDER BY ABS(m0_.timestamp - 1774561909) ASC 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 = ? LIMIT 1

[
  "site-de-grenelle"
]

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

[
  "eric@caravanemedia.com"
  "eric@caravanemedia.com"
]

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

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 = 'eric@caravanemedia.com' OR u0_.username = 'eric@caravanemedia.com';

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.place_id = ? AND t0.parameter_id IN (?)

[
  1
  28
]

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.place_id = ?
  AND t0.parameter_id IN (?)

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.place_id = 1 AND t0.parameter_id IN (28);

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

[
  "place"
]

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

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 = ? AND t0.slug = ?

[
  "place"
  "people_total"
]

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 = ?
  AND t0.slug = ?

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 = 'place' AND t0.slug = 'people_total';