Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.date_debut AS date_debut_2,
  t0.date_fin AS date_fin_3,
  t0.type AS type_4,
  t0.notes AS notes_5,
  t0.active AS active_6,
  t0.publiee AS publiee_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.pharmacie_id AS pharmacie_id_10
FROM
  periode_garde t0
WHERE
  t0.pharmacie_id = ?
ORDER BY
  t0.date_debut DESC

SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.type AS type_4, t0.notes AS notes_5, t0.active AS active_6, t0.publiee AS publiee_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.pharmacie_id AS pharmacie_id_10 FROM periode_garde t0 WHERE t0.pharmacie_id = 34 ORDER BY t0.date_debut DESC;

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.numero_agrement AS numero_agrement_2,
  p0_.description AS description_3,
  p0_.quartier AS quartier_4,
  p0_.adresse AS adresse_5,
  p0_.latitude AS latitude_6,
  p0_.longitude AS longitude_7,
  p0_.telephone AS telephone_8,
  p0_.telephone_secondaire AS telephone_secondaire_9,
  p0_.email AS email_10,
  p0_.site_web AS site_web_11,
  p0_.statut AS statut_12,
  p0_.de_garde AS de_garde_13,
  p0_.active AS active_14,
  p0_.verifiee AS verifiee_15,
  p0_.mise_en_avant AS mise_en_avant_16,
  p0_.note_moyenne AS note_moyenne_17,
  p0_.nombre_avis AS nombre_avis_18,
  p0_.accepte_commande_en_ligne AS accepte_commande_en_ligne_19,
  p0_.accepte_ordonnance_numerique AS accepte_ordonnance_numerique_20,
  p0_.propose_livraison AS propose_livraison_21,
  p0_.rayon_livraison_km AS rayon_livraison_km_22,
  p0_.created_at AS created_at_23,
  p0_.updated_at AS updated_at_24,
  p0_.slug AS slug_25,
  i1_.id AS id_26,
  i1_.code AS code_27,
  i1_.nom_francais AS nom_francais_28,
  i1_.nom_traditionnel AS nom_traditionnel_29,
  i1_.capitale AS capitale_30,
  i1_.slogan AS slogan_31,
  i1_.image_couverture AS image_couverture_32,
  i1_.description AS description_33,
  i1_.ordre_affichage AS ordre_affichage_34,
  i1_.active AS active_35,
  i1_.created_at AS created_at_36,
  i1_.updated_at AS updated_at_37,
  v2_.id AS id_38,
  v2_.nom AS nom_39,
  v2_.code_postal AS code_postal_40,
  v2_.latitude AS latitude_41,
  v2_.longitude AS longitude_42,
  v2_.active AS active_43,
  v2_.created_at AS created_at_44,
  v2_.updated_at AS updated_at_45,
  v2_.slug AS slug_46,
  h3_.id AS id_47,
  h3_.jour_semaine AS jour_semaine_48,
  h3_.heure_ouverture AS heure_ouverture_49,
  h3_.heure_fermeture AS heure_fermeture_50,
  h3_.heure_ouverture_apres_midi AS heure_ouverture_apres_midi_51,
  h3_.heure_fermeture_apres_midi AS heure_fermeture_apres_midi_52,
  h3_.ferme AS ferme_53,
  h3_.note AS note_54,
  p4_.id AS id_55,
  p4_.url AS url_56,
  p4_.nom_fichier AS nom_fichier_57,
  p4_.alt AS alt_58,
  p4_.legende AS legende_59,
  p4_.ordre AS ordre_60,
  p4_.principale AS principale_61,
  p4_.created_at AS created_at_62,
  p4_.updated_at AS updated_at_63,
  p0_.ile_id AS ile_id_64,
  p0_.ville_id AS ville_id_65,
  v2_.ile_id AS ile_id_66,
  h3_.pharmacie_id AS pharmacie_id_67,
  p4_.pharmacie_id AS pharmacie_id_68
FROM
  pharmacie p0_
  LEFT JOIN ile i1_ ON p0_.ile_id = i1_.id
  LEFT JOIN ville v2_ ON p0_.ville_id = v2_.id
  LEFT JOIN horaire_ouverture h3_ ON p0_.id = h3_.pharmacie_id
  LEFT JOIN pharmacie_image p4_ ON p0_.id = p4_.pharmacie_id
WHERE
  p0_.active = 1
