Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 23
• Events
• Routing
• Cache
• Translation 35
• Security
• Twig
• Twig Components
• Doctrine 1
• Debug
• Emails
• EasyAdmin
• Configuration

Query Metrics

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.username_canonical AS username_canonical_2, u0_.email AS email_3, u0_.email_canonical AS email_canonical_4, u0_.roles AS roles_5, u0_.password AS password_6, u0_.enabled AS enabled_7, u0_.locked AS locked_8, u0_.created AS created_9, u0_.rating AS rating_10, u0_.avatar AS avatar_11, u0_.game_count AS game_count_12, u0_.game_victory AS game_victory_13, u0_.firstname AS firstname_14, u0_.blogname AS blogname_15, u0_.surname AS surname_16, u0_.birthday AS birthday_17, u0_.gender AS gender_18, u0_.notification AS notification_19, u0_.school AS school_20, u0_.class AS class_21, u0_.city AS city_22, u0_.confirmation_token AS confirmation_token_23, u0_.password_requested_at AS password_requested_at_24, u0_.x1 AS x1_25, u0_.x2 AS x2_26, u0_.y1 AS y1_27, u0_.y2 AS y2_28, u0_.card_in_last_game AS card_in_last_game_29, u0_.district_id AS district_id_30, u0_.game_id AS game_id_31 FROM user u0_ ORDER BY u0_.rating DESC LIMIT 20 OFFSET 820

[]

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.username_canonical AS username_canonical_2,
  u0_.email AS email_3,
  u0_.email_canonical AS email_canonical_4,
  u0_.roles AS roles_5,
  u0_.password AS password_6,
  u0_.enabled AS enabled_7,
  u0_.locked AS locked_8,
  u0_.created AS created_9,
  u0_.rating AS rating_10,
  u0_.avatar AS avatar_11,
  u0_.game_count AS game_count_12,
  u0_.game_victory AS game_victory_13,
  u0_.firstname AS firstname_14,
  u0_.blogname AS blogname_15,
  u0_.surname AS surname_16,
  u0_.birthday AS birthday_17,
  u0_.gender AS gender_18,
  u0_.notification AS notification_19,
  u0_.school AS school_20,
  u0_.class AS class_21,
  u0_.city AS city_22,
  u0_.confirmation_token AS confirmation_token_23,
  u0_.password_requested_at AS password_requested_at_24,
  u0_.x1 AS x1_25,
  u0_.x2 AS x2_26,
  u0_.y1 AS y1_27,
  u0_.y2 AS y2_28,
  u0_.card_in_last_game AS card_in_last_game_29,
  u0_.district_id AS district_id_30,
  u0_.game_id AS game_id_31
FROM
  user u0_
ORDER BY
  u0_.rating DESC
LIMIT
  20
OFFSET
  820

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.username_canonical AS username_canonical_2, u0_.email AS email_3, u0_.email_canonical AS email_canonical_4, u0_.roles AS roles_5, u0_.password AS password_6, u0_.enabled AS enabled_7, u0_.locked AS locked_8, u0_.created AS created_9, u0_.rating AS rating_10, u0_.avatar AS avatar_11, u0_.game_count AS game_count_12, u0_.game_victory AS game_victory_13, u0_.firstname AS firstname_14, u0_.blogname AS blogname_15, u0_.surname AS surname_16, u0_.birthday AS birthday_17, u0_.gender AS gender_18, u0_.notification AS notification_19, u0_.school AS school_20, u0_.class AS class_21, u0_.city AS city_22, u0_.confirmation_token AS confirmation_token_23, u0_.password_requested_at AS password_requested_at_24, u0_.x1 AS x1_25, u0_.x2 AS x2_26, u0_.y1 AS y1_27, u0_.y2 AS y2_28, u0_.card_in_last_game AS card_in_last_game_29, u0_.district_id AS district_id_30, u0_.game_id AS game_id_31 FROM user u0_ ORDER BY u0_.rating DESC LIMIT 20 OFFSET 820;

SELECT count(u0_.id) AS sclr_0 FROM user u0_

[]

SELECT
  count(u0_.id) AS sclr_0
FROM
  user u0_

SELECT count(u0_.id) AS sclr_0 FROM user u0_;

SELECT t0.id AS id_1, t0.controller_name AS controller_name_2, t0.title AS title_3 FROM controllers t0 WHERE t0.controller_name = ? LIMIT 1

[
  "App\BlogBundle\Controller\UserController"
]

SELECT
  t0.id AS id_1,
  t0.controller_name AS controller_name_2,
  t0.title AS title_3
FROM
  controllers t0
WHERE
  t0.controller_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.controller_name AS controller_name_2, t0.title AS title_3 FROM controllers t0 WHERE t0.controller_name = 'App\\BlogBundle\\Controller\\UserController' LIMIT 1;

SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = ? LIMIT 1

