Symfony Profiler

SELECT
  t0.status AS status_1,
  t0.id AS id_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.first_name AS first_name_5,
  t0.password AS password_6,
  t0.last_name AS last_name_7,
  t0.type AS type_8,
  t0.change_password AS change_password_9,
  t0.contact_id AS contact_id_10,
  t0.region_id AS region_id_11,
  t0.commission_id AS commission_id_12
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.status AS status_1, t0.id AS id_2, t0.email AS email_3, t0.roles AS roles_4, t0.first_name AS first_name_5, t0.password AS password_6, t0.last_name AS last_name_7, t0.type AS type_8, t0.change_password AS change_password_9, t0.contact_id AS contact_id_10, t0.region_id AS region_id_11, t0.commission_id AS commission_id_12 FROM user t0 WHERE t0.id = 437;

SELECT
  t0.status AS status_1,
  t0.id AS id_2,
  t0.raison_social AS raison_social_3,
  t0.adresse AS adresse_4,
  t0.tel1 AS tel1_5,
  t0.tel2 AS tel2_6,
  t0.fax AS fax_7,
  t0.email AS email_8,
  t0.code_siren AS code_siren_9,
  t0.code_ape AS code_ape_10,
  t0.num_tva_intracom AS num_tva_intracom_11,
  t0.ancien_identifiant AS ancien_identifiant_12,
  t0.identifiant_compta AS identifiant_compta_13,
  t0.num_ede_negoce AS num_ede_negoce_14,
  t0.num_ede_centre AS num_ede_centre_15,
  t0.num_ede_elevage AS num_ede_elevage_16,
  t0.nombre_employes AS nombre_employes_17,
  t0.autre_specialite AS autre_specialite_18,
  t0.volume_animaux AS volume_animaux_19,
  t0.souhaite_adherer AS souhaite_adherer_20,
  t0.figurer_annuaire_adherents AS figurer_annuaire_adherents_21,
  t0.figurer_annuaire_internet AS figurer_annuaire_internet_22,
  t0.figurer_au_nom_de AS figurer_au_nom_de_23,
  t0.statut_paiement AS statut_paiement_24,
  t0.raison_non_adhesion AS raison_non_adhesion_25,
  t0.date_cessation AS date_cessation_26,
  t0.chiffre_dernier_total AS chiffre_dernier_total_27,
  t0.commentaires AS commentaires_28,
  t0.is_transporter AS is_transporter_29,
  t0.transport_pour_autrui AS transport_pour_autrui_30,
  t0.lien_url AS lien_url_31,
  t0.ville AS ville_32,
  t0.code_postal AS code_postal_33,
  t0.adresse2 AS adresse2_34,
  t0.nombre_veaux AS nombre_veaux_35,
  t0.nombre_maigres AS nombre_maigres_36,
  t0.nombre_elev_prod AS nombre_elev_prod_37,
  t0.nombre_boucherie AS nombre_boucherie_38,
  t0.nombre_ovins AS nombre_ovins_39,
  t0.nombre_porcins AS nombre_porcins_40,
  t0.nombre_equins AS nombre_equins_41,
  t0.nombre_caprins AS nombre_caprins_42,
  t0.autre_activite AS autre_activite_43,
  t0.code_adherent AS code_adherent_44,
  t0.is_quali_negoce AS is_quali_negoce_45,
  t0.quali_negoce_certification_date AS quali_negoce_certification_date_46,
  t0.quali_negoce_contact_name AS quali_negoce_contact_name_47,
  t0.raison_non_adhesion_autre AS raison_non_adhesion_autre_48,
  t0.total_count_species AS total_count_species_49,
  t0.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_50,
  t0.is_member AS is_member_51,
  t0.groupe_entreprise_id AS groupe_entreprise_id_52,
  t0.departement_id AS departement_id_53,
  t0.syndicat_id AS syndicat_id_54,
  t0.transporteur_id AS transporteur_id_55,
  t0.contact_responsable_id AS contact_responsable_id_56,
  t0.home_region_id AS home_region_id_57,
  t0.commission_id AS commission_id_58,
  t0.quali_negoce_contact_id AS quali_negoce_contact_id_59,
  t0.firm_type_id AS firm_type_id_60
FROM
  entreprise t0
WHERE
  t0.id = ?

