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

[
  "cuckold hidden"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cuckold hidden' LIMIT 1;

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

[
  b"\x01öp)‗Éqë│l=uµ3Í9"
]

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x01947029F2907189B36C3D75E633D639 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
  464503
  476414
  501912
  594576
  733158
  450935
  488219
  730665
  458791
  455768
  523121
  504756
  526227
  544958
  554414
  579742
  563639
  578790
  584641
  572241
  586469
  619317
  435746
  472309
  511153
  623813
  462262
  451779
  500469
  521510
  525137
  556684
  677881
  548754
  561391
  607146
  615394
  461436
  484477
  562590
  732616
  470628
  586562
  632405
  568180
  732838
  508510
  500482
  510157
  522423
  795039
  462904
  451090
  479378
  579853
  584166
  555653
  641564
  556865
  448319
  468942
  589745
  626327
  627063
  479394
  577428
  699399
  655431
  555969
  649211
  632924
  735869
  734385
  496591
  462950
  496397
  504158
  451973
  504757
  576248
  621348
  504759
  504768
]

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 (464503, 476414, 501912, 594576, 733158, 450935, 488219, 730665, 458791, 455768, 523121, 504756, 526227, 544958, 554414, 579742, 563639, 578790, 584641, 572241, 586469, 619317, 435746, 472309, 511153, 623813, 462262, 451779, 500469, 521510, 525137, 556684, 677881, 548754, 561391, 607146, 615394, 461436, 484477, 562590, 732616, 470628, 586562, 632405, 568180, 732838, 508510, 500482, 510157, 522423, 795039, 462904, 451090, 479378, 579853, 584166, 555653, 641564, 556865, 448319, 468942, 589745, 626327, 627063, 479394, 577428, 699399, 655431, 555969, 649211, 632924, 735869, 734385, 496591, 462950, 496397, 504158, 451973, 504757, 576248, 621348, 504759, 504768);

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
  435746
  448319
  450935
  451090
  451779
  451973
  455768
  458791
  461436
  462262
  462904
  462950
  464503
  468942
  470628
  472309
  476414
  479378
  479394
  484477
  488219
  496397
  496591
  500469
  500482
  501912
  504158
  504756
  504757
  504759
  504768
  508510
  510157
  511153
  521510
  522423
  523121
  525137
  526227
  544958
  548754
  554414
  555653
  555969
  556684
  556865
  561391
  562590
  563639
  568180
  572241
  576248
  577428
  578790
  579742
  579853
  584166
  584641
  586469
  586562
  589745
  594576
  607146
  615394
  619317
  621348
  623813
  626327
  627063
  632405
  632924
  641564
  649211
  655431
  677881
  699399
  730665
  732616
  732838
  733158
  734385
  735869
  795039
]

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 (435746, 448319, 450935, 451090, 451779, 451973, 455768, 458791, 461436, 462262, 462904, 462950, 464503, 468942, 470628, 472309, 476414, 479378, 479394, 484477, 488219, 496397, 496591, 500469, 500482, 501912, 504158, 504756, 504757, 504759, 504768, 508510, 510157, 511153, 521510, 522423, 523121, 525137, 526227, 544958, 548754, 554414, 555653, 555969, 556684, 556865, 561391, 562590, 563639, 568180, 572241, 576248, 577428, 578790, 579742, 579853, 584166, 584641, 586469, 586562, 589745, 594576, 607146, 615394, 619317, 621348, 623813, 626327, 627063, 632405, 632924, 641564, 649211, 655431, 677881, 699399, 730665, 732616, 732838, 733158, 734385, 735869, 795039);

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
  435746
  448319
  450935
  451090
  451779
  451973
  455768
  458791
  461436
  462262
  462904
  462950
  464503
  468942
  470628
  472309
  476414
  479378
  479394
  484477
  488219
  496397
  496591
  500469
  500482
  501912
  504158
  504756
  504757
  504759
  504768
  508510
  510157
  511153
  521510
  522423
  523121
  525137
  526227
  544958
  548754
  554414
  555653
  555969
  556684
  556865
  561391
  562590
  563639
  568180
  572241
  576248
  577428
  578790
  579742
  579853
  584166
  584641
  586469
  586562
  589745
  594576
  607146
  615394
  619317
  621348
  623813
  626327
  627063
  632405
  632924
  641564
  649211
  655431
  677881
  699399
  730665
  732616
  732838
  733158
  734385
  735869
  795039
]

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 (435746, 448319, 450935, 451090, 451779, 451973, 455768, 458791, 461436, 462262, 462904, 462950, 464503, 468942, 470628, 472309, 476414, 479378, 479394, 484477, 488219, 496397, 496591, 500469, 500482, 501912, 504158, 504756, 504757, 504759, 504768, 508510, 510157, 511153, 521510, 522423, 523121, 525137, 526227, 544958, 548754, 554414, 555653, 555969, 556684, 556865, 561391, 562590, 563639, 568180, 572241, 576248, 577428, 578790, 579742, 579853, 584166, 584641, 586469, 586562, 589745, 594576, 607146, 615394, 619317, 621348, 623813, 626327, 627063, 632405, 632924, 641564, 649211, 655431, 677881, 699399, 730665, 732616, 732838, 733158, 734385, 735869, 795039);

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` = 'куколд скрыт';