Symfony Profiler

SELECT
  d0_.id AS id_0,
  d0_.membre_communaute_local1 AS membre_communaute_local1_1,
  d0_.membre_communaute_local2 AS membre_communaute_local2_2,
  d0_.membre_organisation_communautaire1 AS membre_organisation_communautaire1_3,
  d0_.membre_organisation_communautaire2 AS membre_organisation_communautaire2_4,
  d0_.membre_operateur1 AS membre_operateur1_5,
  d0_.membre_operateur2 AS membre_operateur2_6,
  d0_.membre_autorite1 AS membre_autorite1_7,
  d0_.membre_autorite2 AS membre_autorite2_8,
  d0_.membre_fonds_national1 AS membre_fonds_national1_9,
  d0_.membre_fonds_national2 AS membre_fonds_national2_10,
  d0_.membre_direction1 AS membre_direction1_11,
  d0_.membre_direction2 AS membre_direction2_12,
  d0_.nom AS nom_13,
  d0_.date_creation AS date_creation_14,
  d0_.created_at AS created_at_15,
  d0_.updated_at AS updated_at_16,
  d0_.deleted_at AS deleted_at_17,
  d0_.operateur_id AS operateur_id_18,
  d0_.user_id AS user_id_19
FROM
  dot d0_
  INNER JOIN operateur o1_ ON d0_.operateur_id = o1_.id
WHERE
  d0_.id NOT IN (
    SELECT
      DISTINCT d2_.id
    FROM
      dot d2_
      INNER JOIN operateur o3_ ON d2_.operateur_id = o3_.id
      INNER JOIN information_financiere i4_ ON o3_.id = i4_.operateur_id
    WHERE
      SUBSTRING(
        i4_.date_info
        FROM
          1 FOR 4
      ) = ?
  )

SELECT d0_.id AS id_0, d0_.membre_communaute_local1 AS membre_communaute_local1_1, d0_.membre_communaute_local2 AS membre_communaute_local2_2, d0_.membre_organisation_communautaire1 AS membre_organisation_communautaire1_3, d0_.membre_organisation_communautaire2 AS membre_organisation_communautaire2_4, d0_.membre_operateur1 AS membre_operateur1_5, d0_.membre_operateur2 AS membre_operateur2_6, d0_.membre_autorite1 AS membre_autorite1_7, d0_.membre_autorite2 AS membre_autorite2_8, d0_.membre_fonds_national1 AS membre_fonds_national1_9, d0_.membre_fonds_national2 AS membre_fonds_national2_10, d0_.membre_direction1 AS membre_direction1_11, d0_.membre_direction2 AS membre_direction2_12, d0_.nom AS nom_13, d0_.date_creation AS date_creation_14, d0_.created_at AS created_at_15, d0_.updated_at AS updated_at_16, d0_.deleted_at AS deleted_at_17, d0_.operateur_id AS operateur_id_18, d0_.user_id AS user_id_19 FROM dot d0_ INNER JOIN operateur o1_ ON d0_.operateur_id = o1_.id WHERE d0_.id NOT IN (SELECT DISTINCT d2_.id FROM dot d2_ INNER JOIN operateur o3_ ON d2_.operateur_id = o3_.id INNER JOIN information_financiere i4_ ON o3_.id = i4_.operateur_id WHERE SUBSTRING(i4_.date_info FROM 1 FOR 4) = '2024');

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.unite AS unite_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.user_id AS user_id_8
FROM
  filiere t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.unite AS unite_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM filiere t0;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.user_id AS user_id_7
FROM
  categorie t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM categorie t0;

