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

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

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
  15129
  130105
  388690
  395824
  396020
  401239
  401919
  405061
  408214
  414301
  417349
  417801
  421250
  424458
  424876
  425168
  426009
  426294
  427112
  431446
  437855
  438772
  439457
  439751
  443099
  443784
  444003
  445641
  446167
  446275
  447926
  454802
  456136
  458191
  461723
  463094
  464327
  468733
  474685
  483788
  484737
  489280
  490404
  491256
  495149
  497953
  499104
  499598
  499852
  509802
  509981
  513540
  513965
  514395
  519563
  521453
  524882
  537198
  541833
  549187
  554119
  574384
  578815
  588264
  596839
  599361
  599478
  605122
  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 (15129, 130105, 388690, 395824, 396020, 401239, 401919, 405061, 408214, 414301, 417349, 417801, 421250, 424458, 424876, 425168, 426009, 426294, 427112, 431446, 437855, 438772, 439457, 439751, 443099, 443784, 444003, 445641, 446167, 446275, 447926, 454802, 456136, 458191, 461723, 463094, 464327, 468733, 474685, 483788, 484737, 489280, 490404, 491256, 495149, 497953, 499104, 499598, 499852, 509802, 509981, 513540, 513965, 514395, 519563, 521453, 524882, 537198, 541833, 549187, 554119, 574384, 578815, 588264, 596839, 599361, 599478, 605122, 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
  15129
  130105
  388690
  395824
  396020
  401239
  401919
  405061
  408214
  414301
  417349
  417801
  421250
  424458
  424876
  425168
  426009
  426294
  427112
  431446
  437855
  438772
  439457
  439751
  443099
  443784
  444003
  445641
  446167
  446275
  447926
  454802
  456136
  458191
  461723
  463094
  464327
  468733
  474685
  483788
  484737
  489280
  490404
  491256
  495149
  497953
  499104
  499598
  499852
  509802
  509981
  513540
  513965
  514395
  519563
  521453
  524882
  537198
  541833
  549187
  554119
  574384
  578815
  588264
  596839
  599361
  599478
  605122
  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 (15129, 130105, 388690, 395824, 396020, 401239, 401919, 405061, 408214, 414301, 417349, 417801, 421250, 424458, 424876, 425168, 426009, 426294, 427112, 431446, 437855, 438772, 439457, 439751, 443099, 443784, 444003, 445641, 446167, 446275, 447926, 454802, 456136, 458191, 461723, 463094, 464327, 468733, 474685, 483788, 484737, 489280, 490404, 491256, 495149, 497953, 499104, 499598, 499852, 509802, 509981, 513540, 513965, 514395, 519563, 521453, 524882, 537198, 541833, 549187, 554119, 574384, 578815, 588264, 596839, 599361, 599478, 605122, 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` = 'анал анал толстые';