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

[
  "pawg solo"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pawg solo' 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
  517509
  584425
  541541
  547659
  577313
  595581
  598341
  777765
  796696
  796703
  796647
  739119
  755022
  459469
  467064
  468255
  434900
  440641
  473481
  476051
  435882
  382670
  444496
  429245
  420157
  420774
  440635
  415863
  415753
  482751
  450272
  469519
  475426
  475733
  522579
  510170
  539471
  521853
  548098
  575870
  601672
  596927
  796640
  808998
  739169
  738262
  739145
  465670
  467058
  493252
  440644
  452254
  458099
  459339
  450274
  468514
  515354
  508257
  555055
  560123
  592184
  752506
  466995
  464476
  580914
  592621
  457998
  465431
  472665
  471148
  591997
  761039
  415749
  494492
]

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 (517509, 584425, 541541, 547659, 577313, 595581, 598341, 777765, 796696, 796703, 796647, 739119, 755022, 459469, 467064, 468255, 434900, 440641, 473481, 476051, 435882, 382670, 444496, 429245, 420157, 420774, 440635, 415863, 415753, 482751, 450272, 469519, 475426, 475733, 522579, 510170, 539471, 521853, 548098, 575870, 601672, 596927, 796640, 808998, 739169, 738262, 739145, 465670, 467058, 493252, 440644, 452254, 458099, 459339, 450274, 468514, 515354, 508257, 555055, 560123, 592184, 752506, 466995, 464476, 580914, 592621, 457998, 465431, 472665, 471148, 591997, 761039, 415749, 494492);

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
  382670
  415749
  415753
  415863
  420157
  420774
  429245
  434900
  435882
  440635
  440641
  440644
  444496
  450272
  450274
  452254
  457998
  458099
  459339
  459469
  464476
  465431
  465670
  466995
  467058
  467064
  468255
  468514
  469519
  471148
  472665
  473481
  475426
  475733
  476051
  482751
  493252
  494492
  508257
  510170
  515354
  517509
  521853
  522579
  539471
  541541
  547659
  548098
  555055
  560123
  575870
  577313
  580914
  584425
  591997
  592184
  592621
  595581
  596927
  598341
  601672
  738262
  739119
  739145
  739169
  752506
  755022
  761039
  777765
  796640
  796647
  796696
  796703
  808998
]

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 (382670, 415749, 415753, 415863, 420157, 420774, 429245, 434900, 435882, 440635, 440641, 440644, 444496, 450272, 450274, 452254, 457998, 458099, 459339, 459469, 464476, 465431, 465670, 466995, 467058, 467064, 468255, 468514, 469519, 471148, 472665, 473481, 475426, 475733, 476051, 482751, 493252, 494492, 508257, 510170, 515354, 517509, 521853, 522579, 539471, 541541, 547659, 548098, 555055, 560123, 575870, 577313, 580914, 584425, 591997, 592184, 592621, 595581, 596927, 598341, 601672, 738262, 739119, 739145, 739169, 752506, 755022, 761039, 777765, 796640, 796647, 796696, 796703, 808998);

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
  382670
  415749
  415753
  415863
  420157
  420774
  429245
  434900
  435882
  440635
  440641
  440644
  444496
  450272
  450274
  452254
  457998
  458099
  459339
  459469
  464476
  465431
  465670
  466995
  467058
  467064
  468255
  468514
  469519
  471148
  472665
  473481
  475426
  475733
  476051
  482751
  493252
  494492
  508257
  510170
  515354
  517509
  521853
  522579
  539471
  541541
  547659
  548098
  555055
  560123
  575870
  577313
  580914
  584425
  591997
  592184
  592621
  595581
  596927
  598341
  601672
  738262
  739119
  739145
  739169
  752506
  755022
  761039
  777765
  796640
  796647
  796696
  796703
  808998
]

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 (382670, 415749, 415753, 415863, 420157, 420774, 429245, 434900, 435882, 440635, 440641, 440644, 444496, 450272, 450274, 452254, 457998, 458099, 459339, 459469, 464476, 465431, 465670, 466995, 467058, 467064, 468255, 468514, 469519, 471148, 472665, 473481, 475426, 475733, 476051, 482751, 493252, 494492, 508257, 510170, 515354, 517509, 521853, 522579, 539471, 541541, 547659, 548098, 555055, 560123, 575870, 577313, 580914, 584425, 591997, 592184, 592621, 595581, 596927, 598341, 601672, 738262, 739119, 739145, 739169, 752506, 755022, 761039, 777765, 796640, 796647, 796696, 796703, 808998);

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

[
  "pawg соло"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'pawg соло';

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

[
  "pawg соло"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'pawg соло';

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 ?

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