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

[
  "anal lesson"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal lesson' 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
  823685
  827428
  654355
  759796
  791202
  781107
  802036
  6983
  786993
  447134
  815058
  704178
  418058
  524097
  628116
  513839
  579483
  393076
  385225
  728446
  555992
  727927
  753668
  663715
  735462
  789824
  721884
  780986
  721426
  817116
  777250
  759543
  744006
  705829
  780243
  720207
  129902
  441901
  720707
  666886
  814768
  677015
  798671
  807554
  780637
  795750
  782564
  761047
  493260
  810297
  756506
  440723
  517106
  440217
  538520
  678943
  418417
  418410
  639809
  461605
  188264
  426038
  517571
  567337
  552267
  605576
  523567
  662000
  678962
  567338
  642063
  679032
  467494
  621683
]

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 (823685, 827428, 654355, 759796, 791202, 781107, 802036, 6983, 786993, 447134, 815058, 704178, 418058, 524097, 628116, 513839, 579483, 393076, 385225, 728446, 555992, 727927, 753668, 663715, 735462, 789824, 721884, 780986, 721426, 817116, 777250, 759543, 744006, 705829, 780243, 720207, 129902, 441901, 720707, 666886, 814768, 677015, 798671, 807554, 780637, 795750, 782564, 761047, 493260, 810297, 756506, 440723, 517106, 440217, 538520, 678943, 418417, 418410, 639809, 461605, 188264, 426038, 517571, 567337, 552267, 605576, 523567, 662000, 678962, 567338, 642063, 679032, 467494, 621683);

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
  6983
  129902
  188264
  385225
  393076
  418058
  418410
  418417
  426038
  440217
  440723
  441901
  447134
  461605
  467494
  493260
  513839
  517106
  517571
  523567
  524097
  538520
  552267
  555992
  567337
  567338
  579483
  605576
  621683
  628116
  639809
  642063
  654355
  662000
  663715
  666886
  677015
  678943
  678962
  679032
  704178
  705829
  720207
  720707
  721426
  721884
  727927
  728446
  735462
  744006
  753668
  756506
  759543
  759796
  761047
  777250
  780243
  780637
  780986
  781107
  782564
  786993
  789824
  791202
  795750
  798671
  802036
  807554
  810297
  814768
  815058
  817116
  823685
  827428
]

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 (6983, 129902, 188264, 385225, 393076, 418058, 418410, 418417, 426038, 440217, 440723, 441901, 447134, 461605, 467494, 493260, 513839, 517106, 517571, 523567, 524097, 538520, 552267, 555992, 567337, 567338, 579483, 605576, 621683, 628116, 639809, 642063, 654355, 662000, 663715, 666886, 677015, 678943, 678962, 679032, 704178, 705829, 720207, 720707, 721426, 721884, 727927, 728446, 735462, 744006, 753668, 756506, 759543, 759796, 761047, 777250, 780243, 780637, 780986, 781107, 782564, 786993, 789824, 791202, 795750, 798671, 802036, 807554, 810297, 814768, 815058, 817116, 823685, 827428);

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
  6983
  129902
  188264
  385225
  393076
  418058
  418410
  418417
  426038
  440217
  440723
  441901
  447134
  461605
  467494
  493260
  513839
  517106
  517571
  523567
  524097
  538520
  552267
  555992
  567337
  567338
  579483
  605576
  621683
  628116
  639809
  642063
  654355
  662000
  663715
  666886
  677015
  678943
  678962
  679032
  704178
  705829
  720207
  720707
  721426
  721884
  727927
  728446
  735462
  744006
  753668
  756506
  759543
  759796
  761047
  777250
  780243
  780637
  780986
  781107
  782564
  786993
  789824
  791202
  795750
  798671
  802036
  807554
  810297
  814768
  815058
  817116
  823685
  827428
]

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 (6983, 129902, 188264, 385225, 393076, 418058, 418410, 418417, 426038, 440217, 440723, 441901, 447134, 461605, 467494, 493260, 513839, 517106, 517571, 523567, 524097, 538520, 552267, 555992, 567337, 567338, 579483, 605576, 621683, 628116, 639809, 642063, 654355, 662000, 663715, 666886, 677015, 678943, 678962, 679032, 704178, 705829, 720207, 720707, 721426, 721884, 727927, 728446, 735462, 744006, 753668, 756506, 759543, 759796, 761047, 777250, 780243, 780637, 780986, 781107, 782564, 786993, 789824, 791202, 795750, 798671, 802036, 807554, 810297, 814768, 815058, 817116, 823685, 827428);

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

[
  "анал lesson"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'анал lesson';

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

[
  "анал lesson"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'анал lesson';

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 ?

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