SELECT
  t0.id AS id_1,
  t0.denomination AS denomination_2,
  t0.sigle AS sigle_3,
  t0.statut AS statut_4,
  t0.nature AS nature_5,
  t0.raison_sociale AS raison_sociale_6,
  t0.regime_fiscal AS regime_fiscal_7,
  t0.siege AS siege_8,
  t0.annee_fermeture AS annee_fermeture_9,
  t0.nombre_surccursale AS nombre_surccursale_10,
  t0.code_unique AS code_unique_11,
  t0.rccm AS rccm_12,
  t0.id_nationnal AS id_nationnal_13,
  t0.num_ident_fiscal AS num_ident_fiscal_14,
  t0.num_import_export AS num_import_export_15,
  t0.num_affactation_inss AS num_affactation_inss_16,
  t0.num_affectation_inpp AS num_affectation_inpp_17,
  t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_18,
  t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_19,
  t0.capital_social AS capital_social_20,
  t0.num_tva AS num_tva_21,
  t0.num_dgda AS num_dgda_22,
  t0.num_dgi AS num_dgi_23,
  t0.num_dgrad AS num_dgrad_24,
  t0.num_occ AS num_occ_25,
  t0.boite_postal AS boite_postal_26,
  t0.fax AS fax_27,
  t0.telephone AS telephone_28,
  t0.site_web AS site_web_29,
  t0.email AS email_30,
  t0.fichier AS fichier_31,
  t0.nom_original AS nom_original_32,
  t0.description AS description_33,
  t0.anne_creation AS anne_creation_34,
  t0.code_operateur AS code_operateur_35,
  t0.code_indentification AS code_indentification_36,
  t0.date_creation AS date_creation_37,
  t0.service AS service_38,
  t0.created_at AS created_at_39,
  t0.updated_at AS updated_at_40,
  t0.deleted_at AS deleted_at_41,
  t0.categorie_id AS categorie_id_42,
  t0.forme_juridique_id AS forme_juridique_id_43,
  t0.ville_id AS ville_id_44,
  t0.sous_secteur_id AS sous_secteur_id_45,
  t0.etd_id AS etd_id_46,
  t0.province_id AS province_id_47,
  t0.user_id AS user_id_48
FROM
  operateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.denomination AS denomination_2, t0.sigle AS sigle_3, t0.statut AS statut_4, t0.nature AS nature_5, t0.raison_sociale AS raison_sociale_6, t0.regime_fiscal AS regime_fiscal_7, t0.siege AS siege_8, t0.annee_fermeture AS annee_fermeture_9, t0.nombre_surccursale AS nombre_surccursale_10, t0.code_unique AS code_unique_11, t0.rccm AS rccm_12, t0.id_nationnal AS id_nationnal_13, t0.num_ident_fiscal AS num_ident_fiscal_14, t0.num_import_export AS num_import_export_15, t0.num_affactation_inss AS num_affactation_inss_16, t0.num_affectation_inpp AS num_affectation_inpp_17, t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_18, t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_19, t0.capital_social AS capital_social_20, t0.num_tva AS num_tva_21, t0.num_dgda AS num_dgda_22, t0.num_dgi AS num_dgi_23, t0.num_dgrad AS num_dgrad_24, t0.num_occ AS num_occ_25, t0.boite_postal AS boite_postal_26, t0.fax AS fax_27, t0.telephone AS telephone_28, t0.site_web AS site_web_29, t0.email AS email_30, t0.fichier AS fichier_31, t0.nom_original AS nom_original_32, t0.description AS description_33, t0.anne_creation AS anne_creation_34, t0.code_operateur AS code_operateur_35, t0.code_indentification AS code_indentification_36, t0.date_creation AS date_creation_37, t0.service AS service_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.deleted_at AS deleted_at_41, t0.categorie_id AS categorie_id_42, t0.forme_juridique_id AS forme_juridique_id_43, t0.ville_id AS ville_id_44, t0.sous_secteur_id AS sous_secteur_id_45, t0.etd_id AS etd_id_46, t0.province_id AS province_id_47, t0.user_id AS user_id_48 FROM operateur t0 WHERE t0.id = 10061;

