Symfony Profiler

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

Query Metrics

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.quartier AS quartier_2, p0_.commune AS commune_3, p0_.adresse AS adresse_4, p0_.telephone AS telephone_5, p0_.latitude AS latitude_6, p0_.longitude AS longitude_7, p0_.created_at AS created_at_8, p0_.deleted_at AS deleted_at_9, p0_.status AS status_10, p0_.is_mutuelle AS is_mutuelle_11, p0_.code AS code_12, p0_.id_groupe_id AS id_groupe_id_13, p0_.id_ville_id AS id_ville_id_14 FROM pharmacie p0_ WHERE p0_.status = 1 AND p0_.id_ville_id = ? AND (p0_.id_groupe_id IN (SELECT s1_.id_groupe_id AS sclr_15 FROM semaine s1_ WHERE (? BETWEEN s1_.date_debut AND s1_.date_fin AND s1_.id_ville_id = ?) AND s1_.status = 1)) ORDER BY p0_.nom ASC LIMIT 50

[
  3
  "2026-03-27 17:07:58"
  3
]

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.quartier AS quartier_2,
  p0_.commune AS commune_3,
  p0_.adresse AS adresse_4,
  p0_.telephone AS telephone_5,
  p0_.latitude AS latitude_6,
  p0_.longitude AS longitude_7,
  p0_.created_at AS created_at_8,
  p0_.deleted_at AS deleted_at_9,
  p0_.status AS status_10,
  p0_.is_mutuelle AS is_mutuelle_11,
  p0_.code AS code_12,
  p0_.id_groupe_id AS id_groupe_id_13,
  p0_.id_ville_id AS id_ville_id_14
FROM
  pharmacie p0_
WHERE
  p0_.status = 1
  AND p0_.id_ville_id = ?
  AND (
    p0_.id_groupe_id IN (
      SELECT
        s1_.id_groupe_id AS sclr_15
      FROM
        semaine s1_
      WHERE
        (
          ? BETWEEN s1_.date_debut
          AND s1_.date_fin
          AND s1_.id_ville_id = ?
        )
        AND s1_.status = 1
    )
  )
ORDER BY
  p0_.nom ASC
LIMIT
  50

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.quartier AS quartier_2, p0_.commune AS commune_3, p0_.adresse AS adresse_4, p0_.telephone AS telephone_5, p0_.latitude AS latitude_6, p0_.longitude AS longitude_7, p0_.created_at AS created_at_8, p0_.deleted_at AS deleted_at_9, p0_.status AS status_10, p0_.is_mutuelle AS is_mutuelle_11, p0_.code AS code_12, p0_.id_groupe_id AS id_groupe_id_13, p0_.id_ville_id AS id_ville_id_14 FROM pharmacie p0_ WHERE p0_.status = 1 AND p0_.id_ville_id = 3 AND (p0_.id_groupe_id IN (SELECT s1_.id_groupe_id AS sclr_15 FROM semaine s1_ WHERE ('2026-03-27 17:07:58' BETWEEN s1_.date_debut AND s1_.date_fin AND s1_.id_ville_id = 3) AND s1_.status = 1)) ORDER BY p0_.nom ASC LIMIT 50;

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.password AS password_6, t0.roles AS roles_7, t0.created_at AS created_at_8, t0.deteled_at AS deteled_at_9, t0.status AS status_10, t0.fcm_token AS fcm_token_11 FROM client t0 WHERE t0.phone = ? LIMIT 1

[
  "22791996354"
]

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.password AS password_6,
  t0.roles AS roles_7,
  t0.created_at AS created_at_8,
  t0.deteled_at AS deteled_at_9,
  t0.status AS status_10,
  t0.fcm_token AS fcm_token_11
FROM
  client t0
WHERE
  t0.phone = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.password AS password_6, t0.roles AS roles_7, t0.created_at AS created_at_8, t0.deteled_at AS deteled_at_9, t0.status AS status_10, t0.fcm_token AS fcm_token_11 FROM client t0 WHERE t0.phone = '22791996354' LIMIT 1;