Symfony Profiler

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

Query Metrics

SELECT u0_.id AS id_0, u0_.ordinary_number AS ordinary_number_1, u0_.civility AS civility_2, u0_.surname AS surname_3, u0_.name AS name_4, u0_.year_of_birth AS year_of_birth_5, u0_.nationality AS nationality_6, u0_.email AS email_7, u0_.password AS password_8, u0_.status AS status_9, u0_.telephone AS telephone_10, u0_.telephone2 AS telephone2_11, u0_.fax AS fax_12, u0_.position AS position_13, u0_.organism AS organism_14, u0_.year_of_alternance AS year_of_alternance_15, u0_.current_speciality AS current_speciality_16, u0_.comment AS comment_17, u0_.create_at AS create_at_18, u0_.user_comment AS user_comment_19, u0_.cv AS cv_20, u0_.diplom AS diplom_21, u0_.licence AS licence_22, u0_.address_id AS address_id_23, u0_.speciality_id AS speciality_id_24, u0_.establishment_id AS establishment_id_25, u0_.subscription_id AS subscription_id_26 FROM user u0_ INNER JOIN speciality s1_ ON u0_.speciality_id = s1_.id INNER JOIN user_user_role u3_ ON u0_.id = u3_.user_id INNER JOIN user_role u2_ ON u2_.id = u3_.user_role_id AND (u2_.id = ?) WHERE u0_.status = ? ORDER BY u0_.create_at DESC LIMIT 7

[
  4
  1
]

SELECT
  u0_.id AS id_0,
  u0_.ordinary_number AS ordinary_number_1,
  u0_.civility AS civility_2,
  u0_.surname AS surname_3,
  u0_.name AS name_4,
  u0_.year_of_birth AS year_of_birth_5,
  u0_.nationality AS nationality_6,
  u0_.email AS email_7,
  u0_.password AS password_8,
  u0_.status AS status_9,
  u0_.telephone AS telephone_10,
  u0_.telephone2 AS telephone2_11,
  u0_.fax AS fax_12,
  u0_.position AS position_13,
  u0_.organism AS organism_14,
  u0_.year_of_alternance AS year_of_alternance_15,
  u0_.current_speciality AS current_speciality_16,
  u0_.comment AS comment_17,
  u0_.create_at AS create_at_18,
  u0_.user_comment AS user_comment_19,
  u0_.cv AS cv_20,
  u0_.diplom AS diplom_21,
  u0_.licence AS licence_22,
  u0_.address_id AS address_id_23,
  u0_.speciality_id AS speciality_id_24,
  u0_.establishment_id AS establishment_id_25,
  u0_.subscription_id AS subscription_id_26
FROM
  user u0_
  INNER JOIN speciality s1_ ON u0_.speciality_id = s1_.id
  INNER JOIN user_user_role u3_ ON u0_.id = u3_.user_id
  INNER JOIN user_role u2_ ON u2_.id = u3_.user_role_id
  AND (u2_.id = ?)
WHERE
  u0_.status = ?
ORDER BY
  u0_.create_at DESC
LIMIT
  7

SELECT u0_.id AS id_0, u0_.ordinary_number AS ordinary_number_1, u0_.civility AS civility_2, u0_.surname AS surname_3, u0_.name AS name_4, u0_.year_of_birth AS year_of_birth_5, u0_.nationality AS nationality_6, u0_.email AS email_7, u0_.password AS password_8, u0_.status AS status_9, u0_.telephone AS telephone_10, u0_.telephone2 AS telephone2_11, u0_.fax AS fax_12, u0_.position AS position_13, u0_.organism AS organism_14, u0_.year_of_alternance AS year_of_alternance_15, u0_.current_speciality AS current_speciality_16, u0_.comment AS comment_17, u0_.create_at AS create_at_18, u0_.user_comment AS user_comment_19, u0_.cv AS cv_20, u0_.diplom AS diplom_21, u0_.licence AS licence_22, u0_.address_id AS address_id_23, u0_.speciality_id AS speciality_id_24, u0_.establishment_id AS establishment_id_25, u0_.subscription_id AS subscription_id_26 FROM user u0_ INNER JOIN speciality s1_ ON u0_.speciality_id = s1_.id INNER JOIN user_user_role u3_ ON u0_.id = u3_.user_id INNER JOIN user_role u2_ ON u2_.id = u3_.user_role_id AND (u2_.id = 4) WHERE u0_.status = 1 ORDER BY u0_.create_at DESC LIMIT 7;

SELECT t0.id AS id_1, t0.name AS name_2, t0.speciality_parent_id AS speciality_parent_id_3 FROM speciality t0 WHERE t0.id = ?

[
  280
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.speciality_parent_id AS speciality_parent_id_3
FROM
  speciality t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.speciality_parent_id AS speciality_parent_id_3 FROM speciality t0 WHERE t0.id = 280;