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

[
  "homemade with stepmother"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'homemade with stepmother' 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
  605639
  621724
  442523
  551110
  421850
  439744
  439677
  422189
  445200
  445459
  422208
  527140
  588031
  798684
  439765
  442239
  439625
  439742
  439801
  440744
  421915
  443278
  451639
  502750
  511308
  439676
  496864
  618381
  445937
  421854
  422154
  439730
  441003
  422205
  444890
  447236
  504162
  552344
  590535
  621352
  439738
  421879
  448409
  418921
  422203
  449428
  439736
  514906
  523032
  496862
  469345
  515913
  439767
  426991
  442869
  549830
  590930
  439812
  624151
  561458
  637404
  559712
  614906
  565795
  599449
  621655
  420635
  430824
  589642
  520672
  662445
]

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 (605639, 621724, 442523, 551110, 421850, 439744, 439677, 422189, 445200, 445459, 422208, 527140, 588031, 798684, 439765, 442239, 439625, 439742, 439801, 440744, 421915, 443278, 451639, 502750, 511308, 439676, 496864, 618381, 445937, 421854, 422154, 439730, 441003, 422205, 444890, 447236, 504162, 552344, 590535, 621352, 439738, 421879, 448409, 418921, 422203, 449428, 439736, 514906, 523032, 496862, 469345, 515913, 439767, 426991, 442869, 549830, 590930, 439812, 624151, 561458, 637404, 559712, 614906, 565795, 599449, 621655, 420635, 430824, 589642, 520672, 662445);

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
  418921
  420635
  421850
  421854
  421879
  421915
  422154
  422189
  422203
  422205
  422208
  426991
  430824
  439625
  439676
  439677
  439730
  439736
  439738
  439742
  439744
  439765
  439767
  439801
  439812
  440744
  441003
  442239
  442523
  442869
  443278
  444890
  445200
  445459
  445937
  447236
  448409
  449428
  451639
  469345
  496862
  496864
  502750
  504162
  511308
  514906
  515913
  520672
  523032
  527140
  549830
  551110
  552344
  559712
  561458
  565795
  588031
  589642
  590535
  590930
  599449
  605639
  614906
  618381
  621352
  621655
  621724
  624151
  637404
  662445
  798684
]

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 (418921, 420635, 421850, 421854, 421879, 421915, 422154, 422189, 422203, 422205, 422208, 426991, 430824, 439625, 439676, 439677, 439730, 439736, 439738, 439742, 439744, 439765, 439767, 439801, 439812, 440744, 441003, 442239, 442523, 442869, 443278, 444890, 445200, 445459, 445937, 447236, 448409, 449428, 451639, 469345, 496862, 496864, 502750, 504162, 511308, 514906, 515913, 520672, 523032, 527140, 549830, 551110, 552344, 559712, 561458, 565795, 588031, 589642, 590535, 590930, 599449, 605639, 614906, 618381, 621352, 621655, 621724, 624151, 637404, 662445, 798684);

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
  418921
  420635
  421850
  421854
  421879
  421915
  422154
  422189
  422203
  422205
  422208
  426991
  430824
  439625
  439676
  439677
  439730
  439736
  439738
  439742
  439744
  439765
  439767
  439801
  439812
  440744
  441003
  442239
  442523
  442869
  443278
  444890
  445200
  445459
  445937
  447236
  448409
  449428
  451639
  469345
  496862
  496864
  502750
  504162
  511308
  514906
  515913
  520672
  523032
  527140
  549830
  551110
  552344
  559712
  561458
  565795
  588031
  589642
  590535
  590930
  599449
  605639
  614906
  618381
  621352
  621655
  621724
  624151
  637404
  662445
  798684
]

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 (418921, 420635, 421850, 421854, 421879, 421915, 422154, 422189, 422203, 422205, 422208, 426991, 430824, 439625, 439676, 439677, 439730, 439736, 439738, 439742, 439744, 439765, 439767, 439801, 439812, 440744, 441003, 442239, 442523, 442869, 443278, 444890, 445200, 445459, 445937, 447236, 448409, 449428, 451639, 469345, 496862, 496864, 502750, 504162, 511308, 514906, 515913, 520672, 523032, 527140, 549830, 551110, 552344, 559712, 561458, 565795, 588031, 589642, 590535, 590930, 599449, 605639, 614906, 618381, 621352, 621655, 621724, 624151, 637404, 662445, 798684);

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

[
  "домашн любительск stepmother"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'домашн любительск stepmother';

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

[
  "домашн любительск stepmother"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'домашн любительск stepmother';

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 ?

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