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

[
  "big pawg"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'big pawg' 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
  473461
  402715
  472469
  503587
  525826
  500764
  520671
  431341
  463280
  413836
  455436
  439434
  536628
  464359
  571751
  755974
  420530
  454397
  491781
  428003
  809272
  761039
  472693
  451010
  571102
  581620
  593238
  591997
  596196
  401927
  415749
  503406
  452257
  541434
  573938
  676622
  586071
  592229
  586331
  621566
  633987
  420762
  426458
  421537
  464861
  471148
  579701
  576970
  402723
  453683
  564244
  549754
  649970
  676014
  496984
  505460
  588877
  517233
  575822
  596192
  430623
  515999
  455411
  459513
  676088
  591033
  448954
  559948
  427543
  526951
  698124
  584887
  519842
  494492
  527414
  542548
  502512
  515459
  527908
  609839
]

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 (473461, 402715, 472469, 503587, 525826, 500764, 520671, 431341, 463280, 413836, 455436, 439434, 536628, 464359, 571751, 755974, 420530, 454397, 491781, 428003, 809272, 761039, 472693, 451010, 571102, 581620, 593238, 591997, 596196, 401927, 415749, 503406, 452257, 541434, 573938, 676622, 586071, 592229, 586331, 621566, 633987, 420762, 426458, 421537, 464861, 471148, 579701, 576970, 402723, 453683, 564244, 549754, 649970, 676014, 496984, 505460, 588877, 517233, 575822, 596192, 430623, 515999, 455411, 459513, 676088, 591033, 448954, 559948, 427543, 526951, 698124, 584887, 519842, 494492, 527414, 542548, 502512, 515459, 527908, 609839);

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
  401927
  402715
  402723
  413836
  415749
  420530
  420762
  421537
  426458
  427543
  428003
  430623
  431341
  439434
  448954
  451010
  452257
  453683
  454397
  455411
  455436
  459513
  463280
  464359
  464861
  471148
  472469
  472693
  473461
  491781
  494492
  496984
  500764
  502512
  503406
  503587
  505460
  515459
  515999
  517233
  519842
  520671
  525826
  526951
  527414
  527908
  536628
  541434
  542548
  549754
  559948
  564244
  571102
  571751
  573938
  575822
  576970
  579701
  581620
  584887
  586071
  586331
  588877
  591033
  591997
  592229
  593238
  596192
  596196
  609839
  621566
  633987
  649970
  676014
  676088
  676622
  698124
  755974
  761039
  809272
]

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 (401927, 402715, 402723, 413836, 415749, 420530, 420762, 421537, 426458, 427543, 428003, 430623, 431341, 439434, 448954, 451010, 452257, 453683, 454397, 455411, 455436, 459513, 463280, 464359, 464861, 471148, 472469, 472693, 473461, 491781, 494492, 496984, 500764, 502512, 503406, 503587, 505460, 515459, 515999, 517233, 519842, 520671, 525826, 526951, 527414, 527908, 536628, 541434, 542548, 549754, 559948, 564244, 571102, 571751, 573938, 575822, 576970, 579701, 581620, 584887, 586071, 586331, 588877, 591033, 591997, 592229, 593238, 596192, 596196, 609839, 621566, 633987, 649970, 676014, 676088, 676622, 698124, 755974, 761039, 809272);

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
  401927
  402715
  402723
  413836
  415749
  420530
  420762
  421537
  426458
  427543
  428003
  430623
  431341
  439434
  448954
  451010
  452257
  453683
  454397
  455411
  455436
  459513
  463280
  464359
  464861
  471148
  472469
  472693
  473461
  491781
  494492
  496984
  500764
  502512
  503406
  503587
  505460
  515459
  515999
  517233
  519842
  520671
  525826
  526951
  527414
  527908
  536628
  541434
  542548
  549754
  559948
  564244
  571102
  571751
  573938
  575822
  576970
  579701
  581620
  584887
  586071
  586331
  588877
  591033
  591997
  592229
  593238
  596192
  596196
  609839
  621566
  633987
  649970
  676014
  676088
  676622
  698124
  755974
  761039
  809272
]

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 (401927, 402715, 402723, 413836, 415749, 420530, 420762, 421537, 426458, 427543, 428003, 430623, 431341, 439434, 448954, 451010, 452257, 453683, 454397, 455411, 455436, 459513, 463280, 464359, 464861, 471148, 472469, 472693, 473461, 491781, 494492, 496984, 500764, 502512, 503406, 503587, 505460, 515459, 515999, 517233, 519842, 520671, 525826, 526951, 527414, 527908, 536628, 541434, 542548, 549754, 559948, 564244, 571102, 571751, 573938, 575822, 576970, 579701, 581620, 584887, 586071, 586331, 588877, 591033, 591997, 592229, 593238, 596192, 596196, 609839, 621566, 633987, 649970, 676014, 676088, 676622, 698124, 755974, 761039, 809272);

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

[
  "большие pawg"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'большие pawg';

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

[
  "большие pawg"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'большие pawg';