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

[
  "порка девушек 18"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'порка девушек 18' 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
  599355
  796740
  742856
  627611
  796754
  543738
  796785
  544911
  546197
  796764
  796786
  511330
  796772
  796745
  543744
  559666
  546178
  805183
  796773
  543657
  768254
  568683
  796769
  634806
  535733
  546217
  763922
  569436
  627666
  479293
  561718
  773241
  595459
  570188
  560626
  510379
  511430
  569787
  519273
  698784
  462115
  549538
  569740
  459685
  560584
  566277
  511288
  479742
  592023
  598078
  523684
  527620
  720882
  473138
  471062
  516970
  598609
  481162
  479191
  520198
  522949
  520729
  565138
  600056
  601917
  594838
  577450
  621269
  514809
  576310
  599532
  489237
]

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 (599355, 796740, 742856, 627611, 796754, 543738, 796785, 544911, 546197, 796764, 796786, 511330, 796772, 796745, 543744, 559666, 546178, 805183, 796773, 543657, 768254, 568683, 796769, 634806, 535733, 546217, 763922, 569436, 627666, 479293, 561718, 773241, 595459, 570188, 560626, 510379, 511430, 569787, 519273, 698784, 462115, 549538, 569740, 459685, 560584, 566277, 511288, 479742, 592023, 598078, 523684, 527620, 720882, 473138, 471062, 516970, 598609, 481162, 479191, 520198, 522949, 520729, 565138, 600056, 601917, 594838, 577450, 621269, 514809, 576310, 599532, 489237);

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
  459685
  462115
  471062
  473138
  479191
  479293
  479742
  481162
  489237
  510379
  511288
  511330
  511430
  514809
  516970
  519273
  520198
  520729
  522949
  523684
  527620
  535733
  543657
  543738
  543744
  544911
  546178
  546197
  546217
  549538
  559666
  560584
  560626
  561718
  565138
  566277
  568683
  569436
  569740
  569787
  570188
  576310
  577450
  592023
  594838
  595459
  598078
  598609
  599355
  599532
  600056
  601917
  621269
  627611
  627666
  634806
  698784
  720882
  742856
  763922
  773241
  796740
  796745
  796754
  796764
  796769
  796772
  796773
  796785
  796786
  805183
]

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 (459685, 462115, 471062, 473138, 479191, 479293, 479742, 481162, 489237, 510379, 511288, 511330, 511430, 514809, 516970, 519273, 520198, 520729, 522949, 523684, 527620, 535733, 543657, 543738, 543744, 544911, 546178, 546197, 546217, 549538, 559666, 560584, 560626, 561718, 565138, 566277, 568683, 569436, 569740, 569787, 570188, 576310, 577450, 592023, 594838, 595459, 598078, 598609, 599355, 599532, 600056, 601917, 621269, 627611, 627666, 634806, 698784, 720882, 742856, 763922, 773241, 796740, 796745, 796754, 796764, 796769, 796772, 796773, 796785, 796786, 805183);

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
  459685
  462115
  471062
  473138
  479191
  479293
  479742
  481162
  489237
  510379
  511288
  511330
  511430
  514809
  516970
  519273
  520198
  520729
  522949
  523684
  527620
  535733
  543657
  543738
  543744
  544911
  546178
  546197
  546217
  549538
  559666
  560584
  560626
  561718
  565138
  566277
  568683
  569436
  569740
  569787
  570188
  576310
  577450
  592023
  594838
  595459
  598078
  598609
  599355
  599532
  600056
  601917
  621269
  627611
  627666
  634806
  698784
  720882
  742856
  763922
  773241
  796740
  796745
  796754
  796764
  796769
  796772
  796773
  796785
  796786
  805183
]

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 (459685, 462115, 471062, 473138, 479191, 479293, 479742, 481162, 489237, 510379, 511288, 511330, 511430, 514809, 516970, 519273, 520198, 520729, 522949, 523684, 527620, 535733, 543657, 543738, 543744, 544911, 546178, 546197, 546217, 549538, 559666, 560584, 560626, 561718, 565138, 566277, 568683, 569436, 569740, 569787, 570188, 576310, 577450, 592023, 594838, 595459, 598078, 598609, 599355, 599532, 600056, 601917, 621269, 627611, 627666, 634806, 698784, 720882, 742856, 763922, 773241, 796740, 796745, 796754, 796764, 796769, 796772, 796773, 796785, 796786, 805183);

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

[
  "порк девушк 18"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'порк девушк 18';

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

[
  "порк девушк 18"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'порк девушк 18';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "порка девушек 18"
  "порка девушек 18"
  "порка девушек 18"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('порка девушек 18') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('порка девушек 18')
              AND `query` <> 'порка девушек 18'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;