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
  680321
  515306
  712726
  789671
  788832
  588840
  756701
  688953
  669969
  774747
  725159
  505772
  696987
  739539
  705408
  723139
  793415
  796182
  814468
  666152
  604432
  793188
  744884
  425167
  679377
  622216
  800967
  751475
  558300
  615900
  727611
  391393
  447248
  544859
  653548
  695867
  749106
  468038
  463758
  467275
  525785
  548850
  547835
  729693
  750461
  419538
  469709
  474647
  467426
  502457
  445334
  508757
  498064
  513533
  414122
  515266
  663348
  682389
  472891
  418857
  456633
  645883
  480461
  465605
  506602
  590439
  545614
]

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 (680321, 515306, 712726, 789671, 788832, 588840, 756701, 688953, 669969, 774747, 725159, 505772, 696987, 739539, 705408, 723139, 793415, 796182, 814468, 666152, 604432, 793188, 744884, 425167, 679377, 622216, 800967, 751475, 558300, 615900, 727611, 391393, 447248, 544859, 653548, 695867, 749106, 468038, 463758, 467275, 525785, 548850, 547835, 729693, 750461, 419538, 469709, 474647, 467426, 502457, 445334, 508757, 498064, 513533, 414122, 515266, 663348, 682389, 472891, 418857, 456633, 645883, 480461, 465605, 506602, 590439, 545614);

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
  391393
  414122
  418857
  419538
  425167
  445334
  447248
  456633
  463758
  465605
  467275
  467426
  468038
  469709
  472891
  474647
  480461
  498064
  502457
  505772
  506602
  508757
  513533
  515266
  515306
  525785
  544859
  545614
  547835
  548850
  558300
  588840
  590439
  604432
  615900
  622216
  645883
  653548
  663348
  666152
  669969
  679377
  680321
  682389
  688953
  695867
  696987
  705408
  712726
  723139
  725159
  727611
  729693
  739539
  744884
  749106
  750461
  751475
  756701
  774747
  788832
  789671
  793188
  793415
  796182
  800967
  814468
]

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 (391393, 414122, 418857, 419538, 425167, 445334, 447248, 456633, 463758, 465605, 467275, 467426, 468038, 469709, 472891, 474647, 480461, 498064, 502457, 505772, 506602, 508757, 513533, 515266, 515306, 525785, 544859, 545614, 547835, 548850, 558300, 588840, 590439, 604432, 615900, 622216, 645883, 653548, 663348, 666152, 669969, 679377, 680321, 682389, 688953, 695867, 696987, 705408, 712726, 723139, 725159, 727611, 729693, 739539, 744884, 749106, 750461, 751475, 756701, 774747, 788832, 789671, 793188, 793415, 796182, 800967, 814468);

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
  391393
  414122
  418857
  419538
  425167
  445334
  447248
  456633
  463758
  465605
  467275
  467426
  468038
  469709
  472891
  474647
  480461
  498064
  502457
  505772
  506602
  508757
  513533
  515266
  515306
  525785
  544859
  545614
  547835
  548850
  558300
  588840
  590439
  604432
  615900
  622216
  645883
  653548
  663348
  666152
  669969
  679377
  680321
  682389
  688953
  695867
  696987
  705408
  712726
  723139
  725159
  727611
  729693
  739539
  744884
  749106
  750461
  751475
  756701
  774747
  788832
  789671
  793188
  793415
  796182
  800967
  814468
]

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 (391393, 414122, 418857, 419538, 425167, 445334, 447248, 456633, 463758, 465605, 467275, 467426, 468038, 469709, 472891, 474647, 480461, 498064, 502457, 505772, 506602, 508757, 513533, 515266, 515306, 525785, 544859, 545614, 547835, 548850, 558300, 588840, 590439, 604432, 615900, 622216, 645883, 653548, 663348, 666152, 669969, 679377, 680321, 682389, 688953, 695867, 696987, 705408, 712726, 723139, 725159, 727611, 729693, 739539, 744884, 749106, 750461, 751475, 756701, 774747, 788832, 789671, 793188, 793415, 796182, 800967, 814468);

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
        ;