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

SELECT
  COUNT(*)
FROM
  ticket t0
WHERE
  t0.created_by_id = ?

SELECT COUNT(*) FROM ticket t0 WHERE t0.created_by_id = 34;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.create_at AS create_at_3,
  t0.update_at AS update_at_4,
  t0.position AS position_5
FROM
  etat_ticket t0
WHERE
  t0.position = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.create_at AS create_at_3, t0.update_at AS update_at_4, t0.position AS position_5 FROM etat_ticket t0 WHERE t0.position = 4;

SELECT
  COUNT(*)
FROM
  ticket t0
WHERE
  t0.created_by_id = ?
  AND t0.etat_id IN (?)

SELECT COUNT(*) FROM ticket t0 WHERE t0.created_by_id = 34 AND t0.etat_id IN (4);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.create_at AS create_at_3,
  t0.update_at AS update_at_4,
  t0.position AS position_5
FROM
  etat_ticket t0
WHERE
  t0.position IN (?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.create_at AS create_at_3, t0.update_at AS update_at_4, t0.position AS position_5 FROM etat_ticket t0 WHERE t0.position IN (1, 2, 3);

SELECT
  COUNT(*)
FROM
  ticket t0
WHERE
  t0.created_by_id = ?
  AND t0.etat_id IN (?, ?, ?)

SELECT COUNT(*) FROM ticket t0 WHERE t0.created_by_id = 34 AND t0.etat_id IN (1, 2, 3);

SELECT
  COUNT(*)
FROM
  ticket t0
WHERE
  t0.affected_to_id = ?

SELECT COUNT(*) FROM ticket t0 WHERE t0.affected_to_id = 34;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.create_at AS create_at_3,
  t0.update_at AS update_at_4,
  t0.position AS position_5
FROM
  etat_ticket t0
WHERE
  t0.position = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.create_at AS create_at_3, t0.update_at AS update_at_4, t0.position AS position_5 FROM etat_ticket t0 WHERE t0.position = 4;

SELECT
  COUNT(*)
FROM
  ticket t0
WHERE
  t0.affected_to_id = ?
  AND t0.etat_id IN (?)

SELECT COUNT(*) FROM ticket t0 WHERE t0.affected_to_id = 34 AND t0.etat_id IN (4);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.create_at AS create_at_3,
  t0.update_at AS update_at_4,
  t0.position AS position_5
FROM
  etat_ticket t0
WHERE
  t0.position IN (?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.create_at AS create_at_3, t0.update_at AS update_at_4, t0.position AS position_5 FROM etat_ticket t0 WHERE t0.position IN (1, 2, 3);

SELECT
  COUNT(*)
FROM
  ticket t0
WHERE
  t0.affected_to_id = ?
  AND t0.etat_id IN (?, ?, ?)

SELECT COUNT(*) FROM ticket t0 WHERE t0.affected_to_id = 34 AND t0.etat_id IN (1, 2, 3);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.create_at AS create_at_3,
  t0.update_at AS update_at_4,
  t0.position AS position_5
FROM
  etat_ticket t0
WHERE
  t0.position IN (?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.create_at AS create_at_3, t0.update_at AS update_at_4, t0.position AS position_5 FROM etat_ticket t0 WHERE t0.position IN (1, 2, 3);

SELECT
  COUNT(*)
FROM
  ticket t0
WHERE
  t0.created_by_id = ?
  AND t0.etat_id IN (?, ?, ?)

SELECT COUNT(*) FROM ticket t0 WHERE t0.created_by_id = 34 AND t0.etat_id IN (1, 2, 3);

SELECT
  COUNT(*)
FROM
  ticket_rapport t0

SELECT COUNT(*) FROM ticket_rapport t0;

SELECT
  COUNT(*)
FROM
  presence t0
WHERE
  t0.agent_id = ?

SELECT COUNT(*) FROM presence t0 WHERE t0.agent_id = 34;

SELECT
  count(id) as nb
FROM
  presence
WHERE
  presence.created_at >= '2026-06-01 00:00:00'
  AND presence.created_at <= '2026-06-16 23:59:59'
  AND presence.agent_id = 34

SELECT count(id) as nb
                FROM presence 
                WHERE presence.created_at >= '2026-06-01 00:00:00' 
                    AND presence.created_at <= '2026-06-16 23:59:59' 
                     AND presence.agent_id=34 
        ;

SELECT
  count(id) as nb
FROM
  presence
WHERE
  presence.created_at >= '2026-01-01 00:00:00'
  AND presence.created_at <= '2026-06-16 23:59:59'
  AND presence.agent_id = 34

SELECT count(id) as nb
                FROM presence 
                WHERE presence.created_at >= '2026-01-01 00:00:00' 
                    AND presence.created_at <= '2026-06-16 23:59:59' 
                     AND presence.agent_id=34 
        ;

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
  COUNT(*)
FROM
  notification t0
WHERE
  t0.receiver_id = ?
  AND t0.seen_at IS NULL

SELECT COUNT(*) FROM notification t0 WHERE t0.receiver_id = 34 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 = 34 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 = 34 ORDER BY t0.seen_at DESC, t0.created_at DESC LIMIT 3;

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