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

[
  "голые сёстры"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'голые сёстры' 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
  799118
  801991
  421587
  767511
  534347
  811132
  809769
  787045
  806813
  678229
  684320
  678748
  690750
  722092
  609757
  753718
  754515
  607350
  609761
  787825
  621448
  608685
  605899
  793777
  735254
  745998
  790864
  444221
  687124
  690726
  627790
  428911
  685916
  707572
  697650
  542043
  690648
  603925
  795781
  535949
  560519
  678787
  612682
  794078
  808628
  504869
  519852
  674918
  701608
  581909
  760777
  517247
  483470
  572220
  574425
  662567
  600494
  760468
  432302
  444712
  490522
  618825
  496327
  527889
  518054
  580666
  527133
  545622
  584752
  450689
  543565
  606799
]

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 (799118, 801991, 421587, 767511, 534347, 811132, 809769, 787045, 806813, 678229, 684320, 678748, 690750, 722092, 609757, 753718, 754515, 607350, 609761, 787825, 621448, 608685, 605899, 793777, 735254, 745998, 790864, 444221, 687124, 690726, 627790, 428911, 685916, 707572, 697650, 542043, 690648, 603925, 795781, 535949, 560519, 678787, 612682, 794078, 808628, 504869, 519852, 674918, 701608, 581909, 760777, 517247, 483470, 572220, 574425, 662567, 600494, 760468, 432302, 444712, 490522, 618825, 496327, 527889, 518054, 580666, 527133, 545622, 584752, 450689, 543565, 606799);

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
  421587
  428911
  432302
  444221
  444712
  450689
  483470
  490522
  496327
  504869
  517247
  518054
  519852
  527133
  527889
  534347
  535949
  542043
  543565
  545622
  560519
  572220
  574425
  580666
  581909
  584752
  600494
  603925
  605899
  606799
  607350
  608685
  609757
  609761
  612682
  618825
  621448
  627790
  662567
  674918
  678229
  678748
  678787
  684320
  685916
  687124
  690648
  690726
  690750
  697650
  701608
  707572
  722092
  735254
  745998
  753718
  754515
  760468
  760777
  767511
  787045
  787825
  790864
  793777
  794078
  795781
  799118
  801991
  806813
  808628
  809769
  811132
]

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 (421587, 428911, 432302, 444221, 444712, 450689, 483470, 490522, 496327, 504869, 517247, 518054, 519852, 527133, 527889, 534347, 535949, 542043, 543565, 545622, 560519, 572220, 574425, 580666, 581909, 584752, 600494, 603925, 605899, 606799, 607350, 608685, 609757, 609761, 612682, 618825, 621448, 627790, 662567, 674918, 678229, 678748, 678787, 684320, 685916, 687124, 690648, 690726, 690750, 697650, 701608, 707572, 722092, 735254, 745998, 753718, 754515, 760468, 760777, 767511, 787045, 787825, 790864, 793777, 794078, 795781, 799118, 801991, 806813, 808628, 809769, 811132);

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
  421587
  428911
  432302
  444221
  444712
  450689
  483470
  490522
  496327
  504869
  517247
  518054
  519852
  527133
  527889
  534347
  535949
  542043
  543565
  545622
  560519
  572220
  574425
  580666
  581909
  584752
  600494
  603925
  605899
  606799
  607350
  608685
  609757
  609761
  612682
  618825
  621448
  627790
  662567
  674918
  678229
  678748
  678787
  684320
  685916
  687124
  690648
  690726
  690750
  697650
  701608
  707572
  722092
  735254
  745998
  753718
  754515
  760468
  760777
  767511
  787045
  787825
  790864
  793777
  794078
  795781
  799118
  801991
  806813
  808628
  809769
  811132
]

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 (421587, 428911, 432302, 444221, 444712, 450689, 483470, 490522, 496327, 504869, 517247, 518054, 519852, 527133, 527889, 534347, 535949, 542043, 543565, 545622, 560519, 572220, 574425, 580666, 581909, 584752, 600494, 603925, 605899, 606799, 607350, 608685, 609757, 609761, 612682, 618825, 621448, 627790, 662567, 674918, 678229, 678748, 678787, 684320, 685916, 687124, 690648, 690726, 690750, 697650, 701608, 707572, 722092, 735254, 745998, 753718, 754515, 760468, 760777, 767511, 787045, 787825, 790864, 793777, 794078, 795781, 799118, 801991, 806813, 808628, 809769, 811132);

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` = 'голые сестр';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "голые сёстры"
  "голые сёстры"
  "голые сёстры"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('голые сёстры') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('голые сёстры')
              AND `query` <> 'голые сёстры'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;