[
  "pre-header"
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  templates t0
WHERE
  t0.title = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2 FROM templates t0 WHERE t0.title = 'pre-header' LIMIT 1;

SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.email_canonical AS email_canonical_5, t0.roles AS roles_6, t0.password AS password_7, t0.enabled AS enabled_8, t0.locked AS locked_9, t0.created AS created_10, t0.rating AS rating_11, t0.avatar AS avatar_12, t0.game_count AS game_count_13, t0.game_victory AS game_victory_14, t0.firstname AS firstname_15, t0.blogname AS blogname_16, t0.surname AS surname_17, t0.birthday AS birthday_18, t0.gender AS gender_19, t0.notification AS notification_20, t0.school AS school_21, t0.class AS class_22, t0.city AS city_23, t0.confirmation_token AS confirmation_token_24, t0.password_requested_at AS password_requested_at_25, t0.x1 AS x1_26, t0.x2 AS x2_27, t0.y1 AS y1_28, t0.y2 AS y2_29, t0.card_in_last_game AS card_in_last_game_30, t0.district_id AS district_id_31, t0.game_id AS game_id_32 FROM user t0 WHERE t0.id = ?

[
  69084
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.username_canonical AS username_canonical_3,
  t0.email AS email_4,
  t0.email_canonical AS email_canonical_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.enabled AS enabled_8,
  t0.locked AS locked_9,
  t0.created AS created_10,
  t0.rating AS rating_11,
  t0.avatar AS avatar_12,
  t0.game_count AS game_count_13,
  t0.game_victory AS game_victory_14,
  t0.firstname AS firstname_15,
  t0.blogname AS blogname_16,
  t0.surname AS surname_17,
  t0.birthday AS birthday_18,
  t0.gender AS gender_19,
  t0.notification AS notification_20,
  t0.school AS school_21,
  t0.class AS class_22,
  t0.city AS city_23,
  t0.confirmation_token AS confirmation_token_24,
  t0.password_requested_at AS password_requested_at_25,
  t0.x1 AS x1_26,
  t0.x2 AS x2_27,
  t0.y1 AS y1_28,
  t0.y2 AS y2_29,
  t0.card_in_last_game AS card_in_last_game_30,
  t0.district_id AS district_id_31,
  t0.game_id AS game_id_32
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.email_canonical AS email_canonical_5, t0.roles AS roles_6, t0.password AS password_7, t0.enabled AS enabled_8, t0.locked AS locked_9, t0.created AS created_10, t0.rating AS rating_11, t0.avatar AS avatar_12, t0.game_count AS game_count_13, t0.game_victory AS game_victory_14, t0.firstname AS firstname_15, t0.blogname AS blogname_16, t0.surname AS surname_17, t0.birthday AS birthday_18, t0.gender AS gender_19, t0.notification AS notification_20, t0.school AS school_21, t0.class AS class_22, t0.city AS city_23, t0.confirmation_token AS confirmation_token_24, t0.password_requested_at AS password_requested_at_25, t0.x1 AS x1_26, t0.x2 AS x2_27, t0.y1 AS y1_28, t0.y2 AS y2_29, t0.card_in_last_game AS card_in_last_game_30, t0.district_id AS district_id_31, t0.game_id AS game_id_32 FROM user t0 WHERE t0.id = 69084;

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.added AS added_2, l0_.user_id AS user_id_3 FROM lenta l0_ ORDER BY l0_.id DESC LIMIT 20

[]

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.added AS added_2,
  l0_.user_id AS user_id_3
FROM
  lenta l0_
ORDER BY
  l0_.id DESC
LIMIT
  20

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.added AS added_2, l0_.user_id AS user_id_3 FROM lenta l0_ ORDER BY l0_.id DESC LIMIT 20;

SELECT o0_.id AS id_0, o0_.type AS type_1, o0_.title AS title_2, o0_.text AS text_3, o0_.picture AS picture_4, o0_.material AS material_5, o0_.url AS url_6, o0_.rating AS rating_7, o0_.added AS added_8, o0_.user_id AS user_id_9 FROM occasion o0_ WHERE o0_.type <> 'post' ORDER BY o0_.id DESC LIMIT 7

[]

SELECT
  o0_.id AS id_0,
  o0_.type AS type_1,
  o0_.title AS title_2,
  o0_.text AS text_3,
  o0_.picture AS picture_4,
  o0_.material AS material_5,
  o0_.url AS url_6,
  o0_.rating AS rating_7,
  o0_.added AS added_8,
  o0_.user_id AS user_id_9
FROM
  occasion o0_
WHERE
  o0_.type <> 'post'
ORDER BY
  o0_.id DESC
LIMIT
  7

SELECT o0_.id AS id_0, o0_.type AS type_1, o0_.title AS title_2, o0_.text AS text_3, o0_.picture AS picture_4, o0_.material AS material_5, o0_.url AS url_6, o0_.rating AS rating_7, o0_.added AS added_8, o0_.user_id AS user_id_9 FROM occasion o0_ WHERE o0_.type <> 'post' ORDER BY o0_.id DESC LIMIT 7;