Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.intervenant_id AS intervenant_id_5
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.intervenant_id AS intervenant_id_5 FROM `user` t0 WHERE t0.id = 594;

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.firstname AS firstname_3,
  t0.numeroClient AS numeroClient_4,
  t0.civilite AS civilite_5,
  t0.lastname AS lastname_6,
  t0.birthday AS birthday_7,
  t0.deathday AS deathday_8,
  t0.gender AS gender_9,
  t0.email AS email_10,
  t0.phone AS phone_11,
  t0.comments AS comments_12,
  t0.suivi_client AS suivi_client_13,
  t0.room_number AS room_number_14,
  t0.building_room AS building_room_15,
  t0.stairs AS stairs_16,
  t0.nom_tuteur AS nom_tuteur_17,
  t0.civilite_tuteur AS civilite_tuteur_18,
  t0.prenom_tuteur AS prenom_tuteur_19,
  t0.email_tuteur AS email_tuteur_20,
  t0.email_notaire AS email_notaire_21,
  t0.num_tuteur AS num_tuteur_22,
  t0.type_tuteur AS type_tuteur_23,
  t0.days_of_week AS days_of_week_24,
  t0.comment_tuteur AS comment_tuteur_25,
  t0.consignes_client AS consignes_client_26,
  t0.status_prospect AS status_prospect_27,
  t0.profil_client AS profil_client_28,
  t0.address_tuteur AS address_tuteur_29,
  t0.address_tuteur2 AS address_tuteur2_30,
  t0.city_tuteur AS city_tuteur_31,
  t0.zipcode AS zipcode_32,
  t0.created AS created_33,
  t0.updated AS updated_34,
  t0.privacy_policy_accepted AS privacy_policy_accepted_35,
  t0.email_agreement AS email_agreement_36,
  t0.cgv_accepted AS cgv_accepted_37,
  t0.has_signed_easy_collect AS has_signed_easy_collect_38,
  t0.address_facturation AS address_facturation_39,
  t0.complement_adresse_facturation AS complement_adresse_facturation_40,
  t0.code_postal_facturation AS code_postal_facturation_41,
  t0.ville_facturation AS ville_facturation_42,
  t0.nom_facturation AS nom_facturation_43,
  t0.prenom_facturation AS prenom_facturation_44,
  t0.civilite_facturation AS civilite_facturation_45,
  t0.site_id AS site_id_46,
  t0.contact_id AS contact_id_47,
  t0.billing_infos_id AS billing_infos_id_48,
  t0.creator_id AS creator_id_49,
  t0.maj_id AS maj_id_50
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.firstname AS firstname_3, t0.numeroClient AS numeroClient_4, t0.civilite AS civilite_5, t0.lastname AS lastname_6, t0.birthday AS birthday_7, t0.deathday AS deathday_8, t0.gender AS gender_9, t0.email AS email_10, t0.phone AS phone_11, t0.comments AS comments_12, t0.suivi_client AS suivi_client_13, t0.room_number AS room_number_14, t0.building_room AS building_room_15, t0.stairs AS stairs_16, t0.nom_tuteur AS nom_tuteur_17, t0.civilite_tuteur AS civilite_tuteur_18, t0.prenom_tuteur AS prenom_tuteur_19, t0.email_tuteur AS email_tuteur_20, t0.email_notaire AS email_notaire_21, t0.num_tuteur AS num_tuteur_22, t0.type_tuteur AS type_tuteur_23, t0.days_of_week AS days_of_week_24, t0.comment_tuteur AS comment_tuteur_25, t0.consignes_client AS consignes_client_26, t0.status_prospect AS status_prospect_27, t0.profil_client AS profil_client_28, t0.address_tuteur AS address_tuteur_29, t0.address_tuteur2 AS address_tuteur2_30, t0.city_tuteur AS city_tuteur_31, t0.zipcode AS zipcode_32, t0.created AS created_33, t0.updated AS updated_34, t0.privacy_policy_accepted AS privacy_policy_accepted_35, t0.email_agreement AS email_agreement_36, t0.cgv_accepted AS cgv_accepted_37, t0.has_signed_easy_collect AS has_signed_easy_collect_38, t0.address_facturation AS address_facturation_39, t0.complement_adresse_facturation AS complement_adresse_facturation_40, t0.code_postal_facturation AS code_postal_facturation_41, t0.ville_facturation AS ville_facturation_42, t0.nom_facturation AS nom_facturation_43, t0.prenom_facturation AS prenom_facturation_44, t0.civilite_facturation AS civilite_facturation_45, t0.site_id AS site_id_46, t0.contact_id AS contact_id_47, t0.billing_infos_id AS billing_infos_id_48, t0.creator_id AS creator_id_49, t0.maj_id AS maj_id_50 FROM client t0 WHERE t0.id = '23349';

