Query Metrics
7
Database Queries
7
Different statements
18.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
11.89 ms (65.12%) |
1 |
SELECT t0_.id AS id_0, t0_.code_rh AS code_rh_1, t0_.salarie AS salarie_2, t0_.statut AS statut_3, t0_.nbr_heure_par_semaine AS nbr_heure_par_semaine_4, t0_.tarif_heure AS tarif_heure_5, t0_.date_embauche AS date_embauche_6, t0_.date_fin_embauche AS date_fin_embauche_7, t0_.emploi AS emploi_8, t0_.adresse AS adresse_9, t0_.note AS note_10, t0_.nom AS nom_11, t0_.prenom AS prenom_12, t0_.num_tel AS num_tel_13, t0_.email AS email_14, t0_.date_naissance AS date_naissance_15, t0_.cin AS cin_16, t0_.tarif_jours AS tarif_jours_17, t0_.tarif_salaire AS tarif_salaire_18, t0_.created_at AS created_at_19, t0_.updated_at AS updated_at_20, t0_.deleted_at AS deleted_at_21, t0_.genre_id AS genre_id_22, t0_.type_id AS type_id_23, t0_.type_contrat_id AS type_contrat_id_24, t0_.user_id AS user_id_25, t0_.ville_id AS ville_id_26, t0_.pays_id AS pays_id_27, t0_.fonction_id AS fonction_id_28, t0_.groupe_id AS groupe_id_29, t0_.created_by AS created_by_30, t0_.updated_by AS updated_by_31, t0_.deleted_by AS deleted_by_32 FROM tbl_personnel t0_ WHERE t0_.fonction_id <> ? ORDER BY t0_.nom ASC
Parameters:
[
"3"
]
|
|
2.10 ms (11.50%) |
1 |
SELECT r0_.id AS id_0, r0_.duree_operation AS duree_operation_1, r0_.valeur_jour AS valeur_jour_2, r0_.created_at AS created_at_3, r0_.updated_at AS updated_at_4, r0_.deleted_at AS deleted_at_5, r0_.created_by AS created_by_6, r0_.updated_by AS updated_by_7, r0_.deleted_by AS deleted_by_8 FROM ref_duree_operation_travail r0_
Parameters:
[] |
|
1.66 ms (9.11%) |
1 |
SELECT t0.user_id AS user_id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.tel AS tel_5, t0.date_naissance AS date_naissance_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.is_salarie AS is_salarie_9, t0.username_court AS username_court_10, t0.nbr_conncetion AS nbr_conncetion_11, t0.last_connection AS last_connection_12 FROM user t0 WHERE t0.user_id = ?
Parameters:
[
1
]
|
|
0.76 ms (4.15%) |
1 |
SELECT t0.profil_id AS profil_id_1, t0.profil_lib AS profil_lib_2, t0.profil_sf AS profil_sf_3 FROM ref_profil t0 INNER JOIN lnk_user_profil ON t0.profil_id = lnk_user_profil.profil_id WHERE lnk_user_profil.user_id = ?
Parameters:
[
1
]
|
|
0.69 ms (3.80%) |
1 |
SELECT t0.id AS id_1, t0.raison_social AS raison_social_2, t0.adresse AS adresse_3, t0.code_postal AS code_postal_4, t0.pays AS pays_5, t0.departement AS departement_6, t0.devise_principale AS devise_principale_7, t0.telephone AS telephone_8, t0.fax AS fax_9, t0.email AS email_10, t0.web AS web_11, t0.note AS note_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.ville AS ville_16, t0.logo_societe_id AS logo_societe_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19, t0.deleted_by AS deleted_by_20 FROM tbl_societe t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.62 ms (3.40%) |
1 |
SELECT r0_.id AS id_0, r0_.type_operation AS type_operation_1, r0_.created_at AS created_at_2, r0_.updated_at AS updated_at_3, r0_.deleted_at AS deleted_at_4, r0_.created_by AS created_by_5, r0_.updated_by AS updated_by_6, r0_.deleted_by AS deleted_by_7 FROM ref_type_operation_travail r0_ ORDER BY r0_.type_operation ASC
Parameters:
[] |
|
0.54 ms (2.93%) |
1 |
SELECT t0_.id AS id_0, t0_.parcelle AS parcelle_1, t0_.surface_hectare AS surface_hectare_2, t0_.created_at AS created_at_3, t0_.updated_at AS updated_at_4, t0_.deleted_at AS deleted_at_5, t0_.created_by AS created_by_6, t0_.updated_by AS updated_by_7, t0_.deleted_by AS deleted_by_8 FROM tbl_parcelle t0_ ORDER BY t0_.parcelle ASC
Parameters:
[] |
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\Profil | No errors. |
| App\Entity\TblMouvement | No errors. |
| App\Entity\TblOperationVente | No errors. |
| App\Entity\TblSociete | No errors. |
| App\Entity\RefVille | No errors. |
| App\Entity\TblFile | No errors. |
| App\Entity\TblOperationTravail | No errors. |
| App\Entity\TblOperationPaie | No errors. |
| App\Entity\RefTypeOperationPaie | No errors. |
| App\Entity\TblMission | No errors. |
| App\Entity\TblParcelle | No errors. |
| App\Entity\RefTypeOperationTravail | No errors. |
| App\Entity\TblPersonnel | No errors. |
| App\Entity\RefGenre | No errors. |
| App\Entity\RefTypePersonnel | No errors. |
| App\Entity\RefTypeContrat | No errors. |
| App\Entity\RefPays | No errors. |
| App\Entity\RefFonction | No errors. |
| App\Entity\RefGroupe | No errors. |
| App\Entity\RefDureeOperationTravail | No errors. |
| App\Entity\TblOperations | No errors. |
| App\Entity\RefTypeProduit | No errors. |
| App\Entity\TblDetailQuantiteParcelle | No errors. |