Query Metrics
7
Database Queries
7
Different statements
6.25 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.12 ms |
SELECT t0.nom_ar AS nom_ar_1, t0.nom_fr AS nom_fr_2, t0.create_date AS create_date_3, t0.write_date AS write_date_4, t0.active AS active_5, t0.id AS id_6, t0.uuid AS uuid_7, t0.model AS model_8, t0.platform AS platform_9, t0.create_uid_id AS create_uid_id_10, t0.write_uid_id AS write_uid_id_11, t0.company_id AS company_id_12, t0.poste_id AS poste_id_13 FROM device t0 WHERE t0.uuid = ? LIMIT 1
Parameters:
[
"12da6e76482acc9b"
]
|
| 2 | 0.76 ms |
SELECT t0.nom_ar AS nom_ar_1, t0.nom_fr AS nom_fr_2, t0.create_date AS create_date_3, t0.write_date AS write_date_4, t0.active AS active_5, t0.id AS id_6, t0.telephone AS telephone_7, t0.create_uid_id AS create_uid_id_8, t0.write_uid_id AS write_uid_id_9, t0.company_id AS company_id_10, t0.poste_director_id AS poste_director_id_11, t0.responsable_id AS responsable_id_12, t0.localite_id AS localite_id_13, t0.type_id AS type_id_14 FROM poste t0 WHERE t0.id = ?
Parameters:
[
139
]
|
| 3 | 0.81 ms |
SELECT t0.nom_ar AS nom_ar_1, t0.nom_fr AS nom_fr_2, t0.create_date AS create_date_3, t0.write_date AS write_date_4, t0.active AS active_5, t0.id AS id_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.personal_phone AS personal_phone_9, t0.email AS email_10, t0.sexe AS sexe_11, t0.create_uid_id AS create_uid_id_12, t0.write_uid_id AS write_uid_id_13, t0.company_id AS company_id_14, t0.partner_id AS partner_id_15, t0.type_id AS type_id_16, t0.poste_director_id AS poste_director_id_17 FROM employee t0 WHERE t0.id = ?
Parameters:
[
123
]
|
| 4 | 0.55 ms |
SELECT t0.nom_ar AS nom_ar_1, t0.nom_fr AS nom_fr_2, t0.create_date AS create_date_3, t0.write_date AS write_date_4, t0.active AS active_5, t0.id AS id_6, t0.filtre AS filtre_7, t0.valeur AS valeur_8, t0.create_uid_id AS create_uid_id_9, t0.write_uid_id AS write_uid_id_10, t0.company_id AS company_id_11 FROM res_liste_de_choix t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 5 | 0.86 ms |
SELECT t0.nom_ar AS nom_ar_1, t0.nom_fr AS nom_fr_2, t0.create_date AS create_date_3, t0.write_date AS write_date_4, t0.active AS active_5, t0.id AS id_6, t0.field_code AS field_code_7, t0.field_label AS field_label_8, t0.max_value AS max_value_9, t0.min_value AS min_value_10, t0.type AS type_11, t0.ordre AS ordre_12, t0.create_uid_id AS create_uid_id_13, t0.write_uid_id AS write_uid_id_14, t0.company_id AS company_id_15, t0.poste_id AS poste_id_16 FROM poste_config t0 WHERE t0.poste_id = ? ORDER BY t0.ordre ASC
Parameters:
[
139
]
|
| 6 | 0.63 ms |
SELECT d0_.nom_ar AS nom_ar_0, d0_.nom_fr AS nom_fr_1, d0_.create_date AS create_date_2, d0_.write_date AS write_date_3, d0_.active AS active_4, d0_.id AS id_5, d0_.heure_debut AS heure_debut_6, d0_.heure_fin AS heure_fin_7, d0_.demande_date_time AS demande_date_time_8, d0_.type AS type_9, d0_.create_uid_id AS create_uid_id_10, d0_.write_uid_id AS write_uid_id_11, d0_.company_id AS company_id_12, d0_.poste_id AS poste_id_13 FROM demande_vacation d0_ WHERE d0_.poste_id = ? AND d0_.demande_date_time >= ? AND d0_.demande_date_time <= ?
Parameters:
[ 139 "2026-02-15 00:00:00" "2026-02-15 23:59:59" ] |
| 7 | 1.52 ms |
SELECT COUNT(v0_.id) AS sclr_0 FROM vacation v0_ WHERE v0_.poste_id = ? AND v0_.vacation_date_time >= ? AND v0_.vacation_date_time <= ?
Parameters:
[ 139 "2026-02-15 00:00:00" "2026-02-15 23:59:59" ] |
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\EntityBase | No errors. |
| App\Entity\Device | No errors. |
| App\Entity\AppUser | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Poste | No errors. |
| App\Entity\PosteDirector | No errors. |
| App\Entity\Employee | No errors. |
| App\Entity\Localite | No errors. |
| App\Entity\ResListeDeChoix | No errors. |
| App\Entity\Vacation | No errors. |
| App\Entity\PosteConfig | No errors. |
| App\Entity\DemandeVacation | No errors. |
| App\Entity\Partner | No errors. |