SELECT
  t0.id AS id_1,
  t0.volume AS volume_2,
  t0.chiffre_affaire AS chiffre_affaire_3,
  t0.date_info AS date_info_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.operateur_id AS operateur_id_8,
  t0.repartition_id AS repartition_id_9,
  t0.user_id AS user_id_10
FROM
  information_financiere t0
WHERE
  t0.operateur_id = ?

SELECT t0.id AS id_1, t0.volume AS volume_2, t0.chiffre_affaire AS chiffre_affaire_3, t0.date_info AS date_info_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.operateur_id AS operateur_id_8, t0.repartition_id AS repartition_id_9, t0.user_id AS user_id_10 FROM information_financiere t0 WHERE t0.operateur_id = 10061;

SELECT
  t0.id AS id_1,
  t0.denomination AS denomination_2,
  t0.sigle AS sigle_3,
  t0.statut AS statut_4,
  t0.nature AS nature_5,
  t0.raison_sociale AS raison_sociale_6,
  t0.regime_fiscal AS regime_fiscal_7,
  t0.siege AS siege_8,
  t0.annee_fermeture AS annee_fermeture_9,
  t0.nombre_surccursale AS nombre_surccursale_10,
  t0.code_unique AS code_unique_11,
  t0.rccm AS rccm_12,
  t0.id_nationnal AS id_nationnal_13,
  t0.num_ident_fiscal AS num_ident_fiscal_14,
  t0.num_import_export AS num_import_export_15,
  t0.num_affactation_inss AS num_affactation_inss_16,
  t0.num_affectation_inpp AS num_affectation_inpp_17,
  t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_18,
  t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_19,
  t0.capital_social AS capital_social_20,
  t0.num_tva AS num_tva_21,
  t0.num_dgda AS num_dgda_22,
  t0.num_dgi AS num_dgi_23,
  t0.num_dgrad AS num_dgrad_24,
  t0.num_occ AS num_occ_25,
  t0.boite_postal AS boite_postal_26,
  t0.fax AS fax_27,
  t0.telephone AS telephone_28,
  t0.site_web AS site_web_29,
  t0.email AS email_30,
  t0.fichier AS fichier_31,
  t0.nom_original AS nom_original_32,
  t0.description AS description_33,
  t0.anne_creation AS anne_creation_34,
  t0.code_operateur AS code_operateur_35,
  t0.code_indentification AS code_indentification_36,
  t0.date_creation AS date_creation_37,
  t0.service AS service_38,
  t0.created_at AS created_at_39,
  t0.updated_at AS updated_at_40,
  t0.deleted_at AS deleted_at_41,
  t0.categorie_id AS categorie_id_42,
  t0.forme_juridique_id AS forme_juridique_id_43,
  t0.ville_id AS ville_id_44,
  t0.sous_secteur_id AS sous_secteur_id_45,
  t0.etd_id AS etd_id_46,
  t0.province_id AS province_id_47,
  t0.user_id AS user_id_48
