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
  542108
  618810
  602774
  444980
  475876
  518787
  531266
  463101
  568723
  596445
  605929
  723933
  457069
  477738
  522728
  413503
  500979
  554929
  468770
  504480
  469511
  589576
  689737
  458530
  492522
  689622
  526350
  557548
  384914
  443639
  510106
  512915
  429243
  511281
  555895
  689358
  558505
  502989
  491394
  491676
  457349
  673152
  561023
  604159
  475009
  470339
  503553
  518523
  451772
  463772
  489173
  689634
  527609
  509703
  621504
  475267
  510042
  520522
  509296
  523392
  610629
  511678
  469766
  585744
  445833
  620836
  469736
  556323
  560340
  504610
  600035
  618941
  545643
]

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 (542108, 618810, 602774, 444980, 475876, 518787, 531266, 463101, 568723, 596445, 605929, 723933, 457069, 477738, 522728, 413503, 500979, 554929, 468770, 504480, 469511, 589576, 689737, 458530, 492522, 689622, 526350, 557548, 384914, 443639, 510106, 512915, 429243, 511281, 555895, 689358, 558505, 502989, 491394, 491676, 457349, 673152, 561023, 604159, 475009, 470339, 503553, 518523, 451772, 463772, 489173, 689634, 527609, 509703, 621504, 475267, 510042, 520522, 509296, 523392, 610629, 511678, 469766, 585744, 445833, 620836, 469736, 556323, 560340, 504610, 600035, 618941, 545643);

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
  384914
  413503
  429243
  443639
  444980
  445833
  451772
  457069
  457349
  458530
  463101
  463772
  468770
  469511
  469736
  469766
  470339
  475009
  475267
  475876
  477738
  489173
  491394
  491676
  492522
  500979
  502989
  503553
  504480
  504610
  509296
  509703
  510042
  510106
  511281
  511678
  512915
  518523
  518787
  520522
  522728
  523392
  526350
  527609
  531266
  542108
  545643
  554929
  555895
  556323
  557548
  558505
  560340
  561023
  568723
  585744
  589576
  596445
  600035
  602774
  604159
  605929
  610629
  618810
  618941
  620836
  621504
  673152
  689358
  689622
  689634
  689737
  723933
]

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 (384914, 413503, 429243, 443639, 444980, 445833, 451772, 457069, 457349, 458530, 463101, 463772, 468770, 469511, 469736, 469766, 470339, 475009, 475267, 475876, 477738, 489173, 491394, 491676, 492522, 500979, 502989, 503553, 504480, 504610, 509296, 509703, 510042, 510106, 511281, 511678, 512915, 518523, 518787, 520522, 522728, 523392, 526350, 527609, 531266, 542108, 545643, 554929, 555895, 556323, 557548, 558505, 560340, 561023, 568723, 585744, 589576, 596445, 600035, 602774, 604159, 605929, 610629, 618810, 618941, 620836, 621504, 673152, 689358, 689622, 689634, 689737, 723933);

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
  384914
  413503
  429243
  443639
  444980
  445833
  451772
  457069
  457349
  458530
  463101
  463772
  468770
  469511
  469736
  469766
  470339
  475009
  475267
  475876
  477738
  489173
  491394
  491676
  492522
  500979
  502989
  503553
  504480
  504610
  509296
  509703
  510042
  510106
  511281
  511678
  512915
  518523
  518787
  520522
  522728
  523392
  526350
  527609
  531266
  542108
  545643
  554929
  555895
  556323
  557548
  558505
  560340
  561023
  568723
  585744
  589576
  596445
  600035
  602774
  604159
  605929
  610629
  618810
  618941
  620836
  621504
  673152
  689358
  689622
  689634
  689737
  723933
]

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 (384914, 413503, 429243, 443639, 444980, 445833, 451772, 457069, 457349, 458530, 463101, 463772, 468770, 469511, 469736, 469766, 470339, 475009, 475267, 475876, 477738, 489173, 491394, 491676, 492522, 500979, 502989, 503553, 504480, 504610, 509296, 509703, 510042, 510106, 511281, 511678, 512915, 518523, 518787, 520522, 522728, 523392, 526350, 527609, 531266, 542108, 545643, 554929, 555895, 556323, 557548, 558505, 560340, 561023, 568723, 585744, 589576, 596445, 600035, 602774, 604159, 605929, 610629, 618810, 618941, 620836, 621504, 673152, 689358, 689622, 689634, 689737, 723933);

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` = 'секс такс';