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

[
  "home ffm"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'home ffm' 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
  466317
  485928
  543048
  787912
  233547
  705520
  650662
  544757
  391204
  505922
  806765
  608459
  598538
  681987
  804004
  398614
  478084
  793175
  822365
  467758
  816073
  532352
  713630
  784475
  534300
  581354
  724440
  422034
  488550
  488571
  584290
  815789
  650664
  718160
  653794
  682839
  802413
  807980
  770245
  784427
  512192
  562878
  527943
  603636
  632304
  812781
  608688
  405850
  543133
  426117
  530504
  587416
  448074
  518100
  807533
  502326
  395970
  396253
  420758
  449886
  557941
  597867
  514815
  661578
  531316
  629781
  640687
  548519
  509507
  675471
  424746
  603923
  751565
  671403
]

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 (466317, 485928, 543048, 787912, 233547, 705520, 650662, 544757, 391204, 505922, 806765, 608459, 598538, 681987, 804004, 398614, 478084, 793175, 822365, 467758, 816073, 532352, 713630, 784475, 534300, 581354, 724440, 422034, 488550, 488571, 584290, 815789, 650664, 718160, 653794, 682839, 802413, 807980, 770245, 784427, 512192, 562878, 527943, 603636, 632304, 812781, 608688, 405850, 543133, 426117, 530504, 587416, 448074, 518100, 807533, 502326, 395970, 396253, 420758, 449886, 557941, 597867, 514815, 661578, 531316, 629781, 640687, 548519, 509507, 675471, 424746, 603923, 751565, 671403);

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
  233547
  391204
  395970
  396253
  398614
  405850
  420758
  422034
  424746
  426117
  448074
  449886
  466317
  467758
  478084
  485928
  488550
  488571
  502326
  505922
  509507
  512192
  514815
  518100
  527943
  530504
  531316
  532352
  534300
  543048
  543133
  544757
  548519
  557941
  562878
  581354
  584290
  587416
  597867
  598538
  603636
  603923
  608459
  608688
  629781
  632304
  640687
  650662
  650664
  653794
  661578
  671403
  675471
  681987
  682839
  705520
  713630
  718160
  724440
  751565
  770245
  784427
  784475
  787912
  793175
  802413
  804004
  806765
  807533
  807980
  812781
  815789
  816073
  822365
]

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 (233547, 391204, 395970, 396253, 398614, 405850, 420758, 422034, 424746, 426117, 448074, 449886, 466317, 467758, 478084, 485928, 488550, 488571, 502326, 505922, 509507, 512192, 514815, 518100, 527943, 530504, 531316, 532352, 534300, 543048, 543133, 544757, 548519, 557941, 562878, 581354, 584290, 587416, 597867, 598538, 603636, 603923, 608459, 608688, 629781, 632304, 640687, 650662, 650664, 653794, 661578, 671403, 675471, 681987, 682839, 705520, 713630, 718160, 724440, 751565, 770245, 784427, 784475, 787912, 793175, 802413, 804004, 806765, 807533, 807980, 812781, 815789, 816073, 822365);

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
  233547
  391204
  395970
  396253
  398614
  405850
  420758
  422034
  424746
  426117
  448074
  449886
  466317
  467758
  478084
  485928
  488550
  488571
  502326
  505922
  509507
  512192
  514815
  518100
  527943
  530504
  531316
  532352
  534300
  543048
  543133
  544757
  548519
  557941
  562878
  581354
  584290
  587416
  597867
  598538
  603636
  603923
  608459
  608688
  629781
  632304
  640687
  650662
  650664
  653794
  661578
  671403
  675471
  681987
  682839
  705520
  713630
  718160
  724440
  751565
  770245
  784427
  784475
  787912
  793175
  802413
  804004
  806765
  807533
  807980
  812781
  815789
  816073
  822365
]

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 (233547, 391204, 395970, 396253, 398614, 405850, 420758, 422034, 424746, 426117, 448074, 449886, 466317, 467758, 478084, 485928, 488550, 488571, 502326, 505922, 509507, 512192, 514815, 518100, 527943, 530504, 531316, 532352, 534300, 543048, 543133, 544757, 548519, 557941, 562878, 581354, 584290, 587416, 597867, 598538, 603636, 603923, 608459, 608688, 629781, 632304, 640687, 650662, 650664, 653794, 661578, 671403, 675471, 681987, 682839, 705520, 713630, 718160, 724440, 751565, 770245, 784427, 784475, 787912, 793175, 802413, 804004, 806765, 807533, 807980, 812781, 815789, 816073, 822365);

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

[
  "home жмж секс втро"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'home жмж секс втро';

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

[
  "home жмж секс втро"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'home жмж секс втро';

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 ?

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