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

[
  "анал пов стоя"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'анал пов стоя' 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
  440874
  441788
  442136
  560431
  636057
  581109
  541678
  352189
  559685
  478732
  537464
  511481
  541686
  684402
  604347
  588916
  562120
  452394
  594463
  444338
  565288
  812022
  562460
  571221
  680780
  479583
  520388
  534432
  569146
  579746
  503444
  544976
  571086
  589133
  506518
  603236
  424121
  590382
  604344
  527296
  568077
  569546
  624320
  599505
  525411
  679656
  526300
  449697
  549216
  457683
  528878
  590076
  478033
  545267
  572825
  549103
  612964
  558976
  467731
  613936
  484222
  502324
  535204
  424682
  564563
  467088
  616489
  502779
  516689
  499566
  453028
]

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 (440874, 441788, 442136, 560431, 636057, 581109, 541678, 352189, 559685, 478732, 537464, 511481, 541686, 684402, 604347, 588916, 562120, 452394, 594463, 444338, 565288, 812022, 562460, 571221, 680780, 479583, 520388, 534432, 569146, 579746, 503444, 544976, 571086, 589133, 506518, 603236, 424121, 590382, 604344, 527296, 568077, 569546, 624320, 599505, 525411, 679656, 526300, 449697, 549216, 457683, 528878, 590076, 478033, 545267, 572825, 549103, 612964, 558976, 467731, 613936, 484222, 502324, 535204, 424682, 564563, 467088, 616489, 502779, 516689, 499566, 453028);

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
  352189
  424121
  424682
  440874
  441788
  442136
  444338
  449697
  452394
  453028
  457683
  467088
  467731
  478033
  478732
  479583
  484222
  499566
  502324
  502779
  503444
  506518
  511481
  516689
  520388
  525411
  526300
  527296
  528878
  534432
  535204
  537464
  541678
  541686
  544976
  545267
  549103
  549216
  558976
  559685
  560431
  562120
  562460
  564563
  565288
  568077
  569146
  569546
  571086
  571221
  572825
  579746
  581109
  588916
  589133
  590076
  590382
  594463
  599505
  603236
  604344
  604347
  612964
  613936
  616489
  624320
  636057
  679656
  680780
  684402
  812022
]

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 (352189, 424121, 424682, 440874, 441788, 442136, 444338, 449697, 452394, 453028, 457683, 467088, 467731, 478033, 478732, 479583, 484222, 499566, 502324, 502779, 503444, 506518, 511481, 516689, 520388, 525411, 526300, 527296, 528878, 534432, 535204, 537464, 541678, 541686, 544976, 545267, 549103, 549216, 558976, 559685, 560431, 562120, 562460, 564563, 565288, 568077, 569146, 569546, 571086, 571221, 572825, 579746, 581109, 588916, 589133, 590076, 590382, 594463, 599505, 603236, 604344, 604347, 612964, 613936, 616489, 624320, 636057, 679656, 680780, 684402, 812022);

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
  352189
  424121
  424682
  440874
  441788
  442136
  444338
  449697
  452394
  453028
  457683
  467088
  467731
  478033
  478732
  479583
  484222
  499566
  502324
  502779
  503444
  506518
  511481
  516689
  520388
  525411
  526300
  527296
  528878
  534432
  535204
  537464
  541678
  541686
  544976
  545267
  549103
  549216
  558976
  559685
  560431
  562120
  562460
  564563
  565288
  568077
  569146
  569546
  571086
  571221
  572825
  579746
  581109
  588916
  589133
  590076
  590382
  594463
  599505
  603236
  604344
  604347
  612964
  613936
  616489
  624320
  636057
  679656
  680780
  684402
  812022
]

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 (352189, 424121, 424682, 440874, 441788, 442136, 444338, 449697, 452394, 453028, 457683, 467088, 467731, 478033, 478732, 479583, 484222, 499566, 502324, 502779, 503444, 506518, 511481, 516689, 520388, 525411, 526300, 527296, 528878, 534432, 535204, 537464, 541678, 541686, 544976, 545267, 549103, 549216, 558976, 559685, 560431, 562120, 562460, 564563, 565288, 568077, 569146, 569546, 571086, 571221, 572825, 579746, 581109, 588916, 589133, 590076, 590382, 594463, 599505, 603236, 604344, 604347, 612964, 613936, 616489, 624320, 636057, 679656, 680780, 684402, 812022);

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

[
  "анал пов сто"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'анал пов сто';

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

[
  "анал пов сто"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'анал пов сто';

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 ?

[
  "анал пов стоя"
  "анал пов стоя"
  "анал пов стоя"
  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 ('анал пов стоя') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('анал пов стоя')
              AND `query` <> 'анал пов стоя'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;