Query Metrics
1648
Database Queries
6
Different statements
393.88 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
348.91 ms (88.58%) |
1636 |
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 WHERE t0.id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||
|
37.88 ms (9.62%) |
1 |
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.typetiers = ?
Parameters:
[
"client"
]
|
||||||||||||||||||||||||
|
3.59 ms (0.91%) |
1 |
SELECT t0.id AS id_1, t0.Denprojet AS Denprojet_2, t0.restap AS restap_3, t0.idanal AS idanal_4, t0.codeprojet AS codeprojet_5, t0.sitjuridique AS sitjuridique_6, t0.Numtitrs AS Numtitrs_7, t0.Numregistre AS Numregistre_8, t0.Numfolio AS Numfolio_9, t0.sisea AS sisea_10, t0.fokotany AS fokotany_11, t0.Commune AS Commune_12, t0.District AS District_13, t0.Region AS Region_14, t0.Nompropriete AS Nompropriete_15, t0.contenance AS contenance_16, t0.proprietaire AS proprietaire_17, t0.Signataire AS Signataire_18, t0.PersonaPPV AS PersonaPPV_19, t0.PAterrain AS PAterrain_20, t0.contrat AS contrat_21, t0.categorie AS categorie_22, t0.refarch AS refarch_23, t0.coordong AS coordong_24, t0.aventage AS aventage_25, t0.inconv AS inconv_26, t0.contenance_av AS contenance_av_27, t0.piecejoint AS piecejoint_28, t0.suivie AS suivie_29, t0.description AS description_30, t0.coordinates AS coordinates_31, t0.date AS date_32, t0.axe AS axe_33, t0.type AS type_34, t0.min AS min_35, t0.max AS max_36, t0.supmin AS supmin_37, t0.supmax AS supmax_38, t0.noted AS noted_39, t0.budget AS budget_40, t0.budgets AS budgets_41, t0.public_visibility AS public_visibility_42, t0.nextcloud_path AS nextcloud_path_43, t0.nextcloud_share_url AS nextcloud_share_url_44, t0.fournisseur_id AS fournisseur_id_45, t0.logo_id AS logo_id_46, t0.image_principal_id AS image_principal_id_47 FROM terrain t0 WHERE t0.contrat = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||
|
2.63 ms (0.67%) |
8 |
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 = ?
Parameters:
[
17
]
|
||||||||||||||||||||||||
|
0.48 ms (0.12%) |
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 = ?
Parameters:
[
39
]
|
||||||||||||||||||||||||
|
0.39 ms (0.10%) |
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.enable = ?
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\ContractGroup | No errors. |
| App\Entity\Documentation | No errors. |
| App\Entity\Offre | No errors. |
| App\Entity\Tiers | No errors. |
| App\Entity\ClientUser | No errors. |
| App\Entity\ActionAf | No errors. |
| App\Entity\RedispacheTo | No errors. |
| App\Entity\Terrain |
|
| App\Entity\Fournisseur | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\ImageTerrain | No errors. |
| App\Entity\TerrainTag | No errors. |
| App\Entity\PropositionOffre | No errors. |
| App\Entity\SourceTerrain | No errors. |
| App\Entity\Contract |
|
| App\Entity\Promesse |
|
| App\Entity\Reservation | No errors. |
| App\Entity\Decaissement | No errors. |
| App\Entity\Terrassement | No errors. |
| App\Entity\CaisseCompte | No errors. |
| App\Entity\Mutation | No errors. |
| App\Entity\FosUser |
|
| App\Entity\ObservationClient | No errors. |
| App\Entity\Parrainage | No errors. |
| App\Entity\Travailleur | No errors. |
| App\Entity\Poste | No errors. |
| App\Entity\CategorieProfessionnelle | No errors. |
| App\Entity\Departement | No errors. |
| App\Entity\TravailleurDocument | No errors. |