SELECT t0.status AS status_1, t0.id AS id_2, t0.raison_social AS raison_social_3, t0.adresse AS adresse_4, t0.tel1 AS tel1_5, t0.tel2 AS tel2_6, t0.fax AS fax_7, t0.email AS email_8, t0.code_siren AS code_siren_9, t0.code_ape AS code_ape_10, t0.num_tva_intracom AS num_tva_intracom_11, t0.ancien_identifiant AS ancien_identifiant_12, t0.identifiant_compta AS identifiant_compta_13, t0.num_ede_negoce AS num_ede_negoce_14, t0.num_ede_centre AS num_ede_centre_15, t0.num_ede_elevage AS num_ede_elevage_16, t0.nombre_employes AS nombre_employes_17, t0.autre_specialite AS autre_specialite_18, t0.volume_animaux AS volume_animaux_19, t0.souhaite_adherer AS souhaite_adherer_20, t0.figurer_annuaire_adherents AS figurer_annuaire_adherents_21, t0.figurer_annuaire_internet AS figurer_annuaire_internet_22, t0.figurer_au_nom_de AS figurer_au_nom_de_23, t0.statut_paiement AS statut_paiement_24, t0.raison_non_adhesion AS raison_non_adhesion_25, t0.date_cessation AS date_cessation_26, t0.chiffre_dernier_total AS chiffre_dernier_total_27, t0.commentaires AS commentaires_28, t0.is_transporter AS is_transporter_29, t0.transport_pour_autrui AS transport_pour_autrui_30, t0.lien_url AS lien_url_31, t0.ville AS ville_32, t0.code_postal AS code_postal_33, t0.adresse2 AS adresse2_34, t0.nombre_veaux AS nombre_veaux_35, t0.nombre_maigres AS nombre_maigres_36, t0.nombre_elev_prod AS nombre_elev_prod_37, t0.nombre_boucherie AS nombre_boucherie_38, t0.nombre_ovins AS nombre_ovins_39, t0.nombre_porcins AS nombre_porcins_40, t0.nombre_equins AS nombre_equins_41, t0.nombre_caprins AS nombre_caprins_42, t0.autre_activite AS autre_activite_43, t0.code_adherent AS code_adherent_44, t0.is_quali_negoce AS is_quali_negoce_45, t0.quali_negoce_certification_date AS quali_negoce_certification_date_46, t0.quali_negoce_contact_name AS quali_negoce_contact_name_47, t0.raison_non_adhesion_autre AS raison_non_adhesion_autre_48, t0.total_count_species AS total_count_species_49, t0.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_50, t0.is_member AS is_member_51, t0.groupe_entreprise_id AS groupe_entreprise_id_52, t0.departement_id AS departement_id_53, t0.syndicat_id AS syndicat_id_54, t0.transporteur_id AS transporteur_id_55, t0.contact_responsable_id AS contact_responsable_id_56, t0.home_region_id AS home_region_id_57, t0.commission_id AS commission_id_58, t0.quali_negoce_contact_id AS quali_negoce_contact_id_59, t0.firm_type_id AS firm_type_id_60 FROM entreprise t0 WHERE t0.id = '1611';

SELECT
  c0_.status AS status_0,
  c0_.id AS id_1,
  c0_.annee_cotisation AS annee_cotisation_2,
  c0_.montant_cotisation AS montant_cotisation_3,
  c0_.commentaire AS commentaire_4,
  c0_.date_paiement AS date_paiement_5,
  c0_.revenue AS revenue_6,
  c0_.year AS year_7,
  c0_.revenue_date AS revenue_date_8,
  c0_.option_import_export AS option_import_export_9,
  c0_.option_mapa AS option_mapa_10,
  c0_.price_ht AS price_ht_11,
  c0_.price_vat AS price_vat_12,
  c0_.price_ttc AS price_ttc_13,
  c0_.internal_licence AS internal_licence_14,
  c0_.community_licence AS community_licence_15,
  c0_.price_department_part AS price_department_part_16,
  c0_.price_national_part AS price_national_part_17,
  c0_.price_national_part_calculated AS price_national_part_calculated_18,
  c0_.price_option_import_export AS price_option_import_export_19,
  c0_.price_option_mapa AS price_option_mapa_20,
  c0_.document AS document_21,
  c0_.original_document_name AS original_document_name_22,
  c0_.proof_of_payment AS proof_of_payment_23,
  c0_.original_proof_of_payment_name AS original_proof_of_payment_name_24,
  c0_.young_member_year_number AS young_member_year_number_25,
  c0_.created_at AS created_at_26,
  c0_.updated_at AS updated_at_27,
  c0_.cotisation_statut_id AS cotisation_statut_id_28,
  c0_.entreprise_id AS entreprise_id_29,
  c0_.type_offre_id AS type_offre_id_30,
  c0_.cotisation_type_id AS cotisation_type_id_31,
  c0_.associeted_order_id AS associeted_order_id_32
