Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 19
• Events
• Routing
• Cache
• Translation 34
• Security
• Twig
• Twig Components
• Doctrine 2
• Debug
• Emails
• EasyAdmin
• Configuration

Query Metrics

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 = ?

[
  62122
]

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 = 62122;

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\ContestController"
]

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\\ContestController' 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.title AS title_2, t0.annotation AS annotation_3, t0.text AS text_4, t0.date_begin AS date_begin_5, t0.date_end AS date_end_6, t0.dateresult AS dateresult_7, t0.is_published AS is_published_8, t0.is_admin AS is_admin_9, t0.slug AS slug_10, t0.mainphoto AS mainphoto_11, t0.viewed AS viewed_12, t0.rating AS rating_13, t0.is_anonymous AS is_anonymous_14, t0.is_show AS is_show_15, t0.file_type AS file_type_16 FROM contest t0 WHERE t0.slug = ? AND t0.is_published = ? LIMIT 1

[
  "99-konkurs-sk"
  1
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.annotation AS annotation_3,
  t0.text AS text_4,
  t0.date_begin AS date_begin_5,
  t0.date_end AS date_end_6,
  t0.dateresult AS dateresult_7,
  t0.is_published AS is_published_8,
  t0.is_admin AS is_admin_9,
  t0.slug AS slug_10,
  t0.mainphoto AS mainphoto_11,
  t0.viewed AS viewed_12,
  t0.rating AS rating_13,
  t0.is_anonymous AS is_anonymous_14,
  t0.is_show AS is_show_15,
  t0.file_type AS file_type_16
FROM
  contest t0
WHERE
  t0.slug = ?
  AND t0.is_published = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.annotation AS annotation_3, t0.text AS text_4, t0.date_begin AS date_begin_5, t0.date_end AS date_end_6, t0.dateresult AS dateresult_7, t0.is_published AS is_published_8, t0.is_admin AS is_admin_9, t0.slug AS slug_10, t0.mainphoto AS mainphoto_11, t0.viewed AS viewed_12, t0.rating AS rating_13, t0.is_anonymous AS is_anonymous_14, t0.is_show AS is_show_15, t0.file_type AS file_type_16 FROM contest t0 WHERE t0.slug = '99-konkurs-sk' AND t0.is_published = 1 LIMIT 1;

SELECT t0.id AS id_1, t0.place AS place_2, t0.contest_id AS contest_id_3, t0.work_id AS work_id_4, t0.user_id AS user_id_5 FROM contest_result t0 WHERE t0.contest_id = ? AND t0.place = ?

[
  99
  1
]

SELECT
  t0.id AS id_1,
  t0.place AS place_2,
  t0.contest_id AS contest_id_3,
  t0.work_id AS work_id_4,
  t0.user_id AS user_id_5
FROM
  contest_result t0
WHERE
  t0.contest_id = ?
  AND t0.place = ?

SELECT t0.id AS id_1, t0.place AS place_2, t0.contest_id AS contest_id_3, t0.work_id AS work_id_4, t0.user_id AS user_id_5 FROM contest_result t0 WHERE t0.contest_id = 99 AND t0.place = 1;

SELECT count(c0_.id) AS sclr_0 FROM contest_member c0_ WHERE c0_.status = 1 AND c0_.contest_id = 99

[]

SELECT
  count(c0_.id) AS sclr_0
FROM
  contest_member c0_
WHERE
  c0_.status = 1
  AND c0_.contest_id = 99

SELECT count(c0_.id) AS sclr_0 FROM contest_member c0_ WHERE c0_.status = 1 AND c0_.contest_id = 99;

SELECT t0.id AS id_1, t0.contest_id AS contest_id_2, t0.user_id AS user_id_3 FROM contest_member_user t0 WHERE t0.contest_id = ?

[
  99
]

SELECT
  t0.id AS id_1,
  t0.contest_id AS contest_id_2,
  t0.user_id AS user_id_3
FROM
  contest_member_user t0
WHERE
  t0.contest_id = ?

SELECT t0.id AS id_1, t0.contest_id AS contest_id_2, t0.user_id AS user_id_3 FROM contest_member_user t0 WHERE t0.contest_id = 99;

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;