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

[
  "anal erotic"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal erotic' 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
  598133
  601388
  614831
  419455
  435554
  471108
  424265
  520483
  653189
  549860
  543745
  391921
  482195
  468642
  558074
  473189
  519086
  439558
  387363
  535025
  431448
  432246
  475329
  510209
  530273
  568519
  579429
  596976
  637469
  592382
  589968
  613558
  626911
  614827
  524479
  517881
  445408
  467559
  571391
  558134
  576710
  527350
  541345
  581929
  584352
  607608
  470015
  562831
  621259
  598142
  620236
  520763
  525026
  451042
  523360
  547245
  677025
  593125
  614029
  480298
  544788
  589040
  453364
  609958
  602312
  411055
  388363
  562195
  448262
  440857
  526263
  515931
  570177
  596862
  565825
  510108
  524760
  622407
  591959
  528923
]

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 (598133, 601388, 614831, 419455, 435554, 471108, 424265, 520483, 653189, 549860, 543745, 391921, 482195, 468642, 558074, 473189, 519086, 439558, 387363, 535025, 431448, 432246, 475329, 510209, 530273, 568519, 579429, 596976, 637469, 592382, 589968, 613558, 626911, 614827, 524479, 517881, 445408, 467559, 571391, 558134, 576710, 527350, 541345, 581929, 584352, 607608, 470015, 562831, 621259, 598142, 620236, 520763, 525026, 451042, 523360, 547245, 677025, 593125, 614029, 480298, 544788, 589040, 453364, 609958, 602312, 411055, 388363, 562195, 448262, 440857, 526263, 515931, 570177, 596862, 565825, 510108, 524760, 622407, 591959, 528923);

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
  387363
  388363
  391921
  411055
  419455
  424265
  431448
  432246
  435554
  439558
  440857
  445408
  448262
  451042
  453364
  467559
  468642
  470015
  471108
  473189
  475329
  480298
  482195
  510108
  510209
  515931
  517881
  519086
  520483
  520763
  523360
  524479
  525026
  526263
  527350
  528923
  530273
  535025
  543745
  544788
  547245
  549860
  558074
  558134
  562195
  562831
  565825
  568519
  570177
  571391
  576710
  579429
  581929
  584352
  589040
  589968
  591959
  592382
  593125
  596862
  596976
  598133
  598142
  601388
  602312
  607608
  609958
  613558
  614029
  614827
  614831
  620236
  621259
  622407
  626911
  637469
  653189
  677025
]

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 (387363, 388363, 391921, 411055, 419455, 424265, 431448, 432246, 435554, 439558, 440857, 445408, 448262, 451042, 453364, 467559, 468642, 470015, 471108, 473189, 475329, 480298, 482195, 510108, 510209, 515931, 517881, 519086, 520483, 520763, 523360, 524479, 525026, 526263, 527350, 528923, 530273, 535025, 543745, 544788, 547245, 549860, 558074, 558134, 562195, 562831, 565825, 568519, 570177, 571391, 576710, 579429, 581929, 584352, 589040, 589968, 591959, 592382, 593125, 596862, 596976, 598133, 598142, 601388, 602312, 607608, 609958, 613558, 614029, 614827, 614831, 620236, 621259, 622407, 626911, 637469, 653189, 677025);

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
  387363
  388363
  391921
  411055
  419455
  424265
  431448
  432246
  435554
  439558
  440857
  445408
  448262
  451042
  453364
  467559
  468642
  470015
  471108
  473189
  475329
  480298
  482195
  510108
  510209
  515931
  517881
  519086
  520483
  520763
  523360
  524479
  525026
  526263
  527350
  528923
  530273
  535025
  543745
  544788
  547245
  549860
  558074
  558134
  562195
  562831
  565825
  568519
  570177
  571391
  576710
  579429
  581929
  584352
  589040
  589968
  591959
  592382
  593125
  596862
  596976
  598133
  598142
  601388
  602312
  607608
  609958
  613558
  614029
  614827
  614831
  620236
  621259
  622407
  626911
  637469
  653189
  677025
]

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 (387363, 388363, 391921, 411055, 419455, 424265, 431448, 432246, 435554, 439558, 440857, 445408, 448262, 451042, 453364, 467559, 468642, 470015, 471108, 473189, 475329, 480298, 482195, 510108, 510209, 515931, 517881, 519086, 520483, 520763, 523360, 524479, 525026, 526263, 527350, 528923, 530273, 535025, 543745, 544788, 547245, 549860, 558074, 558134, 562195, 562831, 565825, 568519, 570177, 571391, 576710, 579429, 581929, 584352, 589040, 589968, 591959, 592382, 593125, 596862, 596976, 598133, 598142, 601388, 602312, 607608, 609958, 613558, 614029, 614827, 614831, 620236, 621259, 622407, 626911, 637469, 653189, 677025);

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` = 'анал эротик';