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

[
  "hairy gangbang"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hairy gangbang' 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
  396600
  420190
  437519
  814865
  531157
  527428
  464162
  486182
  559060
  559061
  574204
  541605
  561351
  581682
  666899
  653447
  647885
  565253
  572544
  581695
  634145
  592440
  637031
  748389
  614401
  417344
  457963
  517842
  444654
  410959
  814934
  815017
  551997
  546993
  668549
  674368
  651599
  666901
  646786
  650127
  603259
  631972
  586524
  605612
  587098
  630526
  603247
  389208
  430436
  417482
  474680
  391386
  454802
  510198
  571674
  581902
  566252
  662137
  560190
  642063
  756395
  639292
  445737
  421093
  403141
  531117
  556797
  606577
  643103
  401919
  591882
  613174
  625423
  406381
  562825
  541643
  591314
  598806
  635275
  609196
  516842
]

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 (396600, 420190, 437519, 814865, 531157, 527428, 464162, 486182, 559060, 559061, 574204, 541605, 561351, 581682, 666899, 653447, 647885, 565253, 572544, 581695, 634145, 592440, 637031, 748389, 614401, 417344, 457963, 517842, 444654, 410959, 814934, 815017, 551997, 546993, 668549, 674368, 651599, 666901, 646786, 650127, 603259, 631972, 586524, 605612, 587098, 630526, 603247, 389208, 430436, 417482, 474680, 391386, 454802, 510198, 571674, 581902, 566252, 662137, 560190, 642063, 756395, 639292, 445737, 421093, 403141, 531117, 556797, 606577, 643103, 401919, 591882, 613174, 625423, 406381, 562825, 541643, 591314, 598806, 635275, 609196, 516842);

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
  391386
  396600
  401919
  403141
  406381
  410959
  417344
  417482
  420190
  421093
  430436
  437519
  444654
  445737
  454802
  457963
  464162
  474680
  486182
  510198
  516842
  517842
  527428
  531117
  531157
  541605
  541643
  546993
  551997
  556797
  559060
  559061
  560190
  561351
  562825
  565253
  566252
  571674
  572544
  574204
  581682
  581695
  581902
  586524
  587098
  591314
  591882
  592440
  598806
  603247
  603259
  605612
  606577
  609196
  613174
  614401
  625423
  630526
  631972
  634145
  635275
  637031
  639292
  642063
  643103
  646786
  647885
  650127
  651599
  653447
  662137
  666899
  666901
  668549
  674368
  748389
  756395
  814865
  814934
  815017
]

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, 391386, 396600, 401919, 403141, 406381, 410959, 417344, 417482, 420190, 421093, 430436, 437519, 444654, 445737, 454802, 457963, 464162, 474680, 486182, 510198, 516842, 517842, 527428, 531117, 531157, 541605, 541643, 546993, 551997, 556797, 559060, 559061, 560190, 561351, 562825, 565253, 566252, 571674, 572544, 574204, 581682, 581695, 581902, 586524, 587098, 591314, 591882, 592440, 598806, 603247, 603259, 605612, 606577, 609196, 613174, 614401, 625423, 630526, 631972, 634145, 635275, 637031, 639292, 642063, 643103, 646786, 647885, 650127, 651599, 653447, 662137, 666899, 666901, 668549, 674368, 748389, 756395, 814865, 814934, 815017);

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
  391386
  396600
  401919
  403141
  406381
  410959
  417344
  417482
  420190
  421093
  430436
  437519
  444654
  445737
  454802
  457963
  464162
  474680
  486182
  510198
  516842
  517842
  527428
  531117
  531157
  541605
  541643
  546993
  551997
  556797
  559060
  559061
  560190
  561351
  562825
  565253
  566252
  571674
  572544
  574204
  581682
  581695
  581902
  586524
  587098
  591314
  591882
  592440
  598806
  603247
  603259
  605612
  606577
  609196
  613174
  614401
  625423
  630526
  631972
  634145
  635275
  637031
  639292
  642063
  643103
  646786
  647885
  650127
  651599
  653447
  662137
  666899
  666901
  668549
  674368
  748389
  756395
  814865
  814934
  815017
]

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, 391386, 396600, 401919, 403141, 406381, 410959, 417344, 417482, 420190, 421093, 430436, 437519, 444654, 445737, 454802, 457963, 464162, 474680, 486182, 510198, 516842, 517842, 527428, 531117, 531157, 541605, 541643, 546993, 551997, 556797, 559060, 559061, 560190, 561351, 562825, 565253, 566252, 571674, 572544, 574204, 581682, 581695, 581902, 586524, 587098, 591314, 591882, 592440, 598806, 603247, 603259, 605612, 606577, 609196, 613174, 614401, 625423, 630526, 631972, 634145, 635275, 637031, 639292, 642063, 643103, 646786, 647885, 650127, 651599, 653447, 662137, 666899, 666901, 668549, 674368, 748389, 756395, 814865, 814934, 815017);

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

[
  "волосатая gangbang"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'волосатая gangbang';

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

[
  "волосатая gangbang"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'волосатая gangbang';