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

[
  "compilation interracial"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'compilation interracial' 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
  599977
  601046
  602647
  599854
  616411
  634212
  639790
  632646
  448811
  476106
  545828
  604478
  605521
  466404
  406081
  481910
  532480
  540217
  540513
  528682
  471691
  583989
  563535
  699397
  651634
  628334
  599983
  604528
  639824
  643061
  600003
  606482
  637092
  599905
  600022
  600030
  614720
  541651
  420291
  428126
  533014
  536712
  474539
  545773
  550315
  630756
  632020
  633445
  632595
  636033
  803455
  604517
  632269
  632616
  607594
  475937
  423329
  455898
  540535
  541644
  541667
  541769
  650380
  676428
  686843
  695181
  695127
  620641
  635243
  597963
  632701
  533348
  574384
  612256
  530637
  541643
  541671
  573212
  542195
  541588
  666850
  601101
  495217
  410959
  503194
]

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 (599977, 601046, 602647, 599854, 616411, 634212, 639790, 632646, 448811, 476106, 545828, 604478, 605521, 466404, 406081, 481910, 532480, 540217, 540513, 528682, 471691, 583989, 563535, 699397, 651634, 628334, 599983, 604528, 639824, 643061, 600003, 606482, 637092, 599905, 600022, 600030, 614720, 541651, 420291, 428126, 533014, 536712, 474539, 545773, 550315, 630756, 632020, 633445, 632595, 636033, 803455, 604517, 632269, 632616, 607594, 475937, 423329, 455898, 540535, 541644, 541667, 541769, 650380, 676428, 686843, 695181, 695127, 620641, 635243, 597963, 632701, 533348, 574384, 612256, 530637, 541643, 541671, 573212, 542195, 541588, 666850, 601101, 495217, 410959, 503194);

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
  406081
  410959
  420291
  423329
  428126
  448811
  455898
  466404
  471691
  474539
  475937
  476106
  481910
  495217
  503194
  528682
  530637
  532480
  533014
  533348
  536712
  540217
  540513
  540535
  541588
  541643
  541644
  541651
  541667
  541671
  541769
  542195
  545773
  545828
  550315
  563535
  573212
  574384
  583989
  597963
  599854
  599905
  599977
  599983
  600003
  600022
  600030
  601046
  601101
  602647
  604478
  604517
  604528
  605521
  606482
  607594
  612256
  614720
  616411
  620641
  628334
  630756
  632020
  632269
  632595
  632616
  632646
  632701
  633445
  634212
  635243
  636033
  637092
  639790
  639824
  643061
  650380
  651634
  666850
  676428
  686843
  695127
  695181
  699397
  803455
]

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 (406081, 410959, 420291, 423329, 428126, 448811, 455898, 466404, 471691, 474539, 475937, 476106, 481910, 495217, 503194, 528682, 530637, 532480, 533014, 533348, 536712, 540217, 540513, 540535, 541588, 541643, 541644, 541651, 541667, 541671, 541769, 542195, 545773, 545828, 550315, 563535, 573212, 574384, 583989, 597963, 599854, 599905, 599977, 599983, 600003, 600022, 600030, 601046, 601101, 602647, 604478, 604517, 604528, 605521, 606482, 607594, 612256, 614720, 616411, 620641, 628334, 630756, 632020, 632269, 632595, 632616, 632646, 632701, 633445, 634212, 635243, 636033, 637092, 639790, 639824, 643061, 650380, 651634, 666850, 676428, 686843, 695127, 695181, 699397, 803455);

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
  406081
  410959
  420291
  423329
  428126
  448811
  455898
  466404
  471691
  474539
  475937
  476106
  481910
  495217
  503194
  528682
  530637
  532480
  533014
  533348
  536712
  540217
  540513
  540535
  541588
  541643
  541644
  541651
  541667
  541671
  541769
  542195
  545773
  545828
  550315
  563535
  573212
  574384
  583989
  597963
  599854
  599905
  599977
  599983
  600003
  600022
  600030
  601046
  601101
  602647
  604478
  604517
  604528
  605521
  606482
  607594
  612256
  614720
  616411
  620641
  628334
  630756
  632020
  632269
  632595
  632616
  632646
  632701
  633445
  634212
  635243
  636033
  637092
  639790
  639824
  643061
  650380
  651634
  666850
  676428
  686843
  695127
  695181
  699397
  803455
]

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 (406081, 410959, 420291, 423329, 428126, 448811, 455898, 466404, 471691, 474539, 475937, 476106, 481910, 495217, 503194, 528682, 530637, 532480, 533014, 533348, 536712, 540217, 540513, 540535, 541588, 541643, 541644, 541651, 541667, 541671, 541769, 542195, 545773, 545828, 550315, 563535, 573212, 574384, 583989, 597963, 599854, 599905, 599977, 599983, 600003, 600022, 600030, 601046, 601101, 602647, 604478, 604517, 604528, 605521, 606482, 607594, 612256, 614720, 616411, 620641, 628334, 630756, 632020, 632269, 632595, 632616, 632646, 632701, 633445, 634212, 635243, 636033, 637092, 639790, 639824, 643061, 650380, 651634, 666850, 676428, 686843, 695127, 695181, 699397, 803455);

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` = 'подборк межрасов';