Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

422 Database Queries

19 Different statements

140.06 ms Query time

4 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
93.67 ms (66.88%)	338	SELECT t0.id AS id_1, t0.fct_nom AS fct_nom_2, t0.id_old AS id_old_3, t0.centre_groupe_id AS centre_groupe_id_4 FROM centre_fonction t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.fct_nom AS fct_nom_2, t0.id_old AS id_old_3, t0.centre_groupe_id AS centre_groupe_id_4 FROM centre_fonction t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.fct_nom AS fct_nom_2, t0.id_old AS id_old_3, t0.centre_groupe_id AS centre_groupe_id_4 FROM centre_fonction t0 WHERE t0.id = 1;
10.62 ms (7.58%)	25	SELECT t0.id AS id_1, t0.denomination AS denomination_2 FROM energie t0 INNER JOIN centre_prestation_energie ON t0.id = centre_prestation_energie.energie_id WHERE centre_prestation_energie.centre_prestation_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.denomination AS denomination_2 FROM energie t0 INNER JOIN centre_prestation_energie ON t0.id = centre_prestation_energie.energie_id WHERE centre_prestation_energie.centre_prestation_id = ? SELECT t0.id AS id_1, t0.denomination AS denomination_2 FROM energie t0 INNER JOIN centre_prestation_energie ON t0.id = centre_prestation_energie.energie_id WHERE centre_prestation_energie.centre_prestation_id = 1;
7.77 ms (5.55%)	14	SELECT t0.id AS id_1, t0.tv_libelle AS tv_libelle_2, t0.tv_moteur AS tv_moteur_3, t0.tv_md AS tv_md_4, t0.tv_ensemble AS tv_ensemble_5, t0.tv_valide AS tv_valide_6, t0.id_old AS id_old_7, t0.tv_centre_type_id AS tv_centre_type_id_8, t9.id AS id_10, t9.ct_denomination AS ct_denomination_11, t9.ct_libele_public AS ct_libele_public_12, t13.id AS id_14, t13.pst_tarif AS pst_tarif_15, t13.pst_duree AS pst_duree_16, t13.pst_actif AS pst_actif_17, t13.pst_afficher AS pst_afficher_18, t13.pst_couleur AS pst_couleur_19, t13.pst_ordre AS pst_ordre_20, t13.id_old AS id_old_21, t13.paiement_en_ligne AS paiement_en_ligne_22, t13.message_appel_centre AS message_appel_centre_23, t13.pst_type_vehicule_id AS pst_type_vehicule_id_24, t13.pst_type_visite_id AS pst_type_visite_id_25, t13.centre_groupe_id AS centre_groupe_id_26, t0.centre_groupe_id AS centre_groupe_id_27 FROM type_vehicule t0 INNER JOIN centre_type t9 ON t0.tv_centre_type_id = t9.id LEFT JOIN centre_prestation t13 ON t13.pst_type_vehicule_id = t0.id WHERE t0.id IN (?) Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.tv_libelle AS tv_libelle_2, t0.tv_moteur AS tv_moteur_3, t0.tv_md AS tv_md_4, t0.tv_ensemble AS tv_ensemble_5, t0.tv_valide AS tv_valide_6, t0.id_old AS id_old_7, t0.tv_centre_type_id AS tv_centre_type_id_8, t9.id AS id_10, t9.ct_denomination AS ct_denomination_11, t9.ct_libele_public AS ct_libele_public_12, t13.id AS id_14, t13.pst_tarif AS pst_tarif_15, t13.pst_duree AS pst_duree_16, t13.pst_actif AS pst_actif_17, t13.pst_afficher AS pst_afficher_18, t13.pst_couleur AS pst_couleur_19, t13.pst_ordre AS pst_ordre_20, t13.id_old AS id_old_21, t13.paiement_en_ligne AS paiement_en_ligne_22, t13.message_appel_centre AS message_appel_centre_23, t13.pst_type_vehicule_id AS pst_type_vehicule_id_24, t13.pst_type_visite_id AS pst_type_visite_id_25, t13.centre_groupe_id AS centre_groupe_id_26, t0.centre_groupe_id AS centre_groupe_id_27 FROM type_vehicule t0 INNER JOIN centre_type t9 ON t0.tv_centre_type_id = t9.id LEFT JOIN centre_prestation t13 ON t13.pst_type_vehicule_id = t0.id WHERE t0.id IN (?) SELECT t0.id AS id_1, t0.tv_libelle AS tv_libelle_2, t0.tv_moteur AS tv_moteur_3, t0.tv_md AS tv_md_4, t0.tv_ensemble AS tv_ensemble_5, t0.tv_valide AS tv_valide_6, t0.id_old AS id_old_7, t0.tv_centre_type_id AS tv_centre_type_id_8, t9.id AS id_10, t9.ct_denomination AS ct_denomination_11, t9.ct_libele_public AS ct_libele_public_12, t13.id AS id_14, t13.pst_tarif AS pst_tarif_15, t13.pst_duree AS pst_duree_16, t13.pst_actif AS pst_actif_17, t13.pst_afficher AS pst_afficher_18, t13.pst_couleur AS pst_couleur_19, t13.pst_ordre AS pst_ordre_20, t13.id_old AS id_old_21, t13.paiement_en_ligne AS paiement_en_ligne_22, t13.message_appel_centre AS message_appel_centre_23, t13.pst_type_vehicule_id AS pst_type_vehicule_id_24, t13.pst_type_visite_id AS pst_type_visite_id_25, t13.centre_groupe_id AS centre_groupe_id_26, t0.centre_groupe_id AS centre_groupe_id_27 FROM type_vehicule t0 INNER JOIN centre_type t9 ON t0.tv_centre_type_id = t9.id LEFT JOIN centre_prestation t13 ON t13.pst_type_vehicule_id = t0.id WHERE t0.id IN (1);
6.18 ms (4.41%)	18	SELECT t0.id AS id_1, t0.typ_vst_libele AS typ_vst_libele_2, t0.typ_vst_libele_long AS typ_vst_libele_long_3, t0.typ_vst_libele_court AS typ_vst_libele_court_4, t0.typ_vst_couleur AS typ_vst_couleur_5, t0.id_old AS id_old_6, t0.centre_groupe_id AS centre_groupe_id_7 FROM type_visite t0 WHERE t0.id IN (?) Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.typ_vst_libele AS typ_vst_libele_2, t0.typ_vst_libele_long AS typ_vst_libele_long_3, t0.typ_vst_libele_court AS typ_vst_libele_court_4, t0.typ_vst_couleur AS typ_vst_couleur_5, t0.id_old AS id_old_6, t0.centre_groupe_id AS centre_groupe_id_7 FROM type_visite t0 WHERE t0.id IN (?) SELECT t0.id AS id_1, t0.typ_vst_libele AS typ_vst_libele_2, t0.typ_vst_libele_long AS typ_vst_libele_long_3, t0.typ_vst_libele_court AS typ_vst_libele_court_4, t0.typ_vst_couleur AS typ_vst_couleur_5, t0.id_old AS id_old_6, t0.centre_groupe_id AS centre_groupe_id_7 FROM type_visite t0 WHERE t0.id IN (5);
4.77 ms (3.40%)	1	SELECT r0_.id AS id_0, r0_.rdv_tarif AS rdv_tarif_1, r0_.rdv_date_heure AS rdv_date_heure_2, r0_.rdv_duree AS rdv_duree_3, r0_.rdv_date_rappel_sms AS rdv_date_rappel_sms_4, r0_.rdv_datetime_timeout AS rdv_datetime_timeout_5, r0_.rdv_timeout AS rdv_timeout_6, r0_.rdv_commentaire AS rdv_commentaire_7, r0_.rdv_demande_rappel_sms AS rdv_demande_rappel_sms_8, r0_.rdv_coupon_cteasy AS rdv_coupon_cteasy_9, r0_.rdv_bon_commande AS rdv_bon_commande_10, r0_.rdv_vehicule_present AS rdv_vehicule_present_11, r0_.rdv_termine AS rdv_termine_12, r0_.rdv_notif_payline AS rdv_notif_payline_13, r0_.rdv_id_auto_planning AS rdv_id_auto_planning_14, r0_.rdv_date_creation AS rdv_date_creation_15, r0_.id_old AS id_old_16, r0_.token_payline AS token_payline_17, r0_.token_rendez_vous AS token_rendez_vous_18, r0_.nombre_modification AS nombre_modification_19, r0_.rdv_color AS rdv_color_20, r0_.rdv_date_modification AS rdv_date_modification_21, r0_.rdv_demande_confirmation_sms AS rdv_demande_confirmation_sms_22, l1_.id AS id_23, l1_.lgn_nom AS lgn_nom_24, l1_.lgn_actif AS lgn_actif_25, l1_.id_old AS id_old_26, l1_.lgn_vl AS lgn_vl_27, l1_.lgn_pl AS lgn_pl_28, l1_.lgn_cl AS lgn_cl_29, l1_.color AS color_30, c2_.id AS id_31, c2_.cl_nom AS cl_nom_32, c2_.cl_prenom AS cl_prenom_33, c2_.cl_email AS cl_email_34, c2_.cl_telephone AS cl_telephone_35, c2_.cl_civilite AS cl_civilite_36, c3_.id AS id_37, c3_.cli_username AS cli_username_38, c3_.cli_is_active AS cli_is_active_39, c3_.cli_password AS cli_password_40, c3_.cli_salt AS cli_salt_41, c3_.cli_nom_societe AS cli_nom_societe_42, c3_.cli_nom AS cli_nom_43, c3_.cli_prenom AS cli_prenom_44, c3_.cli_email AS cli_email_45, c3_.cli_telephone AS cli_telephone_46, c3_.cli_telephone_2 AS cli_telephone_2_47, c3_.cli_fax AS cli_fax_48, c3_.cli_tva AS cli_tva_49, c3_.cli_siren AS cli_siren_50, c3_.cli_cpl AS cli_cpl_51, c3_.cli_nb_jour_alerte_echeance_1 AS cli_nb_jour_alerte_echeance_1_52, c3_.cli_nb_jour_alerte_echeance_2 AS cli_nb_jour_alerte_echeance_2_53, c3_.cli_nb_jour_alerte_echeance_3 AS cli_nb_jour_alerte_echeance_3_54, c3_.cli_nb_jour_alerte_echeance_sms_1 AS cli_nb_jour_alerte_echeance_sms_1_55, c3_.cli_nb_jour_alerte_echeance_sms_2 AS cli_nb_jour_alerte_echeance_sms_2_56, c3_.cli_nb_jour_alerte_echeance_sms_3 AS cli_nb_jour_alerte_echeance_sms_3_57, c3_.cli_contact_1_nom AS cli_contact_1_nom_58, c3_.cli_contact_1_prenom AS cli_contact_1_prenom_59, c3_.cli_contact_1_email AS cli_contact_1_email_60, c3_.cli_contact_1_telephone AS cli_contact_1_telephone_61, c3_.cli_contact_2_nom AS cli_contact_2_nom_62, c3_.cli_contact_2_prenom AS cli_contact_2_prenom_63, c3_.cli_contact_2_email AS cli_contact_2_email_64, c3_.cli_contact_2_telephone AS cli_contact_2_telephone_65, c3_.cli_has_pro_access AS cli_has_pro_access_66, c3_.id_old AS id_old_67, c3_.cli_vl AS cli_vl_68, c3_.cli_pl AS cli_pl_69, c3_.cli_cl AS cli_cl_70, u4_.id AS id_71, u4_.utl_username AS utl_username_72, u4_.utl_password AS utl_password_73, u4_.utl_salt AS utl_salt_74, u4_.utl_prestataire AS utl_prestataire_75, u4_.utl_nom AS utl_nom_76, u4_.utl_prenom AS utl_prenom_77, u4_.utl_is_masked AS utl_is_masked_78, u4_.utl_agrement AS utl_agrement_79, u4_.id_old AS id_old_80, u4_.roles AS roles_81, u4_.utl_email AS utl_email_82, c5_.id AS id_83, c5_.ct_denomination AS ct_denomination_84, c5_.ct_libele_public AS ct_libele_public_85, p6_.id AS id_86, p6_.pa_nom AS pa_nom_87, p6_.pa_logo AS pa_logo_88, p6_.pa_logo_vignette AS pa_logo_vignette_89, p6_.pa_couleur AS pa_couleur_90, p6_.pa_gestion_agenda_autonome AS pa_gestion_agenda_autonome_91, p6_.pa_paiement_obligatoire AS pa_paiement_obligatoire_92, p6_.pa_timeout_reservation AS pa_timeout_reservation_93, p6_.pa_code_ws AS pa_code_ws_94, p6_.id_old AS id_old_95, r7_.id AS id_96, r7_.id_old AS id_old_97, r8_.id AS id_98, r8_.rdv_inf_pv AS rdv_inf_pv_99, r8_.rdv_inf_facture AS rdv_inf_facture_100, r8_.rdv_inf_resultat AS rdv_inf_resultat_101, r8_.rdv_inf_date_ct AS rdv_inf_date_ct_102, r8_.rdv_inf_hdebut_ct AS rdv_inf_hdebut_ct_103, r8_.rdv_inf_hfin_ct AS rdv_inf_hfin_ct_104, r8_.rdv_inf_depot AS rdv_inf_depot_105, r8_.rdv_inf_convoyage AS rdv_inf_convoyage_106, r8_.rdv_inf_pret AS rdv_inf_pret_107, r8_.rdv_inf_date_avis_google_sms AS rdv_inf_date_avis_google_sms_108, r8_.rdv_inf_date_avis_google_email AS rdv_inf_date_avis_google_email_109, r9_.id AS id_110, r9_.rdv_vhc_immatriculation AS rdv_vhc_immatriculation_111, r9_.rdv_vhc_ref_parc AS rdv_vhc_ref_parc_112, r9_.rdv_vhc_num_serie AS rdv_vhc_num_serie_113, r9_.rdv_vhc_description AS rdv_vhc_description_114, r9_.rdv_vhc_date_echeance AS rdv_vhc_date_echeance_115, r9_.rdv_vhc_date_alert_echeance AS rdv_vhc_date_alert_echeance_116, r9_.rdv_vhc_date_chronotachygraphe AS rdv_vhc_date_chronotachygraphe_117, r9_.rdv_vhc_date_limiteur_vitesse AS rdv_vhc_date_limiteur_vitesse_118, r9_.rdv_vhc_type_proprietaire AS rdv_vhc_type_proprietaire_119, r9_.rdv_vhc_nom_client_proprietaire AS rdv_vhc_nom_client_proprietaire_120, r9_.rdv_vhc_prenom_client_proprietaire AS rdv_vhc_prenom_client_proprietaire_121, r9_.rdv_vhc_zone_saisie_1 AS rdv_vhc_zone_saisie_1_122, r9_.rdv_vhc_date_saisie_1 AS rdv_vhc_date_saisie_1_123, r9_.rdv_vhc_zone_saisie_2 AS rdv_vhc_zone_saisie_2_124, r9_.rdv_vhc_date_saisie_2 AS rdv_vhc_date_saisie_2_125, r9_.rdv_vhc_zone_saisie_3 AS rdv_vhc_zone_saisie_3_126, r9_.rdv_vhc_date_saisie_3 AS rdv_vhc_date_saisie_3_127, r9_.rdv_vhc_date_rdv_prevu AS rdv_vhc_date_rdv_prevu_128, r9_.id_old AS id_old_129, r9_.is_active AS is_active_130, m10_.id AS id_131, m10_.marque_libele AS marque_libele_132, m10_.id_old AS id_old_133, m10_.ordre AS ordre_134, m11_.id AS id_135, m11_.marque_libele AS marque_libele_136, m11_.ordre AS ordre_137, m12_.id AS id_138, m12_.mdl_libele AS mdl_libele_139, m12_.id_old AS id_old_140, m12_.mdl_ordre AS mdl_ordre_141, m13_.id AS id_142, m13_.mdl_libele AS mdl_libele_143, m13_.mdl_ordre AS mdl_ordre_144, e14_.id AS id_145, e14_.denomination AS denomination_146, t15_.id AS id_147, t15_.tv_libelle AS tv_libelle_148, t15_.tv_moteur AS tv_moteur_149, t15_.tv_md AS tv_md_150, t15_.tv_ensemble AS tv_ensemble_151, t15_.tv_valide AS tv_valide_152, t15_.id_old AS id_old_153, c16_.id AS id_154, c16_.pst_tarif AS pst_tarif_155, c16_.pst_duree AS pst_duree_156, c16_.pst_actif AS pst_actif_157, c16_.pst_afficher AS pst_afficher_158, c16_.pst_couleur AS pst_couleur_159, c16_.pst_ordre AS pst_ordre_160, c16_.id_old AS id_old_161, c16_.paiement_en_ligne AS paiement_en_ligne_162, c16_.message_appel_centre AS message_appel_centre_163, t17_.id AS id_164, t17_.typ_vst_libele AS typ_vst_libele_165, t17_.typ_vst_libele_long AS typ_vst_libele_long_166, t17_.typ_vst_libele_court AS typ_vst_libele_court_167, t17_.typ_vst_couleur AS typ_vst_couleur_168, t17_.id_old AS id_old_169, r0_.centre_id AS centre_id_170, r0_.client_libre_id AS client_libre_id_171, r0_.client_compte_id AS client_compte_id_172, r0_.centre_type_id AS centre_type_id_173, r0_.ligne_id AS ligne_id_174, r0_.partenaire_id AS partenaire_id_175, r0_.utilisateur_id AS utilisateur_id_176, r0_.recurrence_id AS recurrence_id_177, r0_.promotion_id AS promotion_id_178, r0_.coupon_promotion_id AS coupon_promotion_id_179, l1_.centre_type_id AS centre_type_id_180, l1_.centre_groupe_id AS centre_groupe_id_181, c3_.adresse_id AS adresse_id_182, c3_.adresse_facturation_id AS adresse_facturation_id_183, c3_.centre_groupe_id AS centre_groupe_id_184, c3_.centre_type_id AS centre_type_id_185, u4_.centre_groupe_id AS centre_groupe_id_186, r8_.vehicule_id AS vehicule_id_187, r8_.centre_prestation_id AS centre_prestation_id_188, r8_.rendezvous_id AS rendezvous_id_189, r9_.marque_id AS marque_id_190, r9_.modele_id AS modele_id_191, r9_.type_vehicule_id AS type_vehicule_id_192, r9_.client_compte_id AS client_compte_id_193, r9_.energie_id AS energie_id_194, r9_.marque_pl_id AS marque_pl_id_195, r9_.modele_pl_id AS modele_pl_id_196, r9_.marque_cl_id AS marque_cl_id_197, r9_.modele_cl_id AS modele_cl_id_198, m12_.code_marque_id AS code_marque_id_199, m13_.code_marque_cl_id AS code_marque_cl_id_200, t15_.tv_centre_type_id AS tv_centre_type_id_201, t15_.centre_groupe_id AS centre_groupe_id_202, c16_.pst_type_vehicule_id AS pst_type_vehicule_id_203, c16_.pst_type_visite_id AS pst_type_visite_id_204, c16_.centre_groupe_id AS centre_groupe_id_205, t17_.centre_groupe_id AS centre_groupe_id_206 FROM rendezvous r0_ LEFT JOIN centre c18_ ON r0_.centre_id = c18_.id LEFT JOIN ligne l1_ ON r0_.ligne_id = l1_.id LEFT JOIN client_libre c2_ ON r0_.client_libre_id = c2_.id LEFT JOIN client_compte c3_ ON r0_.client_compte_id = c3_.id LEFT JOIN utilisateur u4_ ON r0_.utilisateur_id = u4_.id LEFT JOIN centre_type c5_ ON r0_.centre_type_id = c5_.id LEFT JOIN partenaire p6_ ON r0_.partenaire_id = p6_.id LEFT JOIN rendez_vous_recurrence r7_ ON r0_.recurrence_id = r7_.id LEFT JOIN rendez_vous_infos r8_ ON r0_.id = r8_.rendezvous_id LEFT JOIN rendez_vous_vehicule r9_ ON r8_.vehicule_id = r9_.id LEFT JOIN marque m10_ ON r9_.marque_id = m10_.id LEFT JOIN marque_cl m11_ ON r9_.marque_cl_id = m11_.id LEFT JOIN modele m12_ ON r9_.modele_id = m12_.id LEFT JOIN modele_cl m13_ ON r9_.modele_cl_id = m13_.id LEFT JOIN energie e14_ ON r9_.energie_id = e14_.id LEFT JOIN type_vehicule t15_ ON r9_.type_vehicule_id = t15_.id LEFT JOIN centre_prestation c16_ ON r8_.centre_prestation_id = c16_.id LEFT JOIN type_visite t17_ ON c16_.pst_type_visite_id = t17_.id WHERE c18_.centre_groupe_id = ? AND r0_.rdv_date_heure >= ? AND r0_.rdv_date_heure <= ? ORDER BY r0_.rdv_date_heure ASC Parameters: [`1 "2026-03-30T00:00:00 02:00" "2026-04-05T00:00:00 02:00"`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.rdv_tarif AS rdv_tarif_1, r0_.rdv_date_heure AS rdv_date_heure_2, r0_.rdv_duree AS rdv_duree_3, r0_.rdv_date_rappel_sms AS rdv_date_rappel_sms_4, r0_.rdv_datetime_timeout AS rdv_datetime_timeout_5, r0_.rdv_timeout AS rdv_timeout_6, r0_.rdv_commentaire AS rdv_commentaire_7, r0_.rdv_demande_rappel_sms AS rdv_demande_rappel_sms_8, r0_.rdv_coupon_cteasy AS rdv_coupon_cteasy_9, r0_.rdv_bon_commande AS rdv_bon_commande_10, r0_.rdv_vehicule_present AS rdv_vehicule_present_11, r0_.rdv_termine AS rdv_termine_12, r0_.rdv_notif_payline AS rdv_notif_payline_13, r0_.rdv_id_auto_planning AS rdv_id_auto_planning_14, r0_.rdv_date_creation AS rdv_date_creation_15, r0_.id_old AS id_old_16, r0_.token_payline AS token_payline_17, r0_.token_rendez_vous AS token_rendez_vous_18, r0_.nombre_modification AS nombre_modification_19, r0_.rdv_color AS rdv_color_20, r0_.rdv_date_modification AS rdv_date_modification_21, r0_.rdv_demande_confirmation_sms AS rdv_demande_confirmation_sms_22, l1_.id AS id_23, l1_.lgn_nom AS lgn_nom_24, l1_.lgn_actif AS lgn_actif_25, l1_.id_old AS id_old_26, l1_.lgn_vl AS lgn_vl_27, l1_.lgn_pl AS lgn_pl_28, l1_.lgn_cl AS lgn_cl_29, l1_.color AS color_30, c2_.id AS id_31, c2_.cl_nom AS cl_nom_32, c2_.cl_prenom AS cl_prenom_33, c2_.cl_email AS cl_email_34, c2_.cl_telephone AS cl_telephone_35, c2_.cl_civilite AS cl_civilite_36, c3_.id AS id_37, c3_.cli_username AS cli_username_38, c3_.cli_is_active AS cli_is_active_39, c3_.cli_password AS cli_password_40, c3_.cli_salt AS cli_salt_41, c3_.cli_nom_societe AS cli_nom_societe_42, c3_.cli_nom AS cli_nom_43, c3_.cli_prenom AS cli_prenom_44, c3_.cli_email AS cli_email_45, c3_.cli_telephone AS cli_telephone_46, c3_.cli_telephone_2 AS cli_telephone_2_47, c3_.cli_fax AS cli_fax_48, c3_.cli_tva AS cli_tva_49, c3_.cli_siren AS cli_siren_50, c3_.cli_cpl AS cli_cpl_51, c3_.cli_nb_jour_alerte_echeance_1 AS cli_nb_jour_alerte_echeance_1_52, c3_.cli_nb_jour_alerte_echeance_2 AS cli_nb_jour_alerte_echeance_2_53, c3_.cli_nb_jour_alerte_echeance_3 AS cli_nb_jour_alerte_echeance_3_54, c3_.cli_nb_jour_alerte_echeance_sms_1 AS cli_nb_jour_alerte_echeance_sms_1_55, c3_.cli_nb_jour_alerte_echeance_sms_2 AS cli_nb_jour_alerte_echeance_sms_2_56, c3_.cli_nb_jour_alerte_echeance_sms_3 AS cli_nb_jour_alerte_echeance_sms_3_57, c3_.cli_contact_1_nom AS cli_contact_1_nom_58, c3_.cli_contact_1_prenom AS cli_contact_1_prenom_59, c3_.cli_contact_1_email AS cli_contact_1_email_60, c3_.cli_contact_1_telephone AS cli_contact_1_telephone_61, c3_.cli_contact_2_nom AS cli_contact_2_nom_62, c3_.cli_contact_2_prenom AS cli_contact_2_prenom_63, c3_.cli_contact_2_email AS cli_contact_2_email_64, c3_.cli_contact_2_telephone AS cli_contact_2_telephone_65, c3_.cli_has_pro_access AS cli_has_pro_access_66, c3_.id_old AS id_old_67, c3_.cli_vl AS cli_vl_68, c3_.cli_pl AS cli_pl_69, c3_.cli_cl AS cli_cl_70, u4_.id AS id_71, u4_.utl_username AS utl_username_72, u4_.utl_password AS utl_password_73, u4_.utl_salt AS utl_salt_74, u4_.utl_prestataire AS utl_prestataire_75, u4_.utl_nom AS utl_nom_76, u4_.utl_prenom AS utl_prenom_77, u4_.utl_is_masked AS utl_is_masked_78, u4_.utl_agrement AS utl_agrement_79, u4_.id_old AS id_old_80, u4_.roles AS roles_81, u4_.utl_email AS utl_email_82, c5_.id AS id_83, c5_.ct_denomination AS ct_denomination_84, c5_.ct_libele_public AS ct_libele_public_85, p6_.id AS id_86, p6_.pa_nom AS pa_nom_87, p6_.pa_logo AS pa_logo_88, p6_.pa_logo_vignette AS pa_logo_vignette_89, p6_.pa_couleur AS pa_couleur_90, p6_.pa_gestion_agenda_autonome AS pa_gestion_agenda_autonome_91, p6_.pa_paiement_obligatoire AS pa_paiement_obligatoire_92, p6_.pa_timeout_reservation AS pa_timeout_reservation_93, p6_.pa_code_ws AS pa_code_ws_94, p6_.id_old AS id_old_95, r7_.id AS id_96, r7_.id_old AS id_old_97, r8_.id AS id_98, r8_.rdv_inf_pv AS rdv_inf_pv_99, r8_.rdv_inf_facture AS rdv_inf_facture_100, r8_.rdv_inf_resultat AS rdv_inf_resultat_101, r8_.rdv_inf_date_ct AS rdv_inf_date_ct_102, r8_.rdv_inf_hdebut_ct AS rdv_inf_hdebut_ct_103, r8_.rdv_inf_hfin_ct AS rdv_inf_hfin_ct_104, r8_.rdv_inf_depot AS rdv_inf_depot_105, r8_.rdv_inf_convoyage AS rdv_inf_convoyage_106, r8_.rdv_inf_pret AS rdv_inf_pret_107, r8_.rdv_inf_date_avis_google_sms AS rdv_inf_date_avis_google_sms_108, r8_.rdv_inf_date_avis_google_email AS rdv_inf_date_avis_google_email_109, r9_.id AS id_110, r9_.rdv_vhc_immatriculation AS rdv_vhc_immatriculation_111, r9_.rdv_vhc_ref_parc AS rdv_vhc_ref_parc_112, r9_.rdv_vhc_num_serie AS rdv_vhc_num_serie_113, r9_.rdv_vhc_description AS rdv_vhc_description_114, r9_.rdv_vhc_date_echeance AS rdv_vhc_date_echeance_115, r9_.rdv_vhc_date_alert_echeance AS rdv_vhc_date_alert_echeance_116, r9_.rdv_vhc_date_chronotachygraphe AS rdv_vhc_date_chronotachygraphe_117, r9_.rdv_vhc_date_limiteur_vitesse AS rdv_vhc_date_limiteur_vitesse_118, r9_.rdv_vhc_type_proprietaire AS rdv_vhc_type_proprietaire_119, r9_.rdv_vhc_nom_client_proprietaire AS rdv_vhc_nom_client_proprietaire_120, r9_.rdv_vhc_prenom_client_proprietaire AS rdv_vhc_prenom_client_proprietaire_121, r9_.rdv_vhc_zone_saisie_1 AS rdv_vhc_zone_saisie_1_122, r9_.rdv_vhc_date_saisie_1 AS rdv_vhc_date_saisie_1_123, r9_.rdv_vhc_zone_saisie_2 AS rdv_vhc_zone_saisie_2_124, r9_.rdv_vhc_date_saisie_2 AS rdv_vhc_date_saisie_2_125, r9_.rdv_vhc_zone_saisie_3 AS rdv_vhc_zone_saisie_3_126, r9_.rdv_vhc_date_saisie_3 AS rdv_vhc_date_saisie_3_127, r9_.rdv_vhc_date_rdv_prevu AS rdv_vhc_date_rdv_prevu_128, r9_.id_old AS id_old_129, r9_.is_active AS is_active_130, m10_.id AS id_131, m10_.marque_libele AS marque_libele_132, m10_.id_old AS id_old_133, m10_.ordre AS ordre_134, m11_.id AS id_135, m11_.marque_libele AS marque_libele_136, m11_.ordre AS ordre_137, m12_.id AS id_138, m12_.mdl_libele AS mdl_libele_139, m12_.id_old AS id_old_140, m12_.mdl_ordre AS mdl_ordre_141, m13_.id AS id_142, m13_.mdl_libele AS mdl_libele_143, m13_.mdl_ordre AS mdl_ordre_144, e14_.id AS id_145, e14_.denomination AS denomination_146, t15_.id AS id_147, t15_.tv_libelle AS tv_libelle_148, t15_.tv_moteur AS tv_moteur_149, t15_.tv_md AS tv_md_150, t15_.tv_ensemble AS tv_ensemble_151, t15_.tv_valide AS tv_valide_152, t15_.id_old AS id_old_153, c16_.id AS id_154, c16_.pst_tarif AS pst_tarif_155, c16_.pst_duree AS pst_duree_156, c16_.pst_actif AS pst_actif_157, c16_.pst_afficher AS pst_afficher_158, c16_.pst_couleur AS pst_couleur_159, c16_.pst_ordre AS pst_ordre_160, c16_.id_old AS id_old_161, c16_.paiement_en_ligne AS paiement_en_ligne_162, c16_.message_appel_centre AS message_appel_centre_163, t17_.id AS id_164, t17_.typ_vst_libele AS typ_vst_libele_165, t17_.typ_vst_libele_long AS typ_vst_libele_long_166, t17_.typ_vst_libele_court AS typ_vst_libele_court_167, t17_.typ_vst_couleur AS typ_vst_couleur_168, t17_.id_old AS id_old_169, r0_.centre_id AS centre_id_170, r0_.client_libre_id AS client_libre_id_171, r0_.client_compte_id AS client_compte_id_172, r0_.centre_type_id AS centre_type_id_173, r0_.ligne_id AS ligne_id_174, r0_.partenaire_id AS partenaire_id_175, r0_.utilisateur_id AS utilisateur_id_176, r0_.recurrence_id AS recurrence_id_177, r0_.promotion_id AS promotion_id_178, r0_.coupon_promotion_id AS coupon_promotion_id_179, l1_.centre_type_id AS centre_type_id_180, l1_.centre_groupe_id AS centre_groupe_id_181, c3_.adresse_id AS adresse_id_182, c3_.adresse_facturation_id AS adresse_facturation_id_183, c3_.centre_groupe_id AS centre_groupe_id_184, c3_.centre_type_id AS centre_type_id_185, u4_.centre_groupe_id AS centre_groupe_id_186, r8_.vehicule_id AS vehicule_id_187, r8_.centre_prestation_id AS centre_prestation_id_188, r8_.rendezvous_id AS rendezvous_id_189, r9_.marque_id AS marque_id_190, r9_.modele_id AS modele_id_191, r9_.type_vehicule_id AS type_vehicule_id_192, r9_.client_compte_id AS client_compte_id_193, r9_.energie_id AS energie_id_194, r9_.marque_pl_id AS marque_pl_id_195, r9_.modele_pl_id AS modele_pl_id_196, r9_.marque_cl_id AS marque_cl_id_197, r9_.modele_cl_id AS modele_cl_id_198, m12_.code_marque_id AS code_marque_id_199, m13_.code_marque_cl_id AS code_marque_cl_id_200, t15_.tv_centre_type_id AS tv_centre_type_id_201, t15_.centre_groupe_id AS centre_groupe_id_202, c16_.pst_type_vehicule_id AS pst_type_vehicule_id_203, c16_.pst_type_visite_id AS pst_type_visite_id_204, c16_.centre_groupe_id AS centre_groupe_id_205, t17_.centre_groupe_id AS centre_groupe_id_206 FROM rendezvous r0_ LEFT JOIN centre c18_ ON r0_.centre_id = c18_.id LEFT JOIN ligne l1_ ON r0_.ligne_id = l1_.id LEFT JOIN client_libre c2_ ON r0_.client_libre_id = c2_.id LEFT JOIN client_compte c3_ ON r0_.client_compte_id = c3_.id LEFT JOIN utilisateur u4_ ON r0_.utilisateur_id = u4_.id LEFT JOIN centre_type c5_ ON r0_.centre_type_id = c5_.id LEFT JOIN partenaire p6_ ON r0_.partenaire_id = p6_.id LEFT JOIN rendez_vous_recurrence r7_ ON r0_.recurrence_id = r7_.id LEFT JOIN rendez_vous_infos r8_ ON r0_.id = r8_.rendezvous_id LEFT JOIN rendez_vous_vehicule r9_ ON r8_.vehicule_id = r9_.id LEFT JOIN marque m10_ ON r9_.marque_id = m10_.id LEFT JOIN marque_cl m11_ ON r9_.marque_cl_id = m11_.id LEFT JOIN modele m12_ ON r9_.modele_id = m12_.id LEFT JOIN modele_cl m13_ ON r9_.modele_cl_id = m13_.id LEFT JOIN energie e14_ ON r9_.energie_id = e14_.id LEFT JOIN type_vehicule t15_ ON r9_.type_vehicule_id = t15_.id LEFT JOIN centre_prestation c16_ ON r8_.centre_prestation_id = c16_.id LEFT JOIN type_visite t17_ ON c16_.pst_type_visite_id = t17_.id WHERE c18_.centre_groupe_id = ? AND r0_.rdv_date_heure >= ? AND r0_.rdv_date_heure <= ? ORDER BY r0_.rdv_date_heure ASC SELECT r0_.id AS id_0, r0_.rdv_tarif AS rdv_tarif_1, r0_.rdv_date_heure AS rdv_date_heure_2, r0_.rdv_duree AS rdv_duree_3, r0_.rdv_date_rappel_sms AS rdv_date_rappel_sms_4, r0_.rdv_datetime_timeout AS rdv_datetime_timeout_5, r0_.rdv_timeout AS rdv_timeout_6, r0_.rdv_commentaire AS rdv_commentaire_7, r0_.rdv_demande_rappel_sms AS rdv_demande_rappel_sms_8, r0_.rdv_coupon_cteasy AS rdv_coupon_cteasy_9, r0_.rdv_bon_commande AS rdv_bon_commande_10, r0_.rdv_vehicule_present AS rdv_vehicule_present_11, r0_.rdv_termine AS rdv_termine_12, r0_.rdv_notif_payline AS rdv_notif_payline_13, r0_.rdv_id_auto_planning AS rdv_id_auto_planning_14, r0_.rdv_date_creation AS rdv_date_creation_15, r0_.id_old AS id_old_16, r0_.token_payline AS token_payline_17, r0_.token_rendez_vous AS token_rendez_vous_18, r0_.nombre_modification AS nombre_modification_19, r0_.rdv_color AS rdv_color_20, r0_.rdv_date_modification AS rdv_date_modification_21, r0_.rdv_demande_confirmation_sms AS rdv_demande_confirmation_sms_22, l1_.id AS id_23, l1_.lgn_nom AS lgn_nom_24, l1_.lgn_actif AS lgn_actif_25, l1_.id_old AS id_old_26, l1_.lgn_vl AS lgn_vl_27, l1_.lgn_pl AS lgn_pl_28, l1_.lgn_cl AS lgn_cl_29, l1_.color AS color_30, c2_.id AS id_31, c2_.cl_nom AS cl_nom_32, c2_.cl_prenom AS cl_prenom_33, c2_.cl_email AS cl_email_34, c2_.cl_telephone AS cl_telephone_35, c2_.cl_civilite AS cl_civilite_36, c3_.id AS id_37, c3_.cli_username AS cli_username_38, c3_.cli_is_active AS cli_is_active_39, c3_.cli_password AS cli_password_40, c3_.cli_salt AS cli_salt_41, c3_.cli_nom_societe AS cli_nom_societe_42, c3_.cli_nom AS cli_nom_43, c3_.cli_prenom AS cli_prenom_44, c3_.cli_email AS cli_email_45, c3_.cli_telephone AS cli_telephone_46, c3_.cli_telephone_2 AS cli_telephone_2_47, c3_.cli_fax AS cli_fax_48, c3_.cli_tva AS cli_tva_49, c3_.cli_siren AS cli_siren_50, c3_.cli_cpl AS cli_cpl_51, c3_.cli_nb_jour_alerte_echeance_1 AS cli_nb_jour_alerte_echeance_1_52, c3_.cli_nb_jour_alerte_echeance_2 AS cli_nb_jour_alerte_echeance_2_53, c3_.cli_nb_jour_alerte_echeance_3 AS cli_nb_jour_alerte_echeance_3_54, c3_.cli_nb_jour_alerte_echeance_sms_1 AS cli_nb_jour_alerte_echeance_sms_1_55, c3_.cli_nb_jour_alerte_echeance_sms_2 AS cli_nb_jour_alerte_echeance_sms_2_56, c3_.cli_nb_jour_alerte_echeance_sms_3 AS cli_nb_jour_alerte_echeance_sms_3_57, c3_.cli_contact_1_nom AS cli_contact_1_nom_58, c3_.cli_contact_1_prenom AS cli_contact_1_prenom_59, c3_.cli_contact_1_email AS cli_contact_1_email_60, c3_.cli_contact_1_telephone AS cli_contact_1_telephone_61, c3_.cli_contact_2_nom AS cli_contact_2_nom_62, c3_.cli_contact_2_prenom AS cli_contact_2_prenom_63, c3_.cli_contact_2_email AS cli_contact_2_email_64, c3_.cli_contact_2_telephone AS cli_contact_2_telephone_65, c3_.cli_has_pro_access AS cli_has_pro_access_66, c3_.id_old AS id_old_67, c3_.cli_vl AS cli_vl_68, c3_.cli_pl AS cli_pl_69, c3_.cli_cl AS cli_cl_70, u4_.id AS id_71, u4_.utl_username AS utl_username_72, u4_.utl_password AS utl_password_73, u4_.utl_salt AS utl_salt_74, u4_.utl_prestataire AS utl_prestataire_75, u4_.utl_nom AS utl_nom_76, u4_.utl_prenom AS utl_prenom_77, u4_.utl_is_masked AS utl_is_masked_78, u4_.utl_agrement AS utl_agrement_79, u4_.id_old AS id_old_80, u4_.roles AS roles_81, u4_.utl_email AS utl_email_82, c5_.id AS id_83, c5_.ct_denomination AS ct_denomination_84, c5_.ct_libele_public AS ct_libele_public_85, p6_.id AS id_86, p6_.pa_nom AS pa_nom_87, p6_.pa_logo AS pa_logo_88, p6_.pa_logo_vignette AS pa_logo_vignette_89, p6_.pa_couleur AS pa_couleur_90, p6_.pa_gestion_agenda_autonome AS pa_gestion_agenda_autonome_91, p6_.pa_paiement_obligatoire AS pa_paiement_obligatoire_92, p6_.pa_timeout_reservation AS pa_timeout_reservation_93, p6_.pa_code_ws AS pa_code_ws_94, p6_.id_old AS id_old_95, r7_.id AS id_96, r7_.id_old AS id_old_97, r8_.id AS id_98, r8_.rdv_inf_pv AS rdv_inf_pv_99, r8_.rdv_inf_facture AS rdv_inf_facture_100, r8_.rdv_inf_resultat AS rdv_inf_resultat_101, r8_.rdv_inf_date_ct AS rdv_inf_date_ct_102, r8_.rdv_inf_hdebut_ct AS rdv_inf_hdebut_ct_103, r8_.rdv_inf_hfin_ct AS rdv_inf_hfin_ct_104, r8_.rdv_inf_depot AS rdv_inf_depot_105, r8_.rdv_inf_convoyage AS rdv_inf_convoyage_106, r8_.rdv_inf_pret AS rdv_inf_pret_107, r8_.rdv_inf_date_avis_google_sms AS rdv_inf_date_avis_google_sms_108, r8_.rdv_inf_date_avis_google_email AS rdv_inf_date_avis_google_email_109, r9_.id AS id_110, r9_.rdv_vhc_immatriculation AS rdv_vhc_immatriculation_111, r9_.rdv_vhc_ref_parc AS rdv_vhc_ref_parc_112, r9_.rdv_vhc_num_serie AS rdv_vhc_num_serie_113, r9_.rdv_vhc_description AS rdv_vhc_description_114, r9_.rdv_vhc_date_echeance AS rdv_vhc_date_echeance_115, r9_.rdv_vhc_date_alert_echeance AS rdv_vhc_date_alert_echeance_116, r9_.rdv_vhc_date_chronotachygraphe AS rdv_vhc_date_chronotachygraphe_117, r9_.rdv_vhc_date_limiteur_vitesse AS rdv_vhc_date_limiteur_vitesse_118, r9_.rdv_vhc_type_proprietaire AS rdv_vhc_type_proprietaire_119, r9_.rdv_vhc_nom_client_proprietaire AS rdv_vhc_nom_client_proprietaire_120, r9_.rdv_vhc_prenom_client_proprietaire AS rdv_vhc_prenom_client_proprietaire_121, r9_.rdv_vhc_zone_saisie_1 AS rdv_vhc_zone_saisie_1_122, r9_.rdv_vhc_date_saisie_1 AS rdv_vhc_date_saisie_1_123, r9_.rdv_vhc_zone_saisie_2 AS rdv_vhc_zone_saisie_2_124, r9_.rdv_vhc_date_saisie_2 AS rdv_vhc_date_saisie_2_125, r9_.rdv_vhc_zone_saisie_3 AS rdv_vhc_zone_saisie_3_126, r9_.rdv_vhc_date_saisie_3 AS rdv_vhc_date_saisie_3_127, r9_.rdv_vhc_date_rdv_prevu AS rdv_vhc_date_rdv_prevu_128, r9_.id_old AS id_old_129, r9_.is_active AS is_active_130, m10_.id AS id_131, m10_.marque_libele AS marque_libele_132, m10_.id_old AS id_old_133, m10_.ordre AS ordre_134, m11_.id AS id_135, m11_.marque_libele AS marque_libele_136, m11_.ordre AS ordre_137, m12_.id AS id_138, m12_.mdl_libele AS mdl_libele_139, m12_.id_old AS id_old_140, m12_.mdl_ordre AS mdl_ordre_141, m13_.id AS id_142, m13_.mdl_libele AS mdl_libele_143, m13_.mdl_ordre AS mdl_ordre_144, e14_.id AS id_145, e14_.denomination AS denomination_146, t15_.id AS id_147, t15_.tv_libelle AS tv_libelle_148, t15_.tv_moteur AS tv_moteur_149, t15_.tv_md AS tv_md_150, t15_.tv_ensemble AS tv_ensemble_151, t15_.tv_valide AS tv_valide_152, t15_.id_old AS id_old_153, c16_.id AS id_154, c16_.pst_tarif AS pst_tarif_155, c16_.pst_duree AS pst_duree_156, c16_.pst_actif AS pst_actif_157, c16_.pst_afficher AS pst_afficher_158, c16_.pst_couleur AS pst_couleur_159, c16_.pst_ordre AS pst_ordre_160, c16_.id_old AS id_old_161, c16_.paiement_en_ligne AS paiement_en_ligne_162, c16_.message_appel_centre AS message_appel_centre_163, t17_.id AS id_164, t17_.typ_vst_libele AS typ_vst_libele_165, t17_.typ_vst_libele_long AS typ_vst_libele_long_166, t17_.typ_vst_libele_court AS typ_vst_libele_court_167, t17_.typ_vst_couleur AS typ_vst_couleur_168, t17_.id_old AS id_old_169, r0_.centre_id AS centre_id_170, r0_.client_libre_id AS client_libre_id_171, r0_.client_compte_id AS client_compte_id_172, r0_.centre_type_id AS centre_type_id_173, r0_.ligne_id AS ligne_id_174, r0_.partenaire_id AS partenaire_id_175, r0_.utilisateur_id AS utilisateur_id_176, r0_.recurrence_id AS recurrence_id_177, r0_.promotion_id AS promotion_id_178, r0_.coupon_promotion_id AS coupon_promotion_id_179, l1_.centre_type_id AS centre_type_id_180, l1_.centre_groupe_id AS centre_groupe_id_181, c3_.adresse_id AS adresse_id_182, c3_.adresse_facturation_id AS adresse_facturation_id_183, c3_.centre_groupe_id AS centre_groupe_id_184, c3_.centre_type_id AS centre_type_id_185, u4_.centre_groupe_id AS centre_groupe_id_186, r8_.vehicule_id AS vehicule_id_187, r8_.centre_prestation_id AS centre_prestation_id_188, r8_.rendezvous_id AS rendezvous_id_189, r9_.marque_id AS marque_id_190, r9_.modele_id AS modele_id_191, r9_.type_vehicule_id AS type_vehicule_id_192, r9_.client_compte_id AS client_compte_id_193, r9_.energie_id AS energie_id_194, r9_.marque_pl_id AS marque_pl_id_195, r9_.modele_pl_id AS modele_pl_id_196, r9_.marque_cl_id AS marque_cl_id_197, r9_.modele_cl_id AS modele_cl_id_198, m12_.code_marque_id AS code_marque_id_199, m13_.code_marque_cl_id AS code_marque_cl_id_200, t15_.tv_centre_type_id AS tv_centre_type_id_201, t15_.centre_groupe_id AS centre_groupe_id_202, c16_.pst_type_vehicule_id AS pst_type_vehicule_id_203, c16_.pst_type_visite_id AS pst_type_visite_id_204, c16_.centre_groupe_id AS centre_groupe_id_205, t17_.centre_groupe_id AS centre_groupe_id_206 FROM rendezvous r0_ LEFT JOIN centre c18_ ON r0_.centre_id = c18_.id LEFT JOIN ligne l1_ ON r0_.ligne_id = l1_.id LEFT JOIN client_libre c2_ ON r0_.client_libre_id = c2_.id LEFT JOIN client_compte c3_ ON r0_.client_compte_id = c3_.id LEFT JOIN utilisateur u4_ ON r0_.utilisateur_id = u4_.id LEFT JOIN centre_type c5_ ON r0_.centre_type_id = c5_.id LEFT JOIN partenaire p6_ ON r0_.partenaire_id = p6_.id LEFT JOIN rendez_vous_recurrence r7_ ON r0_.recurrence_id = r7_.id LEFT JOIN rendez_vous_infos r8_ ON r0_.id = r8_.rendezvous_id LEFT JOIN rendez_vous_vehicule r9_ ON r8_.vehicule_id = r9_.id LEFT JOIN marque m10_ ON r9_.marque_id = m10_.id LEFT JOIN marque_cl m11_ ON r9_.marque_cl_id = m11_.id LEFT JOIN modele m12_ ON r9_.modele_id = m12_.id LEFT JOIN modele_cl m13_ ON r9_.modele_cl_id = m13_.id LEFT JOIN energie e14_ ON r9_.energie_id = e14_.id LEFT JOIN type_vehicule t15_ ON r9_.type_vehicule_id = t15_.id LEFT JOIN centre_prestation c16_ ON r8_.centre_prestation_id = c16_.id LEFT JOIN type_visite t17_ ON c16_.pst_type_visite_id = t17_.id WHERE c18_.centre_groupe_id = 1 AND r0_.rdv_date_heure >= '2026-03-30T00:00:00 02:00' AND r0_.rdv_date_heure <= '2026-04-05T00:00:00 02:00' ORDER BY r0_.rdv_date_heure ASC;
2.12 ms (1.51%)	3	SELECT t0.id AS id_1, t0.pc_entete AS pc_entete_2, t0.pc_nom_icone1 AS pc_nom_icone1_3, t0.pc_nom_icone2 AS pc_nom_icone2_4, t0.pc_nom_icone3 AS pc_nom_icone3_5, t0.pc_titre1 AS pc_titre1_6, t0.pc_titre2 AS pc_titre2_7, t0.pc_titre3 AS pc_titre3_8, t0.pc_texte1 AS pc_texte1_9, t0.pc_texte2 AS pc_texte2_10, t0.pc_texte3 AS pc_texte3_11, t0.pc_url_twitter AS pc_url_twitter_12, t0.pc_url_google AS pc_url_google_13, t0.pc_url_facebook AS pc_url_facebook_14, t0.pc_chemin_img_centre AS pc_chemin_img_centre_15, t0.pc_chemin_logo_centre AS pc_chemin_logo_centre_16, t0.pc_affiche_logo AS pc_affiche_logo_17, t0.display_tarif_from_fo AS display_tarif_from_fo_18, t0.display_tarif_from_bo AS display_tarif_from_bo_19, t0.display_tarif_email_from_bo AS display_tarif_email_from_bo_20, t0.display_msg_rdv_move_on_blc_bo AS display_msg_rdv_move_on_blc_bo_21, t0.is_block_rdv AS is_block_rdv_22, t0.can_edit_rdv_without_set_user AS can_edit_rdv_without_set_user_23, t0.nb_hours_block_rdv AS nb_hours_block_rdv_24, t0.nb_hours_before_block_rdv AS nb_hours_before_block_rdv_25, t0.hour_start_block_rdv AS hour_start_block_rdv_26, t0.holidays AS holidays_27, t0.energies AS energies_28, t0.pc_auto_planning_api_key AS pc_auto_planning_api_key_29, t0.pc_affiche_message_info AS pc_affiche_message_info_30, t0.pc_envoi_sms AS pc_envoi_sms_31, t0.pc_rappel_sms AS pc_rappel_sms_32, t0.paiement_en_ligne AS paiement_en_ligne_33, t0.garantie_paiement AS garantie_paiement_34, t0.pc_duree_max_rdv AS pc_duree_max_rdv_35, t0.pc_envoi_notif_rdv AS pc_envoi_notif_rdv_36, t0.pc_telephone_non_obligatoire AS pc_telephone_non_obligatoire_37, t0.pc_conditions_chemin AS pc_conditions_chemin_38, t0.pc_url_instagram AS pc_url_instagram_39, t0.pcg_chemin_fichier AS pcg_chemin_fichier_40, t0.pc_affiche_rdv6_jours AS pc_affiche_rdv6_jours_41, t0.paiement_en_centre AS paiement_en_centre_42, t0.pc_opt_deux_fois AS pc_opt_deux_fois_43, t0.pc_opt_deux_fois_montant AS pc_opt_deux_fois_montant_44, t0.pc_opt_assurance_cv AS pc_opt_assurance_cv_45, t0.pc_opt_assurance_cv_montant AS pc_opt_assurance_cv_montant_46, t0.pc_opt_rdv_modifiable AS pc_opt_rdv_modifiable_47, t0.pc_opt_rdv_modifiable_montant AS pc_opt_rdv_modifiable_montant_48, t0.pc_google_buisness AS pc_google_buisness_49, t0.pc_avis_google AS pc_avis_google_50, t0.pc_time_before_rdv AS pc_time_before_rdv_51, t0.pc_utl_default AS pc_utl_default_52, t0.pc_aff_percent AS pc_aff_percent_53, t0.pc_aff_montant AS pc_aff_montant_54, t0.pc_force_immat AS pc_force_immat_55, t0.pc_code_promo AS pc_code_promo_56, t0.pc_message_conf_sms AS pc_message_conf_sms_57, t0.pc_message_rappel_sms AS pc_message_rappel_sms_58, t0.pc_message_annul_sms AS pc_message_annul_sms_59, t0.pc_envoi_sms_avis AS pc_envoi_sms_avis_60, t0.pc_message_avis_google_sms AS pc_message_avis_google_sms_61, t0.pc_envoi_email_avis AS pc_envoi_email_avis_62, t0.pc_envoi_sms_confirm AS pc_envoi_sms_confirm_63, t0.pc_email_conf_custom AS pc_email_conf_custom_64, t65.id AS id_66, t65.ctr_nom AS ctr_nom_67, t65.ctr_telephone AS ctr_telephone_68, t65.ctr_email AS ctr_email_69, t65.ctr_fax AS ctr_fax_70, t65.ctr_agrement AS ctr_agrement_71, t65.id_old AS id_old_72, t65.ctr_adresse_id AS ctr_adresse_id_73, t65.centre_groupe_id AS centre_groupe_id_74, t65.centre_type_id AS centre_type_id_75, t65.ctr_parametre_centre_id AS ctr_parametre_centre_id_76, t65.ctr_parametre_centre_admin_id AS ctr_parametre_centre_admin_id_77, t0.pc_utl_id AS pc_utl_id_78 FROM parametre_centre t0 LEFT JOIN centre t65 ON t65.ctr_parametre_centre_id = t0.id WHERE t0.id IN (?) Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.pc_entete AS pc_entete_2, t0.pc_nom_icone1 AS pc_nom_icone1_3, t0.pc_nom_icone2 AS pc_nom_icone2_4, t0.pc_nom_icone3 AS pc_nom_icone3_5, t0.pc_titre1 AS pc_titre1_6, t0.pc_titre2 AS pc_titre2_7, t0.pc_titre3 AS pc_titre3_8, t0.pc_texte1 AS pc_texte1_9, t0.pc_texte2 AS pc_texte2_10, t0.pc_texte3 AS pc_texte3_11, t0.pc_url_twitter AS pc_url_twitter_12, t0.pc_url_google AS pc_url_google_13, t0.pc_url_facebook AS pc_url_facebook_14, t0.pc_chemin_img_centre AS pc_chemin_img_centre_15, t0.pc_chemin_logo_centre AS pc_chemin_logo_centre_16, t0.pc_affiche_logo AS pc_affiche_logo_17, t0.display_tarif_from_fo AS display_tarif_from_fo_18, t0.display_tarif_from_bo AS display_tarif_from_bo_19, t0.display_tarif_email_from_bo AS display_tarif_email_from_bo_20, t0.display_msg_rdv_move_on_blc_bo AS display_msg_rdv_move_on_blc_bo_21, t0.is_block_rdv AS is_block_rdv_22, t0.can_edit_rdv_without_set_user AS can_edit_rdv_without_set_user_23, t0.nb_hours_block_rdv AS nb_hours_block_rdv_24, t0.nb_hours_before_block_rdv AS nb_hours_before_block_rdv_25, t0.hour_start_block_rdv AS hour_start_block_rdv_26, t0.holidays AS holidays_27, t0.energies AS energies_28, t0.pc_auto_planning_api_key AS pc_auto_planning_api_key_29, t0.pc_affiche_message_info AS pc_affiche_message_info_30, t0.pc_envoi_sms AS pc_envoi_sms_31, t0.pc_rappel_sms AS pc_rappel_sms_32, t0.paiement_en_ligne AS paiement_en_ligne_33, t0.garantie_paiement AS garantie_paiement_34, t0.pc_duree_max_rdv AS pc_duree_max_rdv_35, t0.pc_envoi_notif_rdv AS pc_envoi_notif_rdv_36, t0.pc_telephone_non_obligatoire AS pc_telephone_non_obligatoire_37, t0.pc_conditions_chemin AS pc_conditions_chemin_38, t0.pc_url_instagram AS pc_url_instagram_39, t0.pcg_chemin_fichier AS pcg_chemin_fichier_40, t0.pc_affiche_rdv6_jours AS pc_affiche_rdv6_jours_41, t0.paiement_en_centre AS paiement_en_centre_42, t0.pc_opt_deux_fois AS pc_opt_deux_fois_43, t0.pc_opt_deux_fois_montant AS pc_opt_deux_fois_montant_44, t0.pc_opt_assurance_cv AS pc_opt_assurance_cv_45, t0.pc_opt_assurance_cv_montant AS pc_opt_assurance_cv_montant_46, t0.pc_opt_rdv_modifiable AS pc_opt_rdv_modifiable_47, t0.pc_opt_rdv_modifiable_montant AS pc_opt_rdv_modifiable_montant_48, t0.pc_google_buisness AS pc_google_buisness_49, t0.pc_avis_google AS pc_avis_google_50, t0.pc_time_before_rdv AS pc_time_before_rdv_51, t0.pc_utl_default AS pc_utl_default_52, t0.pc_aff_percent AS pc_aff_percent_53, t0.pc_aff_montant AS pc_aff_montant_54, t0.pc_force_immat AS pc_force_immat_55, t0.pc_code_promo AS pc_code_promo_56, t0.pc_message_conf_sms AS pc_message_conf_sms_57, t0.pc_message_rappel_sms AS pc_message_rappel_sms_58, t0.pc_message_annul_sms AS pc_message_annul_sms_59, t0.pc_envoi_sms_avis AS pc_envoi_sms_avis_60, t0.pc_message_avis_google_sms AS pc_message_avis_google_sms_61, t0.pc_envoi_email_avis AS pc_envoi_email_avis_62, t0.pc_envoi_sms_confirm AS pc_envoi_sms_confirm_63, t0.pc_email_conf_custom AS pc_email_conf_custom_64, t65.id AS id_66, t65.ctr_nom AS ctr_nom_67, t65.ctr_telephone AS ctr_telephone_68, t65.ctr_email AS ctr_email_69, t65.ctr_fax AS ctr_fax_70, t65.ctr_agrement AS ctr_agrement_71, t65.id_old AS id_old_72, t65.ctr_adresse_id AS ctr_adresse_id_73, t65.centre_groupe_id AS centre_groupe_id_74, t65.centre_type_id AS centre_type_id_75, t65.ctr_parametre_centre_id AS ctr_parametre_centre_id_76, t65.ctr_parametre_centre_admin_id AS ctr_parametre_centre_admin_id_77, t0.pc_utl_id AS pc_utl_id_78 FROM parametre_centre t0 LEFT JOIN centre t65 ON t65.ctr_parametre_centre_id = t0.id WHERE t0.id IN (?) SELECT t0.id AS id_1, t0.pc_entete AS pc_entete_2, t0.pc_nom_icone1 AS pc_nom_icone1_3, t0.pc_nom_icone2 AS pc_nom_icone2_4, t0.pc_nom_icone3 AS pc_nom_icone3_5, t0.pc_titre1 AS pc_titre1_6, t0.pc_titre2 AS pc_titre2_7, t0.pc_titre3 AS pc_titre3_8, t0.pc_texte1 AS pc_texte1_9, t0.pc_texte2 AS pc_texte2_10, t0.pc_texte3 AS pc_texte3_11, t0.pc_url_twitter AS pc_url_twitter_12, t0.pc_url_google AS pc_url_google_13, t0.pc_url_facebook AS pc_url_facebook_14, t0.pc_chemin_img_centre AS pc_chemin_img_centre_15, t0.pc_chemin_logo_centre AS pc_chemin_logo_centre_16, t0.pc_affiche_logo AS pc_affiche_logo_17, t0.display_tarif_from_fo AS display_tarif_from_fo_18, t0.display_tarif_from_bo AS display_tarif_from_bo_19, t0.display_tarif_email_from_bo AS display_tarif_email_from_bo_20, t0.display_msg_rdv_move_on_blc_bo AS display_msg_rdv_move_on_blc_bo_21, t0.is_block_rdv AS is_block_rdv_22, t0.can_edit_rdv_without_set_user AS can_edit_rdv_without_set_user_23, t0.nb_hours_block_rdv AS nb_hours_block_rdv_24, t0.nb_hours_before_block_rdv AS nb_hours_before_block_rdv_25, t0.hour_start_block_rdv AS hour_start_block_rdv_26, t0.holidays AS holidays_27, t0.energies AS energies_28, t0.pc_auto_planning_api_key AS pc_auto_planning_api_key_29, t0.pc_affiche_message_info AS pc_affiche_message_info_30, t0.pc_envoi_sms AS pc_envoi_sms_31, t0.pc_rappel_sms AS pc_rappel_sms_32, t0.paiement_en_ligne AS paiement_en_ligne_33, t0.garantie_paiement AS garantie_paiement_34, t0.pc_duree_max_rdv AS pc_duree_max_rdv_35, t0.pc_envoi_notif_rdv AS pc_envoi_notif_rdv_36, t0.pc_telephone_non_obligatoire AS pc_telephone_non_obligatoire_37, t0.pc_conditions_chemin AS pc_conditions_chemin_38, t0.pc_url_instagram AS pc_url_instagram_39, t0.pcg_chemin_fichier AS pcg_chemin_fichier_40, t0.pc_affiche_rdv6_jours AS pc_affiche_rdv6_jours_41, t0.paiement_en_centre AS paiement_en_centre_42, t0.pc_opt_deux_fois AS pc_opt_deux_fois_43, t0.pc_opt_deux_fois_montant AS pc_opt_deux_fois_montant_44, t0.pc_opt_assurance_cv AS pc_opt_assurance_cv_45, t0.pc_opt_assurance_cv_montant AS pc_opt_assurance_cv_montant_46, t0.pc_opt_rdv_modifiable AS pc_opt_rdv_modifiable_47, t0.pc_opt_rdv_modifiable_montant AS pc_opt_rdv_modifiable_montant_48, t0.pc_google_buisness AS pc_google_buisness_49, t0.pc_avis_google AS pc_avis_google_50, t0.pc_time_before_rdv AS pc_time_before_rdv_51, t0.pc_utl_default AS pc_utl_default_52, t0.pc_aff_percent AS pc_aff_percent_53, t0.pc_aff_montant AS pc_aff_montant_54, t0.pc_force_immat AS pc_force_immat_55, t0.pc_code_promo AS pc_code_promo_56, t0.pc_message_conf_sms AS pc_message_conf_sms_57, t0.pc_message_rappel_sms AS pc_message_rappel_sms_58, t0.pc_message_annul_sms AS pc_message_annul_sms_59, t0.pc_envoi_sms_avis AS pc_envoi_sms_avis_60, t0.pc_message_avis_google_sms AS pc_message_avis_google_sms_61, t0.pc_envoi_email_avis AS pc_envoi_email_avis_62, t0.pc_envoi_sms_confirm AS pc_envoi_sms_confirm_63, t0.pc_email_conf_custom AS pc_email_conf_custom_64, t65.id AS id_66, t65.ctr_nom AS ctr_nom_67, t65.ctr_telephone AS ctr_telephone_68, t65.ctr_email AS ctr_email_69, t65.ctr_fax AS ctr_fax_70, t65.ctr_agrement AS ctr_agrement_71, t65.id_old AS id_old_72, t65.ctr_adresse_id AS ctr_adresse_id_73, t65.centre_groupe_id AS centre_groupe_id_74, t65.centre_type_id AS centre_type_id_75, t65.ctr_parametre_centre_id AS ctr_parametre_centre_id_76, t65.ctr_parametre_centre_admin_id AS ctr_parametre_centre_admin_id_77, t0.pc_utl_id AS pc_utl_id_78 FROM parametre_centre t0 LEFT JOIN centre t65 ON t65.ctr_parametre_centre_id = t0.id WHERE t0.id IN (1);
1.96 ms (1.40%)	1	SELECT p0_.id AS id_0, p0_.pcg_display_creneau_dispo_bo AS pcg_display_creneau_dispo_bo_1, p0_.pcg_presta_web AS pcg_presta_web_2, p0_.pcg_url AS pcg_url_3, p0_.pcg_blocage_bg_color AS pcg_blocage_bg_color_4, p0_.pcg_rdv_recurrence_bg_color AS pcg_rdv_recurrence_bg_color_5, p0_.pcg_info_bandeau AS pcg_info_bandeau_6, p0_.pcg_color_info_paiement_text AS pcg_color_info_paiement_text_7, p0_.pcg_color_info_paiement_border AS pcg_color_info_paiement_border_8, p0_.pcg_color_info_paiement_bg AS pcg_color_info_paiement_bg_9, p0_.pcg_info_message1 AS pcg_info_message1_10, p0_.pcg_info_message1_color_text AS pcg_info_message1_color_text_11, p0_.pcg_info_message1_color_border AS pcg_info_message1_color_border_12, p0_.pcg_info_message1_color_bg AS pcg_info_message1_color_bg_13, p0_.pcg_info_message1_color_cligno AS pcg_info_message1_color_cligno_14, p0_.pcg_info_message2 AS pcg_info_message2_15, p0_.pcg_info_message2_color_text AS pcg_info_message2_color_text_16, p0_.pcg_info_message2_color_border AS pcg_info_message2_color_border_17, p0_.pcg_info_message2_color_bg AS pcg_info_message2_color_bg_18, p0_.pcg_info_message2_color_cligno AS pcg_info_message2_color_cligno_19, p0_.pcg_info_message_email AS pcg_info_message_email_20, p0_.pcg_visuel_logo_nom AS pcg_visuel_logo_nom_21, p0_.pcg_visuel_logo_alt AS pcg_visuel_logo_alt_22, p0_.pcg_visuel_img_centre_nom AS pcg_visuel_img_centre_nom_23, p0_.pcg_en_savoir_plus AS pcg_en_savoir_plus_24, p0_.pcg_accueil_titre AS pcg_accueil_titre_25, p0_.pcg_accueil_meta_description AS pcg_accueil_meta_description_26, p0_.pcg_accueil_meta_keywords AS pcg_accueil_meta_keywords_27, p0_.pcg_accueil_h2 AS pcg_accueil_h2_28, p0_.pcg_reservation_titre AS pcg_reservation_titre_29, p0_.pcg_reservation_meta_description AS pcg_reservation_meta_description_30, p0_.pcg_reservation_meta_keywords AS pcg_reservation_meta_keywords_31, p0_.pcg_type_visite AS pcg_type_visite_32, p0_.pcg_pyl_bo_cartouche_cal_client_first AS pcg_pyl_bo_cartouche_cal_client_first_33, p0_.pcg_google_analytics AS pcg_google_analytics_34, p0_.pcg_google_analytics_2 AS pcg_google_analytics_2_35, p0_.pcg_google_analytics_3 AS pcg_google_analytics_3_36, p0_.pcg_chemin_logo AS pcg_chemin_logo_37, p0_.pcg_taille_logo AS pcg_taille_logo_38, p0_.pcg_url2 AS pcg_url2_39, p0_.pcg_heure_debut_calendar AS pcg_heure_debut_calendar_40, p0_.pcg_heure_fin_calendar AS pcg_heure_fin_calendar_41, p0_.pcg_info_bulle AS pcg_info_bulle_42, p0_.pcg_redirect_calendar AS pcg_redirect_calendar_43, p0_.pcg_rdv_client_not_honored AS pcg_rdv_client_not_honored_44, p0_.pcg_mediateur_nom AS pcg_mediateur_nom_45, p0_.pcg_mediateur_site AS pcg_mediateur_site_46, p0_.pcg_mediateur_adresse AS pcg_mediateur_adresse_47, p0_.centre_groupe_id AS centre_groupe_id_48 FROM parametre_centre_groupe p0_ WHERE p0_.pcg_url = ? OR p0_.pcg_url2 = ? ORDER BY p0_.id ASC Parameters: [`"mercureweb2-07.autobilan-systems.com" "mercureweb2-07.autobilan-systems.com"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.pcg_display_creneau_dispo_bo AS pcg_display_creneau_dispo_bo_1, p0_.pcg_presta_web AS pcg_presta_web_2, p0_.pcg_url AS pcg_url_3, p0_.pcg_blocage_bg_color AS pcg_blocage_bg_color_4, p0_.pcg_rdv_recurrence_bg_color AS pcg_rdv_recurrence_bg_color_5, p0_.pcg_info_bandeau AS pcg_info_bandeau_6, p0_.pcg_color_info_paiement_text AS pcg_color_info_paiement_text_7, p0_.pcg_color_info_paiement_border AS pcg_color_info_paiement_border_8, p0_.pcg_color_info_paiement_bg AS pcg_color_info_paiement_bg_9, p0_.pcg_info_message1 AS pcg_info_message1_10, p0_.pcg_info_message1_color_text AS pcg_info_message1_color_text_11, p0_.pcg_info_message1_color_border AS pcg_info_message1_color_border_12, p0_.pcg_info_message1_color_bg AS pcg_info_message1_color_bg_13, p0_.pcg_info_message1_color_cligno AS pcg_info_message1_color_cligno_14, p0_.pcg_info_message2 AS pcg_info_message2_15, p0_.pcg_info_message2_color_text AS pcg_info_message2_color_text_16, p0_.pcg_info_message2_color_border AS pcg_info_message2_color_border_17, p0_.pcg_info_message2_color_bg AS pcg_info_message2_color_bg_18, p0_.pcg_info_message2_color_cligno AS pcg_info_message2_color_cligno_19, p0_.pcg_info_message_email AS pcg_info_message_email_20, p0_.pcg_visuel_logo_nom AS pcg_visuel_logo_nom_21, p0_.pcg_visuel_logo_alt AS pcg_visuel_logo_alt_22, p0_.pcg_visuel_img_centre_nom AS pcg_visuel_img_centre_nom_23, p0_.pcg_en_savoir_plus AS pcg_en_savoir_plus_24, p0_.pcg_accueil_titre AS pcg_accueil_titre_25, p0_.pcg_accueil_meta_description AS pcg_accueil_meta_description_26, p0_.pcg_accueil_meta_keywords AS pcg_accueil_meta_keywords_27, p0_.pcg_accueil_h2 AS pcg_accueil_h2_28, p0_.pcg_reservation_titre AS pcg_reservation_titre_29, p0_.pcg_reservation_meta_description AS pcg_reservation_meta_description_30, p0_.pcg_reservation_meta_keywords AS pcg_reservation_meta_keywords_31, p0_.pcg_type_visite AS pcg_type_visite_32, p0_.pcg_pyl_bo_cartouche_cal_client_first AS pcg_pyl_bo_cartouche_cal_client_first_33, p0_.pcg_google_analytics AS pcg_google_analytics_34, p0_.pcg_google_analytics_2 AS pcg_google_analytics_2_35, p0_.pcg_google_analytics_3 AS pcg_google_analytics_3_36, p0_.pcg_chemin_logo AS pcg_chemin_logo_37, p0_.pcg_taille_logo AS pcg_taille_logo_38, p0_.pcg_url2 AS pcg_url2_39, p0_.pcg_heure_debut_calendar AS pcg_heure_debut_calendar_40, p0_.pcg_heure_fin_calendar AS pcg_heure_fin_calendar_41, p0_.pcg_info_bulle AS pcg_info_bulle_42, p0_.pcg_redirect_calendar AS pcg_redirect_calendar_43, p0_.pcg_rdv_client_not_honored AS pcg_rdv_client_not_honored_44, p0_.pcg_mediateur_nom AS pcg_mediateur_nom_45, p0_.pcg_mediateur_site AS pcg_mediateur_site_46, p0_.pcg_mediateur_adresse AS pcg_mediateur_adresse_47, p0_.centre_groupe_id AS centre_groupe_id_48 FROM parametre_centre_groupe p0_ WHERE p0_.pcg_url = ? OR p0_.pcg_url2 = ? ORDER BY p0_.id ASC SELECT p0_.id AS id_0, p0_.pcg_display_creneau_dispo_bo AS pcg_display_creneau_dispo_bo_1, p0_.pcg_presta_web AS pcg_presta_web_2, p0_.pcg_url AS pcg_url_3, p0_.pcg_blocage_bg_color AS pcg_blocage_bg_color_4, p0_.pcg_rdv_recurrence_bg_color AS pcg_rdv_recurrence_bg_color_5, p0_.pcg_info_bandeau AS pcg_info_bandeau_6, p0_.pcg_color_info_paiement_text AS pcg_color_info_paiement_text_7, p0_.pcg_color_info_paiement_border AS pcg_color_info_paiement_border_8, p0_.pcg_color_info_paiement_bg AS pcg_color_info_paiement_bg_9, p0_.pcg_info_message1 AS pcg_info_message1_10, p0_.pcg_info_message1_color_text AS pcg_info_message1_color_text_11, p0_.pcg_info_message1_color_border AS pcg_info_message1_color_border_12, p0_.pcg_info_message1_color_bg AS pcg_info_message1_color_bg_13, p0_.pcg_info_message1_color_cligno AS pcg_info_message1_color_cligno_14, p0_.pcg_info_message2 AS pcg_info_message2_15, p0_.pcg_info_message2_color_text AS pcg_info_message2_color_text_16, p0_.pcg_info_message2_color_border AS pcg_info_message2_color_border_17, p0_.pcg_info_message2_color_bg AS pcg_info_message2_color_bg_18, p0_.pcg_info_message2_color_cligno AS pcg_info_message2_color_cligno_19, p0_.pcg_info_message_email AS pcg_info_message_email_20, p0_.pcg_visuel_logo_nom AS pcg_visuel_logo_nom_21, p0_.pcg_visuel_logo_alt AS pcg_visuel_logo_alt_22, p0_.pcg_visuel_img_centre_nom AS pcg_visuel_img_centre_nom_23, p0_.pcg_en_savoir_plus AS pcg_en_savoir_plus_24, p0_.pcg_accueil_titre AS pcg_accueil_titre_25, p0_.pcg_accueil_meta_description AS pcg_accueil_meta_description_26, p0_.pcg_accueil_meta_keywords AS pcg_accueil_meta_keywords_27, p0_.pcg_accueil_h2 AS pcg_accueil_h2_28, p0_.pcg_reservation_titre AS pcg_reservation_titre_29, p0_.pcg_reservation_meta_description AS pcg_reservation_meta_description_30, p0_.pcg_reservation_meta_keywords AS pcg_reservation_meta_keywords_31, p0_.pcg_type_visite AS pcg_type_visite_32, p0_.pcg_pyl_bo_cartouche_cal_client_first AS pcg_pyl_bo_cartouche_cal_client_first_33, p0_.pcg_google_analytics AS pcg_google_analytics_34, p0_.pcg_google_analytics_2 AS pcg_google_analytics_2_35, p0_.pcg_google_analytics_3 AS pcg_google_analytics_3_36, p0_.pcg_chemin_logo AS pcg_chemin_logo_37, p0_.pcg_taille_logo AS pcg_taille_logo_38, p0_.pcg_url2 AS pcg_url2_39, p0_.pcg_heure_debut_calendar AS pcg_heure_debut_calendar_40, p0_.pcg_heure_fin_calendar AS pcg_heure_fin_calendar_41, p0_.pcg_info_bulle AS pcg_info_bulle_42, p0_.pcg_redirect_calendar AS pcg_redirect_calendar_43, p0_.pcg_rdv_client_not_honored AS pcg_rdv_client_not_honored_44, p0_.pcg_mediateur_nom AS pcg_mediateur_nom_45, p0_.pcg_mediateur_site AS pcg_mediateur_site_46, p0_.pcg_mediateur_adresse AS pcg_mediateur_adresse_47, p0_.centre_groupe_id AS centre_groupe_id_48 FROM parametre_centre_groupe p0_ WHERE p0_.pcg_url = 'mercureweb2-07.autobilan-systems.com' OR p0_.pcg_url2 = 'mercureweb2-07.autobilan-systems.com' ORDER BY p0_.id ASC;
1.69 ms (1.21%)	3	SELECT t0.id AS id_1, t0.pca_calendrier_remplir_trou AS pca_calendrier_remplir_trou_2, t0.pca_auto_complete_client_vl AS pca_auto_complete_client_vl_3, t0.pca_pyl_merchant_id AS pca_pyl_merchant_id_4, t0.pca_pyl_access_key AS pca_pyl_access_key_5, t0.pca_pyl_contract_number AS pca_pyl_contract_number_6, t0.pca_pyl_environment AS pca_pyl_environment_7, t0.pca_pyl_cancel_url AS pca_pyl_cancel_url_8, t0.pca_pyl_notification_url AS pca_pyl_notification_url_9, t0.pca_pyl_return_url AS pca_pyl_return_url_10, t0.pca_pyl_recurring_billing_cycle AS pca_pyl_recurring_billing_cycle_11, t0.pca_pyl_ws_version AS pca_pyl_ws_version_12, t0.pca_pyl_payment_currency AS pca_pyl_payment_currency_13, t0.pca_pyl_order_currency AS pca_pyl_order_currency_14, t0.pca_pyl_security_mode AS pca_pyl_security_mode_15, t0.pca_pyl_language_code AS pca_pyl_language_code_16, t0.pca_pyl_payment_action AS pca_pyl_payment_action_17, t0.pca_pyl_payment_mode AS pca_pyl_payment_mode_18, t0.pca_pyl_custom_payment_template_url AS pca_pyl_custom_payment_template_url_19, t0.pca_pyl_custom_payment_page_code AS pca_pyl_custom_payment_page_code_20, t0.pca_pyl_contract_number_list AS pca_pyl_contract_number_list_21, t0.pca_pyl_acces_key_ref AS pca_pyl_acces_key_ref_22, t0.pca_pyl_proxy_host AS pca_pyl_proxy_host_23, t0.pca_pyl_proxy_port AS pca_pyl_proxy_port_24, t0.pca_pyl_proxy_login AS pca_pyl_proxy_login_25, t0.pca_pyl_proxy_password AS pca_pyl_proxy_password_26, t0.pca_pyl_pym_opt_deux_fois AS pca_pyl_pym_opt_deux_fois_27, t0.pca_pyl_pym_opt_assurance_cv AS pca_pyl_pym_opt_assurance_cv_28, t0.pca_pyl_pym_opt_rdv_modifiable AS pca_pyl_pym_opt_rdv_modifiable_29, t0.pca_duree_promo AS pca_duree_promo_30, t0.pca_actif AS pca_actif_31, t0.pca_iban_lemonway AS pca_iban_lemonway_32, t33.id AS id_34, t33.ctr_nom AS ctr_nom_35, t33.ctr_telephone AS ctr_telephone_36, t33.ctr_email AS ctr_email_37, t33.ctr_fax AS ctr_fax_38, t33.ctr_agrement AS ctr_agrement_39, t33.id_old AS id_old_40, t33.ctr_adresse_id AS ctr_adresse_id_41, t33.centre_groupe_id AS centre_groupe_id_42, t33.centre_type_id AS centre_type_id_43, t33.ctr_parametre_centre_id AS ctr_parametre_centre_id_44, t33.ctr_parametre_centre_admin_id AS ctr_parametre_centre_admin_id_45 FROM parametre_centre_admin t0 LEFT JOIN centre t33 ON t33.ctr_parametre_centre_admin_id = t0.id WHERE t0.id IN (?) Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.pca_calendrier_remplir_trou AS pca_calendrier_remplir_trou_2, t0.pca_auto_complete_client_vl AS pca_auto_complete_client_vl_3, t0.pca_pyl_merchant_id AS pca_pyl_merchant_id_4, t0.pca_pyl_access_key AS pca_pyl_access_key_5, t0.pca_pyl_contract_number AS pca_pyl_contract_number_6, t0.pca_pyl_environment AS pca_pyl_environment_7, t0.pca_pyl_cancel_url AS pca_pyl_cancel_url_8, t0.pca_pyl_notification_url AS pca_pyl_notification_url_9, t0.pca_pyl_return_url AS pca_pyl_return_url_10, t0.pca_pyl_recurring_billing_cycle AS pca_pyl_recurring_billing_cycle_11, t0.pca_pyl_ws_version AS pca_pyl_ws_version_12, t0.pca_pyl_payment_currency AS pca_pyl_payment_currency_13, t0.pca_pyl_order_currency AS pca_pyl_order_currency_14, t0.pca_pyl_security_mode AS pca_pyl_security_mode_15, t0.pca_pyl_language_code AS pca_pyl_language_code_16, t0.pca_pyl_payment_action AS pca_pyl_payment_action_17, t0.pca_pyl_payment_mode AS pca_pyl_payment_mode_18, t0.pca_pyl_custom_payment_template_url AS pca_pyl_custom_payment_template_url_19, t0.pca_pyl_custom_payment_page_code AS pca_pyl_custom_payment_page_code_20, t0.pca_pyl_contract_number_list AS pca_pyl_contract_number_list_21, t0.pca_pyl_acces_key_ref AS pca_pyl_acces_key_ref_22, t0.pca_pyl_proxy_host AS pca_pyl_proxy_host_23, t0.pca_pyl_proxy_port AS pca_pyl_proxy_port_24, t0.pca_pyl_proxy_login AS pca_pyl_proxy_login_25, t0.pca_pyl_proxy_password AS pca_pyl_proxy_password_26, t0.pca_pyl_pym_opt_deux_fois AS pca_pyl_pym_opt_deux_fois_27, t0.pca_pyl_pym_opt_assurance_cv AS pca_pyl_pym_opt_assurance_cv_28, t0.pca_pyl_pym_opt_rdv_modifiable AS pca_pyl_pym_opt_rdv_modifiable_29, t0.pca_duree_promo AS pca_duree_promo_30, t0.pca_actif AS pca_actif_31, t0.pca_iban_lemonway AS pca_iban_lemonway_32, t33.id AS id_34, t33.ctr_nom AS ctr_nom_35, t33.ctr_telephone AS ctr_telephone_36, t33.ctr_email AS ctr_email_37, t33.ctr_fax AS ctr_fax_38, t33.ctr_agrement AS ctr_agrement_39, t33.id_old AS id_old_40, t33.ctr_adresse_id AS ctr_adresse_id_41, t33.centre_groupe_id AS centre_groupe_id_42, t33.centre_type_id AS centre_type_id_43, t33.ctr_parametre_centre_id AS ctr_parametre_centre_id_44, t33.ctr_parametre_centre_admin_id AS ctr_parametre_centre_admin_id_45 FROM parametre_centre_admin t0 LEFT JOIN centre t33 ON t33.ctr_parametre_centre_admin_id = t0.id WHERE t0.id IN (?) SELECT t0.id AS id_1, t0.pca_calendrier_remplir_trou AS pca_calendrier_remplir_trou_2, t0.pca_auto_complete_client_vl AS pca_auto_complete_client_vl_3, t0.pca_pyl_merchant_id AS pca_pyl_merchant_id_4, t0.pca_pyl_access_key AS pca_pyl_access_key_5, t0.pca_pyl_contract_number AS pca_pyl_contract_number_6, t0.pca_pyl_environment AS pca_pyl_environment_7, t0.pca_pyl_cancel_url AS pca_pyl_cancel_url_8, t0.pca_pyl_notification_url AS pca_pyl_notification_url_9, t0.pca_pyl_return_url AS pca_pyl_return_url_10, t0.pca_pyl_recurring_billing_cycle AS pca_pyl_recurring_billing_cycle_11, t0.pca_pyl_ws_version AS pca_pyl_ws_version_12, t0.pca_pyl_payment_currency AS pca_pyl_payment_currency_13, t0.pca_pyl_order_currency AS pca_pyl_order_currency_14, t0.pca_pyl_security_mode AS pca_pyl_security_mode_15, t0.pca_pyl_language_code AS pca_pyl_language_code_16, t0.pca_pyl_payment_action AS pca_pyl_payment_action_17, t0.pca_pyl_payment_mode AS pca_pyl_payment_mode_18, t0.pca_pyl_custom_payment_template_url AS pca_pyl_custom_payment_template_url_19, t0.pca_pyl_custom_payment_page_code AS pca_pyl_custom_payment_page_code_20, t0.pca_pyl_contract_number_list AS pca_pyl_contract_number_list_21, t0.pca_pyl_acces_key_ref AS pca_pyl_acces_key_ref_22, t0.pca_pyl_proxy_host AS pca_pyl_proxy_host_23, t0.pca_pyl_proxy_port AS pca_pyl_proxy_port_24, t0.pca_pyl_proxy_login AS pca_pyl_proxy_login_25, t0.pca_pyl_proxy_password AS pca_pyl_proxy_password_26, t0.pca_pyl_pym_opt_deux_fois AS pca_pyl_pym_opt_deux_fois_27, t0.pca_pyl_pym_opt_assurance_cv AS pca_pyl_pym_opt_assurance_cv_28, t0.pca_pyl_pym_opt_rdv_modifiable AS pca_pyl_pym_opt_rdv_modifiable_29, t0.pca_duree_promo AS pca_duree_promo_30, t0.pca_actif AS pca_actif_31, t0.pca_iban_lemonway AS pca_iban_lemonway_32, t33.id AS id_34, t33.ctr_nom AS ctr_nom_35, t33.ctr_telephone AS ctr_telephone_36, t33.ctr_email AS ctr_email_37, t33.ctr_fax AS ctr_fax_38, t33.ctr_agrement AS ctr_agrement_39, t33.id_old AS id_old_40, t33.ctr_adresse_id AS ctr_adresse_id_41, t33.centre_groupe_id AS centre_groupe_id_42, t33.centre_type_id AS centre_type_id_43, t33.ctr_parametre_centre_id AS ctr_parametre_centre_id_44, t33.ctr_parametre_centre_admin_id AS ctr_parametre_centre_admin_id_45 FROM parametre_centre_admin t0 LEFT JOIN centre t33 ON t33.ctr_parametre_centre_admin_id = t0.id WHERE t0.id IN (1);
1.62 ms (1.15%)	1	SELECT l0_.id AS id_0, l0_.blc_debut AS blc_debut_1, l0_.blc_fin AS blc_fin_2, l0_.blc_commentaire AS blc_commentaire_3, l0_.blc_auto_planning AS blc_auto_planning_4, l0_.blc_bg_color AS blc_bg_color_5, l0_.ligne_id AS ligne_id_6, l0_.recurrence_id AS recurrence_id_7 FROM ligne_blocage l0_ LEFT JOIN ligne l1_ ON l0_.ligne_id = l1_.id WHERE l1_.centre_groupe_id = ? AND ((l0_.blc_debut BETWEEN ? AND ?) OR (l0_.blc_fin BETWEEN ? AND ?) OR (l0_.blc_debut <= ? AND l0_.blc_fin >= ?)) ORDER BY l0_.id ASC Parameters: [`1 "2026-03-30T00:00:00 02:00" "2026-04-05T00:00:00 02:00" "2026-03-30T00:00:00 02:00" "2026-04-05T00:00:00 02:00" "2026-03-30T00:00:00 02:00" "2026-04-05T00:00:00 02:00"`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, l0_.blc_debut AS blc_debut_1, l0_.blc_fin AS blc_fin_2, l0_.blc_commentaire AS blc_commentaire_3, l0_.blc_auto_planning AS blc_auto_planning_4, l0_.blc_bg_color AS blc_bg_color_5, l0_.ligne_id AS ligne_id_6, l0_.recurrence_id AS recurrence_id_7 FROM ligne_blocage l0_ LEFT JOIN ligne l1_ ON l0_.ligne_id = l1_.id WHERE l1_.centre_groupe_id = ? AND ( ( l0_.blc_debut BETWEEN ? AND ? ) OR ( l0_.blc_fin BETWEEN ? AND ? ) OR ( l0_.blc_debut <= ? AND l0_.blc_fin >= ? ) ) ORDER BY l0_.id ASC SELECT l0_.id AS id_0, l0_.blc_debut AS blc_debut_1, l0_.blc_fin AS blc_fin_2, l0_.blc_commentaire AS blc_commentaire_3, l0_.blc_auto_planning AS blc_auto_planning_4, l0_.blc_bg_color AS blc_bg_color_5, l0_.ligne_id AS ligne_id_6, l0_.recurrence_id AS recurrence_id_7 FROM ligne_blocage l0_ LEFT JOIN ligne l1_ ON l0_.ligne_id = l1_.id WHERE l1_.centre_groupe_id = 1 AND ((l0_.blc_debut BETWEEN '2026-03-30T00:00:00 02:00' AND '2026-04-05T00:00:00 02:00') OR (l0_.blc_fin BETWEEN '2026-03-30T00:00:00 02:00' AND '2026-04-05T00:00:00 02:00') OR (l0_.blc_debut <= '2026-03-30T00:00:00 02:00' AND l0_.blc_fin >= '2026-04-05T00:00:00 02:00')) ORDER BY l0_.id ASC;
1.59 ms (1.13%)	1	SELECT t0.id AS id_1, t0.utl_username AS utl_username_2, t0.utl_password AS utl_password_3, t0.utl_salt AS utl_salt_4, t0.utl_prestataire AS utl_prestataire_5, t0.utl_nom AS utl_nom_6, t0.utl_prenom AS utl_prenom_7, t0.utl_is_masked AS utl_is_masked_8, t0.utl_agrement AS utl_agrement_9, t0.id_old AS id_old_10, t0.roles AS roles_11, t0.utl_email AS utl_email_12, t13.id AS id_14, t13.utl_inf_utilisateur_id AS utl_inf_utilisateur_id_15, t13.utl_inf_fonction_id AS utl_inf_fonction_id_16, t0.centre_groupe_id AS centre_groupe_id_17 FROM utilisateur t0 LEFT JOIN utilisateur_info t13 ON t13.utl_inf_utilisateur_id = t0.id WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.utl_username AS utl_username_2, t0.utl_password AS utl_password_3, t0.utl_salt AS utl_salt_4, t0.utl_prestataire AS utl_prestataire_5, t0.utl_nom AS utl_nom_6, t0.utl_prenom AS utl_prenom_7, t0.utl_is_masked AS utl_is_masked_8, t0.utl_agrement AS utl_agrement_9, t0.id_old AS id_old_10, t0.roles AS roles_11, t0.utl_email AS utl_email_12, t13.id AS id_14, t13.utl_inf_utilisateur_id AS utl_inf_utilisateur_id_15, t13.utl_inf_fonction_id AS utl_inf_fonction_id_16, t0.centre_groupe_id AS centre_groupe_id_17 FROM utilisateur t0 LEFT JOIN utilisateur_info t13 ON t13.utl_inf_utilisateur_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.utl_username AS utl_username_2, t0.utl_password AS utl_password_3, t0.utl_salt AS utl_salt_4, t0.utl_prestataire AS utl_prestataire_5, t0.utl_nom AS utl_nom_6, t0.utl_prenom AS utl_prenom_7, t0.utl_is_masked AS utl_is_masked_8, t0.utl_agrement AS utl_agrement_9, t0.id_old AS id_old_10, t0.roles AS roles_11, t0.utl_email AS utl_email_12, t13.id AS id_14, t13.utl_inf_utilisateur_id AS utl_inf_utilisateur_id_15, t13.utl_inf_fonction_id AS utl_inf_fonction_id_16, t0.centre_groupe_id AS centre_groupe_id_17 FROM utilisateur t0 LEFT JOIN utilisateur_info t13 ON t13.utl_inf_utilisateur_id = t0.id WHERE t0.id = 1;
1.54 ms (1.10%)	3	SELECT t0.id AS id_1, t0.lgn_hor_debut AS lgn_hor_debut_2, t0.lgn_hor_fin AS lgn_hor_fin_3, t0.lgn_hor_ouvert AS lgn_hor_ouvert_4, t0.lgn_hor_liste_jours AS lgn_hor_liste_jours_5, t0.ligne_id AS ligne_id_6 FROM ligne_horaire t0 WHERE t0.ligne_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.lgn_hor_debut AS lgn_hor_debut_2, t0.lgn_hor_fin AS lgn_hor_fin_3, t0.lgn_hor_ouvert AS lgn_hor_ouvert_4, t0.lgn_hor_liste_jours AS lgn_hor_liste_jours_5, t0.ligne_id AS ligne_id_6 FROM ligne_horaire t0 WHERE t0.ligne_id = ? SELECT t0.id AS id_1, t0.lgn_hor_debut AS lgn_hor_debut_2, t0.lgn_hor_fin AS lgn_hor_fin_3, t0.lgn_hor_ouvert AS lgn_hor_ouvert_4, t0.lgn_hor_liste_jours AS lgn_hor_liste_jours_5, t0.ligne_id AS ligne_id_6 FROM ligne_horaire t0 WHERE t0.ligne_id = 1;
1.44 ms (1.03%)	1	SELECT t0.id AS id_1, t0.cg_nom AS cg_nom_2, t0.cg_pas_horaires AS cg_pas_horaires_3, t0.cg_actif AS cg_actif_4, t0.cg_stay_to_date_rdv AS cg_stay_to_date_rdv_5, t0.id_old AS id_old_6, t0.cg_serveur AS cg_serveur_7, t8.id AS id_9, t8.pst_tarif AS pst_tarif_10, t8.pst_duree AS pst_duree_11, t8.pst_actif AS pst_actif_12, t8.pst_afficher AS pst_afficher_13, t8.pst_couleur AS pst_couleur_14, t8.pst_ordre AS pst_ordre_15, t8.id_old AS id_old_16, t8.paiement_en_ligne AS paiement_en_ligne_17, t8.message_appel_centre AS message_appel_centre_18, t8.pst_type_vehicule_id AS pst_type_vehicule_id_19, t8.pst_type_visite_id AS pst_type_visite_id_20, t8.centre_groupe_id AS centre_groupe_id_21, t0.cg_gerant_id AS cg_gerant_id_22, t0.centre_groupe_css_id AS centre_groupe_css_id_23, t24.id AS id_25, t24.bg1 AS bg1_26, t24.color1 AS color1_27, t24.color2 AS color2_28, t24.bg2 AS bg2_29, t24.bg3 AS bg3_30, t24.color3 AS color3_31, t24.nom AS nom_32, t33.id AS id_34, t33.ctr_nom AS ctr_nom_35, t33.ctr_telephone AS ctr_telephone_36, t33.ctr_email AS ctr_email_37, t33.ctr_fax AS ctr_fax_38, t33.ctr_agrement AS ctr_agrement_39, t33.id_old AS id_old_40, t33.ctr_adresse_id AS ctr_adresse_id_41, t33.centre_groupe_id AS centre_groupe_id_42, t33.centre_type_id AS centre_type_id_43, t33.ctr_parametre_centre_id AS ctr_parametre_centre_id_44, t33.ctr_parametre_centre_admin_id AS ctr_parametre_centre_admin_id_45 FROM centre_groupe t0 LEFT JOIN centre_prestation t8 ON t8.centre_groupe_id = t0.id LEFT JOIN centre_groupe_css t24 ON t0.centre_groupe_css_id = t24.id LEFT JOIN centre t33 ON t33.centre_groupe_id = t0.id WHERE t0.id IN (?) Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.cg_nom AS cg_nom_2, t0.cg_pas_horaires AS cg_pas_horaires_3, t0.cg_actif AS cg_actif_4, t0.cg_stay_to_date_rdv AS cg_stay_to_date_rdv_5, t0.id_old AS id_old_6, t0.cg_serveur AS cg_serveur_7, t8.id AS id_9, t8.pst_tarif AS pst_tarif_10, t8.pst_duree AS pst_duree_11, t8.pst_actif AS pst_actif_12, t8.pst_afficher AS pst_afficher_13, t8.pst_couleur AS pst_couleur_14, t8.pst_ordre AS pst_ordre_15, t8.id_old AS id_old_16, t8.paiement_en_ligne AS paiement_en_ligne_17, t8.message_appel_centre AS message_appel_centre_18, t8.pst_type_vehicule_id AS pst_type_vehicule_id_19, t8.pst_type_visite_id AS pst_type_visite_id_20, t8.centre_groupe_id AS centre_groupe_id_21, t0.cg_gerant_id AS cg_gerant_id_22, t0.centre_groupe_css_id AS centre_groupe_css_id_23, t24.id AS id_25, t24.bg1 AS bg1_26, t24.color1 AS color1_27, t24.color2 AS color2_28, t24.bg2 AS bg2_29, t24.bg3 AS bg3_30, t24.color3 AS color3_31, t24.nom AS nom_32, t33.id AS id_34, t33.ctr_nom AS ctr_nom_35, t33.ctr_telephone AS ctr_telephone_36, t33.ctr_email AS ctr_email_37, t33.ctr_fax AS ctr_fax_38, t33.ctr_agrement AS ctr_agrement_39, t33.id_old AS id_old_40, t33.ctr_adresse_id AS ctr_adresse_id_41, t33.centre_groupe_id AS centre_groupe_id_42, t33.centre_type_id AS centre_type_id_43, t33.ctr_parametre_centre_id AS ctr_parametre_centre_id_44, t33.ctr_parametre_centre_admin_id AS ctr_parametre_centre_admin_id_45 FROM centre_groupe t0 LEFT JOIN centre_prestation t8 ON t8.centre_groupe_id = t0.id LEFT JOIN centre_groupe_css t24 ON t0.centre_groupe_css_id = t24.id LEFT JOIN centre t33 ON t33.centre_groupe_id = t0.id WHERE t0.id IN (?) SELECT t0.id AS id_1, t0.cg_nom AS cg_nom_2, t0.cg_pas_horaires AS cg_pas_horaires_3, t0.cg_actif AS cg_actif_4, t0.cg_stay_to_date_rdv AS cg_stay_to_date_rdv_5, t0.id_old AS id_old_6, t0.cg_serveur AS cg_serveur_7, t8.id AS id_9, t8.pst_tarif AS pst_tarif_10, t8.pst_duree AS pst_duree_11, t8.pst_actif AS pst_actif_12, t8.pst_afficher AS pst_afficher_13, t8.pst_couleur AS pst_couleur_14, t8.pst_ordre AS pst_ordre_15, t8.id_old AS id_old_16, t8.paiement_en_ligne AS paiement_en_ligne_17, t8.message_appel_centre AS message_appel_centre_18, t8.pst_type_vehicule_id AS pst_type_vehicule_id_19, t8.pst_type_visite_id AS pst_type_visite_id_20, t8.centre_groupe_id AS centre_groupe_id_21, t0.cg_gerant_id AS cg_gerant_id_22, t0.centre_groupe_css_id AS centre_groupe_css_id_23, t24.id AS id_25, t24.bg1 AS bg1_26, t24.color1 AS color1_27, t24.color2 AS color2_28, t24.bg2 AS bg2_29, t24.bg3 AS bg3_30, t24.color3 AS color3_31, t24.nom AS nom_32, t33.id AS id_34, t33.ctr_nom AS ctr_nom_35, t33.ctr_telephone AS ctr_telephone_36, t33.ctr_email AS ctr_email_37, t33.ctr_fax AS ctr_fax_38, t33.ctr_agrement AS ctr_agrement_39, t33.id_old AS id_old_40, t33.ctr_adresse_id AS ctr_adresse_id_41, t33.centre_groupe_id AS centre_groupe_id_42, t33.centre_type_id AS centre_type_id_43, t33.ctr_parametre_centre_id AS ctr_parametre_centre_id_44, t33.ctr_parametre_centre_admin_id AS ctr_parametre_centre_admin_id_45 FROM centre_groupe t0 LEFT JOIN centre_prestation t8 ON t8.centre_groupe_id = t0.id LEFT JOIN centre_groupe_css t24 ON t0.centre_groupe_css_id = t24.id LEFT JOIN centre t33 ON t33.centre_groupe_id = t0.id WHERE t0.id IN (1);
1.26 ms (0.90%)	3	SELECT t0.id AS id_1, t0.ctr_hor_debut AS ctr_hor_debut_2, t0.ctr_hor_fin AS ctr_hor_fin_3, t0.ctr_hor_ouvert AS ctr_hor_ouvert_4, t0.ctr_hor_jour_continue AS ctr_hor_jour_continue_5, t0.ctr_hor_jours_semaine AS ctr_hor_jours_semaine_6, t0.centre_id AS centre_id_7 FROM centre_horaire t0 WHERE t0.centre_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.ctr_hor_debut AS ctr_hor_debut_2, t0.ctr_hor_fin AS ctr_hor_fin_3, t0.ctr_hor_ouvert AS ctr_hor_ouvert_4, t0.ctr_hor_jour_continue AS ctr_hor_jour_continue_5, t0.ctr_hor_jours_semaine AS ctr_hor_jours_semaine_6, t0.centre_id AS centre_id_7 FROM centre_horaire t0 WHERE t0.centre_id = ? SELECT t0.id AS id_1, t0.ctr_hor_debut AS ctr_hor_debut_2, t0.ctr_hor_fin AS ctr_hor_fin_3, t0.ctr_hor_ouvert AS ctr_hor_ouvert_4, t0.ctr_hor_jour_continue AS ctr_hor_jour_continue_5, t0.ctr_hor_jours_semaine AS ctr_hor_jours_semaine_6, t0.centre_id AS centre_id_7 FROM centre_horaire t0 WHERE t0.centre_id = 1;
1.00 ms (0.72%)	3	SELECT t0.id AS id_1, t0.adr_coordonnees AS adr_coordonnees_2, t0.adr_code_postal AS adr_code_postal_3, t0.adr_rue AS adr_rue_4, t0.adr_ville AS adr_ville_5, t0.adr_complement AS adr_complement_6 FROM adresse t0 WHERE t0.id IN (?) Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.adr_coordonnees AS adr_coordonnees_2, t0.adr_code_postal AS adr_code_postal_3, t0.adr_rue AS adr_rue_4, t0.adr_ville AS adr_ville_5, t0.adr_complement AS adr_complement_6 FROM adresse t0 WHERE t0.id IN (?) SELECT t0.id AS id_1, t0.adr_coordonnees AS adr_coordonnees_2, t0.adr_code_postal AS adr_code_postal_3, t0.adr_rue AS adr_rue_4, t0.adr_ville AS adr_ville_5, t0.adr_complement AS adr_complement_6 FROM adresse t0 WHERE t0.id IN (1);
0.84 ms (0.60%)	2	SELECT t0.id AS id_1, t0.utl_inf_utilisateur_id AS utl_inf_utilisateur_id_2, t0.utl_inf_fonction_id AS utl_inf_fonction_id_3 FROM utilisateur_info t0 WHERE t0.utl_inf_utilisateur_id = ? Parameters: [`707`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.utl_inf_utilisateur_id AS utl_inf_utilisateur_id_2, t0.utl_inf_fonction_id AS utl_inf_fonction_id_3 FROM utilisateur_info t0 WHERE t0.utl_inf_utilisateur_id = ? SELECT t0.id AS id_1, t0.utl_inf_utilisateur_id AS utl_inf_utilisateur_id_2, t0.utl_inf_fonction_id AS utl_inf_fonction_id_3 FROM utilisateur_info t0 WHERE t0.utl_inf_utilisateur_id = 707;
0.61 ms (0.43%)	2	SELECT t0.id AS id_1, t0.ct_denomination AS ct_denomination_2, t0.ct_libele_public AS ct_libele_public_3 FROM centre_type t0 WHERE t0.id IN (?) Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.ct_denomination AS ct_denomination_2, t0.ct_libele_public AS ct_libele_public_3 FROM centre_type t0 WHERE t0.id IN (?) SELECT t0.id AS id_1, t0.ct_denomination AS ct_denomination_2, t0.ct_libele_public AS ct_libele_public_3 FROM centre_type t0 WHERE t0.id IN (2);
0.59 ms (0.42%)	1	SELECT r0_.id AS id_0, r0_.fp_montant_prestation AS fp_montant_prestation_1, r0_.fp_montant_frais_service AS fp_montant_frais_service_2, r0_.fp_option_cv AS fp_option_cv_3, r0_.fp_option_cv_montant AS fp_option_cv_montant_4, r0_.fp_option_modifiable AS fp_option_modifiable_5, r0_.fp_option_modifiable_montant AS fp_option_modifiable_montant_6, r0_.fp_option_paiement_multiple AS fp_option_paiement_multiple_7, r0_.fp_option_paiement_multiple_montant AS fp_option_paiement_multiple_montant_8, r0_.fp_option_coupon_reduction AS fp_option_coupon_reduction_9, r0_.fp_option_coupon_reduction_montant AS fp_option_coupon_reduction_montant_10, r0_.fp_mode_reglement AS fp_mode_reglement_11, r0_.fp_date_second_versement AS fp_date_second_versement_12, r0_.fp_montant_second_versement AS fp_montant_second_versement_13, r0_.rendezvous_id AS rendezvous_id_14 FROM rendez_vous_facturation r0_ WHERE r0_.rendezvous_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`5248138 5233760 5278905 5278906 5278907 5278908 5278909 5278911 5278910`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.fp_montant_prestation AS fp_montant_prestation_1, r0_.fp_montant_frais_service AS fp_montant_frais_service_2, r0_.fp_option_cv AS fp_option_cv_3, r0_.fp_option_cv_montant AS fp_option_cv_montant_4, r0_.fp_option_modifiable AS fp_option_modifiable_5, r0_.fp_option_modifiable_montant AS fp_option_modifiable_montant_6, r0_.fp_option_paiement_multiple AS fp_option_paiement_multiple_7, r0_.fp_option_paiement_multiple_montant AS fp_option_paiement_multiple_montant_8, r0_.fp_option_coupon_reduction AS fp_option_coupon_reduction_9, r0_.fp_option_coupon_reduction_montant AS fp_option_coupon_reduction_montant_10, r0_.fp_mode_reglement AS fp_mode_reglement_11, r0_.fp_date_second_versement AS fp_date_second_versement_12, r0_.fp_montant_second_versement AS fp_montant_second_versement_13, r0_.rendezvous_id AS rendezvous_id_14 FROM rendez_vous_facturation r0_ WHERE r0_.rendezvous_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT r0_.id AS id_0, r0_.fp_montant_prestation AS fp_montant_prestation_1, r0_.fp_montant_frais_service AS fp_montant_frais_service_2, r0_.fp_option_cv AS fp_option_cv_3, r0_.fp_option_cv_montant AS fp_option_cv_montant_4, r0_.fp_option_modifiable AS fp_option_modifiable_5, r0_.fp_option_modifiable_montant AS fp_option_modifiable_montant_6, r0_.fp_option_paiement_multiple AS fp_option_paiement_multiple_7, r0_.fp_option_paiement_multiple_montant AS fp_option_paiement_multiple_montant_8, r0_.fp_option_coupon_reduction AS fp_option_coupon_reduction_9, r0_.fp_option_coupon_reduction_montant AS fp_option_coupon_reduction_montant_10, r0_.fp_mode_reglement AS fp_mode_reglement_11, r0_.fp_date_second_versement AS fp_date_second_versement_12, r0_.fp_montant_second_versement AS fp_montant_second_versement_13, r0_.rendezvous_id AS rendezvous_id_14 FROM rendez_vous_facturation r0_ WHERE r0_.rendezvous_id IN (5248138, 5233760, 5278905, 5278906, 5278907, 5278908, 5278909, 5278911, 5278910);
0.52 ms (0.37%)	1	SELECT t0.id AS id_1, t0.pcg_display_creneau_dispo_bo AS pcg_display_creneau_dispo_bo_2, t0.pcg_presta_web AS pcg_presta_web_3, t0.pcg_url AS pcg_url_4, t0.pcg_blocage_bg_color AS pcg_blocage_bg_color_5, t0.pcg_rdv_recurrence_bg_color AS pcg_rdv_recurrence_bg_color_6, t0.pcg_info_bandeau AS pcg_info_bandeau_7, t0.pcg_color_info_paiement_text AS pcg_color_info_paiement_text_8, t0.pcg_color_info_paiement_border AS pcg_color_info_paiement_border_9, t0.pcg_color_info_paiement_bg AS pcg_color_info_paiement_bg_10, t0.pcg_info_message1 AS pcg_info_message1_11, t0.pcg_info_message1_color_text AS pcg_info_message1_color_text_12, t0.pcg_info_message1_color_border AS pcg_info_message1_color_border_13, t0.pcg_info_message1_color_bg AS pcg_info_message1_color_bg_14, t0.pcg_info_message1_color_cligno AS pcg_info_message1_color_cligno_15, t0.pcg_info_message2 AS pcg_info_message2_16, t0.pcg_info_message2_color_text AS pcg_info_message2_color_text_17, t0.pcg_info_message2_color_border AS pcg_info_message2_color_border_18, t0.pcg_info_message2_color_bg AS pcg_info_message2_color_bg_19, t0.pcg_info_message2_color_cligno AS pcg_info_message2_color_cligno_20, t0.pcg_info_message_email AS pcg_info_message_email_21, t0.pcg_visuel_logo_nom AS pcg_visuel_logo_nom_22, t0.pcg_visuel_logo_alt AS pcg_visuel_logo_alt_23, t0.pcg_visuel_img_centre_nom AS pcg_visuel_img_centre_nom_24, t0.pcg_en_savoir_plus AS pcg_en_savoir_plus_25, t0.pcg_accueil_titre AS pcg_accueil_titre_26, t0.pcg_accueil_meta_description AS pcg_accueil_meta_description_27, t0.pcg_accueil_meta_keywords AS pcg_accueil_meta_keywords_28, t0.pcg_accueil_h2 AS pcg_accueil_h2_29, t0.pcg_reservation_titre AS pcg_reservation_titre_30, t0.pcg_reservation_meta_description AS pcg_reservation_meta_description_31, t0.pcg_reservation_meta_keywords AS pcg_reservation_meta_keywords_32, t0.pcg_type_visite AS pcg_type_visite_33, t0.pcg_pyl_bo_cartouche_cal_client_first AS pcg_pyl_bo_cartouche_cal_client_first_34, t0.pcg_google_analytics AS pcg_google_analytics_35, t0.pcg_google_analytics_2 AS pcg_google_analytics_2_36, t0.pcg_google_analytics_3 AS pcg_google_analytics_3_37, t0.pcg_chemin_logo AS pcg_chemin_logo_38, t0.pcg_taille_logo AS pcg_taille_logo_39, t0.pcg_url2 AS pcg_url2_40, t0.pcg_heure_debut_calendar AS pcg_heure_debut_calendar_41, t0.pcg_heure_fin_calendar AS pcg_heure_fin_calendar_42, t0.pcg_info_bulle AS pcg_info_bulle_43, t0.pcg_redirect_calendar AS pcg_redirect_calendar_44, t0.pcg_rdv_client_not_honored AS pcg_rdv_client_not_honored_45, t0.pcg_mediateur_nom AS pcg_mediateur_nom_46, t0.pcg_mediateur_site AS pcg_mediateur_site_47, t0.pcg_mediateur_adresse AS pcg_mediateur_adresse_48, t0.centre_groupe_id AS centre_groupe_id_49, t50.id AS id_51, t50.cg_nom AS cg_nom_52, t50.cg_pas_horaires AS cg_pas_horaires_53, t50.cg_actif AS cg_actif_54, t50.cg_stay_to_date_rdv AS cg_stay_to_date_rdv_55, t50.id_old AS id_old_56, t50.cg_serveur AS cg_serveur_57, t50.cg_gerant_id AS cg_gerant_id_58, t50.centre_groupe_css_id AS centre_groupe_css_id_59 FROM parametre_centre_groupe t0 INNER JOIN centre_groupe t50 ON t0.centre_groupe_id = t50.id WHERE t0.centre_groupe_id = ? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.pcg_display_creneau_dispo_bo AS pcg_display_creneau_dispo_bo_2, t0.pcg_presta_web AS pcg_presta_web_3, t0.pcg_url AS pcg_url_4, t0.pcg_blocage_bg_color AS pcg_blocage_bg_color_5, t0.pcg_rdv_recurrence_bg_color AS pcg_rdv_recurrence_bg_color_6, t0.pcg_info_bandeau AS pcg_info_bandeau_7, t0.pcg_color_info_paiement_text AS pcg_color_info_paiement_text_8, t0.pcg_color_info_paiement_border AS pcg_color_info_paiement_border_9, t0.pcg_color_info_paiement_bg AS pcg_color_info_paiement_bg_10, t0.pcg_info_message1 AS pcg_info_message1_11, t0.pcg_info_message1_color_text AS pcg_info_message1_color_text_12, t0.pcg_info_message1_color_border AS pcg_info_message1_color_border_13, t0.pcg_info_message1_color_bg AS pcg_info_message1_color_bg_14, t0.pcg_info_message1_color_cligno AS pcg_info_message1_color_cligno_15, t0.pcg_info_message2 AS pcg_info_message2_16, t0.pcg_info_message2_color_text AS pcg_info_message2_color_text_17, t0.pcg_info_message2_color_border AS pcg_info_message2_color_border_18, t0.pcg_info_message2_color_bg AS pcg_info_message2_color_bg_19, t0.pcg_info_message2_color_cligno AS pcg_info_message2_color_cligno_20, t0.pcg_info_message_email AS pcg_info_message_email_21, t0.pcg_visuel_logo_nom AS pcg_visuel_logo_nom_22, t0.pcg_visuel_logo_alt AS pcg_visuel_logo_alt_23, t0.pcg_visuel_img_centre_nom AS pcg_visuel_img_centre_nom_24, t0.pcg_en_savoir_plus AS pcg_en_savoir_plus_25, t0.pcg_accueil_titre AS pcg_accueil_titre_26, t0.pcg_accueil_meta_description AS pcg_accueil_meta_description_27, t0.pcg_accueil_meta_keywords AS pcg_accueil_meta_keywords_28, t0.pcg_accueil_h2 AS pcg_accueil_h2_29, t0.pcg_reservation_titre AS pcg_reservation_titre_30, t0.pcg_reservation_meta_description AS pcg_reservation_meta_description_31, t0.pcg_reservation_meta_keywords AS pcg_reservation_meta_keywords_32, t0.pcg_type_visite AS pcg_type_visite_33, t0.pcg_pyl_bo_cartouche_cal_client_first AS pcg_pyl_bo_cartouche_cal_client_first_34, t0.pcg_google_analytics AS pcg_google_analytics_35, t0.pcg_google_analytics_2 AS pcg_google_analytics_2_36, t0.pcg_google_analytics_3 AS pcg_google_analytics_3_37, t0.pcg_chemin_logo AS pcg_chemin_logo_38, t0.pcg_taille_logo AS pcg_taille_logo_39, t0.pcg_url2 AS pcg_url2_40, t0.pcg_heure_debut_calendar AS pcg_heure_debut_calendar_41, t0.pcg_heure_fin_calendar AS pcg_heure_fin_calendar_42, t0.pcg_info_bulle AS pcg_info_bulle_43, t0.pcg_redirect_calendar AS pcg_redirect_calendar_44, t0.pcg_rdv_client_not_honored AS pcg_rdv_client_not_honored_45, t0.pcg_mediateur_nom AS pcg_mediateur_nom_46, t0.pcg_mediateur_site AS pcg_mediateur_site_47, t0.pcg_mediateur_adresse AS pcg_mediateur_adresse_48, t0.centre_groupe_id AS centre_groupe_id_49, t50.id AS id_51, t50.cg_nom AS cg_nom_52, t50.cg_pas_horaires AS cg_pas_horaires_53, t50.cg_actif AS cg_actif_54, t50.cg_stay_to_date_rdv AS cg_stay_to_date_rdv_55, t50.id_old AS id_old_56, t50.cg_serveur AS cg_serveur_57, t50.cg_gerant_id AS cg_gerant_id_58, t50.centre_groupe_css_id AS centre_groupe_css_id_59 FROM parametre_centre_groupe t0 INNER JOIN centre_groupe t50 ON t0.centre_groupe_id = t50.id WHERE t0.centre_groupe_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.pcg_display_creneau_dispo_bo AS pcg_display_creneau_dispo_bo_2, t0.pcg_presta_web AS pcg_presta_web_3, t0.pcg_url AS pcg_url_4, t0.pcg_blocage_bg_color AS pcg_blocage_bg_color_5, t0.pcg_rdv_recurrence_bg_color AS pcg_rdv_recurrence_bg_color_6, t0.pcg_info_bandeau AS pcg_info_bandeau_7, t0.pcg_color_info_paiement_text AS pcg_color_info_paiement_text_8, t0.pcg_color_info_paiement_border AS pcg_color_info_paiement_border_9, t0.pcg_color_info_paiement_bg AS pcg_color_info_paiement_bg_10, t0.pcg_info_message1 AS pcg_info_message1_11, t0.pcg_info_message1_color_text AS pcg_info_message1_color_text_12, t0.pcg_info_message1_color_border AS pcg_info_message1_color_border_13, t0.pcg_info_message1_color_bg AS pcg_info_message1_color_bg_14, t0.pcg_info_message1_color_cligno AS pcg_info_message1_color_cligno_15, t0.pcg_info_message2 AS pcg_info_message2_16, t0.pcg_info_message2_color_text AS pcg_info_message2_color_text_17, t0.pcg_info_message2_color_border AS pcg_info_message2_color_border_18, t0.pcg_info_message2_color_bg AS pcg_info_message2_color_bg_19, t0.pcg_info_message2_color_cligno AS pcg_info_message2_color_cligno_20, t0.pcg_info_message_email AS pcg_info_message_email_21, t0.pcg_visuel_logo_nom AS pcg_visuel_logo_nom_22, t0.pcg_visuel_logo_alt AS pcg_visuel_logo_alt_23, t0.pcg_visuel_img_centre_nom AS pcg_visuel_img_centre_nom_24, t0.pcg_en_savoir_plus AS pcg_en_savoir_plus_25, t0.pcg_accueil_titre AS pcg_accueil_titre_26, t0.pcg_accueil_meta_description AS pcg_accueil_meta_description_27, t0.pcg_accueil_meta_keywords AS pcg_accueil_meta_keywords_28, t0.pcg_accueil_h2 AS pcg_accueil_h2_29, t0.pcg_reservation_titre AS pcg_reservation_titre_30, t0.pcg_reservation_meta_description AS pcg_reservation_meta_description_31, t0.pcg_reservation_meta_keywords AS pcg_reservation_meta_keywords_32, t0.pcg_type_visite AS pcg_type_visite_33, t0.pcg_pyl_bo_cartouche_cal_client_first AS pcg_pyl_bo_cartouche_cal_client_first_34, t0.pcg_google_analytics AS pcg_google_analytics_35, t0.pcg_google_analytics_2 AS pcg_google_analytics_2_36, t0.pcg_google_analytics_3 AS pcg_google_analytics_3_37, t0.pcg_chemin_logo AS pcg_chemin_logo_38, t0.pcg_taille_logo AS pcg_taille_logo_39, t0.pcg_url2 AS pcg_url2_40, t0.pcg_heure_debut_calendar AS pcg_heure_debut_calendar_41, t0.pcg_heure_fin_calendar AS pcg_heure_fin_calendar_42, t0.pcg_info_bulle AS pcg_info_bulle_43, t0.pcg_redirect_calendar AS pcg_redirect_calendar_44, t0.pcg_rdv_client_not_honored AS pcg_rdv_client_not_honored_45, t0.pcg_mediateur_nom AS pcg_mediateur_nom_46, t0.pcg_mediateur_site AS pcg_mediateur_site_47, t0.pcg_mediateur_adresse AS pcg_mediateur_adresse_48, t0.centre_groupe_id AS centre_groupe_id_49, t50.id AS id_51, t50.cg_nom AS cg_nom_52, t50.cg_pas_horaires AS cg_pas_horaires_53, t50.cg_actif AS cg_actif_54, t50.cg_stay_to_date_rdv AS cg_stay_to_date_rdv_55, t50.id_old AS id_old_56, t50.cg_serveur AS cg_serveur_57, t50.cg_gerant_id AS cg_gerant_id_58, t50.centre_groupe_css_id AS centre_groupe_css_id_59 FROM parametre_centre_groupe t0 INNER JOIN centre_groupe t50 ON t0.centre_groupe_id = t50.id WHERE t0.centre_groupe_id = 1 LIMIT 1;
0.29 ms (0.20%)	1	SELECT count(c0_.id) AS sclr_0 FROM centre_prestation c0_ WHERE c0_.id = ? AND c0_.centre_groupe_id = ? Parameters: [`"null" 1`] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM centre_prestation c0_ WHERE c0_.id = ? AND c0_.centre_groupe_id = ? SELECT count(c0_.id) AS sclr_0 FROM centre_prestation c0_ WHERE c0_.id = 'null' AND c0_.centre_groupe_id = 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Utilisateur	No errors.
App\Entity\UtilisateurInfo	No errors.
App\Entity\CentreFonction	No errors.
App\Entity\CentreGroupe	No errors.
App\Entity\Rendezvous	No errors.
App\Entity\ParametreCentreGroupe	No errors.
App\Entity\CentrePrestation	No errors.
App\Entity\TypeVehicule	No errors.
App\Entity\TypeVisite	No errors.
App\Entity\Gerant	No errors.
App\Entity\CentreGroupeCss	No errors.
App\Entity\Centre	No errors.
App\Entity\Adresse	No errors.
App\Entity\CentreType	No errors.
App\Entity\ParametreCentre	No errors.
App\Entity\ParametreCentreAdmin	No errors.
App\Entity\Ligne	No errors.
App\Entity\Promotion	No errors.
App\Entity\CentreCouponPromotion	No errors.
App\Entity\ClientCompte	The mappings App\Entity\ClientCompte#adresse_facturation and App\Entity\Adresse#clientComptes are inconsistent with each other.
App\Entity\CentrePartenaire	No errors.
App\Entity\RendezVousInfos	No errors.
App\Entity\Energie	No errors.
App\Entity\RendezVousVehicule	No errors.
App\Entity\SmsRelance	No errors.
App\Entity\Sms	No errors.
App\Entity\CentreHoraire	No errors.
App\Entity\Droit	No errors.
App\Entity\LigneBlocage	No errors.
App\Entity\LigneBlocageRecurrence	No errors.
App\Entity\ClientLibre	No errors.
App\Entity\Partenaire	No errors.
App\Entity\RendezVousRecurrence	The association App\Entity\RendezVousRecurrence#recurrence refers to the owning side field App\Entity\Rendezvous#rendezVousRecurrence which does not exist.
App\Entity\Marque	No errors.
App\Entity\MarqueCl	The association App\Entity\MarqueCl#modeleCls refers to the owning side field App\Entity\ModeleCl#code_marque_cl_id which does not exist.
App\Entity\Modele	No errors.
App\Entity\ModeleCl	The mappings App\Entity\ModeleCl#code_marque_cl and App\Entity\MarqueCl#modeleCls are inconsistent with each other.
App\Entity\MarquePl	No errors.
App\Entity\ModelePl	No errors.
App\Entity\LigneHoraire	No errors.
App\Entity\RendezVousFacturation	No errors.
App\Entity\RendezVousPaiementMultiple	No errors.

Symfony Profiler

https://mercureweb2-07.autobilan-systems.com/admin/rendez-vous/json?end=2026-04-05T00%3A00%3A00%2002%3A00&prestation=null&start=2026-03-30T00%3A00%3A00%2002%3A00

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping