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

[
  "car hairy pussy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'car hairy pussy' 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
  708292
  623696
  388005
  385941
  691235
  623071
  667402
  599773
  817909
  555982
  579945
  582836
  666713
  396885
  413534
  602969
  497816
  640880
  637902
  506529
  635189
  546351
  488332
  533108
  661901
  592391
  461422
  588930
  384865
  504584
  484374
  419803
  624238
  515749
  818746
  475056
  539774
  572537
  463990
  528067
  817632
  584691
  449180
  491901
  456369
  486606
  471810
  722521
  673142
  497130
  482367
  524982
  437488
  491783
  613777
  550788
  494684
  477899
  560168
  413499
  451824
  421238
  599827
  490025
  615735
  630070
  522914
  807023
  123029
  445641
  430303
  541804
]

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 (708292, 623696, 388005, 385941, 691235, 623071, 667402, 599773, 817909, 555982, 579945, 582836, 666713, 396885, 413534, 602969, 497816, 640880, 637902, 506529, 635189, 546351, 488332, 533108, 661901, 592391, 461422, 588930, 384865, 504584, 484374, 419803, 624238, 515749, 818746, 475056, 539774, 572537, 463990, 528067, 817632, 584691, 449180, 491901, 456369, 486606, 471810, 722521, 673142, 497130, 482367, 524982, 437488, 491783, 613777, 550788, 494684, 477899, 560168, 413499, 451824, 421238, 599827, 490025, 615735, 630070, 522914, 807023, 123029, 445641, 430303, 541804);

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
  123029
  384865
  385941
  388005
  396885
  413499
  413534
  419803
  421238
  430303
  437488
  445641
  449180
  451824
  456369
  461422
  463990
  471810
  475056
  477899
  482367
  484374
  486606
  488332
  490025
  491783
  491901
  494684
  497130
  497816
  504584
  506529
  515749
  522914
  524982
  528067
  533108
  539774
  541804
  546351
  550788
  555982
  560168
  572537
  579945
  582836
  584691
  588930
  592391
  599773
  599827
  602969
  613777
  615735
  623071
  623696
  624238
  630070
  635189
  637902
  640880
  661901
  666713
  667402
  673142
  691235
  708292
  722521
  807023
  817632
  817909
  818746
]

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 (123029, 384865, 385941, 388005, 396885, 413499, 413534, 419803, 421238, 430303, 437488, 445641, 449180, 451824, 456369, 461422, 463990, 471810, 475056, 477899, 482367, 484374, 486606, 488332, 490025, 491783, 491901, 494684, 497130, 497816, 504584, 506529, 515749, 522914, 524982, 528067, 533108, 539774, 541804, 546351, 550788, 555982, 560168, 572537, 579945, 582836, 584691, 588930, 592391, 599773, 599827, 602969, 613777, 615735, 623071, 623696, 624238, 630070, 635189, 637902, 640880, 661901, 666713, 667402, 673142, 691235, 708292, 722521, 807023, 817632, 817909, 818746);

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
  123029
  384865
  385941
  388005
  396885
  413499
  413534
  419803
  421238
  430303
  437488
  445641
  449180
  451824
  456369
  461422
  463990
  471810
  475056
  477899
  482367
  484374
  486606
  488332
  490025
  491783
  491901
  494684
  497130
  497816
  504584
  506529
  515749
  522914
  524982
  528067
  533108
  539774
  541804
  546351
  550788
  555982
  560168
  572537
  579945
  582836
  584691
  588930
  592391
  599773
  599827
  602969
  613777
  615735
  623071
  623696
  624238
  630070
  635189
  637902
  640880
  661901
  666713
  667402
  673142
  691235
  708292
  722521
  807023
  817632
  817909
  818746
]

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 (123029, 384865, 385941, 388005, 396885, 413499, 413534, 419803, 421238, 430303, 437488, 445641, 449180, 451824, 456369, 461422, 463990, 471810, 475056, 477899, 482367, 484374, 486606, 488332, 490025, 491783, 491901, 494684, 497130, 497816, 504584, 506529, 515749, 522914, 524982, 528067, 533108, 539774, 541804, 546351, 550788, 555982, 560168, 572537, 579945, 582836, 584691, 588930, 592391, 599773, 599827, 602969, 613777, 615735, 623071, 623696, 624238, 630070, 635189, 637902, 640880, 661901, 666713, 667402, 673142, 691235, 708292, 722521, 807023, 817632, 817909, 818746);

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

[
  "вмашин волосатая pussy"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'вмашин волосатая pussy';

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

[
  "вмашин волосатая pussy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'вмашин волосатая pussy';