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 COUNT(DISTINCT u.id) AS total FROM user u INNER JOIN user_user_role r ON u.id = r.user_id AND r.user_role_id = ? WHERE u.status = 1

[
  4
]

SELECT
  COUNT(DISTINCT u.id) AS total
FROM
  user u
  INNER JOIN user_user_role r ON u.id = r.user_id
  AND r.user_role_id = ?
WHERE
  u.status = 1

SELECT COUNT(DISTINCT u.id) AS total FROM user u INNER JOIN user_user_role r ON u.id = r.user_id AND r.user_role_id = 4 WHERE u.status = 1;

SELECT t0.id AS id_1, t0.name AS name_2 FROM region t0

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  region t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM region t0;

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

[]

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

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

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.logo AS logo_2 FROM partenaire_logo p0_ ORDER BY p0_.id DESC

[]

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.logo AS logo_2
FROM
  partenaire_logo p0_
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.logo AS logo_2 FROM partenaire_logo p0_ ORDER BY p0_.id DESC;

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;