Symfony Profiler

SELECT
  o0_.id AS id_0,
  o0_.denomination AS denomination_1,
  o0_.sigle AS sigle_2,
  o0_.statut AS statut_3,
  o0_.nature AS nature_4,
  o0_.raison_sociale AS raison_sociale_5,
  o0_.regime_fiscal AS regime_fiscal_6,
  o0_.siege AS siege_7,
  o0_.annee_fermeture AS annee_fermeture_8,
  o0_.nombre_surccursale AS nombre_surccursale_9,
  o0_.code_unique AS code_unique_10,
  o0_.rccm AS rccm_11,
  o0_.id_nationnal AS id_nationnal_12,
  o0_.num_ident_fiscal AS num_ident_fiscal_13,
  o0_.num_import_export AS num_import_export_14,
  o0_.num_affactation_inss AS num_affactation_inss_15,
  o0_.num_affectation_inpp AS num_affectation_inpp_16,
  o0_.num_compte_bancaire_interne AS num_compte_bancaire_interne_17,
  o0_.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_18,
  o0_.capital_social AS capital_social_19,
  o0_.num_tva AS num_tva_20,
  o0_.num_dgda AS num_dgda_21,
  o0_.num_dgi AS num_dgi_22,
  o0_.num_dgrad AS num_dgrad_23,
  o0_.num_occ AS num_occ_24,
  o0_.boite_postal AS boite_postal_25,
  o0_.fax AS fax_26,
  o0_.telephone AS telephone_27,
  o0_.site_web AS site_web_28,
  o0_.email AS email_29,
  o0_.fichier AS fichier_30,
  o0_.nom_original AS nom_original_31,
  o0_.description AS description_32,
  o0_.anne_creation AS anne_creation_33,
  o0_.code_operateur AS code_operateur_34,
  o0_.code_indentification AS code_indentification_35,
  o0_.date_creation AS date_creation_36,
  o0_.service AS service_37,
  o0_.created_at AS created_at_38,
  o0_.updated_at AS updated_at_39,
  o0_.deleted_at AS deleted_at_40,
  o0_.categorie_id AS categorie_id_41,
  o0_.forme_juridique_id AS forme_juridique_id_42,
  o0_.ville_id AS ville_id_43,
  o0_.sous_secteur_id AS sous_secteur_id_44,
  o0_.etd_id AS etd_id_45,
  o0_.province_id AS province_id_46,
  o0_.user_id AS user_id_47
FROM
  operateur o0_
  INNER JOIN sous_secteur s1_ ON o0_.sous_secteur_id = s1_.id
  INNER JOIN secteur s2_ ON s1_.secteur_id = s2_.id
WHERE
  s2_.id = ?
  AND o0_.annee_fermeture > ?
  AND o0_.date_creation < ?

