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

[
  "anal young hard"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal young hard' 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
  824920
  549060
  631196
  598505
  545363
  485232
  530663
  536681
  530018
  501598
  537209
  575815
  476559
  382971
  785572
  401032
  570145
  449021
  432662
  425518
  565276
  675008
  389966
  449428
  470852
  597204
  509810
  438001
  825812
  454076
  533519
  545601
  807327
  790218
  466369
  469472
  426009
  459513
  485061
  739535
  600011
  523924
  440993
  406089
  481134
  477097
  191048
  520319
  419370
  594231
  389500
  539210
  619513
  486445
  523389
  619536
  457971
  517008
  520753
  536584
  537212
  735778
  537970
  529801
  814901
  540339
  530275
  404629
  527902
  647837
  441022
  534645
  537210
  541866
  562894
  639258
  597216
  536691
  619527
  626944
  400491
  520759
]

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 (824920, 549060, 631196, 598505, 545363, 485232, 530663, 536681, 530018, 501598, 537209, 575815, 476559, 382971, 785572, 401032, 570145, 449021, 432662, 425518, 565276, 675008, 389966, 449428, 470852, 597204, 509810, 438001, 825812, 454076, 533519, 545601, 807327, 790218, 466369, 469472, 426009, 459513, 485061, 739535, 600011, 523924, 440993, 406089, 481134, 477097, 191048, 520319, 419370, 594231, 389500, 539210, 619513, 486445, 523389, 619536, 457971, 517008, 520753, 536584, 537212, 735778, 537970, 529801, 814901, 540339, 530275, 404629, 527902, 647837, 441022, 534645, 537210, 541866, 562894, 639258, 597216, 536691, 619527, 626944, 400491, 520759);

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
  191048
  382971
  389500
  389966
  400491
  401032
  404629
  406089
  419370
  425518
  426009
  432662
  438001
  440993
  441022
  449021
  449428
  454076
  457971
  459513
  466369
  469472
  470852
  476559
  477097
  481134
  485061
  485232
  486445
  501598
  509810
  517008
  520319
  520753
  520759
  523389
  523924
  527902
  529801
  530018
  530275
  530663
  533519
  534645
  536584
  536681
  536691
  537209
  537210
  537212
  537970
  539210
  540339
  541866
  545363
  545601
  549060
  562894
  565276
  570145
  575815
  594231
  597204
  597216
  598505
  600011
  619513
  619527
  619536
  626944
  631196
  639258
  647837
  675008
  735778
  739535
  785572
  790218
  807327
  814901
  824920
  825812
]

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 (191048, 382971, 389500, 389966, 400491, 401032, 404629, 406089, 419370, 425518, 426009, 432662, 438001, 440993, 441022, 449021, 449428, 454076, 457971, 459513, 466369, 469472, 470852, 476559, 477097, 481134, 485061, 485232, 486445, 501598, 509810, 517008, 520319, 520753, 520759, 523389, 523924, 527902, 529801, 530018, 530275, 530663, 533519, 534645, 536584, 536681, 536691, 537209, 537210, 537212, 537970, 539210, 540339, 541866, 545363, 545601, 549060, 562894, 565276, 570145, 575815, 594231, 597204, 597216, 598505, 600011, 619513, 619527, 619536, 626944, 631196, 639258, 647837, 675008, 735778, 739535, 785572, 790218, 807327, 814901, 824920, 825812);

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
  191048
  382971
  389500
  389966
  400491
  401032
  404629
  406089
  419370
  425518
  426009
  432662
  438001
  440993
  441022
  449021
  449428
  454076
  457971
  459513
  466369
  469472
  470852
  476559
  477097
  481134
  485061
  485232
  486445
  501598
  509810
  517008
  520319
  520753
  520759
  523389
  523924
  527902
  529801
  530018
  530275
  530663
  533519
  534645
  536584
  536681
  536691
  537209
  537210
  537212
  537970
  539210
  540339
  541866
  545363
  545601
  549060
  562894
  565276
  570145
  575815
  594231
  597204
  597216
  598505
  600011
  619513
  619527
  619536
  626944
  631196
  639258
  647837
  675008
  735778
  739535
  785572
  790218
  807327
  814901
  824920
  825812
]

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 (191048, 382971, 389500, 389966, 400491, 401032, 404629, 406089, 419370, 425518, 426009, 432662, 438001, 440993, 441022, 449021, 449428, 454076, 457971, 459513, 466369, 469472, 470852, 476559, 477097, 481134, 485061, 485232, 486445, 501598, 509810, 517008, 520319, 520753, 520759, 523389, 523924, 527902, 529801, 530018, 530275, 530663, 533519, 534645, 536584, 536681, 536691, 537209, 537210, 537212, 537970, 539210, 540339, 541866, 545363, 545601, 549060, 562894, 565276, 570145, 575815, 594231, 597204, 597216, 598505, 600011, 619513, 619527, 619536, 626944, 631196, 639258, 647837, 675008, 735778, 739535, 785572, 790218, 807327, 814901, 824920, 825812);

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

[
  "анал young hard"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'анал young hard';

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

[
  "анал young hard"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'анал young hard';