Symfony Profiler

• Request / Response
• Performance
• Exception
• Logs 17
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Doctrine
• Debug
• Serializer
• Configuration

Query Metrics

Queries

Group similar statements

SELECT t0.id AS id_1, t0.login AS login_2, t0.date_suspended AS date_suspended_3, t0.password AS password_4, t0.has_access AS has_access_5 FROM permission t0 WHERE t0.id = ?

[
  27226
]

SELECT
  t0.id AS id_1,
  t0.login AS login_2,
  t0.date_suspended AS date_suspended_3,
  t0.password AS password_4,
  t0.has_access AS has_access_5
FROM
  permission t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.login AS login_2, t0.date_suspended AS date_suspended_3, t0.password AS password_4, t0.has_access AS has_access_5 FROM permission t0 WHERE t0.id = 27226;

SELECT t0.id AS id_1, t0.login AS login_2, t0.date_suspended AS date_suspended_3, t0.password AS password_4, t0.has_access AS has_access_5 FROM permission t0 WHERE t0.login = ? LIMIT 1

[
  "jcaron-capca@netisse.fr"
]

SELECT
  t0.id AS id_1,
  t0.login AS login_2,
  t0.date_suspended AS date_suspended_3,
  t0.password AS password_4,
  t0.has_access AS has_access_5
FROM
  permission t0
WHERE
  t0.login = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.login AS login_2, t0.date_suspended AS date_suspended_3, t0.password AS password_4, t0.has_access AS has_access_5 FROM permission t0 WHERE t0.login = 'jcaron-capca@netisse.fr' LIMIT 1;

SELECT t0.id AS id_1, t0.group_name AS group_name_2, t0.group_level_id AS group_level_id_3, t0.group_level_name AS group_level_name_4, t0.group_type_name AS group_type_name_5, t0.group_ancestor_id AS group_ancestor_id_6 FROM group_ancestor_details t0 WHERE t0.group_type_name = ? ORDER BY t0.group_level_id ASC

[
  "Localisation"
]

SELECT
  t0.id AS id_1,
  t0.group_name AS group_name_2,
  t0.group_level_id AS group_level_id_3,
  t0.group_level_name AS group_level_name_4,
  t0.group_type_name AS group_type_name_5,
  t0.group_ancestor_id AS group_ancestor_id_6
FROM
  group_ancestor_details t0
WHERE
  t0.group_type_name = ?
ORDER BY
  t0.group_level_id ASC

SELECT t0.id AS id_1, t0.group_name AS group_name_2, t0.group_level_id AS group_level_id_3, t0.group_level_name AS group_level_name_4, t0.group_type_name AS group_type_name_5, t0.group_ancestor_id AS group_ancestor_id_6 FROM group_ancestor_details t0 WHERE t0.group_type_name = 'Localisation' ORDER BY t0.group_level_id ASC;

SELECT t0.id AS id_1, t0.group_name AS group_name_2, t0.group_level_id AS group_level_id_3, t0.group_level_name AS group_level_name_4, t0.group_type_name AS group_type_name_5, t0.group_ancestor_id AS group_ancestor_id_6 FROM group_ancestor_details t0 WHERE t0.group_type_name = ? ORDER BY t0.group_level_id ASC

[
  "Type"
]

SELECT
  t0.id AS id_1,
  t0.group_name AS group_name_2,
  t0.group_level_id AS group_level_id_3,
  t0.group_level_name AS group_level_name_4,
  t0.group_type_name AS group_type_name_5,
  t0.group_ancestor_id AS group_ancestor_id_6
FROM
  group_ancestor_details t0
WHERE
  t0.group_type_name = ?
ORDER BY
  t0.group_level_id ASC

SELECT t0.id AS id_1, t0.group_name AS group_name_2, t0.group_level_id AS group_level_id_3, t0.group_level_name AS group_level_name_4, t0.group_type_name AS group_type_name_5, t0.group_ancestor_id AS group_ancestor_id_6 FROM group_ancestor_details t0 WHERE t0.group_type_name = 'Type' ORDER BY t0.group_level_id ASC;

SELECT s.id,t.value FROM `status` s left join translator t on s.id = t.path_id where t.path = 'status.label' and lang = 'fr-FR'

[]

SELECT
  s.id,
  t.value
FROM
  `status` s
  left join translator t on s.id = t.path_id
where
  t.path = 'status.label'
  and lang = 'fr-FR'

SELECT s.id,t.value FROM `status` s left join translator t on s.id = t.path_id where t.path = 'status.label' and lang = 'fr-FR';

SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.last_name AS last_name_2, u0_.create_date AS create_date_3, u0_.delete_date AS delete_date_4, u0_.email AS email_5, u0_.group_ancestor_id AS group_ancestor_id_6 FROM `user` u0_ GROUP BY u0_.id

[]

SELECT
  u0_.id AS id_0,
  u0_.first_name AS first_name_1,
  u0_.last_name AS last_name_2,
  u0_.create_date AS create_date_3,
  u0_.delete_date AS delete_date_4,
  u0_.email AS email_5,
  u0_.group_ancestor_id AS group_ancestor_id_6
FROM
  `user` u0_
GROUP BY
  u0_.id

SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.last_name AS last_name_2, u0_.create_date AS create_date_3, u0_.delete_date AS delete_date_4, u0_.email AS email_5, u0_.group_ancestor_id AS group_ancestor_id_6 FROM `user` u0_ GROUP BY u0_.id;

SELECT t0.id AS id_1, t0.tenant_name AS tenant_name_2, t0.tenant_id AS tenant_id_3, t0.last_cron AS last_cron_4, t0.open AS open_5, t0.close AS close_6, t0.logo AS logo_7 FROM general t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.tenant_name AS tenant_name_2,
  t0.tenant_id AS tenant_id_3,
  t0.last_cron AS last_cron_4,
  t0.open AS open_5,
  t0.close AS close_6,
  t0.logo AS logo_7
FROM
  general t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.tenant_name AS tenant_name_2, t0.tenant_id AS tenant_id_3, t0.last_cron AS last_cron_4, t0.open AS open_5, t0.close AS close_6, t0.logo AS logo_7 FROM general t0 WHERE t0.id = 1;

SELECT DISTINCT id as id, name FROM `resource`

[]

SELECT
  DISTINCT id as id,
  name
FROM
  `resource`

SELECT DISTINCT id as id, name FROM `resource` ;

Database Connections

Entity Managers

Second Level Cache

Entities Mapping