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

[
  "fingering hairy pussy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'fingering hairy pussy' 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
  764204
  750514
  709651
  462843
  577814
  517881
  602562
  496845
  640366
  783350
  683257
  535317
  614338
  471057
  565808
  714319
  804435
  509598
  609057
  526529
  533289
  736725
  739186
  581408
  532616
  652163
  600590
  796397
  389182
  763966
  666680
  488900
  639981
  710639
  801841
  803819
  742822
  620880
  687620
  796404
  803479
  610138
  802278
  418132
  506848
  668699
  706029
  468322
  636610
  766349
  459258
  750626
  804793
  801990
  528816
  499568
  546016
  527889
  712174
  586688
  646081
  490675
  496456
  580366
  597899
  588379
  594257
  436942
  474076
  583267
  681220
  533290
  414618
  521150
  426298
  505526
  577926
  594179
  441049
]

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 (764204, 750514, 709651, 462843, 577814, 517881, 602562, 496845, 640366, 783350, 683257, 535317, 614338, 471057, 565808, 714319, 804435, 509598, 609057, 526529, 533289, 736725, 739186, 581408, 532616, 652163, 600590, 796397, 389182, 763966, 666680, 488900, 639981, 710639, 801841, 803819, 742822, 620880, 687620, 796404, 803479, 610138, 802278, 418132, 506848, 668699, 706029, 468322, 636610, 766349, 459258, 750626, 804793, 801990, 528816, 499568, 546016, 527889, 712174, 586688, 646081, 490675, 496456, 580366, 597899, 588379, 594257, 436942, 474076, 583267, 681220, 533290, 414618, 521150, 426298, 505526, 577926, 594179, 441049);

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
  389182
  414618
  418132
  426298
  436942
  441049
  459258
  462843
  468322
  471057
  474076
  488900
  490675
  496456
  496845
  499568
  505526
  506848
  509598
  517881
  521150
  526529
  527889
  528816
  532616
  533289
  533290
  535317
  546016
  565808
  577814
  577926
  580366
  581408
  583267
  586688
  588379
  594179
  594257
  597899
  600590
  602562
  609057
  610138
  614338
  620880
  636610
  639981
  640366
  646081
  652163
  666680
  668699
  681220
  683257
  687620
  706029
  709651
  710639
  712174
  714319
  736725
  739186
  742822
  750514
  750626
  763966
  764204
  766349
  783350
  796397
  796404
  801841
  801990
  802278
  803479
  803819
  804435
  804793
]

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 (389182, 414618, 418132, 426298, 436942, 441049, 459258, 462843, 468322, 471057, 474076, 488900, 490675, 496456, 496845, 499568, 505526, 506848, 509598, 517881, 521150, 526529, 527889, 528816, 532616, 533289, 533290, 535317, 546016, 565808, 577814, 577926, 580366, 581408, 583267, 586688, 588379, 594179, 594257, 597899, 600590, 602562, 609057, 610138, 614338, 620880, 636610, 639981, 640366, 646081, 652163, 666680, 668699, 681220, 683257, 687620, 706029, 709651, 710639, 712174, 714319, 736725, 739186, 742822, 750514, 750626, 763966, 764204, 766349, 783350, 796397, 796404, 801841, 801990, 802278, 803479, 803819, 804435, 804793);

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
  389182
  414618
  418132
  426298
  436942
  441049
  459258
  462843
  468322
  471057
  474076
  488900
  490675
  496456
  496845
  499568
  505526
  506848
  509598
  517881
  521150
  526529
  527889
  528816
  532616
  533289
  533290
  535317
  546016
  565808
  577814
  577926
  580366
  581408
  583267
  586688
  588379
  594179
  594257
  597899
  600590
  602562
  609057
  610138
  614338
  620880
  636610
  639981
  640366
  646081
  652163
  666680
  668699
  681220
  683257
  687620
  706029
  709651
  710639
  712174
  714319
  736725
  739186
  742822
  750514
  750626
  763966
  764204
  766349
  783350
  796397
  796404
  801841
  801990
  802278
  803479
  803819
  804435
  804793
]

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 (389182, 414618, 418132, 426298, 436942, 441049, 459258, 462843, 468322, 471057, 474076, 488900, 490675, 496456, 496845, 499568, 505526, 506848, 509598, 517881, 521150, 526529, 527889, 528816, 532616, 533289, 533290, 535317, 546016, 565808, 577814, 577926, 580366, 581408, 583267, 586688, 588379, 594179, 594257, 597899, 600590, 602562, 609057, 610138, 614338, 620880, 636610, 639981, 640366, 646081, 652163, 666680, 668699, 681220, 683257, 687620, 706029, 709651, 710639, 712174, 714319, 736725, 739186, 742822, 750514, 750626, 763966, 764204, 766349, 783350, 796397, 796404, 801841, 801990, 802278, 803479, 803819, 804435, 804793);

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

[
  "fingering волосатая pussy"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'fingering волосатая pussy';

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

[
  "fingering волосатая pussy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'fingering волосатая pussy';