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

[
  "masturbation japanese"
]

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

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

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

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
  382971
  413044
  416146
  420818
  425804
  428784
  429565
  431427
  457265
  467705
  467715
  478030
  482237
  494510
  499885
  502511
  502533
  503026
  503029
  503043
  503479
  505804
  510581
  512189
  512194
  512198
  512205
  512221
  512222
  513136
  516432
  516873
  517997
  523373
  526100
  531903
  538295
  546040
  547569
  547651
  550769
  550778
  551121
  551953
  551973
  552198
  552281
  554769
  559890
  559892
  565974
  565980
  565984
  565986
  565987
  566076
  583267
  584678
  584680
  584685
  585889
  586584
  586588
  586619
  588228
  589684
  599789
  603576
  607879
  614730
  619439
  619457
  623513
  623574
  623610
  623818
  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, 382971, 413044, 416146, 420818, 425804, 428784, 429565, 431427, 457265, 467705, 467715, 478030, 482237, 494510, 499885, 502511, 502533, 503026, 503029, 503043, 503479, 505804, 510581, 512189, 512194, 512198, 512205, 512221, 512222, 513136, 516432, 516873, 517997, 523373, 526100, 531903, 538295, 546040, 547569, 547651, 550769, 550778, 551121, 551953, 551973, 552198, 552281, 554769, 559890, 559892, 565974, 565980, 565984, 565986, 565987, 566076, 583267, 584678, 584680, 584685, 585889, 586584, 586588, 586619, 588228, 589684, 599789, 603576, 607879, 614730, 619439, 619457, 623513, 623574, 623610, 623818, 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
  382971
  413044
  416146
  420818
  425804
  428784
  429565
  431427
  457265
  467705
  467715
  478030
  482237
  494510
  499885
  502511
  502533
  503026
  503029
  503043
  503479
  505804
  510581
  512189
  512194
  512198
  512205
  512221
  512222
  513136
  516432
  516873
  517997
  523373
  526100
  531903
  538295
  546040
  547569
  547651
  550769
  550778
  551121
  551953
  551973
  552198
  552281
  554769
  559890
  559892
  565974
  565980
  565984
  565986
  565987
  566076
  583267
  584678
  584680
  584685
  585889
  586584
  586588
  586619
  588228
  589684
  599789
  603576
  607879
  614730
  619439
  619457
  623513
  623574
  623610
  623818
  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, 382971, 413044, 416146, 420818, 425804, 428784, 429565, 431427, 457265, 467705, 467715, 478030, 482237, 494510, 499885, 502511, 502533, 503026, 503029, 503043, 503479, 505804, 510581, 512189, 512194, 512198, 512205, 512221, 512222, 513136, 516432, 516873, 517997, 523373, 526100, 531903, 538295, 546040, 547569, 547651, 550769, 550778, 551121, 551953, 551973, 552198, 552281, 554769, 559890, 559892, 565974, 565980, 565984, 565986, 565987, 566076, 583267, 584678, 584680, 584685, 585889, 586584, 586588, 586619, 588228, 589684, 599789, 603576, 607879, 614730, 619439, 619457, 623513, 623574, 623610, 623818, 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` = 'мастурбац японк азиатк';