FROM
  cotisation c0_
  LEFT JOIN cotisation_statut c1_ ON c0_.cotisation_statut_id = c1_.id
WHERE
  c0_.entreprise_id = ?
  AND c1_.nom = ?
  AND c0_.status = ?
  AND c0_.year = ?

SELECT c0_.status AS status_0, c0_.id AS id_1, c0_.annee_cotisation AS annee_cotisation_2, c0_.montant_cotisation AS montant_cotisation_3, c0_.commentaire AS commentaire_4, c0_.date_paiement AS date_paiement_5, c0_.revenue AS revenue_6, c0_.year AS year_7, c0_.revenue_date AS revenue_date_8, c0_.option_import_export AS option_import_export_9, c0_.option_mapa AS option_mapa_10, c0_.price_ht AS price_ht_11, c0_.price_vat AS price_vat_12, c0_.price_ttc AS price_ttc_13, c0_.internal_licence AS internal_licence_14, c0_.community_licence AS community_licence_15, c0_.price_department_part AS price_department_part_16, c0_.price_national_part AS price_national_part_17, c0_.price_national_part_calculated AS price_national_part_calculated_18, c0_.price_option_import_export AS price_option_import_export_19, c0_.price_option_mapa AS price_option_mapa_20, c0_.document AS document_21, c0_.original_document_name AS original_document_name_22, c0_.proof_of_payment AS proof_of_payment_23, c0_.original_proof_of_payment_name AS original_proof_of_payment_name_24, c0_.young_member_year_number AS young_member_year_number_25, c0_.created_at AS created_at_26, c0_.updated_at AS updated_at_27, c0_.cotisation_statut_id AS cotisation_statut_id_28, c0_.entreprise_id AS entreprise_id_29, c0_.type_offre_id AS type_offre_id_30, c0_.cotisation_type_id AS cotisation_type_id_31, c0_.associeted_order_id AS associeted_order_id_32 FROM cotisation c0_ LEFT JOIN cotisation_statut c1_ ON c0_.cotisation_statut_id = c1_.id WHERE c0_.entreprise_id = 1611 AND c1_.nom = 'payé' AND c0_.status = 2 AND c0_.year = 2024;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.comment AS comment_3,
  t0.from_firm_id AS from_firm_id_4,
  t0.to_firm_id AS to_firm_id_5,
  t0.type_id AS type_id_6
FROM
  linked_firm t0
WHERE
  t0.from_firm_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.comment AS comment_3, t0.from_firm_id AS from_firm_id_4, t0.to_firm_id AS to_firm_id_5, t0.type_id AS type_id_6 FROM linked_firm t0 WHERE t0.from_firm_id = 1611;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.comment AS comment_3,
  t0.from_firm_id AS from_firm_id_4,
  t0.to_firm_id AS to_firm_id_5,
  t0.type_id AS type_id_6
FROM
  linked_firm t0
WHERE
  t0.to_firm_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.comment AS comment_3, t0.from_firm_id AS from_firm_id_4, t0.to_firm_id AS to_firm_id_5, t0.type_id AS type_id_6 FROM linked_firm t0 WHERE t0.to_firm_id = 1611;

SELECT
  t0.status AS status_1,
  t0.id AS id_2,
  t0.annee_cotisation AS annee_cotisation_3,
  t0.montant_cotisation AS montant_cotisation_4,
  t0.commentaire AS commentaire_5,
  t0.date_paiement AS date_paiement_6,
  t0.revenue AS revenue_7,
  t0.year AS year_8,
  t0.revenue_date AS revenue_date_9,
  t0.option_import_export AS option_import_export_10,
  t0.option_mapa AS option_mapa_11,
  t0.price_ht AS price_ht_12,
  t0.price_vat AS price_vat_13,
  t0.price_ttc AS price_ttc_14,
  t0.internal_licence AS internal_licence_15,
  t0.community_licence AS community_licence_16,
  t0.price_department_part AS price_department_part_17,
  t0.price_national_part AS price_national_part_18,
  t0.price_national_part_calculated AS price_national_part_calculated_19,
  t0.price_option_import_export AS price_option_import_export_20,
  t0.price_option_mapa AS price_option_mapa_21,
  t0.document AS document_22,
  t0.original_document_name AS original_document_name_23,
  t0.proof_of_payment AS proof_of_payment_24,
  t0.original_proof_of_payment_name AS original_proof_of_payment_name_25,
  t0.young_member_year_number AS young_member_year_number_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.cotisation_statut_id AS cotisation_statut_id_29,
  t0.entreprise_id AS entreprise_id_30,
  t0.type_offre_id AS type_offre_id_31,
  t0.cotisation_type_id AS cotisation_type_id_32,
  t0.associeted_order_id AS associeted_order_id_33
