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

[
  "sloppy blowjob"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sloppy blowjob' LIMIT 1;

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

[
  b"\x01’Ùý!Œs5‰ZœÓÙ!l*"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0192D9FD218C7335895A9CD3D9216C2A 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
  505550
  593971
  601365
  589356
  479813
  550316
  580405
  438363
  458462
  471083
  472489
  510545
  717603
  621136
  389273
  603509
  386493
  415623
  498809
  453877
  457834
  498501
  811405
  538478
  497915
  785161
  752080
  489042
  450238
  440827
  447258
  435207
  593835
  618711
  768581
  587703
  635422
  402678
  616630
  606987
  414327
  422290
  472119
  447718
  478540
  451772
  514842
  497230
  518636
  533950
  466376
  529229
  704339
  529271
  556664
  455793
  520701
  530761
  502554
  501209
  516607
  591413
  532380
  520205
  764233
  524141
  509713
  507312
  471380
  527222
  544012
  524417
  508494
  520448
  419370
  517345
  543659
  617153
  586118
  626014
]

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 (505550, 593971, 601365, 589356, 479813, 550316, 580405, 438363, 458462, 471083, 472489, 510545, 717603, 621136, 389273, 603509, 386493, 415623, 498809, 453877, 457834, 498501, 811405, 538478, 497915, 785161, 752080, 489042, 450238, 440827, 447258, 435207, 593835, 618711, 768581, 587703, 635422, 402678, 616630, 606987, 414327, 422290, 472119, 447718, 478540, 451772, 514842, 497230, 518636, 533950, 466376, 529229, 704339, 529271, 556664, 455793, 520701, 530761, 502554, 501209, 516607, 591413, 532380, 520205, 764233, 524141, 509713, 507312, 471380, 527222, 544012, 524417, 508494, 520448, 419370, 517345, 543659, 617153, 586118, 626014);

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
  386493
  389273
  402678
  414327
  415623
  419370
  422290
  435207
  438363
  440827
  447258
  447718
  450238
  451772
  453877
  455793
  457834
  458462
  466376
  471083
  471380
  472119
  472489
  478540
  479813
  489042
  497230
  497915
  498501
  498809
  501209
  502554
  505550
  507312
  508494
  509713
  510545
  514842
  516607
  517345
  518636
  520205
  520448
  520701
  524141
  524417
  527222
  529229
  529271
  530761
  532380
  533950
  538478
  543659
  544012
  550316
  556664
  580405
  586118
  587703
  589356
  591413
  593835
  593971
  601365
  603509
  606987
  616630
  617153
  618711
  621136
  626014
  635422
  704339
  717603
  752080
  764233
  768581
  785161
  811405
]

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 (386493, 389273, 402678, 414327, 415623, 419370, 422290, 435207, 438363, 440827, 447258, 447718, 450238, 451772, 453877, 455793, 457834, 458462, 466376, 471083, 471380, 472119, 472489, 478540, 479813, 489042, 497230, 497915, 498501, 498809, 501209, 502554, 505550, 507312, 508494, 509713, 510545, 514842, 516607, 517345, 518636, 520205, 520448, 520701, 524141, 524417, 527222, 529229, 529271, 530761, 532380, 533950, 538478, 543659, 544012, 550316, 556664, 580405, 586118, 587703, 589356, 591413, 593835, 593971, 601365, 603509, 606987, 616630, 617153, 618711, 621136, 626014, 635422, 704339, 717603, 752080, 764233, 768581, 785161, 811405);

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
  386493
  389273
  402678
  414327
  415623
  419370
  422290
  435207
  438363
  440827
  447258
  447718
  450238
  451772
  453877
  455793
  457834
  458462
  466376
  471083
  471380
  472119
  472489
  478540
  479813
  489042
  497230
  497915
  498501
  498809
  501209
  502554
  505550
  507312
  508494
  509713
  510545
  514842
  516607
  517345
  518636
  520205
  520448
  520701
  524141
  524417
  527222
  529229
  529271
  530761
  532380
  533950
  538478
  543659
  544012
  550316
  556664
  580405
  586118
  587703
  589356
  591413
  593835
  593971
  601365
  603509
  606987
  616630
  617153
  618711
  621136
  626014
  635422
  704339
  717603
  752080
  764233
  768581
  785161
  811405
]

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 (386493, 389273, 402678, 414327, 415623, 419370, 422290, 435207, 438363, 440827, 447258, 447718, 450238, 451772, 453877, 455793, 457834, 458462, 466376, 471083, 471380, 472119, 472489, 478540, 479813, 489042, 497230, 497915, 498501, 498809, 501209, 502554, 505550, 507312, 508494, 509713, 510545, 514842, 516607, 517345, 518636, 520205, 520448, 520701, 524141, 524417, 527222, 529229, 529271, 530761, 532380, 533950, 538478, 543659, 544012, 550316, 556664, 580405, 586118, 587703, 589356, 591413, 593835, 593971, 601365, 603509, 606987, 616630, 617153, 618711, 621136, 626014, 635422, 704339, 717603, 752080, 764233, 768581, 785161, 811405);

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

[
  "sloppy минет оральн секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'sloppy минет оральн секс';

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

[
  "sloppy минет оральн секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sloppy минет оральн секс';