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

[
  b"заглоты кончил в горлÐ…"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 0xD0B7D0B0D0B3D0BBD0BED182D18B20D0BAD0BED0BDD187D0B8D0BB20D0B220D0B3D0BED180D0BBD0E280A6 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
  504825
  589356
  520600
  508539
  545273
  492245
  551131
  668360
  602031
  581766
  600863
  599080
  560155
  591909
  598861
  500907
  554825
  545262
  651913
  588237
  623031
  568914
  511464
  581091
  651836
  626388
  602935
  644065
  679224
  621767
  585984
  626367
  523255
  569778
  582012
  537253
  499034
  524299
  659407
  606888
  501329
  537247
  524926
  586616
  508974
  523868
  672469
  591729
  678801
  621796
  559801
  517788
  600503
  546808
  623849
  647975
  533950
  571674
  580264
  595080
  468098
  583670
  624921
  625950
  497447
  558951
  545382
  556030
  604960
  609165
  649960
  606577
  504085
  545363
  521002
  674982
  601162
  524628
  530808
  647898
  538963
  530382
  642662
]

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 (504825, 589356, 520600, 508539, 545273, 492245, 551131, 668360, 602031, 581766, 600863, 599080, 560155, 591909, 598861, 500907, 554825, 545262, 651913, 588237, 623031, 568914, 511464, 581091, 651836, 626388, 602935, 644065, 679224, 621767, 585984, 626367, 523255, 569778, 582012, 537253, 499034, 524299, 659407, 606888, 501329, 537247, 524926, 586616, 508974, 523868, 672469, 591729, 678801, 621796, 559801, 517788, 600503, 546808, 623849, 647975, 533950, 571674, 580264, 595080, 468098, 583670, 624921, 625950, 497447, 558951, 545382, 556030, 604960, 609165, 649960, 606577, 504085, 545363, 521002, 674982, 601162, 524628, 530808, 647898, 538963, 530382, 642662);

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
  468098
  492245
  497447
  499034
  500907
  501329
  504085
  504825
  508539
  508974
  511464
  517788
  520600
  521002
  523255
  523868
  524299
  524628
  524926
  530382
  530808
  533950
  537247
  537253
  538963
  545262
  545273
  545363
  545382
  546808
  551131
  554825
  556030
  558951
  559801
  560155
  568914
  569778
  571674
  580264
  581091
  581766
  582012
  583670
  585984
  586616
  588237
  589356
  591729
  591909
  595080
  598861
  599080
  600503
  600863
  601162
  602031
  602935
  604960
  606577
  606888
  609165
  621767
  621796
  623031
  623849
  624921
  625950
  626367
  626388
  642662
  644065
  647898
  647975
  649960
  651836
  651913
  659407
  668360
  672469
  674982
  678801
  679224
]

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 (468098, 492245, 497447, 499034, 500907, 501329, 504085, 504825, 508539, 508974, 511464, 517788, 520600, 521002, 523255, 523868, 524299, 524628, 524926, 530382, 530808, 533950, 537247, 537253, 538963, 545262, 545273, 545363, 545382, 546808, 551131, 554825, 556030, 558951, 559801, 560155, 568914, 569778, 571674, 580264, 581091, 581766, 582012, 583670, 585984, 586616, 588237, 589356, 591729, 591909, 595080, 598861, 599080, 600503, 600863, 601162, 602031, 602935, 604960, 606577, 606888, 609165, 621767, 621796, 623031, 623849, 624921, 625950, 626367, 626388, 642662, 644065, 647898, 647975, 649960, 651836, 651913, 659407, 668360, 672469, 674982, 678801, 679224);

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
  468098
  492245
  497447
  499034
  500907
  501329
  504085
  504825
  508539
  508974
  511464
  517788
  520600
  521002
  523255
  523868
  524299
  524628
  524926
  530382
  530808
  533950
  537247
  537253
  538963
  545262
  545273
  545363
  545382
  546808
  551131
  554825
  556030
  558951
  559801
  560155
  568914
  569778
  571674
  580264
  581091
  581766
  582012
  583670
  585984
  586616
  588237
  589356
  591729
  591909
  595080
  598861
  599080
  600503
  600863
  601162
  602031
  602935
  604960
  606577
  606888
  609165
  621767
  621796
  623031
  623849
  624921
  625950
  626367
  626388
  642662
  644065
  647898
  647975
  649960
  651836
  651913
  659407
  668360
  672469
  674982
  678801
  679224
]

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 (468098, 492245, 497447, 499034, 500907, 501329, 504085, 504825, 508539, 508974, 511464, 517788, 520600, 521002, 523255, 523868, 524299, 524628, 524926, 530382, 530808, 533950, 537247, 537253, 538963, 545262, 545273, 545363, 545382, 546808, 551131, 554825, 556030, 558951, 559801, 560155, 568914, 569778, 571674, 580264, 581091, 581766, 582012, 583670, 585984, 586616, 588237, 589356, 591729, 591909, 595080, 598861, 599080, 600503, 600863, 601162, 602031, 602935, 604960, 606577, 606888, 609165, 621767, 621796, 623031, 623849, 624921, 625950, 626367, 626388, 642662, 644065, 647898, 647975, 649960, 651836, 651913, 659407, 668360, 672469, 674982, 678801, 679224);

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` = 'заглот сперм в горл';