Symfony Profiler

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.password_default AS password_default_7,
  t0.created_at AS created_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.one_connexion AS one_connexion_10,
  t0.roles AS roles_11,
  t0.fcm_token AS fcm_token_12,
  t0.id_statut_id AS id_statut_id_13,
  t0.id_restaurant_id AS id_restaurant_id_14,
  t0.id_pharmacie_id AS id_pharmacie_id_15
FROM
  `user` t0
WHERE
  t0.email = ?
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.password_default AS password_default_7, t0.created_at AS created_at_8, t0.deleted_at AS deleted_at_9, t0.one_connexion AS one_connexion_10, t0.roles AS roles_11, t0.fcm_token AS fcm_token_12, t0.id_statut_id AS id_statut_id_13, t0.id_restaurant_id AS id_restaurant_id_14, t0.id_pharmacie_id AS id_pharmacie_id_15 FROM `user` t0 WHERE t0.email = 'citecaisse@gmail.com' 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.password_default AS password_default_7,
  t0.created_at AS created_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.one_connexion AS one_connexion_10,
  t0.roles AS roles_11,
  t0.fcm_token AS fcm_token_12,
  t0.id_statut_id AS id_statut_id_13,
  t0.id_restaurant_id AS id_restaurant_id_14,
  t0.id_pharmacie_id AS id_pharmacie_id_15
FROM
  `user` t0
WHERE
  t0.email = ?
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.password_default AS password_default_7, t0.created_at AS created_at_8, t0.deleted_at AS deleted_at_9, t0.one_connexion AS one_connexion_10, t0.roles AS roles_11, t0.fcm_token AS fcm_token_12, t0.id_statut_id AS id_statut_id_13, t0.id_restaurant_id AS id_restaurant_id_14, t0.id_pharmacie_id AS id_pharmacie_id_15 FROM `user` t0 WHERE t0.email = 'citecaisse@gmail.com' LIMIT 1;

SELECT
  l0_.id AS id_0,
  l0_.nom_produit AS nom_produit_1,
  l0_.qte AS qte_2,
  l0_.prix AS prix_3,
  l0_.ordonance AS ordonance_4,
  l0_.ordre AS ordre_5,
  l0_.created_at AS created_at_6,
  l0_.deleted_at AS deleted_at_7,
  l0_.status AS status_8,
  l0_.choix AS choix_9,
  l0_.id_demande_id AS id_demande_id_10
FROM
  ligne_demande l0_
WHERE
  l0_.status = 1
  AND (
    l0_.created_at BETWEEN ?
    AND ?
  )
  AND (
    l0_.id NOT IN (
      SELECT
        r1_.id_demande_id AS sclr_11
      FROM
        reponse_demande r1_
      WHERE
        r1_.id_pharmacie_id = ?
        AND r1_.status = 1
    )
  )
ORDER BY
  l0_.id DESC

SELECT l0_.id AS id_0, l0_.nom_produit AS nom_produit_1, l0_.qte AS qte_2, l0_.prix AS prix_3, l0_.ordonance AS ordonance_4, l0_.ordre AS ordre_5, l0_.created_at AS created_at_6, l0_.deleted_at AS deleted_at_7, l0_.status AS status_8, l0_.choix AS choix_9, l0_.id_demande_id AS id_demande_id_10 FROM ligne_demande l0_ WHERE l0_.status = 1 AND (l0_.created_at BETWEEN '2026-08-12 16:07:20' AND '2026-08-13 16:07:20') AND (l0_.id NOT IN (SELECT r1_.id_demande_id AS sclr_11 FROM reponse_demande r1_ WHERE r1_.id_pharmacie_id = 13 AND r1_.status = 1)) ORDER BY l0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.prix AS prix_2,
  t0.commentaire AS commentaire_3,
  t0.disponible AS disponible_4,
  t0.created_at AS created_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.status AS status_7,
  t0.id_pharmacie_id AS id_pharmacie_id_8,
  t0.id_user_id AS id_user_id_9,
  t0.id_demande_id AS id_demande_id_10
FROM
  reponse_demande t0
WHERE
  t0.id_demande_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.commentaire AS commentaire_3, t0.disponible AS disponible_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.status AS status_7, t0.id_pharmacie_id AS id_pharmacie_id_8, t0.id_user_id AS id_user_id_9, t0.id_demande_id AS id_demande_id_10 FROM reponse_demande t0 WHERE t0.id_demande_id = 789 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.adresse AS adresse_3,
  t0.longitude AS longitude_4,
  t0.latitude AS latitude_5,
  t0.frais_livraison AS frais_livraison_6,
  t0.created_at AS created_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.status AS status_9,
  t0.ordre AS ordre_10,
  t0.ville AS ville_11,
  t0.livraison AS livraison_12,
  t0.id_status_id AS id_status_id_13,
  t0.id_client_id AS id_client_id_14
FROM
  demande_produit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.adresse AS adresse_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.frais_livraison AS frais_livraison_6, t0.created_at AS created_at_7, t0.deleted_at AS deleted_at_8, t0.status AS status_9, t0.ordre AS ordre_10, t0.ville AS ville_11, t0.livraison AS livraison_12, t0.id_status_id AS id_status_id_13, t0.id_client_id AS id_client_id_14 FROM demande_produit t0 WHERE t0.id = 726;

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

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.id = 1348;

