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

[
  "gangbang group russian"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'gangbang group russian' LIMIT 1;

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

[
  b"\x01”\x07¢P\rܺZ,ÐèrûÊ"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x019407A2505C72DCBA5A2CD0E872FBCA 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
  531172
  533697
  552267
  576019
  564808
  584654
  582549
  683259
  716032
  565247
  567304
  567581
  598057
  600061
  601478
  600354
  622799
  733908
  731665
  716030
  775958
  540955
  461609
  551223
  534028
  568315
  569413
  575856
  702166
  714511
  683261
  676989
  561334
  590411
  587098
  733870
  473780
  521866
  543652
  615696
  655705
  648871
  621612
  533726
  551222
  647936
  683264
  662137
  555805
  599969
  598024
  659323
  557985
  542864
  614747
  730798
  490201
  558131
  647340
  601584
  599964
  587864
  597963
  599361
  601933
  617132
  583500
  671863
  620098
  603906
  627652
  609196
  598806
  521453
]

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 (531172, 533697, 552267, 576019, 564808, 584654, 582549, 683259, 716032, 565247, 567304, 567581, 598057, 600061, 601478, 600354, 622799, 733908, 731665, 716030, 775958, 540955, 461609, 551223, 534028, 568315, 569413, 575856, 702166, 714511, 683261, 676989, 561334, 590411, 587098, 733870, 473780, 521866, 543652, 615696, 655705, 648871, 621612, 533726, 551222, 647936, 683264, 662137, 555805, 599969, 598024, 659323, 557985, 542864, 614747, 730798, 490201, 558131, 647340, 601584, 599964, 587864, 597963, 599361, 601933, 617132, 583500, 671863, 620098, 603906, 627652, 609196, 598806, 521453);

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
  461609
  473780
  490201
  521453
  521866
  531172
  533697
  533726
  534028
  540955
  542864
  543652
  551222
  551223
  552267
  555805
  557985
  558131
  561334
  564808
  565247
  567304
  567581
  568315
  569413
  575856
  576019
  582549
  583500
  584654
  587098
  587864
  590411
  597963
  598024
  598057
  598806
  599361
  599964
  599969
  600061
  600354
  601478
  601584
  601933
  603906
  609196
  614747
  615696
  617132
  620098
  621612
  622799
  627652
  647340
  647936
  648871
  655705
  659323
  662137
  671863
  676989
  683259
  683261
  683264
  702166
  714511
  716030
  716032
  730798
  731665
  733870
  733908
  775958
]

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 (461609, 473780, 490201, 521453, 521866, 531172, 533697, 533726, 534028, 540955, 542864, 543652, 551222, 551223, 552267, 555805, 557985, 558131, 561334, 564808, 565247, 567304, 567581, 568315, 569413, 575856, 576019, 582549, 583500, 584654, 587098, 587864, 590411, 597963, 598024, 598057, 598806, 599361, 599964, 599969, 600061, 600354, 601478, 601584, 601933, 603906, 609196, 614747, 615696, 617132, 620098, 621612, 622799, 627652, 647340, 647936, 648871, 655705, 659323, 662137, 671863, 676989, 683259, 683261, 683264, 702166, 714511, 716030, 716032, 730798, 731665, 733870, 733908, 775958);

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
  461609
  473780
  490201
  521453
  521866
  531172
  533697
  533726
  534028
  540955
  542864
  543652
  551222
  551223
  552267
  555805
  557985
  558131
  561334
  564808
  565247
  567304
  567581
  568315
  569413
  575856
  576019
  582549
  583500
  584654
  587098
  587864
  590411
  597963
  598024
  598057
  598806
  599361
  599964
  599969
  600061
  600354
  601478
  601584
  601933
  603906
  609196
  614747
  615696
  617132
  620098
  621612
  622799
  627652
  647340
  647936
  648871
  655705
  659323
  662137
  671863
  676989
  683259
  683261
  683264
  702166
  714511
  716030
  716032
  730798
  731665
  733870
  733908
  775958
]

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 (461609, 473780, 490201, 521453, 521866, 531172, 533697, 533726, 534028, 540955, 542864, 543652, 551222, 551223, 552267, 555805, 557985, 558131, 561334, 564808, 565247, 567304, 567581, 568315, 569413, 575856, 576019, 582549, 583500, 584654, 587098, 587864, 590411, 597963, 598024, 598057, 598806, 599361, 599964, 599969, 600061, 600354, 601478, 601584, 601933, 603906, 609196, 614747, 615696, 617132, 620098, 621612, 622799, 627652, 647340, 647936, 648871, 655705, 659323, 662137, 671863, 676989, 683259, 683261, 683264, 702166, 714511, 716030, 716032, 730798, 731665, 733870, 733908, 775958);

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

[
  "gangbang group русск"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'gangbang group русск';

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

[
  "gangbang group русск"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'gangbang group русск';