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 mature compilation"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'russian mature compilation' 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
  519299
  540727
  694115
  778607
  738367
  758236
  741712
  741701
  471067
  487763
  490705
  483385
  527842
  519333
  492050
  466141
  483367
  520340
  483376
  649523
  659385
  697459
  629571
  587866
  801292
  776940
  477731
  465381
  430433
  509430
  480707
  439559
  518599
  474091
  527876
  593596
  429954
  439693
  455941
  476244
  518614
  486569
  519141
  445644
  579224
  625274
  601792
  741763
  805139
  476839
  526161
  489373
  474776
  490744
  607218
  494966
  597148
  518597
  452953
  514404
  439585
  452404
  508525
  518818
  477097
  455008
  710902
  482315
  470613
  478978
  465317
  470442
  546114
  566403
  539351
  472388
  542954
  597963
  465844
  466090
]

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 (519299, 540727, 694115, 778607, 738367, 758236, 741712, 741701, 471067, 487763, 490705, 483385, 527842, 519333, 492050, 466141, 483367, 520340, 483376, 649523, 659385, 697459, 629571, 587866, 801292, 776940, 477731, 465381, 430433, 509430, 480707, 439559, 518599, 474091, 527876, 593596, 429954, 439693, 455941, 476244, 518614, 486569, 519141, 445644, 579224, 625274, 601792, 741763, 805139, 476839, 526161, 489373, 474776, 490744, 607218, 494966, 597148, 518597, 452953, 514404, 439585, 452404, 508525, 518818, 477097, 455008, 710902, 482315, 470613, 478978, 465317, 470442, 546114, 566403, 539351, 472388, 542954, 597963, 465844, 466090);

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
  429954
  430433
  439559
  439585
  439693
  445644
  452404
  452953
  455008
  455941
  465317
  465381
  465844
  466090
  466141
  470442
  470613
  471067
  472388
  474091
  474776
  476244
  476839
  477097
  477731
  478978
  480707
  482315
  483367
  483376
  483385
  486569
  487763
  489373
  490705
  490744
  492050
  494966
  508525
  509430
  514404
  518597
  518599
  518614
  518818
  519141
  519299
  519333
  520340
  526161
  527842
  527876
  539351
  540727
  542954
  546114
  566403
  579224
  587866
  593596
  597148
  597963
  601792
  607218
  625274
  629571
  649523
  659385
  694115
  697459
  710902
  738367
  741701
  741712
  741763
  758236
  776940
  778607
  801292
  805139
]

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 (429954, 430433, 439559, 439585, 439693, 445644, 452404, 452953, 455008, 455941, 465317, 465381, 465844, 466090, 466141, 470442, 470613, 471067, 472388, 474091, 474776, 476244, 476839, 477097, 477731, 478978, 480707, 482315, 483367, 483376, 483385, 486569, 487763, 489373, 490705, 490744, 492050, 494966, 508525, 509430, 514404, 518597, 518599, 518614, 518818, 519141, 519299, 519333, 520340, 526161, 527842, 527876, 539351, 540727, 542954, 546114, 566403, 579224, 587866, 593596, 597148, 597963, 601792, 607218, 625274, 629571, 649523, 659385, 694115, 697459, 710902, 738367, 741701, 741712, 741763, 758236, 776940, 778607, 801292, 805139);

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
  429954
  430433
  439559
  439585
  439693
  445644
  452404
  452953
  455008
  455941
  465317
  465381
  465844
  466090
  466141
  470442
  470613
  471067
  472388
  474091
  474776
  476244
  476839
  477097
  477731
  478978
  480707
  482315
  483367
  483376
  483385
  486569
  487763
  489373
  490705
  490744
  492050
  494966
  508525
  509430
  514404
  518597
  518599
  518614
  518818
  519141
  519299
  519333
  520340
  526161
  527842
  527876
  539351
  540727
  542954
  546114
  566403
  579224
  587866
  593596
  597148
  597963
  601792
  607218
  625274
  629571
  649523
  659385
  694115
  697459
  710902
  738367
  741701
  741712
  741763
  758236
  776940
  778607
  801292
  805139
]

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 (429954, 430433, 439559, 439585, 439693, 445644, 452404, 452953, 455008, 455941, 465317, 465381, 465844, 466090, 466141, 470442, 470613, 471067, 472388, 474091, 474776, 476244, 476839, 477097, 477731, 478978, 480707, 482315, 483367, 483376, 483385, 486569, 487763, 489373, 490705, 490744, 492050, 494966, 508525, 509430, 514404, 518597, 518599, 518614, 518818, 519141, 519299, 519333, 520340, 526161, 527842, 527876, 539351, 540727, 542954, 546114, 566403, 579224, 587866, 593596, 597148, 597963, 601792, 607218, 625274, 629571, 649523, 659385, 694115, 697459, 710902, 738367, 741701, 741712, 741763, 758236, 776940, 778607, 801292, 805139);

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

[
  "русск mature подборк"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'русск mature подборк';

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

[
  "русск mature подборк"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'русск mature подборк';