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

[
  "flashing girls"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'flashing girls' 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
  618069
  469119
  526555
  495473
  494878
  559570
  661356
  721948
  450858
  571811
  615650
  823411
  526174
  477763
  552302
  636647
  798838
  810633
  810644
  420021
  528350
  494165
  529901
  579661
  545237
  660024
  601738
  607676
  592189
  635621
  423916
  537322
  556585
  550498
  568216
  702613
  558106
  565350
  784976
  807876
  797312
  420014
  472816
  472807
  534663
  577540
  552715
  478402
  676418
  562381
  602952
  584980
  529914
  633408
  420009
  626911
  452223
  499735
  682915
  614797
  811993
  444134
  525699
  497103
  598121
  472916
  550119
  672740
  752506
  450657
  577031
  489087
  525947
  552278
  617026
  525729
  535616
  466960
  558316
  605703
  513828
  649912
  601944
]

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 (618069, 469119, 526555, 495473, 494878, 559570, 661356, 721948, 450858, 571811, 615650, 823411, 526174, 477763, 552302, 636647, 798838, 810633, 810644, 420021, 528350, 494165, 529901, 579661, 545237, 660024, 601738, 607676, 592189, 635621, 423916, 537322, 556585, 550498, 568216, 702613, 558106, 565350, 784976, 807876, 797312, 420014, 472816, 472807, 534663, 577540, 552715, 478402, 676418, 562381, 602952, 584980, 529914, 633408, 420009, 626911, 452223, 499735, 682915, 614797, 811993, 444134, 525699, 497103, 598121, 472916, 550119, 672740, 752506, 450657, 577031, 489087, 525947, 552278, 617026, 525729, 535616, 466960, 558316, 605703, 513828, 649912, 601944);

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
  420009
  420014
  420021
  423916
  444134
  450657
  450858
  452223
  466960
  469119
  472807
  472816
  472916
  477763
  478402
  489087
  494165
  494878
  495473
  497103
  499735
  513828
  525699
  525729
  525947
  526174
  526555
  528350
  529901
  529914
  534663
  535616
  537322
  545237
  550119
  550498
  552278
  552302
  552715
  556585
  558106
  558316
  559570
  562381
  565350
  568216
  571811
  577031
  577540
  579661
  584980
  592189
  598121
  601738
  601944
  602952
  605703
  607676
  614797
  615650
  617026
  618069
  626911
  633408
  635621
  636647
  649912
  660024
  661356
  672740
  676418
  682915
  702613
  721948
  752506
  784976
  797312
  798838
  807876
  810633
  810644
  811993
  823411
]

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 (420009, 420014, 420021, 423916, 444134, 450657, 450858, 452223, 466960, 469119, 472807, 472816, 472916, 477763, 478402, 489087, 494165, 494878, 495473, 497103, 499735, 513828, 525699, 525729, 525947, 526174, 526555, 528350, 529901, 529914, 534663, 535616, 537322, 545237, 550119, 550498, 552278, 552302, 552715, 556585, 558106, 558316, 559570, 562381, 565350, 568216, 571811, 577031, 577540, 579661, 584980, 592189, 598121, 601738, 601944, 602952, 605703, 607676, 614797, 615650, 617026, 618069, 626911, 633408, 635621, 636647, 649912, 660024, 661356, 672740, 676418, 682915, 702613, 721948, 752506, 784976, 797312, 798838, 807876, 810633, 810644, 811993, 823411);

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
  420009
  420014
  420021
  423916
  444134
  450657
  450858
  452223
  466960
  469119
  472807
  472816
  472916
  477763
  478402
  489087
  494165
  494878
  495473
  497103
  499735
  513828
  525699
  525729
  525947
  526174
  526555
  528350
  529901
  529914
  534663
  535616
  537322
  545237
  550119
  550498
  552278
  552302
  552715
  556585
  558106
  558316
  559570
  562381
  565350
  568216
  571811
  577031
  577540
  579661
  584980
  592189
  598121
  601738
  601944
  602952
  605703
  607676
  614797
  615650
  617026
  618069
  626911
  633408
  635621
  636647
  649912
  660024
  661356
  672740
  676418
  682915
  702613
  721948
  752506
  784976
  797312
  798838
  807876
  810633
  810644
  811993
  823411
]

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 (420009, 420014, 420021, 423916, 444134, 450657, 450858, 452223, 466960, 469119, 472807, 472816, 472916, 477763, 478402, 489087, 494165, 494878, 495473, 497103, 499735, 513828, 525699, 525729, 525947, 526174, 526555, 528350, 529901, 529914, 534663, 535616, 537322, 545237, 550119, 550498, 552278, 552302, 552715, 556585, 558106, 558316, 559570, 562381, 565350, 568216, 571811, 577031, 577540, 579661, 584980, 592189, 598121, 601738, 601944, 602952, 605703, 607676, 614797, 615650, 617026, 618069, 626911, 633408, 635621, 636647, 649912, 660024, 661356, 672740, 676418, 682915, 702613, 721948, 752506, 784976, 797312, 798838, 807876, 810633, 810644, 811993, 823411);

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

[
  "flashing девушк"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'flashing девушк';

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

[
  "flashing девушк"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'flashing девушк';