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

[
  "mature strapon boy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature strapon boy' 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
  748255
  748242
  484681
  445608
  600173
  445416
  466079
  563449
  454709
  507094
  411946
  427258
  470412
  465883
  748258
  484670
  472956
  434045
  390667
  463825
  484667
  423647
  618908
  546766
  431133
  518766
  726487
  506269
  639722
  443249
  467952
  475801
  531231
  418934
  564661
  600054
  484719
  419371
  474561
  476706
  478051
  451626
  476409
  448840
  456518
  476797
  534288
  559111
  534645
  512059
  542189
  523924
  599234
  405531
]

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 (748255, 748242, 484681, 445608, 600173, 445416, 466079, 563449, 454709, 507094, 411946, 427258, 470412, 465883, 748258, 484670, 472956, 434045, 390667, 463825, 484667, 423647, 618908, 546766, 431133, 518766, 726487, 506269, 639722, 443249, 467952, 475801, 531231, 418934, 564661, 600054, 484719, 419371, 474561, 476706, 478051, 451626, 476409, 448840, 456518, 476797, 534288, 559111, 534645, 512059, 542189, 523924, 599234, 405531);

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
  390667
  405531
  411946
  418934
  419371
  423647
  427258
  431133
  434045
  443249
  445416
  445608
  448840
  451626
  454709
  456518
  463825
  465883
  466079
  467952
  470412
  472956
  474561
  475801
  476409
  476706
  476797
  478051
  484667
  484670
  484681
  484719
  506269
  507094
  512059
  518766
  523924
  531231
  534288
  534645
  542189
  546766
  559111
  563449
  564661
  599234
  600054
  600173
  618908
  639722
  726487
  748242
  748255
  748258
]

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 (390667, 405531, 411946, 418934, 419371, 423647, 427258, 431133, 434045, 443249, 445416, 445608, 448840, 451626, 454709, 456518, 463825, 465883, 466079, 467952, 470412, 472956, 474561, 475801, 476409, 476706, 476797, 478051, 484667, 484670, 484681, 484719, 506269, 507094, 512059, 518766, 523924, 531231, 534288, 534645, 542189, 546766, 559111, 563449, 564661, 599234, 600054, 600173, 618908, 639722, 726487, 748242, 748255, 748258);

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
  390667
  405531
  411946
  418934
  419371
  423647
  427258
  431133
  434045
  443249
  445416
  445608
  448840
  451626
  454709
  456518
  463825
  465883
  466079
  467952
  470412
  472956
  474561
  475801
  476409
  476706
  476797
  478051
  484667
  484670
  484681
  484719
  506269
  507094
  512059
  518766
  523924
  531231
  534288
  534645
  542189
  546766
  559111
  563449
  564661
  599234
  600054
  600173
  618908
  639722
  726487
  748242
  748255
  748258
]

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 (390667, 405531, 411946, 418934, 419371, 423647, 427258, 431133, 434045, 443249, 445416, 445608, 448840, 451626, 454709, 456518, 463825, 465883, 466079, 467952, 470412, 472956, 474561, 475801, 476409, 476706, 476797, 478051, 484667, 484670, 484681, 484719, 506269, 507094, 512059, 518766, 523924, 531231, 534288, 534645, 542189, 546766, 559111, 563449, 564661, 599234, 600054, 600173, 618908, 639722, 726487, 748242, 748255, 748258);

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

[
  "mature страпон парен"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'mature страпон парен';

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

[
  "mature страпон парен"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature страпон парен';

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 ?

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