FROM
  operateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.denomination AS denomination_2, t0.sigle AS sigle_3, t0.statut AS statut_4, t0.nature AS nature_5, t0.raison_sociale AS raison_sociale_6, t0.regime_fiscal AS regime_fiscal_7, t0.siege AS siege_8, t0.annee_fermeture AS annee_fermeture_9, t0.nombre_surccursale AS nombre_surccursale_10, t0.code_unique AS code_unique_11, t0.rccm AS rccm_12, t0.id_nationnal AS id_nationnal_13, t0.num_ident_fiscal AS num_ident_fiscal_14, t0.num_import_export AS num_import_export_15, t0.num_affactation_inss AS num_affactation_inss_16, t0.num_affectation_inpp AS num_affectation_inpp_17, t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_18, t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_19, t0.capital_social AS capital_social_20, t0.num_tva AS num_tva_21, t0.num_dgda AS num_dgda_22, t0.num_dgi AS num_dgi_23, t0.num_dgrad AS num_dgrad_24, t0.num_occ AS num_occ_25, t0.boite_postal AS boite_postal_26, t0.fax AS fax_27, t0.telephone AS telephone_28, t0.site_web AS site_web_29, t0.email AS email_30, t0.fichier AS fichier_31, t0.nom_original AS nom_original_32, t0.description AS description_33, t0.anne_creation AS anne_creation_34, t0.code_operateur AS code_operateur_35, t0.code_indentification AS code_indentification_36, t0.date_creation AS date_creation_37, t0.service AS service_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.deleted_at AS deleted_at_41, t0.categorie_id AS categorie_id_42, t0.forme_juridique_id AS forme_juridique_id_43, t0.ville_id AS ville_id_44, t0.sous_secteur_id AS sous_secteur_id_45, t0.etd_id AS etd_id_46, t0.province_id AS province_id_47, t0.user_id AS user_id_48 FROM operateur t0 WHERE t0.id = 8031;

SELECT
  t0.id AS id_1,
  t0.volume AS volume_2,
  t0.chiffre_affaire AS chiffre_affaire_3,
  t0.date_info AS date_info_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.operateur_id AS operateur_id_8,
  t0.repartition_id AS repartition_id_9,
  t0.user_id AS user_id_10
FROM
  information_financiere t0
WHERE
  t0.operateur_id = ?

SELECT t0.id AS id_1, t0.volume AS volume_2, t0.chiffre_affaire AS chiffre_affaire_3, t0.date_info AS date_info_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.operateur_id AS operateur_id_8, t0.repartition_id AS repartition_id_9, t0.user_id AS user_id_10 FROM information_financiere t0 WHERE t0.operateur_id = 8031;

SELECT
  t0.id AS id_1,
  t0.denomination AS denomination_2,
  t0.sigle AS sigle_3,
  t0.statut AS statut_4,
  t0.nature AS nature_5,
  t0.raison_sociale AS raison_sociale_6,
  t0.regime_fiscal AS regime_fiscal_7,
  t0.siege AS siege_8,
  t0.annee_fermeture AS annee_fermeture_9,
  t0.nombre_surccursale AS nombre_surccursale_10,
  t0.code_unique AS code_unique_11,
  t0.rccm AS rccm_12,
  t0.id_nationnal AS id_nationnal_13,
  t0.num_ident_fiscal AS num_ident_fiscal_14,
  t0.num_import_export AS num_import_export_15,
  t0.num_affactation_inss AS num_affactation_inss_16,
  t0.num_affectation_inpp AS num_affectation_inpp_17,
  t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_18,
  t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_19,
  t0.capital_social AS capital_social_20,
  t0.num_tva AS num_tva_21,
  t0.num_dgda AS num_dgda_22,
  t0.num_dgi AS num_dgi_23,
  t0.num_dgrad AS num_dgrad_24,
  t0.num_occ AS num_occ_25,
  t0.boite_postal AS boite_postal_26,
  t0.fax AS fax_27,
  t0.telephone AS telephone_28,
  t0.site_web AS site_web_29,
  t0.email AS email_30,
  t0.fichier AS fichier_31,
  t0.nom_original AS nom_original_32,
  t0.description AS description_33,
  t0.anne_creation AS anne_creation_34,
  t0.code_operateur AS code_operateur_35,
  t0.code_indentification AS code_indentification_36,
  t0.date_creation AS date_creation_37,
  t0.service AS service_38,
  t0.created_at AS created_at_39,
  t0.updated_at AS updated_at_40,
  t0.deleted_at AS deleted_at_41,
  t0.categorie_id AS categorie_id_42,
  t0.forme_juridique_id AS forme_juridique_id_43,
  t0.ville_id AS ville_id_44,
  t0.sous_secteur_id AS sous_secteur_id_45,
  t0.etd_id AS etd_id_46,
  t0.province_id AS province_id_47,
  t0.user_id AS user_id_48
