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
  477404
  529154
  469533
  576678
  541872
  567304
  639253
  436132
  516880
  446144
  456607
  525941
  454326
  567163
  446203
  489661
  585363
  450977
  466836
  480782
  524300
  644276
  575810
  521535
  484708
  495652
  416208
  447009
  538281
  522889
  451943
  445015
  520984
  515341
  566781
  524530
  535326
  465317
  470968
  508554
  581809
  519572
  499111
  521089
  566112
  583021
  582899
  601995
  516122
  541821
  590405
  584503
  603552
  507308
  541667
  490061
  587185
  561137
  582624
  576638
  627730
  465487
  584749
  608200
  581797
  595871
  540330
  533996
  476604
  658421
  585725
  642662
  542187
  522878
  415160
  447835
]

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 (477404, 529154, 469533, 576678, 541872, 567304, 639253, 436132, 516880, 446144, 456607, 525941, 454326, 567163, 446203, 489661, 585363, 450977, 466836, 480782, 524300, 644276, 575810, 521535, 484708, 495652, 416208, 447009, 538281, 522889, 451943, 445015, 520984, 515341, 566781, 524530, 535326, 465317, 470968, 508554, 581809, 519572, 499111, 521089, 566112, 583021, 582899, 601995, 516122, 541821, 590405, 584503, 603552, 507308, 541667, 490061, 587185, 561137, 582624, 576638, 627730, 465487, 584749, 608200, 581797, 595871, 540330, 533996, 476604, 658421, 585725, 642662, 542187, 522878, 415160, 447835);

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
  415160
  416208
  436132
  445015
  446144
  446203
  447009
  447835
  450977
  451943
  454326
  456607
  465317
  465487
  466836
  469533
  470968
  476604
  477404
  480782
  484708
  489661
  490061
  495652
  499111
  507308
  508554
  515341
  516122
  516880
  519572
  520984
  521089
  521535
  522878
  522889
  524300
  524530
  525941
  529154
  533996
  535326
  538281
  540330
  541667
  541821
  541872
  542187
  561137
  566112
  566781
  567163
  567304
  575810
  576638
  576678
  581797
  581809
  582624
  582899
  583021
  584503
  584749
  585363
  585725
  587185
  590405
  595871
  601995
  603552
  608200
  627730
  639253
  642662
  644276
  658421
]

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 (415160, 416208, 436132, 445015, 446144, 446203, 447009, 447835, 450977, 451943, 454326, 456607, 465317, 465487, 466836, 469533, 470968, 476604, 477404, 480782, 484708, 489661, 490061, 495652, 499111, 507308, 508554, 515341, 516122, 516880, 519572, 520984, 521089, 521535, 522878, 522889, 524300, 524530, 525941, 529154, 533996, 535326, 538281, 540330, 541667, 541821, 541872, 542187, 561137, 566112, 566781, 567163, 567304, 575810, 576638, 576678, 581797, 581809, 582624, 582899, 583021, 584503, 584749, 585363, 585725, 587185, 590405, 595871, 601995, 603552, 608200, 627730, 639253, 642662, 644276, 658421);

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
  415160
  416208
  436132
  445015
  446144
  446203
  447009
  447835
  450977
  451943
  454326
  456607
  465317
  465487
  466836
  469533
  470968
  476604
  477404
  480782
  484708
  489661
  490061
  495652
  499111
  507308
  508554
  515341
  516122
  516880
  519572
  520984
  521089
  521535
  522878
  522889
  524300
  524530
  525941
  529154
  533996
  535326
  538281
  540330
  541667
  541821
  541872
  542187
  561137
  566112
  566781
  567163
  567304
  575810
  576638
  576678
  581797
  581809
  582624
  582899
  583021
  584503
  584749
  585363
  585725
  587185
  590405
  595871
  601995
  603552
  608200
  627730
  639253
  642662
  644276
  658421
]

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 (415160, 416208, 436132, 445015, 446144, 446203, 447009, 447835, 450977, 451943, 454326, 456607, 465317, 465487, 466836, 469533, 470968, 476604, 477404, 480782, 484708, 489661, 490061, 495652, 499111, 507308, 508554, 515341, 516122, 516880, 519572, 520984, 521089, 521535, 522878, 522889, 524300, 524530, 525941, 529154, 533996, 535326, 538281, 540330, 541667, 541821, 541872, 542187, 561137, 566112, 566781, 567163, 567304, 575810, 576638, 576678, 581797, 581809, 582624, 582899, 583021, 584503, 584749, 585363, 585725, 587185, 590405, 595871, 601995, 603552, 608200, 627730, 639253, 642662, 644276, 658421);

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` = 'секс костюм';