Symfony Profiler

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;

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);

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;

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);

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 = 7;

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);

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 = 11;

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 (8);

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 = 12;

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 (9);

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 = 13;

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 (1);

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 = 3569;

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 = 3570;

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 (3101);

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 = 3619;

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 (3160);

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 = 4258;

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 (3848);

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 (4);

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;

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);

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);

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);

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 = 2;