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

[
  "sex game mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sex game mom' 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
  483189
  501875
  825864
  532776
  578067
  483162
  516473
  512479
  505818
  528197
  612809
  601938
  808865
  788260
  416785
  457946
  508522
  512998
  575198
  474787
  680271
  648838
  631170
  510108
  547481
  788262
  542678
  752158
  405181
  563473
  571979
  645952
  508474
  489212
  784152
  521469
  494842
  581816
  788264
  515861
  482355
  515914
  582531
  522906
  412311
  480861
  463087
  535018
  469030
  498730
  511595
  483709
  515358
  495752
  506406
  531516
  616205
  639810
  535013
  512927
  532942
  573156
  541821
  578397
  676634
  539319
  751565
  582624
  587651
  588244
  560924
  506269
  532755
  494081
  492320
  500562
  585725
  619407
  447835
]

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 (483189, 501875, 825864, 532776, 578067, 483162, 516473, 512479, 505818, 528197, 612809, 601938, 808865, 788260, 416785, 457946, 508522, 512998, 575198, 474787, 680271, 648838, 631170, 510108, 547481, 788262, 542678, 752158, 405181, 563473, 571979, 645952, 508474, 489212, 784152, 521469, 494842, 581816, 788264, 515861, 482355, 515914, 582531, 522906, 412311, 480861, 463087, 535018, 469030, 498730, 511595, 483709, 515358, 495752, 506406, 531516, 616205, 639810, 535013, 512927, 532942, 573156, 541821, 578397, 676634, 539319, 751565, 582624, 587651, 588244, 560924, 506269, 532755, 494081, 492320, 500562, 585725, 619407, 447835);

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
  405181
  412311
  416785
  447835
  457946
  463087
  469030
  474787
  480861
  482355
  483162
  483189
  483709
  489212
  492320
  494081
  494842
  495752
  498730
  500562
  501875
  505818
  506269
  506406
  508474
  508522
  510108
  511595
  512479
  512927
  512998
  515358
  515861
  515914
  516473
  521469
  522906
  528197
  531516
  532755
  532776
  532942
  535013
  535018
  539319
  541821
  542678
  547481
  560924
  563473
  571979
  573156
  575198
  578067
  578397
  581816
  582531
  582624
  585725
  587651
  588244
  601938
  612809
  616205
  619407
  631170
  639810
  645952
  648838
  676634
  680271
  751565
  752158
  784152
  788260
  788262
  788264
  808865
  825864
]

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 (405181, 412311, 416785, 447835, 457946, 463087, 469030, 474787, 480861, 482355, 483162, 483189, 483709, 489212, 492320, 494081, 494842, 495752, 498730, 500562, 501875, 505818, 506269, 506406, 508474, 508522, 510108, 511595, 512479, 512927, 512998, 515358, 515861, 515914, 516473, 521469, 522906, 528197, 531516, 532755, 532776, 532942, 535013, 535018, 539319, 541821, 542678, 547481, 560924, 563473, 571979, 573156, 575198, 578067, 578397, 581816, 582531, 582624, 585725, 587651, 588244, 601938, 612809, 616205, 619407, 631170, 639810, 645952, 648838, 676634, 680271, 751565, 752158, 784152, 788260, 788262, 788264, 808865, 825864);

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
  405181
  412311
  416785
  447835
  457946
  463087
  469030
  474787
  480861
  482355
  483162
  483189
  483709
  489212
  492320
  494081
  494842
  495752
  498730
  500562
  501875
  505818
  506269
  506406
  508474
  508522
  510108
  511595
  512479
  512927
  512998
  515358
  515861
  515914
  516473
  521469
  522906
  528197
  531516
  532755
  532776
  532942
  535013
  535018
  539319
  541821
  542678
  547481
  560924
  563473
  571979
  573156
  575198
  578067
  578397
  581816
  582531
  582624
  585725
  587651
  588244
  601938
  612809
  616205
  619407
  631170
  639810
  645952
  648838
  676634
  680271
  751565
  752158
  784152
  788260
  788262
  788264
  808865
  825864
]

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 (405181, 412311, 416785, 447835, 457946, 463087, 469030, 474787, 480861, 482355, 483162, 483189, 483709, 489212, 492320, 494081, 494842, 495752, 498730, 500562, 501875, 505818, 506269, 506406, 508474, 508522, 510108, 511595, 512479, 512927, 512998, 515358, 515861, 515914, 516473, 521469, 522906, 528197, 531516, 532755, 532776, 532942, 535013, 535018, 539319, 541821, 542678, 547481, 560924, 563473, 571979, 573156, 575198, 578067, 578397, 581816, 582531, 582624, 585725, 587651, 588244, 601938, 612809, 616205, 619407, 631170, 639810, 645952, 648838, 676634, 680271, 751565, 752158, 784152, 788260, 788262, 788264, 808865, 825864);

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

[
  "секс игр mom"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'секс игр mom';

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

[
  "секс игр mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс игр mom';