Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 3
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.role AS role_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.is_active AS is_active_7, t0.permissions AS permissions_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_verified AS is_verified_11, t0.region_id AS region_id_12, t0.entity_id AS entity_id_13 FROM user t0 WHERE t0.email = ? LIMIT 1

[
  "pf.Vatovavy@metfp.mg"
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.role AS role_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.is_active AS is_active_7,
  t0.permissions AS permissions_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.is_verified AS is_verified_11,
  t0.region_id AS region_id_12,
  t0.entity_id AS entity_id_13
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.role AS role_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.is_active AS is_active_7, t0.permissions AS permissions_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_verified AS is_verified_11, t0.region_id AS region_id_12, t0.entity_id AS entity_id_13 FROM user t0 WHERE t0.email = 'pf.Vatovavy@metfp.mg' LIMIT 1;

SELECT t0.id AS id_1, t0.email AS email_2, t0.role AS role_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.is_active AS is_active_7, t0.permissions AS permissions_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_verified AS is_verified_11, t0.region_id AS region_id_12, t0.entity_id AS entity_id_13 FROM user t0 WHERE t0.email = ? LIMIT 1

[
  "pf.Vatovavy@metfp.mg"
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.role AS role_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.is_active AS is_active_7,
  t0.permissions AS permissions_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.is_verified AS is_verified_11,
  t0.region_id AS region_id_12,
  t0.entity_id AS entity_id_13
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.role AS role_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.is_active AS is_active_7, t0.permissions AS permissions_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_verified AS is_verified_11, t0.region_id AS region_id_12, t0.entity_id AS entity_id_13 FROM user t0 WHERE t0.email = 'pf.Vatovavy@metfp.mg' LIMIT 1;

SELECT t0.id AS id_1, t0.cle AS cle_2, t0.valeur AS valeur_3, t0.modifie_le AS modifie_le_4, t0.modifie_par_id AS modifie_par_id_5 FROM parametre t0

[]

SELECT
  t0.id AS id_1,
  t0.cle AS cle_2,
  t0.valeur AS valeur_3,
  t0.modifie_le AS modifie_le_4,
  t0.modifie_par_id AS modifie_par_id_5
FROM
  parametre t0

SELECT t0.id AS id_1, t0.cle AS cle_2, t0.valeur AS valeur_3, t0.modifie_le AS modifie_le_4, t0.modifie_par_id AS modifie_par_id_5 FROM parametre t0;

UPDATE user_session SET statut = ?, closed_at = ? WHERE statut = ? AND last_activity_at < ?

[
  "expiree"
  "2026-11-09 13:01:52"
  "active"
  "2026-11-09 12:01:52"
]

UPDATE
  user_session
SET
  statut = ?,
  closed_at = ?
WHERE
  statut = ?
  AND last_activity_at < ?

UPDATE user_session SET statut = 'expiree', closed_at = '2026-11-09 13:01:52' WHERE statut = 'active' AND last_activity_at < '2026-11-09 12:01:52';

SELECT u0_.id AS id_0, u0_.session_hash AS session_hash_1, u0_.statut AS statut_2, u0_.created_at AS created_at_3, u0_.last_activity_at AS last_activity_at_4, u0_.closed_at AS closed_at_5, u0_.ip AS ip_6, u0_.user_agent AS user_agent_7, u0_.user_id AS user_id_8, u0_.closed_by_id AS closed_by_id_9 FROM user_session u0_ WHERE u0_.user_id = ? AND u0_.statut = ? ORDER BY u0_.last_activity_at DESC LIMIT 1

[
  103
  "active"
]

SELECT
  u0_.id AS id_0,
  u0_.session_hash AS session_hash_1,
  u0_.statut AS statut_2,
  u0_.created_at AS created_at_3,
  u0_.last_activity_at AS last_activity_at_4,
  u0_.closed_at AS closed_at_5,
  u0_.ip AS ip_6,
  u0_.user_agent AS user_agent_7,
  u0_.user_id AS user_id_8,
  u0_.closed_by_id AS closed_by_id_9
FROM
  user_session u0_
WHERE
  u0_.user_id = ?
  AND u0_.statut = ?
ORDER BY
  u0_.last_activity_at DESC
LIMIT
  1

SELECT u0_.id AS id_0, u0_.session_hash AS session_hash_1, u0_.statut AS statut_2, u0_.created_at AS created_at_3, u0_.last_activity_at AS last_activity_at_4, u0_.closed_at AS closed_at_5, u0_.ip AS ip_6, u0_.user_agent AS user_agent_7, u0_.user_id AS user_id_8, u0_.closed_by_id AS closed_by_id_9 FROM user_session u0_ WHERE u0_.user_id = 103 AND u0_.statut = 'active' ORDER BY u0_.last_activity_at DESC LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO journal_action (cree_le, auteur_nom, auteur_role, type, module, action, cible_type, cible_id, cible_libelle, ancien_etat, nouvel_etat, ip, navigateur, user_agent, auteur_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  "2026-11-09 13:01:52"
  "Point focal VATOVAVY"
  "Responsable régional"
  "connexion"
  "Authentification"
  "s’est connecté à l’espace back-office"
  null
  null
  null
  null
  null
  "102.18.157.28"
  "Firefox"
  "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:159.0) Gecko/20100101 Firefox/159.0"
  103
]

INSERT INTO journal_action (
  cree_le, auteur_nom, auteur_role,
  type, module, action, cible_type,
  cible_id, cible_libelle, ancien_etat,
  nouvel_etat, ip, navigateur, user_agent,
  auteur_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO journal_action (cree_le, auteur_nom, auteur_role, type, module, action, cible_type, cible_id, cible_libelle, ancien_etat, nouvel_etat, ip, navigateur, user_agent, auteur_id) VALUES ('2026-11-09 13:01:52', 'Point focal VATOVAVY', 'Responsable régional', 'connexion', 'Authentification', 's’est connecté à l’espace back-office', NULL, NULL, NULL, NULL, NULL, '102.18.157.28', 'Firefox', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:159.0) Gecko/20100101 Firefox/159.0', 103);

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT t0.id AS id_1, t0.session_hash AS session_hash_2, t0.statut AS statut_3, t0.created_at AS created_at_4, t0.last_activity_at AS last_activity_at_5, t0.closed_at AS closed_at_6, t0.ip AS ip_7, t0.user_agent AS user_agent_8, t0.user_id AS user_id_9, t0.closed_by_id AS closed_by_id_10 FROM user_session t0 WHERE t0.session_hash = ? LIMIT 1

[
  "679094d6f8eb43b1d18a04222015ec9d95c2fe92518f1b6d6f4917803166cc41"
]

SELECT
  t0.id AS id_1,
  t0.session_hash AS session_hash_2,
  t0.statut AS statut_3,
  t0.created_at AS created_at_4,
  t0.last_activity_at AS last_activity_at_5,
  t0.closed_at AS closed_at_6,
  t0.ip AS ip_7,
  t0.user_agent AS user_agent_8,
  t0.user_id AS user_id_9,
  t0.closed_by_id AS closed_by_id_10
FROM
  user_session t0
WHERE
  t0.session_hash = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.session_hash AS session_hash_2, t0.statut AS statut_3, t0.created_at AS created_at_4, t0.last_activity_at AS last_activity_at_5, t0.closed_at AS closed_at_6, t0.ip AS ip_7, t0.user_agent AS user_agent_8, t0.user_id AS user_id_9, t0.closed_by_id AS closed_by_id_10 FROM user_session t0 WHERE t0.session_hash = '679094d6f8eb43b1d18a04222015ec9d95c2fe92518f1b6d6f4917803166cc41' LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO user_session (session_hash, statut, created_at, last_activity_at, closed_at, ip, user_agent, user_id, closed_by_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  "679094d6f8eb43b1d18a04222015ec9d95c2fe92518f1b6d6f4917803166cc41"
  "active"
  "2026-11-09 13:01:52"
  "2026-11-09 13:01:52"
  null
  "102.18.157.28"
  "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:159.0) Gecko/20100101 Firefox/159.0"
  103
  null
]

INSERT INTO user_session (
  session_hash, statut, created_at,
  last_activity_at, closed_at, ip,
  user_agent, user_id, closed_by_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO user_session (session_hash, statut, created_at, last_activity_at, closed_at, ip, user_agent, user_id, closed_by_id) VALUES ('679094d6f8eb43b1d18a04222015ec9d95c2fe92518f1b6d6f4917803166cc41', 'active', '2026-11-09 13:01:52', '2026-11-09 13:01:52', NULL, '102.18.157.28', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:159.0) Gecko/20100101 Firefox/159.0', 103, NULL);

"COMMIT"

[]

"COMMIT"

"COMMIT";