Query Metrics
7
Database Queries
7
Different statements
183.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.52 ms (87.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 405727 427929 460307 461835 475109 489778 493578 495860 503966 533180 535243 535909 549515 549547 551016 557020 572946 574369 577264 578677 579671 584393 599115 602965 610134 622790 623230 623427 631500 636338 645065 648451 652190 653316 654167 662459 675276 687118 687666 691000 693722 696249 700158 704355 707251 707701 707944 713130 713731 714173 715408 716571 716825 716991 717229 718341 718405 719953 719977 722098 723086 723116 724433 724444 724498 724894 725709 726271 726408 726535 728170 731968 732388 732570 733648 735647 735854 737300 737411 738976 739636 739720 741340 743567 744694 744763 747543 747607 747625 748000 749324 749498 749607 750381 752382 754619 755113 756204 756683 757690 759000 764386 768913 769702 770758 771529 772292 793677 794950 797876 798887 800348 804647 809410 811355 811402 818100 823557 823575 825005 ] |
||||||||||||||||||||||||||||||
|
12.89 ms (7.04%) |
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 610134 623427 747607 750381 756683 724498 726535 747543 735647 728170 744694 757690 770758 771529 809410 495860 823575 723086 800348 733648 738976 764386 716991 535243 662459 652190 623230 599115 713731 475109 427929 574369 707944 648451 696249 713130 631500 700158 823557 818100 825005 493578 549515 719953 704355 722098 675276 622790 798887 724894 741340 747625 772292 724433 724444 739636 748000 754619 756204 726408 737300 743567 749498 759000 726271 744763 752382 769702 739720 768913 717229 723116 793677 811355 811402 707701 636338 731968 602965 707251 533180 732388 557020 578677 489778 460307 551016 716825 715408 719977 794950 755113 687118 693722 461835 654167 718341 725709 737411 797876 735854 749324 732570 749607 714173 716571 405727 503966 577264 718405 804647 535909 584393 549547 572946 579671 645065 653316 687666 691000 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (1.75%) |
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 405727 427929 460307 461835 475109 489778 493578 495860 503966 533180 535243 535909 549515 549547 551016 557020 572946 574369 577264 578677 579671 584393 599115 602965 610134 622790 623230 623427 631500 636338 645065 648451 652190 653316 654167 662459 675276 687118 687666 691000 693722 696249 700158 704355 707251 707701 707944 713130 713731 714173 715408 716571 716825 716991 717229 718341 718405 719953 719977 722098 723086 723116 724433 724444 724498 724894 725709 726271 726408 726535 728170 731968 732388 732570 733648 735647 735854 737300 737411 738976 739636 739720 741340 743567 744694 744763 747543 747607 747625 748000 749324 749498 749607 750381 752382 754619 755113 756204 756683 757690 759000 764386 768913 769702 770758 771529 772292 793677 794950 797876 798887 800348 804647 809410 811355 811402 818100 823557 823575 825005 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск большие cock"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur big cock"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск большие cock"
]
|
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.