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
  446376
  569088
  659153
  648876
  598756
  601491
  588285
  603092
  623457
  429660
  550778
  563580
  584907
  572164
  654322
  564453
  581968
  589450
  606217
  598449
  606822
  618442
  605812
  617069
  618926
  414865
  514327
  544296
  541640
  550100
  555953
  578219
  547241
  560569
  653459
  654503
  657046
  659323
  659325
  578467
  581797
  591980
  606203
  590596
  590670
  590910
  599057
  604247
  586406
  589721
  591439
  591896
  597542
  599404
  601537
  611416
  625205
  620995
  413141
  504840
  532246
  646826
  598485
  598711
  601314
  600535
  617165
  614921
  625701
  475891
  471667
  468065
  516254
  543419
  616994
]

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 (446376, 569088, 659153, 648876, 598756, 601491, 588285, 603092, 623457, 429660, 550778, 563580, 584907, 572164, 654322, 564453, 581968, 589450, 606217, 598449, 606822, 618442, 605812, 617069, 618926, 414865, 514327, 544296, 541640, 550100, 555953, 578219, 547241, 560569, 653459, 654503, 657046, 659323, 659325, 578467, 581797, 591980, 606203, 590596, 590670, 590910, 599057, 604247, 586406, 589721, 591439, 591896, 597542, 599404, 601537, 611416, 625205, 620995, 413141, 504840, 532246, 646826, 598485, 598711, 601314, 600535, 617165, 614921, 625701, 475891, 471667, 468065, 516254, 543419, 616994);

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
  413141
  414865
  429660
  446376
  468065
  471667
  475891
  504840
  514327
  516254
  532246
  541640
  543419
  544296
  547241
  550100
  550778
  555953
  560569
  563580
  564453
  569088
  572164
  578219
  578467
  581797
  581968
  584907
  586406
  588285
  589450
  589721
  590596
  590670
  590910
  591439
  591896
  591980
  597542
  598449
  598485
  598711
  598756
  599057
  599404
  600535
  601314
  601491
  601537
  603092
  604247
  605812
  606203
  606217
  606822
  611416
  614921
  616994
  617069
  617165
  618442
  618926
  620995
  623457
  625205
  625701
  646826
  648876
  653459
  654322
  654503
  657046
  659153
  659323
  659325
]

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 (413141, 414865, 429660, 446376, 468065, 471667, 475891, 504840, 514327, 516254, 532246, 541640, 543419, 544296, 547241, 550100, 550778, 555953, 560569, 563580, 564453, 569088, 572164, 578219, 578467, 581797, 581968, 584907, 586406, 588285, 589450, 589721, 590596, 590670, 590910, 591439, 591896, 591980, 597542, 598449, 598485, 598711, 598756, 599057, 599404, 600535, 601314, 601491, 601537, 603092, 604247, 605812, 606203, 606217, 606822, 611416, 614921, 616994, 617069, 617165, 618442, 618926, 620995, 623457, 625205, 625701, 646826, 648876, 653459, 654322, 654503, 657046, 659153, 659323, 659325);

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
  413141
  414865
  429660
  446376
  468065
  471667
  475891
  504840
  514327
  516254
  532246
  541640
  543419
  544296
  547241
  550100
  550778
  555953
  560569
  563580
  564453
  569088
  572164
  578219
  578467
  581797
  581968
  584907
  586406
  588285
  589450
  589721
  590596
  590670
  590910
  591439
  591896
  591980
  597542
  598449
  598485
  598711
  598756
  599057
  599404
  600535
  601314
  601491
  601537
  603092
  604247
  605812
  606203
  606217
  606822
  611416
  614921
  616994
  617069
  617165
  618442
  618926
  620995
  623457
  625205
  625701
  646826
  648876
  653459
  654322
  654503
  657046
  659153
  659323
  659325
]

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 (413141, 414865, 429660, 446376, 468065, 471667, 475891, 504840, 514327, 516254, 532246, 541640, 543419, 544296, 547241, 550100, 550778, 555953, 560569, 563580, 564453, 569088, 572164, 578219, 578467, 581797, 581968, 584907, 586406, 588285, 589450, 589721, 590596, 590670, 590910, 591439, 591896, 591980, 597542, 598449, 598485, 598711, 598756, 599057, 599404, 600535, 601314, 601491, 601537, 603092, 604247, 605812, 606203, 606217, 606822, 611416, 614921, 616994, 617069, 617165, 618442, 618926, 620995, 623457, 625205, 625701, 646826, 648876, 653459, 654322, 654503, 657046, 659153, 659323, 659325);

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` = 'нежн худая';