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

[
  "nice girl"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'nice girl' 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
  634139
  804771
  472517
  492026
  497667
  399209
  528344
  448314
  814175
  491773
  560067
  465010
  524608
  535038
  676467
  712882
  447512
  454227
  519891
  647305
  592229
  430349
  491906
  492279
  524855
  428394
  457138
  509095
  446977
  550443
  446364
  565192
  599184
  524635
  524836
  507710
  518313
  528041
  603696
  455861
  462955
  477100
  518406
  550579
  716811
  566330
  615826
  472299
  598653
  514327
  514715
  486199
  550128
  478802
  516025
  550031
  445672
  565181
  591510
  651954
  601827
  620239
  475951
  651929
  651933
  605586
  544296
  653189
  514717
  621294
  506269
  511009
  523822
  502695
]

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 (634139, 804771, 472517, 492026, 497667, 399209, 528344, 448314, 814175, 491773, 560067, 465010, 524608, 535038, 676467, 712882, 447512, 454227, 519891, 647305, 592229, 430349, 491906, 492279, 524855, 428394, 457138, 509095, 446977, 550443, 446364, 565192, 599184, 524635, 524836, 507710, 518313, 528041, 603696, 455861, 462955, 477100, 518406, 550579, 716811, 566330, 615826, 472299, 598653, 514327, 514715, 486199, 550128, 478802, 516025, 550031, 445672, 565181, 591510, 651954, 601827, 620239, 475951, 651929, 651933, 605586, 544296, 653189, 514717, 621294, 506269, 511009, 523822, 502695);

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
  399209
  428394
  430349
  445672
  446364
  446977
  447512
  448314
  454227
  455861
  457138
  462955
  465010
  472299
  472517
  475951
  477100
  478802
  486199
  491773
  491906
  492026
  492279
  497667
  502695
  506269
  507710
  509095
  511009
  514327
  514715
  514717
  516025
  518313
  518406
  519891
  523822
  524608
  524635
  524836
  524855
  528041
  528344
  535038
  544296
  550031
  550128
  550443
  550579
  560067
  565181
  565192
  566330
  591510
  592229
  598653
  599184
  601827
  603696
  605586
  615826
  620239
  621294
  634139
  647305
  651929
  651933
  651954
  653189
  676467
  712882
  716811
  804771
  814175
]

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 (399209, 428394, 430349, 445672, 446364, 446977, 447512, 448314, 454227, 455861, 457138, 462955, 465010, 472299, 472517, 475951, 477100, 478802, 486199, 491773, 491906, 492026, 492279, 497667, 502695, 506269, 507710, 509095, 511009, 514327, 514715, 514717, 516025, 518313, 518406, 519891, 523822, 524608, 524635, 524836, 524855, 528041, 528344, 535038, 544296, 550031, 550128, 550443, 550579, 560067, 565181, 565192, 566330, 591510, 592229, 598653, 599184, 601827, 603696, 605586, 615826, 620239, 621294, 634139, 647305, 651929, 651933, 651954, 653189, 676467, 712882, 716811, 804771, 814175);

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
  399209
  428394
  430349
  445672
  446364
  446977
  447512
  448314
  454227
  455861
  457138
  462955
  465010
  472299
  472517
  475951
  477100
  478802
  486199
  491773
  491906
  492026
  492279
  497667
  502695
  506269
  507710
  509095
  511009
  514327
  514715
  514717
  516025
  518313
  518406
  519891
  523822
  524608
  524635
  524836
  524855
  528041
  528344
  535038
  544296
  550031
  550128
  550443
  550579
  560067
  565181
  565192
  566330
  591510
  592229
  598653
  599184
  601827
  603696
  605586
  615826
  620239
  621294
  634139
  647305
  651929
  651933
  651954
  653189
  676467
  712882
  716811
  804771
  814175
]

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 (399209, 428394, 430349, 445672, 446364, 446977, 447512, 448314, 454227, 455861, 457138, 462955, 465010, 472299, 472517, 475951, 477100, 478802, 486199, 491773, 491906, 492026, 492279, 497667, 502695, 506269, 507710, 509095, 511009, 514327, 514715, 514717, 516025, 518313, 518406, 519891, 523822, 524608, 524635, 524836, 524855, 528041, 528344, 535038, 544296, 550031, 550128, 550443, 550579, 560067, 565181, 565192, 566330, 591510, 592229, 598653, 599184, 601827, 603696, 605586, 615826, 620239, 621294, 634139, 647305, 651929, 651933, 651954, 653189, 676467, 712882, 716811, 804771, 814175);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "nice девушк"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'nice девушк';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "nice девушк"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'nice девушк';