SELECT
  t0.id AS id_1,
  t0.mode AS mode_2,
  t0.reference AS reference_3,
  t0.status AS status_4,
  t0.date AS date_5,
  t0.date_remise_chaque AS date_remise_chaque_6,
  t0.ttc AS ttc_7,
  t0.numero_remise AS numero_remise_8,
  t0.motif_cancel AS motif_cancel_9,
  t0.client_id AS client_id_10,
  t0.company_id AS company_id_11
FROM
  reglement t0
WHERE
  t0.client_id = ?
ORDER BY
  t0.id DESC
LIMIT
  12

SELECT t0.id AS id_1, t0.mode AS mode_2, t0.reference AS reference_3, t0.status AS status_4, t0.date AS date_5, t0.date_remise_chaque AS date_remise_chaque_6, t0.ttc AS ttc_7, t0.numero_remise AS numero_remise_8, t0.motif_cancel AS motif_cancel_9, t0.client_id AS client_id_10, t0.company_id AS company_id_11 FROM reglement t0 WHERE t0.client_id = 23349 ORDER BY t0.id DESC LIMIT 12;

SELECT
  b0_.id AS id_0,
  b0_.dateBilling AS dateBilling_1,
  b0_.sendingDate AS sendingDate_2,
  b0_.modeFacturation AS modeFacturation_3,
  b0_.code AS code_4,
  b0_.comment AS comment_5,
  b0_.paidPaytweak AS paidPaytweak_6,
  b0_.ht AS ht_7,
  b0_.ttc AS ttc_8,
  b0_.solde AS solde_9,
  b0_.status AS status_10,
  b0_.accompte AS accompte_11,
  b0_.linkPaytweak AS linkPaytweak_12,
  b0_.linkPaytweakExpire AS linkPaytweakExpire_13,
  b0_.type AS type_14,
  b0_.created AS created_15,
  b0_.updated AS updated_16,
  b0_.client_id AS client_id_17,
  b0_.site_id AS site_id_18,
  b0_.company_id AS company_id_19,
  b0_.reglement_id AS reglement_id_20,
  b0_.rdv_id AS rdv_id_21,
  b0_.creator_id AS creator_id_22,
  b0_.maj_id AS maj_id_23
FROM
  billing b0_
  INNER JOIN client c1_ ON b0_.client_id = c1_.id
  LEFT JOIN `rdv` r2_ ON b0_.rdv_id = r2_.id
WHERE
  c1_.id = ?
ORDER BY
  b0_.code DESC
LIMIT
  12

SELECT b0_.id AS id_0, b0_.dateBilling AS dateBilling_1, b0_.sendingDate AS sendingDate_2, b0_.modeFacturation AS modeFacturation_3, b0_.code AS code_4, b0_.comment AS comment_5, b0_.paidPaytweak AS paidPaytweak_6, b0_.ht AS ht_7, b0_.ttc AS ttc_8, b0_.solde AS solde_9, b0_.status AS status_10, b0_.accompte AS accompte_11, b0_.linkPaytweak AS linkPaytweak_12, b0_.linkPaytweakExpire AS linkPaytweakExpire_13, b0_.type AS type_14, b0_.created AS created_15, b0_.updated AS updated_16, b0_.client_id AS client_id_17, b0_.site_id AS site_id_18, b0_.company_id AS company_id_19, b0_.reglement_id AS reglement_id_20, b0_.rdv_id AS rdv_id_21, b0_.creator_id AS creator_id_22, b0_.maj_id AS maj_id_23 FROM billing b0_ INNER JOIN client c1_ ON b0_.client_id = c1_.id LEFT JOIN `rdv` r2_ ON b0_.rdv_id = r2_.id WHERE c1_.id = 23349 ORDER BY b0_.code DESC LIMIT 12;

