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 hard young"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'fuck hard young' 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
  389500
  481463
  619543
  619513
  605365
  470852
  449021
  539210
  526212
  558904
  512549
  526254
  562059
  591035
  515916
  619528
  619510
  389966
  400491
  540800
  523032
  594231
  467498
  522975
  486583
  487648
  449428
  600011
  481134
  404629
  523389
  509810
  450822
  530275
  462208
  540339
  486445
  739535
  814901
  450510
  551222
  597204
  477097
  561307
  513506
  493102
  459513
  498019
  467508
  485061
  406089
  527902
  440993
  523924
  647837
  639258
  559712
  483627
  419370
  735778
  424780
  517008
  537210
  562894
  520753
  536584
  537212
  541866
  653472
  534645
  536691
  486835
  597216
  557570
  561480
  516472
  626944
  520759
  584720
  619527
]

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 (389500, 481463, 619543, 619513, 605365, 470852, 449021, 539210, 526212, 558904, 512549, 526254, 562059, 591035, 515916, 619528, 619510, 389966, 400491, 540800, 523032, 594231, 467498, 522975, 486583, 487648, 449428, 600011, 481134, 404629, 523389, 509810, 450822, 530275, 462208, 540339, 486445, 739535, 814901, 450510, 551222, 597204, 477097, 561307, 513506, 493102, 459513, 498019, 467508, 485061, 406089, 527902, 440993, 523924, 647837, 639258, 559712, 483627, 419370, 735778, 424780, 517008, 537210, 562894, 520753, 536584, 537212, 541866, 653472, 534645, 536691, 486835, 597216, 557570, 561480, 516472, 626944, 520759, 584720, 619527);

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
  389500
  389966
  400491
  404629
  406089
  419370
  424780
  440993
  449021
  449428
  450510
  450822
  459513
  462208
  467498
  467508
  470852
  477097
  481134
  481463
  483627
  485061
  486445
  486583
  486835
  487648
  493102
  498019
  509810
  512549
  513506
  515916
  516472
  517008
  520753
  520759
  522975
  523032
  523389
  523924
  526212
  526254
  527902
  530275
  534645
  536584
  536691
  537210
  537212
  539210
  540339
  540800
  541866
  551222
  557570
  558904
  559712
  561307
  561480
  562059
  562894
  584720
  591035
  594231
  597204
  597216
  600011
  605365
  619510
  619513
  619527
  619528
  619543
  626944
  639258
  647837
  653472
  735778
  739535
  814901
]

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 (389500, 389966, 400491, 404629, 406089, 419370, 424780, 440993, 449021, 449428, 450510, 450822, 459513, 462208, 467498, 467508, 470852, 477097, 481134, 481463, 483627, 485061, 486445, 486583, 486835, 487648, 493102, 498019, 509810, 512549, 513506, 515916, 516472, 517008, 520753, 520759, 522975, 523032, 523389, 523924, 526212, 526254, 527902, 530275, 534645, 536584, 536691, 537210, 537212, 539210, 540339, 540800, 541866, 551222, 557570, 558904, 559712, 561307, 561480, 562059, 562894, 584720, 591035, 594231, 597204, 597216, 600011, 605365, 619510, 619513, 619527, 619528, 619543, 626944, 639258, 647837, 653472, 735778, 739535, 814901);

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
  389500
  389966
  400491
  404629
  406089
  419370
  424780
  440993
  449021
  449428
  450510
  450822
  459513
  462208
  467498
  467508
  470852
  477097
  481134
  481463
  483627
  485061
  486445
  486583
  486835
  487648
  493102
  498019
  509810
  512549
  513506
  515916
  516472
  517008
  520753
  520759
  522975
  523032
  523389
  523924
  526212
  526254
  527902
  530275
  534645
  536584
  536691
  537210
  537212
  539210
  540339
  540800
  541866
  551222
  557570
  558904
  559712
  561307
  561480
  562059
  562894
  584720
  591035
  594231
  597204
  597216
  600011
  605365
  619510
  619513
  619527
  619528
  619543
  626944
  639258
  647837
  653472
  735778
  739535
  814901
]

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 (389500, 389966, 400491, 404629, 406089, 419370, 424780, 440993, 449021, 449428, 450510, 450822, 459513, 462208, 467498, 467508, 470852, 477097, 481134, 481463, 483627, 485061, 486445, 486583, 486835, 487648, 493102, 498019, 509810, 512549, 513506, 515916, 516472, 517008, 520753, 520759, 522975, 523032, 523389, 523924, 526212, 526254, 527902, 530275, 534645, 536584, 536691, 537210, 537212, 539210, 540339, 540800, 541866, 551222, 557570, 558904, 559712, 561307, 561480, 562059, 562894, 584720, 591035, 594231, 597204, 597216, 600011, 605365, 619510, 619513, 619527, 619528, 619543, 626944, 639258, 647837, 653472, 735778, 739535, 814901);

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

[
  "секс hard young"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'секс hard young';

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

[
  "секс hard young"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс hard young';