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

[
  "секс пятеро"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс пятеро' 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
  449633
  633819
  632588
  634790
  437511
  628208
  486860
  436230
  676641
  599847
  544455
  674975
  632707
  633126
  531136
  531097
  676089
  569922
  600029
  633742
  601595
  632663
  477707
  666863
  512927
  592188
  422960
  428554
  652544
  596652
  531117
  532816
  543652
  499104
  532245
  537864
  541848
  634115
  637001
  614308
  646427
  581481
  630635
  632678
  502279
  642706
  484463
  598172
  663569
  581968
  532643
  676020
  679801
  634140
  628383
  639719
  637148
  593799
  518490
  532789
  514577
  621527
  610419
  447089
  538803
  620001
  597866
  526808
  521863
  617421
  515568
  654422
  617423
  517345
  556405
  477773
  395696
  598865
  627652
  530369
  520759
]

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 (449633, 633819, 632588, 634790, 437511, 628208, 486860, 436230, 676641, 599847, 544455, 674975, 632707, 633126, 531136, 531097, 676089, 569922, 600029, 633742, 601595, 632663, 477707, 666863, 512927, 592188, 422960, 428554, 652544, 596652, 531117, 532816, 543652, 499104, 532245, 537864, 541848, 634115, 637001, 614308, 646427, 581481, 630635, 632678, 502279, 642706, 484463, 598172, 663569, 581968, 532643, 676020, 679801, 634140, 628383, 639719, 637148, 593799, 518490, 532789, 514577, 621527, 610419, 447089, 538803, 620001, 597866, 526808, 521863, 617421, 515568, 654422, 617423, 517345, 556405, 477773, 395696, 598865, 627652, 530369, 520759);

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
  395696
  422960
  428554
  436230
  437511
  447089
  449633
  477707
  477773
  484463
  486860
  499104
  502279
  512927
  514577
  515568
  517345
  518490
  520759
  521863
  526808
  530369
  531097
  531117
  531136
  532245
  532643
  532789
  532816
  537864
  538803
  541848
  543652
  544455
  556405
  569922
  581481
  581968
  592188
  593799
  596652
  597866
  598172
  598865
  599847
  600029
  601595
  610419
  614308
  617421
  617423
  620001
  621527
  627652
  628208
  628383
  630635
  632588
  632663
  632678
  632707
  633126
  633742
  633819
  634115
  634140
  634790
  637001
  637148
  639719
  642706
  646427
  652544
  654422
  663569
  666863
  674975
  676020
  676089
  676641
  679801
]

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 (395696, 422960, 428554, 436230, 437511, 447089, 449633, 477707, 477773, 484463, 486860, 499104, 502279, 512927, 514577, 515568, 517345, 518490, 520759, 521863, 526808, 530369, 531097, 531117, 531136, 532245, 532643, 532789, 532816, 537864, 538803, 541848, 543652, 544455, 556405, 569922, 581481, 581968, 592188, 593799, 596652, 597866, 598172, 598865, 599847, 600029, 601595, 610419, 614308, 617421, 617423, 620001, 621527, 627652, 628208, 628383, 630635, 632588, 632663, 632678, 632707, 633126, 633742, 633819, 634115, 634140, 634790, 637001, 637148, 639719, 642706, 646427, 652544, 654422, 663569, 666863, 674975, 676020, 676089, 676641, 679801);

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
  395696
  422960
  428554
  436230
  437511
  447089
  449633
  477707
  477773
  484463
  486860
  499104
  502279
  512927
  514577
  515568
  517345
  518490
  520759
  521863
  526808
  530369
  531097
  531117
  531136
  532245
  532643
  532789
  532816
  537864
  538803
  541848
  543652
  544455
  556405
  569922
  581481
  581968
  592188
  593799
  596652
  597866
  598172
  598865
  599847
  600029
  601595
  610419
  614308
  617421
  617423
  620001
  621527
  627652
  628208
  628383
  630635
  632588
  632663
  632678
  632707
  633126
  633742
  633819
  634115
  634140
  634790
  637001
  637148
  639719
  642706
  646427
  652544
  654422
  663569
  666863
  674975
  676020
  676089
  676641
  679801
]

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 (395696, 422960, 428554, 436230, 437511, 447089, 449633, 477707, 477773, 484463, 486860, 499104, 502279, 512927, 514577, 515568, 517345, 518490, 520759, 521863, 526808, 530369, 531097, 531117, 531136, 532245, 532643, 532789, 532816, 537864, 538803, 541848, 543652, 544455, 556405, 569922, 581481, 581968, 592188, 593799, 596652, 597866, 598172, 598865, 599847, 600029, 601595, 610419, 614308, 617421, 617423, 620001, 621527, 627652, 628208, 628383, 630635, 632588, 632663, 632678, 632707, 633126, 633742, 633819, 634115, 634140, 634790, 637001, 637148, 639719, 642706, 646427, 652544, 654422, 663569, 666863, 674975, 676020, 676089, 676641, 679801);

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` = 'секс пят';