SELECT
  b0_.id AS id_0,
  b0_.dateBilling AS dateBilling_1,
  b0_.sendingDate AS sendingDate_2,
  b0_.modeFacturation AS modeFacturation_3,
  b0_.code AS code_4,
  b0_.comment AS comment_5,
  b0_.paidPaytweak AS paidPaytweak_6,
  b0_.ht AS ht_7,
  b0_.ttc AS ttc_8,
  b0_.solde AS solde_9,
  b0_.status AS status_10,
  b0_.accompte AS accompte_11,
  b0_.linkPaytweak AS linkPaytweak_12,
  b0_.linkPaytweakExpire AS linkPaytweakExpire_13,
  b0_.type AS type_14,
  b0_.created AS created_15,
  b0_.updated AS updated_16,
  b0_.client_id AS client_id_17,
  b0_.site_id AS site_id_18,
  b0_.company_id AS company_id_19,
  b0_.reglement_id AS reglement_id_20,
  b0_.rdv_id AS rdv_id_21,
  b0_.creator_id AS creator_id_22,
  b0_.maj_id AS maj_id_23
FROM
  billing b0_
  INNER JOIN client c1_ ON b0_.client_id = c1_.id
  LEFT JOIN `rdv` r2_ ON b0_.rdv_id = r2_.id
WHERE
  c1_.id = ?

SELECT b0_.id AS id_0, b0_.dateBilling AS dateBilling_1, b0_.sendingDate AS sendingDate_2, b0_.modeFacturation AS modeFacturation_3, b0_.code AS code_4, b0_.comment AS comment_5, b0_.paidPaytweak AS paidPaytweak_6, b0_.ht AS ht_7, b0_.ttc AS ttc_8, b0_.solde AS solde_9, b0_.status AS status_10, b0_.accompte AS accompte_11, b0_.linkPaytweak AS linkPaytweak_12, b0_.linkPaytweakExpire AS linkPaytweakExpire_13, b0_.type AS type_14, b0_.created AS created_15, b0_.updated AS updated_16, b0_.client_id AS client_id_17, b0_.site_id AS site_id_18, b0_.company_id AS company_id_19, b0_.reglement_id AS reglement_id_20, b0_.rdv_id AS rdv_id_21, b0_.creator_id AS creator_id_22, b0_.maj_id AS maj_id_23 FROM billing b0_ INNER JOIN client c1_ ON b0_.client_id = c1_.id LEFT JOIN `rdv` r2_ ON b0_.rdv_id = r2_.id WHERE c1_.id = 23349;

SELECT
  t0.type AS type_1,
  t0.id AS id_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.nom_jeune_fille AS nom_jeune_fille_5,
  t0.birthday AS birthday_6,
  t0.deathday AS deathday_7,
  t0.gender AS gender_8,
  t0.email AS email_9,
  t0.phone AS phone_10,
  t0.phone_gcm AS phone_gcm_11,
  t0.comments AS comments_12,
  t0.client_id AS client_id_13,
  t0.address_id AS address_id_14
FROM
  family_member t0
WHERE
  t0.client_id = ?

SELECT t0.type AS type_1, t0.id AS id_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.nom_jeune_fille AS nom_jeune_fille_5, t0.birthday AS birthday_6, t0.deathday AS deathday_7, t0.gender AS gender_8, t0.email AS email_9, t0.phone AS phone_10, t0.phone_gcm AS phone_gcm_11, t0.comments AS comments_12, t0.client_id AS client_id_13, t0.address_id AS address_id_14 FROM family_member t0 WHERE t0.client_id = 23349;

