Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 47
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 6
• Migrations 5
• Debug
• Emails
• Notifications
• Elastica
• Mercure
• Configuration

Query Metrics

SELECT s0_.id AS id_0, s0_.zipcode AS zipcode_1, s0_.municipality AS municipality_2, s0_.department AS department_3, s0_.region AS region_4, s0_.indicative AS indicative_5, s0_.commercial_name AS commercial_name_6, s0_.sf_country_id AS sf_country_id_7 FROM sf_municipality s0_ WHERE LOWER(UNACCENT(s0_.zipcode)) LIKE LOWER(UNACCENT(?)) OR LOWER(UNACCENT(s0_.municipality)) LIKE LOWER(UNACCENT(?))

[
  "%"
  "%"
]

SELECT
  s0_.id AS id_0,
  s0_.zipcode AS zipcode_1,
  s0_.municipality AS municipality_2,
  s0_.department AS department_3,
  s0_.region AS region_4,
  s0_.indicative AS indicative_5,
  s0_.commercial_name AS commercial_name_6,
  s0_.sf_country_id AS sf_country_id_7
FROM
  sf_municipality s0_
WHERE
  LOWER(
    UNACCENT(s0_.zipcode)
  ) LIKE LOWER(
    UNACCENT(?)
  )
  OR LOWER(
    UNACCENT(s0_.municipality)
  ) LIKE LOWER(
    UNACCENT(?)
  )

SELECT s0_.id AS id_0, s0_.zipcode AS zipcode_1, s0_.municipality AS municipality_2, s0_.department AS department_3, s0_.region AS region_4, s0_.indicative AS indicative_5, s0_.commercial_name AS commercial_name_6, s0_.sf_country_id AS sf_country_id_7 FROM sf_municipality s0_ WHERE LOWER(UNACCENT(s0_.zipcode)) LIKE LOWER(UNACCENT('%')) OR LOWER(UNACCENT(s0_.municipality)) LIKE LOWER(UNACCENT('%'));

SELECT t0.object_id AS object_id_1, t0.field AS field_2, t0.content AS content_3, t0.locale AS locale_4, t0.id AS id_5, t0.object_id AS object_id_6, t0.language_id AS language_id_7 FROM sf_country_translation t0 WHERE t0.object_id = ?

[
  "190"
]

SELECT
  t0.object_id AS object_id_1,
  t0.field AS field_2,
  t0.content AS content_3,
  t0.locale AS locale_4,
  t0.id AS id_5,
  t0.object_id AS object_id_6,
  t0.language_id AS language_id_7
FROM
  sf_country_translation t0
WHERE
  t0.object_id = ?

SELECT t0.object_id AS object_id_1, t0.field AS field_2, t0.content AS content_3, t0.locale AS locale_4, t0.id AS id_5, t0.object_id AS object_id_6, t0.language_id AS language_id_7 FROM sf_country_translation t0 WHERE t0.object_id = '190';

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.phone_code AS phone_code_2, s0_.code AS code_3 FROM sf_country s0_ INNER JOIN sf_country_translation s1_ ON (s1_.object_id = s0_.id) WHERE UPPER(s1_.content) LIKE UPPER(?) AND s1_.locale = ?

[
  "%"
  "fr"
]

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.phone_code AS phone_code_2,
  s0_.code AS code_3
FROM
  sf_country s0_
  INNER JOIN sf_country_translation s1_ ON (s1_.object_id = s0_.id)
WHERE
  UPPER(s1_.content) LIKE UPPER(?)
  AND s1_.locale = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.phone_code AS phone_code_2, s0_.code AS code_3 FROM sf_country s0_ INNER JOIN sf_country_translation s1_ ON (s1_.object_id = s0_.id) WHERE UPPER(s1_.content) LIKE UPPER('%') AND s1_.locale = 'fr';

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.login AS login_5, t0.password AS password_6, t0.keycloak_id AS keycloak_id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.last_login AS last_login_10, t0.timezone AS timezone_11, t0.enabled AS enabled_12, t0.roles AS roles_13, t0.menu AS menu_14, t0.deleted_at AS deleted_at_15, t0.hidden AS hidden_16, t0.sf_core_language_id AS sf_core_language_id_17, t0.sf_core_user_settings_id AS sf_core_user_settings_id_18 FROM sf_core_user t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

[
  "96"
]

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.position AS position_3,
  t0.id AS id_4,
  t0.login AS login_5,
  t0.password AS password_6,
  t0.keycloak_id AS keycloak_id_7,
  t0.first_name AS first_name_8,
  t0.last_name AS last_name_9,
  t0.last_login AS last_login_10,
  t0.timezone AS timezone_11,
  t0.enabled AS enabled_12,
  t0.roles AS roles_13,
  t0.menu AS menu_14,
  t0.deleted_at AS deleted_at_15,
  t0.hidden AS hidden_16,
  t0.sf_core_language_id AS sf_core_language_id_17,
  t0.sf_core_user_settings_id AS sf_core_user_settings_id_18
