https://essabiri-bo-r7.zaimdigital.com/pointage/new

Query Metrics

7 Database Queries
7 Different statements
18.26 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.66 ms
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
]
2 0.76 ms
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
]
3 0.69 ms
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
]
4 11.89 ms
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"
]
5 2.10 ms
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:
[]
6 0.62 ms
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:
[]
7 0.54 ms
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.