SELECT
  t0.id AS id_1,
  t0.date_debut_relation AS date_debut_relation_2,
  t0.date_fin_relation AS date_fin_relation_3,
  t0.date_debut AS date_debut_4,
  t0.date_fin AS date_fin_5,
  t0.type_prestation AS type_prestation_6,
  t0.type_rdv AS type_rdv_7,
  t0.libelle_prestation AS libelle_prestation_8,
  t0.recurrence AS recurrence_9,
  t0.variable AS variable_10,
  t0.horaires AS horaires_11,
  t0.remarque AS remarque_12,
  t0.recurrence_generated AS recurrence_generated_13,
  t0.priorite AS priorite_14,
  t0.foumulaireReservation AS foumulaireReservation_15,
  t0.heure AS heure_16,
  t0.client_id AS client_id_17
FROM
  contract t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.date_debut_relation AS date_debut_relation_2, t0.date_fin_relation AS date_fin_relation_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.type_prestation AS type_prestation_6, t0.type_rdv AS type_rdv_7, t0.libelle_prestation AS libelle_prestation_8, t0.recurrence AS recurrence_9, t0.variable AS variable_10, t0.horaires AS horaires_11, t0.remarque AS remarque_12, t0.recurrence_generated AS recurrence_generated_13, t0.priorite AS priorite_14, t0.foumulaireReservation AS foumulaireReservation_15, t0.heure AS heure_16, t0.client_id AS client_id_17 FROM contract t0 WHERE t0.client_id = 23349;

SELECT
  t0.id AS id_1,
  t0.billing_mode AS billing_mode_2,
  t0.date_signature_mandat AS date_signature_mandat_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.discount AS discount_6,
  t0.send_mode AS send_mode_7,
  t0.pay_mode AS pay_mode_8,
  t0.esthetique AS esthetique_9,
  t0.account AS account_10,
  t0.bankName AS bankName_11,
  t0.iban AS iban_12,
  t0.bic AS bic_13,
  t0.rum AS rum_14,
  t0.company_id AS company_id_15
FROM
  billing_infos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.billing_mode AS billing_mode_2, t0.date_signature_mandat AS date_signature_mandat_3, t0.email AS email_4, t0.phone AS phone_5, t0.discount AS discount_6, t0.send_mode AS send_mode_7, t0.pay_mode AS pay_mode_8, t0.esthetique AS esthetique_9, t0.account AS account_10, t0.bankName AS bankName_11, t0.iban AS iban_12, t0.bic AS bic_13, t0.rum AS rum_14, t0.company_id AS company_id_15 FROM billing_infos t0 WHERE t0.id = 25250;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.enseigne AS enseigne_4,
  t0.phone AS phone_5,
  t0.status AS status_6,
  t0.zoneGeographique AS zoneGeographique_7,
  t0.consignesLingeries AS consignesLingeries_8,
  t0.parking AS parking_9,
  t0.rangementCles AS rangementCles_10,
  t0.localPoubelles AS localPoubelles_11,
  t0.codeAccess AS codeAccess_12,
  t0.filename AS filename_13,
  t0.autresInformations AS autresInformations_14,
  t0.emailSite AS emailSite_15,
  t0.no_display_reservation AS no_display_reservation_16,
  t0.no_display_annuaire AS no_display_annuaire_17,
  t0.created AS created_18,
  t0.updated AS updated_19,
  t0.logistique_id AS logistique_id_20,
  t0.address_id AS address_id_21,
  t0.contactCommercial_id AS contactCommercial_id_22,
  t0.contactBilling_id AS contactBilling_id_23,
  t0.contact_id AS contact_id_24,
  t0.creator_id AS creator_id_25,
  t0.maj_id AS maj_id_26
