https://drpe.alternative-it.net/api/get_poste_infos Return to referer URL

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.28 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:
[
  "c61a15e5f1f8da5b"
]
2 0.98 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:
[
  123
]
3 0.78 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:
[
  107
]
4 0.78 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:
[
  123
]
6 0.64 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:
[
  123
  "2026-02-15 00:00:00"
  "2026-02-15 23:59:59"
]
7 1.45 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:
[
  123
  "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.