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

[
  "gangbang amateur"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'gangbang amateur' 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
  775963
  421050
  636579
  567581
  478096
  543613
  543924
  557938
  716030
  775958
  778359
  423940
  512578
  484389
  540955
  417058
  452956
  510750
  390466
  423708
  492839
  514853
  560446
  748236
  718732
  361993
  525657
  537017
  543614
  543615
  590560
  421131
  420769
  477483
  540785
  546993
  612422
  600061
  748389
  437526
  545718
  554134
  576052
  579351
  660424
  644280
  514733
  540513
  714511
  668525
  583994
  640136
  130105
  431105
  486182
  560434
  605338
  443823
  583500
  557985
  557676
  730798
  598024
  632298
  597739
  490201
  494264
  558614
  565254
  517844
  521866
  591680
  423329
  541076
  566252
  662137
  579301
  671863
  601101
  521723
  603906
  611558
  587864
  621612
  627812
  521126
  520759
  588318
  516842
]

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 (775963, 421050, 636579, 567581, 478096, 543613, 543924, 557938, 716030, 775958, 778359, 423940, 512578, 484389, 540955, 417058, 452956, 510750, 390466, 423708, 492839, 514853, 560446, 748236, 718732, 361993, 525657, 537017, 543614, 543615, 590560, 421131, 420769, 477483, 540785, 546993, 612422, 600061, 748389, 437526, 545718, 554134, 576052, 579351, 660424, 644280, 514733, 540513, 714511, 668525, 583994, 640136, 130105, 431105, 486182, 560434, 605338, 443823, 583500, 557985, 557676, 730798, 598024, 632298, 597739, 490201, 494264, 558614, 565254, 517844, 521866, 591680, 423329, 541076, 566252, 662137, 579301, 671863, 601101, 521723, 603906, 611558, 587864, 621612, 627812, 521126, 520759, 588318, 516842);

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
  130105
  361993
  390466
  417058
  420769
  421050
  421131
  423329
  423708
  423940
  431105
  437526
  443823
  452956
  477483
  478096
  484389
  486182
  490201
  492839
  494264
  510750
  512578
  514733
  514853
  516842
  517844
  520759
  521126
  521723
  521866
  525657
  537017
  540513
  540785
  540955
  541076
  543613
  543614
  543615
  543924
  545718
  546993
  554134
  557676
  557938
  557985
  558614
  560434
  560446
  565254
  566252
  567581
  576052
  579301
  579351
  583500
  583994
  587864
  588318
  590560
  591680
  597739
  598024
  600061
  601101
  603906
  605338
  611558
  612422
  621612
  627812
  632298
  636579
  640136
  644280
  660424
  662137
  668525
  671863
  714511
  716030
  718732
  730798
  748236
  748389
  775958
  775963
  778359
]

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 (130105, 361993, 390466, 417058, 420769, 421050, 421131, 423329, 423708, 423940, 431105, 437526, 443823, 452956, 477483, 478096, 484389, 486182, 490201, 492839, 494264, 510750, 512578, 514733, 514853, 516842, 517844, 520759, 521126, 521723, 521866, 525657, 537017, 540513, 540785, 540955, 541076, 543613, 543614, 543615, 543924, 545718, 546993, 554134, 557676, 557938, 557985, 558614, 560434, 560446, 565254, 566252, 567581, 576052, 579301, 579351, 583500, 583994, 587864, 588318, 590560, 591680, 597739, 598024, 600061, 601101, 603906, 605338, 611558, 612422, 621612, 627812, 632298, 636579, 640136, 644280, 660424, 662137, 668525, 671863, 714511, 716030, 718732, 730798, 748236, 748389, 775958, 775963, 778359);

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
  130105
  361993
  390466
  417058
  420769
  421050
  421131
  423329
  423708
  423940
  431105
  437526
  443823
  452956
  477483
  478096
  484389
  486182
  490201
  492839
  494264
  510750
  512578
  514733
  514853
  516842
  517844
  520759
  521126
  521723
  521866
  525657
  537017
  540513
  540785
  540955
  541076
  543613
  543614
  543615
  543924
  545718
  546993
  554134
  557676
  557938
  557985
  558614
  560434
  560446
  565254
  566252
  567581
  576052
  579301
  579351
  583500
  583994
  587864
  588318
  590560
  591680
  597739
  598024
  600061
  601101
  603906
  605338
  611558
  612422
  621612
  627812
  632298
  636579
  640136
  644280
  660424
  662137
  668525
  671863
  714511
  716030
  718732
  730798
  748236
  748389
  775958
  775963
  778359
]

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 (130105, 361993, 390466, 417058, 420769, 421050, 421131, 423329, 423708, 423940, 431105, 437526, 443823, 452956, 477483, 478096, 484389, 486182, 490201, 492839, 494264, 510750, 512578, 514733, 514853, 516842, 517844, 520759, 521126, 521723, 521866, 525657, 537017, 540513, 540785, 540955, 541076, 543613, 543614, 543615, 543924, 545718, 546993, 554134, 557676, 557938, 557985, 558614, 560434, 560446, 565254, 566252, 567581, 576052, 579301, 579351, 583500, 583994, 587864, 588318, 590560, 591680, 597739, 598024, 600061, 601101, 603906, 605338, 611558, 612422, 621612, 627812, 632298, 636579, 640136, 644280, 660424, 662137, 668525, 671863, 714511, 716030, 718732, 730798, 748236, 748389, 775958, 775963, 778359);

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

[
  "gangbang любительск"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'gangbang любительск';

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

[
  "gangbang любительск"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'gangbang любительск';