Symfony Profiler

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.heure AS heure_3,
  t0.type AS type_4,
  t0.validated AS validated_5,
  t0.agent_id AS agent_id_6
FROM
  pointage t0
WHERE
  t0.agent_id = ?
  AND t0.date = ?
  AND t0.validated = ?
ORDER BY
  t0.heure ASC

SELECT t0.id AS id_1, t0.date AS date_2, t0.heure AS heure_3, t0.type AS type_4, t0.validated AS validated_5, t0.agent_id AS agent_id_6 FROM pointage t0 WHERE t0.agent_id = 30 AND t0.date = '2026-03-23' AND t0.validated = 1 ORDER BY t0.heure ASC;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.email AS email_7
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.email AS email_7 FROM user t0 WHERE t0.id = 30;

SELECT
  p0_.id AS id_0,
  p0_.date AS date_1,
  p0_.heure AS heure_2,
  p0_.type AS type_3,
  p0_.validated AS validated_4,
  p0_.agent_id AS agent_id_5
FROM
  pointage p0_
WHERE
  p0_.agent_id = ?
  AND p0_.validated = ?
  AND p0_.date >= ?
  AND p0_.date <= ?
ORDER BY
  p0_.date ASC,
  p0_.heure ASC

SELECT p0_.id AS id_0, p0_.date AS date_1, p0_.heure AS heure_2, p0_.type AS type_3, p0_.validated AS validated_4, p0_.agent_id AS agent_id_5 FROM pointage p0_ WHERE p0_.agent_id = 30 AND p0_.validated = 1 AND p0_.date >= '2026-03-01 00:00:00' AND p0_.date <= '2026-03-31 00:00:00' ORDER BY p0_.date ASC, p0_.heure ASC;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO pointage (
  date, heure, TYPE, validated, agent_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO pointage (date, heure, TYPE, validated, agent_id) VALUES ('2026-03-23', '15:50', 'dépointage', 1, 30);

SELECT
  t0.id AS id_1,
  t0.mois AS mois_2,
  t0.annee AS annee_3,
  t0.total AS total_4,
  t0.agent_id AS agent_id_5
FROM
  heure_agent t0
WHERE
  t0.agent_id = ?
  AND t0.mois = ?
  AND t0.annee = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.mois AS mois_2, t0.annee AS annee_3, t0.total AS total_4, t0.agent_id AS agent_id_5 FROM heure_agent t0 WHERE t0.agent_id = 30 AND t0.mois = '03' AND t0.annee = '2026' LIMIT 1;

UPDATE
  heure_agent
SET
  total = ?
WHERE
  id = ?

UPDATE heure_agent SET total = 245160 WHERE id = 112;