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

[
  "riding dildo hard"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'riding dildo hard' 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
  679269
  579173
  807112
  776032
  779280
  656891
  383672
  640131
  793914
  697108
  774883
  813215
  384917
  780384
  739135
  774862
  813558
  696593
  787511
  808796
  477761
  678707
  807835
  636130
  779288
  483742
  287436
  417600
  776404
  752470
  571726
  465148
  420774
  795377
  416696
  552706
  512143
  621653
  643250
  764030
  605592
  571042
  427526
  391945
  449470
  478057
  608955
  783319
  765657
  675375
  589071
  672261
  692688
  604106
  796339
  801610
  528315
  721640
  596796
  606549
  806695
  784655
  772233
  389966
  555116
  591021
  382971
  702061
  565254
]

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 (679269, 579173, 807112, 776032, 779280, 656891, 383672, 640131, 793914, 697108, 774883, 813215, 384917, 780384, 739135, 774862, 813558, 696593, 787511, 808796, 477761, 678707, 807835, 636130, 779288, 483742, 287436, 417600, 776404, 752470, 571726, 465148, 420774, 795377, 416696, 552706, 512143, 621653, 643250, 764030, 605592, 571042, 427526, 391945, 449470, 478057, 608955, 783319, 765657, 675375, 589071, 672261, 692688, 604106, 796339, 801610, 528315, 721640, 596796, 606549, 806695, 784655, 772233, 389966, 555116, 591021, 382971, 702061, 565254);

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
  287436
  382971
  383672
  384917
  389966
  391945
  416696
  417600
  420774
  427526
  449470
  465148
  477761
  478057
  483742
  512143
  528315
  552706
  555116
  565254
  571042
  571726
  579173
  589071
  591021
  596796
  604106
  605592
  606549
  608955
  621653
  636130
  640131
  643250
  656891
  672261
  675375
  678707
  679269
  692688
  696593
  697108
  702061
  721640
  739135
  752470
  764030
  765657
  772233
  774862
  774883
  776032
  776404
  779280
  779288
  780384
  783319
  784655
  787511
  793914
  795377
  796339
  801610
  806695
  807112
  807835
  808796
  813215
  813558
]

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 (287436, 382971, 383672, 384917, 389966, 391945, 416696, 417600, 420774, 427526, 449470, 465148, 477761, 478057, 483742, 512143, 528315, 552706, 555116, 565254, 571042, 571726, 579173, 589071, 591021, 596796, 604106, 605592, 606549, 608955, 621653, 636130, 640131, 643250, 656891, 672261, 675375, 678707, 679269, 692688, 696593, 697108, 702061, 721640, 739135, 752470, 764030, 765657, 772233, 774862, 774883, 776032, 776404, 779280, 779288, 780384, 783319, 784655, 787511, 793914, 795377, 796339, 801610, 806695, 807112, 807835, 808796, 813215, 813558);

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
  287436
  382971
  383672
  384917
  389966
  391945
  416696
  417600
  420774
  427526
  449470
  465148
  477761
  478057
  483742
  512143
  528315
  552706
  555116
  565254
  571042
  571726
  579173
  589071
  591021
  596796
  604106
  605592
  606549
  608955
  621653
  636130
  640131
  643250
  656891
  672261
  675375
  678707
  679269
  692688
  696593
  697108
  702061
  721640
  739135
  752470
  764030
  765657
  772233
  774862
  774883
  776032
  776404
  779280
  779288
  780384
  783319
  784655
  787511
  793914
  795377
  796339
  801610
  806695
  807112
  807835
  808796
  813215
  813558
]

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 (287436, 382971, 383672, 384917, 389966, 391945, 416696, 417600, 420774, 427526, 449470, 465148, 477761, 478057, 483742, 512143, 528315, 552706, 555116, 565254, 571042, 571726, 579173, 589071, 591021, 596796, 604106, 605592, 606549, 608955, 621653, 636130, 640131, 643250, 656891, 672261, 675375, 678707, 679269, 692688, 696593, 697108, 702061, 721640, 739135, 752470, 764030, 765657, 772233, 774862, 774883, 776032, 776404, 779280, 779288, 780384, 783319, 784655, 787511, 793914, 795377, 796339, 801610, 806695, 807112, 807835, 808796, 813215, 813558);

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

[
  "riding дилд hard"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'riding дилд hard';

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

[
  "riding дилд hard"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'riding дилд hard';

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 ?

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