Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.Denprojet AS Denprojet_1,
  t0_.restap AS restap_2,
  t0_.idanal AS idanal_3,
  t0_.codeprojet AS codeprojet_4,
  t0_.sitjuridique AS sitjuridique_5,
  t0_.Numtitrs AS Numtitrs_6,
  t0_.Numregistre AS Numregistre_7,
  t0_.Numfolio AS Numfolio_8,
  t0_.sisea AS sisea_9,
  t0_.fokotany AS fokotany_10,
  t0_.Commune AS Commune_11,
  t0_.District AS District_12,
  t0_.Region AS Region_13,
  t0_.Nompropriete AS Nompropriete_14,
  t0_.contenance AS contenance_15,
  t0_.proprietaire AS proprietaire_16,
  t0_.Signataire AS Signataire_17,
  t0_.PersonaPPV AS PersonaPPV_18,
  t0_.PAterrain AS PAterrain_19,
  t0_.contrat AS contrat_20,
  t0_.categorie AS categorie_21,
  t0_.refarch AS refarch_22,
  t0_.coordong AS coordong_23,
  t0_.aventage AS aventage_24,
  t0_.inconv AS inconv_25,
  t0_.contenance_av AS contenance_av_26,
  t0_.piecejoint AS piecejoint_27,
  t0_.suivie AS suivie_28,
  t0_.description AS description_29,
  t0_.coordinates AS coordinates_30,
  t0_.date AS date_31,
  t0_.axe AS axe_32,
  t0_.type AS type_33,
  t0_.min AS min_34,
  t0_.max AS max_35,
  t0_.supmin AS supmin_36,
  t0_.supmax AS supmax_37,
  t0_.noted AS noted_38,
  t0_.budget AS budget_39,
  t0_.budgets AS budgets_40,
  t0_.public_visibility AS public_visibility_41,
  t0_.nextcloud_path AS nextcloud_path_42,
  t0_.nextcloud_share_url AS nextcloud_share_url_43,
  t0_.fournisseur_id AS fournisseur_id_44,
  t0_.logo_id AS logo_id_45,
  t0_.image_principal_id AS image_principal_id_46
FROM
  terrain t0_
ORDER BY
  t0_.Denprojet ASC

SELECT t0_.id AS id_0, t0_.Denprojet AS Denprojet_1, t0_.restap AS restap_2, t0_.idanal AS idanal_3, t0_.codeprojet AS codeprojet_4, t0_.sitjuridique AS sitjuridique_5, t0_.Numtitrs AS Numtitrs_6, t0_.Numregistre AS Numregistre_7, t0_.Numfolio AS Numfolio_8, t0_.sisea AS sisea_9, t0_.fokotany AS fokotany_10, t0_.Commune AS Commune_11, t0_.District AS District_12, t0_.Region AS Region_13, t0_.Nompropriete AS Nompropriete_14, t0_.contenance AS contenance_15, t0_.proprietaire AS proprietaire_16, t0_.Signataire AS Signataire_17, t0_.PersonaPPV AS PersonaPPV_18, t0_.PAterrain AS PAterrain_19, t0_.contrat AS contrat_20, t0_.categorie AS categorie_21, t0_.refarch AS refarch_22, t0_.coordong AS coordong_23, t0_.aventage AS aventage_24, t0_.inconv AS inconv_25, t0_.contenance_av AS contenance_av_26, t0_.piecejoint AS piecejoint_27, t0_.suivie AS suivie_28, t0_.description AS description_29, t0_.coordinates AS coordinates_30, t0_.date AS date_31, t0_.axe AS axe_32, t0_.type AS type_33, t0_.min AS min_34, t0_.max AS max_35, t0_.supmin AS supmin_36, t0_.supmax AS supmax_37, t0_.noted AS noted_38, t0_.budget AS budget_39, t0_.budgets AS budgets_40, t0_.public_visibility AS public_visibility_41, t0_.nextcloud_path AS nextcloud_path_42, t0_.nextcloud_share_url AS nextcloud_share_url_43, t0_.fournisseur_id AS fournisseur_id_44, t0_.logo_id AS logo_id_45, t0_.image_principal_id AS image_principal_id_46 FROM terrain t0_ ORDER BY t0_.Denprojet ASC;

