Symfony Profiler

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

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "широко"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'широко' LIMIT 1;

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

[
  b"\x01“3\x02\x00ßq:‹\x14„Âø¥Ê\x1A"
]

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0193330200DF713A8B1484C2F8A5CA1A LIMIT 1;

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  553970
  562740
  566272
  565653
  568062
  569667
  553942
  556636
  557021
  565185
  654399
  656322
  659487
  552946
  562768
  565572
  572334
  582269
  586713
  590587
  598026
  598657
  599359
  590628
  590993
  594400
  597282
  599044
  607329
  636268
  643252
  598870
  599478
  605952
  619783
  620216
  620263
  620546
  598475
  599545
  618743
  608048
  621269
  636231
  416635
  441404
  460212
  480800
  462415
  457159
  480326
  524208
  489604
  512885
  513381
  509100
  513965
  535062
  488410
  491955
  521681
  550442
  571388
  603592
  627700
  591139
  614603
  613220
  625991
  617421
  507177
  510668
  526104
  494081
  569955
  632059
  468666
  521159
  447835
]

SELECT
  p.post_id,
  p.user_id,
  p.content_id,
  p.public_key,
  p.search_field,
  p.cover,
  p.type,
  p.sexual_orientation,
  p.orientation,
  p.quality,
  p.noindex,
  p.nofollow,
  p.contents_num,
  p.duration,
  p.likes,
  p.dislikes,
  p.views,
  p.vote_rating,
  p.params,
  p.published_at,
  IFNULL(`r`.`title`, `f`.`title`) as `title`,
  IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`,
  IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2`
FROM
  post p
  LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`
  AND `f`.`lang_id` = ?
  LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`
  AND `r`.`lang_id` = ?
WHERE
  p.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (553970, 562740, 566272, 565653, 568062, 569667, 553942, 556636, 557021, 565185, 654399, 656322, 659487, 552946, 562768, 565572, 572334, 582269, 586713, 590587, 598026, 598657, 599359, 590628, 590993, 594400, 597282, 599044, 607329, 636268, 643252, 598870, 599478, 605952, 619783, 620216, 620263, 620546, 598475, 599545, 618743, 608048, 621269, 636231, 416635, 441404, 460212, 480800, 462415, 457159, 480326, 524208, 489604, 512885, 513381, 509100, 513965, 535062, 488410, 491955, 521681, 550442, 571388, 603592, 627700, 591139, 614603, 613220, 625991, 617421, 507177, 510668, 526104, 494081, 569955, 632059, 468666, 521159, 447835);

SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  416635
  441404
  447835
  457159
  460212
  462415
  468666
  480326
  480800
  488410
  489604
  491955
  494081
  507177
  509100
  510668
  512885
  513381
  513965
  521159
  521681
  524208
  526104
  535062
  550442
  552946
  553942
  553970
  556636
  557021
  562740
  562768
  565185
  565572
  565653
  566272
  568062
  569667
  569955
  571388
  572334
  582269
  586713
  590587
  590628
  590993
  591139
  594400
  597282
  598026
  598475
  598657
  598870
  599044
  599359
  599478
  599545
  603592
  605952
  607329
  608048
  613220
  614603
  617421
  618743
  619783
  620216
  620263
  620546
  621269
  625991
  627700
  632059
  636231
  636268
  643252
  654399
  656322
  659487
]

SELECT
  pht.post_id,
  pht.tag_id,
  t.slug,
  IFNULL(`r`.`name`, `f`.`name`) as `name`
FROM
  post_has_tag pht
  INNER JOIN tag t ON pht.tag_id = t.tag_id
  AND t.enabled = 1
  LEFT JOIN tag_translation f ON t.tag_id = f.tag_id
  AND f.lang_id = ?
  LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id`
  AND `r`.`lang_id` = ?
WHERE
  pht.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (416635, 441404, 447835, 457159, 460212, 462415, 468666, 480326, 480800, 488410, 489604, 491955, 494081, 507177, 509100, 510668, 512885, 513381, 513965, 521159, 521681, 524208, 526104, 535062, 550442, 552946, 553942, 553970, 556636, 557021, 562740, 562768, 565185, 565572, 565653, 566272, 568062, 569667, 569955, 571388, 572334, 582269, 586713, 590587, 590628, 590993, 591139, 594400, 597282, 598026, 598475, 598657, 598870, 599044, 599359, 599478, 599545, 603592, 605952, 607329, 608048, 613220, 614603, 617421, 618743, 619783, 620216, 620263, 620546, 621269, 625991, 627700, 632059, 636231, 636268, 643252, 654399, 656322, 659487);

SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  416635
  441404
  447835
  457159
  460212
  462415
  468666
  480326
  480800
  488410
  489604
  491955
  494081
  507177
  509100
  510668
  512885
  513381
  513965
  521159
  521681
  524208
  526104
  535062
  550442
  552946
  553942
  553970
  556636
  557021
  562740
  562768
  565185
  565572
  565653
  566272
  568062
  569667
  569955
  571388
  572334
  582269
  586713
  590587
  590628
  590993
  591139
  594400
  597282
  598026
  598475
  598657
  598870
  599044
  599359
  599478
  599545
  603592
  605952
  607329
  608048
  613220
  614603
  617421
  618743
  619783
  620216
  620263
  620546
  621269
  625991
  627700
  632059
  636231
  636268
  643252
  654399
  656322
  659487
]

SELECT
  phc.post_id,
  phc.category_id,
  c.slug,
  IFNULL(`r`.`name`, `f`.`name`) as `name`
FROM
  post_has_category phc
  INNER JOIN category c ON phc.category_id = c.category_id
  AND c.enabled = 1
  LEFT JOIN category_translation f ON c.category_id = f.category_id
  AND f.lang_id = ?
  LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`
  AND `r`.`lang_id` = ?
WHERE
  phc.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (416635, 441404, 447835, 457159, 460212, 462415, 468666, 480326, 480800, 488410, 489604, 491955, 494081, 507177, 509100, 510668, 512885, 513381, 513965, 521159, 521681, 524208, 526104, 535062, 550442, 552946, 553942, 553970, 556636, 557021, 562740, 562768, 565185, 565572, 565653, 566272, 568062, 569667, 569955, 571388, 572334, 582269, 586713, 590587, 590628, 590993, 591139, 594400, 597282, 598026, 598475, 598657, 598870, 599044, 599359, 599478, 599545, 603592, 605952, 607329, 608048, 613220, 614603, 617421, 618743, 619783, 620216, 620263, 620546, 621269, 625991, 627700, 632059, 636231, 636268, 643252, 654399, 656322, 659487);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "широк"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'широк';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "широк"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'широк';