FROM
  site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.enseigne AS enseigne_4, t0.phone AS phone_5, t0.status AS status_6, t0.zoneGeographique AS zoneGeographique_7, t0.consignesLingeries AS consignesLingeries_8, t0.parking AS parking_9, t0.rangementCles AS rangementCles_10, t0.localPoubelles AS localPoubelles_11, t0.codeAccess AS codeAccess_12, t0.filename AS filename_13, t0.autresInformations AS autresInformations_14, t0.emailSite AS emailSite_15, t0.no_display_reservation AS no_display_reservation_16, t0.no_display_annuaire AS no_display_annuaire_17, t0.created AS created_18, t0.updated AS updated_19, t0.logistique_id AS logistique_id_20, t0.address_id AS address_id_21, t0.contactCommercial_id AS contactCommercial_id_22, t0.contactBilling_id AS contactBilling_id_23, t0.contact_id AS contact_id_24, t0.creator_id AS creator_id_25, t0.maj_id AS maj_id_26 FROM site t0 WHERE t0.id = 53;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tva_number AS tva_number_3,
  t0.capital AS capital_4,
  t0.siret AS siret_5,
  t0.forme AS forme_6,
  t0.urssaf_number AS urssaf_number_7,
  t0.fiscalite_number AS fiscalite_number_8,
  t0.ceo_name AS ceo_name_9,
  t0.ceo_job AS ceo_job_10,
  t0.status AS status_11,
  t0.logo AS logo_12,
  t0.endDate AS endDate_13,
  t0.textMail AS textMail_14,
  t0.mail AS mail_15,
  t0.convention AS convention_16,
  t0.telephoneStandard AS telephoneStandard_17,
  t0.address_id AS address_id_18
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tva_number AS tva_number_3, t0.capital AS capital_4, t0.siret AS siret_5, t0.forme AS forme_6, t0.urssaf_number AS urssaf_number_7, t0.fiscalite_number AS fiscalite_number_8, t0.ceo_name AS ceo_name_9, t0.ceo_job AS ceo_job_10, t0.status AS status_11, t0.logo AS logo_12, t0.endDate AS endDate_13, t0.textMail AS textMail_14, t0.mail AS mail_15, t0.convention AS convention_16, t0.telephoneStandard AS telephoneStandard_17, t0.address_id AS address_id_18 FROM company t0 WHERE t0.id = 2;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.type AS type_2,
  s0_.enseigne AS enseigne_3,
  s0_.phone AS phone_4,
  s0_.status AS status_5,
  s0_.zoneGeographique AS zoneGeographique_6,
  s0_.consignesLingeries AS consignesLingeries_7,
  s0_.parking AS parking_8,
  s0_.rangementCles AS rangementCles_9,
  s0_.localPoubelles AS localPoubelles_10,
  s0_.codeAccess AS codeAccess_11,
  s0_.filename AS filename_12,
  s0_.autresInformations AS autresInformations_13,
  s0_.emailSite AS emailSite_14,
  s0_.no_display_reservation AS no_display_reservation_15,
  s0_.no_display_annuaire AS no_display_annuaire_16,
  s0_.created AS created_17,
  s0_.updated AS updated_18,
  s0_.logistique_id AS logistique_id_19,
  s0_.address_id AS address_id_20,
  s0_.contactCommercial_id AS contactCommercial_id_21,
  s0_.contactBilling_id AS contactBilling_id_22,
  s0_.contact_id AS contact_id_23,
  s0_.creator_id AS creator_id_24,
  s0_.maj_id AS maj_id_25
FROM
  site s0_
WHERE
  s0_.id IN (?)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.enseigne AS enseigne_3, s0_.phone AS phone_4, s0_.status AS status_5, s0_.zoneGeographique AS zoneGeographique_6, s0_.consignesLingeries AS consignesLingeries_7, s0_.parking AS parking_8, s0_.rangementCles AS rangementCles_9, s0_.localPoubelles AS localPoubelles_10, s0_.codeAccess AS codeAccess_11, s0_.filename AS filename_12, s0_.autresInformations AS autresInformations_13, s0_.emailSite AS emailSite_14, s0_.no_display_reservation AS no_display_reservation_15, s0_.no_display_annuaire AS no_display_annuaire_16, s0_.created AS created_17, s0_.updated AS updated_18, s0_.logistique_id AS logistique_id_19, s0_.address_id AS address_id_20, s0_.contactCommercial_id AS contactCommercial_id_21, s0_.contactBilling_id AS contactBilling_id_22, s0_.contact_id AS contact_id_23, s0_.creator_id AS creator_id_24, s0_.maj_id AS maj_id_25 FROM site s0_ WHERE s0_.id IN ('53');

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.tva_number AS tva_number_2,
  c0_.capital AS capital_3,
  c0_.siret AS siret_4,
  c0_.forme AS forme_5,
  c0_.urssaf_number AS urssaf_number_6,
  c0_.fiscalite_number AS fiscalite_number_7,
  c0_.ceo_name AS ceo_name_8,
  c0_.ceo_job AS ceo_job_9,
  c0_.status AS status_10,
  c0_.logo AS logo_11,
  c0_.endDate AS endDate_12,
  c0_.textMail AS textMail_13,
  c0_.mail AS mail_14,
  c0_.convention AS convention_15,
  c0_.telephoneStandard AS telephoneStandard_16,
  c0_.address_id AS address_id_17