SELECT o0_.id AS id_0, o0_.denomination AS denomination_1, o0_.sigle AS sigle_2, o0_.statut AS statut_3, o0_.nature AS nature_4, o0_.raison_sociale AS raison_sociale_5, o0_.regime_fiscal AS regime_fiscal_6, o0_.siege AS siege_7, o0_.annee_fermeture AS annee_fermeture_8, o0_.nombre_surccursale AS nombre_surccursale_9, o0_.code_unique AS code_unique_10, o0_.rccm AS rccm_11, o0_.id_nationnal AS id_nationnal_12, o0_.num_ident_fiscal AS num_ident_fiscal_13, o0_.num_import_export AS num_import_export_14, o0_.num_affactation_inss AS num_affactation_inss_15, o0_.num_affectation_inpp AS num_affectation_inpp_16, o0_.num_compte_bancaire_interne AS num_compte_bancaire_interne_17, o0_.num_compte_bancaire_etranger AS num_compte_bancaire_etranger_18, o0_.capital_social AS capital_social_19, o0_.num_tva AS num_tva_20, o0_.num_dgda AS num_dgda_21, o0_.num_dgi AS num_dgi_22, o0_.num_dgrad AS num_dgrad_23, o0_.num_occ AS num_occ_24, o0_.boite_postal AS boite_postal_25, o0_.fax AS fax_26, o0_.telephone AS telephone_27, o0_.site_web AS site_web_28, o0_.email AS email_29, o0_.fichier AS fichier_30, o0_.nom_original AS nom_original_31, o0_.description AS description_32, o0_.anne_creation AS anne_creation_33, o0_.code_operateur AS code_operateur_34, o0_.code_indentification AS code_indentification_35, o0_.date_creation AS date_creation_36, o0_.service AS service_37, o0_.created_at AS created_at_38, o0_.updated_at AS updated_at_39, o0_.deleted_at AS deleted_at_40, o0_.categorie_id AS categorie_id_41, o0_.forme_juridique_id AS forme_juridique_id_42, o0_.ville_id AS ville_id_43, o0_.sous_secteur_id AS sous_secteur_id_44, o0_.etd_id AS etd_id_45, o0_.province_id AS province_id_46, o0_.user_id AS user_id_47 FROM operateur o0_ INNER JOIN sous_secteur s1_ ON o0_.sous_secteur_id = s1_.id INNER JOIN secteur s2_ ON s1_.secteur_id = s2_.id WHERE s2_.id = 2 AND o0_.annee_fermeture > '2024-01-01' AND o0_.date_creation < '2024-01-01';

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.symbole_chimique AS symbole_chimique_2,
  t0.nom AS nom_3,
  t0.reserve_approv AS reserve_approv_4,
  t0.code AS code_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.filiere_id AS filiere_id_9,
  t0.localisation_id AS localisation_id_10,
  t0.user_id AS user_id_11
FROM
  commodite t0
  INNER JOIN operateur_commodite ON t0.id = operateur_commodite.commodite_id
WHERE
  operateur_commodite.operateur_id = ?

SELECT t0.id AS id_1, t0.symbole_chimique AS symbole_chimique_2, t0.nom AS nom_3, t0.reserve_approv AS reserve_approv_4, t0.code AS code_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.filiere_id AS filiere_id_9, t0.localisation_id AS localisation_id_10, t0.user_id AS user_id_11 FROM commodite t0 INNER JOIN operateur_commodite ON t0.id = operateur_commodite.commodite_id WHERE operateur_commodite.operateur_id = 8167;

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.secteur_id AS secteur_id_7,
  t0.user_id AS user_id_8
FROM
  sous_secteur t0
WHERE
  t0.id = ?

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.secteur_id AS secteur_id_7, t0.user_id AS user_id_8 FROM sous_secteur t0 WHERE t0.id = 2;

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
  secteur t0
WHERE
  t0.id = ?

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 secteur t0 WHERE t0.id = 2;

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.province_id AS province_id_7,
  t0.user_id AS user_id_8
FROM
  ville t0
WHERE
  t0.id = ?

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.province_id AS province_id_7, t0.user_id AS user_id_8 FROM ville t0 WHERE t0.id = 21;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.superficie AS superficie_4,
  t0.chef_lieu AS chef_lieu_5,
  t0.population AS population_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.user_id AS user_id_10
FROM
  province t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.superficie AS superficie_4, t0.chef_lieu AS chef_lieu_5, t0.population AS population_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.user_id AS user_id_10 FROM province t0 WHERE t0.id = 17;

SELECT
  t0.id AS id_1,
  t0.symbole_chimique AS symbole_chimique_2,
  t0.nom AS nom_3,
  t0.reserve_approv AS reserve_approv_4,
  t0.code AS code_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.filiere_id AS filiere_id_9,
  t0.localisation_id AS localisation_id_10,
  t0.user_id AS user_id_11
FROM
  commodite t0
  INNER JOIN operateur_commodite ON t0.id = operateur_commodite.commodite_id
WHERE
  operateur_commodite.operateur_id = ?

SELECT t0.id AS id_1, t0.symbole_chimique AS symbole_chimique_2, t0.nom AS nom_3, t0.reserve_approv AS reserve_approv_4, t0.code AS code_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.filiere_id AS filiere_id_9, t0.localisation_id AS localisation_id_10, t0.user_id AS user_id_11 FROM commodite t0 INNER JOIN operateur_commodite ON t0.id = operateur_commodite.commodite_id WHERE operateur_commodite.operateur_id = 8168;

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.province_id AS province_id_7,
  t0.user_id AS user_id_8
