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

[
  "mom hard"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mom hard' LIMIT 1;

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

[
  b"\x01”b/Õ{p_Š‘8Dh\x7F`§"
]

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0194622FD57B705F8A913844687F60A7 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
  456812
  496518
  537670
  558904
  562059
  572264
  565557
  668549
  600995
  809508
  475776
  458907
  478832
  497757
  491784
  525245
  522759
  814901
  459513
  459535
  530275
  562796
  567757
  578300
  605298
  609238
  462208
  404629
  421566
  528927
  524142
  497409
  562001
  560227
  556046
  580219
  577435
  637036
  623261
  475828
  428202
  466500
  486302
  536584
  562894
  675022
  639258
  601119
  613819
  622241
  642006
  642037
  623260
  641127
  642016
  419370
  427981
  424780
  517326
  517008
  525651
  526951
  534645
  572886
  675008
  561480
  597216
  624911
  625239
  477230
  500562
  508451
  520354
  584720
  617212
  523924
]

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 (456812, 496518, 537670, 558904, 562059, 572264, 565557, 668549, 600995, 809508, 475776, 458907, 478832, 497757, 491784, 525245, 522759, 814901, 459513, 459535, 530275, 562796, 567757, 578300, 605298, 609238, 462208, 404629, 421566, 528927, 524142, 497409, 562001, 560227, 556046, 580219, 577435, 637036, 623261, 475828, 428202, 466500, 486302, 536584, 562894, 675022, 639258, 601119, 613819, 622241, 642006, 642037, 623260, 641127, 642016, 419370, 427981, 424780, 517326, 517008, 525651, 526951, 534645, 572886, 675008, 561480, 597216, 624911, 625239, 477230, 500562, 508451, 520354, 584720, 617212, 523924);

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
  404629
  419370
  421566
  424780
  427981
  428202
  456812
  458907
  459513
  459535
  462208
  466500
  475776
  475828
  477230
  478832
  486302
  491784
  496518
  497409
  497757
  500562
  508451
  517008
  517326
  520354
  522759
  523924
  524142
  525245
  525651
  526951
  528927
  530275
  534645
  536584
  537670
  556046
  558904
  560227
  561480
  562001
  562059
  562796
  562894
  565557
  567757
  572264
  572886
  577435
  578300
  580219
  584720
  597216
  600995
  601119
  605298
  609238
  613819
  617212
  622241
  623260
  623261
  624911
  625239
  637036
  639258
  641127
  642006
  642016
  642037
  668549
  675008
  675022
  809508
  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 (404629, 419370, 421566, 424780, 427981, 428202, 456812, 458907, 459513, 459535, 462208, 466500, 475776, 475828, 477230, 478832, 486302, 491784, 496518, 497409, 497757, 500562, 508451, 517008, 517326, 520354, 522759, 523924, 524142, 525245, 525651, 526951, 528927, 530275, 534645, 536584, 537670, 556046, 558904, 560227, 561480, 562001, 562059, 562796, 562894, 565557, 567757, 572264, 572886, 577435, 578300, 580219, 584720, 597216, 600995, 601119, 605298, 609238, 613819, 617212, 622241, 623260, 623261, 624911, 625239, 637036, 639258, 641127, 642006, 642016, 642037, 668549, 675008, 675022, 809508, 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
  404629
  419370
  421566
  424780
  427981
  428202
  456812
  458907
  459513
  459535
  462208
  466500
  475776
  475828
  477230
  478832
  486302
  491784
  496518
  497409
  497757
  500562
  508451
  517008
  517326
  520354
  522759
  523924
  524142
  525245
  525651
  526951
  528927
  530275
  534645
  536584
  537670
  556046
  558904
  560227
  561480
  562001
  562059
  562796
  562894
  565557
  567757
  572264
  572886
  577435
  578300
  580219
  584720
  597216
  600995
  601119
  605298
  609238
  613819
  617212
  622241
  623260
  623261
  624911
  625239
  637036
  639258
  641127
  642006
  642016
  642037
  668549
  675008
  675022
  809508
  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 (404629, 419370, 421566, 424780, 427981, 428202, 456812, 458907, 459513, 459535, 462208, 466500, 475776, 475828, 477230, 478832, 486302, 491784, 496518, 497409, 497757, 500562, 508451, 517008, 517326, 520354, 522759, 523924, 524142, 525245, 525651, 526951, 528927, 530275, 534645, 536584, 537670, 556046, 558904, 560227, 561480, 562001, 562059, 562796, 562894, 565557, 567757, 572264, 572886, 577435, 578300, 580219, 584720, 597216, 600995, 601119, 605298, 609238, 613819, 617212, 622241, 623260, 623261, 624911, 625239, 637036, 639258, 641127, 642006, 642016, 642037, 668549, 675008, 675022, 809508, 814901);

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

[
  "mom hard"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'mom hard';

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

[
  "mom hard"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mom hard';