Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.horaire AS horaire_2,
  t0.is_confirmed AS is_confirmed_3,
  t0.horaires_holiday AS horaires_holiday_4,
  t0.id_audio_id AS id_audio_id_5,
  t0.id_centre_id AS id_centre_id_6
FROM
  audio_centre t0
WHERE
  t0.id_centre_id = ?
  AND t0.id_audio_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.horaire AS horaire_2, t0.is_confirmed AS is_confirmed_3, t0.horaires_holiday AS horaires_holiday_4, t0.id_audio_id AS id_audio_id_5, t0.id_centre_id AS id_centre_id_6 FROM audio_centre t0 WHERE t0.id_centre_id = 532 AND t0.id_audio_id = 563 LIMIT 1;

SELECT
  r0_.id AS id_0,
  r0_.date_creation AS date_creation_1,
  r0_.date AS date_2,
  r0_.comment AS comment_3,
  r0_.review AS review_4,
  r0_.note AS note_5,
  r0_.id_status AS id_status_6,
  r0_.duration AS duration_7,
  r0_.id_sms AS id_sms_8,
  r0_.is_absence AS is_absence_9,
  r0_.color AS color_10,
  r0_.motif_absence AS motif_absence_11,
  r0_.cacher AS cacher_12,
  r0_.is_my_audio AS is_my_audio_13,
  r0_.google_agenda_imported AS google_agenda_imported_14,
  r0_.cosium_imported AS cosium_imported_15,
  r0_.is_one_hour_notification_sent AS is_one_hour_notification_sent_16,
  r0_.is_twenty_four_hour_notification_sent AS is_twenty_four_hour_notification_sent_17,
  r0_.rdv_parent AS rdv_parent_18,
  r0_.is_rdv_rapide AS is_rdv_rapide_19,
  r0_.is_rdv_lp AS is_rdv_lp_20,
  r0_.last_reminder_sent_at AS last_reminder_sent_at_21,
  r0_.is_followup_call_sent AS is_followup_call_sent_22,
  r0_.is_followup_day15_call_sent AS is_followup_day15_call_sent_23,
  r0_.is_followup_day31_call_sent AS is_followup_day31_call_sent_24,
  r0_.is_reminder_one_day_before_call_sent AS is_reminder_one_day_before_call_sent_25,
  r0_.is_reminder_one_hour_before_call_sent AS is_reminder_one_hour_before_call_sent_26,
  r0_.is_notification_rdv_call_sent AS is_notification_rdv_call_sent_27,
  r0_.date_old_rdv AS date_old_rdv_28,
  r0_.rdv_orl_date AS rdv_orl_date_29,
  r0_.is_equipment_status_call_sent AS is_equipment_status_call_sent_30,
  r0_.last_equipment_status_call_date AS last_equipment_status_call_date_31,
  r0_.id_motif_id AS id_motif_id_32,
  r0_.id_client_id AS id_client_id_33,
  r0_.id_client_temp_id AS id_client_temp_id_34,
  r0_.id_centre_id AS id_centre_id_35,
  r0_.id_etat_id AS id_etat_id_36,
  r0_.id_audio_id AS id_audio_id_37,
  r0_.id_lieu_id AS id_lieu_id_38,
  r0_.id_proche_id AS id_proche_id_39,
  r0_.test_client_id AS test_client_id_40,
  r0_.remplacant_id AS remplacant_id_41
FROM
  rdv r0_
WHERE
  r0_.id_audio_id = ?
  AND (
    r0_.date BETWEEN ?
    AND ?
  )
  AND r0_.cacher = 0
ORDER BY
  r0_.date ASC

SELECT r0_.id AS id_0, r0_.date_creation AS date_creation_1, r0_.date AS date_2, r0_.comment AS comment_3, r0_.review AS review_4, r0_.note AS note_5, r0_.id_status AS id_status_6, r0_.duration AS duration_7, r0_.id_sms AS id_sms_8, r0_.is_absence AS is_absence_9, r0_.color AS color_10, r0_.motif_absence AS motif_absence_11, r0_.cacher AS cacher_12, r0_.is_my_audio AS is_my_audio_13, r0_.google_agenda_imported AS google_agenda_imported_14, r0_.cosium_imported AS cosium_imported_15, r0_.is_one_hour_notification_sent AS is_one_hour_notification_sent_16, r0_.is_twenty_four_hour_notification_sent AS is_twenty_four_hour_notification_sent_17, r0_.rdv_parent AS rdv_parent_18, r0_.is_rdv_rapide AS is_rdv_rapide_19, r0_.is_rdv_lp AS is_rdv_lp_20, r0_.last_reminder_sent_at AS last_reminder_sent_at_21, r0_.is_followup_call_sent AS is_followup_call_sent_22, r0_.is_followup_day15_call_sent AS is_followup_day15_call_sent_23, r0_.is_followup_day31_call_sent AS is_followup_day31_call_sent_24, r0_.is_reminder_one_day_before_call_sent AS is_reminder_one_day_before_call_sent_25, r0_.is_reminder_one_hour_before_call_sent AS is_reminder_one_hour_before_call_sent_26, r0_.is_notification_rdv_call_sent AS is_notification_rdv_call_sent_27, r0_.date_old_rdv AS date_old_rdv_28, r0_.rdv_orl_date AS rdv_orl_date_29, r0_.is_equipment_status_call_sent AS is_equipment_status_call_sent_30, r0_.last_equipment_status_call_date AS last_equipment_status_call_date_31, r0_.id_motif_id AS id_motif_id_32, r0_.id_client_id AS id_client_id_33, r0_.id_client_temp_id AS id_client_temp_id_34, r0_.id_centre_id AS id_centre_id_35, r0_.id_etat_id AS id_etat_id_36, r0_.id_audio_id AS id_audio_id_37, r0_.id_lieu_id AS id_lieu_id_38, r0_.id_proche_id AS id_proche_id_39, r0_.test_client_id AS test_client_id_40, r0_.remplacant_id AS remplacant_id_41 FROM rdv r0_ WHERE r0_.id_audio_id = 563 AND (r0_.date BETWEEN '2025-10-20' AND '2025-10-26') AND r0_.cacher = 0 ORDER BY r0_.date ASC;

