Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 1
• Debug
• Emails
• Configuration

Query Metrics

SELECT p0_.date AS date_0, p0_.email AS email_1, p0_.phone AS phone_2, p0_.site AS site_3, p0_.updated AS updated_4, p0_.center AS center_5, p0_.close AS close_6, p0_.created AS created_7, p0_.description AS description_8, p0_.id AS id_9, p0_.name AS name_10, p0_.slug AS slug_11, p0_.title AS title_12, p0_.visible AS visible_13, p0_.address_id AS address_id_14, p0_.pdf_id AS pdf_id_15, p0_.picture_id AS picture_id_16 FROM partner p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id LEFT JOIN partner_category p3_ ON p0_.id = p3_.partner_id LEFT JOIN category c2_ ON c2_.id = p3_.category_id LEFT JOIN view v4_ ON p0_.id = v4_.partner_id LEFT JOIN `like` l5_ ON p0_.id = l5_.partner_id INNER JOIN schedule s6_ ON p0_.id = s6_.partner_id WHERE p0_.visible = ? AND c2_.slug = ? AND s6_.day = ? AND s6_.open <= ? AND ? <= s6_.close GROUP BY p0_.id ORDER BY COUNT(l5_.id) DESC, COUNT(v4_.id) DESC

[
  1
  "immobilier"
  "Saturday"
  "2026-04-18 09:50:18"
  "2026-04-18 09:50:18"
]

SELECT
  p0_.date AS date_0,
  p0_.email AS email_1,
  p0_.phone AS phone_2,
  p0_.site AS site_3,
  p0_.updated AS updated_4,
  p0_.center AS center_5,
  p0_.close AS close_6,
  p0_.created AS created_7,
  p0_.description AS description_8,
  p0_.id AS id_9,
  p0_.name AS name_10,
  p0_.slug AS slug_11,
  p0_.title AS title_12,
  p0_.visible AS visible_13,
  p0_.address_id AS address_id_14,
  p0_.pdf_id AS pdf_id_15,
  p0_.picture_id AS picture_id_16
FROM
  partner p0_
  LEFT JOIN address a1_ ON p0_.address_id = a1_.id
  LEFT JOIN partner_category p3_ ON p0_.id = p3_.partner_id
  LEFT JOIN category c2_ ON c2_.id = p3_.category_id
  LEFT JOIN view v4_ ON p0_.id = v4_.partner_id
  LEFT JOIN `like` l5_ ON p0_.id = l5_.partner_id
  INNER JOIN schedule s6_ ON p0_.id = s6_.partner_id
WHERE
  p0_.visible = ?
  AND c2_.slug = ?
  AND s6_.day = ?
  AND s6_.open <= ?
  AND ? <= s6_.close
GROUP BY
  p0_.id
ORDER BY
  COUNT(l5_.id) DESC,
  COUNT(v4_.id) DESC

SELECT p0_.date AS date_0, p0_.email AS email_1, p0_.phone AS phone_2, p0_.site AS site_3, p0_.updated AS updated_4, p0_.center AS center_5, p0_.close AS close_6, p0_.created AS created_7, p0_.description AS description_8, p0_.id AS id_9, p0_.name AS name_10, p0_.slug AS slug_11, p0_.title AS title_12, p0_.visible AS visible_13, p0_.address_id AS address_id_14, p0_.pdf_id AS pdf_id_15, p0_.picture_id AS picture_id_16 FROM partner p0_ LEFT JOIN address a1_ ON p0_.address_id = a1_.id LEFT JOIN partner_category p3_ ON p0_.id = p3_.partner_id LEFT JOIN category c2_ ON c2_.id = p3_.category_id LEFT JOIN view v4_ ON p0_.id = v4_.partner_id LEFT JOIN `like` l5_ ON p0_.id = l5_.partner_id INNER JOIN schedule s6_ ON p0_.id = s6_.partner_id WHERE p0_.visible = 1 AND c2_.slug = 'immobilier' AND s6_.day = 'Saturday' AND s6_.open <= '2026-04-18 09:50:18' AND '2026-04-18 09:50:18' <= s6_.close GROUP BY p0_.id ORDER BY COUNT(l5_.id) DESC, COUNT(v4_.id) DESC;

