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

[
  "sex in movies"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sex in movies' 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
  743011
  573708
  573076
  573627
  551358
  573702
  573866
  308783
  573067
  536278
  652879
  573081
  501652
  573555
  826933
  573104
  387722
  730479
  525406
  786402
  724732
  629374
  819673
  389585
  571630
  387868
  387773
  387823
  621695
  810336
  827611
  568259
  522344
  427258
  707506
  565941
  689000
  573559
  573083
  429337
  679471
  586965
  811621
  797532
  800895
  636819
  549422
  654846
  427218
  809346
  538368
  726517
  665990
  813526
  483243
  598840
  809308
  434185
  577386
  526073
  622981
  582590
  712775
  615726
  571241
  576628
  521367
  435424
  629296
  602614
  541614
  629021
  541924
]

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 (743011, 573708, 573076, 573627, 551358, 573702, 573866, 308783, 573067, 536278, 652879, 573081, 501652, 573555, 826933, 573104, 387722, 730479, 525406, 786402, 724732, 629374, 819673, 389585, 571630, 387868, 387773, 387823, 621695, 810336, 827611, 568259, 522344, 427258, 707506, 565941, 689000, 573559, 573083, 429337, 679471, 586965, 811621, 797532, 800895, 636819, 549422, 654846, 427218, 809346, 538368, 726517, 665990, 813526, 483243, 598840, 809308, 434185, 577386, 526073, 622981, 582590, 712775, 615726, 571241, 576628, 521367, 435424, 629296, 602614, 541614, 629021, 541924);

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
  308783
  387722
  387773
  387823
  387868
  389585
  427218
  427258
  429337
  434185
  435424
  483243
  501652
  521367
  522344
  525406
  526073
  536278
  538368
  541614
  541924
  549422
  551358
  565941
  568259
  571241
  571630
  573067
  573076
  573081
  573083
  573104
  573555
  573559
  573627
  573702
  573708
  573866
  576628
  577386
  582590
  586965
  598840
  602614
  615726
  621695
  622981
  629021
  629296
  629374
  636819
  652879
  654846
  665990
  679471
  689000
  707506
  712775
  724732
  726517
  730479
  743011
  786402
  797532
  800895
  809308
  809346
  810336
  811621
  813526
  819673
  826933
  827611
]

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 (308783, 387722, 387773, 387823, 387868, 389585, 427218, 427258, 429337, 434185, 435424, 483243, 501652, 521367, 522344, 525406, 526073, 536278, 538368, 541614, 541924, 549422, 551358, 565941, 568259, 571241, 571630, 573067, 573076, 573081, 573083, 573104, 573555, 573559, 573627, 573702, 573708, 573866, 576628, 577386, 582590, 586965, 598840, 602614, 615726, 621695, 622981, 629021, 629296, 629374, 636819, 652879, 654846, 665990, 679471, 689000, 707506, 712775, 724732, 726517, 730479, 743011, 786402, 797532, 800895, 809308, 809346, 810336, 811621, 813526, 819673, 826933, 827611);

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
  308783
  387722
  387773
  387823
  387868
  389585
  427218
  427258
  429337
  434185
  435424
  483243
  501652
  521367
  522344
  525406
  526073
  536278
  538368
  541614
  541924
  549422
  551358
  565941
  568259
  571241
  571630
  573067
  573076
  573081
  573083
  573104
  573555
  573559
  573627
  573702
  573708
  573866
  576628
  577386
  582590
  586965
  598840
  602614
  615726
  621695
  622981
  629021
  629296
  629374
  636819
  652879
  654846
  665990
  679471
  689000
  707506
  712775
  724732
  726517
  730479
  743011
  786402
  797532
  800895
  809308
  809346
  810336
  811621
  813526
  819673
  826933
  827611
]

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 (308783, 387722, 387773, 387823, 387868, 389585, 427218, 427258, 429337, 434185, 435424, 483243, 501652, 521367, 522344, 525406, 526073, 536278, 538368, 541614, 541924, 549422, 551358, 565941, 568259, 571241, 571630, 573067, 573076, 573081, 573083, 573104, 573555, 573559, 573627, 573702, 573708, 573866, 576628, 577386, 582590, 586965, 598840, 602614, 615726, 621695, 622981, 629021, 629296, 629374, 636819, 652879, 654846, 665990, 679471, 689000, 707506, 712775, 724732, 726517, 730479, 743011, 786402, 797532, 800895, 809308, 809346, 810336, 811621, 813526, 819673, 826933, 827611);

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

[
  "секс movies"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'секс movies';

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

[
  "секс movies"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс movies';

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 ?

[
  "sex in movies"
  "sex in movies"
  "sex in movies"
  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 ('sex in movies') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('sex in movies')
              AND `query` <> 'sex in movies'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;