Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 WHERE t0.code = ? LIMIT 1

[
  "fr"
]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.tax AS tax_3,
  t0.reference_eloa AS reference_eloa_4,
  t0.label AS label_5
FROM
  country t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 WHERE t0.code = 'fr' LIMIT 1;

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.active AS active_3, n0_.public AS public_4, n0_.slug AS slug_5, n0_.created AS created_6, n0_.updated AS updated_7 FROM news n0_ WHERE n0_.active IN (?) AND n0_.public IN (?) ORDER BY n0_.id DESC) dctrn_result) dctrn_table

[
  true
  true
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.name AS name_1,
          n0_.description AS description_2,
          n0_.active AS active_3,
          n0_.public AS public_4,
          n0_.slug AS slug_5,
          n0_.created AS created_6,
          n0_.updated AS updated_7
        FROM
          news n0_
        WHERE
          n0_.active IN (?)
          AND n0_.public IN (?)
        ORDER BY
          n0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.active AS active_3, n0_.public AS public_4, n0_.slug AS slug_5, n0_.created AS created_6, n0_.updated AS updated_7 FROM news n0_ WHERE n0_.active IN (1) AND n0_.public IN (1) ORDER BY n0_.id DESC) dctrn_result) dctrn_table;

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.active AS active_3, n0_.public AS public_4, n0_.slug AS slug_5, n0_.created AS created_6, n0_.updated AS updated_7 FROM news n0_ WHERE n0_.active IN (?) AND n0_.public IN (?)) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 3

[
  true
  true
]

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.name AS name_1,
          n0_.description AS description_2,
          n0_.active AS active_3,
          n0_.public AS public_4,
          n0_.slug AS slug_5,
          n0_.created AS created_6,
          n0_.updated AS updated_7
        FROM
          news n0_
        WHERE
          n0_.active IN (?)
          AND n0_.public IN (?)
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  3

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.active AS active_3, n0_.public AS public_4, n0_.slug AS slug_5, n0_.created AS created_6, n0_.updated AS updated_7 FROM news n0_ WHERE n0_.active IN (1) AND n0_.public IN (1)) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 3;

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.active AS active_3, n0_.public AS public_4, n0_.slug AS slug_5, n0_.created AS created_6, n0_.updated AS updated_7, n0_.image_id AS image_id_8, n0_.creator_id AS creator_id_9, n0_.news_category_id AS news_category_id_10 FROM news n0_ WHERE n0_.active IN (?) AND n0_.public IN (?) AND n0_.id IN (?, ?, ?) ORDER BY n0_.id DESC

[
  true
  true
  1658
  1586
  1569
]

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.description AS description_2,
  n0_.active AS active_3,
  n0_.public AS public_4,
  n0_.slug AS slug_5,
  n0_.created AS created_6,
  n0_.updated AS updated_7,
  n0_.image_id AS image_id_8,
  n0_.creator_id AS creator_id_9,
  n0_.news_category_id AS news_category_id_10
FROM
  news n0_
WHERE
  n0_.active IN (?)
  AND n0_.public IN (?)
  AND n0_.id IN (?, ?, ?)
ORDER BY
  n0_.id DESC

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.description AS description_2, n0_.active AS active_3, n0_.public AS public_4, n0_.slug AS slug_5, n0_.created AS created_6, n0_.updated AS updated_7, n0_.image_id AS image_id_8, n0_.creator_id AS creator_id_9, n0_.news_category_id AS news_category_id_10 FROM news n0_ WHERE n0_.active IN (1) AND n0_.public IN (1) AND n0_.id IN (1658, 1586, 1569) ORDER BY n0_.id DESC;

SELECT t0.id AS id_1, t0.name AS name_2 FROM news_category t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  news_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM news_category t0 WHERE t0.id = 2;

SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.eloa_url AS eloa_url_4, t0.eloa_order AS eloa_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agency_id AS agency_id_8, t0.vehicle_id AS vehicle_id_9 FROM image t0 WHERE t0.id = ?

[
  4183411
]

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.position AS position_3,
  t0.eloa_url AS eloa_url_4,
  t0.eloa_order AS eloa_order_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.agency_id AS agency_id_8,
  t0.vehicle_id AS vehicle_id_9
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.eloa_url AS eloa_url_4, t0.eloa_order AS eloa_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agency_id AS agency_id_8, t0.vehicle_id AS vehicle_id_9 FROM image t0 WHERE t0.id = 4183411;

SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 INNER JOIN news_country ON t0.id = news_country.country_id WHERE news_country.news_id = ?

[
  1658
]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.tax AS tax_3,
  t0.reference_eloa AS reference_eloa_4,
  t0.label AS label_5
FROM
  country t0
  INNER JOIN news_country ON t0.id = news_country.country_id
WHERE
  news_country.news_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 INNER JOIN news_country ON t0.id = news_country.country_id WHERE news_country.news_id = 1658;

SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.eloa_url AS eloa_url_4, t0.eloa_order AS eloa_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agency_id AS agency_id_8, t0.vehicle_id AS vehicle_id_9 FROM image t0 WHERE t0.id = ?

[
  3820467
]

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.position AS position_3,
  t0.eloa_url AS eloa_url_4,
  t0.eloa_order AS eloa_order_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.agency_id AS agency_id_8,
  t0.vehicle_id AS vehicle_id_9
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.eloa_url AS eloa_url_4, t0.eloa_order AS eloa_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agency_id AS agency_id_8, t0.vehicle_id AS vehicle_id_9 FROM image t0 WHERE t0.id = 3820467;

SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 INNER JOIN news_country ON t0.id = news_country.country_id WHERE news_country.news_id = ?

[
  1586
]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.tax AS tax_3,
  t0.reference_eloa AS reference_eloa_4,
  t0.label AS label_5
FROM
  country t0
  INNER JOIN news_country ON t0.id = news_country.country_id
WHERE
  news_country.news_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 INNER JOIN news_country ON t0.id = news_country.country_id WHERE news_country.news_id = 1586;

SELECT t0.id AS id_1, t0.name AS name_2 FROM news_category t0 WHERE t0.id = ?

[
  21
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  news_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM news_category t0 WHERE t0.id = 21;

SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.eloa_url AS eloa_url_4, t0.eloa_order AS eloa_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agency_id AS agency_id_8, t0.vehicle_id AS vehicle_id_9 FROM image t0 WHERE t0.id = ?

[
  3755850
]

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.position AS position_3,
  t0.eloa_url AS eloa_url_4,
  t0.eloa_order AS eloa_order_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.agency_id AS agency_id_8,
  t0.vehicle_id AS vehicle_id_9
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.eloa_url AS eloa_url_4, t0.eloa_order AS eloa_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agency_id AS agency_id_8, t0.vehicle_id AS vehicle_id_9 FROM image t0 WHERE t0.id = 3755850;

SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 INNER JOIN news_country ON t0.id = news_country.country_id WHERE news_country.news_id = ?

[
  1569
]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.tax AS tax_3,
  t0.reference_eloa AS reference_eloa_4,
  t0.label AS label_5
FROM
  country t0
  INNER JOIN news_country ON t0.id = news_country.country_id
WHERE
  news_country.news_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 INNER JOIN news_country ON t0.id = news_country.country_id WHERE news_country.news_id = 1569;