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
  652712
  130105
  814746
  495149
  439457
  426009
  474685
  490404
  491256
  432787
  479709
  499111
  437855
  446167
  446275
  396020
  424458
  458191
  401239
  578815
  466241
  414301
  388690
  513540
  444003
  447926
  443099
  443784
  484737
  427112
  408214
  421250
  424876
  610314
  438772
  519563
  417349
  431446
  549187
  405061
  454802
  461723
  499104
  401919
  524882
  464327
  513965
  426294
  588264
  810663
  456136
  468733
  489280
  541833
  599361
  599478
  617421
  521453
  417801
  679567
  445641
  499598
  395824
  623199
  509981
  439751
  554119
  463094
  514395
  483788
  499852
  497953
  509802
  574384
  596839
]

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 (652712, 130105, 814746, 495149, 439457, 426009, 474685, 490404, 491256, 432787, 479709, 499111, 437855, 446167, 446275, 396020, 424458, 458191, 401239, 578815, 466241, 414301, 388690, 513540, 444003, 447926, 443099, 443784, 484737, 427112, 408214, 421250, 424876, 610314, 438772, 519563, 417349, 431446, 549187, 405061, 454802, 461723, 499104, 401919, 524882, 464327, 513965, 426294, 588264, 810663, 456136, 468733, 489280, 541833, 599361, 599478, 617421, 521453, 417801, 679567, 445641, 499598, 395824, 623199, 509981, 439751, 554119, 463094, 514395, 483788, 499852, 497953, 509802, 574384, 596839);

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
  130105
  388690
  395824
  396020
  401239
  401919
  405061
  408214
  414301
  417349
  417801
  421250
  424458
  424876
  426009
  426294
  427112
  431446
  432787
  437855
  438772
  439457
  439751
  443099
  443784
  444003
  445641
  446167
  446275
  447926
  454802
  456136
  458191
  461723
  463094
  464327
  466241
  468733
  474685
  479709
  483788
  484737
  489280
  490404
  491256
  495149
  497953
  499104
  499111
  499598
  499852
  509802
  509981
  513540
  513965
  514395
  519563
  521453
  524882
  541833
  549187
  554119
  574384
  578815
  588264
  596839
  599361
  599478
  610314
  617421
  623199
  652712
  679567
  810663
  814746
]

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 (130105, 388690, 395824, 396020, 401239, 401919, 405061, 408214, 414301, 417349, 417801, 421250, 424458, 424876, 426009, 426294, 427112, 431446, 432787, 437855, 438772, 439457, 439751, 443099, 443784, 444003, 445641, 446167, 446275, 447926, 454802, 456136, 458191, 461723, 463094, 464327, 466241, 468733, 474685, 479709, 483788, 484737, 489280, 490404, 491256, 495149, 497953, 499104, 499111, 499598, 499852, 509802, 509981, 513540, 513965, 514395, 519563, 521453, 524882, 541833, 549187, 554119, 574384, 578815, 588264, 596839, 599361, 599478, 610314, 617421, 623199, 652712, 679567, 810663, 814746);

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
  130105
  388690
  395824
  396020
  401239
  401919
  405061
  408214
  414301
  417349
  417801
  421250
  424458
  424876
  426009
  426294
  427112
  431446
  432787
  437855
  438772
  439457
  439751
  443099
  443784
  444003
  445641
  446167
  446275
  447926
  454802
  456136
  458191
  461723
  463094
  464327
  466241
  468733
  474685
  479709
  483788
  484737
  489280
  490404
  491256
  495149
  497953
  499104
  499111
  499598
  499852
  509802
  509981
  513540
  513965
  514395
  519563
  521453
  524882
  541833
  549187
  554119
  574384
  578815
  588264
  596839
  599361
  599478
  610314
  617421
  623199
  652712
  679567
  810663
  814746
]

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 (130105, 388690, 395824, 396020, 401239, 401919, 405061, 408214, 414301, 417349, 417801, 421250, 424458, 424876, 426009, 426294, 427112, 431446, 432787, 437855, 438772, 439457, 439751, 443099, 443784, 444003, 445641, 446167, 446275, 447926, 454802, 456136, 458191, 461723, 463094, 464327, 466241, 468733, 474685, 479709, 483788, 484737, 489280, 490404, 491256, 495149, 497953, 499104, 499111, 499598, 499852, 509802, 509981, 513540, 513965, 514395, 519563, 521453, 524882, 541833, 549187, 554119, 574384, 578815, 588264, 596839, 599361, 599478, 610314, 617421, 623199, 652712, 679567, 810663, 814746);

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` = 'толстые анал';