Symfony Profiler

[
  "route" => "front_booking"
  "route_parameters" => [
    "_route" => "front_booking"
    "_controller" => "App\Controller\Front\HomeController::booking"
    "id" => "019f7fd7-bb93-7f15-90f7-7a17d1970cd2"
  ]
  "request_uri" => "https://reservation-ccpmb.test.genesii.fr/reserver/019f7fd7-bb93-7f15-90f7-7a17d1970cd2"
  "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" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "4y9ac.myd.infomaniak.com"
    "port" => 3306
    "user" => "4y9ac_resaccpmb"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "4y9ac_resaccpmb"
    "serverVersion" => "10.4.34-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM categorie_materiel t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nom AS nom_2, t0.statut AS statut_3, t0.indisponible_depuis AS indisponible_depuis_4, t0.indisponible_jusqua AS indisponible_jusqua_5, t0.motif_indisponibilite AS motif_indisponibilite_6, t0.categorie_id AS categorie_id_7 FROM exemplaire_materiel t0"
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.numero_reservation AS numero_reservation_1, r0_.statut AS statut_2, r0_.commune AS commune_3, r0_.prenom AS prenom_4, r0_.nom AS nom_5, r0_.email AS email_6, r0_.telephone AS telephone_7, r0_.consentement_donnees AS consentement_donnees_8, r0_.canal_creation AS canal_creation_9, r0_.notes_internes AS notes_internes_10, r0_.date_demande AS date_demande_11, r0_.date_confirmation AS date_confirmation_12, r0_.categorie_id AS categorie_id_13, r0_.periode_id AS periode_id_14, r0_.exemplaire_id AS exemplaire_id_15 FROM reservation r0_ WHERE r0_.exemplaire_id = ? AND r0_.statut = ? LIMIT 1"
  "params" => [
    1 => "019f7fd7-bb8b-72f6-8c40-b23aa1414aa9"
    2 => "materiel_retire"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#964
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#964}
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.numero_reservation AS numero_reservation_1, r0_.statut AS statut_2, r0_.commune AS commune_3, r0_.prenom AS prenom_4, r0_.nom AS nom_5, r0_.email AS email_6, r0_.telephone AS telephone_7, r0_.consentement_donnees AS consentement_donnees_8, r0_.canal_creation AS canal_creation_9, r0_.notes_internes AS notes_internes_10, r0_.date_demande AS date_demande_11, r0_.date_confirmation AS date_confirmation_12, r0_.categorie_id AS categorie_id_13, r0_.periode_id AS periode_id_14, r0_.exemplaire_id AS exemplaire_id_15 FROM reservation r0_ INNER JOIN periode_reservation p1_ ON r0_.periode_id = p1_.id WHERE r0_.exemplaire_id = ? AND r0_.statut = ? AND p1_.date_debut <= ? AND p1_.date_fin >= ? LIMIT 1"
  "params" => [
    1 => "019f7fd7-bb8b-72f6-8c40-b23aa1414aa9"
    2 => "confirmee"
    3 => "2026-07-31 00:00:00"
    4 => "2026-07-31 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#964
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#964}
    3 => Doctrine\DBAL\ParameterType {#964}
    4 => Doctrine\DBAL\ParameterType {#964}
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.numero_reservation AS numero_reservation_1, r0_.statut AS statut_2, r0_.commune AS commune_3, r0_.prenom AS prenom_4, r0_.nom AS nom_5, r0_.email AS email_6, r0_.telephone AS telephone_7, r0_.consentement_donnees AS consentement_donnees_8, r0_.canal_creation AS canal_creation_9, r0_.notes_internes AS notes_internes_10, r0_.date_demande AS date_demande_11, r0_.date_confirmation AS date_confirmation_12, r0_.categorie_id AS categorie_id_13, r0_.periode_id AS periode_id_14, r0_.exemplaire_id AS exemplaire_id_15 FROM reservation r0_ WHERE r0_.exemplaire_id = ? AND r0_.statut = ? LIMIT 1"
  "params" => [
    1 => "019f8e81-fdb1-7931-aa02-b868ef952e61"
    2 => "materiel_retire"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#964
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#964}
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, r0_.numero_reservation AS numero_reservation_1, r0_.statut AS statut_2, r0_.commune AS commune_3, r0_.prenom AS prenom_4, r0_.nom AS nom_5, r0_.email AS email_6, r0_.telephone AS telephone_7, r0_.consentement_donnees AS consentement_donnees_8, r0_.canal_creation AS canal_creation_9, r0_.notes_internes AS notes_internes_10, r0_.date_demande AS date_demande_11, r0_.date_confirmation AS date_confirmation_12, r0_.categorie_id AS categorie_id_13, r0_.periode_id AS periode_id_14, r0_.exemplaire_id AS exemplaire_id_15 FROM reservation r0_ INNER JOIN periode_reservation p1_ ON r0_.periode_id = p1_.id WHERE r0_.exemplaire_id = ? AND r0_.statut = ? AND p1_.date_debut <= ? AND p1_.date_fin >= ? LIMIT 1"
  "params" => [
    1 => "019f8e81-fdb1-7931-aa02-b868ef952e61"
    2 => "confirmee"
    3 => "2026-07-31 00:00:00"
    4 => "2026-07-31 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#964
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#964}
    3 => Doctrine\DBAL\ParameterType {#964}
    4 => Doctrine\DBAL\ParameterType {#964}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.jour_retrait_label AS jour_retrait_label_4, t0.horaire_retrait_label AS horaire_retrait_label_5, t0.jour_retour_label AS jour_retour_label_6, t0.horaire_retour_label AS horaire_retour_label_7, t0.lieu_retrait AS lieu_retrait_8, t0.lieu_retour AS lieu_retour_9, t0.capacite AS capacite_10, t0.active AS active_11, t0.categorie_id AS categorie_id_12 FROM periode_reservation t0 WHERE t0.id = ?"
  "params" => [
    1 => "019f7fd7-bb93-7f15-90f7-7a17d1970cd2"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#964
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(r0_.id) AS sclr_0 FROM reservation r0_ WHERE r0_.periode_id = ? AND r0_.statut IN (?, ?, ?)"
  "params" => [
    1 => "019f7fd7-bb93-7f15-90f7-7a17d1970cd2"
    2 => "en_attente"
    3 => "confirmee"
    4 => "materiel_retire"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#964
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#964}
    3 => Doctrine\DBAL\ParameterType {#964}
    4 => Doctrine\DBAL\ParameterType {#964}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.titre_principal AS titre_principal_2, t0.texte_presentation AS texte_presentation_3, t0.texte_caution AS texte_caution_4, t0.faq_items AS faq_items_5, t0.rappels_actifs AS rappels_actifs_6, t0.adresse_contact AS adresse_contact_7, t0.telephone_contact AS telephone_contact_8, t0.email_contact AS email_contact_9, t0.horaires_contact AS horaires_contact_10, t0.texte_consentement AS texte_consentement_11, t0.url_politique_confidentialite AS url_politique_confidentialite_12, t0.emails_administration AS emails_administration_13, t0.heures_rappel_retrait AS heures_rappel_retrait_14, t0.heures_rappel_retour AS heures_rappel_retour_15 FROM parametrage_plateforme t0 LIMIT 1"
]