Symfony Profiler

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 = ?

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 = 11;

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

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;

SELECT
  m0_.id AS id_0,
  m0_.debut AS debut_1,
  m0_.fin AS fin_2,
  m0_.created_at AS created_at_3,
  m0_.updated_at AS updated_at_4,
  m0_.valide AS valide_5,
  m0_.user_id AS user_id_6,
  m0_.agence_id AS agence_id_7
FROM
  mission m0_
WHERE
  (
    m0_.debut <= ?
    OR m0_.fin >= ?
  )
  AND m0_.user_id = ?
ORDER BY
  m0_.created_at DESC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.debut AS debut_1, m0_.fin AS fin_2, m0_.created_at AS created_at_3, m0_.updated_at AS updated_at_4, m0_.valide AS valide_5, m0_.user_id AS user_id_6, m0_.agence_id AS agence_id_7 FROM mission m0_ WHERE (m0_.debut <= '2026-06-15' OR m0_.fin >= '2026-06-15') AND m0_.user_id = 11 ORDER BY m0_.created_at DESC LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.created_at AS created_at_1,
  p0_.ip_adresse AS ip_adresse_2,
  p0_.penalite AS penalite_3,
  p0_.saved_at AS saved_at_4,
  p0_.est_present AS est_present_5,
  p0_.motif_retard AS motif_retard_6,
  p0_.checkout_at AS checkout_at_7,
  p0_.salaire_restant AS salaire_restant_8,
  p0_.agent_id AS agent_id_9,
  p0_.agence_id AS agence_id_10
FROM
  presence p0_
WHERE
  p0_.created_at >= ?
  AND p0_.created_at <= ?
  AND p0_.agent_id = 11
  AND p0_.est_present = 'o'
ORDER BY
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.ip_adresse AS ip_adresse_2, p0_.penalite AS penalite_3, p0_.saved_at AS saved_at_4, p0_.est_present AS est_present_5, p0_.motif_retard AS motif_retard_6, p0_.checkout_at AS checkout_at_7, p0_.salaire_restant AS salaire_restant_8, p0_.agent_id AS agent_id_9, p0_.agence_id AS agence_id_10 FROM presence p0_ WHERE p0_.created_at >= '2026-06-15 00:00:00' AND p0_.created_at <= '2026-06-15 23:59:59' AND p0_.agent_id = 11 AND p0_.est_present = 'o' ORDER BY p0_.created_at DESC;

SELECT
  a0_.id AS id_0,
  a0_.nom AS nom_1,
  a0_.departement AS departement_2,
  a0_.ville AS ville_3,
  a0_.pays AS pays_4,
  a0_.created_at AS created_at_5,
  a0_.updated_at AS updated_at_6,
  a0_.plage_ip AS plage_ip_7,
  a0_.device_hmac AS device_hmac_8
FROM
  agence a0_
ORDER BY
  a0_.nom ASC

SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.departement AS departement_2, a0_.ville AS ville_3, a0_.pays AS pays_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.plage_ip AS plage_ip_7, a0_.device_hmac AS device_hmac_8 FROM agence a0_ ORDER BY a0_.nom ASC;

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

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;

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

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;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.abbrev AS abbrev_3,
  t0.accepte_ticket AS accepte_ticket_4,
  t0.heure_limite_arrive AS heure_limite_arrive_5,
  t0.ignorer_penalite AS ignorer_penalite_6,
  t0.manage_ticket AS manage_ticket_7,
  t0.role_id AS role_id_8
FROM
  role_profile t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.abbrev AS abbrev_3, t0.accepte_ticket AS accepte_ticket_4, t0.heure_limite_arrive AS heure_limite_arrive_5, t0.ignorer_penalite AS ignorer_penalite_6, t0.manage_ticket AS manage_ticket_7, t0.role_id AS role_id_8 FROM role_profile t0 WHERE t0.id = 5;

SELECT
  COUNT(*)
FROM
  notification t0
WHERE
  t0.receiver_id = ?
  AND t0.seen_at IS NULL

SELECT COUNT(*) FROM notification t0 WHERE t0.receiver_id = 11 AND t0.seen_at IS NULL;

SELECT
  COUNT(*)
FROM
  notification t0
WHERE
  t0.receiver_id = ?
  AND t0.seen_at IS NULL

SELECT COUNT(*) FROM notification t0 WHERE t0.receiver_id = 11 AND t0.seen_at IS NULL;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.target AS target_4,
  t0.seen_at AS seen_at_5,
  t0.object_id AS object_id_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.extra AS extra_9,
  t0.path AS path_10,
  t0.receiver_id AS receiver_id_11
FROM
  notification t0
WHERE
  t0.receiver_id = ?
ORDER BY
  t0.seen_at DESC,
  t0.created_at DESC
LIMIT
  3

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.target AS target_4, t0.seen_at AS seen_at_5, t0.object_id AS object_id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.extra AS extra_9, t0.path AS path_10, t0.receiver_id AS receiver_id_11 FROM notification t0 WHERE t0.receiver_id = 11 ORDER BY t0.seen_at DESC, t0.created_at DESC LIMIT 3;