Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.visible AS visible_2,
  t0.libelle AS libelle_3,
  t0.nb_doc_jour AS nb_doc_jour_4,
  t0.nb_doc_panier AS nb_doc_panier_5,
  t0.nb_reservation AS nb_reservation_6,
  t0.nb_prolongation AS nb_prolongation_7,
  t0.nb_simultane AS nb_simultane_8,
  t0.coordonnees AS coordonnees_9,
  t0.utilisation_casier AS utilisation_casier_10,
  t0.utiliser_mot_de_passe AS utiliser_mot_de_passe_11,
  t0.alias AS alias_12,
  t0.levees AS levees_13,
  t0.mode_connect_salle AS mode_connect_salle_14,
  t0.date_crea AS date_crea_15,
  t0.date_modif AS date_modif_16,
  t0.id_service AS id_service_17,
  t0.id_user_create AS id_user_create_18,
  t0.id_user_update AS id_user_update_19
FROM
  com_salle t0
WHERE
  t0.alias IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.visible AS visible_2, t0.libelle AS libelle_3, t0.nb_doc_jour AS nb_doc_jour_4, t0.nb_doc_panier AS nb_doc_panier_5, t0.nb_reservation AS nb_reservation_6, t0.nb_prolongation AS nb_prolongation_7, t0.nb_simultane AS nb_simultane_8, t0.coordonnees AS coordonnees_9, t0.utilisation_casier AS utilisation_casier_10, t0.utiliser_mot_de_passe AS utiliser_mot_de_passe_11, t0.alias AS alias_12, t0.levees AS levees_13, t0.mode_connect_salle AS mode_connect_salle_14, t0.date_crea AS date_crea_15, t0.date_modif AS date_modif_16, t0.id_service AS id_service_17, t0.id_user_create AS id_user_create_18, t0.id_user_update AS id_user_update_19 FROM com_salle t0 WHERE t0.alias IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.date AS date_3,
  t0.commentaires AS commentaires_4,
  t0.cloture AS cloture_5,
  t0.cloture_date AS cloture_date_6,
  t0.levees AS levees_7,
  t0.date_crea AS date_crea_8,
  t0.date_modif AS date_modif_9,
  t0.ref_unique AS ref_unique_10,
  t0.cloture_id_lecteur AS cloture_id_lecteur_11,
  t0.salle_id AS salle_id_12,
  t0.id_lecteur_ajout AS id_lecteur_ajout_13,
  t0.id_lecteur_modif AS id_lecteur_modif_14,
  t0.id_user_create AS id_user_create_15,
  t0.id_user_update AS id_user_update_16
FROM
  com_seance t0
WHERE
  t0.salle_id = ?
  AND t0.date = ?
ORDER BY
  t0.date DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date AS date_3, t0.commentaires AS commentaires_4, t0.cloture AS cloture_5, t0.cloture_date AS cloture_date_6, t0.levees AS levees_7, t0.date_crea AS date_crea_8, t0.date_modif AS date_modif_9, t0.ref_unique AS ref_unique_10, t0.cloture_id_lecteur AS cloture_id_lecteur_11, t0.salle_id AS salle_id_12, t0.id_lecteur_ajout AS id_lecteur_ajout_13, t0.id_lecteur_modif AS id_lecteur_modif_14, t0.id_user_create AS id_user_create_15, t0.id_user_update AS id_user_update_16 FROM com_seance t0 WHERE t0.salle_id = 1 AND t0.date = '2026-04-08' ORDER BY t0.date DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.visible AS visible_2,
  t0.libelle AS libelle_3,
  t0.nb_doc_jour AS nb_doc_jour_4,
  t0.nb_doc_panier AS nb_doc_panier_5,
  t0.nb_reservation AS nb_reservation_6,
  t0.nb_prolongation AS nb_prolongation_7,
  t0.nb_simultane AS nb_simultane_8,
  t0.coordonnees AS coordonnees_9,
  t0.utilisation_casier AS utilisation_casier_10,
  t0.utiliser_mot_de_passe AS utiliser_mot_de_passe_11,
  t0.alias AS alias_12,
  t0.levees AS levees_13,
  t0.mode_connect_salle AS mode_connect_salle_14,
  t0.date_crea AS date_crea_15,
  t0.date_modif AS date_modif_16,
  t0.id_service AS id_service_17,
  t0.id_user_create AS id_user_create_18,
  t0.id_user_update AS id_user_update_19