FROM
  company c0_
WHERE
  c0_.id IN (?)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.tva_number AS tva_number_2, c0_.capital AS capital_3, c0_.siret AS siret_4, c0_.forme AS forme_5, c0_.urssaf_number AS urssaf_number_6, c0_.fiscalite_number AS fiscalite_number_7, c0_.ceo_name AS ceo_name_8, c0_.ceo_job AS ceo_job_9, c0_.status AS status_10, c0_.logo AS logo_11, c0_.endDate AS endDate_12, c0_.textMail AS textMail_13, c0_.mail AS mail_14, c0_.convention AS convention_15, c0_.telephoneStandard AS telephoneStandard_16, c0_.address_id AS address_id_17 FROM company c0_ WHERE c0_.id IN ('2');

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  client
SET
  consignes_client = ?,
  updated = ?
WHERE
  id = ?

UPDATE client SET consignes_client = 'Sh sans minerve..sans soucis avec le ballon bac
pas d\'achat (mail famille )', updated = '2024-11-21 10:32:01' WHERE id = 23349;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.marque AS marque_3,
  t0.gamme AS gamme_4,
  t0.compte AS compte_5,
  t0.facturation AS facturation_6,
  t0.type_taux_tva AS type_taux_tva_7,
  t0.ui AS ui_8,
  t0.mesure AS mesure_9,
  t0.type AS type_10,
  t0.fournisseur AS fournisseur_11,
  t0.remiseGenerale AS remiseGenerale_12,
  t0.tempsNormatif AS tempsNormatif_13,
  t0.forfaitIllimite AS forfaitIllimite_14,
  t0.reference AS reference_15,
  t0.price_sell_ht_a AS price_sell_ht_a_16,
  t0.price_ht_b AS price_ht_b_17,
  t0.price_ht_c AS price_ht_c_18,
  t0.price_ht_c_d AS price_ht_c_d_19,
  t0.price_ht AS price_ht_20,
  t0.marge AS marge_21,
  t0.tva AS tva_22,
  t0.type_tva AS type_tva_23,
  t0.stock_quantity AS stock_quantity_24,
  t0.gestion_stock AS gestion_stock_25,
  t0.order_multiple AS order_multiple_26,
  t0.indisponible_vente AS indisponible_vente_27,
  t0.unitVente AS unitVente_28,
  t0.mandatory AS mandatory_29,
  t0.no_reservation AS no_reservation_30,
  t0.commercial_name AS commercial_name_31,
  t0.checked AS checked_32,
  t0.ordering AS ordering_33,
  t0.product_type AS product_type_34,
  t0.famille AS famille_35,
  t0.sous_famille AS sous_famille_36
