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

[
  "desi homemade"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'desi homemade' 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
  811898
  794818
  730110
  734794
  736509
  736257
  742535
  591816
  484260
  509903
  507783
  749486
  668960
  610104
  596982
  728134
  572689
  573536
  577101
  650666
  467119
  584868
  717278
  602993
  803292
  802841
  738175
  749541
  762804
  716974
  803164
  520474
  816647
  493283
  571469
  575707
  714147
  760381
  797191
  749520
  495364
  507792
  513843
  605567
  589664
  667253
  590265
  593247
  533291
  528816
  543929
  547538
  717274
  801234
  725408
  736226
  716965
  537531
  564504
  796822
  518542
  524325
  590975
  551935
  528915
  716980
  467122
  561345
  575710
  602562
  592318
  527889
  615145
  533289
  472299
  543434
  547525
]

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 (811898, 794818, 730110, 734794, 736509, 736257, 742535, 591816, 484260, 509903, 507783, 749486, 668960, 610104, 596982, 728134, 572689, 573536, 577101, 650666, 467119, 584868, 717278, 602993, 803292, 802841, 738175, 749541, 762804, 716974, 803164, 520474, 816647, 493283, 571469, 575707, 714147, 760381, 797191, 749520, 495364, 507792, 513843, 605567, 589664, 667253, 590265, 593247, 533291, 528816, 543929, 547538, 717274, 801234, 725408, 736226, 716965, 537531, 564504, 796822, 518542, 524325, 590975, 551935, 528915, 716980, 467122, 561345, 575710, 602562, 592318, 527889, 615145, 533289, 472299, 543434, 547525);

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
  467119
  467122
  472299
  484260
  493283
  495364
  507783
  507792
  509903
  513843
  518542
  520474
  524325
  527889
  528816
  528915
  533289
  533291
  537531
  543434
  543929
  547525
  547538
  551935
  561345
  564504
  571469
  572689
  573536
  575707
  575710
  577101
  584868
  589664
  590265
  590975
  591816
  592318
  593247
  596982
  602562
  602993
  605567
  610104
  615145
  650666
  667253
  668960
  714147
  716965
  716974
  716980
  717274
  717278
  725408
  728134
  730110
  734794
  736226
  736257
  736509
  738175
  742535
  749486
  749520
  749541
  760381
  762804
  794818
  796822
  797191
  801234
  802841
  803164
  803292
  811898
  816647
]

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 (467119, 467122, 472299, 484260, 493283, 495364, 507783, 507792, 509903, 513843, 518542, 520474, 524325, 527889, 528816, 528915, 533289, 533291, 537531, 543434, 543929, 547525, 547538, 551935, 561345, 564504, 571469, 572689, 573536, 575707, 575710, 577101, 584868, 589664, 590265, 590975, 591816, 592318, 593247, 596982, 602562, 602993, 605567, 610104, 615145, 650666, 667253, 668960, 714147, 716965, 716974, 716980, 717274, 717278, 725408, 728134, 730110, 734794, 736226, 736257, 736509, 738175, 742535, 749486, 749520, 749541, 760381, 762804, 794818, 796822, 797191, 801234, 802841, 803164, 803292, 811898, 816647);

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
  467119
  467122
  472299
  484260
  493283
  495364
  507783
  507792
  509903
  513843
  518542
  520474
  524325
  527889
  528816
  528915
  533289
  533291
  537531
  543434
  543929
  547525
  547538
  551935
  561345
  564504
  571469
  572689
  573536
  575707
  575710
  577101
  584868
  589664
  590265
  590975
  591816
  592318
  593247
  596982
  602562
  602993
  605567
  610104
  615145
  650666
  667253
  668960
  714147
  716965
  716974
  716980
  717274
  717278
  725408
  728134
  730110
  734794
  736226
  736257
  736509
  738175
  742535
  749486
  749520
  749541
  760381
  762804
  794818
  796822
  797191
  801234
  802841
  803164
  803292
  811898
  816647
]

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 (467119, 467122, 472299, 484260, 493283, 495364, 507783, 507792, 509903, 513843, 518542, 520474, 524325, 527889, 528816, 528915, 533289, 533291, 537531, 543434, 543929, 547525, 547538, 551935, 561345, 564504, 571469, 572689, 573536, 575707, 575710, 577101, 584868, 589664, 590265, 590975, 591816, 592318, 593247, 596982, 602562, 602993, 605567, 610104, 615145, 650666, 667253, 668960, 714147, 716965, 716974, 716980, 717274, 717278, 725408, 728134, 730110, 734794, 736226, 736257, 736509, 738175, 742535, 749486, 749520, 749541, 760381, 762804, 794818, 796822, 797191, 801234, 802841, 803164, 803292, 811898, 816647);

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

[
  "desi домашн любительск"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'desi домашн любительск';

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

[
  "desi домашн любительск"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'desi домашн любительск';