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

[
  "crying wife"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'crying wife' 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
  523226
  503644
  390508
  433656
  537970
  456809
  524506
  510553
  462679
  547556
  563493
  602371
  622233
  624375
  594810
  423979
  430374
  441168
  456362
  495259
  512966
  540721
  488897
  462610
  429383
  452228
  482768
  522434
  539744
  523134
  550511
  574434
  560858
  601423
  604046
  454238
  432582
  432843
  427166
  505614
  610661
  506529
  495937
  425353
  428756
  453324
  555291
  621352
  444068
  507733
  637243
  609292
  499867
  588801
  484581
  655087
  539731
  597736
  613263
  619965
  688664
  451497
  575713
  654552
  663930
  511601
  484372
  622778
  611900
  563446
  655615
  584712
  689013
  601976
  518521
  520008
  511837
  610695
  657438
  560511
]

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 (523226, 503644, 390508, 433656, 537970, 456809, 524506, 510553, 462679, 547556, 563493, 602371, 622233, 624375, 594810, 423979, 430374, 441168, 456362, 495259, 512966, 540721, 488897, 462610, 429383, 452228, 482768, 522434, 539744, 523134, 550511, 574434, 560858, 601423, 604046, 454238, 432582, 432843, 427166, 505614, 610661, 506529, 495937, 425353, 428756, 453324, 555291, 621352, 444068, 507733, 637243, 609292, 499867, 588801, 484581, 655087, 539731, 597736, 613263, 619965, 688664, 451497, 575713, 654552, 663930, 511601, 484372, 622778, 611900, 563446, 655615, 584712, 689013, 601976, 518521, 520008, 511837, 610695, 657438, 560511);

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
  390508
  423979
  425353
  427166
  428756
  429383
  430374
  432582
  432843
  433656
  441168
  444068
  451497
  452228
  453324
  454238
  456362
  456809
  462610
  462679
  482768
  484372
  484581
  488897
  495259
  495937
  499867
  503644
  505614
  506529
  507733
  510553
  511601
  511837
  512966
  518521
  520008
  522434
  523134
  523226
  524506
  537970
  539731
  539744
  540721
  547556
  550511
  555291
  560511
  560858
  563446
  563493
  574434
  575713
  584712
  588801
  594810
  597736
  601423
  601976
  602371
  604046
  609292
  610661
  610695
  611900
  613263
  619965
  621352
  622233
  622778
  624375
  637243
  654552
  655087
  655615
  657438
  663930
  688664
  689013
]

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 (390508, 423979, 425353, 427166, 428756, 429383, 430374, 432582, 432843, 433656, 441168, 444068, 451497, 452228, 453324, 454238, 456362, 456809, 462610, 462679, 482768, 484372, 484581, 488897, 495259, 495937, 499867, 503644, 505614, 506529, 507733, 510553, 511601, 511837, 512966, 518521, 520008, 522434, 523134, 523226, 524506, 537970, 539731, 539744, 540721, 547556, 550511, 555291, 560511, 560858, 563446, 563493, 574434, 575713, 584712, 588801, 594810, 597736, 601423, 601976, 602371, 604046, 609292, 610661, 610695, 611900, 613263, 619965, 621352, 622233, 622778, 624375, 637243, 654552, 655087, 655615, 657438, 663930, 688664, 689013);

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
  390508
  423979
  425353
  427166
  428756
  429383
  430374
  432582
  432843
  433656
  441168
  444068
  451497
  452228
  453324
  454238
  456362
  456809
  462610
  462679
  482768
  484372
  484581
  488897
  495259
  495937
  499867
  503644
  505614
  506529
  507733
  510553
  511601
  511837
  512966
  518521
  520008
  522434
  523134
  523226
  524506
  537970
  539731
  539744
  540721
  547556
  550511
  555291
  560511
  560858
  563446
  563493
  574434
  575713
  584712
  588801
  594810
  597736
  601423
  601976
  602371
  604046
  609292
  610661
  610695
  611900
  613263
  619965
  621352
  622233
  622778
  624375
  637243
  654552
  655087
  655615
  657438
  663930
  688664
  689013
]

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 (390508, 423979, 425353, 427166, 428756, 429383, 430374, 432582, 432843, 433656, 441168, 444068, 451497, 452228, 453324, 454238, 456362, 456809, 462610, 462679, 482768, 484372, 484581, 488897, 495259, 495937, 499867, 503644, 505614, 506529, 507733, 510553, 511601, 511837, 512966, 518521, 520008, 522434, 523134, 523226, 524506, 537970, 539731, 539744, 540721, 547556, 550511, 555291, 560511, 560858, 563446, 563493, 574434, 575713, 584712, 588801, 594810, 597736, 601423, 601976, 602371, 604046, 609292, 610661, 610695, 611900, 613263, 619965, 621352, 622233, 622778, 624375, 637243, 654552, 655087, 655615, 657438, 663930, 688664, 689013);

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` = 'крича вперв жен';