ORDER BY
  i1_.ordre_affichage ASC,
  p0_.de_garde DESC,
  p0_.nom ASC,
  h3_.jour_semaine ASC,
  p4_.ordre ASC

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.numero_agrement AS numero_agrement_2, p0_.description AS description_3, p0_.quartier AS quartier_4, p0_.adresse AS adresse_5, p0_.latitude AS latitude_6, p0_.longitude AS longitude_7, p0_.telephone AS telephone_8, p0_.telephone_secondaire AS telephone_secondaire_9, p0_.email AS email_10, p0_.site_web AS site_web_11, p0_.statut AS statut_12, p0_.de_garde AS de_garde_13, p0_.active AS active_14, p0_.verifiee AS verifiee_15, p0_.mise_en_avant AS mise_en_avant_16, p0_.note_moyenne AS note_moyenne_17, p0_.nombre_avis AS nombre_avis_18, p0_.accepte_commande_en_ligne AS accepte_commande_en_ligne_19, p0_.accepte_ordonnance_numerique AS accepte_ordonnance_numerique_20, p0_.propose_livraison AS propose_livraison_21, p0_.rayon_livraison_km AS rayon_livraison_km_22, p0_.created_at AS created_at_23, p0_.updated_at AS updated_at_24, p0_.slug AS slug_25, i1_.id AS id_26, i1_.code AS code_27, i1_.nom_francais AS nom_francais_28, i1_.nom_traditionnel AS nom_traditionnel_29, i1_.capitale AS capitale_30, i1_.slogan AS slogan_31, i1_.image_couverture AS image_couverture_32, i1_.description AS description_33, i1_.ordre_affichage AS ordre_affichage_34, i1_.active AS active_35, i1_.created_at AS created_at_36, i1_.updated_at AS updated_at_37, v2_.id AS id_38, v2_.nom AS nom_39, v2_.code_postal AS code_postal_40, v2_.latitude AS latitude_41, v2_.longitude AS longitude_42, v2_.active AS active_43, v2_.created_at AS created_at_44, v2_.updated_at AS updated_at_45, v2_.slug AS slug_46, h3_.id AS id_47, h3_.jour_semaine AS jour_semaine_48, h3_.heure_ouverture AS heure_ouverture_49, h3_.heure_fermeture AS heure_fermeture_50, h3_.heure_ouverture_apres_midi AS heure_ouverture_apres_midi_51, h3_.heure_fermeture_apres_midi AS heure_fermeture_apres_midi_52, h3_.ferme AS ferme_53, h3_.note AS note_54, p4_.id AS id_55, p4_.url AS url_56, p4_.nom_fichier AS nom_fichier_57, p4_.alt AS alt_58, p4_.legende AS legende_59, p4_.ordre AS ordre_60, p4_.principale AS principale_61, p4_.created_at AS created_at_62, p4_.updated_at AS updated_at_63, p0_.ile_id AS ile_id_64, p0_.ville_id AS ville_id_65, v2_.ile_id AS ile_id_66, h3_.pharmacie_id AS pharmacie_id_67, p4_.pharmacie_id AS pharmacie_id_68 FROM pharmacie p0_ LEFT JOIN ile i1_ ON p0_.ile_id = i1_.id LEFT JOIN ville v2_ ON p0_.ville_id = v2_.id LEFT JOIN horaire_ouverture h3_ ON p0_.id = h3_.pharmacie_id LEFT JOIN pharmacie_image p4_ ON p0_.id = p4_.pharmacie_id WHERE p0_.active = 1 ORDER BY i1_.ordre_affichage ASC, p0_.de_garde DESC, p0_.nom ASC, h3_.jour_semaine ASC, p4_.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.numero_agrement AS numero_agrement_3,
  t0.description AS description_4,
  t0.quartier AS quartier_5,
  t0.adresse AS adresse_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t0.telephone AS telephone_9,
  t0.telephone_secondaire AS telephone_secondaire_10,
  t0.email AS email_11,
  t0.site_web AS site_web_12,
  t0.statut AS statut_13,
  t0.de_garde AS de_garde_14,
  t0.active AS active_15,
  t0.verifiee AS verifiee_16,
  t0.mise_en_avant AS mise_en_avant_17,
  t0.note_moyenne AS note_moyenne_18,
  t0.nombre_avis AS nombre_avis_19,
  t0.accepte_commande_en_ligne AS accepte_commande_en_ligne_20,
  t0.accepte_ordonnance_numerique AS accepte_ordonnance_numerique_21,
  t0.propose_livraison AS propose_livraison_22,
  t0.rayon_livraison_km AS rayon_livraison_km_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.slug AS slug_26,
  t0.ile_id AS ile_id_27,
  t0.ville_id AS ville_id_28
FROM
  pharmacie t0