FROM
  cotisation t0
WHERE
  t0.entreprise_id = ?
ORDER BY
  t0.year DESC

SELECT t0.status AS status_1, t0.id AS id_2, t0.annee_cotisation AS annee_cotisation_3, t0.montant_cotisation AS montant_cotisation_4, t0.commentaire AS commentaire_5, t0.date_paiement AS date_paiement_6, t0.revenue AS revenue_7, t0.year AS year_8, t0.revenue_date AS revenue_date_9, t0.option_import_export AS option_import_export_10, t0.option_mapa AS option_mapa_11, t0.price_ht AS price_ht_12, t0.price_vat AS price_vat_13, t0.price_ttc AS price_ttc_14, t0.internal_licence AS internal_licence_15, t0.community_licence AS community_licence_16, t0.price_department_part AS price_department_part_17, t0.price_national_part AS price_national_part_18, t0.price_national_part_calculated AS price_national_part_calculated_19, t0.price_option_import_export AS price_option_import_export_20, t0.price_option_mapa AS price_option_mapa_21, t0.document AS document_22, t0.original_document_name AS original_document_name_23, t0.proof_of_payment AS proof_of_payment_24, t0.original_proof_of_payment_name AS original_proof_of_payment_name_25, t0.young_member_year_number AS young_member_year_number_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.cotisation_statut_id AS cotisation_statut_id_29, t0.entreprise_id AS entreprise_id_30, t0.type_offre_id AS type_offre_id_31, t0.cotisation_type_id AS cotisation_type_id_32, t0.associeted_order_id AS associeted_order_id_33 FROM cotisation t0 WHERE t0.entreprise_id = 1611 ORDER BY t0.year DESC;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1
FROM
  firm_link_reason f0_

SELECT f0_.id AS id_0, f0_.name AS name_1 FROM firm_link_reason f0_;

SELECT
  COUNT(*)
FROM
  user_question t0
WHERE
  t0.is_new = ?

SELECT COUNT(*) FROM user_question t0 WHERE t0.is_new = 1;

SELECT
  COUNT(*)
FROM
  user_question t0
WHERE
  t0.is_new = ?

SELECT COUNT(*) FROM user_question t0 WHERE t0.is_new = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tag AS tag_3,
  t0.color AS color_4
FROM
  firm_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.color AS color_4 FROM firm_type t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.num_depart AS num_depart_3,
  t0.is_billed_by_department AS is_billed_by_department_4,
  t0.region_id AS region_id_5
FROM
  departement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.num_depart AS num_depart_3, t0.is_billed_by_department AS is_billed_by_department_4, t0.region_id AS region_id_5 FROM departement t0 WHERE t0.id = 52;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  region t0
  INNER JOIN departement_region ON t0.id = departement_region.region_id
WHERE
  departement_region.departement_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM region t0 INNER JOIN departement_region ON t0.id = departement_region.region_id WHERE departement_region.departement_id = 52;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.nom AS nom_3,
  t0.comment AS comment_4,
  t0.syndicat_regional_id AS syndicat_regional_id_5,
  t0.region_id AS region_id_6,
  t0.departement_id AS departement_id_7
FROM
  syndicat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.nom AS nom_3, t0.comment AS comment_4, t0.syndicat_regional_id AS syndicat_regional_id_5, t0.region_id AS region_id_6, t0.departement_id AS departement_id_7 FROM syndicat t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse AS adresse_3,
  t0.tel_bureau1 AS tel_bureau1_4,
  t0.tel_bureau2 AS tel_bureau2_5,
  t0.fax AS fax_6,
  t0.email_bureau AS email_bureau_7,
  t0.code_siret AS code_siret_8,
  t0.siege_social AS siege_social_9,
  t0.date_cessation AS date_cessation_10,
  t0.commentaire AS commentaire_11,
  t0.code_postal AS code_postal_12,
  t0.ville AS ville_13,
  t0.code_ede AS code_ede_14,
  t0.syndicat_id AS syndicat_id_15,
  t0.entreprise_id AS entreprise_id_16,
  t0.departement_id AS departement_id_17
