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

[
  "japanese girl masturbation"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'japanese girl masturbation' 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
  517997
  285321
  513136
  584685
  603576
  416146
  565980
  538295
  565986
  588228
  429565
  614730
  671835
  512189
  428784
  523373
  505804
  467705
  550778
  583267
  586584
  512221
  512205
  478030
  672212
  425804
  552281
  586588
  457265
  512194
  526100
  531903
  550769
  623818
  494510
  584680
  619457
  510581
  819181
  565974
  566076
  551121
  589684
  559892
  512198
  551973
  565987
  554769
  623513
  420818
  584678
  623574
  552198
  547569
  559890
  565984
  586619
  590981
  413044
  516432
  547651
  619439
  499885
  467715
  599789
  503026
  688371
  761289
  516873
  546040
  512222
  607879
  585889
  648132
]

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 (517997, 285321, 513136, 584685, 603576, 416146, 565980, 538295, 565986, 588228, 429565, 614730, 671835, 512189, 428784, 523373, 505804, 467705, 550778, 583267, 586584, 512221, 512205, 478030, 672212, 425804, 552281, 586588, 457265, 512194, 526100, 531903, 550769, 623818, 494510, 584680, 619457, 510581, 819181, 565974, 566076, 551121, 589684, 559892, 512198, 551973, 565987, 554769, 623513, 420818, 584678, 623574, 552198, 547569, 559890, 565984, 586619, 590981, 413044, 516432, 547651, 619439, 499885, 467715, 599789, 503026, 688371, 761289, 516873, 546040, 512222, 607879, 585889, 648132);

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
  285321
  413044
  416146
  420818
  425804
  428784
  429565
  457265
  467705
  467715
  478030
  494510
  499885
  503026
  505804
  510581
  512189
  512194
  512198
  512205
  512221
  512222
  513136
  516432
  516873
  517997
  523373
  526100
  531903
  538295
  546040
  547569
  547651
  550769
  550778
  551121
  551973
  552198
  552281
  554769
  559890
  559892
  565974
  565980
  565984
  565986
  565987
  566076
  583267
  584678
  584680
  584685
  585889
  586584
  586588
  586619
  588228
  589684
  590981
  599789
  603576
  607879
  614730
  619439
  619457
  623513
  623574
  623818
  648132
  671835
  672212
  688371
  761289
  819181
]

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 (285321, 413044, 416146, 420818, 425804, 428784, 429565, 457265, 467705, 467715, 478030, 494510, 499885, 503026, 505804, 510581, 512189, 512194, 512198, 512205, 512221, 512222, 513136, 516432, 516873, 517997, 523373, 526100, 531903, 538295, 546040, 547569, 547651, 550769, 550778, 551121, 551973, 552198, 552281, 554769, 559890, 559892, 565974, 565980, 565984, 565986, 565987, 566076, 583267, 584678, 584680, 584685, 585889, 586584, 586588, 586619, 588228, 589684, 590981, 599789, 603576, 607879, 614730, 619439, 619457, 623513, 623574, 623818, 648132, 671835, 672212, 688371, 761289, 819181);

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
  285321
  413044
  416146
  420818
  425804
  428784
  429565
  457265
  467705
  467715
  478030
  494510
  499885
  503026
  505804
  510581
  512189
  512194
  512198
  512205
  512221
  512222
  513136
  516432
  516873
  517997
  523373
  526100
  531903
  538295
  546040
  547569
  547651
  550769
  550778
  551121
  551973
  552198
  552281
  554769
  559890
  559892
  565974
  565980
  565984
  565986
  565987
  566076
  583267
  584678
  584680
  584685
  585889
  586584
  586588
  586619
  588228
  589684
  590981
  599789
  603576
  607879
  614730
  619439
  619457
  623513
  623574
  623818
  648132
  671835
  672212
  688371
  761289
  819181
]

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 (285321, 413044, 416146, 420818, 425804, 428784, 429565, 457265, 467705, 467715, 478030, 494510, 499885, 503026, 505804, 510581, 512189, 512194, 512198, 512205, 512221, 512222, 513136, 516432, 516873, 517997, 523373, 526100, 531903, 538295, 546040, 547569, 547651, 550769, 550778, 551121, 551973, 552198, 552281, 554769, 559890, 559892, 565974, 565980, 565984, 565986, 565987, 566076, 583267, 584678, 584680, 584685, 585889, 586584, 586588, 586619, 588228, 589684, 590981, 599789, 603576, 607879, 614730, 619439, 619457, 623513, 623574, 623818, 648132, 671835, 672212, 688371, 761289, 819181);

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

[
  "японк азиатк девушк мастурбац"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'японк азиатк девушк мастурбац';

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

[
  "японк азиатк девушк мастурбац"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'японк азиатк девушк мастурбац';