FROM
  operateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.denomination AS denomination_2, t0.sigle AS sigle_3, t0.statut AS statut_4, t0.nature AS nature_5, t0.raison_sociale AS raison_sociale_6, t0.regime_fiscal AS regime_fiscal_7, t0.siege AS siege_8, t0.annee_fermeture AS annee_fermeture_9, t0.nombre_surccursale AS nombre_surccursale_10, t0.code_unique AS code_unique_11, t0.rccm AS rccm_12, t0.id_nationnal AS id_nationnal_13, t0.num_ident_fiscal AS num_ident_fiscal_14, t0.num_import_export AS num_import_export_15, t0.num_affactation_inss AS num_affactation_inss_16, t0.num_affectation_inpp AS num_affectation_inpp_17, t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_18, t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_19, t0.capital_social AS capital_social_20, t0.num_tva AS num_tva_21, t0.num_dgda AS num_dgda_22, t0.num_dgi AS num_dgi_23, t0.num_dgrad AS num_dgrad_24, t0.num_occ AS num_occ_25, t0.boite_postal AS boite_postal_26, t0.fax AS fax_27, t0.telephone AS telephone_28, t0.site_web AS site_web_29, t0.email AS email_30, t0.fichier AS fichier_31, t0.nom_original AS nom_original_32, t0.description AS description_33, t0.anne_creation AS anne_creation_34, t0.code_operateur AS code_operateur_35, t0.code_indentification AS code_indentification_36, t0.date_creation AS date_creation_37, t0.service AS service_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.deleted_at AS deleted_at_41, t0.categorie_id AS categorie_id_42, t0.forme_juridique_id AS forme_juridique_id_43, t0.ville_id AS ville_id_44, t0.sous_secteur_id AS sous_secteur_id_45, t0.etd_id AS etd_id_46, t0.province_id AS province_id_47, t0.user_id AS user_id_48 FROM operateur t0 WHERE t0.id = 7966;

SELECT
  t0.id AS id_1,
  t0.volume AS volume_2,
  t0.chiffre_affaire AS chiffre_affaire_3,
  t0.date_info AS date_info_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.operateur_id AS operateur_id_8,
  t0.repartition_id AS repartition_id_9,
  t0.user_id AS user_id_10
FROM
  information_financiere t0
WHERE
  t0.operateur_id = ?

SELECT t0.id AS id_1, t0.volume AS volume_2, t0.chiffre_affaire AS chiffre_affaire_3, t0.date_info AS date_info_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.operateur_id AS operateur_id_8, t0.repartition_id AS repartition_id_9, t0.user_id AS user_id_10 FROM information_financiere t0 WHERE t0.operateur_id = 7966;

SELECT
  t0.id AS id_1,
  t0.denomination AS denomination_2,
  t0.sigle AS sigle_3,
  t0.statut AS statut_4,
  t0.nature AS nature_5,
  t0.raison_sociale AS raison_sociale_6,
  t0.regime_fiscal AS regime_fiscal_7,
  t0.siege AS siege_8,
  t0.annee_fermeture AS annee_fermeture_9,
  t0.nombre_surccursale AS nombre_surccursale_10,
  t0.code_unique AS code_unique_11,
  t0.rccm AS rccm_12,
  t0.id_nationnal AS id_nationnal_13,
  t0.num_ident_fiscal AS num_ident_fiscal_14,
  t0.num_import_export AS num_import_export_15,
  t0.num_affactation_inss AS num_affactation_inss_16,
  t0.num_affectation_inpp AS num_affectation_inpp_17,
  t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_18,
  t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_19,
  t0.capital_social AS capital_social_20,
  t0.num_tva AS num_tva_21,
  t0.num_dgda AS num_dgda_22,
  t0.num_dgi AS num_dgi_23,
  t0.num_dgrad AS num_dgrad_24,
  t0.num_occ AS num_occ_25,
  t0.boite_postal AS boite_postal_26,
  t0.fax AS fax_27,
  t0.telephone AS telephone_28,
  t0.site_web AS site_web_29,
  t0.email AS email_30,
  t0.fichier AS fichier_31,
  t0.nom_original AS nom_original_32,
  t0.description AS description_33,
  t0.anne_creation AS anne_creation_34,
  t0.code_operateur AS code_operateur_35,
  t0.code_indentification AS code_indentification_36,
  t0.date_creation AS date_creation_37,
  t0.service AS service_38,
  t0.created_at AS created_at_39,
  t0.updated_at AS updated_at_40,
  t0.deleted_at AS deleted_at_41,
  t0.categorie_id AS categorie_id_42,
  t0.forme_juridique_id AS forme_juridique_id_43,
  t0.ville_id AS ville_id_44,
  t0.sous_secteur_id AS sous_secteur_id_45,
  t0.etd_id AS etd_id_46,
  t0.province_id AS province_id_47,
  t0.user_id AS user_id_48
