Query Metrics
7
Database Queries
7
Different statements
130.68 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.51 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 1.86 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur home porn"
]
|
||||||||||||||||||||||||||||||
| 3 | 16.70 ms |
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 670723 795803 766082 679628 557365 703761 507849 610739 679533 650298 670725 484171 546871 768101 741553 826109 809965 588695 794079 781513 823602 560600 732996 595808 712226 732995 720304 733651 574550 543733 606641 686610 402021 511479 673874 591275 794811 645965 610421 591234 638490 729345 538455 462658 389630 593516 524367 608633 758635 392607 479037 469908 693278 700733 579381 479959 503819 403716 521896 524180 524359 444384 461785 543829 487272 505922 492341 553591 520099 560438 610011 591219 457226 567408 520823 496585 521141 506232 497834 431759 748236 525884 499183 445200 487472 517833 544202 521495 620754 574527 ] |
||||||||||||||||||||||||||||||
| 4 | 2.46 ms |
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 389630 392607 402021 403716 431759 444384 445200 457226 461785 462658 469908 479037 479959 484171 487272 487472 492341 496585 497834 499183 503819 505922 506232 507849 511479 517833 520099 520823 521141 521495 521896 524180 524359 524367 525884 538455 543733 543829 544202 546871 553591 557365 560438 560600 567408 574527 574550 579381 588695 591219 591234 591275 593516 595808 606641 608633 610011 610421 610739 620754 638490 645965 650298 670723 670725 673874 679533 679628 686610 693278 700733 703761 712226 720304 729345 732995 732996 733651 741553 748236 758635 766082 768101 781513 794079 794811 795803 809965 823602 ] |
||||||||||||||||||||||||||||||
| 5 | 105.08 ms |
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 389630 392607 402021 403716 431759 444384 445200 457226 461785 462658 469908 479037 479959 484171 487272 487472 492341 496585 497834 499183 503819 505922 506232 507849 511479 517833 520099 520823 521141 521495 521896 524180 524359 524367 525884 538455 543733 543829 544202 546871 553591 557365 560438 560600 567408 574527 574550 579381 588695 591219 591234 591275 593516 595808 606641 608633 610011 610421 610739 620754 638490 645965 650298 670723 670725 673874 679533 679628 686610 693278 700733 703761 712226 720304 729345 732995 732996 733651 741553 748236 758635 766082 768101 781513 794079 794811 795803 809965 823602 ] |
||||||||||||||||||||||||||||||
| 6 | 1.67 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск home porn"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.41 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск home porn"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.