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
  516087
  527767
  585137
  554776
  658269
  662435
  687522
  551388
  577929
  588975
  593096
  606136
  620638
  586134
  414865
  462497
  504446
  524361
  523290
  551299
  565366
  568720
  663930
  663347
  673589
  671403
  548708
  555182
  571653
  590966
  605913
  599803
  601356
  618717
  618723
  591354
  601886
  601941
  603907
  465219
  515252
  522478
  523253
  524544
  518438
  523492
  539417
  484870
  486536
  518040
  543881
  545643
  550436
  581898
  650224
  573805
  575548
  598654
  621520
  620015
  612348
  623727
  616779
  468446
  512952
  502512
  523139
  584720
  564456
  549225
  605346
  594958
  602972
  619527
  481994
  512554
  491023
  503840
  550599
  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 (516087, 527767, 585137, 554776, 658269, 662435, 687522, 551388, 577929, 588975, 593096, 606136, 620638, 586134, 414865, 462497, 504446, 524361, 523290, 551299, 565366, 568720, 663930, 663347, 673589, 671403, 548708, 555182, 571653, 590966, 605913, 599803, 601356, 618717, 618723, 591354, 601886, 601941, 603907, 465219, 515252, 522478, 523253, 524544, 518438, 523492, 539417, 484870, 486536, 518040, 543881, 545643, 550436, 581898, 650224, 573805, 575548, 598654, 621520, 620015, 612348, 623727, 616779, 468446, 512952, 502512, 523139, 584720, 564456, 549225, 605346, 594958, 602972, 619527, 481994, 512554, 491023, 503840, 550599, 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
  414865
  462497
  465219
  468446
  481994
  484870
  486536
  491023
  502512
  503840
  504446
  512554
  512952
  515252
  516087
  518040
  518438
  522478
  523139
  523253
  523290
  523492
  524361
  524544
  527767
  539417
  541866
  543881
  545643
  548708
  549225
  550436
  550599
  551299
  551388
  554776
  555182
  564456
  565366
  568720
  571653
  573805
  575548
  577929
  581898
  584720
  585137
  586134
  588975
  590966
  591354
  593096
  594958
  598654
  599803
  601356
  601886
  601941
  602972
  603907
  605346
  605913
  606136
  612348
  616779
  618717
  618723
  619527
  620015
  620638
  621520
  623727
  650224
  658269
  662435
  663347
  663930
  671403
  673589
  687522
]

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 (414865, 462497, 465219, 468446, 481994, 484870, 486536, 491023, 502512, 503840, 504446, 512554, 512952, 515252, 516087, 518040, 518438, 522478, 523139, 523253, 523290, 523492, 524361, 524544, 527767, 539417, 541866, 543881, 545643, 548708, 549225, 550436, 550599, 551299, 551388, 554776, 555182, 564456, 565366, 568720, 571653, 573805, 575548, 577929, 581898, 584720, 585137, 586134, 588975, 590966, 591354, 593096, 594958, 598654, 599803, 601356, 601886, 601941, 602972, 603907, 605346, 605913, 606136, 612348, 616779, 618717, 618723, 619527, 620015, 620638, 621520, 623727, 650224, 658269, 662435, 663347, 663930, 671403, 673589, 687522);

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
  414865
  462497
  465219
  468446
  481994
  484870
  486536
  491023
  502512
  503840
  504446
  512554
  512952
  515252
  516087
  518040
  518438
  522478
  523139
  523253
  523290
  523492
  524361
  524544
  527767
  539417
  541866
  543881
  545643
  548708
  549225
  550436
  550599
  551299
  551388
  554776
  555182
  564456
  565366
  568720
  571653
  573805
  575548
  577929
  581898
  584720
  585137
  586134
  588975
  590966
  591354
  593096
  594958
  598654
  599803
  601356
  601886
  601941
  602972
  603907
  605346
  605913
  606136
  612348
  616779
  618717
  618723
  619527
  620015
  620638
  621520
  623727
  650224
  658269
  662435
  663347
  663930
  671403
  673589
  687522
]

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 (414865, 462497, 465219, 468446, 481994, 484870, 486536, 491023, 502512, 503840, 504446, 512554, 512952, 515252, 516087, 518040, 518438, 522478, 523139, 523253, 523290, 523492, 524361, 524544, 527767, 539417, 541866, 543881, 545643, 548708, 549225, 550436, 550599, 551299, 551388, 554776, 555182, 564456, 565366, 568720, 571653, 573805, 575548, 577929, 581898, 584720, 585137, 586134, 588975, 590966, 591354, 593096, 594958, 598654, 599803, 601356, 601886, 601941, 602972, 603907, 605346, 605913, 606136, 612348, 616779, 618717, 618723, 619527, 620015, 620638, 621520, 623727, 650224, 658269, 662435, 663347, 663930, 671403, 673589, 687522);

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` = 'замет';