WHERE
  t0.ile_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_agrement AS numero_agrement_3, t0.description AS description_4, t0.quartier AS quartier_5, t0.adresse AS adresse_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.telephone AS telephone_9, t0.telephone_secondaire AS telephone_secondaire_10, t0.email AS email_11, t0.site_web AS site_web_12, t0.statut AS statut_13, t0.de_garde AS de_garde_14, t0.active AS active_15, t0.verifiee AS verifiee_16, t0.mise_en_avant AS mise_en_avant_17, t0.note_moyenne AS note_moyenne_18, t0.nombre_avis AS nombre_avis_19, t0.accepte_commande_en_ligne AS accepte_commande_en_ligne_20, t0.accepte_ordonnance_numerique AS accepte_ordonnance_numerique_21, t0.propose_livraison AS propose_livraison_22, t0.rayon_livraison_km AS rayon_livraison_km_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.slug AS slug_26, t0.ile_id AS ile_id_27, t0.ville_id AS ville_id_28 FROM pharmacie t0 WHERE t0.ile_id = 7;

SELECT
  i0_.id AS id_0,
  i0_.code AS code_1,
  i0_.nom_francais AS nom_francais_2,
  i0_.nom_traditionnel AS nom_traditionnel_3,
  i0_.capitale AS capitale_4,
  i0_.slogan AS slogan_5,
  i0_.image_couverture AS image_couverture_6,
  i0_.description AS description_7,
  i0_.ordre_affichage AS ordre_affichage_8,
  i0_.active AS active_9,
  i0_.created_at AS created_at_10,
  i0_.updated_at AS updated_at_11,
  v1_.id AS id_12,
  v1_.nom AS nom_13,
  v1_.code_postal AS code_postal_14,
  v1_.latitude AS latitude_15,
  v1_.longitude AS longitude_16,
  v1_.active AS active_17,
  v1_.created_at AS created_at_18,
  v1_.updated_at AS updated_at_19,
  v1_.slug AS slug_20,
  v1_.ile_id AS ile_id_21
FROM
  ile i0_
  LEFT JOIN ville v1_ ON i0_.id = v1_.ile_id
WHERE
  i0_.active = 1
ORDER BY
  i0_.ordre_affichage ASC,
  v1_.nom ASC

SELECT i0_.id AS id_0, i0_.code AS code_1, i0_.nom_francais AS nom_francais_2, i0_.nom_traditionnel AS nom_traditionnel_3, i0_.capitale AS capitale_4, i0_.slogan AS slogan_5, i0_.image_couverture AS image_couverture_6, i0_.description AS description_7, i0_.ordre_affichage AS ordre_affichage_8, i0_.active AS active_9, i0_.created_at AS created_at_10, i0_.updated_at AS updated_at_11, v1_.id AS id_12, v1_.nom AS nom_13, v1_.code_postal AS code_postal_14, v1_.latitude AS latitude_15, v1_.longitude AS longitude_16, v1_.active AS active_17, v1_.created_at AS created_at_18, v1_.updated_at AS updated_at_19, v1_.slug AS slug_20, v1_.ile_id AS ile_id_21 FROM ile i0_ LEFT JOIN ville v1_ ON i0_.id = v1_.ile_id WHERE i0_.active = 1 ORDER BY i0_.ordre_affichage ASC, v1_.nom ASC;

SELECT
  a0_.id AS id_0,
  a0_.type AS type_1,
  a0_.tag AS tag_2,
  a0_.titre AS titre_3,
  a0_.contenu AS contenu_4,
  a0_.valeur_statistique AS valeur_statistique_5,
  a0_.libelle_statistique AS libelle_statistique_6,
  a0_.image_url AS image_url_7,
  a0_.icone AS icone_8,
  a0_.auteur AS auteur_9,
  a0_.cta_libelle AS cta_libelle_10,
  a0_.cta_url AS cta_url_11,
  a0_.ordre AS ordre_12,
  a0_.active AS active_13,
  a0_.date_debut AS date_debut_14,
  a0_.date_fin AS date_fin_15,
  a0_.created_at AS created_at_16,
  a0_.updated_at AS updated_at_17
FROM
  annonce a0_
WHERE
  a0_.active = 1
  AND (
    a0_.date_debut IS NULL
    OR a0_.date_debut <= ?
  )
  AND (
    a0_.date_fin IS NULL
    OR a0_.date_fin >= ?
  )
ORDER BY
  a0_.ordre ASC,
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.tag AS tag_2, a0_.titre AS titre_3, a0_.contenu AS contenu_4, a0_.valeur_statistique AS valeur_statistique_5, a0_.libelle_statistique AS libelle_statistique_6, a0_.image_url AS image_url_7, a0_.icone AS icone_8, a0_.auteur AS auteur_9, a0_.cta_libelle AS cta_libelle_10, a0_.cta_url AS cta_url_11, a0_.ordre AS ordre_12, a0_.active AS active_13, a0_.date_debut AS date_debut_14, a0_.date_fin AS date_fin_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17 FROM annonce a0_ WHERE a0_.active = 1 AND (a0_.date_debut IS NULL OR a0_.date_debut <= '2026-05-30 21:05:03') AND (a0_.date_fin IS NULL OR a0_.date_fin >= '2026-05-30 21:05:03') ORDER BY a0_.ordre ASC, a0_.id ASC;