SELECT
  t0.id AS id_1,
  t0.reftier AS reftier_2,
  t0.gender AS gender_3,
  t0.dep AS dep_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.address AS address_7,
  t0.zip_code AS zip_code_8,
  t0.city AS city_9,
  t0.country AS country_10,
  t0.phone AS phone_11,
  t0.cin AS cin_12,
  t0.datenaiss AS datenaiss_13,
  t0.lieunaiss AS lieunaiss_14,
  t0.phone2 AS phone2_15,
  t0.facebook AS facebook_16,
  t0.etatcivil AS etatcivil_17,
  t0.besoin AS besoin_18,
  t0.profession AS profession_19,
  t0.hierarchie AS hierarchie_20,
  t0.decideurs AS decideurs_21,
  t0.etat_mat AS etat_mat_22,
  t0.email AS email_23,
  t0.nationalite AS nationalite_24,
  t0.email_pro AS email_pro_25,
  t26.id AS id_27,
  t26.email AS email_28,
  t26.password AS password_29,
  t26.roles AS roles_30,
  t26.created_at AS created_at_31,
  t26.actif AS actif_32,
  t26.impersonator AS impersonator_33,
  t26.label AS label_34,
  t26.client_id AS client_id_35
FROM
  fos_user t0
  LEFT JOIN client_user t26 ON t26.client_id = t0.id

SELECT t0.id AS id_1, t0.reftier AS reftier_2, t0.gender AS gender_3, t0.dep AS dep_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.address AS address_7, t0.zip_code AS zip_code_8, t0.city AS city_9, t0.country AS country_10, t0.phone AS phone_11, t0.cin AS cin_12, t0.datenaiss AS datenaiss_13, t0.lieunaiss AS lieunaiss_14, t0.phone2 AS phone2_15, t0.facebook AS facebook_16, t0.etatcivil AS etatcivil_17, t0.besoin AS besoin_18, t0.profession AS profession_19, t0.hierarchie AS hierarchie_20, t0.decideurs AS decideurs_21, t0.etat_mat AS etat_mat_22, t0.email AS email_23, t0.nationalite AS nationalite_24, t0.email_pro AS email_pro_25, t26.id AS id_27, t26.email AS email_28, t26.password AS password_29, t26.roles AS roles_30, t26.created_at AS created_at_31, t26.actif AS actif_32, t26.impersonator AS impersonator_33, t26.label AS label_34, t26.client_id AS client_id_35 FROM fos_user t0 LEFT JOIN client_user t26 ON t26.client_id = t0.id;

SELECT
  t0.id AS id_1,
  t0.idUtilisateur AS idUtilisateur_2,
  t0.idtiers AS idtiers_3,
  t0.statut AS statut_4,
  t0.idCommercial AS idCommercial_5,
  t0.NomAlt AS NomAlt_6,
  t0.Sweb AS Sweb_7,
  t0.Fax AS Fax_8,
  t0.STAT AS STAT_9,
  t0.RCS AS RCS_10,
  t0.NIF AS NIF_11,
  t0.AssTva AS AssTva_12,
  t0.NumTva AS NumTva_13,
  t0.FormeJur AS FormeJur_14,
  t0.Effectif AS Effectif_15,
  t0.typetiers AS typetiers_16,
  t0.source AS source_17,
  t0.gender AS gender_18,
  t0.nompr AS nompr_19,
  t0.prenompr AS prenompr_20,
  t0.phonepr AS phonepr_21,
  t0.interes AS interes_22,
  t0.degr AS degr_23,
  t0.datec AS datec_24,
  t0.datetra AS datetra_25,
  t0.tra AS tra_26,
  t0.majnote AS majnote_27,
  t0.datemaj AS datemaj_28,
  t0.superficie AS superficie_29,
  t0.action AS action_30,
  t0.phonepr2 AS phonepr2_31,
  t0.budget AS budget_32,
  t0.status AS status_33,
  t0.urgence AS urgence_34,
  t0.provinces AS provinces_35,
  t0.axe AS axe_36,
  t0.projet AS projet_37,
  t0.created_at AS created_at_38,
  t0.emailpr AS emailpr_39,
  t0.client_user_id AS client_user_id_40
FROM
  tiers t0
WHERE
  t0.client_user_id = ?

SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.idtiers AS idtiers_3, t0.statut AS statut_4, t0.idCommercial AS idCommercial_5, t0.NomAlt AS NomAlt_6, t0.Sweb AS Sweb_7, t0.Fax AS Fax_8, t0.STAT AS STAT_9, t0.RCS AS RCS_10, t0.NIF AS NIF_11, t0.AssTva AS AssTva_12, t0.NumTva AS NumTva_13, t0.FormeJur AS FormeJur_14, t0.Effectif AS Effectif_15, t0.typetiers AS typetiers_16, t0.source AS source_17, t0.gender AS gender_18, t0.nompr AS nompr_19, t0.prenompr AS prenompr_20, t0.phonepr AS phonepr_21, t0.interes AS interes_22, t0.degr AS degr_23, t0.datec AS datec_24, t0.datetra AS datetra_25, t0.tra AS tra_26, t0.majnote AS majnote_27, t0.datemaj AS datemaj_28, t0.superficie AS superficie_29, t0.action AS action_30, t0.phonepr2 AS phonepr2_31, t0.budget AS budget_32, t0.status AS status_33, t0.urgence AS urgence_34, t0.provinces AS provinces_35, t0.axe AS axe_36, t0.projet AS projet_37, t0.created_at AS created_at_38, t0.emailpr AS emailpr_39, t0.client_user_id AS client_user_id_40 FROM tiers t0 WHERE t0.client_user_id = 17;

SELECT
  t0.id AS id_1,
  t0.Type AS Type_2,
  t0.Nom AS Nom_3,
  t0.Enabled AS Enabled_4
FROM
  analitique t0
WHERE
  t0.Nom = ?
  AND t0.Enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.Type AS Type_2, t0.Nom AS Nom_3, t0.Enabled AS Enabled_4 FROM analitique t0 WHERE t0.Nom = 'LOGISTIQUE' AND t0.Enabled = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.Type AS Type_2,
  t0.Nom AS Nom_3,
  t0.Enabled AS Enabled_4
FROM
  analitique t0
WHERE
  t0.Enabled = ?

SELECT t0.id AS id_1, t0.Type AS Type_2, t0.Nom AS Nom_3, t0.Enabled AS Enabled_4 FROM analitique t0 WHERE t0.Enabled = 1;

SELECT
  t0.id AS id_1,
  t0.idcaissier AS idcaissier_2,
  t0.idcaisse AS idcaisse_3,
  t0.type AS type_4,
  t0.enabled AS enabled_5
FROM
  caisse t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.idcaissier AS idcaissier_2, t0.idcaisse AS idcaisse_3, t0.type AS type_4, t0.enabled AS enabled_5 FROM caisse t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.Type AS Type_2,
  t0.Nom AS Nom_3,
  t0.Enabled AS Enabled_4
FROM
  analitique t0
  INNER JOIN analitique_analitique ON t0.id = analitique_analitique.analitique_target
WHERE
  analitique_analitique.analitique_source = ?

SELECT t0.id AS id_1, t0.Type AS Type_2, t0.Nom AS Nom_3, t0.Enabled AS Enabled_4 FROM analitique t0 INNER JOIN analitique_analitique ON t0.id = analitique_analitique.analitique_target WHERE analitique_analitique.analitique_source = 96;

SELECT
  t0.id AS id_1,
  t0.idcaissier AS idcaissier_2,
  t0.idcaisse AS idcaisse_3,
  t0.type AS type_4,
  t0.enabled AS enabled_5
FROM
  caisse t0
WHERE
  t0.enabled = ?

SELECT t0.id AS id_1, t0.idcaissier AS idcaissier_2, t0.idcaisse AS idcaisse_3, t0.type AS type_4, t0.enabled AS enabled_5 FROM caisse t0 WHERE t0.enabled = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4
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 FROM user t0 WHERE t0.id = 2;

SELECT
  a0_.id AS id_0,
  a0_.Type AS Type_1,
  a0_.Nom AS Nom_2,
  a0_.Enabled AS Enabled_3
FROM
  analitique a0_
WHERE
  a0_.Type = ?
  AND a0_.Enabled = ?
  AND (
    SELECT
      COUNT(*)
    FROM
      analitique_analitique a1_
    WHERE
      a1_.analitique_target = a0_.id
  ) = 0

SELECT a0_.id AS id_0, a0_.Type AS Type_1, a0_.Nom AS Nom_2, a0_.Enabled AS Enabled_3 FROM analitique a0_ WHERE a0_.Type = 'A2' AND a0_.Enabled = 1 AND (SELECT COUNT(*) FROM analitique_analitique a1_ WHERE a1_.analitique_target = a0_.id) = 0;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.ref AS ref_2,
  c0_.rib AS rib_3
