Symfony Profiler

SELECT
  COUNT(*)
FROM
  categorie_materiel t0

SELECT COUNT(*) FROM categorie_materiel t0;

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

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;

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

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 = '019f7fd7-bb8b-72f6-8c40-b23aa1414aa9' AND r0_.statut = 'materiel_retire' LIMIT 1;

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

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 = '019f7fd7-bb8b-72f6-8c40-b23aa1414aa9' AND r0_.statut = 'confirmee' AND p1_.date_debut <= '2026-07-31 00:00:00' AND p1_.date_fin >= '2026-07-31 00:00:00' LIMIT 1;

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

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 = '019f8e81-fdb1-7931-aa02-b868ef952e61' AND r0_.statut = 'materiel_retire' LIMIT 1;

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

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 = '019f8e81-fdb1-7931-aa02-b868ef952e61' AND r0_.statut = 'confirmee' AND p1_.date_debut <= '2026-07-31 00:00:00' AND p1_.date_fin >= '2026-07-31 00:00:00' LIMIT 1;

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
ORDER BY
  t0.date_debut ASC

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 ORDER BY t0.date_debut ASC;

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  reservation r0_
WHERE
  r0_.periode_id = ?
  AND r0_.statut IN (?, ?, ?)

SELECT COUNT(r0_.id) AS sclr_0 FROM reservation r0_ WHERE r0_.periode_id = '019f7fd7-bb93-7861-90f7-7a17cd9b3a9f' AND r0_.statut IN ('en_attente', 'confirmee', 'materiel_retire');

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  reservation r0_
WHERE
  r0_.periode_id = ?
  AND r0_.statut IN (?, ?, ?)

SELECT COUNT(r0_.id) AS sclr_0 FROM reservation r0_ WHERE r0_.periode_id = '019f7fd7-bb93-7e99-90f7-7a17ce895978' AND r0_.statut IN ('en_attente', 'confirmee', 'materiel_retire');

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  reservation r0_
WHERE
  r0_.periode_id = ?
  AND r0_.statut IN (?, ?, ?)

SELECT COUNT(r0_.id) AS sclr_0 FROM reservation r0_ WHERE r0_.periode_id = '019f7fd7-bb93-7ec1-90f7-7a17cf044289' AND r0_.statut IN ('en_attente', 'confirmee', 'materiel_retire');

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  reservation r0_
WHERE
  r0_.periode_id = ?
  AND r0_.statut IN (?, ?, ?)

SELECT COUNT(r0_.id) AS sclr_0 FROM reservation r0_ WHERE r0_.periode_id = '019f7fd7-bb93-7ed5-90f7-7a17cf86290d' AND r0_.statut IN ('en_attente', 'confirmee', 'materiel_retire');

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  reservation r0_
WHERE
  r0_.periode_id = ?
  AND r0_.statut IN (?, ?, ?)

SELECT COUNT(r0_.id) AS sclr_0 FROM reservation r0_ WHERE r0_.periode_id = '019f7fd7-bb93-7ee9-90f7-7a17cfe9c9b6' AND r0_.statut IN ('en_attente', 'confirmee', 'materiel_retire');

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  reservation r0_
WHERE
  r0_.periode_id = ?
  AND r0_.statut IN (?, ?, ?)

SELECT COUNT(r0_.id) AS sclr_0 FROM reservation r0_ WHERE r0_.periode_id = '019f7fd7-bb93-7ef9-90f7-7a17d07413f9' AND r0_.statut IN ('en_attente', 'confirmee', 'materiel_retire');

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  reservation r0_
WHERE
  r0_.periode_id = ?
  AND r0_.statut IN (?, ?, ?)

SELECT COUNT(r0_.id) AS sclr_0 FROM reservation r0_ WHERE r0_.periode_id = '019f7fd7-bb93-7f09-90f7-7a17d16bacf6' AND r0_.statut IN ('en_attente', 'confirmee', 'materiel_retire');

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  reservation r0_
WHERE
  r0_.periode_id = ?
  AND r0_.statut IN (?, ?, ?)

SELECT COUNT(r0_.id) AS sclr_0 FROM reservation r0_ WHERE r0_.periode_id = '019f7fd7-bb93-7f15-90f7-7a17d1970cd2' AND r0_.statut IN ('en_attente', 'confirmee', 'materiel_retire');

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  reservation r0_
WHERE
  r0_.periode_id = ?
  AND r0_.statut IN (?, ?, ?)

SELECT COUNT(r0_.id) AS sclr_0 FROM reservation r0_ WHERE r0_.periode_id = '019f7fd7-bb93-7f29-90f7-7a17d2567d84' AND r0_.statut IN ('en_attente', 'confirmee', 'materiel_retire');

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  reservation r0_
WHERE
  r0_.periode_id = ?
  AND r0_.statut IN (?, ?, ?)

SELECT COUNT(r0_.id) AS sclr_0 FROM reservation r0_ WHERE r0_.periode_id = '019f7fd7-bb93-7f35-90f7-7a17d293da03' AND r0_.statut IN ('en_attente', 'confirmee', 'materiel_retire');

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

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;