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

[
  "russian talks"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'russian talks' 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
  494017
  716841
  454155
  544459
  578010
  579585
  761957
  816099
  727708
  712948
  533663
  661920
  684693
  672774
  686384
  692280
  695080
  761916
  601986
  700476
  776572
  534469
  672707
  667025
  608220
  602707
  495531
  475942
  577416
  518341
  817725
  701266
  680650
  713004
  810169
  779912
  565015
  452755
  480895
  455614
  500055
  500024
  565004
  758030
  584765
  659377
  621386
  814401
  677407
  716852
  760428
  522755
  507222
  512740
  574035
  598483
  489746
  521391
  523608
  506207
  527858
  423488
  464666
  437765
  603055
  462272
  573455
  521408
  591198
  663264
  599368
  668140
  605552
]

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 (494017, 716841, 454155, 544459, 578010, 579585, 761957, 816099, 727708, 712948, 533663, 661920, 684693, 672774, 686384, 692280, 695080, 761916, 601986, 700476, 776572, 534469, 672707, 667025, 608220, 602707, 495531, 475942, 577416, 518341, 817725, 701266, 680650, 713004, 810169, 779912, 565015, 452755, 480895, 455614, 500055, 500024, 565004, 758030, 584765, 659377, 621386, 814401, 677407, 716852, 760428, 522755, 507222, 512740, 574035, 598483, 489746, 521391, 523608, 506207, 527858, 423488, 464666, 437765, 603055, 462272, 573455, 521408, 591198, 663264, 599368, 668140, 605552);

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
  423488
  437765
  452755
  454155
  455614
  462272
  464666
  475942
  480895
  489746
  494017
  495531
  500024
  500055
  506207
  507222
  512740
  518341
  521391
  521408
  522755
  523608
  527858
  533663
  534469
  544459
  565004
  565015
  573455
  574035
  577416
  578010
  579585
  584765
  591198
  598483
  599368
  601986
  602707
  603055
  605552
  608220
  621386
  659377
  661920
  663264
  667025
  668140
  672707
  672774
  677407
  680650
  684693
  686384
  692280
  695080
  700476
  701266
  712948
  713004
  716841
  716852
  727708
  758030
  760428
  761916
  761957
  776572
  779912
  810169
  814401
  816099
  817725
]

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 (423488, 437765, 452755, 454155, 455614, 462272, 464666, 475942, 480895, 489746, 494017, 495531, 500024, 500055, 506207, 507222, 512740, 518341, 521391, 521408, 522755, 523608, 527858, 533663, 534469, 544459, 565004, 565015, 573455, 574035, 577416, 578010, 579585, 584765, 591198, 598483, 599368, 601986, 602707, 603055, 605552, 608220, 621386, 659377, 661920, 663264, 667025, 668140, 672707, 672774, 677407, 680650, 684693, 686384, 692280, 695080, 700476, 701266, 712948, 713004, 716841, 716852, 727708, 758030, 760428, 761916, 761957, 776572, 779912, 810169, 814401, 816099, 817725);

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
  423488
  437765
  452755
  454155
  455614
  462272
  464666
  475942
  480895
  489746
  494017
  495531
  500024
  500055
  506207
  507222
  512740
  518341
  521391
  521408
  522755
  523608
  527858
  533663
  534469
  544459
  565004
  565015
  573455
  574035
  577416
  578010
  579585
  584765
  591198
  598483
  599368
  601986
  602707
  603055
  605552
  608220
  621386
  659377
  661920
  663264
  667025
  668140
  672707
  672774
  677407
  680650
  684693
  686384
  692280
  695080
  700476
  701266
  712948
  713004
  716841
  716852
  727708
  758030
  760428
  761916
  761957
  776572
  779912
  810169
  814401
  816099
  817725
]

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 (423488, 437765, 452755, 454155, 455614, 462272, 464666, 475942, 480895, 489746, 494017, 495531, 500024, 500055, 506207, 507222, 512740, 518341, 521391, 521408, 522755, 523608, 527858, 533663, 534469, 544459, 565004, 565015, 573455, 574035, 577416, 578010, 579585, 584765, 591198, 598483, 599368, 601986, 602707, 603055, 605552, 608220, 621386, 659377, 661920, 663264, 667025, 668140, 672707, 672774, 677407, 680650, 684693, 686384, 692280, 695080, 700476, 701266, 712948, 713004, 716841, 716852, 727708, 758030, 760428, 761916, 761957, 776572, 779912, 810169, 814401, 816099, 817725);

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

[
  "русск talks"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'русск talks';

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

[
  "русск talks"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'русск talks';

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 ?

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