Query Metrics
7
Database Queries
7
Different statements
169.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.80 ms (84.67%) |
1 |
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 402249 408810 420648 448089 459752 477799 494735 512355 522949 527018 528146 534461 536903 552817 562790 576392 582291 591183 619724 621468 627547 631044 638775 644447 645943 648009 664467 676486 676529 677055 683042 687437 708749 709365 712137 717476 719260 720655 725616 726192 728958 729177 729402 734283 734344 735544 735992 740137 740493 744480 745361 745901 746546 749525 758980 763449 764810 765422 766236 766456 769047 779360 782418 786089 787648 789493 790367 791071 791789 792198 794182 795609 795668 795671 796551 796931 800120 802078 803785 803792 804130 804993 805341 809907 812429 813812 815222 818392 818547 818708 818755 818817 819430 819439 819957 819965 823347 823551 823574 823656 823689 823748 824693 824825 825059 825786 825822 825887 826632 826982 828122 828275 828316 828414 828429 828442 828563 ] |
||||||||||||||||||||||||||||||
|
15.02 ms (8.84%) |
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 2 477799 420648 512355 522949 536903 562790 823656 804993 719260 823748 792198 726192 823689 819439 534461 676529 805341 828414 795668 749525 745901 791789 408810 826638 826653 823347 815222 621468 765422 766236 644447 740493 823574 824205 818547 645943 708749 779360 819957 823551 800120 804130 734283 746546 826632 819965 582291 818755 828122 828316 828275 591183 796551 744480 824825 576392 683042 796931 786089 745361 728958 734344 729177 735544 627547 709365 782418 677055 729402 824693 828563 735992 528146 402249 813812 527018 638775 802078 725616 789493 790367 791071 794182 758980 769047 720655 809907 818817 819430 825887 826982 818708 825786 828429 648009 664467 712137 795609 795671 803785 763449 766456 459752 631044 812429 448089 687437 676486 552817 619724 825822 818392 825059 828442 494735 717476 787648 803792 740137 764810 ] |
||||||||||||||||||||||||||||||
|
3.85 ms (2.27%) |
1 |
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 402249 408810 420648 448089 459752 477799 494735 512355 522949 527018 528146 534461 536903 552817 562790 576392 582291 591183 619724 621468 627547 631044 638775 644447 645943 648009 664467 676486 676529 677055 683042 687437 708749 709365 712137 717476 719260 720655 725616 726192 728958 729177 729402 734283 734344 735544 735992 740137 740493 744480 745361 745901 746546 749525 758980 763449 764810 765422 766236 766456 769047 779360 782418 786089 787648 789493 790367 791071 791789 792198 794182 795609 795668 795671 796551 796931 800120 802078 803785 803792 804130 804993 805341 809907 812429 813812 815222 818392 818547 818708 818755 818817 819430 819439 819957 819965 823347 823551 823574 823656 823689 823748 824693 824825 825059 825786 825822 825887 826632 826982 828122 828275 828316 828414 828429 828442 828563 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pussy fucked"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"pussy fucked"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"pussy fucked"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.