SELECT
  g0_.id AS id_0,
  g0_.summary AS summary_1,
  g0_.start AS start_2,
  g0_.end AS end_3,
  g0_.color AS color_4,
  g0_.location AS location_5,
  g0_.description AS description_6,
  g0_.event_id AS event_id_7,
  g0_.organiser_email AS organiser_email_8,
  g0_.meeting_url AS meeting_url_9,
  g0_.attendees AS attendees_10,
  g0_.attachement AS attachement_11,
  g0_.synch_token AS synch_token_12,
  g0_.audio_id AS audio_id_13,
  g0_.synchronisation_setting_id AS synchronisation_setting_id_14
FROM
  google_agenda g0_
WHERE
  g0_.audio_id = ?
  AND (
    g0_.start BETWEEN ?
    AND ?
  )
  AND (
    g0_.end BETWEEN ?
    AND ?
  )
  AND (
    g0_.description IS NULL
    OR g0_.description NOT LIKE ?
  )
ORDER BY
  g0_.start ASC

SELECT g0_.id AS id_0, g0_.summary AS summary_1, g0_.start AS start_2, g0_.end AS end_3, g0_.color AS color_4, g0_.location AS location_5, g0_.description AS description_6, g0_.event_id AS event_id_7, g0_.organiser_email AS organiser_email_8, g0_.meeting_url AS meeting_url_9, g0_.attendees AS attendees_10, g0_.attachement AS attachement_11, g0_.synch_token AS synch_token_12, g0_.audio_id AS audio_id_13, g0_.synchronisation_setting_id AS synchronisation_setting_id_14 FROM google_agenda g0_ WHERE g0_.audio_id = 563 AND (g0_.start BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 00:00:00') AND (g0_.end BETWEEN '2025-10-20 00:00:00' AND '2025-10-26 00:00:00') AND (g0_.description IS NULL OR g0_.description NOT LIKE '%Nom du patient:%') ORDER BY g0_.start ASC;

SELECT
  r0_.id AS id_0,
  r0_.date_creation AS date_creation_1,
  r0_.date AS date_2,
  r0_.comment AS comment_3,
  r0_.review AS review_4,
  r0_.note AS note_5,
  r0_.id_status AS id_status_6,
  r0_.duration AS duration_7,
  r0_.id_sms AS id_sms_8,
  r0_.is_absence AS is_absence_9,
  r0_.color AS color_10,
  r0_.motif_absence AS motif_absence_11,
  r0_.cacher AS cacher_12,
  r0_.is_my_audio AS is_my_audio_13,
  r0_.google_agenda_imported AS google_agenda_imported_14,
  r0_.cosium_imported AS cosium_imported_15,
  r0_.is_one_hour_notification_sent AS is_one_hour_notification_sent_16,
  r0_.is_twenty_four_hour_notification_sent AS is_twenty_four_hour_notification_sent_17,
  r0_.rdv_parent AS rdv_parent_18,
  r0_.is_rdv_rapide AS is_rdv_rapide_19,
  r0_.is_rdv_lp AS is_rdv_lp_20,
  r0_.last_reminder_sent_at AS last_reminder_sent_at_21,
  r0_.is_followup_call_sent AS is_followup_call_sent_22,
  r0_.is_followup_day15_call_sent AS is_followup_day15_call_sent_23,
  r0_.is_followup_day31_call_sent AS is_followup_day31_call_sent_24,
  r0_.is_reminder_one_day_before_call_sent AS is_reminder_one_day_before_call_sent_25,
  r0_.is_reminder_one_hour_before_call_sent AS is_reminder_one_hour_before_call_sent_26,
  r0_.is_notification_rdv_call_sent AS is_notification_rdv_call_sent_27,
  r0_.date_old_rdv AS date_old_rdv_28,
  r0_.rdv_orl_date AS rdv_orl_date_29,
  r0_.is_equipment_status_call_sent AS is_equipment_status_call_sent_30,
  r0_.last_equipment_status_call_date AS last_equipment_status_call_date_31,
  r0_.id_motif_id AS id_motif_id_32,
  r0_.id_client_id AS id_client_id_33,
  r0_.id_client_temp_id AS id_client_temp_id_34,
  r0_.id_centre_id AS id_centre_id_35,
  r0_.id_etat_id AS id_etat_id_36,
  r0_.id_audio_id AS id_audio_id_37,
  r0_.id_lieu_id AS id_lieu_id_38,
  r0_.id_proche_id AS id_proche_id_39,
  r0_.test_client_id AS test_client_id_40,
  r0_.remplacant_id AS remplacant_id_41
FROM
  rdv r0_
WHERE
  r0_.review IS NOT NULL
  AND r0_.id_audio_id = ?

SELECT r0_.id AS id_0, r0_.date_creation AS date_creation_1, r0_.date AS date_2, r0_.comment AS comment_3, r0_.review AS review_4, r0_.note AS note_5, r0_.id_status AS id_status_6, r0_.duration AS duration_7, r0_.id_sms AS id_sms_8, r0_.is_absence AS is_absence_9, r0_.color AS color_10, r0_.motif_absence AS motif_absence_11, r0_.cacher AS cacher_12, r0_.is_my_audio AS is_my_audio_13, r0_.google_agenda_imported AS google_agenda_imported_14, r0_.cosium_imported AS cosium_imported_15, r0_.is_one_hour_notification_sent AS is_one_hour_notification_sent_16, r0_.is_twenty_four_hour_notification_sent AS is_twenty_four_hour_notification_sent_17, r0_.rdv_parent AS rdv_parent_18, r0_.is_rdv_rapide AS is_rdv_rapide_19, r0_.is_rdv_lp AS is_rdv_lp_20, r0_.last_reminder_sent_at AS last_reminder_sent_at_21, r0_.is_followup_call_sent AS is_followup_call_sent_22, r0_.is_followup_day15_call_sent AS is_followup_day15_call_sent_23, r0_.is_followup_day31_call_sent AS is_followup_day31_call_sent_24, r0_.is_reminder_one_day_before_call_sent AS is_reminder_one_day_before_call_sent_25, r0_.is_reminder_one_hour_before_call_sent AS is_reminder_one_hour_before_call_sent_26, r0_.is_notification_rdv_call_sent AS is_notification_rdv_call_sent_27, r0_.date_old_rdv AS date_old_rdv_28, r0_.rdv_orl_date AS rdv_orl_date_29, r0_.is_equipment_status_call_sent AS is_equipment_status_call_sent_30, r0_.last_equipment_status_call_date AS last_equipment_status_call_date_31, r0_.id_motif_id AS id_motif_id_32, r0_.id_client_id AS id_client_id_33, r0_.id_client_temp_id AS id_client_temp_id_34, r0_.id_centre_id AS id_centre_id_35, r0_.id_etat_id AS id_etat_id_36, r0_.id_audio_id AS id_audio_id_37, r0_.id_lieu_id AS id_lieu_id_38, r0_.id_proche_id AS id_proche_id_39, r0_.test_client_id AS test_client_id_40, r0_.remplacant_id AS remplacant_id_41 FROM rdv r0_ WHERE r0_.review IS NOT NULL AND r0_.id_audio_id = 563;

SELECT
  r0_.id AS id_0,
  r0_.date_creation AS date_creation_1,
  r0_.date AS date_2,
  r0_.comment AS comment_3,
  r0_.review AS review_4,
  r0_.note AS note_5,
  r0_.id_status AS id_status_6,
  r0_.duration AS duration_7,
  r0_.id_sms AS id_sms_8,
  r0_.is_absence AS is_absence_9,
  r0_.color AS color_10,
  r0_.motif_absence AS motif_absence_11,
  r0_.cacher AS cacher_12,
  r0_.is_my_audio AS is_my_audio_13,
  r0_.google_agenda_imported AS google_agenda_imported_14,
  r0_.cosium_imported AS cosium_imported_15,
  r0_.is_one_hour_notification_sent AS is_one_hour_notification_sent_16,
  r0_.is_twenty_four_hour_notification_sent AS is_twenty_four_hour_notification_sent_17,
  r0_.rdv_parent AS rdv_parent_18,
  r0_.is_rdv_rapide AS is_rdv_rapide_19,
  r0_.is_rdv_lp AS is_rdv_lp_20,
  r0_.last_reminder_sent_at AS last_reminder_sent_at_21,
  r0_.is_followup_call_sent AS is_followup_call_sent_22,
  r0_.is_followup_day15_call_sent AS is_followup_day15_call_sent_23,
  r0_.is_followup_day31_call_sent AS is_followup_day31_call_sent_24,
  r0_.is_reminder_one_day_before_call_sent AS is_reminder_one_day_before_call_sent_25,
  r0_.is_reminder_one_hour_before_call_sent AS is_reminder_one_hour_before_call_sent_26,
  r0_.is_notification_rdv_call_sent AS is_notification_rdv_call_sent_27,
  r0_.date_old_rdv AS date_old_rdv_28,
  r0_.rdv_orl_date AS rdv_orl_date_29,
  r0_.is_equipment_status_call_sent AS is_equipment_status_call_sent_30,
  r0_.last_equipment_status_call_date AS last_equipment_status_call_date_31,
  r0_.id_motif_id AS id_motif_id_32,
  r0_.id_client_id AS id_client_id_33,
  r0_.id_client_temp_id AS id_client_temp_id_34,
  r0_.id_centre_id AS id_centre_id_35,
  r0_.id_etat_id AS id_etat_id_36,
  r0_.id_audio_id AS id_audio_id_37,
  r0_.id_lieu_id AS id_lieu_id_38,
  r0_.id_proche_id AS id_proche_id_39,
  r0_.test_client_id AS test_client_id_40,
  r0_.remplacant_id AS remplacant_id_41
FROM
  rdv r0_
WHERE
  r0_.review IS NOT NULL
  AND r0_.id_centre_id = ?

SELECT r0_.id AS id_0, r0_.date_creation AS date_creation_1, r0_.date AS date_2, r0_.comment AS comment_3, r0_.review AS review_4, r0_.note AS note_5, r0_.id_status AS id_status_6, r0_.duration AS duration_7, r0_.id_sms AS id_sms_8, r0_.is_absence AS is_absence_9, r0_.color AS color_10, r0_.motif_absence AS motif_absence_11, r0_.cacher AS cacher_12, r0_.is_my_audio AS is_my_audio_13, r0_.google_agenda_imported AS google_agenda_imported_14, r0_.cosium_imported AS cosium_imported_15, r0_.is_one_hour_notification_sent AS is_one_hour_notification_sent_16, r0_.is_twenty_four_hour_notification_sent AS is_twenty_four_hour_notification_sent_17, r0_.rdv_parent AS rdv_parent_18, r0_.is_rdv_rapide AS is_rdv_rapide_19, r0_.is_rdv_lp AS is_rdv_lp_20, r0_.last_reminder_sent_at AS last_reminder_sent_at_21, r0_.is_followup_call_sent AS is_followup_call_sent_22, r0_.is_followup_day15_call_sent AS is_followup_day15_call_sent_23, r0_.is_followup_day31_call_sent AS is_followup_day31_call_sent_24, r0_.is_reminder_one_day_before_call_sent AS is_reminder_one_day_before_call_sent_25, r0_.is_reminder_one_hour_before_call_sent AS is_reminder_one_hour_before_call_sent_26, r0_.is_notification_rdv_call_sent AS is_notification_rdv_call_sent_27, r0_.date_old_rdv AS date_old_rdv_28, r0_.rdv_orl_date AS rdv_orl_date_29, r0_.is_equipment_status_call_sent AS is_equipment_status_call_sent_30, r0_.last_equipment_status_call_date AS last_equipment_status_call_date_31, r0_.id_motif_id AS id_motif_id_32, r0_.id_client_id AS id_client_id_33, r0_.id_client_temp_id AS id_client_temp_id_34, r0_.id_centre_id AS id_centre_id_35, r0_.id_etat_id AS id_etat_id_36, r0_.id_audio_id AS id_audio_id_37, r0_.id_lieu_id AS id_lieu_id_38, r0_.id_proche_id AS id_proche_id_39, r0_.test_client_id AS test_client_id_40, r0_.remplacant_id AS remplacant_id_41 FROM rdv r0_ WHERE r0_.review IS NOT NULL AND r0_.id_centre_id = 532;

SELECT
  t0.id AS id_1,
  t0.signup_date AS signup_date_2,
  t0.civilite AS civilite_3,
  t0.name AS name_4,
  t0.lastname AS lastname_5,
  t0.birthdate AS birthdate_6,
  t0.mail AS mail_7,
  t0.phone AS phone_8,
  t0.adeli AS adeli_9,
  t0.password AS password_10,
  t0.pin AS pin_11,
  t0.code_parrainage AS code_parrainage_12,
  t0.description AS description_13,
  t0.img_url AS img_url_14,
  t0.is_indie AS is_indie_15,
  t0.mail_valid AS mail_valid_16,
  t0.confirm_rdv_mail AS confirm_rdv_mail_17,
  t0.confirm_rdv_sms AS confirm_rdv_sms_18,
  t0.modif_rdv_mail AS modif_rdv_mail_19,
  t0.modif_rdv_sms AS modif_rdv_sms_20,
  t0.modif_note AS modif_note_21,
  t0.mail_notif AS mail_notif_22,
  t0.phone_notif AS phone_notif_23,
  t0.is_rdv_domicile_indie AS is_rdv_domicile_indie_24,
  t0.is_indie_valid AS is_indie_valid_25,
  t0.is_partner AS is_partner_26,
  t0.session_lifetime AS session_lifetime_27,
  t0.last_login_date AS last_login_date_28,
  t0.referral_code AS referral_code_29,
  t0.balance AS balance_30,
  t0.role_id AS role_id_31
FROM
  audio t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.signup_date AS signup_date_2, t0.civilite AS civilite_3, t0.name AS name_4, t0.lastname AS lastname_5, t0.birthdate AS birthdate_6, t0.mail AS mail_7, t0.phone AS phone_8, t0.adeli AS adeli_9, t0.password AS password_10, t0.pin AS pin_11, t0.code_parrainage AS code_parrainage_12, t0.description AS description_13, t0.img_url AS img_url_14, t0.is_indie AS is_indie_15, t0.mail_valid AS mail_valid_16, t0.confirm_rdv_mail AS confirm_rdv_mail_17, t0.confirm_rdv_sms AS confirm_rdv_sms_18, t0.modif_rdv_mail AS modif_rdv_mail_19, t0.modif_rdv_sms AS modif_rdv_sms_20, t0.modif_note AS modif_note_21, t0.mail_notif AS mail_notif_22, t0.phone_notif AS phone_notif_23, t0.is_rdv_domicile_indie AS is_rdv_domicile_indie_24, t0.is_indie_valid AS is_indie_valid_25, t0.is_partner AS is_partner_26, t0.session_lifetime AS session_lifetime_27, t0.last_login_date AS last_login_date_28, t0.referral_code AS referral_code_29, t0.balance AS balance_30, t0.role_id AS role_id_31 FROM audio t0 WHERE t0.id = 563 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.duration AS duration_2,
  t0.color AS color_3,
  t0.consigne AS consigne_4,
  t0.is_rdvonline AS is_rdvonline_5,
  t0.is_deleted AS is_deleted_6,
  t0.type AS type_7,
  t0.id_audio_id AS id_audio_id_8,
  t0.id_motif_id AS id_motif_id_9
FROM
  audio_motif t0
WHERE
  t0.id_audio_id = ?

SELECT t0.id AS id_1, t0.duration AS duration_2, t0.color AS color_3, t0.consigne AS consigne_4, t0.is_rdvonline AS is_rdvonline_5, t0.is_deleted AS is_deleted_6, t0.type AS type_7, t0.id_audio_id AS id_audio_id_8, t0.id_motif_id AS id_motif_id_9 FROM audio_motif t0 WHERE t0.id_audio_id = 563;

SELECT
  t0.id AS id_1,
  t0.horaire AS horaire_2,
  t0.is_confirmed AS is_confirmed_3,
  t0.horaires_holiday AS horaires_holiday_4,
  t0.id_audio_id AS id_audio_id_5,
  t0.id_centre_id AS id_centre_id_6
FROM
  audio_centre t0
WHERE
  t0.id_centre_id = ?
  AND t0.is_confirmed = ?

SELECT t0.id AS id_1, t0.horaire AS horaire_2, t0.is_confirmed AS is_confirmed_3, t0.horaires_holiday AS horaires_holiday_4, t0.id_audio_id AS id_audio_id_5, t0.id_centre_id AS id_centre_id_6 FROM audio_centre t0 WHERE t0.id_centre_id = 532 AND t0.is_confirmed = 1;

SELECT
  t0.id AS id_1,
  t0.other AS other_2,
  t0.id_audio_id AS id_audio_id_3,
  t0.id_specialite_id AS id_specialite_id_4
FROM
  audio_specialite t0
WHERE
  t0.id_audio_id = ?

SELECT t0.id AS id_1, t0.other AS other_2, t0.id_audio_id AS id_audio_id_3, t0.id_specialite_id AS id_specialite_id_4 FROM audio_specialite t0 WHERE t0.id_audio_id = 563;

SELECT
  t0.id AS id_1,
  t0.id_centre_id AS id_centre_id_2,
  t0.id_prestation_id AS id_prestation_id_3
FROM
  centre_prestation t0
WHERE
  t0.id_centre_id = ?

SELECT t0.id AS id_1, t0.id_centre_id AS id_centre_id_2, t0.id_prestation_id AS id_prestation_id_3 FROM centre_prestation t0 WHERE t0.id_centre_id = 532;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.phone AS phone_4,
  t0.logo_url AS logo_url_5,
  t0.website AS website_6,
  t0.email AS email_7,
  t0.seuil_ca_droite AS seuil_ca_droite_8,
  t0.seuil_ca_gauche AS seuil_ca_gauche_9,
  t0.seuil_confort_droite AS seuil_confort_droite_10,
  t0.seuil_confort_gauche AS seuil_confort_gauche_11,
  t0.seuil_co_droite AS seuil_co_droite_12,
  t0.seuil_co_gauche AS seuil_co_gauche_13,
  t0.seuil_ca_masking_droite AS seuil_ca_masking_droite_14,
  t0.seuil_ca_masking_gauche AS seuil_ca_masking_gauche_15,
  t0.seuil_co_masking_droite AS seuil_co_masking_droite_16,
  t0.seuil_co_masking_gauche AS seuil_co_masking_gauche_17,
  t0.casque_droite AS casque_droite_18,
  t0.casque_gauche AS casque_gauche_19,
  t0.casque_binaural AS casque_binaural_20,
  t0.champs_libre_droite AS champs_libre_droite_21,
  t0.champs_libre_gauche AS champs_libre_gauche_22,
  t0.champs_libre_binaural AS champs_libre_binaural_23,
  t0.champs_libre_app_droite AS champs_libre_app_droite_24,
  t0.champs_libre_app_gauche AS champs_libre_app_gauche_25,
  t0.champs_libre_app_binaural AS champs_libre_app_binaural_26,
  t0.seuil_in_confort_droite AS seuil_in_confort_droite_27,
  t0.seuil_in_confort_gauche AS seuil_in_confort_gauche_28,
  t0.firstname AS firstname_29,
  t0.lastname AS lastname_30,
  t0.centre_id AS centre_id_31
FROM
  setting t0
WHERE
  t0.centre_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.phone AS phone_4, t0.logo_url AS logo_url_5, t0.website AS website_6, t0.email AS email_7, t0.seuil_ca_droite AS seuil_ca_droite_8, t0.seuil_ca_gauche AS seuil_ca_gauche_9, t0.seuil_confort_droite AS seuil_confort_droite_10, t0.seuil_confort_gauche AS seuil_confort_gauche_11, t0.seuil_co_droite AS seuil_co_droite_12, t0.seuil_co_gauche AS seuil_co_gauche_13, t0.seuil_ca_masking_droite AS seuil_ca_masking_droite_14, t0.seuil_ca_masking_gauche AS seuil_ca_masking_gauche_15, t0.seuil_co_masking_droite AS seuil_co_masking_droite_16, t0.seuil_co_masking_gauche AS seuil_co_masking_gauche_17, t0.casque_droite AS casque_droite_18, t0.casque_gauche AS casque_gauche_19, t0.casque_binaural AS casque_binaural_20, t0.champs_libre_droite AS champs_libre_droite_21, t0.champs_libre_gauche AS champs_libre_gauche_22, t0.champs_libre_binaural AS champs_libre_binaural_23, t0.champs_libre_app_droite AS champs_libre_app_droite_24, t0.champs_libre_app_gauche AS champs_libre_app_gauche_25, t0.champs_libre_app_binaural AS champs_libre_app_binaural_26, t0.seuil_in_confort_droite AS seuil_in_confort_droite_27, t0.seuil_in_confort_gauche AS seuil_in_confort_gauche_28, t0.firstname AS firstname_29, t0.lastname AS lastname_30, t0.centre_id AS centre_id_31 FROM setting t0 WHERE t0.centre_id = 532;

SELECT
  t0.id AS id_1,
  t0.stripe_subscription_id AS stripe_subscription_id_2,
  t0.stripe_customer_id AS stripe_customer_id_3,
  t0.stripe_payment_intent_id AS stripe_payment_intent_id_4,
  t0.payment_method AS payment_method_5,
  t0.paid_amount AS paid_amount_6,
  t0.paid_amount_currency AS paid_amount_currency_7,
  t0.plan_interval AS plan_interval_8,
  t0.plan_interval_count AS plan_interval_count_9,
  t0.customer_name AS customer_name_10,
  t0.customer_email AS customer_email_11,
  t0.created AS created_12,
  t0.plan_period_start AS plan_period_start_13,
  t0.plan_period_end AS plan_period_end_14,
  t0.status AS status_15,
  t0.quantity AS quantity_16,
  t0.centre_id AS centre_id_17,
  t0.plan_id AS plan_id_18,
  t0.audio_id AS audio_id_19
FROM
  subscription t0
WHERE
  t0.centre_id = ?

SELECT t0.id AS id_1, t0.stripe_subscription_id AS stripe_subscription_id_2, t0.stripe_customer_id AS stripe_customer_id_3, t0.stripe_payment_intent_id AS stripe_payment_intent_id_4, t0.payment_method AS payment_method_5, t0.paid_amount AS paid_amount_6, t0.paid_amount_currency AS paid_amount_currency_7, t0.plan_interval AS plan_interval_8, t0.plan_interval_count AS plan_interval_count_9, t0.customer_name AS customer_name_10, t0.customer_email AS customer_email_11, t0.created AS created_12, t0.plan_period_start AS plan_period_start_13, t0.plan_period_end AS plan_period_end_14, t0.status AS status_15, t0.quantity AS quantity_16, t0.centre_id AS centre_id_17, t0.plan_id AS plan_id_18, t0.audio_id AS audio_id_19 FROM subscription t0 WHERE t0.centre_id = 532;

SELECT
  t0.id AS id_1,
  t0.stripe_customer AS stripe_customer_2,
  t0.stripe_product AS stripe_product_3,
  t0.payment_method AS payment_method_4,
  t0.payment_intent AS payment_intent_5,
  t0.plan_interval AS plan_interval_6,
  t0.paid_amount AS paid_amount_7,
  t0.status AS status_8,
  t0.created AS created_9,
  t0.plan_period_start AS plan_period_start_10,
  t0.plan_period_end AS plan_period_end_11,
  t0.quantity AS quantity_12,
  t0.plan_id AS plan_id_13,
  t0.center_id AS center_id_14,
  t0.audio_id AS audio_id_15,
  t0.contract_category_id AS contract_category_id_16
FROM
  specific_subscription t0
WHERE
  t0.center_id = ?

SELECT t0.id AS id_1, t0.stripe_customer AS stripe_customer_2, t0.stripe_product AS stripe_product_3, t0.payment_method AS payment_method_4, t0.payment_intent AS payment_intent_5, t0.plan_interval AS plan_interval_6, t0.paid_amount AS paid_amount_7, t0.status AS status_8, t0.created AS created_9, t0.plan_period_start AS plan_period_start_10, t0.plan_period_end AS plan_period_end_11, t0.quantity AS quantity_12, t0.plan_id AS plan_id_13, t0.center_id AS center_id_14, t0.audio_id AS audio_id_15, t0.contract_category_id AS contract_category_id_16 FROM specific_subscription t0 WHERE t0.center_id = 532;

SELECT
  t0.id AS id_1,
  t0.paid_amount AS paid_amount_2,
  t0.paid_amount_currency AS paid_amount_currency_3,
  t0.plan_interva_l AS plan_interva_l_4,
  t0.created AS created_5,
  t0.plan_period_start AS plan_period_start_6,
  t0.plan_period_end AS plan_period_end_7,
  t0.quantity AS quantity_8,
  t0.is_audiolibre AS is_audiolibre_9,
  t0.centre_id AS centre_id_10,
  t0.audio_id AS audio_id_11,
  t0.plan_id AS plan_id_12,
  t0.audio_partner_id AS audio_partner_id_13,
  t0.audio_libre_partner_id AS audio_libre_partner_id_14
FROM
  partner_subscription t0
WHERE
  t0.centre_id = ?

SELECT t0.id AS id_1, t0.paid_amount AS paid_amount_2, t0.paid_amount_currency AS paid_amount_currency_3, t0.plan_interva_l AS plan_interva_l_4, t0.created AS created_5, t0.plan_period_start AS plan_period_start_6, t0.plan_period_end AS plan_period_end_7, t0.quantity AS quantity_8, t0.is_audiolibre AS is_audiolibre_9, t0.centre_id AS centre_id_10, t0.audio_id AS audio_id_11, t0.plan_id AS plan_id_12, t0.audio_partner_id AS audio_partner_id_13, t0.audio_libre_partner_id AS audio_libre_partner_id_14 FROM partner_subscription t0 WHERE t0.centre_id = 532;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lastname AS lastname_3,
  t0.birthdate AS birthdate_4,
  t0.mail AS mail_5,
  t0.password AS password_6,
  t0.id_centre_id AS id_centre_id_7,
  t0.permission_id AS permission_id_8
FROM
  assistante t0
WHERE
  t0.id_centre_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.birthdate AS birthdate_4, t0.mail AS mail_5, t0.password AS password_6, t0.id_centre_id AS id_centre_id_7, t0.permission_id AS permission_id_8 FROM assistante t0 WHERE t0.id_centre_id = 532;

SELECT
  t0.id AS id_1,
  t0.motif AS motif_2,
  t0.comment AS comment_3,
  t0.created_at AS created_at_4,
  t0.status AS status_5,
  t0.centre_id AS centre_id_6
FROM
  cancellation_record t0
WHERE
  t0.centre_id = ?

SELECT t0.id AS id_1, t0.motif AS motif_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.status AS status_5, t0.centre_id AS centre_id_6 FROM cancellation_record t0 WHERE t0.centre_id = 532;

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.adresse AS adresse_2,
  c0_.code_postal AS code_postal_3,
  c0_.ville AS ville_4,
  c0_.telephone AS telephone_5,
  c0_.adresse_email AS adresse_email_6,
  c0_.forme_juridique AS forme_juridique_7,
  c0_.dirigent AS dirigent_8,
  c0_.immatriculation AS immatriculation_9,
  c0_.siren AS siren_10,
  c0_.ape AS ape_11,
  c0_.annee_ca AS annee_ca_12,
  c0_.ca AS ca_13,
  c0_.resultat AS resultat_14,
  c0_.effectif AS effectif_15,
  c0_.naf AS naf_16,
  c0_.siret AS siret_17,
  c0_.effectif_min AS effectif_min_18,
  c0_.effectif_max AS effectif_max_19,
  c0_.latitude AS latitude_20,
  c0_.longitude AS longitude_21,
  c0_.invalid AS invalid_22,
  c0_.slug AS slug_23,
  (
    (c0_.longitude - ?) * (c0_.longitude - ?) + (c0_.latitude - ?) * (c0_.latitude - ?)
  ) AS sclr_24
FROM
  center_imported c0_
WHERE
  (
    c0_.longitude BETWEEN ?
    AND ?
  )
  AND (
    c0_.latitude BETWEEN ?
    AND ?
  )
ORDER BY
  sclr_24 ASC
LIMIT
  80

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.adresse AS adresse_2, c0_.code_postal AS code_postal_3, c0_.ville AS ville_4, c0_.telephone AS telephone_5, c0_.adresse_email AS adresse_email_6, c0_.forme_juridique AS forme_juridique_7, c0_.dirigent AS dirigent_8, c0_.immatriculation AS immatriculation_9, c0_.siren AS siren_10, c0_.ape AS ape_11, c0_.annee_ca AS annee_ca_12, c0_.ca AS ca_13, c0_.resultat AS resultat_14, c0_.effectif AS effectif_15, c0_.naf AS naf_16, c0_.siret AS siret_17, c0_.effectif_min AS effectif_min_18, c0_.effectif_max AS effectif_max_19, c0_.latitude AS latitude_20, c0_.longitude AS longitude_21, c0_.invalid AS invalid_22, c0_.slug AS slug_23, ((c0_.longitude - '-0.57918') * (c0_.longitude - '-0.57918') + (c0_.latitude - '44.837789') * (c0_.latitude - '44.837789')) AS sclr_24 FROM center_imported c0_ WHERE (c0_.longitude BETWEEN -0.97918 AND -0.17918) AND (c0_.latitude BETWEEN 44.437789 AND 45.237789) ORDER BY sclr_24 ASC LIMIT 80;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  center_imported c0_
WHERE
  (
    c0_.longitude BETWEEN ?
    AND ?
  )
  AND (
    c0_.latitude BETWEEN ?
    AND ?
  )

SELECT COUNT(c0_.id) AS sclr_0 FROM center_imported c0_ WHERE (c0_.longitude BETWEEN -0.97918 AND -0.17918) AND (c0_.latitude BETWEEN 44.437789 AND 45.237789);

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.is_default AS is_default_3
FROM
  motif t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.is_default AS is_default_3 FROM motif t0 WHERE t0.id = 1;

SELECT
  c0_.id AS id_0,
  c0_.address AS address_1,
  c0_.postale AS postale_2,
  c0_.numero AS numero_3,
  c0_.voie AS voie_4,
  c0_.rue AS rue_5,
  c0_.city AS city_6,
  c0_.description AS description_7,
  c0_.finess AS finess_8,
  c0_.siret AS siret_9,
  c0_.website AS website_10,
  c0_.phone AS phone_11,
  c0_.is_handicap AS is_handicap_12,
  c0_.latitude AS latitude_13,
  c0_.longitude AS longitude_14,
  c0_.name AS name_15,
  c0_.img_url AS img_url_16,
  c0_.finess_url AS finess_url_17,
  c0_.is_rdv_domicile AS is_rdv_domicile_18,
  c0_.horaire AS horaire_19,
  c0_.is_valid AS is_valid_20,
  c0_.id_dockage AS id_dockage_21,
  c0_.document_id AS document_id_22,
  c0_.facture_id AS facture_id_23,
  c0_.transaction_id AS transaction_id_24,
  c0_.is_sign AS is_sign_25,
  c0_.is_blocked AS is_blocked_26,
  c0_.mandat AS mandat_27,
  c0_.signup_date AS signup_date_28,
  c0_.calendar_color AS calendar_color_29,
  c0_.initial AS initial_30,
  c0_.slug AS slug_31,
  c0_.aditionnel_info AS aditionnel_info_32,
  c0_.horaires_holiday AS horaires_holiday_33,
  c0_.url_rdv AS url_rdv_34,
  c0_.is_visible AS is_visible_35,
  c0_.social_name AS social_name_36,
  c0_.contract_signup_date AS contract_signup_date_37,
  c0_.zone_km AS zone_km_38,
  c0_.marketing_ad_status AS marketing_ad_status_39,
  c0_.accord_use_mark_name AS accord_use_mark_name_40,
  c0_.accord_use_audio_name AS accord_use_audio_name_41,
  c0_.partner_code AS partner_code_42,
  c0_.lien_doctolib AS lien_doctolib_43,
  c0_.is_resilied AS is_resilied_44,
  (
    (c0_.longitude - ?) * (c0_.longitude - ?) + (c0_.latitude - ?) * (c0_.latitude - ?)
  ) AS sclr_45,
  c0_.id_gerant_id AS id_gerant_id_46,
  c0_.id_audio_libre_partner_id AS id_audio_libre_partner_id_47,
  c0_.ato_laudition_partner_id AS ato_laudition_partner_id_48
FROM
  centre c0_
WHERE
  (
    c0_.longitude BETWEEN ?
    AND ?
  )
  AND (
    c0_.latitude BETWEEN ?
    AND ?
  )
ORDER BY
  sclr_45 ASC
LIMIT
  80