FROM
  operateur t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.denomination AS denomination_2, t0.sigle AS sigle_3, t0.statut AS statut_4, t0.nature AS nature_5, t0.raison_sociale AS raison_sociale_6, t0.regime_fiscal AS regime_fiscal_7, t0.siege AS siege_8, t0.annee_fermeture AS annee_fermeture_9, t0.nombre_surccursale AS nombre_surccursale_10, t0.code_unique AS code_unique_11, t0.rccm AS rccm_12, t0.id_nationnal AS id_nationnal_13, t0.num_ident_fiscal AS num_ident_fiscal_14, t0.num_import_export AS num_import_export_15, t0.num_affactation_inss AS num_affactation_inss_16, t0.num_affectation_inpp AS num_affectation_inpp_17, t0.num_compte_bancaire_interne AS num_compte_bancaire_interne_18, t0.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_19, t0.capital_social AS capital_social_20, t0.num_tva AS num_tva_21, t0.num_dgda AS num_dgda_22, t0.num_dgi AS num_dgi_23, t0.num_dgrad AS num_dgrad_24, t0.num_occ AS num_occ_25, t0.boite_postal AS boite_postal_26, t0.fax AS fax_27, t0.telephone AS telephone_28, t0.site_web AS site_web_29, t0.email AS email_30, t0.fichier AS fichier_31, t0.nom_original AS nom_original_32, t0.description AS description_33, t0.anne_creation AS anne_creation_34, t0.code_operateur AS code_operateur_35, t0.code_indentification AS code_indentification_36, t0.date_creation AS date_creation_37, t0.service AS service_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.deleted_at AS deleted_at_41, t0.categorie_id AS categorie_id_42, t0.forme_juridique_id AS forme_juridique_id_43, t0.ville_id AS ville_id_44, t0.sous_secteur_id AS sous_secteur_id_45, t0.etd_id AS etd_id_46, t0.province_id AS province_id_47, t0.user_id AS user_id_48 FROM operateur t0 WHERE t0.id = 7803;

SELECT
  t0.id AS id_1,
  t0.volume AS volume_2,
  t0.chiffre_affaire AS chiffre_affaire_3,
  t0.date_info AS date_info_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7,
  t0.operateur_id AS operateur_id_8,
  t0.repartition_id AS repartition_id_9,
  t0.user_id AS user_id_10
FROM
  information_financiere t0
WHERE
  t0.operateur_id = ?

SELECT t0.id AS id_1, t0.volume AS volume_2, t0.chiffre_affaire AS chiffre_affaire_3, t0.date_info AS date_info_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.operateur_id AS operateur_id_8, t0.repartition_id AS repartition_id_9, t0.user_id AS user_id_10 FROM information_financiere t0 WHERE t0.operateur_id = 7803;