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
  781516
  499169
  619720
  639197
  509545
  801940
  780479
  590042
  730840
  647805
  722841
  635122
  715457
  632467
  734445
  402243
  446226
  567764
  458909
  520883
  393761
  457522
  473011
  556636
  443757
  549406
  656371
  570534
  529250
  653463
  584636
  598486
  547423
  569835
  588532
  630859
  600149
  634532
  551165
  584712
  596608
  620203
  609933
  614991
  406075
  536925
  511770
  528040
  563007
  565322
  546347
  659325
  679567
  548696
  595243
  618923
  613934
  615833
  620667
  405804
  469462
  510299
  535338
  488596
  545667
  601314
  591706
  605996
  599191
  538848
  520672
  415160
]

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 (781516, 499169, 619720, 639197, 509545, 801940, 780479, 590042, 730840, 647805, 722841, 635122, 715457, 632467, 734445, 402243, 446226, 567764, 458909, 520883, 393761, 457522, 473011, 556636, 443757, 549406, 656371, 570534, 529250, 653463, 584636, 598486, 547423, 569835, 588532, 630859, 600149, 634532, 551165, 584712, 596608, 620203, 609933, 614991, 406075, 536925, 511770, 528040, 563007, 565322, 546347, 659325, 679567, 548696, 595243, 618923, 613934, 615833, 620667, 405804, 469462, 510299, 535338, 488596, 545667, 601314, 591706, 605996, 599191, 538848, 520672, 415160);

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
  393761
  402243
  405804
  406075
  415160
  443757
  446226
  457522
  458909
  469462
  473011
  488596
  499169
  509545
  510299
  511770
  520672
  520883
  528040
  529250
  535338
  536925
  538848
  545667
  546347
  547423
  548696
  549406
  551165
  556636
  563007
  565322
  567764
  569835
  570534
  584636
  584712
  588532
  590042
  591706
  595243
  596608
  598486
  599191
  600149
  601314
  605996
  609933
  613934
  614991
  615833
  618923
  619720
  620203
  620667
  630859
  632467
  634532
  635122
  639197
  647805
  653463
  656371
  659325
  679567
  715457
  722841
  730840
  734445
  780479
  781516
  801940
]

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 (393761, 402243, 405804, 406075, 415160, 443757, 446226, 457522, 458909, 469462, 473011, 488596, 499169, 509545, 510299, 511770, 520672, 520883, 528040, 529250, 535338, 536925, 538848, 545667, 546347, 547423, 548696, 549406, 551165, 556636, 563007, 565322, 567764, 569835, 570534, 584636, 584712, 588532, 590042, 591706, 595243, 596608, 598486, 599191, 600149, 601314, 605996, 609933, 613934, 614991, 615833, 618923, 619720, 620203, 620667, 630859, 632467, 634532, 635122, 639197, 647805, 653463, 656371, 659325, 679567, 715457, 722841, 730840, 734445, 780479, 781516, 801940);

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
  393761
  402243
  405804
  406075
  415160
  443757
  446226
  457522
  458909
  469462
  473011
  488596
  499169
  509545
  510299
  511770
  520672
  520883
  528040
  529250
  535338
  536925
  538848
  545667
  546347
  547423
  548696
  549406
  551165
  556636
  563007
  565322
  567764
  569835
  570534
  584636
  584712
  588532
  590042
  591706
  595243
  596608
  598486
  599191
  600149
  601314
  605996
  609933
  613934
  614991
  615833
  618923
  619720
  620203
  620667
  630859
  632467
  634532
  635122
  639197
  647805
  653463
  656371
  659325
  679567
  715457
  722841
  730840
  734445
  780479
  781516
  801940
]

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 (393761, 402243, 405804, 406075, 415160, 443757, 446226, 457522, 458909, 469462, 473011, 488596, 499169, 509545, 510299, 511770, 520672, 520883, 528040, 529250, 535338, 536925, 538848, 545667, 546347, 547423, 548696, 549406, 551165, 556636, 563007, 565322, 567764, 569835, 570534, 584636, 584712, 588532, 590042, 591706, 595243, 596608, 598486, 599191, 600149, 601314, 605996, 609933, 613934, 614991, 615833, 618923, 619720, 620203, 620667, 630859, 632467, 634532, 635122, 639197, 647805, 653463, 656371, 659325, 679567, 715457, 722841, 730840, 734445, 780479, 781516, 801940);

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
        ;