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
  806086
  725613
  473771
  717199
  635178
  632143
  797680
  749060
  533832
  813082
  532974
  670763
  537893
  647891
  736770
  463083
  580199
  615370
  634770
  600279
  607369
  572737
  661570
  497679
  577391
  614605
  793082
  495757
  473094
  601226
  534769
  542965
  668137
  623204
  504955
  519701
  571442
  640732
  448149
  484307
  615378
  526105
  617115
  500726
  594422
  623200
  641910
  788260
  518210
  500245
  429814
  542975
  533538
  600123
  588818
  560664
  500458
  530494
  519212
  604523
  557163
  689006
  537670
  650419
  623198
  535369
  565162
  752700
  518768
  628175
  534625
  534312
  680182
  704205
  647333
  556485
  648560
  516885
  543772
]

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 (806086, 725613, 473771, 717199, 635178, 632143, 797680, 749060, 533832, 813082, 532974, 670763, 537893, 647891, 736770, 463083, 580199, 615370, 634770, 600279, 607369, 572737, 661570, 497679, 577391, 614605, 793082, 495757, 473094, 601226, 534769, 542965, 668137, 623204, 504955, 519701, 571442, 640732, 448149, 484307, 615378, 526105, 617115, 500726, 594422, 623200, 641910, 788260, 518210, 500245, 429814, 542975, 533538, 600123, 588818, 560664, 500458, 530494, 519212, 604523, 557163, 689006, 537670, 650419, 623198, 535369, 565162, 752700, 518768, 628175, 534625, 534312, 680182, 704205, 647333, 556485, 648560, 516885, 543772);

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
  429814
  448149
  463083
  473094
  473771
  484307
  495757
  497679
  500245
  500458
  500726
  504955
  516885
  518210
  518768
  519212
  519701
  526105
  530494
  532974
  533538
  533832
  534312
  534625
  534769
  535369
  537670
  537893
  542965
  542975
  543772
  556485
  557163
  560664
  565162
  571442
  572737
  577391
  580199
  588818
  594422
  600123
  600279
  601226
  604523
  607369
  614605
  615370
  615378
  617115
  623198
  623200
  623204
  628175
  632143
  634770
  635178
  640732
  641910
  647333
  647891
  648560
  650419
  661570
  668137
  670763
  680182
  689006
  704205
  717199
  725613
  736770
  749060
  752700
  788260
  793082
  797680
  806086
  813082
]

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 (429814, 448149, 463083, 473094, 473771, 484307, 495757, 497679, 500245, 500458, 500726, 504955, 516885, 518210, 518768, 519212, 519701, 526105, 530494, 532974, 533538, 533832, 534312, 534625, 534769, 535369, 537670, 537893, 542965, 542975, 543772, 556485, 557163, 560664, 565162, 571442, 572737, 577391, 580199, 588818, 594422, 600123, 600279, 601226, 604523, 607369, 614605, 615370, 615378, 617115, 623198, 623200, 623204, 628175, 632143, 634770, 635178, 640732, 641910, 647333, 647891, 648560, 650419, 661570, 668137, 670763, 680182, 689006, 704205, 717199, 725613, 736770, 749060, 752700, 788260, 793082, 797680, 806086, 813082);

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
  429814
  448149
  463083
  473094
  473771
  484307
  495757
  497679
  500245
  500458
  500726
  504955
  516885
  518210
  518768
  519212
  519701
  526105
  530494
  532974
  533538
  533832
  534312
  534625
  534769
  535369
  537670
  537893
  542965
  542975
  543772
  556485
  557163
  560664
  565162
  571442
  572737
  577391
  580199
  588818
  594422
  600123
  600279
  601226
  604523
  607369
  614605
  615370
  615378
  617115
  623198
  623200
  623204
  628175
  632143
  634770
  635178
  640732
  641910
  647333
  647891
  648560
  650419
  661570
  668137
  670763
  680182
  689006
  704205
  717199
  725613
  736770
  749060
  752700
  788260
  793082
  797680
  806086
  813082
]

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 (429814, 448149, 463083, 473094, 473771, 484307, 495757, 497679, 500245, 500458, 500726, 504955, 516885, 518210, 518768, 519212, 519701, 526105, 530494, 532974, 533538, 533832, 534312, 534625, 534769, 535369, 537670, 537893, 542965, 542975, 543772, 556485, 557163, 560664, 565162, 571442, 572737, 577391, 580199, 588818, 594422, 600123, 600279, 601226, 604523, 607369, 614605, 615370, 615378, 617115, 623198, 623200, 623204, 628175, 632143, 634770, 635178, 640732, 641910, 647333, 647891, 648560, 650419, 661570, 668137, 670763, 680182, 689006, 704205, 717199, 725613, 736770, 749060, 752700, 788260, 793082, 797680, 806086, 813082);

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` = 'секс супер';