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

[
  "homemade amateur gangbang"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'homemade amateur gangbang' 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
  583894
  651609
  603269
  591143
  591804
  775866
  770205
  755176
  775963
  540513
  690851
  543613
  543924
  557938
  716030
  775958
  778359
  423940
  512578
  484389
  540955
  418534
  385171
  308783
  382381
  477483
  668525
  590560
  540785
  546993
  612422
  96690
  714511
  387287
  721538
  600061
  583994
  640136
  557985
  557676
  730798
  390466
  423708
  492839
  560446
  748236
  361993
  671863
  597739
  437526
  545718
  554134
  576052
  579351
  660424
  514733
  423329
  601101
  591680
  632298
  603906
  130105
  431105
  486182
  565254
  517844
  521866
  520759
  566252
  579301
  521723
  588318
  611558
  587864
  621612
  521126
  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 (583894, 651609, 603269, 591143, 591804, 775866, 770205, 755176, 775963, 540513, 690851, 543613, 543924, 557938, 716030, 775958, 778359, 423940, 512578, 484389, 540955, 418534, 385171, 308783, 382381, 477483, 668525, 590560, 540785, 546993, 612422, 96690, 714511, 387287, 721538, 600061, 583994, 640136, 557985, 557676, 730798, 390466, 423708, 492839, 560446, 748236, 361993, 671863, 597739, 437526, 545718, 554134, 576052, 579351, 660424, 514733, 423329, 601101, 591680, 632298, 603906, 130105, 431105, 486182, 565254, 517844, 521866, 520759, 566252, 579301, 521723, 588318, 611558, 587864, 621612, 521126, 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
  96690
  130105
  308783
  361993
  382381
  385171
  387287
  390466
  418534
  423329
  423708
  423940
  431105
  437526
  477483
  484389
  486182
  492839
  512578
  514733
  516842
  517844
  520759
  521126
  521723
  521866
  540513
  540785
  540955
  543613
  543924
  545718
  546993
  554134
  557676
  557938
  557985
  560446
  565254
  566252
  576052
  579301
  579351
  583894
  583994
  587864
  588318
  590560
  591143
  591680
  591804
  597739
  600061
  601101
  603269
  603906
  611558
  612422
  621612
  632298
  640136
  651609
  660424
  668525
  671863
  690851
  714511
  716030
  721538
  730798
  748236
  755176
  770205
  775866
  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 (96690, 130105, 308783, 361993, 382381, 385171, 387287, 390466, 418534, 423329, 423708, 423940, 431105, 437526, 477483, 484389, 486182, 492839, 512578, 514733, 516842, 517844, 520759, 521126, 521723, 521866, 540513, 540785, 540955, 543613, 543924, 545718, 546993, 554134, 557676, 557938, 557985, 560446, 565254, 566252, 576052, 579301, 579351, 583894, 583994, 587864, 588318, 590560, 591143, 591680, 591804, 597739, 600061, 601101, 603269, 603906, 611558, 612422, 621612, 632298, 640136, 651609, 660424, 668525, 671863, 690851, 714511, 716030, 721538, 730798, 748236, 755176, 770205, 775866, 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
  96690
  130105
  308783
  361993
  382381
  385171
  387287
  390466
  418534
  423329
  423708
  423940
  431105
  437526
  477483
  484389
  486182
  492839
  512578
  514733
  516842
  517844
  520759
  521126
  521723
  521866
  540513
  540785
  540955
  543613
  543924
  545718
  546993
  554134
  557676
  557938
  557985
  560446
  565254
  566252
  576052
  579301
  579351
  583894
  583994
  587864
  588318
  590560
  591143
  591680
  591804
  597739
  600061
  601101
  603269
  603906
  611558
  612422
  621612
  632298
  640136
  651609
  660424
  668525
  671863
  690851
  714511
  716030
  721538
  730798
  748236
  755176
  770205
  775866
  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 (96690, 130105, 308783, 361993, 382381, 385171, 387287, 390466, 418534, 423329, 423708, 423940, 431105, 437526, 477483, 484389, 486182, 492839, 512578, 514733, 516842, 517844, 520759, 521126, 521723, 521866, 540513, 540785, 540955, 543613, 543924, 545718, 546993, 554134, 557676, 557938, 557985, 560446, 565254, 566252, 576052, 579301, 579351, 583894, 583994, 587864, 588318, 590560, 591143, 591680, 591804, 597739, 600061, 601101, 603269, 603906, 611558, 612422, 621612, 632298, 640136, 651609, 660424, 668525, 671863, 690851, 714511, 716030, 721538, 730798, 748236, 755176, 770205, 775866, 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';