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

[
  "mature riding squirt"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature riding squirt' 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
  531377
  411861
  728340
  827496
  735939
  555306
  395182
  633237
  537856
  765224
  625779
  790941
  521831
  795404
  263259
  555390
  803633
  819488
  555402
  717550
  6806
  388440
  662129
  188462
  555297
  730015
  630793
  510198
  634472
  825864
  718678
  745938
  382295
  546129
  591661
  796644
  765388
  534546
  695803
  731204
  744598
  370755
  725598
  533598
  483731
  649921
  577058
  513842
  471081
  733518
  445409
  633435
  472625
  606576
  617129
  629808
  775855
  738827
  752704
  478596
  533643
  578829
  604811
  595061
  748227
  491790
  660410
  510395
  735546
  541832
  815017
  439543
  699397
  664566
  664166
  793187
  741060
  424780
  707556
  773457
  728469
  791209
  567291
]

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 (531377, 411861, 728340, 827496, 735939, 555306, 395182, 633237, 537856, 765224, 625779, 790941, 521831, 795404, 263259, 555390, 803633, 819488, 555402, 717550, 6806, 388440, 662129, 188462, 555297, 730015, 630793, 510198, 634472, 825864, 718678, 745938, 382295, 546129, 591661, 796644, 765388, 534546, 695803, 731204, 744598, 370755, 725598, 533598, 483731, 649921, 577058, 513842, 471081, 733518, 445409, 633435, 472625, 606576, 617129, 629808, 775855, 738827, 752704, 478596, 533643, 578829, 604811, 595061, 748227, 491790, 660410, 510395, 735546, 541832, 815017, 439543, 699397, 664566, 664166, 793187, 741060, 424780, 707556, 773457, 728469, 791209, 567291);

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
  6806
  188462
  263259
  370755
  382295
  388440
  395182
  411861
  424780
  439543
  445409
  471081
  472625
  478596
  483731
  491790
  510198
  510395
  513842
  521831
  531377
  533598
  533643
  534546
  537856
  541832
  546129
  555297
  555306
  555390
  555402
  567291
  577058
  578829
  591661
  595061
  604811
  606576
  617129
  625779
  629808
  630793
  633237
  633435
  634472
  649921
  660410
  662129
  664166
  664566
  695803
  699397
  707556
  717550
  718678
  725598
  728340
  728469
  730015
  731204
  733518
  735546
  735939
  738827
  741060
  744598
  745938
  748227
  752704
  765224
  765388
  773457
  775855
  790941
  791209
  793187
  795404
  796644
  803633
  815017
  819488
  825864
  827496
]

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 (6806, 188462, 263259, 370755, 382295, 388440, 395182, 411861, 424780, 439543, 445409, 471081, 472625, 478596, 483731, 491790, 510198, 510395, 513842, 521831, 531377, 533598, 533643, 534546, 537856, 541832, 546129, 555297, 555306, 555390, 555402, 567291, 577058, 578829, 591661, 595061, 604811, 606576, 617129, 625779, 629808, 630793, 633237, 633435, 634472, 649921, 660410, 662129, 664166, 664566, 695803, 699397, 707556, 717550, 718678, 725598, 728340, 728469, 730015, 731204, 733518, 735546, 735939, 738827, 741060, 744598, 745938, 748227, 752704, 765224, 765388, 773457, 775855, 790941, 791209, 793187, 795404, 796644, 803633, 815017, 819488, 825864, 827496);

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
  6806
  188462
  263259
  370755
  382295
  388440
  395182
  411861
  424780
  439543
  445409
  471081
  472625
  478596
  483731
  491790
  510198
  510395
  513842
  521831
  531377
  533598
  533643
  534546
  537856
  541832
  546129
  555297
  555306
  555390
  555402
  567291
  577058
  578829
  591661
  595061
  604811
  606576
  617129
  625779
  629808
  630793
  633237
  633435
  634472
  649921
  660410
  662129
  664166
  664566
  695803
  699397
  707556
  717550
  718678
  725598
  728340
  728469
  730015
  731204
  733518
  735546
  735939
  738827
  741060
  744598
  745938
  748227
  752704
  765224
  765388
  773457
  775855
  790941
  791209
  793187
  795404
  796644
  803633
  815017
  819488
  825864
  827496
]

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 (6806, 188462, 263259, 370755, 382295, 388440, 395182, 411861, 424780, 439543, 445409, 471081, 472625, 478596, 483731, 491790, 510198, 510395, 513842, 521831, 531377, 533598, 533643, 534546, 537856, 541832, 546129, 555297, 555306, 555390, 555402, 567291, 577058, 578829, 591661, 595061, 604811, 606576, 617129, 625779, 629808, 630793, 633237, 633435, 634472, 649921, 660410, 662129, 664166, 664566, 695803, 699397, 707556, 717550, 718678, 725598, 728340, 728469, 730015, 731204, 733518, 735546, 735939, 738827, 741060, 744598, 745938, 748227, 752704, 765224, 765388, 773457, 775855, 790941, 791209, 793187, 795404, 796644, 803633, 815017, 819488, 825864, 827496);

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

[
  "mature riding сквирт оргазм"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'mature riding сквирт оргазм';

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

[
  "mature riding сквирт оргазм"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature riding сквирт оргазм';