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
  517819
  502464
  507686
  511407
  575133
  541380
  675675
  675723
  559998
  603298
  623973
  603973
  623962
  409021
  422438
  465934
  390923
  416038
  396003
  435069
  481726
  524006
  485537
  493174
  519118
  524509
  390629
  426531
  454522
  470936
  511031
  511033
  579660
  675429
  675431
  546380
  631110
  445243
  475883
  440222
  501748
  513465
  526827
  513427
  439726
  513155
  540400
  647954
  620726
  439622
  420547
  470527
  510426
  467572
  675123
  603759
  625222
  463066
  416012
  598031
  604990
  637243
  597015
  608364
  619355
  461141
  509879
  597256
  601944
  632261
  605105
  548056
  545611
  568072
  609845
  492525
  624270
  637074
]

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 (517819, 502464, 507686, 511407, 575133, 541380, 675675, 675723, 559998, 603298, 623973, 603973, 623962, 409021, 422438, 465934, 390923, 416038, 396003, 435069, 481726, 524006, 485537, 493174, 519118, 524509, 390629, 426531, 454522, 470936, 511031, 511033, 579660, 675429, 675431, 546380, 631110, 445243, 475883, 440222, 501748, 513465, 526827, 513427, 439726, 513155, 540400, 647954, 620726, 439622, 420547, 470527, 510426, 467572, 675123, 603759, 625222, 463066, 416012, 598031, 604990, 637243, 597015, 608364, 619355, 461141, 509879, 597256, 601944, 632261, 605105, 548056, 545611, 568072, 609845, 492525, 624270, 637074);

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
  390629
  390923
  396003
  409021
  416012
  416038
  420547
  422438
  426531
  435069
  439622
  439726
  440222
  445243
  454522
  461141
  463066
  465934
  467572
  470527
  470936
  475883
  481726
  485537
  492525
  493174
  501748
  502464
  507686
  509879
  510426
  511031
  511033
  511407
  513155
  513427
  513465
  517819
  519118
  524006
  524509
  526827
  540400
  541380
  545611
  546380
  548056
  559998
  568072
  575133
  579660
  597015
  597256
  598031
  601944
  603298
  603759
  603973
  604990
  605105
  608364
  609845
  619355
  620726
  623962
  623973
  624270
  625222
  631110
  632261
  637074
  637243
  647954
  675123
  675429
  675431
  675675
  675723
]

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 (390629, 390923, 396003, 409021, 416012, 416038, 420547, 422438, 426531, 435069, 439622, 439726, 440222, 445243, 454522, 461141, 463066, 465934, 467572, 470527, 470936, 475883, 481726, 485537, 492525, 493174, 501748, 502464, 507686, 509879, 510426, 511031, 511033, 511407, 513155, 513427, 513465, 517819, 519118, 524006, 524509, 526827, 540400, 541380, 545611, 546380, 548056, 559998, 568072, 575133, 579660, 597015, 597256, 598031, 601944, 603298, 603759, 603973, 604990, 605105, 608364, 609845, 619355, 620726, 623962, 623973, 624270, 625222, 631110, 632261, 637074, 637243, 647954, 675123, 675429, 675431, 675675, 675723);

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
  390629
  390923
  396003
  409021
  416012
  416038
  420547
  422438
  426531
  435069
  439622
  439726
  440222
  445243
  454522
  461141
  463066
  465934
  467572
  470527
  470936
  475883
  481726
  485537
  492525
  493174
  501748
  502464
  507686
  509879
  510426
  511031
  511033
  511407
  513155
  513427
  513465
  517819
  519118
  524006
  524509
  526827
  540400
  541380
  545611
  546380
  548056
  559998
  568072
  575133
  579660
  597015
  597256
  598031
  601944
  603298
  603759
  603973
  604990
  605105
  608364
  609845
  619355
  620726
  623962
  623973
  624270
  625222
  631110
  632261
  637074
  637243
  647954
  675123
  675429
  675431
  675675
  675723
]

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 (390629, 390923, 396003, 409021, 416012, 416038, 420547, 422438, 426531, 435069, 439622, 439726, 440222, 445243, 454522, 461141, 463066, 465934, 467572, 470527, 470936, 475883, 481726, 485537, 492525, 493174, 501748, 502464, 507686, 509879, 510426, 511031, 511033, 511407, 513155, 513427, 513465, 517819, 519118, 524006, 524509, 526827, 540400, 541380, 545611, 546380, 548056, 559998, 568072, 575133, 579660, 597015, 597256, 598031, 601944, 603298, 603759, 603973, 604990, 605105, 608364, 609845, 619355, 620726, 623962, 623973, 624270, 625222, 631110, 632261, 637074, 637243, 647954, 675123, 675429, 675431, 675675, 675723);

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` = 'черн';