FROM
  ville t0
WHERE
  t0.id = ?

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.province_id AS province_id_7, t0.user_id AS user_id_8 FROM ville t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.superficie AS superficie_4,
  t0.chef_lieu AS chef_lieu_5,
  t0.population AS population_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.user_id AS user_id_10
FROM
  province t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.superficie AS superficie_4, t0.chef_lieu AS chef_lieu_5, t0.population AS population_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.user_id AS user_id_10 FROM province t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.symbole_chimique AS symbole_chimique_2,
  t0.nom AS nom_3,
  t0.reserve_approv AS reserve_approv_4,
  t0.code AS code_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.filiere_id AS filiere_id_9,
  t0.localisation_id AS localisation_id_10,
  t0.user_id AS user_id_11
FROM
  commodite t0
  INNER JOIN operateur_commodite ON t0.id = operateur_commodite.commodite_id
WHERE
  operateur_commodite.operateur_id = ?

SELECT t0.id AS id_1, t0.symbole_chimique AS symbole_chimique_2, t0.nom AS nom_3, t0.reserve_approv AS reserve_approv_4, t0.code AS code_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.filiere_id AS filiere_id_9, t0.localisation_id AS localisation_id_10, t0.user_id AS user_id_11 FROM commodite t0 INNER JOIN operateur_commodite ON t0.id = operateur_commodite.commodite_id WHERE operateur_commodite.operateur_id = 8170;

SELECT
  t0.id AS id_1,
  t0.symbole_chimique AS symbole_chimique_2,
  t0.nom AS nom_3,
  t0.reserve_approv AS reserve_approv_4,
  t0.code AS code_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.filiere_id AS filiere_id_9,
  t0.localisation_id AS localisation_id_10,
  t0.user_id AS user_id_11
FROM
  commodite t0
  INNER JOIN operateur_commodite ON t0.id = operateur_commodite.commodite_id
WHERE
  operateur_commodite.operateur_id = ?

SELECT t0.id AS id_1, t0.symbole_chimique AS symbole_chimique_2, t0.nom AS nom_3, t0.reserve_approv AS reserve_approv_4, t0.code AS code_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.filiere_id AS filiere_id_9, t0.localisation_id AS localisation_id_10, t0.user_id AS user_id_11 FROM commodite t0 INNER JOIN operateur_commodite ON t0.id = operateur_commodite.commodite_id WHERE operateur_commodite.operateur_id = 8171;

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.province_id AS province_id_7,
  t0.user_id AS user_id_8
FROM
  ville t0
WHERE
  t0.id = ?

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.province_id AS province_id_7, t0.user_id AS user_id_8 FROM ville t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.superficie AS superficie_4,
  t0.chef_lieu AS chef_lieu_5,
  t0.population AS population_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.user_id AS user_id_10
FROM
  province t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.superficie AS superficie_4, t0.chef_lieu AS chef_lieu_5, t0.population AS population_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.user_id AS user_id_10 FROM province t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.symbole_chimique AS symbole_chimique_2,
  t0.nom AS nom_3,
  t0.reserve_approv AS reserve_approv_4,
  t0.code AS code_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.filiere_id AS filiere_id_9,
  t0.localisation_id AS localisation_id_10,
  t0.user_id AS user_id_11
FROM
  commodite t0
  INNER JOIN operateur_commodite ON t0.id = operateur_commodite.commodite_id
WHERE
  operateur_commodite.operateur_id = ?

SELECT t0.id AS id_1, t0.symbole_chimique AS symbole_chimique_2, t0.nom AS nom_3, t0.reserve_approv AS reserve_approv_4, t0.code AS code_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.filiere_id AS filiere_id_9, t0.localisation_id AS localisation_id_10, t0.user_id AS user_id_11 FROM commodite t0 INNER JOIN operateur_commodite ON t0.id = operateur_commodite.commodite_id WHERE operateur_commodite.operateur_id = 8172;