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

[
  "quick blowjob"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'quick blowjob' 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
  523069
  568144
  571062
  569193
  553990
  459217
  435019
  504351
  518786
  544549
  579470
  419099
  479316
  523653
  455523
  458286
  502731
  773850
  736369
  487259
  463624
  520825
  634222
  503808
  451878
  510955
  556518
  568147
  454620
  463634
  555903
  402715
  801982
  506118
  676582
  726410
  501381
  482360
  463016
  504232
  578261
  613599
  501048
  512947
  556967
  569026
  569010
  469303
  464611
  563337
  528268
  514969
  567087
  529168
  515063
  435479
  578835
  497230
  606599
  471498
  492549
  527341
  520654
  557595
  486954
  418427
  579511
  571723
  568610
  613995
  577670
  594353
  549187
  542903
  484331
  628277
  614611
  516119
  495217
  568072
  596500
]

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 (523069, 568144, 571062, 569193, 553990, 459217, 435019, 504351, 518786, 544549, 579470, 419099, 479316, 523653, 455523, 458286, 502731, 773850, 736369, 487259, 463624, 520825, 634222, 503808, 451878, 510955, 556518, 568147, 454620, 463634, 555903, 402715, 801982, 506118, 676582, 726410, 501381, 482360, 463016, 504232, 578261, 613599, 501048, 512947, 556967, 569026, 569010, 469303, 464611, 563337, 528268, 514969, 567087, 529168, 515063, 435479, 578835, 497230, 606599, 471498, 492549, 527341, 520654, 557595, 486954, 418427, 579511, 571723, 568610, 613995, 577670, 594353, 549187, 542903, 484331, 628277, 614611, 516119, 495217, 568072, 596500);

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
  402715
  418427
  419099
  435019
  435479
  451878
  454620
  455523
  458286
  459217
  463016
  463624
  463634
  464611
  469303
  471498
  479316
  482360
  484331
  486954
  487259
  492549
  495217
  497230
  501048
  501381
  502731
  503808
  504232
  504351
  506118
  510955
  512947
  514969
  515063
  516119
  518786
  520654
  520825
  523069
  523653
  527341
  528268
  529168
  542903
  544549
  549187
  553990
  555903
  556518
  556967
  557595
  563337
  567087
  568072
  568144
  568147
  568610
  569010
  569026
  569193
  571062
  571723
  577670
  578261
  578835
  579470
  579511
  594353
  596500
  606599
  613599
  613995
  614611
  628277
  634222
  726410
  736369
  773850
  801982
]

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 (402715, 418427, 419099, 435019, 435479, 451878, 454620, 455523, 458286, 459217, 463016, 463624, 463634, 464611, 469303, 471498, 479316, 482360, 484331, 486954, 487259, 492549, 495217, 497230, 501048, 501381, 502731, 503808, 504232, 504351, 506118, 510955, 512947, 514969, 515063, 516119, 518786, 520654, 520825, 523069, 523653, 527341, 528268, 529168, 542903, 544549, 549187, 553990, 555903, 556518, 556967, 557595, 563337, 567087, 568072, 568144, 568147, 568610, 569010, 569026, 569193, 571062, 571723, 577670, 578261, 578835, 579470, 579511, 594353, 596500, 606599, 613599, 613995, 614611, 628277, 634222, 726410, 736369, 773850, 801982);

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
  402715
  418427
  419099
  435019
  435479
  451878
  454620
  455523
  458286
  459217
  463016
  463624
  463634
  464611
  469303
  471498
  479316
  482360
  484331
  486954
  487259
  492549
  495217
  497230
  501048
  501381
  502731
  503808
  504232
  504351
  506118
  510955
  512947
  514969
  515063
  516119
  518786
  520654
  520825
  523069
  523653
  527341
  528268
  529168
  542903
  544549
  549187
  553990
  555903
  556518
  556967
  557595
  563337
  567087
  568072
  568144
  568147
  568610
  569010
  569026
  569193
  571062
  571723
  577670
  578261
  578835
  579470
  579511
  594353
  596500
  606599
  613599
  613995
  614611
  628277
  634222
  726410
  736369
  773850
  801982
]

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 (402715, 418427, 419099, 435019, 435479, 451878, 454620, 455523, 458286, 459217, 463016, 463624, 463634, 464611, 469303, 471498, 479316, 482360, 484331, 486954, 487259, 492549, 495217, 497230, 501048, 501381, 502731, 503808, 504232, 504351, 506118, 510955, 512947, 514969, 515063, 516119, 518786, 520654, 520825, 523069, 523653, 527341, 528268, 529168, 542903, 544549, 549187, 553990, 555903, 556518, 556967, 557595, 563337, 567087, 568072, 568144, 568147, 568610, 569010, 569026, 569193, 571062, 571723, 577670, 578261, 578835, 579470, 579511, 594353, 596500, 606599, 613599, 613995, 614611, 628277, 634222, 726410, 736369, 773850, 801982);

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

[
  "quick минет оральн секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'quick минет оральн секс';

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

[
  "quick минет оральн секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'quick минет оральн секс';