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
  511413
  497482
  493788
  444921
  644849
  464014
  464476
  478514
  452640
  508891
  473743
  558172
  556338
  569298
  554775
  592621
  590418
  705424
  797241
  407423
  423153
  429885
  461840
  473400
  429895
  445783
  466386
  444917
  450281
  452436
  454000
  457950
  460208
  493961
  497667
  527180
  482291
  467939
  579707
  569133
  554986
  671835
  607694
  607552
  600458
  697000
  797170
  454568
  486761
  507640
  510532
  477223
  554529
  613976
  604153
  419609
  508912
  518227
  518241
  509983
  486240
  602312
  606439
  629882
  624167
  522238
  515970
  452953
  599359
  598870
  606762
  537789
  486875
]

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 (511413, 497482, 493788, 444921, 644849, 464014, 464476, 478514, 452640, 508891, 473743, 558172, 556338, 569298, 554775, 592621, 590418, 705424, 797241, 407423, 423153, 429885, 461840, 473400, 429895, 445783, 466386, 444917, 450281, 452436, 454000, 457950, 460208, 493961, 497667, 527180, 482291, 467939, 579707, 569133, 554986, 671835, 607694, 607552, 600458, 697000, 797170, 454568, 486761, 507640, 510532, 477223, 554529, 613976, 604153, 419609, 508912, 518227, 518241, 509983, 486240, 602312, 606439, 629882, 624167, 522238, 515970, 452953, 599359, 598870, 606762, 537789, 486875);

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
  407423
  419609
  423153
  429885
  429895
  444917
  444921
  445783
  450281
  452436
  452640
  452953
  454000
  454568
  457950
  460208
  461840
  464014
  464476
  466386
  467939
  473400
  473743
  477223
  478514
  482291
  486240
  486761
  486875
  493788
  493961
  497482
  497667
  507640
  508891
  508912
  509983
  510532
  511413
  515970
  518227
  518241
  522238
  527180
  537789
  554529
  554775
  554986
  556338
  558172
  569133
  569298
  579707
  590418
  592621
  598870
  599359
  600458
  602312
  604153
  606439
  606762
  607552
  607694
  613976
  624167
  629882
  644849
  671835
  697000
  705424
  797170
  797241
]

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 (407423, 419609, 423153, 429885, 429895, 444917, 444921, 445783, 450281, 452436, 452640, 452953, 454000, 454568, 457950, 460208, 461840, 464014, 464476, 466386, 467939, 473400, 473743, 477223, 478514, 482291, 486240, 486761, 486875, 493788, 493961, 497482, 497667, 507640, 508891, 508912, 509983, 510532, 511413, 515970, 518227, 518241, 522238, 527180, 537789, 554529, 554775, 554986, 556338, 558172, 569133, 569298, 579707, 590418, 592621, 598870, 599359, 600458, 602312, 604153, 606439, 606762, 607552, 607694, 613976, 624167, 629882, 644849, 671835, 697000, 705424, 797170, 797241);

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
  407423
  419609
  423153
  429885
  429895
  444917
  444921
  445783
  450281
  452436
  452640
  452953
  454000
  454568
  457950
  460208
  461840
  464014
  464476
  466386
  467939
  473400
  473743
  477223
  478514
  482291
  486240
  486761
  486875
  493788
  493961
  497482
  497667
  507640
  508891
  508912
  509983
  510532
  511413
  515970
  518227
  518241
  522238
  527180
  537789
  554529
  554775
  554986
  556338
  558172
  569133
  569298
  579707
  590418
  592621
  598870
  599359
  600458
  602312
  604153
  606439
  606762
  607552
  607694
  613976
  624167
  629882
  644849
  671835
  697000
  705424
  797170
  797241
]

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 (407423, 419609, 423153, 429885, 429895, 444917, 444921, 445783, 450281, 452436, 452640, 452953, 454000, 454568, 457950, 460208, 461840, 464014, 464476, 466386, 467939, 473400, 473743, 477223, 478514, 482291, 486240, 486761, 486875, 493788, 493961, 497482, 497667, 507640, 508891, 508912, 509983, 510532, 511413, 515970, 518227, 518241, 522238, 527180, 537789, 554529, 554775, 554986, 556338, 558172, 569133, 569298, 579707, 590418, 592621, 598870, 599359, 600458, 602312, 604153, 606439, 606762, 607552, 607694, 613976, 624167, 629882, 644849, 671835, 697000, 705424, 797170, 797241);

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` = 'соло пышн';