Query Metrics
7
Database Queries
7
Different statements
174.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.15 ms (86.15%) |
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 394271 397015 397912 441530 448080 468112 468343 506371 527189 529586 529810 538248 547853 564184 575625 588433 590795 594267 598135 608233 620075 622836 629167 630651 631521 632103 639092 640375 642689 645365 655260 656597 660836 676656 683303 692528 700031 703471 704619 704703 705461 706754 708107 712591 715391 718127 719544 720087 721910 722001 724978 725025 725032 725547 726897 726926 728517 730069 730333 731243 734934 736741 737055 745912 746915 747749 750118 750229 753550 756847 756986 758806 759791 760609 761009 761115 761579 761724 764161 765715 765952 767073 767095 767193 768392 769018 769039 769070 772831 775390 775904 776203 777337 778962 780061 780503 781622 785097 787319 788631 791412 792720 793816 794351 799692 799868 800594 802051 810413 811555 811663 813703 813850 816140 817203 818911 824862 824882 826153 826728 ] |
||||||||||||||||||||||||||||||
|
13.68 ms (7.85%) |
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 791412 780061 785097 655260 692528 590795 629167 397015 722001 756847 780503 747749 730333 529810 506371 718127 788631 777337 778962 761009 758806 767193 768392 708107 761115 824882 826728 792720 761579 726926 734934 769018 776203 810413 564184 726897 622836 645365 660836 704619 639092 598135 631521 703471 706754 575625 704703 630651 818911 817203 468343 394271 826153 761724 730069 745912 767073 538248 529586 721910 640375 725032 620075 799692 632103 813703 799868 787319 802051 767095 794351 800594 811555 769039 448080 468112 728517 824862 781622 725547 737055 547853 720087 608233 775904 746915 753550 759791 750118 731243 750229 724978 756986 765952 719544 769070 736741 712591 676656 656597 594267 588433 811663 527189 816140 715391 793816 725025 772831 775390 683303 700031 764161 705461 642689 397912 760609 765715 441530 813850 ] |
||||||||||||||||||||||||||||||
|
2.97 ms (1.70%) |
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 394271 397015 397912 441530 448080 468112 468343 506371 527189 529586 529810 538248 547853 564184 575625 588433 590795 594267 598135 608233 620075 622836 629167 630651 631521 632103 639092 640375 642689 645365 655260 656597 660836 676656 683303 692528 700031 703471 704619 704703 705461 706754 708107 712591 715391 718127 719544 720087 721910 722001 724978 725025 725032 725547 726897 726926 728517 730069 730333 731243 734934 736741 737055 745912 746915 747749 750118 750229 753550 756847 756986 758806 759791 760609 761009 761115 761579 761724 764161 765715 765952 767073 767095 767193 768392 769018 769039 769070 772831 775390 775904 776203 777337 778962 780061 780503 781622 785097 787319 788631 791412 792720 793816 794351 799692 799868 800594 802051 810413 811555 811663 813703 813850 816140 817203 818911 824862 824882 826153 826728 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск hot анал"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur hot anal"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск hot анал"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.99%) |
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.