Symfony Profiler

[
  "route" => "app_index"
  "route_parameters" => [
    "_route" => "app_index"
    "_controller" => "App\Controller\IndexController::index"
  ]
  "request_uri" => "https://locapharma.technopole-km.com/"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "techn2778696"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "techn2778696_3whzao"
    "serverVersion" => "8.0.32"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
]

[
  "sql" => "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"
]

[
  "sql" => "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"
  "params" => [
    1 => "2026-05-30 21:05:03"
    2 => "2026-05-30 21:05:03"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2677
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2677}
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 34
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 35
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 36
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 37
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 38
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 39
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 40
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 41
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 42
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 44
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 45
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 46
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 47
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 48
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 49
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 50
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 51
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 52
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 53
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 54
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 55
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 56
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 57
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 58
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2662
      +name: "INTEGER"
    }
  ]
]