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

[
  "tiktok suck"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'tiktok suck' 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
  734391
  737491
  793375
  775211
  791696
  825705
  828370
  746375
  751950
  723228
  785184
  747044
  821815
  828347
  719999
  778312
  729169
  726350
  731435
  733676
  532614
  825370
  826656
  719823
  762130
  747068
  747178
  763699
  731443
  773749
  786151
  793324
  715006
  801004
  796526
  755814
  766093
  747190
  754966
  625204
  825441
  792168
  730229
  750797
  768287
  818186
  746298
  764052
  724372
  763678
  763841
  824007
  784011
  790083
  780874
  742961
  781445
  794955
  742898
  748753
  718821
  746618
  742865
  747543
  711982
  781291
  742817
  735198
  762487
  711257
  797758
  744683
  731437
  763741
]

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 (734391, 737491, 793375, 775211, 791696, 825705, 828370, 746375, 751950, 723228, 785184, 747044, 821815, 828347, 719999, 778312, 729169, 726350, 731435, 733676, 532614, 825370, 826656, 719823, 762130, 747068, 747178, 763699, 731443, 773749, 786151, 793324, 715006, 801004, 796526, 755814, 766093, 747190, 754966, 625204, 825441, 792168, 730229, 750797, 768287, 818186, 746298, 764052, 724372, 763678, 763841, 824007, 784011, 790083, 780874, 742961, 781445, 794955, 742898, 748753, 718821, 746618, 742865, 747543, 711982, 781291, 742817, 735198, 762487, 711257, 797758, 744683, 731437, 763741);

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
  532614
  711257
  711982
  715006
  718821
  719823
  719999
  723228
  724372
  726350
  729169
  730229
  731435
  731437
  731443
  733676
  734391
  735198
  737491
  742817
  742865
  742898
  742961
  744683
  746298
  746375
  746618
  747044
  747068
  747178
  747190
  747543
  748753
  750797
  751950
  754966
  755814
  762130
  762487
  763678
  763741
  763841
  764052
  766093
  768287
  773749
  775211
  778312
  780874
  781291
  781445
  784011
  785184
  786151
  790083
  791696
  792168
  793324
  793375
  794955
  796526
  797758
  801004
  818186
  821815
  824007
  825370
  825441
  825705
  826656
  828347
  828370
]

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 (532614, 711257, 711982, 715006, 718821, 719823, 719999, 723228, 724372, 726350, 729169, 730229, 731435, 731437, 731443, 733676, 734391, 735198, 737491, 742817, 742865, 742898, 742961, 744683, 746298, 746375, 746618, 747044, 747068, 747178, 747190, 747543, 748753, 750797, 751950, 754966, 755814, 762130, 762487, 763678, 763741, 763841, 764052, 766093, 768287, 773749, 775211, 778312, 780874, 781291, 781445, 784011, 785184, 786151, 790083, 791696, 792168, 793324, 793375, 794955, 796526, 797758, 801004, 818186, 821815, 824007, 825370, 825441, 825705, 826656, 828347, 828370);

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
  532614
  711257
  711982
  715006
  718821
  719823
  719999
  723228
  724372
  726350
  729169
  730229
  731435
  731437
  731443
  733676
  734391
  735198
  737491
  742817
  742865
  742898
  742961
  744683
  746298
  746375
  746618
  747044
  747068
  747178
  747190
  747543
  748753
  750797
  751950
  754966
  755814
  762130
  762487
  763678
  763741
  763841
  764052
  766093
  768287
  773749
  775211
  778312
  780874
  781291
  781445
  784011
  785184
  786151
  790083
  791696
  792168
  793324
  793375
  794955
  796526
  797758
  801004
  818186
  821815
  824007
  825370
  825441
  825705
  826656
  828347
  828370
]

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 (532614, 711257, 711982, 715006, 718821, 719823, 719999, 723228, 724372, 726350, 729169, 730229, 731435, 731437, 731443, 733676, 734391, 735198, 737491, 742817, 742865, 742898, 742961, 744683, 746298, 746375, 746618, 747044, 747068, 747178, 747190, 747543, 748753, 750797, 751950, 754966, 755814, 762130, 762487, 763678, 763741, 763841, 764052, 766093, 768287, 773749, 775211, 778312, 780874, 781291, 781445, 784011, 785184, 786151, 790083, 791696, 792168, 793324, 793375, 794955, 796526, 797758, 801004, 818186, 821815, 824007, 825370, 825441, 825705, 826656, 828347, 828370);

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

[
  "тикток социальн сет suck"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'тикток социальн сет suck';

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

[
  "тикток социальн сет suck"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'тикток социальн сет suck';

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 ?

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