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

[
  "young gangbang"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'young gangbang' LIMIT 1;

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

[
  b"\x01“·×À\x12p\x05š!;\x08\h#\x08"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0193B7D7C01270059A213B085C682308 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
  457163
  530010
  539239
  530018
  537206
  559061
  567907
  576019
  543440
  574776
  634199
  616097
  805558
  748389
  457963
  484389
  518470
  527412
  533463
  541643
  545418
  624270
  628333
  598806
  637074
  406322
  814072
  823695
  462955
  461056
  514715
  531165
  534028
  536752
  537659
  546993
  649556
  674415
  674018
  602960
  389208
  473780
  422342
  474680
  474696
  452018
  484457
  530275
  532738
  536590
  537660
  530060
  530017
  551222
  560190
  603235
  477097
  485541
  562814
  562825
  585716
  609196
  615696
  618326
  696213
  556797
  730798
  401919
  514717
  536584
  540437
  653567
  406381
  540330
  517743
  591314
  620098
  530369
  520759
  521575
]

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 (457163, 530010, 539239, 530018, 537206, 559061, 567907, 576019, 543440, 574776, 634199, 616097, 805558, 748389, 457963, 484389, 518470, 527412, 533463, 541643, 545418, 624270, 628333, 598806, 637074, 406322, 814072, 823695, 462955, 461056, 514715, 531165, 534028, 536752, 537659, 546993, 649556, 674415, 674018, 602960, 389208, 473780, 422342, 474680, 474696, 452018, 484457, 530275, 532738, 536590, 537660, 530060, 530017, 551222, 560190, 603235, 477097, 485541, 562814, 562825, 585716, 609196, 615696, 618326, 696213, 556797, 730798, 401919, 514717, 536584, 540437, 653567, 406381, 540330, 517743, 591314, 620098, 530369, 520759, 521575);

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
  389208
  401919
  406322
  406381
  422342
  452018
  457163
  457963
  461056
  462955
  473780
  474680
  474696
  477097
  484389
  484457
  485541
  514715
  514717
  517743
  518470
  520759
  521575
  527412
  530010
  530017
  530018
  530060
  530275
  530369
  531165
  532738
  533463
  534028
  536584
  536590
  536752
  537206
  537659
  537660
  539239
  540330
  540437
  541643
  543440
  545418
  546993
  551222
  556797
  559061
  560190
  562814
  562825
  567907
  574776
  576019
  585716
  591314
  598806
  602960
  603235
  609196
  615696
  616097
  618326
  620098
  624270
  628333
  634199
  637074
  649556
  653567
  674018
  674415
  696213
  730798
  748389
  805558
  814072
  823695
]

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 (389208, 401919, 406322, 406381, 422342, 452018, 457163, 457963, 461056, 462955, 473780, 474680, 474696, 477097, 484389, 484457, 485541, 514715, 514717, 517743, 518470, 520759, 521575, 527412, 530010, 530017, 530018, 530060, 530275, 530369, 531165, 532738, 533463, 534028, 536584, 536590, 536752, 537206, 537659, 537660, 539239, 540330, 540437, 541643, 543440, 545418, 546993, 551222, 556797, 559061, 560190, 562814, 562825, 567907, 574776, 576019, 585716, 591314, 598806, 602960, 603235, 609196, 615696, 616097, 618326, 620098, 624270, 628333, 634199, 637074, 649556, 653567, 674018, 674415, 696213, 730798, 748389, 805558, 814072, 823695);

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
  389208
  401919
  406322
  406381
  422342
  452018
  457163
  457963
  461056
  462955
  473780
  474680
  474696
  477097
  484389
  484457
  485541
  514715
  514717
  517743
  518470
  520759
  521575
  527412
  530010
  530017
  530018
  530060
  530275
  530369
  531165
  532738
  533463
  534028
  536584
  536590
  536752
  537206
  537659
  537660
  539239
  540330
  540437
  541643
  543440
  545418
  546993
  551222
  556797
  559061
  560190
  562814
  562825
  567907
  574776
  576019
  585716
  591314
  598806
  602960
  603235
  609196
  615696
  616097
  618326
  620098
  624270
  628333
  634199
  637074
  649556
  653567
  674018
  674415
  696213
  730798
  748389
  805558
  814072
  823695
]

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 (389208, 401919, 406322, 406381, 422342, 452018, 457163, 457963, 461056, 462955, 473780, 474680, 474696, 477097, 484389, 484457, 485541, 514715, 514717, 517743, 518470, 520759, 521575, 527412, 530010, 530017, 530018, 530060, 530275, 530369, 531165, 532738, 533463, 534028, 536584, 536590, 536752, 537206, 537659, 537660, 539239, 540330, 540437, 541643, 543440, 545418, 546993, 551222, 556797, 559061, 560190, 562814, 562825, 567907, 574776, 576019, 585716, 591314, 598806, 602960, 603235, 609196, 615696, 616097, 618326, 620098, 624270, 628333, 634199, 637074, 649556, 653567, 674018, 674415, 696213, 730798, 748389, 805558, 814072, 823695);

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

[
  "young gangbang"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'young gangbang';

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

[
  "young gangbang"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'young gangbang';