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

[
  "mature onlyfans"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature onlyfans' 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
  594899
  640401
  601806
  775866
  775946
  785500
  809514
  780375
  784750
  726997
  745661
  749926
  775848
  775963
  787586
  472195
  484529
  604419
  542735
  555567
  660060
  667975
  700949
  680271
  680671
  607694
  587757
  590759
  613508
  791738
  767275
  775958
  778359
  511776
  586690
  430543
  453340
  550624
  652756
  613683
  595080
  596929
  603640
  786120
  637592
  447045
  583500
  564563
  599533
  602928
  604219
  614720
  558899
  572716
  605804
  610806
  586962
  578631
  603963
  607537
  549740
  593596
  549747
  593571
  539928
  564253
  585007
  602945
  549745
  549743
  652708
  612809
  549744
  618272
  540769
  563028
  710161
  586002
  540779
  539764
  549742
]

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 (594899, 640401, 601806, 775866, 775946, 785500, 809514, 780375, 784750, 726997, 745661, 749926, 775848, 775963, 787586, 472195, 484529, 604419, 542735, 555567, 660060, 667975, 700949, 680271, 680671, 607694, 587757, 590759, 613508, 791738, 767275, 775958, 778359, 511776, 586690, 430543, 453340, 550624, 652756, 613683, 595080, 596929, 603640, 786120, 637592, 447045, 583500, 564563, 599533, 602928, 604219, 614720, 558899, 572716, 605804, 610806, 586962, 578631, 603963, 607537, 549740, 593596, 549747, 593571, 539928, 564253, 585007, 602945, 549745, 549743, 652708, 612809, 549744, 618272, 540769, 563028, 710161, 586002, 540779, 539764, 549742);

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
  430543
  447045
  453340
  472195
  484529
  511776
  539764
  539928
  540769
  540779
  542735
  549740
  549742
  549743
  549744
  549745
  549747
  550624
  555567
  558899
  563028
  564253
  564563
  572716
  578631
  583500
  585007
  586002
  586690
  586962
  587757
  590759
  593571
  593596
  594899
  595080
  596929
  599533
  601806
  602928
  602945
  603640
  603963
  604219
  604419
  605804
  607537
  607694
  610806
  612809
  613508
  613683
  614720
  618272
  637592
  640401
  652708
  652756
  660060
  667975
  680271
  680671
  700949
  710161
  726997
  745661
  749926
  767275
  775848
  775866
  775946
  775958
  775963
  778359
  780375
  784750
  785500
  786120
  787586
  791738
  809514
]

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 (430543, 447045, 453340, 472195, 484529, 511776, 539764, 539928, 540769, 540779, 542735, 549740, 549742, 549743, 549744, 549745, 549747, 550624, 555567, 558899, 563028, 564253, 564563, 572716, 578631, 583500, 585007, 586002, 586690, 586962, 587757, 590759, 593571, 593596, 594899, 595080, 596929, 599533, 601806, 602928, 602945, 603640, 603963, 604219, 604419, 605804, 607537, 607694, 610806, 612809, 613508, 613683, 614720, 618272, 637592, 640401, 652708, 652756, 660060, 667975, 680271, 680671, 700949, 710161, 726997, 745661, 749926, 767275, 775848, 775866, 775946, 775958, 775963, 778359, 780375, 784750, 785500, 786120, 787586, 791738, 809514);

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
  430543
  447045
  453340
  472195
  484529
  511776
  539764
  539928
  540769
  540779
  542735
  549740
  549742
  549743
  549744
  549745
  549747
  550624
  555567
  558899
  563028
  564253
  564563
  572716
  578631
  583500
  585007
  586002
  586690
  586962
  587757
  590759
  593571
  593596
  594899
  595080
  596929
  599533
  601806
  602928
  602945
  603640
  603963
  604219
  604419
  605804
  607537
  607694
  610806
  612809
  613508
  613683
  614720
  618272
  637592
  640401
  652708
  652756
  660060
  667975
  680271
  680671
  700949
  710161
  726997
  745661
  749926
  767275
  775848
  775866
  775946
  775958
  775963
  778359
  780375
  784750
  785500
  786120
  787586
  791738
  809514
]

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 (430543, 447045, 453340, 472195, 484529, 511776, 539764, 539928, 540769, 540779, 542735, 549740, 549742, 549743, 549744, 549745, 549747, 550624, 555567, 558899, 563028, 564253, 564563, 572716, 578631, 583500, 585007, 586002, 586690, 586962, 587757, 590759, 593571, 593596, 594899, 595080, 596929, 599533, 601806, 602928, 602945, 603640, 603963, 604219, 604419, 605804, 607537, 607694, 610806, 612809, 613508, 613683, 614720, 618272, 637592, 640401, 652708, 652756, 660060, 667975, 680271, 680671, 700949, 710161, 726997, 745661, 749926, 767275, 775848, 775866, 775946, 775958, 775963, 778359, 780375, 784750, 785500, 786120, 787586, 791738, 809514);

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

[
  "mature онлифанс социальн сет"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'mature онлифанс социальн сет';

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

[
  "mature онлифанс социальн сет"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature онлифанс социальн сет';