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

[
  "russian suck"
]

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

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

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

[
  b"\x01“²n3*sʱߦo4Â\x11Ú"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0193B26E332A73CAB1DFA66F34C211DA 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
  445759
  453508
  448876
  452297
  477114
  439609
  447079
  463000
  512540
  522362
  524930
  527370
  528187
  530001
  482916
  485570
  489060
  500210
  522559
  491168
  494161
  513825
  488372
  506928
  519460
  524060
  527738
  529107
  507533
  563742
  593296
  426818
  464532
  455247
  514488
  814175
  542753
  621796
  614918
  423123
  428771
  418591
  426789
  450912
  455861
  527609
  512263
  493288
  518818
  519331
  487577
  523016
  564160
  614442
  508497
  541572
  676472
  551156
  601853
  597126
  389895
  451492
  421604
  424060
  484628
  597821
  598605
  601963
  470543
  517117
  528265
  576286
  627139
  560786
  619005
  620995
  529226
  624131
  576396
  625001
]

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 (445759, 453508, 448876, 452297, 477114, 439609, 447079, 463000, 512540, 522362, 524930, 527370, 528187, 530001, 482916, 485570, 489060, 500210, 522559, 491168, 494161, 513825, 488372, 506928, 519460, 524060, 527738, 529107, 507533, 563742, 593296, 426818, 464532, 455247, 514488, 814175, 542753, 621796, 614918, 423123, 428771, 418591, 426789, 450912, 455861, 527609, 512263, 493288, 518818, 519331, 487577, 523016, 564160, 614442, 508497, 541572, 676472, 551156, 601853, 597126, 389895, 451492, 421604, 424060, 484628, 597821, 598605, 601963, 470543, 517117, 528265, 576286, 627139, 560786, 619005, 620995, 529226, 624131, 576396, 625001);

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
  389895
  418591
  421604
  423123
  424060
  426789
  426818
  428771
  439609
  445759
  447079
  448876
  450912
  451492
  452297
  453508
  455247
  455861
  463000
  464532
  470543
  477114
  482916
  484628
  485570
  487577
  488372
  489060
  491168
  493288
  494161
  500210
  506928
  507533
  508497
  512263
  512540
  513825
  514488
  517117
  518818
  519331
  519460
  522362
  522559
  523016
  524060
  524930
  527370
  527609
  527738
  528187
  528265
  529107
  529226
  530001
  541572
  542753
  551156
  560786
  563742
  564160
  576286
  576396
  593296
  597126
  597821
  598605
  601853
  601963
  614442
  614918
  619005
  620995
  621796
  624131
  625001
  627139
  676472
  814175
]

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 (389895, 418591, 421604, 423123, 424060, 426789, 426818, 428771, 439609, 445759, 447079, 448876, 450912, 451492, 452297, 453508, 455247, 455861, 463000, 464532, 470543, 477114, 482916, 484628, 485570, 487577, 488372, 489060, 491168, 493288, 494161, 500210, 506928, 507533, 508497, 512263, 512540, 513825, 514488, 517117, 518818, 519331, 519460, 522362, 522559, 523016, 524060, 524930, 527370, 527609, 527738, 528187, 528265, 529107, 529226, 530001, 541572, 542753, 551156, 560786, 563742, 564160, 576286, 576396, 593296, 597126, 597821, 598605, 601853, 601963, 614442, 614918, 619005, 620995, 621796, 624131, 625001, 627139, 676472, 814175);

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
  389895
  418591
  421604
  423123
  424060
  426789
  426818
  428771
  439609
  445759
  447079
  448876
  450912
  451492
  452297
  453508
  455247
  455861
  463000
  464532
  470543
  477114
  482916
  484628
  485570
  487577
  488372
  489060
  491168
  493288
  494161
  500210
  506928
  507533
  508497
  512263
  512540
  513825
  514488
  517117
  518818
  519331
  519460
  522362
  522559
  523016
  524060
  524930
  527370
  527609
  527738
  528187
  528265
  529107
  529226
  530001
  541572
  542753
  551156
  560786
  563742
  564160
  576286
  576396
  593296
  597126
  597821
  598605
  601853
  601963
  614442
  614918
  619005
  620995
  621796
  624131
  625001
  627139
  676472
  814175
]

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 (389895, 418591, 421604, 423123, 424060, 426789, 426818, 428771, 439609, 445759, 447079, 448876, 450912, 451492, 452297, 453508, 455247, 455861, 463000, 464532, 470543, 477114, 482916, 484628, 485570, 487577, 488372, 489060, 491168, 493288, 494161, 500210, 506928, 507533, 508497, 512263, 512540, 513825, 514488, 517117, 518818, 519331, 519460, 522362, 522559, 523016, 524060, 524930, 527370, 527609, 527738, 528187, 528265, 529107, 529226, 530001, 541572, 542753, 551156, 560786, 563742, 564160, 576286, 576396, 593296, 597126, 597821, 598605, 601853, 601963, 614442, 614918, 619005, 620995, 621796, 624131, 625001, 627139, 676472, 814175);

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

[
  "русск suck"
]

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

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

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

[
  "русск suck"
]

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

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