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` = 0xD0BAD0B8D182D0B0D0B9D181D0BAD0B0D18F20D18120D0B1D0BED0BBD18CD188D0B8D0BCD0B820D1E280A6 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
  419906
  586639
  458094
  423196
  595252
  421298
  776932
  425823
  475443
  461899
  536652
  583491
  771236
  424726
  420658
  458384
  557211
  458623
  802111
  504963
  418323
  813803
  568034
  557209
  813787
  528316
  482824
  558578
  779560
  801890
  771308
  527484
  676241
  778383
  803268
  510266
  574033
  815137
  682936
  634215
  437828
  422746
  546085
  589769
  695725
  785525
  531083
  752596
  590859
  815096
  649559
  757362
  541854
  534023
  581185
  754135
  459524
  614603
  447273
  497656
  541084
  609121
  598133
  457981
  546783
  756113
  538653
  677712
  665781
  754168
  544964
  628170
  562149
  567357
  541849
  541863
  623261
]

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 (419906, 586639, 458094, 423196, 595252, 421298, 776932, 425823, 475443, 461899, 536652, 583491, 771236, 424726, 420658, 458384, 557211, 458623, 802111, 504963, 418323, 813803, 568034, 557209, 813787, 528316, 482824, 558578, 779560, 801890, 771308, 527484, 676241, 778383, 803268, 510266, 574033, 815137, 682936, 634215, 437828, 422746, 546085, 589769, 695725, 785525, 531083, 752596, 590859, 815096, 649559, 757362, 541854, 534023, 581185, 754135, 459524, 614603, 447273, 497656, 541084, 609121, 598133, 457981, 546783, 756113, 538653, 677712, 665781, 754168, 544964, 628170, 562149, 567357, 541849, 541863, 623261);

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
  418323
  419906
  420658
  421298
  422746
  423196
  424726
  425823
  437828
  447273
  457981
  458094
  458384
  458623
  459524
  461899
  475443
  482824
  497656
  504963
  510266
  527484
  528316
  531083
  534023
  536652
  538653
  541084
  541849
  541854
  541863
  544964
  546085
  546783
  557209
  557211
  558578
  562149
  567357
  568034
  574033
  581185
  583491
  586639
  589769
  590859
  595252
  598133
  609121
  614603
  623261
  628170
  634215
  649559
  665781
  676241
  677712
  682936
  695725
  752596
  754135
  754168
  756113
  757362
  771236
  771308
  776932
  778383
  779560
  785525
  801890
  802111
  803268
  813787
  813803
  815096
  815137
]

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 (418323, 419906, 420658, 421298, 422746, 423196, 424726, 425823, 437828, 447273, 457981, 458094, 458384, 458623, 459524, 461899, 475443, 482824, 497656, 504963, 510266, 527484, 528316, 531083, 534023, 536652, 538653, 541084, 541849, 541854, 541863, 544964, 546085, 546783, 557209, 557211, 558578, 562149, 567357, 568034, 574033, 581185, 583491, 586639, 589769, 590859, 595252, 598133, 609121, 614603, 623261, 628170, 634215, 649559, 665781, 676241, 677712, 682936, 695725, 752596, 754135, 754168, 756113, 757362, 771236, 771308, 776932, 778383, 779560, 785525, 801890, 802111, 803268, 813787, 813803, 815096, 815137);

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
  418323
  419906
  420658
  421298
  422746
  423196
  424726
  425823
  437828
  447273
  457981
  458094
  458384
  458623
  459524
  461899
  475443
  482824
  497656
  504963
  510266
  527484
  528316
  531083
  534023
  536652
  538653
  541084
  541849
  541854
  541863
  544964
  546085
  546783
  557209
  557211
  558578
  562149
  567357
  568034
  574033
  581185
  583491
  586639
  589769
  590859
  595252
  598133
  609121
  614603
  623261
  628170
  634215
  649559
  665781
  676241
  677712
  682936
  695725
  752596
  754135
  754168
  756113
  757362
  771236
  771308
  776932
  778383
  779560
  785525
  801890
  802111
  803268
  813787
  813803
  815096
  815137
]

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 (418323, 419906, 420658, 421298, 422746, 423196, 424726, 425823, 437828, 447273, 457981, 458094, 458384, 458623, 459524, 461899, 475443, 482824, 497656, 504963, 510266, 527484, 528316, 531083, 534023, 536652, 538653, 541084, 541849, 541854, 541863, 544964, 546085, 546783, 557209, 557211, 558578, 562149, 567357, 568034, 574033, 581185, 583491, 586639, 589769, 590859, 595252, 598133, 609121, 614603, 623261, 628170, 634215, 649559, 665781, 676241, 677712, 682936, 695725, 752596, 754135, 754168, 756113, 757362, 771236, 771308, 776932, 778383, 779560, 785525, 801890, 802111, 803268, 813787, 813803, 815096, 815137);

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` = 'китаянк азиатк большие';