FROM
  etablissement t0
WHERE
  t0.entreprise_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.tel_bureau1 AS tel_bureau1_4, t0.tel_bureau2 AS tel_bureau2_5, t0.fax AS fax_6, t0.email_bureau AS email_bureau_7, t0.code_siret AS code_siret_8, t0.siege_social AS siege_social_9, t0.date_cessation AS date_cessation_10, t0.commentaire AS commentaire_11, t0.code_postal AS code_postal_12, t0.ville AS ville_13, t0.code_ede AS code_ede_14, t0.syndicat_id AS syndicat_id_15, t0.entreprise_id AS entreprise_id_16, t0.departement_id AS departement_id_17 FROM etablissement t0 WHERE t0.entreprise_id = 1611;

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.checked AS checked_3,
  t0.entreprise_id AS entreprise_id_4,
  t0.activity_id AS activity_id_5
FROM
  entreprise_activity t0
WHERE
  t0.entreprise_id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.checked AS checked_3, t0.entreprise_id AS entreprise_id_4, t0.activity_id AS activity_id_5 FROM entreprise_activity t0 WHERE t0.entreprise_id = 1611;

SELECT
  t0.status AS status_1,
  t0.id AS id_2,
  t0.type_contact AS type_contact_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.tel_portable AS tel_portable_6,
  t0.tel_portable2 AS tel_portable2_7,
  t0.tel_bureau AS tel_bureau_8,
  t0.email_contact AS email_contact_9,
  t0.date_naissance AS date_naissance_10,
  t0.commentaire AS commentaire_11,
  t0.adresse AS adresse_12,
  t0.adresse2 AS adresse2_13,
  t0.ville AS ville_14,
  t0.code_postal AS code_postal_15,
  t0.is_responsible AS is_responsible_16,
  t0.is_privileged AS is_privileged_17,
  t0.civilite AS civilite_18,
  t0.type AS type_19,
  t20.status AS status_21,
  t20.id AS id_22,
  t20.raison_social AS raison_social_23,
  t20.adresse AS adresse_24,
  t20.tel1 AS tel1_25,
  t20.tel2 AS tel2_26,
  t20.fax AS fax_27,
  t20.email AS email_28,
  t20.code_siren AS code_siren_29,
  t20.code_ape AS code_ape_30,
  t20.num_tva_intracom AS num_tva_intracom_31,
  t20.ancien_identifiant AS ancien_identifiant_32,
  t20.identifiant_compta AS identifiant_compta_33,
  t20.num_ede_negoce AS num_ede_negoce_34,
  t20.num_ede_centre AS num_ede_centre_35,
  t20.num_ede_elevage AS num_ede_elevage_36,
  t20.nombre_employes AS nombre_employes_37,
  t20.autre_specialite AS autre_specialite_38,
  t20.volume_animaux AS volume_animaux_39,
  t20.souhaite_adherer AS souhaite_adherer_40,
  t20.figurer_annuaire_adherents AS figurer_annuaire_adherents_41,
  t20.figurer_annuaire_internet AS figurer_annuaire_internet_42,
  t20.figurer_au_nom_de AS figurer_au_nom_de_43,
  t20.statut_paiement AS statut_paiement_44,
  t20.raison_non_adhesion AS raison_non_adhesion_45,
  t20.date_cessation AS date_cessation_46,
  t20.chiffre_dernier_total AS chiffre_dernier_total_47,
  t20.commentaires AS commentaires_48,
  t20.is_transporter AS is_transporter_49,
  t20.transport_pour_autrui AS transport_pour_autrui_50,
  t20.lien_url AS lien_url_51,
  t20.ville AS ville_52,
  t20.code_postal AS code_postal_53,
  t20.adresse2 AS adresse2_54,
  t20.nombre_veaux AS nombre_veaux_55,
  t20.nombre_maigres AS nombre_maigres_56,
  t20.nombre_elev_prod AS nombre_elev_prod_57,
  t20.nombre_boucherie AS nombre_boucherie_58,
  t20.nombre_ovins AS nombre_ovins_59,
  t20.nombre_porcins AS nombre_porcins_60,
  t20.nombre_equins AS nombre_equins_61,
  t20.nombre_caprins AS nombre_caprins_62,
  t20.autre_activite AS autre_activite_63,
  t20.code_adherent AS code_adherent_64,
  t20.is_quali_negoce AS is_quali_negoce_65,
  t20.quali_negoce_certification_date AS quali_negoce_certification_date_66,
  t20.quali_negoce_contact_name AS quali_negoce_contact_name_67,
  t20.raison_non_adhesion_autre AS raison_non_adhesion_autre_68,
  t20.total_count_species AS total_count_species_69,
  t20.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_70,
  t20.is_member AS is_member_71,
  t20.groupe_entreprise_id AS groupe_entreprise_id_72,
  t20.departement_id AS departement_id_73,
  t20.syndicat_id AS syndicat_id_74,
  t20.transporteur_id AS transporteur_id_75,
  t20.contact_responsable_id AS contact_responsable_id_76,
  t20.home_region_id AS home_region_id_77,
  t20.commission_id AS commission_id_78,
  t20.quali_negoce_contact_id AS quali_negoce_contact_id_79,
  t20.firm_type_id AS firm_type_id_80,
  t0.firm_id AS firm_id_81,
  t0.user_id AS user_id_82,
  t0.etablissement_id AS etablissement_id_83