FROM
  caisse_compte c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.ref AS ref_2, c0_.rib AS rib_3 FROM caisse_compte c0_;

SELECT
  t0.id AS id_1,
  t0.idUtilisateur AS idUtilisateur_2,
  t0.userid AS userid_3,
  t0.registerkey AS registerkey_4,
  t0.codetr AS codetr_5,
  t0.Fonction AS Fonction_6,
  t0.ClassPro AS ClassPro_7,
  t0.DateEmbauche AS DateEmbauche_8,
  t0.DateDebauche AS DateDebauche_9,
  t0.SalaireB AS SalaireB_10,
  t0.Nbenfant AS Nbenfant_11,
  t0.nb_enfant_fille AS nb_enfant_fille_12,
  t0.nb_enfant_garcon AS nb_enfant_garcon_13,
  t0.mere_en_vie AS mere_en_vie_14,
  t0.pere_en_vie AS pere_en_vie_15,
  t0.nb_proche AS nb_proche_16,
  t0.nb_proche_en_vie AS nb_proche_en_vie_17,
  t0.marital_status AS marital_status_18,
  t0.marriage_date AS marriage_date_19,
  t0.work_time_ratio AS work_time_ratio_20,
  t0.NbjourC AS NbjourC_21,
  t0.UpdateNbj AS UpdateNbj_22,
  t0.enable AS enable_23,
  t0.addDate AS addDate_24,
  t0.photo AS photo_25,
  t0.com AS com_26,
  t0.repartition AS repartition_27,
  t0.cicle AS cicle_28,
  t0.lastadd AS lastadd_29,
  t0.rang AS rang_30,
  t0.matricule AS matricule_31,
  t0.type_contrat AS type_contrat_32,
  t0.nextcloud_path AS nextcloud_path_33,
  t0.nextcloud_share_url AS nextcloud_share_url_34,
  t0.poste_id AS poste_id_35,
  t0.categorie_professionnelle_id AS categorie_professionnelle_id_36,
  t0.departement_id AS departement_id_37,
  t0.manager_id AS manager_id_38
FROM
  travailleur t0
WHERE
  t0.enable = ?

SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.userid AS userid_3, t0.registerkey AS registerkey_4, t0.codetr AS codetr_5, t0.Fonction AS Fonction_6, t0.ClassPro AS ClassPro_7, t0.DateEmbauche AS DateEmbauche_8, t0.DateDebauche AS DateDebauche_9, t0.SalaireB AS SalaireB_10, t0.Nbenfant AS Nbenfant_11, t0.nb_enfant_fille AS nb_enfant_fille_12, t0.nb_enfant_garcon AS nb_enfant_garcon_13, t0.mere_en_vie AS mere_en_vie_14, t0.pere_en_vie AS pere_en_vie_15, t0.nb_proche AS nb_proche_16, t0.nb_proche_en_vie AS nb_proche_en_vie_17, t0.marital_status AS marital_status_18, t0.marriage_date AS marriage_date_19, t0.work_time_ratio AS work_time_ratio_20, t0.NbjourC AS NbjourC_21, t0.UpdateNbj AS UpdateNbj_22, t0.enable AS enable_23, t0.addDate AS addDate_24, t0.photo AS photo_25, t0.com AS com_26, t0.repartition AS repartition_27, t0.cicle AS cicle_28, t0.lastadd AS lastadd_29, t0.rang AS rang_30, t0.matricule AS matricule_31, t0.type_contrat AS type_contrat_32, t0.nextcloud_path AS nextcloud_path_33, t0.nextcloud_share_url AS nextcloud_share_url_34, t0.poste_id AS poste_id_35, t0.categorie_professionnelle_id AS categorie_professionnelle_id_36, t0.departement_id AS departement_id_37, t0.manager_id AS manager_id_38 FROM travailleur t0 WHERE t0.enable = 1;

SELECT
  t0.id AS id_1,
  t0.idcaisse AS idcaisse_2,
  t0.Solde AS Solde_3,
  t0.dateMod AS dateMod_4,
  t0.TypeCaisse AS TypeCaisse_5,
  t0.modeCaisse AS modeCaisse_6,
  t0.nomc AS nomc_7,
  t0.enabled AS enabled_8
FROM
  caisse_type t0
WHERE
  t0.enabled = ?

