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
  423396
  444080
  435958
  468362
  479352
  445324
  464318
  487134
  473430
  812939
  489856
  491997
  492656
  440852
  421779
  570728
  761134
  438898
  541549
  441537
  450514
  463493
  450418
  478033
  506335
  497343
  513313
  445228
  420584
  481625
  434428
  386211
  437558
  396640
  529265
  432359
  448363
  468127
  496997
  418165
  427083
  418857
  421517
  449384
  561995
  401273
  468042
  594783
  437855
  483386
  393055
  596645
  463936
  565665
  187962
  623321
  614434
  572711
  606136
  630177
  594869
  599109
  620638
  507872
  620290
  479854
  608584
  605953
  685469
  652236
  597975
  596627
  620250
  546125
  544478
  627773
  480768
  567050
  608553
  549246
  520737
  540141
  493958
  654474
  554787
]

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 (423396, 444080, 435958, 468362, 479352, 445324, 464318, 487134, 473430, 812939, 489856, 491997, 492656, 440852, 421779, 570728, 761134, 438898, 541549, 441537, 450514, 463493, 450418, 478033, 506335, 497343, 513313, 445228, 420584, 481625, 434428, 386211, 437558, 396640, 529265, 432359, 448363, 468127, 496997, 418165, 427083, 418857, 421517, 449384, 561995, 401273, 468042, 594783, 437855, 483386, 393055, 596645, 463936, 565665, 187962, 623321, 614434, 572711, 606136, 630177, 594869, 599109, 620638, 507872, 620290, 479854, 608584, 605953, 685469, 652236, 597975, 596627, 620250, 546125, 544478, 627773, 480768, 567050, 608553, 549246, 520737, 540141, 493958, 654474, 554787);

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
  187962
  386211
  393055
  396640
  401273
  418165
  418857
  420584
  421517
  421779
  423396
  427083
  432359
  434428
  435958
  437558
  437855
  438898
  440852
  441537
  444080
  445228
  445324
  448363
  449384
  450418
  450514
  463493
  463936
  464318
  468042
  468127
  468362
  473430
  478033
  479352
  479854
  480768
  481625
  483386
  487134
  489856
  491997
  492656
  493958
  496997
  497343
  506335
  507872
  513313
  520737
  529265
  540141
  541549
  544478
  546125
  549246
  554787
  561995
  565665
  567050
  570728
  572711
  594783
  594869
  596627
  596645
  597975
  599109
  605953
  606136
  608553
  608584
  614434
  620250
  620290
  620638
  623321
  627773
  630177
  652236
  654474
  685469
  761134
  812939
]

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 (187962, 386211, 393055, 396640, 401273, 418165, 418857, 420584, 421517, 421779, 423396, 427083, 432359, 434428, 435958, 437558, 437855, 438898, 440852, 441537, 444080, 445228, 445324, 448363, 449384, 450418, 450514, 463493, 463936, 464318, 468042, 468127, 468362, 473430, 478033, 479352, 479854, 480768, 481625, 483386, 487134, 489856, 491997, 492656, 493958, 496997, 497343, 506335, 507872, 513313, 520737, 529265, 540141, 541549, 544478, 546125, 549246, 554787, 561995, 565665, 567050, 570728, 572711, 594783, 594869, 596627, 596645, 597975, 599109, 605953, 606136, 608553, 608584, 614434, 620250, 620290, 620638, 623321, 627773, 630177, 652236, 654474, 685469, 761134, 812939);

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
  187962
  386211
  393055
  396640
  401273
  418165
  418857
  420584
  421517
  421779
  423396
  427083
  432359
  434428
  435958
  437558
  437855
  438898
  440852
  441537
  444080
  445228
  445324
  448363
  449384
  450418
  450514
  463493
  463936
  464318
  468042
  468127
  468362
  473430
  478033
  479352
  479854
  480768
  481625
  483386
  487134
  489856
  491997
  492656
  493958
  496997
  497343
  506335
  507872
  513313
  520737
  529265
  540141
  541549
  544478
  546125
  549246
  554787
  561995
  565665
  567050
  570728
  572711
  594783
  594869
  596627
  596645
  597975
  599109
  605953
  606136
  608553
  608584
  614434
  620250
  620290
  620638
  623321
  627773
  630177
  652236
  654474
  685469
  761134
  812939
]

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 (187962, 386211, 393055, 396640, 401273, 418165, 418857, 420584, 421517, 421779, 423396, 427083, 432359, 434428, 435958, 437558, 437855, 438898, 440852, 441537, 444080, 445228, 445324, 448363, 449384, 450418, 450514, 463493, 463936, 464318, 468042, 468127, 468362, 473430, 478033, 479352, 479854, 480768, 481625, 483386, 487134, 489856, 491997, 492656, 493958, 496997, 497343, 506335, 507872, 513313, 520737, 529265, 540141, 541549, 544478, 546125, 549246, 554787, 561995, 565665, 567050, 570728, 572711, 594783, 594869, 596627, 596645, 597975, 599109, 605953, 606136, 608553, 608584, 614434, 620250, 620290, 620638, 623321, 627773, 630177, 652236, 654474, 685469, 761134, 812939);

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` = 'дав член';