FROM
  contact t0
  LEFT JOIN entreprise t20 ON t20.contact_responsable_id = t0.id
WHERE
  t0.firm_id = ?
ORDER BY
  t0.is_responsible DESC

SELECT t0.status AS status_1, t0.id AS id_2, t0.type_contact AS type_contact_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.tel_portable AS tel_portable_6, t0.tel_portable2 AS tel_portable2_7, t0.tel_bureau AS tel_bureau_8, t0.email_contact AS email_contact_9, t0.date_naissance AS date_naissance_10, t0.commentaire AS commentaire_11, t0.adresse AS adresse_12, t0.adresse2 AS adresse2_13, t0.ville AS ville_14, t0.code_postal AS code_postal_15, t0.is_responsible AS is_responsible_16, t0.is_privileged AS is_privileged_17, t0.civilite AS civilite_18, t0.type AS type_19, t20.status AS status_21, t20.id AS id_22, t20.raison_social AS raison_social_23, t20.adresse AS adresse_24, t20.tel1 AS tel1_25, t20.tel2 AS tel2_26, t20.fax AS fax_27, t20.email AS email_28, t20.code_siren AS code_siren_29, t20.code_ape AS code_ape_30, t20.num_tva_intracom AS num_tva_intracom_31, t20.ancien_identifiant AS ancien_identifiant_32, t20.identifiant_compta AS identifiant_compta_33, t20.num_ede_negoce AS num_ede_negoce_34, t20.num_ede_centre AS num_ede_centre_35, t20.num_ede_elevage AS num_ede_elevage_36, t20.nombre_employes AS nombre_employes_37, t20.autre_specialite AS autre_specialite_38, t20.volume_animaux AS volume_animaux_39, t20.souhaite_adherer AS souhaite_adherer_40, t20.figurer_annuaire_adherents AS figurer_annuaire_adherents_41, t20.figurer_annuaire_internet AS figurer_annuaire_internet_42, t20.figurer_au_nom_de AS figurer_au_nom_de_43, t20.statut_paiement AS statut_paiement_44, t20.raison_non_adhesion AS raison_non_adhesion_45, t20.date_cessation AS date_cessation_46, t20.chiffre_dernier_total AS chiffre_dernier_total_47, t20.commentaires AS commentaires_48, t20.is_transporter AS is_transporter_49, t20.transport_pour_autrui AS transport_pour_autrui_50, t20.lien_url AS lien_url_51, t20.ville AS ville_52, t20.code_postal AS code_postal_53, t20.adresse2 AS adresse2_54, t20.nombre_veaux AS nombre_veaux_55, t20.nombre_maigres AS nombre_maigres_56, t20.nombre_elev_prod AS nombre_elev_prod_57, t20.nombre_boucherie AS nombre_boucherie_58, t20.nombre_ovins AS nombre_ovins_59, t20.nombre_porcins AS nombre_porcins_60, t20.nombre_equins AS nombre_equins_61, t20.nombre_caprins AS nombre_caprins_62, t20.autre_activite AS autre_activite_63, t20.code_adherent AS code_adherent_64, t20.is_quali_negoce AS is_quali_negoce_65, t20.quali_negoce_certification_date AS quali_negoce_certification_date_66, t20.quali_negoce_contact_name AS quali_negoce_contact_name_67, t20.raison_non_adhesion_autre AS raison_non_adhesion_autre_68, t20.total_count_species AS total_count_species_69, t20.quali_negoce_pre_audit_date AS quali_negoce_pre_audit_date_70, t20.is_member AS is_member_71, t20.groupe_entreprise_id AS groupe_entreprise_id_72, t20.departement_id AS departement_id_73, t20.syndicat_id AS syndicat_id_74, t20.transporteur_id AS transporteur_id_75, t20.contact_responsable_id AS contact_responsable_id_76, t20.home_region_id AS home_region_id_77, t20.commission_id AS commission_id_78, t20.quali_negoce_contact_id AS quali_negoce_contact_id_79, t20.firm_type_id AS firm_type_id_80, t0.firm_id AS firm_id_81, t0.user_id AS user_id_82, t0.etablissement_id AS etablissement_id_83 FROM contact t0 LEFT JOIN entreprise t20 ON t20.contact_responsable_id = t0.id WHERE t0.firm_id = 1611 ORDER BY t0.is_responsible DESC;