SELECT
  t0.id AS id_1,
  t0.prix AS prix_2,
  t0.commentaire AS commentaire_3,
  t0.disponible AS disponible_4,
  t0.created_at AS created_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.status AS status_7,
  t0.id_pharmacie_id AS id_pharmacie_id_8,
  t0.id_user_id AS id_user_id_9,
  t0.id_demande_id AS id_demande_id_10
FROM
  reponse_demande t0
WHERE
  t0.id_demande_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.commentaire AS commentaire_3, t0.disponible AS disponible_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.status AS status_7, t0.id_pharmacie_id AS id_pharmacie_id_8, t0.id_user_id AS id_user_id_9, t0.id_demande_id AS id_demande_id_10 FROM reponse_demande t0 WHERE t0.id_demande_id = 788 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.adresse AS adresse_3,
  t0.longitude AS longitude_4,
  t0.latitude AS latitude_5,
  t0.frais_livraison AS frais_livraison_6,
  t0.created_at AS created_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.status AS status_9,
  t0.ordre AS ordre_10,
  t0.ville AS ville_11,
  t0.livraison AS livraison_12,
  t0.id_status_id AS id_status_id_13,
  t0.id_client_id AS id_client_id_14
FROM
  demande_produit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.adresse AS adresse_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.frais_livraison AS frais_livraison_6, t0.created_at AS created_at_7, t0.deleted_at AS deleted_at_8, t0.status AS status_9, t0.ordre AS ordre_10, t0.ville AS ville_11, t0.livraison AS livraison_12, t0.id_status_id AS id_status_id_13, t0.id_client_id AS id_client_id_14 FROM demande_produit t0 WHERE t0.id = 725;

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

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.id = 1346;

SELECT
  t0.id AS id_1,
  t0.prix AS prix_2,
  t0.commentaire AS commentaire_3,
  t0.disponible AS disponible_4,
  t0.created_at AS created_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.status AS status_7,
  t0.id_pharmacie_id AS id_pharmacie_id_8,
  t0.id_user_id AS id_user_id_9,
  t0.id_demande_id AS id_demande_id_10
FROM
  reponse_demande t0
WHERE
  t0.id_demande_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.commentaire AS commentaire_3, t0.disponible AS disponible_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.status AS status_7, t0.id_pharmacie_id AS id_pharmacie_id_8, t0.id_user_id AS id_user_id_9, t0.id_demande_id AS id_demande_id_10 FROM reponse_demande t0 WHERE t0.id_demande_id = 787 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.adresse AS adresse_3,
  t0.longitude AS longitude_4,
  t0.latitude AS latitude_5,
  t0.frais_livraison AS frais_livraison_6,
  t0.created_at AS created_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.status AS status_9,
  t0.ordre AS ordre_10,
  t0.ville AS ville_11,
  t0.livraison AS livraison_12,
  t0.id_status_id AS id_status_id_13,
  t0.id_client_id AS id_client_id_14
FROM
  demande_produit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.adresse AS adresse_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.frais_livraison AS frais_livraison_6, t0.created_at AS created_at_7, t0.deleted_at AS deleted_at_8, t0.status AS status_9, t0.ordre AS ordre_10, t0.ville AS ville_11, t0.livraison AS livraison_12, t0.id_status_id AS id_status_id_13, t0.id_client_id AS id_client_id_14 FROM demande_produit t0 WHERE t0.id = 724;

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

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.id = 1344;

SELECT
  t0.id AS id_1,
  t0.prix AS prix_2,
  t0.commentaire AS commentaire_3,
  t0.disponible AS disponible_4,
  t0.created_at AS created_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.status AS status_7,
  t0.id_pharmacie_id AS id_pharmacie_id_8,
  t0.id_user_id AS id_user_id_9,
  t0.id_demande_id AS id_demande_id_10
FROM
  reponse_demande t0
WHERE
  t0.id_demande_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.prix AS prix_2, t0.commentaire AS commentaire_3, t0.disponible AS disponible_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.status AS status_7, t0.id_pharmacie_id AS id_pharmacie_id_8, t0.id_user_id AS id_user_id_9, t0.id_demande_id AS id_demande_id_10 FROM reponse_demande t0 WHERE t0.id_demande_id = 786 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.adresse AS adresse_3,
  t0.longitude AS longitude_4,
  t0.latitude AS latitude_5,
  t0.frais_livraison AS frais_livraison_6,
  t0.created_at AS created_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.status AS status_9,
  t0.ordre AS ordre_10,
  t0.ville AS ville_11,
  t0.livraison AS livraison_12,
  t0.id_status_id AS id_status_id_13,
  t0.id_client_id AS id_client_id_14
FROM
  demande_produit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.adresse AS adresse_3, t0.longitude AS longitude_4, t0.latitude AS latitude_5, t0.frais_livraison AS frais_livraison_6, t0.created_at AS created_at_7, t0.deleted_at AS deleted_at_8, t0.status AS status_9, t0.ordre AS ordre_10, t0.ville AS ville_11, t0.livraison AS livraison_12, t0.id_status_id AS id_status_id_13, t0.id_client_id AS id_client_id_14 FROM demande_produit t0 WHERE t0.id = 723;

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

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.id = 1343;