SELECT t0.id AS id_1, t0.idcaisse AS idcaisse_2, t0.Solde AS Solde_3, t0.dateMod AS dateMod_4, t0.TypeCaisse AS TypeCaisse_5, t0.modeCaisse AS modeCaisse_6, t0.nomc AS nomc_7, t0.enabled AS enabled_8 FROM caisse_type t0 WHERE t0.enabled = 1;

SELECT
  t0.id AS id_1,
  t0.typerf AS typerf_2,
  t0.nomrf AS nomrf_3,
  t0.enabled AS enabled_4
FROM
  rcfac t0
WHERE
  t0.typerf = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.typerf AS typerf_2, t0.nomrf AS nomrf_3, t0.enabled AS enabled_4 FROM rcfac t0 WHERE t0.typerf = 'DC' AND t0.enabled = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.idUtilisateur AS idUtilisateur_2,
  t0.userid AS userid_3,
  t0.registerkey AS registerkey_4,
  t0.codetr AS codetr_5,
  t0.Fonction AS Fonction_6,
  t0.ClassPro AS ClassPro_7,
  t0.DateEmbauche AS DateEmbauche_8,
  t0.DateDebauche AS DateDebauche_9,
  t0.SalaireB AS SalaireB_10,
  t0.Nbenfant AS Nbenfant_11,
  t0.nb_enfant_fille AS nb_enfant_fille_12,
  t0.nb_enfant_garcon AS nb_enfant_garcon_13,
  t0.mere_en_vie AS mere_en_vie_14,
  t0.pere_en_vie AS pere_en_vie_15,
  t0.nb_proche AS nb_proche_16,
  t0.nb_proche_en_vie AS nb_proche_en_vie_17,
  t0.marital_status AS marital_status_18,
  t0.marriage_date AS marriage_date_19,
  t0.work_time_ratio AS work_time_ratio_20,
  t0.NbjourC AS NbjourC_21,
  t0.UpdateNbj AS UpdateNbj_22,
  t0.enable AS enable_23,
  t0.addDate AS addDate_24,
  t0.photo AS photo_25,
  t0.com AS com_26,
  t0.repartition AS repartition_27,
  t0.cicle AS cicle_28,
  t0.lastadd AS lastadd_29,
  t0.rang AS rang_30,
  t0.matricule AS matricule_31,
  t0.type_contrat AS type_contrat_32,
  t0.nextcloud_path AS nextcloud_path_33,
  t0.nextcloud_share_url AS nextcloud_share_url_34,
  t0.poste_id AS poste_id_35,
  t0.categorie_professionnelle_id AS categorie_professionnelle_id_36,
  t0.departement_id AS departement_id_37,
  t0.manager_id AS manager_id_38
FROM
  travailleur t0
WHERE
  t0.userid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.userid AS userid_3, t0.registerkey AS registerkey_4, t0.codetr AS codetr_5, t0.Fonction AS Fonction_6, t0.ClassPro AS ClassPro_7, t0.DateEmbauche AS DateEmbauche_8, t0.DateDebauche AS DateDebauche_9, t0.SalaireB AS SalaireB_10, t0.Nbenfant AS Nbenfant_11, t0.nb_enfant_fille AS nb_enfant_fille_12, t0.nb_enfant_garcon AS nb_enfant_garcon_13, t0.mere_en_vie AS mere_en_vie_14, t0.pere_en_vie AS pere_en_vie_15, t0.nb_proche AS nb_proche_16, t0.nb_proche_en_vie AS nb_proche_en_vie_17, t0.marital_status AS marital_status_18, t0.marriage_date AS marriage_date_19, t0.work_time_ratio AS work_time_ratio_20, t0.NbjourC AS NbjourC_21, t0.UpdateNbj AS UpdateNbj_22, t0.enable AS enable_23, t0.addDate AS addDate_24, t0.photo AS photo_25, t0.com AS com_26, t0.repartition AS repartition_27, t0.cicle AS cicle_28, t0.lastadd AS lastadd_29, t0.rang AS rang_30, t0.matricule AS matricule_31, t0.type_contrat AS type_contrat_32, t0.nextcloud_path AS nextcloud_path_33, t0.nextcloud_share_url AS nextcloud_share_url_34, t0.poste_id AS poste_id_35, t0.categorie_professionnelle_id AS categorie_professionnelle_id_36, t0.departement_id AS departement_id_37, t0.manager_id AS manager_id_38 FROM travailleur t0 WHERE t0.userid = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1