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

[
  "ass pants"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'ass pants' 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
  448465
  440671
  416474
  455565
  503429
  501203
  546320
  675703
  632790
  449499
  437996
  456328
  514842
  520590
  541345
  481362
  463608
  522320
  506006
  675107
  601892
  458331
  463581
  472806
  500067
  514377
  487628
  510252
  484300
  526933
  451118
  568445
  584611
  554129
  595582
  449270
  459694
  478371
  529306
  463561
  516496
  524753
  675725
  459016
  463544
  481925
  509747
  492088
  511914
  580223
  565013
  463597
  451002
  454440
  463368
  598763
  600466
  453402
  483039
  512121
  459873
  549872
  609881
  587453
  493902
  444617
  439783
  471464
  533965
  418361
  506590
  498033
  516874
  500506
  555832
  424254
  516991
  510194
  440623
  522105
  482622
  577931
  463587
  509712
]

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 (448465, 440671, 416474, 455565, 503429, 501203, 546320, 675703, 632790, 449499, 437996, 456328, 514842, 520590, 541345, 481362, 463608, 522320, 506006, 675107, 601892, 458331, 463581, 472806, 500067, 514377, 487628, 510252, 484300, 526933, 451118, 568445, 584611, 554129, 595582, 449270, 459694, 478371, 529306, 463561, 516496, 524753, 675725, 459016, 463544, 481925, 509747, 492088, 511914, 580223, 565013, 463597, 451002, 454440, 463368, 598763, 600466, 453402, 483039, 512121, 459873, 549872, 609881, 587453, 493902, 444617, 439783, 471464, 533965, 418361, 506590, 498033, 516874, 500506, 555832, 424254, 516991, 510194, 440623, 522105, 482622, 577931, 463587, 509712);

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
  416474
  418361
  424254
  437996
  439783
  440623
  440671
  444617
  448465
  449270
  449499
  451002
  451118
  453402
  454440
  455565
  456328
  458331
  459016
  459694
  459873
  463368
  463544
  463561
  463581
  463587
  463597
  463608
  471464
  472806
  481362
  481925
  482622
  483039
  484300
  487628
  492088
  493902
  498033
  500067
  500506
  501203
  503429
  506006
  506590
  509712
  509747
  510194
  510252
  511914
  512121
  514377
  514842
  516496
  516874
  516991
  520590
  522105
  522320
  524753
  526933
  529306
  533965
  546320
  549872
  554129
  555832
  565013
  568445
  577931
  580223
  584611
  587453
  595582
  598763
  600466
  601892
  609881
  632790
  675107
  675703
  675725
]

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 (416474, 418361, 424254, 437996, 439783, 440623, 440671, 444617, 448465, 449270, 449499, 451002, 451118, 453402, 454440, 455565, 456328, 458331, 459016, 459694, 459873, 463368, 463544, 463561, 463581, 463587, 463597, 463608, 471464, 472806, 481362, 481925, 482622, 483039, 484300, 487628, 492088, 493902, 498033, 500067, 500506, 501203, 503429, 506006, 506590, 509712, 509747, 510194, 510252, 511914, 512121, 514377, 514842, 516496, 516874, 516991, 520590, 522105, 522320, 524753, 526933, 529306, 533965, 546320, 549872, 554129, 555832, 565013, 568445, 577931, 580223, 584611, 587453, 595582, 598763, 600466, 601892, 609881, 632790, 675107, 675703, 675725);

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
  416474
  418361
  424254
  437996
  439783
  440623
  440671
  444617
  448465
  449270
  449499
  451002
  451118
  453402
  454440
  455565
  456328
  458331
  459016
  459694
  459873
  463368
  463544
  463561
  463581
  463587
  463597
  463608
  471464
  472806
  481362
  481925
  482622
  483039
  484300
  487628
  492088
  493902
  498033
  500067
  500506
  501203
  503429
  506006
  506590
  509712
  509747
  510194
  510252
  511914
  512121
  514377
  514842
  516496
  516874
  516991
  520590
  522105
  522320
  524753
  526933
  529306
  533965
  546320
  549872
  554129
  555832
  565013
  568445
  577931
  580223
  584611
  587453
  595582
  598763
  600466
  601892
  609881
  632790
  675107
  675703
  675725
]

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 (416474, 418361, 424254, 437996, 439783, 440623, 440671, 444617, 448465, 449270, 449499, 451002, 451118, 453402, 454440, 455565, 456328, 458331, 459016, 459694, 459873, 463368, 463544, 463561, 463581, 463587, 463597, 463608, 471464, 472806, 481362, 481925, 482622, 483039, 484300, 487628, 492088, 493902, 498033, 500067, 500506, 501203, 503429, 506006, 506590, 509712, 509747, 510194, 510252, 511914, 512121, 514377, 514842, 516496, 516874, 516991, 520590, 522105, 522320, 524753, 526933, 529306, 533965, 546320, 549872, 554129, 555832, 565013, 568445, 577931, 580223, 584611, 587453, 595582, 598763, 600466, 601892, 609881, 632790, 675107, 675703, 675725);

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

[
  "жоп pants"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'жоп pants';

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

[
  "жоп pants"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'жоп pants';