FROM
  com_salle t0
WHERE
  t0.alias = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.visible AS visible_2, t0.libelle AS libelle_3, t0.nb_doc_jour AS nb_doc_jour_4, t0.nb_doc_panier AS nb_doc_panier_5, t0.nb_reservation AS nb_reservation_6, t0.nb_prolongation AS nb_prolongation_7, t0.nb_simultane AS nb_simultane_8, t0.coordonnees AS coordonnees_9, t0.utilisation_casier AS utilisation_casier_10, t0.utiliser_mot_de_passe AS utiliser_mot_de_passe_11, t0.alias AS alias_12, t0.levees AS levees_13, t0.mode_connect_salle AS mode_connect_salle_14, t0.date_crea AS date_crea_15, t0.date_modif AS date_modif_16, t0.id_service AS id_service_17, t0.id_user_create AS id_user_create_18, t0.id_user_update AS id_user_update_19 FROM com_salle t0 WHERE t0.alias = 'salle1' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.intitule AS intitule_2,
  t0.cle AS cle_3,
  t0.roles AS roles_4,
  t0.valeurParDefault AS valeurParDefault_5,
  t0.valeurService AS valeurService_6,
  t0.utiliserValeurService AS utiliserValeurService_7,
  t0.valeurEffective AS valeurEffective_8,
  t0.type AS type_9,
  t0.typeValidateur AS typeValidateur_10,
  t0.categorie AS categorie_11,
  t0.commentaire AS commentaire_12,
  t0.ordre AS ordre_13,
  t0.date_crea AS date_crea_14,
  t0.date_modif AS date_modif_15,
  t0.id_service AS id_service_16,
  t0.id_user_create AS id_user_create_17,
  t0.id_user_update AS id_user_update_18
FROM
  adm_config t0

SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.cle AS cle_3, t0.roles AS roles_4, t0.valeurParDefault AS valeurParDefault_5, t0.valeurService AS valeurService_6, t0.utiliserValeurService AS utiliserValeurService_7, t0.valeurEffective AS valeurEffective_8, t0.type AS type_9, t0.typeValidateur AS typeValidateur_10, t0.categorie AS categorie_11, t0.commentaire AS commentaire_12, t0.ordre AS ordre_13, t0.date_crea AS date_crea_14, t0.date_modif AS date_modif_15, t0.id_service AS id_service_16, t0.id_user_create AS id_user_create_17, t0.id_user_update AS id_user_update_18 FROM adm_config t0;

SET
  sql_mode =(
    SELECT
      REPLACE(
        @@sql_mode, 'ONLY_FULL_GROUP_BY',
        ''
      )
  );

SET sql_mode=(SELECT REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', ''));;

SET
  sql_mode =(
    SELECT
      REPLACE(
        @@sql_mode, 'STRICT_TRANS_TABLES',
        ''
      )
  );

SET sql_mode=(SELECT REPLACE(@@sql_mode, 'STRICT_TRANS_TABLES', ''));;

SET
  @@group_concat_max_len = 100000;

SET @@group_concat_max_len = 100000;;

SET
  @optimizer_switch = 'subquery_cache=OFF'

SET @optimizer_switch='subquery_cache=OFF';

SET
  @optimizer_switch = 'optimize_join_buffer_size=on'

SET @optimizer_switch='optimize_join_buffer_size=on';