Symfony Profiler

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

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 - -0.57918) * (c0_.longitude - -0.57918) + (c0_.latitude - 44.837789) * (c0_.latitude - 44.837789)) 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 -0.97918 AND -0.17918) AND (c0_.latitude BETWEEN 44.437789 AND 45.237789) ORDER BY sclr_45 ASC LIMIT 80;

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

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

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

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

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

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

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

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

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

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

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

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