SELECT c0_.updated AS updated_0, c0_.created AS created_1, c0_.entities AS entities_2, c0_.id AS id_3, c0_.major AS major_4, c0_.slug AS slug_5, c0_.title AS title_6 FROM category c0_ WHERE c0_.entities LIKE ? ORDER BY c0_.title ASC

[
  "%partner%"
]

SELECT
  c0_.updated AS updated_0,
  c0_.created AS created_1,
  c0_.entities AS entities_2,
  c0_.id AS id_3,
  c0_.major AS major_4,
  c0_.slug AS slug_5,
  c0_.title AS title_6
FROM
  category c0_
WHERE
  c0_.entities LIKE ?
ORDER BY
  c0_.title ASC

SELECT c0_.updated AS updated_0, c0_.created AS created_1, c0_.entities AS entities_2, c0_.id AS id_3, c0_.major AS major_4, c0_.slug AS slug_5, c0_.title AS title_6 FROM category c0_ WHERE c0_.entities LIKE '%partner%' ORDER BY c0_.title ASC;

SELECT v0_.ip AS ip_0, v0_.created AS created_1, v0_.env AS env_2, v0_.id AS id_3, v0_.preview AS preview_4, v0_.article_id AS article_id_5, v0_.event_id AS event_id_6, v0_.partner_id AS partner_id_7, v0_.talent_id AS talent_id_8, v0_.user_id AS user_id_9 FROM view v0_ WHERE v0_.created >= ? AND v0_.ip = ? AND v0_.preview = ? AND v0_.partner_id = ?

[
  "2026-04-17 09:50:18"
  "216.73.217.139"
  1
  18
]

SELECT
  v0_.ip AS ip_0,
  v0_.created AS created_1,
  v0_.env AS env_2,
  v0_.id AS id_3,
  v0_.preview AS preview_4,
  v0_.article_id AS article_id_5,
  v0_.event_id AS event_id_6,
  v0_.partner_id AS partner_id_7,
  v0_.talent_id AS talent_id_8,
  v0_.user_id AS user_id_9
FROM
  view v0_
WHERE
  v0_.created >= ?
  AND v0_.ip = ?
  AND v0_.preview = ?
  AND v0_.partner_id = ?

SELECT v0_.ip AS ip_0, v0_.created AS created_1, v0_.env AS env_2, v0_.id AS id_3, v0_.preview AS preview_4, v0_.article_id AS article_id_5, v0_.event_id AS event_id_6, v0_.partner_id AS partner_id_7, v0_.talent_id AS talent_id_8, v0_.user_id AS user_id_9 FROM view v0_ WHERE v0_.created >= '2026-04-17 09:50:18' AND v0_.ip = '216.73.217.139' AND v0_.preview = 1 AND v0_.partner_id = 18;

SELECT t0.position AS position_1, t0.updated AS updated_2, t0.created AS created_3, t0.id AS id_4, t0.name AS name_5, t0.article_id AS article_id_6, t0.partner_id AS partner_id_7 FROM file t0 WHERE t0.id = ?

[
  249
]

SELECT
  t0.position AS position_1,
  t0.updated AS updated_2,
  t0.created AS created_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.article_id AS article_id_6,
  t0.partner_id AS partner_id_7
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.position AS position_1, t0.updated AS updated_2, t0.created AS created_3, t0.id AS id_4, t0.name AS name_5, t0.article_id AS article_id_6, t0.partner_id AS partner_id_7 FROM file t0 WHERE t0.id = 249;

SELECT t0.break AS break_1, t0.resume AS resume_2, t0.updated AS updated_3, t0.close AS close_4, t0.created AS created_5, t0.day AS day_6, t0.id AS id_7, t0.open AS open_8, t0.partner_id AS partner_id_9 FROM schedule t0 WHERE t0.partner_id = ?

[
  18
]

SELECT
  t0.break AS break_1,
  t0.resume AS resume_2,
  t0.updated AS updated_3,
  t0.close AS close_4,
  t0.created AS created_5,
  t0.day AS day_6,
  t0.id AS id_7,
  t0.open AS open_8,
  t0.partner_id AS partner_id_9
FROM
  schedule t0
WHERE
  t0.partner_id = ?

SELECT t0.break AS break_1, t0.resume AS resume_2, t0.updated AS updated_3, t0.close AS close_4, t0.created AS created_5, t0.day AS day_6, t0.id AS id_7, t0.open AS open_8, t0.partner_id AS partner_id_9 FROM schedule t0 WHERE t0.partner_id = 18;