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

[
  "retro busty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'retro busty' 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
  592478
  694508
  577079
  670764
  604121
  785485
  694112
  694110
  474479
  581276
  652252
  594186
  727685
  776774
  560369
  541402
  565227
  672723
  625755
  671712
  474485
  581389
  568213
  647308
  587451
  605341
  509103
  539503
  566668
  644315
  726657
  538952
  580852
  669566
  671701
  621310
  789659
  542778
  670102
  692428
  716835
  619482
  716572
  581353
  474483
  672372
  699596
  717862
  683297
  592390
  592438
  716368
  554886
  567384
  671753
  625279
  710878
  567405
  668943
  623202
  541336
  801471
  802455
  541656
  554446
  801896
  562832
  772574
  571428
  543579
  801917
  677712
  603214
  603310
]

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 (592478, 694508, 577079, 670764, 604121, 785485, 694112, 694110, 474479, 581276, 652252, 594186, 727685, 776774, 560369, 541402, 565227, 672723, 625755, 671712, 474485, 581389, 568213, 647308, 587451, 605341, 509103, 539503, 566668, 644315, 726657, 538952, 580852, 669566, 671701, 621310, 789659, 542778, 670102, 692428, 716835, 619482, 716572, 581353, 474483, 672372, 699596, 717862, 683297, 592390, 592438, 716368, 554886, 567384, 671753, 625279, 710878, 567405, 668943, 623202, 541336, 801471, 802455, 541656, 554446, 801896, 562832, 772574, 571428, 543579, 801917, 677712, 603214, 603310);

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
  474479
  474483
  474485
  509103
  538952
  539503
  541336
  541402
  541656
  542778
  543579
  554446
  554886
  560369
  562832
  565227
  566668
  567384
  567405
  568213
  571428
  577079
  580852
  581276
  581353
  581389
  587451
  592390
  592438
  592478
  594186
  603214
  603310
  604121
  605341
  619482
  621310
  623202
  625279
  625755
  644315
  647308
  652252
  668943
  669566
  670102
  670764
  671701
  671712
  671753
  672372
  672723
  677712
  683297
  692428
  694110
  694112
  694508
  699596
  710878
  716368
  716572
  716835
  717862
  726657
  727685
  772574
  776774
  785485
  789659
  801471
  801896
  801917
  802455
]

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 (474479, 474483, 474485, 509103, 538952, 539503, 541336, 541402, 541656, 542778, 543579, 554446, 554886, 560369, 562832, 565227, 566668, 567384, 567405, 568213, 571428, 577079, 580852, 581276, 581353, 581389, 587451, 592390, 592438, 592478, 594186, 603214, 603310, 604121, 605341, 619482, 621310, 623202, 625279, 625755, 644315, 647308, 652252, 668943, 669566, 670102, 670764, 671701, 671712, 671753, 672372, 672723, 677712, 683297, 692428, 694110, 694112, 694508, 699596, 710878, 716368, 716572, 716835, 717862, 726657, 727685, 772574, 776774, 785485, 789659, 801471, 801896, 801917, 802455);

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
  474479
  474483
  474485
  509103
  538952
  539503
  541336
  541402
  541656
  542778
  543579
  554446
  554886
  560369
  562832
  565227
  566668
  567384
  567405
  568213
  571428
  577079
  580852
  581276
  581353
  581389
  587451
  592390
  592438
  592478
  594186
  603214
  603310
  604121
  605341
  619482
  621310
  623202
  625279
  625755
  644315
  647308
  652252
  668943
  669566
  670102
  670764
  671701
  671712
  671753
  672372
  672723
  677712
  683297
  692428
  694110
  694112
  694508
  699596
  710878
  716368
  716572
  716835
  717862
  726657
  727685
  772574
  776774
  785485
  789659
  801471
  801896
  801917
  802455
]

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 (474479, 474483, 474485, 509103, 538952, 539503, 541336, 541402, 541656, 542778, 543579, 554446, 554886, 560369, 562832, 565227, 566668, 567384, 567405, 568213, 571428, 577079, 580852, 581276, 581353, 581389, 587451, 592390, 592438, 592478, 594186, 603214, 603310, 604121, 605341, 619482, 621310, 623202, 625279, 625755, 644315, 647308, 652252, 668943, 669566, 670102, 670764, 671701, 671712, 671753, 672372, 672723, 677712, 683297, 692428, 694110, 694112, 694508, 699596, 710878, 716368, 716572, 716835, 717862, 726657, 727685, 772574, 776774, 785485, 789659, 801471, 801896, 801917, 802455);

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

[
  "ретр busty"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'ретр busty';

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

[
  "ретр busty"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'ретр busty';

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 ?

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