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

[
  b"ð▒ð¥ð╗ÐîÐêð©ðÁ ð╗ÐÅðÂð║ð© ÐÇÐâÐüÐüð║ð©ð%ÔǪ"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 0xD0B1D0BED0BBD18CD188D0B8D0B520D0BBD18FD0B6D0BAD0B820D180D183D181D181D0BAD0B8D025E280A6 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
  636519
  439641
  489217
  584631
  439559
  624167
  436186
  572408
  574520
  573643
  590427
  598449
  619186
  634277
  578084
  618743
  611791
  621985
  627625
  579062
  597572
  602715
  598604
  656370
  653464
  610616
  620031
  485371
  579188
  598609
  584422
  582269
  596515
  601956
  561828
  650311
  594819
  599514
  601489
  603911
  590599
  599506
  611989
  582258
  583139
  618856
  601903
  604298
  625205
  618014
  595369
  600074
  608111
  621454
  590444
  601485
  617097
  601856
  601917
  620263
  589698
  603971
  606011
  614729
  620262
  484331
  625991
  623468
  557570
  559796
  624131
  525849
  626944
  601630
]

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 (636519, 439641, 489217, 584631, 439559, 624167, 436186, 572408, 574520, 573643, 590427, 598449, 619186, 634277, 578084, 618743, 611791, 621985, 627625, 579062, 597572, 602715, 598604, 656370, 653464, 610616, 620031, 485371, 579188, 598609, 584422, 582269, 596515, 601956, 561828, 650311, 594819, 599514, 601489, 603911, 590599, 599506, 611989, 582258, 583139, 618856, 601903, 604298, 625205, 618014, 595369, 600074, 608111, 621454, 590444, 601485, 617097, 601856, 601917, 620263, 589698, 603971, 606011, 614729, 620262, 484331, 625991, 623468, 557570, 559796, 624131, 525849, 626944, 601630);

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
  436186
  439559
  439641
  484331
  485371
  489217
  525849
  557570
  559796
  561828
  572408
  573643
  574520
  578084
  579062
  579188
  582258
  582269
  583139
  584422
  584631
  589698
  590427
  590444
  590599
  594819
  595369
  596515
  597572
  598449
  598604
  598609
  599506
  599514
  600074
  601485
  601489
  601630
  601856
  601903
  601917
  601956
  602715
  603911
  603971
  604298
  606011
  608111
  610616
  611791
  611989
  614729
  617097
  618014
  618743
  618856
  619186
  620031
  620262
  620263
  621454
  621985
  623468
  624131
  624167
  625205
  625991
  626944
  627625
  634277
  636519
  650311
  653464
  656370
]

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 (436186, 439559, 439641, 484331, 485371, 489217, 525849, 557570, 559796, 561828, 572408, 573643, 574520, 578084, 579062, 579188, 582258, 582269, 583139, 584422, 584631, 589698, 590427, 590444, 590599, 594819, 595369, 596515, 597572, 598449, 598604, 598609, 599506, 599514, 600074, 601485, 601489, 601630, 601856, 601903, 601917, 601956, 602715, 603911, 603971, 604298, 606011, 608111, 610616, 611791, 611989, 614729, 617097, 618014, 618743, 618856, 619186, 620031, 620262, 620263, 621454, 621985, 623468, 624131, 624167, 625205, 625991, 626944, 627625, 634277, 636519, 650311, 653464, 656370);

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
  436186
  439559
  439641
  484331
  485371
  489217
  525849
  557570
  559796
  561828
  572408
  573643
  574520
  578084
  579062
  579188
  582258
  582269
  583139
  584422
  584631
  589698
  590427
  590444
  590599
  594819
  595369
  596515
  597572
  598449
  598604
  598609
  599506
  599514
  600074
  601485
  601489
  601630
  601856
  601903
  601917
  601956
  602715
  603911
  603971
  604298
  606011
  608111
  610616
  611791
  611989
  614729
  617097
  618014
  618743
  618856
  619186
  620031
  620262
  620263
  621454
  621985
  623468
  624131
  624167
  625205
  625991
  626944
  627625
  634277
  636519
  650311
  653464
  656370
]

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 (436186, 439559, 439641, 484331, 485371, 489217, 525849, 557570, 559796, 561828, 572408, 573643, 574520, 578084, 579062, 579188, 582258, 582269, 583139, 584422, 584631, 589698, 590427, 590444, 590599, 594819, 595369, 596515, 597572, 598449, 598604, 598609, 599506, 599514, 600074, 601485, 601489, 601630, 601856, 601903, 601917, 601956, 602715, 603911, 603971, 604298, 606011, 608111, 610616, 611791, 611989, 614729, 617097, 618014, 618743, 618856, 619186, 620031, 620262, 620263, 621454, 621985, 623468, 624131, 624167, 625205, 625991, 626944, 627625, 634277, 636519, 650311, 653464, 656370);

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` = 'большие ляжк русск';