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

[
  "fuck mom real"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'fuck mom real' 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
  544964
  480417
  647328
  647609
  814850
  533848
  443167
  449764
  576002
  541074
  631919
  422159
  421831
  439770
  433371
  485057
  516034
  577620
  400494
  485064
  521759
  488772
  524217
  519512
  541316
  523907
  539147
  572697
  668528
  786552
  572038
  718798
  728946
  518159
  750701
  422151
  454141
  485037
  600411
  636598
  579292
  421878
  421900
  442613
  444883
  513750
  421922
  563875
  517564
  537672
  623089
  612053
  525286
  537670
  650992
  600995
  586009
  523840
  540071
  439764
  433323
  496518
  606624
  428756
  529143
  470302
  594353
  563787
  639810
  459513
  532572
  626136
  527908
  428761
  572716
  510254
  604419
  526951
  568062
  599967
  577491
  621764
  513001
]

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 (544964, 480417, 647328, 647609, 814850, 533848, 443167, 449764, 576002, 541074, 631919, 422159, 421831, 439770, 433371, 485057, 516034, 577620, 400494, 485064, 521759, 488772, 524217, 519512, 541316, 523907, 539147, 572697, 668528, 786552, 572038, 718798, 728946, 518159, 750701, 422151, 454141, 485037, 600411, 636598, 579292, 421878, 421900, 442613, 444883, 513750, 421922, 563875, 517564, 537672, 623089, 612053, 525286, 537670, 650992, 600995, 586009, 523840, 540071, 439764, 433323, 496518, 606624, 428756, 529143, 470302, 594353, 563787, 639810, 459513, 532572, 626136, 527908, 428761, 572716, 510254, 604419, 526951, 568062, 599967, 577491, 621764, 513001);

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
  400494
  421831
  421878
  421900
  421922
  422151
  422159
  428756
  428761
  433323
  433371
  439764
  439770
  442613
  443167
  444883
  449764
  454141
  459513
  470302
  480417
  485037
  485057
  485064
  488772
  496518
  510254
  513001
  513750
  516034
  517564
  518159
  519512
  521759
  523840
  523907
  524217
  525286
  526951
  527908
  529143
  532572
  533848
  537670
  537672
  539147
  540071
  541074
  541316
  544964
  563787
  563875
  568062
  572038
  572697
  572716
  576002
  577491
  577620
  579292
  586009
  594353
  599967
  600411
  600995
  604419
  606624
  612053
  621764
  623089
  626136
  631919
  636598
  639810
  647328
  647609
  650992
  668528
  718798
  728946
  750701
  786552
  814850
]

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 (400494, 421831, 421878, 421900, 421922, 422151, 422159, 428756, 428761, 433323, 433371, 439764, 439770, 442613, 443167, 444883, 449764, 454141, 459513, 470302, 480417, 485037, 485057, 485064, 488772, 496518, 510254, 513001, 513750, 516034, 517564, 518159, 519512, 521759, 523840, 523907, 524217, 525286, 526951, 527908, 529143, 532572, 533848, 537670, 537672, 539147, 540071, 541074, 541316, 544964, 563787, 563875, 568062, 572038, 572697, 572716, 576002, 577491, 577620, 579292, 586009, 594353, 599967, 600411, 600995, 604419, 606624, 612053, 621764, 623089, 626136, 631919, 636598, 639810, 647328, 647609, 650992, 668528, 718798, 728946, 750701, 786552, 814850);

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
  400494
  421831
  421878
  421900
  421922
  422151
  422159
  428756
  428761
  433323
  433371
  439764
  439770
  442613
  443167
  444883
  449764
  454141
  459513
  470302
  480417
  485037
  485057
  485064
  488772
  496518
  510254
  513001
  513750
  516034
  517564
  518159
  519512
  521759
  523840
  523907
  524217
  525286
  526951
  527908
  529143
  532572
  533848
  537670
  537672
  539147
  540071
  541074
  541316
  544964
  563787
  563875
  568062
  572038
  572697
  572716
  576002
  577491
  577620
  579292
  586009
  594353
  599967
  600411
  600995
  604419
  606624
  612053
  621764
  623089
  626136
  631919
  636598
  639810
  647328
  647609
  650992
  668528
  718798
  728946
  750701
  786552
  814850
]

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 (400494, 421831, 421878, 421900, 421922, 422151, 422159, 428756, 428761, 433323, 433371, 439764, 439770, 442613, 443167, 444883, 449764, 454141, 459513, 470302, 480417, 485037, 485057, 485064, 488772, 496518, 510254, 513001, 513750, 516034, 517564, 518159, 519512, 521759, 523840, 523907, 524217, 525286, 526951, 527908, 529143, 532572, 533848, 537670, 537672, 539147, 540071, 541074, 541316, 544964, 563787, 563875, 568062, 572038, 572697, 572716, 576002, 577491, 577620, 579292, 586009, 594353, 599967, 600411, 600995, 604419, 606624, 612053, 621764, 623089, 626136, 631919, 636598, 639810, 647328, 647609, 650992, 668528, 718798, 728946, 750701, 786552, 814850);

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

[
  "секс mom real"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'секс mom real';

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

[
  "секс mom real"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс mom real';