POST http://gpi.datm.tech/presence/checkout/day

Query Metrics

6 Database Queries
6 Different statements
11.50 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 5.44 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.device_id AS device_id_7, t0.enable_device_check AS enable_device_check_8, t9.id AS id_10, t9.matricule AS matricule_11, t9.nom AS nom_12, t9.prenom AS prenom_13, t9.tel AS tel_14, t9.create_at AS create_at_15, t9.update_at AS update_at_16, t9.salaire AS salaire_17, t9.salaire_restant AS salaire_restant_18, t9.agence_id AS agence_id_19, t9.user_id AS user_id_20, t0.role_id AS role_id_21, t0.role_profile_id AS role_profile_id_22 FROM "user" t0 LEFT JOIN employe t9 ON t9.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  11
]
2 2.07 ms
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.address AS address_3, t0.phone1 AS phone1_4, t0.name AS name_5, t0.created_at AS created_at_6, t0.email AS email_7, t0.domain_name AS domain_name_8, t0.penalite AS penalite_9 FROM gpi t0 ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[]
3 1.51 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.ip_adresse AS ip_adresse_3, t0.penalite AS penalite_4, t0.saved_at AS saved_at_5, t0.est_present AS est_present_6, t0.motif_retard AS motif_retard_7, t0.checkout_at AS checkout_at_8, t0.salaire_restant AS salaire_restant_9, t0.agent_id AS agent_id_10, t0.agence_id AS agence_id_11 FROM presence t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "3362"
]
4 0.31 ms
"START TRANSACTION"
Parameters:
[]
5 0.83 ms
UPDATE presence SET checkout_at = ? WHERE id = ?
Parameters:
[
  "2026-06-15 18:37:16"
  3362
]
6 1.34 ms
"COMMIT"
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\Employe No errors.
App\Entity\Agence No errors.
App\Entity\Role No errors.
App\Entity\RoleProfile No errors.
App\Entity\Ticket No errors.
App\Entity\Mission No errors.
App\Entity\Presence No errors.
App\Entity\Notification No errors.
App\Entity\TicketRapport No errors.
App\Entity\Penalite No errors.
App\Entity\UserDevice No errors.
App\Entity\Gpi No errors.