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
  578290
  583370
  583614
  704560
  661008
  626538
  630870
  587555
  591613
  617217
  603436
  604414
  612065
  620768
  511545
  524845
  461731
  525637
  496359
  528399
  555657
  563654
  647928
  590891
  604094
  614027
  644244
  610559
  632687
  444527
  461040
  531545
  580201
  561087
  564122
  568972
  703836
  545424
  562340
  637103
  595931
  723994
  639731
  470414
  535655
  532241
  495835
  496080
  578494
  545621
  648220
  670564
  646884
  594016
  637080
  633758
  716902
  534845
  576529
  646849
  649596
  607049
  606482
  532245
  534387
  647307
  610555
  532662
  532661
  545437
  595121
  608756
]

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 (578290, 583370, 583614, 704560, 661008, 626538, 630870, 587555, 591613, 617217, 603436, 604414, 612065, 620768, 511545, 524845, 461731, 525637, 496359, 528399, 555657, 563654, 647928, 590891, 604094, 614027, 644244, 610559, 632687, 444527, 461040, 531545, 580201, 561087, 564122, 568972, 703836, 545424, 562340, 637103, 595931, 723994, 639731, 470414, 535655, 532241, 495835, 496080, 578494, 545621, 648220, 670564, 646884, 594016, 637080, 633758, 716902, 534845, 576529, 646849, 649596, 607049, 606482, 532245, 534387, 647307, 610555, 532662, 532661, 545437, 595121, 608756);

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
  444527
  461040
  461731
  470414
  495835
  496080
  496359
  511545
  524845
  525637
  528399
  531545
  532241
  532245
  532661
  532662
  534387
  534845
  535655
  545424
  545437
  545621
  555657
  561087
  562340
  563654
  564122
  568972
  576529
  578290
  578494
  580201
  583370
  583614
  587555
  590891
  591613
  594016
  595121
  595931
  603436
  604094
  604414
  606482
  607049
  608756
  610555
  610559
  612065
  614027
  617217
  620768
  626538
  630870
  632687
  633758
  637080
  637103
  639731
  644244
  646849
  646884
  647307
  647928
  648220
  649596
  661008
  670564
  703836
  704560
  716902
  723994
]

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 (444527, 461040, 461731, 470414, 495835, 496080, 496359, 511545, 524845, 525637, 528399, 531545, 532241, 532245, 532661, 532662, 534387, 534845, 535655, 545424, 545437, 545621, 555657, 561087, 562340, 563654, 564122, 568972, 576529, 578290, 578494, 580201, 583370, 583614, 587555, 590891, 591613, 594016, 595121, 595931, 603436, 604094, 604414, 606482, 607049, 608756, 610555, 610559, 612065, 614027, 617217, 620768, 626538, 630870, 632687, 633758, 637080, 637103, 639731, 644244, 646849, 646884, 647307, 647928, 648220, 649596, 661008, 670564, 703836, 704560, 716902, 723994);

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
  444527
  461040
  461731
  470414
  495835
  496080
  496359
  511545
  524845
  525637
  528399
  531545
  532241
  532245
  532661
  532662
  534387
  534845
  535655
  545424
  545437
  545621
  555657
  561087
  562340
  563654
  564122
  568972
  576529
  578290
  578494
  580201
  583370
  583614
  587555
  590891
  591613
  594016
  595121
  595931
  603436
  604094
  604414
  606482
  607049
  608756
  610555
  610559
  612065
  614027
  617217
  620768
  626538
  630870
  632687
  633758
  637080
  637103
  639731
  644244
  646849
  646884
  647307
  647928
  648220
  649596
  661008
  670564
  703836
  704560
  716902
  723994
]

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 (444527, 461040, 461731, 470414, 495835, 496080, 496359, 511545, 524845, 525637, 528399, 531545, 532241, 532245, 532661, 532662, 534387, 534845, 535655, 545424, 545437, 545621, 555657, 561087, 562340, 563654, 564122, 568972, 576529, 578290, 578494, 580201, 583370, 583614, 587555, 590891, 591613, 594016, 595121, 595931, 603436, 604094, 604414, 606482, 607049, 608756, 610555, 610559, 612065, 614027, 617217, 620768, 626538, 630870, 632687, 633758, 637080, 637103, 639731, 644244, 646849, 646884, 647307, 647928, 648220, 649596, 661008, 670564, 703836, 704560, 716902, 723994);

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` = 'роуз';