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
  580243
  677064
  647495
  680249
  577697
  592481
  602642
  619724
  587937
  595358
  606946
  613310
  800030
  799553
  811124
  730914
  751567
  787120
  729260
  750718
  765860
  763720
  635584
  797437
  800178
  480924
  472244
  499371
  498254
  486421
  553227
  661974
  664593
  696202
  705099
  666125
  668508
  696430
  562062
  592762
  586566
  599305
  642504
  784003
  772600
  731437
  610654
  804927
  479006
  503459
  441537
  532351
  534784
  495579
  516754
  528692
  530943
  697006
  552343
  568973
  614956
  619823
  595099
  593812
  750611
  466821
  507697
  502841
  596555
  749924
  423349
  506088
  530935
  623744
  609161
  605359
  509981
  568455
  585976
  528788
  613394
]

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 (580243, 677064, 647495, 680249, 577697, 592481, 602642, 619724, 587937, 595358, 606946, 613310, 800030, 799553, 811124, 730914, 751567, 787120, 729260, 750718, 765860, 763720, 635584, 797437, 800178, 480924, 472244, 499371, 498254, 486421, 553227, 661974, 664593, 696202, 705099, 666125, 668508, 696430, 562062, 592762, 586566, 599305, 642504, 784003, 772600, 731437, 610654, 804927, 479006, 503459, 441537, 532351, 534784, 495579, 516754, 528692, 530943, 697006, 552343, 568973, 614956, 619823, 595099, 593812, 750611, 466821, 507697, 502841, 596555, 749924, 423349, 506088, 530935, 623744, 609161, 605359, 509981, 568455, 585976, 528788, 613394);

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
  423349
  441537
  466821
  472244
  479006
  480924
  486421
  495579
  498254
  499371
  502841
  503459
  506088
  507697
  509981
  516754
  528692
  528788
  530935
  530943
  532351
  534784
  552343
  553227
  562062
  568455
  568973
  577697
  580243
  585976
  586566
  587937
  592481
  592762
  593812
  595099
  595358
  596555
  599305
  602642
  605359
  606946
  609161
  610654
  613310
  613394
  614956
  619724
  619823
  623744
  635584
  642504
  647495
  661974
  664593
  666125
  668508
  677064
  680249
  696202
  696430
  697006
  705099
  729260
  730914
  731437
  749924
  750611
  750718
  751567
  763720
  765860
  772600
  784003
  787120
  797437
  799553
  800030
  804927
  811124
]

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 (423349, 441537, 466821, 472244, 479006, 480924, 486421, 495579, 498254, 499371, 502841, 503459, 506088, 507697, 509981, 516754, 528692, 528788, 530935, 530943, 532351, 534784, 552343, 553227, 562062, 568455, 568973, 577697, 580243, 585976, 586566, 587937, 592481, 592762, 593812, 595099, 595358, 596555, 599305, 602642, 605359, 606946, 609161, 610654, 613310, 613394, 614956, 619724, 619823, 623744, 635584, 642504, 647495, 661974, 664593, 666125, 668508, 677064, 680249, 696202, 696430, 697006, 705099, 729260, 730914, 731437, 749924, 750611, 750718, 751567, 763720, 765860, 772600, 784003, 787120, 797437, 799553, 800030, 804927, 811124);

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
  423349
  441537
  466821
  472244
  479006
  480924
  486421
  495579
  498254
  499371
  502841
  503459
  506088
  507697
  509981
  516754
  528692
  528788
  530935
  530943
  532351
  534784
  552343
  553227
  562062
  568455
  568973
  577697
  580243
  585976
  586566
  587937
  592481
  592762
  593812
  595099
  595358
  596555
  599305
  602642
  605359
  606946
  609161
  610654
  613310
  613394
  614956
  619724
  619823
  623744
  635584
  642504
  647495
  661974
  664593
  666125
  668508
  677064
  680249
  696202
  696430
  697006
  705099
  729260
  730914
  731437
  749924
  750611
  750718
  751567
  763720
  765860
  772600
  784003
  787120
  797437
  799553
  800030
  804927
  811124
]

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 (423349, 441537, 466821, 472244, 479006, 480924, 486421, 495579, 498254, 499371, 502841, 503459, 506088, 507697, 509981, 516754, 528692, 528788, 530935, 530943, 532351, 534784, 552343, 553227, 562062, 568455, 568973, 577697, 580243, 585976, 586566, 587937, 592481, 592762, 593812, 595099, 595358, 596555, 599305, 602642, 605359, 606946, 609161, 610654, 613310, 613394, 614956, 619724, 619823, 623744, 635584, 642504, 647495, 661974, 664593, 666125, 668508, 677064, 680249, 696202, 696430, 697006, 705099, 729260, 730914, 731437, 749924, 750611, 750718, 751567, 763720, 765860, 772600, 784003, 787120, 797437, 799553, 800030, 804927, 811124);

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` = 'фанат';