FROM
  sf_core_user t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.login AS login_5, t0.password AS password_6, t0.keycloak_id AS keycloak_id_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.last_login AS last_login_10, t0.timezone AS timezone_11, t0.enabled AS enabled_12, t0.roles AS roles_13, t0.menu AS menu_14, t0.deleted_at AS deleted_at_15, t0.hidden AS hidden_16, t0.sf_core_language_id AS sf_core_language_id_17, t0.sf_core_user_settings_id AS sf_core_user_settings_id_18 FROM sf_core_user t0 WHERE t0.id = '96' AND ((t0.deleted_at IS NULL));

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.name AS name_5, t0.deleted_at AS deleted_at_6, t0.hidden AS hidden_7 FROM sf_core_notification_topic t0 INNER JOIN sf_core_user_sf_core_notification_topic ON t0.id = sf_core_user_sf_core_notification_topic.sf_core_notification_topic_id WHERE sf_core_user_sf_core_notification_topic.sf_core_user_id = ? AND ((t0.deleted_at IS NULL))

[
  "96"
]

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.position AS position_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.deleted_at AS deleted_at_6,
  t0.hidden AS hidden_7
FROM
  sf_core_notification_topic t0
  INNER JOIN sf_core_user_sf_core_notification_topic ON t0.id = sf_core_user_sf_core_notification_topic.sf_core_notification_topic_id
WHERE
  sf_core_user_sf_core_notification_topic.sf_core_user_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.name AS name_5, t0.deleted_at AS deleted_at_6, t0.hidden AS hidden_7 FROM sf_core_notification_topic t0 INNER JOIN sf_core_user_sf_core_notification_topic ON t0.id = sf_core_user_sf_core_notification_topic.sf_core_notification_topic_id WHERE sf_core_user_sf_core_notification_topic.sf_core_user_id = '96' AND ((t0.deleted_at IS NULL));

SELECT sfcp.id, sfcp.route FROM sf_core_permission sfcp WHERE sfcp.deleted_at IS NULL;

[]

SELECT
  sfcp.id,
  sfcp.route
FROM
  sf_core_permission sfcp
WHERE
  sfcp.deleted_at IS NULL;

SELECT sfcp.id, sfcp.route FROM sf_core_permission sfcp WHERE sfcp.deleted_at IS NULL;;

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.name AS name_5, t0.enabled AS enabled_6, t0.level AS level_7, t0.deleted_at AS deleted_at_8, t0.hidden AS hidden_9 FROM sf_core_role t0 INNER JOIN sf_core_user_sf_core_role ON t0.id = sf_core_user_sf_core_role.sf_core_role_id WHERE sf_core_user_sf_core_role.sf_core_user_id = ? AND ((t0.deleted_at IS NULL))

[
  "96"
]

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.position AS position_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.enabled AS enabled_6,
  t0.level AS level_7,
  t0.deleted_at AS deleted_at_8,
  t0.hidden AS hidden_9
FROM
  sf_core_role t0
  INNER JOIN sf_core_user_sf_core_role ON t0.id = sf_core_user_sf_core_role.sf_core_role_id
WHERE
  sf_core_user_sf_core_role.sf_core_user_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.name AS name_5, t0.enabled AS enabled_6, t0.level AS level_7, t0.deleted_at AS deleted_at_8, t0.hidden AS hidden_9 FROM sf_core_role t0 INNER JOIN sf_core_user_sf_core_role ON t0.id = sf_core_user_sf_core_role.sf_core_role_id WHERE sf_core_user_sf_core_role.sf_core_user_id = '96' AND ((t0.deleted_at IS NULL));

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.name AS name_5, t0.code AS code_6, t0.enabled AS enabled_7, t0.deleted_at AS deleted_at_8, t0.hidden AS hidden_9 FROM sf_core_language t0 WHERE t0.code = ? AND ((t0.deleted_at IS NULL)) LIMIT 1

[
  "fr"
]

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.position AS position_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.code AS code_6,
  t0.enabled AS enabled_7,
  t0.deleted_at AS deleted_at_8,
  t0.hidden AS hidden_9
FROM
  sf_core_language t0
WHERE
  t0.code = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.name AS name_5, t0.code AS code_6, t0.enabled AS enabled_7, t0.deleted_at AS deleted_at_8, t0.hidden AS hidden_9 FROM sf_core_language t0 WHERE t0.code = 'fr' AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.name AS name_5, t0.deleted_at AS deleted_at_6, t0.hidden AS hidden_7 FROM sf_core_notification_topic t0 INNER JOIN sf_core_role_sf_core_notification_topic ON t0.id = sf_core_role_sf_core_notification_topic.sf_core_notification_topic_id WHERE sf_core_role_sf_core_notification_topic.sf_core_role_id = ? AND ((t0.deleted_at IS NULL))

[
  "3"
]

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.position AS position_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.deleted_at AS deleted_at_6,
  t0.hidden AS hidden_7
FROM
  sf_core_notification_topic t0
  INNER JOIN sf_core_role_sf_core_notification_topic ON t0.id = sf_core_role_sf_core_notification_topic.sf_core_notification_topic_id
WHERE
  sf_core_role_sf_core_notification_topic.sf_core_role_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.position AS position_3, t0.id AS id_4, t0.name AS name_5, t0.deleted_at AS deleted_at_6, t0.hidden AS hidden_7 FROM sf_core_notification_topic t0 INNER JOIN sf_core_role_sf_core_notification_topic ON t0.id = sf_core_role_sf_core_notification_topic.sf_core_notification_topic_id WHERE sf_core_role_sf_core_notification_topic.sf_core_role_id = '3' AND ((t0.deleted_at IS NULL));