SELECT
  t0.id AS id_1,
  t0.nom_role AS nom_role_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.is_active AS is_active_5,
  t0.commission_id AS commission_id_6,
  t0.contact_id AS contact_id_7
FROM
  commission_contact t0
WHERE
  t0.contact_id = ?

SELECT t0.id AS id_1, t0.nom_role AS nom_role_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.is_active AS is_active_5, t0.commission_id AS commission_id_6, t0.contact_id AS contact_id_7 FROM commission_contact t0 WHERE t0.contact_id = 2933;

SELECT
  t0.id AS id_1,
  t0.date_debut AS date_debut_2,
  t0.date_fin AS date_fin_3,
  t0.is_active AS is_active_4,
  t0.is_inactif AS is_inactif_5,
  t0.contact_id AS contact_id_6,
  t0.conseil_administration_id AS conseil_administration_id_7
FROM
  contact_conseil_administration t0
WHERE
  t0.contact_id = ?

SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.is_active AS is_active_4, t0.is_inactif AS is_inactif_5, t0.contact_id AS contact_id_6, t0.conseil_administration_id AS conseil_administration_id_7 FROM contact_conseil_administration t0 WHERE t0.contact_id = 2933;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  repere t0
  INNER JOIN contact_repere ON t0.id = contact_repere.repere_id
WHERE
  contact_repere.contact_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM repere t0 INNER JOIN contact_repere ON t0.id = contact_repere.repere_id WHERE contact_repere.contact_id = 2933;

SELECT
  t0.id AS id_1,
  t0.firm_id AS firm_id_2,
  t0.contact_id AS contact_id_3
FROM
  firm_contact_quali_negoce t0
WHERE
  t0.firm_id = ?

SELECT t0.id AS id_1, t0.firm_id AS firm_id_2, t0.contact_id AS contact_id_3 FROM firm_contact_quali_negoce t0 WHERE t0.firm_id = 1611;

SELECT
  t0.id AS id_1,
  t0.file AS file_2,
  t0.size AS size_3,
  t0.original_file_name AS original_file_name_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.firm_id AS firm_id_7
FROM
  firm_quali_negoce_document t0
WHERE
  t0.firm_id = ?

SELECT t0.id AS id_1, t0.file AS file_2, t0.size AS size_3, t0.original_file_name AS original_file_name_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.firm_id AS firm_id_7 FROM firm_quali_negoce_document t0 WHERE t0.firm_id = 1611;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tag AS tag_3,
  t0.is_enabled AS is_enabled_4,
  t0.hide_in_member AS hide_in_member_5,
  t0.description AS description_6,
  t0.cotisation_order AS cotisation_order_7,
  t0.max_amount AS max_amount_8
FROM
  param_cotisation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.is_enabled AS is_enabled_4, t0.hide_in_member AS hide_in_member_5, t0.description AS description_6, t0.cotisation_order AS cotisation_order_7, t0.max_amount AS max_amount_8 FROM param_cotisation t0 WHERE t0.id = 5;