FROM
  product t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.marque AS marque_3, t0.gamme AS gamme_4, t0.compte AS compte_5, t0.facturation AS facturation_6, t0.type_taux_tva AS type_taux_tva_7, t0.ui AS ui_8, t0.mesure AS mesure_9, t0.type AS type_10, t0.fournisseur AS fournisseur_11, t0.remiseGenerale AS remiseGenerale_12, t0.tempsNormatif AS tempsNormatif_13, t0.forfaitIllimite AS forfaitIllimite_14, t0.reference AS reference_15, t0.price_sell_ht_a AS price_sell_ht_a_16, t0.price_ht_b AS price_ht_b_17, t0.price_ht_c AS price_ht_c_18, t0.price_ht_c_d AS price_ht_c_d_19, t0.price_ht AS price_ht_20, t0.marge AS marge_21, t0.tva AS tva_22, t0.type_tva AS type_tva_23, t0.stock_quantity AS stock_quantity_24, t0.gestion_stock AS gestion_stock_25, t0.order_multiple AS order_multiple_26, t0.indisponible_vente AS indisponible_vente_27, t0.unitVente AS unitVente_28, t0.mandatory AS mandatory_29, t0.no_reservation AS no_reservation_30, t0.commercial_name AS commercial_name_31, t0.checked AS checked_32, t0.ordering AS ordering_33, t0.product_type AS product_type_34, t0.famille AS famille_35, t0.sous_famille AS sous_famille_36 FROM product t0;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.type AS type_2,
  s0_.enseigne AS enseigne_3,
  s0_.phone AS phone_4,
  s0_.status AS status_5,
  s0_.zoneGeographique AS zoneGeographique_6,
  s0_.consignesLingeries AS consignesLingeries_7,
  s0_.parking AS parking_8,
  s0_.rangementCles AS rangementCles_9,
  s0_.localPoubelles AS localPoubelles_10,
  s0_.codeAccess AS codeAccess_11,
  s0_.filename AS filename_12,
  s0_.autresInformations AS autresInformations_13,
  s0_.emailSite AS emailSite_14,
  s0_.no_display_reservation AS no_display_reservation_15,
  s0_.no_display_annuaire AS no_display_annuaire_16,
  s0_.created AS created_17,
  s0_.updated AS updated_18,
  s0_.logistique_id AS logistique_id_19,
  s0_.address_id AS address_id_20,
  s0_.contactCommercial_id AS contactCommercial_id_21,
  s0_.contactBilling_id AS contactBilling_id_22,
  s0_.contact_id AS contact_id_23,
  s0_.creator_id AS creator_id_24,
  s0_.maj_id AS maj_id_25
FROM
  site s0_

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.enseigne AS enseigne_3, s0_.phone AS phone_4, s0_.status AS status_5, s0_.zoneGeographique AS zoneGeographique_6, s0_.consignesLingeries AS consignesLingeries_7, s0_.parking AS parking_8, s0_.rangementCles AS rangementCles_9, s0_.localPoubelles AS localPoubelles_10, s0_.codeAccess AS codeAccess_11, s0_.filename AS filename_12, s0_.autresInformations AS autresInformations_13, s0_.emailSite AS emailSite_14, s0_.no_display_reservation AS no_display_reservation_15, s0_.no_display_annuaire AS no_display_annuaire_16, s0_.created AS created_17, s0_.updated AS updated_18, s0_.logistique_id AS logistique_id_19, s0_.address_id AS address_id_20, s0_.contactCommercial_id AS contactCommercial_id_21, s0_.contactBilling_id AS contactBilling_id_22, s0_.contact_id AS contact_id_23, s0_.creator_id AS creator_id_24, s0_.maj_id AS maj_id_25 FROM site s0_;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.tva_number AS tva_number_2,
  c0_.capital AS capital_3,
  c0_.siret AS siret_4,
  c0_.forme AS forme_5,
  c0_.urssaf_number AS urssaf_number_6,
  c0_.fiscalite_number AS fiscalite_number_7,
  c0_.ceo_name AS ceo_name_8,
  c0_.ceo_job AS ceo_job_9,
  c0_.status AS status_10,
  c0_.logo AS logo_11,
  c0_.endDate AS endDate_12,
  c0_.textMail AS textMail_13,
  c0_.mail AS mail_14,
  c0_.convention AS convention_15,
  c0_.telephoneStandard AS telephoneStandard_16,
  c0_.address_id AS address_id_17
FROM
  company c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.tva_number AS tva_number_2, c0_.capital AS capital_3, c0_.siret AS siret_4, c0_.forme AS forme_5, c0_.urssaf_number AS urssaf_number_6, c0_.fiscalite_number AS fiscalite_number_7, c0_.ceo_name AS ceo_name_8, c0_.ceo_job AS ceo_job_9, c0_.status AS status_10, c0_.logo AS logo_11, c0_.endDate AS endDate_12, c0_.textMail AS textMail_13, c0_.mail AS mail_14, c0_.convention AS convention_15, c0_.telephoneStandard AS telephoneStandard_16, c0_.address_id AS address_id_17 FROM company c0_;

