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

[
  "bbw ass hard"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bbw ass hard' 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
  810084
  729012
  753039
  782398
  782021
  726282
  728308
  750836
  782404
  766721
  807208
  759127
  726836
  757177
  797478
  604577
  828710
  710678
  765781
  618288
  618612
  794859
  726872
  471178
  453316
  706625
  781796
  741515
  308583
  819361
  781782
  823857
  772113
  750948
  705781
  669201
  696115
  781824
  739171
  543970
  795295
  483885
  443627
  459858
  664967
  784964
  545631
  530414
  453992
  491767
  447882
  519754
  567414
  781826
  31329
  423966
  698124
  427543
  453544
  592985
  476619
  443105
  483448
  464336
  515952
  569098
  585746
  678764
  666784
  447942
  494291
  763136
  474923
]

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 (810084, 729012, 753039, 782398, 782021, 726282, 728308, 750836, 782404, 766721, 807208, 759127, 726836, 757177, 797478, 604577, 828710, 710678, 765781, 618288, 618612, 794859, 726872, 471178, 453316, 706625, 781796, 741515, 308583, 819361, 781782, 823857, 772113, 750948, 705781, 669201, 696115, 781824, 739171, 543970, 795295, 483885, 443627, 459858, 664967, 784964, 545631, 530414, 453992, 491767, 447882, 519754, 567414, 781826, 31329, 423966, 698124, 427543, 453544, 592985, 476619, 443105, 483448, 464336, 515952, 569098, 585746, 678764, 666784, 447942, 494291, 763136, 474923);

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
  31329
  308583
  423966
  427543
  443105
  443627
  447882
  447942
  453316
  453544
  453992
  459858
  464336
  471178
  474923
  476619
  483448
  483885
  491767
  494291
  515952
  519754
  530414
  543970
  545631
  567414
  569098
  585746
  592985
  604577
  618288
  618612
  664967
  666784
  669201
  678764
  696115
  698124
  705781
  706625
  710678
  726282
  726836
  726872
  728308
  729012
  739171
  741515
  750836
  750948
  753039
  757177
  759127
  763136
  765781
  766721
  772113
  781782
  781796
  781824
  781826
  782021
  782398
  782404
  784964
  794859
  795295
  797478
  807208
  810084
  819361
  823857
  828710
]

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 (31329, 308583, 423966, 427543, 443105, 443627, 447882, 447942, 453316, 453544, 453992, 459858, 464336, 471178, 474923, 476619, 483448, 483885, 491767, 494291, 515952, 519754, 530414, 543970, 545631, 567414, 569098, 585746, 592985, 604577, 618288, 618612, 664967, 666784, 669201, 678764, 696115, 698124, 705781, 706625, 710678, 726282, 726836, 726872, 728308, 729012, 739171, 741515, 750836, 750948, 753039, 757177, 759127, 763136, 765781, 766721, 772113, 781782, 781796, 781824, 781826, 782021, 782398, 782404, 784964, 794859, 795295, 797478, 807208, 810084, 819361, 823857, 828710);

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
  31329
  308583
  423966
  427543
  443105
  443627
  447882
  447942
  453316
  453544
  453992
  459858
  464336
  471178
  474923
  476619
  483448
  483885
  491767
  494291
  515952
  519754
  530414
  543970
  545631
  567414
  569098
  585746
  592985
  604577
  618288
  618612
  664967
  666784
  669201
  678764
  696115
  698124
  705781
  706625
  710678
  726282
  726836
  726872
  728308
  729012
  739171
  741515
  750836
  750948
  753039
  757177
  759127
  763136
  765781
  766721
  772113
  781782
  781796
  781824
  781826
  782021
  782398
  782404
  784964
  794859
  795295
  797478
  807208
  810084
  819361
  823857
  828710
]

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 (31329, 308583, 423966, 427543, 443105, 443627, 447882, 447942, 453316, 453544, 453992, 459858, 464336, 471178, 474923, 476619, 483448, 483885, 491767, 494291, 515952, 519754, 530414, 543970, 545631, 567414, 569098, 585746, 592985, 604577, 618288, 618612, 664967, 666784, 669201, 678764, 696115, 698124, 705781, 706625, 710678, 726282, 726836, 726872, 728308, 729012, 739171, 741515, 750836, 750948, 753039, 757177, 759127, 763136, 765781, 766721, 772113, 781782, 781796, 781824, 781826, 782021, 782398, 782404, 784964, 794859, 795295, 797478, 807208, 810084, 819361, 823857, 828710);

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

[
  "bbw жоп hard"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'bbw жоп hard';

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

[
  "bbw жоп hard"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bbw жоп hard';

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 ?

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