Query Metrics
7
Database Queries
7
Different statements
138.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.03 ms (85.72%) |
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 389995 390459 421404 441997 466418 519444 529766 534639 543600 548247 548355 554108 557805 567978 576579 581192 610140 626636 629659 631024 631816 656147 685233 688245 691706 692164 693425 710352 710936 715183 715692 717119 718113 718325 718346 718847 719083 721714 723476 725240 725489 726888 728568 728634 729018 730309 730780 730972 733944 734295 734300 734540 739887 748063 750703 751269 753216 753704 756295 758296 760787 761378 761418 763370 763644 764850 765476 766221 766260 766278 768641 768686 768814 770153 771430 771894 772863 775168 775474 776028 777041 777276 777484 778065 778719 779079 779405 779586 779730 781543 783572 787647 788053 788358 788560 788869 790181 791151 791869 792704 793396 793519 793595 794922 795236 795905 797120 797472 799511 800798 802228 802619 803699 808316 811381 811589 813313 813428 814032 ] |
||||||||||||||||||||||||||||||
|
10.15 ms (7.31%) |
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 725489 763644 766221 766278 775474 792704 793595 813313 389995 441997 421404 814032 715692 802228 787647 813428 771430 784610 790181 791151 795236 811381 734295 771894 733944 739887 758296 779079 791869 793519 797120 811589 692164 529766 581192 691706 631816 629659 730780 763370 610140 710936 777484 693425 656147 688245 685233 772863 756295 390459 466418 534639 519444 543600 567978 554108 557805 576579 717119 718847 721714 723476 718325 718346 719083 710352 715183 718113 548247 548355 626636 631024 775168 777276 778719 779405 779730 788053 788869 795905 800798 803699 776028 777041 778065 779586 783572 788358 788560 802619 726888 728568 728634 729018 734300 751269 753216 753704 760787 761378 761418 764850 765476 766260 768641 768686 768814 770153 781543 793396 794922 797472 799511 808316 725240 730309 730972 734540 748063 750703 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (2.37%) |
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 389995 390459 421404 441997 466418 519444 529766 534639 543600 548247 548355 554108 557805 567978 576579 581192 610140 626636 629659 631024 631816 656147 685233 688245 691706 692164 693425 710352 710936 715183 715692 717119 718113 718325 718346 718847 719083 721714 723476 725240 725489 726888 728568 728634 729018 730309 730780 730972 733944 734295 734300 734540 739887 748063 750703 751269 753216 753704 756295 758296 760787 761378 761418 763370 763644 764850 765476 766221 766260 766278 768641 768686 768814 770153 771430 771894 772863 775168 775474 776028 777041 777276 777484 778065 778719 779079 779405 779586 779730 781543 783572 787647 788053 788358 788560 788869 790181 791151 791869 792704 793396 793519 793595 794922 795236 795905 797120 797472 799511 800798 802228 802619 803699 808316 811381 811589 813313 813428 814032 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm homemade"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.