SELECT
  t0.id AS id_1,
  t0.dateBilling AS dateBilling_2,
  t0.sendingDate AS sendingDate_3,
  t0.modeFacturation AS modeFacturation_4,
  t0.code AS code_5,
  t0.comment AS comment_6,
  t0.paidPaytweak AS paidPaytweak_7,
  t0.ht AS ht_8,
  t0.ttc AS ttc_9,
  t0.solde AS solde_10,
  t0.status AS status_11,
  t0.accompte AS accompte_12,
  t0.linkPaytweak AS linkPaytweak_13,
  t0.linkPaytweakExpire AS linkPaytweakExpire_14,
  t0.type AS type_15,
  t0.created AS created_16,
  t0.updated AS updated_17,
  t0.client_id AS client_id_18,
  t0.site_id AS site_id_19,
  t0.company_id AS company_id_20,
  t0.reglement_id AS reglement_id_21,
  t0.rdv_id AS rdv_id_22,
  t0.creator_id AS creator_id_23,
  t0.maj_id AS maj_id_24
FROM
  billing t0
WHERE
  t0.client_id = ?

SELECT t0.id AS id_1, t0.dateBilling AS dateBilling_2, t0.sendingDate AS sendingDate_3, t0.modeFacturation AS modeFacturation_4, t0.code AS code_5, t0.comment AS comment_6, t0.paidPaytweak AS paidPaytweak_7, t0.ht AS ht_8, t0.ttc AS ttc_9, t0.solde AS solde_10, t0.status AS status_11, t0.accompte AS accompte_12, t0.linkPaytweak AS linkPaytweak_13, t0.linkPaytweakExpire AS linkPaytweakExpire_14, t0.type AS type_15, t0.created AS created_16, t0.updated AS updated_17, t0.client_id AS client_id_18, t0.site_id AS site_id_19, t0.company_id AS company_id_20, t0.reglement_id AS reglement_id_21, t0.rdv_id AS rdv_id_22, t0.creator_id AS creator_id_23, t0.maj_id AS maj_id_24 FROM billing t0 WHERE t0.client_id = 23349;

SELECT
  t0.id AS id_1,
  t0.dateBilling AS dateBilling_2,
  t0.sendingDate AS sendingDate_3,
  t0.modeFacturation AS modeFacturation_4,
  t0.code AS code_5,
  t0.comment AS comment_6,
  t0.paidPaytweak AS paidPaytweak_7,
  t0.ht AS ht_8,
  t0.ttc AS ttc_9,
  t0.solde AS solde_10,
  t0.status AS status_11,
  t0.accompte AS accompte_12,
  t0.linkPaytweak AS linkPaytweak_13,
  t0.linkPaytweakExpire AS linkPaytweakExpire_14,
  t0.type AS type_15,
  t0.created AS created_16,
  t0.updated AS updated_17,
  t0.client_id AS client_id_18,
  t0.site_id AS site_id_19,
  t0.company_id AS company_id_20,
  t0.reglement_id AS reglement_id_21,
  t0.rdv_id AS rdv_id_22,
  t0.creator_id AS creator_id_23,
  t0.maj_id AS maj_id_24
FROM
  billing t0
WHERE
  t0.reglement_id = ?

SELECT t0.id AS id_1, t0.dateBilling AS dateBilling_2, t0.sendingDate AS sendingDate_3, t0.modeFacturation AS modeFacturation_4, t0.code AS code_5, t0.comment AS comment_6, t0.paidPaytweak AS paidPaytweak_7, t0.ht AS ht_8, t0.ttc AS ttc_9, t0.solde AS solde_10, t0.status AS status_11, t0.accompte AS accompte_12, t0.linkPaytweak AS linkPaytweak_13, t0.linkPaytweakExpire AS linkPaytweakExpire_14, t0.type AS type_15, t0.created AS created_16, t0.updated AS updated_17, t0.client_id AS client_id_18, t0.site_id AS site_id_19, t0.company_id AS company_id_20, t0.reglement_id AS reglement_id_21, t0.rdv_id AS rdv_id_22, t0.creator_id AS creator_id_23, t0.maj_id AS maj_id_24 FROM billing t0 WHERE t0.reglement_id = 83213;