Query Metrics
7
Database Queries
7
Different statements
174.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
140.59 ms (80.43%) |
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 4282 197300 382851 389618 392772 396303 397075 397401 417284 421618 426374 426877 427250 427373 450684 452731 454470 456505 458313 458527 460410 460417 461676 463397 463501 465415 467082 469693 476446 477122 478362 483025 489924 496123 499964 499995 500553 506246 508243 509864 516793 518004 519595 522749 539913 551576 554129 556779 572720 574967 575539 578207 578809 584170 585375 586057 587274 590604 591401 594608 605675 626839 653117 688902 691982 700219 711554 711565 717274 722149 724698 729111 735581 745962 748687 750458 758023 765536 768615 768624 770958 771931 772461 773601 776678 778786 779147 781128 782318 787847 789461 789472 791769 792399 795998 796744 797313 798791 804032 811528 818097 819527 819804 823013 825068 825191 825350 825400 825633 825764 825930 825985 825986 827142 827280 827632 828438 828442 828555 828781 ] |
||||||||||||||||||||||||||||||
|
23.18 ms (13.26%) |
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 392772 818097 828781 827632 828442 522749 578809 653117 691982 750458 773601 758023 771931 778786 458313 452731 539913 463501 575539 578207 605675 626839 590604 724698 460410 499964 499995 506246 518004 396303 454470 519595 556779 554129 717274 711554 711565 586057 587274 591401 776678 745962 467082 478362 427250 426877 516793 508243 483025 496123 825633 825191 825985 827142 827280 825068 828555 828438 688902 700219 585375 781128 779147 797313 772461 782318 789461 789472 791769 768624 729111 765536 787847 798791 804032 197300 397401 397075 421618 426374 460417 461676 489924 456505 477122 500553 509864 584170 551576 572720 574967 722149 594608 796744 748687 792399 795998 735581 768615 770958 811528 382851 427373 465415 417284 463397 469693 450684 458527 476446 4282 389618 825930 819804 823013 825350 825400 819527 825764 825986 ] |
||||||||||||||||||||||||||||||
|
3.47 ms (1.99%) |
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 4282 197300 382851 389618 392772 396303 397075 397401 417284 421618 426374 426877 427250 427373 450684 452731 454470 456505 458313 458527 460410 460417 461676 463397 463501 465415 467082 469693 476446 477122 478362 483025 489924 496123 499964 499995 500553 506246 508243 509864 516793 518004 519595 522749 539913 551576 554129 556779 572720 574967 575539 578207 578809 584170 585375 586057 587274 590604 591401 594608 605675 626839 653117 688902 691982 700219 711554 711565 717274 722149 724698 729111 735581 745962 748687 750458 758023 765536 768615 768624 770958 771931 772461 773601 776678 778786 779147 781128 782318 787847 789461 789472 791769 792399 795998 796744 797313 798791 804032 811528 818097 819527 819804 823013 825068 825191 825350 825400 825633 825764 825930 825985 825986 827142 827280 827632 828438 828442 828555 828781 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy cum"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак cum"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак cum"
]
|
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.