Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 15
• Events
• Routing
• Cache
• Translation 3
• Security
• Twig
• Doctrine
• Emails
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_enable AS is_enable_4, t0.is_default AS is_default_5 FROM language t0 WHERE t0.code = ? LIMIT 1

[
  "fr"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_enable AS is_enable_4,
  t0.is_default AS is_default_5
FROM
  language t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_enable AS is_enable_4, t0.is_default AS is_default_5 FROM language t0 WHERE t0.code = 'fr' LIMIT 1;

SELECT s0_.id AS id_0, s0_.is_public AS is_public_1, s0_.is_connect AS is_connect_2, s0_.is_enable AS is_enable_3, s0_.deleted_at AS deleted_at_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM subject s0_ LEFT JOIN subject_lang s1_ ON s0_.id = s1_.subject_id AND (s1_.language_id = ?) WHERE s0_.deleted_at IS NULL AND s0_.is_enable = ? AND s0_.is_public = ? ORDER BY s0_.id DESC

[
  3
  1
  1
]

SELECT
  s0_.id AS id_0,
  s0_.is_public AS is_public_1,
  s0_.is_connect AS is_connect_2,
  s0_.is_enable AS is_enable_3,
  s0_.deleted_at AS deleted_at_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6
FROM
  subject s0_
  LEFT JOIN subject_lang s1_ ON s0_.id = s1_.subject_id
  AND (s1_.language_id = ?)
WHERE
  s0_.deleted_at IS NULL
  AND s0_.is_enable = ?
  AND s0_.is_public = ?
ORDER BY
  s0_.id DESC

SELECT s0_.id AS id_0, s0_.is_public AS is_public_1, s0_.is_connect AS is_connect_2, s0_.is_enable AS is_enable_3, s0_.deleted_at AS deleted_at_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM subject s0_ LEFT JOIN subject_lang s1_ ON s0_.id = s1_.subject_id AND (s1_.language_id = 3) WHERE s0_.deleted_at IS NULL AND s0_.is_enable = 1 AND s0_.is_public = 1 ORDER BY s0_.id DESC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.language_id AS language_id_3, t0.subject_id AS subject_id_4 FROM subject_lang t0 WHERE t0.language_id = ? AND t0.subject_id = ? LIMIT 1

[
  3
  4
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.language_id AS language_id_3,
  t0.subject_id AS subject_id_4
FROM
  subject_lang t0
WHERE
  t0.language_id = ?
  AND t0.subject_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.language_id AS language_id_3, t0.subject_id AS subject_id_4 FROM subject_lang t0 WHERE t0.language_id = 3 AND t0.subject_id = 4 LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.language_id AS language_id_3, t0.subject_id AS subject_id_4 FROM subject_lang t0 WHERE t0.language_id = ? AND t0.subject_id = ? LIMIT 1

[
  3
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.language_id AS language_id_3,
  t0.subject_id AS subject_id_4
FROM
  subject_lang t0
WHERE
  t0.language_id = ?
  AND t0.subject_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.language_id AS language_id_3, t0.subject_id AS subject_id_4 FROM subject_lang t0 WHERE t0.language_id = 3 AND t0.subject_id = 1 LIMIT 1;

SELECT t0.id AS id_1, t0.title AS title_2, t0.route AS route_3, t0.parameter AS parameter_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.no_index AS no_index_7, t0.language_id AS language_id_8 FROM seo t0 WHERE t0.language_id = ? AND t0.parameter IS NULL AND t0.route = ? LIMIT 1

[
  3
  "app_front_contact"
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.route AS route_3,
  t0.parameter AS parameter_4,
  t0.meta_title AS meta_title_5,
  t0.meta_description AS meta_description_6,
  t0.no_index AS no_index_7,
  t0.language_id AS language_id_8
FROM
  seo t0
WHERE
  t0.language_id = ?
  AND t0.parameter IS NULL
  AND t0.route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.route AS route_3, t0.parameter AS parameter_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.no_index AS no_index_7, t0.language_id AS language_id_8 FROM seo t0 WHERE t0.language_id = 3 AND t0.parameter IS NULL AND t0.route = 'app_front_contact' LIMIT 1;

SELECT b0_.id AS id_0, b1_.name AS name_1, b1_.slug AS slug_2, b2_.id AS id_3, b3_.name AS name_4 FROM brand b0_ LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id AND (b1_.language_id = ?) LEFT JOIN brand_type b2_ ON b0_.brand_type_id = b2_.id LEFT JOIN brand_type_lang b3_ ON b2_.id = b3_.brand_type_id AND (b3_.language_id = ?) WHERE b0_.deleted_at IS NULL AND b0_.is_enable = ? AND b0_.publication_at <= ? AND b0_.is_public = 1 ORDER BY b2_.id ASC, b0_.position ASC, b1_.name ASC

[
  3
  3
  1
  "2024-11-25 17:29:07"
]

SELECT
  b0_.id AS id_0,
  b1_.name AS name_1,
  b1_.slug AS slug_2,
  b2_.id AS id_3,
  b3_.name AS name_4
FROM
  brand b0_
  LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id
  AND (b1_.language_id = ?)
  LEFT JOIN brand_type b2_ ON b0_.brand_type_id = b2_.id
  LEFT JOIN brand_type_lang b3_ ON b2_.id = b3_.brand_type_id
  AND (b3_.language_id = ?)
WHERE
  b0_.deleted_at IS NULL
  AND b0_.is_enable = ?
  AND b0_.publication_at <= ?
  AND b0_.is_public = 1
ORDER BY
  b2_.id ASC,
  b0_.position ASC,
  b1_.name ASC

SELECT b0_.id AS id_0, b1_.name AS name_1, b1_.slug AS slug_2, b2_.id AS id_3, b3_.name AS name_4 FROM brand b0_ LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id AND (b1_.language_id = 3) LEFT JOIN brand_type b2_ ON b0_.brand_type_id = b2_.id LEFT JOIN brand_type_lang b3_ ON b2_.id = b3_.brand_type_id AND (b3_.language_id = 3) WHERE b0_.deleted_at IS NULL AND b0_.is_enable = 1 AND b0_.publication_at <= '2024-11-25 17:29:07' AND b0_.is_public = 1 ORDER BY b2_.id ASC, b0_.position ASC, b1_.name ASC;

SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.is_enable AS is_enable_2, l1_.id AS id_3, m0_.title AS title_4, p2_.slug AS slug_5, m0_.page_statique AS page_statique_6, m0_.type AS type_7, c3_.slug AS slug_8, p4_.id AS id_9 FROM menu m0_ LEFT JOIN page p4_ ON m0_.page_id = p4_.id LEFT JOIN page_lang p2_ ON p4_.id = p2_.page_id AND (p2_.language_id = ?) LEFT JOIN category c5_ ON m0_.category_id = c5_.id LEFT JOIN category_lang c3_ ON c5_.id = c3_.category_id AND (c3_.language_id = ?) LEFT JOIN language l1_ ON m0_.language_id = l1_.id WHERE m0_.deleted_at IS NULL AND l1_.id = ? AND m0_.is_enable = ? ORDER BY m0_.position ASC

[
  3
  3
  3
  "1"
]

SELECT
  m0_.id AS id_0,
  m0_.position AS position_1,
  m0_.is_enable AS is_enable_2,
  l1_.id AS id_3,
  m0_.title AS title_4,
  p2_.slug AS slug_5,
  m0_.page_statique AS page_statique_6,
  m0_.type AS type_7,
  c3_.slug AS slug_8,
  p4_.id AS id_9
FROM
  menu m0_
  LEFT JOIN page p4_ ON m0_.page_id = p4_.id
  LEFT JOIN page_lang p2_ ON p4_.id = p2_.page_id
  AND (p2_.language_id = ?)
  LEFT JOIN category c5_ ON m0_.category_id = c5_.id
  LEFT JOIN category_lang c3_ ON c5_.id = c3_.category_id
  AND (c3_.language_id = ?)
  LEFT JOIN language l1_ ON m0_.language_id = l1_.id
WHERE
  m0_.deleted_at IS NULL
  AND l1_.id = ?
  AND m0_.is_enable = ?
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.is_enable AS is_enable_2, l1_.id AS id_3, m0_.title AS title_4, p2_.slug AS slug_5, m0_.page_statique AS page_statique_6, m0_.type AS type_7, c3_.slug AS slug_8, p4_.id AS id_9 FROM menu m0_ LEFT JOIN page p4_ ON m0_.page_id = p4_.id LEFT JOIN page_lang p2_ ON p4_.id = p2_.page_id AND (p2_.language_id = 3) LEFT JOIN category c5_ ON m0_.category_id = c5_.id LEFT JOIN category_lang c3_ ON c5_.id = c3_.category_id AND (c3_.language_id = 3) LEFT JOIN language l1_ ON m0_.language_id = l1_.id WHERE m0_.deleted_at IS NULL AND l1_.id = 3 AND m0_.is_enable = '1' ORDER BY m0_.position ASC;