SELECT
  t0.status AS status_1,
  t0.id AS id_2,
  t0.number AS number_3,
  t0.order_date AS order_date_4,
  t0.type AS type_5,
  t0.total_amount AS total_amount_6,
  t0.billing_address AS billing_address_7,
  t0.delivery_address AS delivery_address_8,
  t0.shipping_number AS shipping_number_9,
  t0.invoice_number AS invoice_number_10,
  t0.invoice_date AS invoice_date_11,
  t0.bank_request AS bank_request_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.firm_id AS firm_id_15,
  t16.id AS id_17,
  t16.number AS number_18,
  t16.created_at AS created_at_19,
  t16.updated_at AS updated_at_20,
  t16.parent_order_id AS parent_order_id_21,
  t22.status AS status_23,
  t22.id AS id_24,
  t22.annee_cotisation AS annee_cotisation_25,
  t22.montant_cotisation AS montant_cotisation_26,
  t22.commentaire AS commentaire_27,
  t22.date_paiement AS date_paiement_28,
  t22.revenue AS revenue_29,
  t22.year AS year_30,
  t22.revenue_date AS revenue_date_31,
  t22.option_import_export AS option_import_export_32,
  t22.option_mapa AS option_mapa_33,
  t22.price_ht AS price_ht_34,
  t22.price_vat AS price_vat_35,
  t22.price_ttc AS price_ttc_36,
  t22.internal_licence AS internal_licence_37,
  t22.community_licence AS community_licence_38,
  t22.price_department_part AS price_department_part_39,
  t22.price_national_part AS price_national_part_40,
  t22.price_national_part_calculated AS price_national_part_calculated_41,
  t22.price_option_import_export AS price_option_import_export_42,
  t22.price_option_mapa AS price_option_mapa_43,
  t22.document AS document_44,
  t22.original_document_name AS original_document_name_45,
  t22.proof_of_payment AS proof_of_payment_46,
  t22.original_proof_of_payment_name AS original_proof_of_payment_name_47,
  t22.young_member_year_number AS young_member_year_number_48,
  t22.created_at AS created_at_49,
  t22.updated_at AS updated_at_50,
  t22.cotisation_statut_id AS cotisation_statut_id_51,
  t22.entreprise_id AS entreprise_id_52,
  t22.type_offre_id AS type_offre_id_53,
  t22.cotisation_type_id AS cotisation_type_id_54,
  t22.associeted_order_id AS associeted_order_id_55,
  t0.payment_type_id AS payment_type_id_56,
  t0.user_id AS user_id_57
FROM
  `order` t0
  LEFT JOIN invoice t16 ON t16.parent_order_id = t0.id
  LEFT JOIN cotisation t22 ON t22.associeted_order_id = t0.id
WHERE
  t0.id = ?

SELECT t0.status AS status_1, t0.id AS id_2, t0.number AS number_3, t0.order_date AS order_date_4, t0.type AS type_5, t0.total_amount AS total_amount_6, t0.billing_address AS billing_address_7, t0.delivery_address AS delivery_address_8, t0.shipping_number AS shipping_number_9, t0.invoice_number AS invoice_number_10, t0.invoice_date AS invoice_date_11, t0.bank_request AS bank_request_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.firm_id AS firm_id_15, t16.id AS id_17, t16.number AS number_18, t16.created_at AS created_at_19, t16.updated_at AS updated_at_20, t16.parent_order_id AS parent_order_id_21, t22.status AS status_23, t22.id AS id_24, t22.annee_cotisation AS annee_cotisation_25, t22.montant_cotisation AS montant_cotisation_26, t22.commentaire AS commentaire_27, t22.date_paiement AS date_paiement_28, t22.revenue AS revenue_29, t22.year AS year_30, t22.revenue_date AS revenue_date_31, t22.option_import_export AS option_import_export_32, t22.option_mapa AS option_mapa_33, t22.price_ht AS price_ht_34, t22.price_vat AS price_vat_35, t22.price_ttc AS price_ttc_36, t22.internal_licence AS internal_licence_37, t22.community_licence AS community_licence_38, t22.price_department_part AS price_department_part_39, t22.price_national_part AS price_national_part_40, t22.price_national_part_calculated AS price_national_part_calculated_41, t22.price_option_import_export AS price_option_import_export_42, t22.price_option_mapa AS price_option_mapa_43, t22.document AS document_44, t22.original_document_name AS original_document_name_45, t22.proof_of_payment AS proof_of_payment_46, t22.original_proof_of_payment_name AS original_proof_of_payment_name_47, t22.young_member_year_number AS young_member_year_number_48, t22.created_at AS created_at_49, t22.updated_at AS updated_at_50, t22.cotisation_statut_id AS cotisation_statut_id_51, t22.entreprise_id AS entreprise_id_52, t22.type_offre_id AS type_offre_id_53, t22.cotisation_type_id AS cotisation_type_id_54, t22.associeted_order_id AS associeted_order_id_55, t0.payment_type_id AS payment_type_id_56, t0.user_id AS user_id_57 FROM `order` t0 LEFT JOIN invoice t16 ON t16.parent_order_id = t0.id LEFT JOIN cotisation t22 ON t22.associeted_order_id = t0.id WHERE t0.id = 764;