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
  781511
  790742
  799063
  798529
  740854
  767183
  772151
  751120
  771969
  772753
  803531
  809935
  811611
  436459
  459069
  506898
  614029
  631968
  530414
  499163
  527253
  513696
  581531
  581637
  693075
  670197
  720424
  585358
  592590
  602463
  602821
  615819
  787109
  721109
  803596
  499174
  609280
  508150
  521575
  426220
  447914
  523508
  528363
  527281
  502060
  530371
  565266
  617408
  797541
  482319
  497155
  570535
  570743
  546118
  558217
  678764
  574869
  605661
  614431
  419860
  504183
  525835
  492804
  814235
  577699
  601381
  617437
  615829
  495665
  716220
  634885
  530690
  637001
]

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 (781511, 790742, 799063, 798529, 740854, 767183, 772151, 751120, 771969, 772753, 803531, 809935, 811611, 436459, 459069, 506898, 614029, 631968, 530414, 499163, 527253, 513696, 581531, 581637, 693075, 670197, 720424, 585358, 592590, 602463, 602821, 615819, 787109, 721109, 803596, 499174, 609280, 508150, 521575, 426220, 447914, 523508, 528363, 527281, 502060, 530371, 565266, 617408, 797541, 482319, 497155, 570535, 570743, 546118, 558217, 678764, 574869, 605661, 614431, 419860, 504183, 525835, 492804, 814235, 577699, 601381, 617437, 615829, 495665, 716220, 634885, 530690, 637001);

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
  419860
  426220
  436459
  447914
  459069
  482319
  492804
  495665
  497155
  499163
  499174
  502060
  504183
  506898
  508150
  513696
  521575
  523508
  525835
  527253
  527281
  528363
  530371
  530414
  530690
  546118
  558217
  565266
  570535
  570743
  574869
  577699
  581531
  581637
  585358
  592590
  601381
  602463
  602821
  605661
  609280
  614029
  614431
  615819
  615829
  617408
  617437
  631968
  634885
  637001
  670197
  678764
  693075
  716220
  720424
  721109
  740854
  751120
  767183
  771969
  772151
  772753
  781511
  787109
  790742
  797541
  798529
  799063
  803531
  803596
  809935
  811611
  814235
]

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 (419860, 426220, 436459, 447914, 459069, 482319, 492804, 495665, 497155, 499163, 499174, 502060, 504183, 506898, 508150, 513696, 521575, 523508, 525835, 527253, 527281, 528363, 530371, 530414, 530690, 546118, 558217, 565266, 570535, 570743, 574869, 577699, 581531, 581637, 585358, 592590, 601381, 602463, 602821, 605661, 609280, 614029, 614431, 615819, 615829, 617408, 617437, 631968, 634885, 637001, 670197, 678764, 693075, 716220, 720424, 721109, 740854, 751120, 767183, 771969, 772151, 772753, 781511, 787109, 790742, 797541, 798529, 799063, 803531, 803596, 809935, 811611, 814235);

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
  419860
  426220
  436459
  447914
  459069
  482319
  492804
  495665
  497155
  499163
  499174
  502060
  504183
  506898
  508150
  513696
  521575
  523508
  525835
  527253
  527281
  528363
  530371
  530414
  530690
  546118
  558217
  565266
  570535
  570743
  574869
  577699
  581531
  581637
  585358
  592590
  601381
  602463
  602821
  605661
  609280
  614029
  614431
  615819
  615829
  617408
  617437
  631968
  634885
  637001
  670197
  678764
  693075
  716220
  720424
  721109
  740854
  751120
  767183
  771969
  772151
  772753
  781511
  787109
  790742
  797541
  798529
  799063
  803531
  803596
  809935
  811611
  814235
]

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 (419860, 426220, 436459, 447914, 459069, 482319, 492804, 495665, 497155, 499163, 499174, 502060, 504183, 506898, 508150, 513696, 521575, 523508, 525835, 527253, 527281, 528363, 530371, 530414, 530690, 546118, 558217, 565266, 570535, 570743, 574869, 577699, 581531, 581637, 585358, 592590, 601381, 602463, 602821, 605661, 609280, 614029, 614431, 615819, 615829, 617408, 617437, 631968, 634885, 637001, 670197, 678764, 693075, 716220, 720424, 721109, 740854, 751120, 767183, 771969, 772151, 772753, 781511, 787109, 790742, 797541, 798529, 799063, 803531, 803596, 809935, 811611, 814235);

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
        ;