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

[
  "2 деда"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = '2 деда' 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
  582201
  810701
  749266
  729618
  748950
  721325
  464506
  464513
  445363
  470792
  492610
  389899
  424923
  545318
  550092
  584537
  667898
  720885
  596809
  613857
  807927
  486909
  515222
  523903
  488735
  442216
  825001
  562106
  574204
  541605
  560665
  606275
  591607
  716030
  473909
  571847
  559184
  646838
  556755
  599856
  590542
  628424
  623198
  608031
  421562
  484628
  572763
  658564
  662137
  567829
  603622
  500904
  577356
  544840
  579592
  623196
  628082
  548257
  581663
  545611
  611986
  630537
  641127
  605122
  593125
  463957
  541650
  492256
  560188
  609196
  553280
  665328
  596839
  616994
  541866
]

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 (582201, 810701, 749266, 729618, 748950, 721325, 464506, 464513, 445363, 470792, 492610, 389899, 424923, 545318, 550092, 584537, 667898, 720885, 596809, 613857, 807927, 486909, 515222, 523903, 488735, 442216, 825001, 562106, 574204, 541605, 560665, 606275, 591607, 716030, 473909, 571847, 559184, 646838, 556755, 599856, 590542, 628424, 623198, 608031, 421562, 484628, 572763, 658564, 662137, 567829, 603622, 500904, 577356, 544840, 579592, 623196, 628082, 548257, 581663, 545611, 611986, 630537, 641127, 605122, 593125, 463957, 541650, 492256, 560188, 609196, 553280, 665328, 596839, 616994, 541866);

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
  389899
  421562
  424923
  442216
  445363
  463957
  464506
  464513
  470792
  473909
  484628
  486909
  488735
  492256
  492610
  500904
  515222
  523903
  541605
  541650
  541866
  544840
  545318
  545611
  548257
  550092
  553280
  556755
  559184
  560188
  560665
  562106
  567829
  571847
  572763
  574204
  577356
  579592
  581663
  582201
  584537
  590542
  591607
  593125
  596809
  596839
  599856
  603622
  605122
  606275
  608031
  609196
  611986
  613857
  616994
  623196
  623198
  628082
  628424
  630537
  641127
  646838
  658564
  662137
  665328
  667898
  716030
  720885
  721325
  729618
  748950
  749266
  807927
  810701
  825001
]

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 (389899, 421562, 424923, 442216, 445363, 463957, 464506, 464513, 470792, 473909, 484628, 486909, 488735, 492256, 492610, 500904, 515222, 523903, 541605, 541650, 541866, 544840, 545318, 545611, 548257, 550092, 553280, 556755, 559184, 560188, 560665, 562106, 567829, 571847, 572763, 574204, 577356, 579592, 581663, 582201, 584537, 590542, 591607, 593125, 596809, 596839, 599856, 603622, 605122, 606275, 608031, 609196, 611986, 613857, 616994, 623196, 623198, 628082, 628424, 630537, 641127, 646838, 658564, 662137, 665328, 667898, 716030, 720885, 721325, 729618, 748950, 749266, 807927, 810701, 825001);

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
  389899
  421562
  424923
  442216
  445363
  463957
  464506
  464513
  470792
  473909
  484628
  486909
  488735
  492256
  492610
  500904
  515222
  523903
  541605
  541650
  541866
  544840
  545318
  545611
  548257
  550092
  553280
  556755
  559184
  560188
  560665
  562106
  567829
  571847
  572763
  574204
  577356
  579592
  581663
  582201
  584537
  590542
  591607
  593125
  596809
  596839
  599856
  603622
  605122
  606275
  608031
  609196
  611986
  613857
  616994
  623196
  623198
  628082
  628424
  630537
  641127
  646838
  658564
  662137
  665328
  667898
  716030
  720885
  721325
  729618
  748950
  749266
  807927
  810701
  825001
]

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 (389899, 421562, 424923, 442216, 445363, 463957, 464506, 464513, 470792, 473909, 484628, 486909, 488735, 492256, 492610, 500904, 515222, 523903, 541605, 541650, 541866, 544840, 545318, 545611, 548257, 550092, 553280, 556755, 559184, 560188, 560665, 562106, 567829, 571847, 572763, 574204, 577356, 579592, 581663, 582201, 584537, 590542, 591607, 593125, 596809, 596839, 599856, 603622, 605122, 606275, 608031, 609196, 611986, 613857, 616994, 623196, 623198, 628082, 628424, 630537, 641127, 646838, 658564, 662137, 665328, 667898, 716030, 720885, 721325, 729618, 748950, 749266, 807927, 810701, 825001);

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 ?

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