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 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
  525154
  539417
  488596
  578500
  662435
  664659
  568792
  605953
  588992
  424530
  567139
  543874
  685469
  608073
  559119
  577720
  571016
  654374
  616905
  599456
  619651
  610613
  536802
  526107
  488398
  604743
  615214
  591954
  585101
  543387
  584419
  543198
  606687
  622938
  605111
  618155
  642686
  598770
  609591
  478651
  527990
  589068
  520496
  504693
  514782
  589041
  591438
  476147
  524915
  575698
  650224
  470467
  675321
  601125
  619007
  622375
  584708
  626042
  591065
  622805
  507177
  526633
  545643
  654422
  636174
  520697
  643316
  527908
  533707
  557235
  548870
  589148
  591739
  415160
  528011
  603810
  614479
  512554
  564456
  622668
  649185
  486904
  499112
]

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 (525154, 539417, 488596, 578500, 662435, 664659, 568792, 605953, 588992, 424530, 567139, 543874, 685469, 608073, 559119, 577720, 571016, 654374, 616905, 599456, 619651, 610613, 536802, 526107, 488398, 604743, 615214, 591954, 585101, 543387, 584419, 543198, 606687, 622938, 605111, 618155, 642686, 598770, 609591, 478651, 527990, 589068, 520496, 504693, 514782, 589041, 591438, 476147, 524915, 575698, 650224, 470467, 675321, 601125, 619007, 622375, 584708, 626042, 591065, 622805, 507177, 526633, 545643, 654422, 636174, 520697, 643316, 527908, 533707, 557235, 548870, 589148, 591739, 415160, 528011, 603810, 614479, 512554, 564456, 622668, 649185, 486904, 499112);

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
  415160
  424530
  470467
  476147
  478651
  486904
  488398
  488596
  499112
  504693
  507177
  512554
  514782
  520496
  520697
  524915
  525154
  526107
  526633
  527908
  527990
  528011
  533707
  536802
  539417
  543198
  543387
  543874
  545643
  548870
  557235
  559119
  564456
  567139
  568792
  571016
  575698
  577720
  578500
  584419
  584708
  585101
  588992
  589041
  589068
  589148
  591065
  591438
  591739
  591954
  598770
  599456
  601125
  603810
  604743
  605111
  605953
  606687
  608073
  609591
  610613
  614479
  615214
  616905
  618155
  619007
  619651
  622375
  622668
  622805
  622938
  626042
  636174
  642686
  643316
  649185
  650224
  654374
  654422
  662435
  664659
  675321
  685469
]

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 (415160, 424530, 470467, 476147, 478651, 486904, 488398, 488596, 499112, 504693, 507177, 512554, 514782, 520496, 520697, 524915, 525154, 526107, 526633, 527908, 527990, 528011, 533707, 536802, 539417, 543198, 543387, 543874, 545643, 548870, 557235, 559119, 564456, 567139, 568792, 571016, 575698, 577720, 578500, 584419, 584708, 585101, 588992, 589041, 589068, 589148, 591065, 591438, 591739, 591954, 598770, 599456, 601125, 603810, 604743, 605111, 605953, 606687, 608073, 609591, 610613, 614479, 615214, 616905, 618155, 619007, 619651, 622375, 622668, 622805, 622938, 626042, 636174, 642686, 643316, 649185, 650224, 654374, 654422, 662435, 664659, 675321, 685469);

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
  415160
  424530
  470467
  476147
  478651
  486904
  488398
  488596
  499112
  504693
  507177
  512554
  514782
  520496
  520697
  524915
  525154
  526107
  526633
  527908
  527990
  528011
  533707
  536802
  539417
  543198
  543387
  543874
  545643
  548870
  557235
  559119
  564456
  567139
  568792
  571016
  575698
  577720
  578500
  584419
  584708
  585101
  588992
  589041
  589068
  589148
  591065
  591438
  591739
  591954
  598770
  599456
  601125
  603810
  604743
  605111
  605953
  606687
  608073
  609591
  610613
  614479
  615214
  616905
  618155
  619007
  619651
  622375
  622668
  622805
  622938
  626042
  636174
  642686
  643316
  649185
  650224
  654374
  654422
  662435
  664659
  675321
  685469
]

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 (415160, 424530, 470467, 476147, 478651, 486904, 488398, 488596, 499112, 504693, 507177, 512554, 514782, 520496, 520697, 524915, 525154, 526107, 526633, 527908, 527990, 528011, 533707, 536802, 539417, 543198, 543387, 543874, 545643, 548870, 557235, 559119, 564456, 567139, 568792, 571016, 575698, 577720, 578500, 584419, 584708, 585101, 588992, 589041, 589068, 589148, 591065, 591438, 591739, 591954, 598770, 599456, 601125, 603810, 604743, 605111, 605953, 606687, 608073, 609591, 610613, 614479, 615214, 616905, 618155, 619007, 619651, 622375, 622668, 622805, 622938, 626042, 636174, 642686, 643316, 649185, 650224, 654374, 654422, 662435, 664659, 675321, 685469);

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` = 'мясист член';