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

[
  "solo asian girl"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'solo asian girl' LIMIT 1;

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

[
  b"\x01—\x08“çÙrb¹Ò\x12­Æftô"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x01970893E7D97262B9D212ADC66674F4 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
  584481
  575300
  438052
  547241
  428944
  567127
  749693
  680706
  468153
  557605
  643145
  783740
  824449
  579499
  555547
  558175
  615371
  672212
  642164
  384960
  819181
  804703
  574243
  752700
  507774
  452781
  649435
  665964
  637318
  740110
  751036
  173238
  645526
  645604
  792273
  534791
  601767
  473055
  617486
  500743
  428903
  480233
  599829
  772507
  524369
  538547
  499885
  500679
  606493
  587307
  495167
  572967
  740268
  547768
  464690
  615983
  439252
  534023
  556371
  590981
  467715
  559782
  542884
  690682
  599789
  546085
  480788
  761289
  516873
  471092
  546783
  544964
  615447
  508891
  494206
  585889
  607879
]

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 (584481, 575300, 438052, 547241, 428944, 567127, 749693, 680706, 468153, 557605, 643145, 783740, 824449, 579499, 555547, 558175, 615371, 672212, 642164, 384960, 819181, 804703, 574243, 752700, 507774, 452781, 649435, 665964, 637318, 740110, 751036, 173238, 645526, 645604, 792273, 534791, 601767, 473055, 617486, 500743, 428903, 480233, 599829, 772507, 524369, 538547, 499885, 500679, 606493, 587307, 495167, 572967, 740268, 547768, 464690, 615983, 439252, 534023, 556371, 590981, 467715, 559782, 542884, 690682, 599789, 546085, 480788, 761289, 516873, 471092, 546783, 544964, 615447, 508891, 494206, 585889, 607879);

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
  173238
  384960
  428903
  428944
  438052
  439252
  452781
  464690
  467715
  468153
  471092
  473055
  480233
  480788
  494206
  495167
  499885
  500679
  500743
  507774
  508891
  516873
  524369
  534023
  534791
  538547
  542884
  544964
  546085
  546783
  547241
  547768
  555547
  556371
  557605
  558175
  559782
  567127
  572967
  574243
  575300
  579499
  584481
  585889
  587307
  590981
  599789
  599829
  601767
  606493
  607879
  615371
  615447
  615983
  617486
  637318
  642164
  643145
  645526
  645604
  649435
  665964
  672212
  680706
  690682
  740110
  740268
  749693
  751036
  752700
  761289
  772507
  783740
  792273
  804703
  819181
  824449
]

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 (173238, 384960, 428903, 428944, 438052, 439252, 452781, 464690, 467715, 468153, 471092, 473055, 480233, 480788, 494206, 495167, 499885, 500679, 500743, 507774, 508891, 516873, 524369, 534023, 534791, 538547, 542884, 544964, 546085, 546783, 547241, 547768, 555547, 556371, 557605, 558175, 559782, 567127, 572967, 574243, 575300, 579499, 584481, 585889, 587307, 590981, 599789, 599829, 601767, 606493, 607879, 615371, 615447, 615983, 617486, 637318, 642164, 643145, 645526, 645604, 649435, 665964, 672212, 680706, 690682, 740110, 740268, 749693, 751036, 752700, 761289, 772507, 783740, 792273, 804703, 819181, 824449);

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
  173238
  384960
  428903
  428944
  438052
  439252
  452781
  464690
  467715
  468153
  471092
  473055
  480233
  480788
  494206
  495167
  499885
  500679
  500743
  507774
  508891
  516873
  524369
  534023
  534791
  538547
  542884
  544964
  546085
  546783
  547241
  547768
  555547
  556371
  557605
  558175
  559782
  567127
  572967
  574243
  575300
  579499
  584481
  585889
  587307
  590981
  599789
  599829
  601767
  606493
  607879
  615371
  615447
  615983
  617486
  637318
  642164
  643145
  645526
  645604
  649435
  665964
  672212
  680706
  690682
  740110
  740268
  749693
  751036
  752700
  761289
  772507
  783740
  792273
  804703
  819181
  824449
]

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 (173238, 384960, 428903, 428944, 438052, 439252, 452781, 464690, 467715, 468153, 471092, 473055, 480233, 480788, 494206, 495167, 499885, 500679, 500743, 507774, 508891, 516873, 524369, 534023, 534791, 538547, 542884, 544964, 546085, 546783, 547241, 547768, 555547, 556371, 557605, 558175, 559782, 567127, 572967, 574243, 575300, 579499, 584481, 585889, 587307, 590981, 599789, 599829, 601767, 606493, 607879, 615371, 615447, 615983, 617486, 637318, 642164, 643145, 645526, 645604, 649435, 665964, 672212, 680706, 690682, 740110, 740268, 749693, 751036, 752700, 761289, 772507, 783740, 792273, 804703, 819181, 824449);

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` = 'соло азиатк девушк';