Query Metrics
7
Database Queries
7
Different statements
212.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.62 ms (86.04%) |
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 386816 397174 408278 421009 422053 425590 428895 430833 430835 431302 443809 446286 446288 448707 449764 464389 483401 487608 518312 518927 521469 524245 527148 534262 534276 560081 563524 564780 566013 569952 575720 582760 599997 603307 603316 604913 610315 613263 624600 645600 681041 681279 688083 699730 700741 714049 714475 717731 719097 725116 728018 732547 741611 742880 747258 762192 764005 765477 765482 766033 770630 773554 775971 776503 781112 781791 783625 785093 786167 786279 790356 790614 792356 793406 794980 796246 797504 798645 799256 799413 801883 801898 802120 802436 803472 804073 804455 806104 806511 807389 807912 808182 808626 808946 809519 809723 810447 811081 813505 814376 814758 814880 815226 815256 815436 815534 815842 816068 816209 816562 816969 817233 818273 818277 818284 818335 820072 820339 821612 824315 ] |
||||||||||||||||||||||||||||||
|
16.03 ms (7.55%) |
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 801883 808182 446286 518312 430835 518927 408278 431302 815534 815842 817233 818277 820072 814758 821612 815436 816562 816969 818335 815226 816068 818273 818284 824315 487608 534276 534262 464389 566013 563524 645600 719097 717731 688083 564780 599997 610315 624600 775971 790356 797504 799256 806104 776503 781112 783625 798645 799413 802120 802436 809519 810447 811081 742880 785093 804455 808626 813505 732547 765482 747258 765477 764005 728018 770630 773554 699730 790614 792356 803472 807912 808946 809723 446288 448707 421009 575720 582760 741611 814376 449764 483401 560081 422053 443809 524245 681279 714475 428895 430833 521469 681041 613263 386816 816209 781791 700741 804073 397174 815256 820339 814880 527148 569952 714049 603316 603307 604913 801898 793406 807389 725116 766033 786279 762192 786167 794980 796246 806511 425590 ] |
||||||||||||||||||||||||||||||
|
6.15 ms (2.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"lick mom tits"
]
|
||||||||||||||||||||||||||||||
|
2.29 ms (1.08%) |
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 386816 397174 408278 421009 422053 425590 428895 430833 430835 431302 443809 446286 446288 448707 449764 464389 483401 487608 518312 518927 521469 524245 527148 534262 534276 560081 563524 564780 566013 569952 575720 582760 599997 603307 603316 604913 610315 613263 624600 645600 681041 681279 688083 699730 700741 714049 714475 717731 719097 725116 728018 732547 741611 742880 747258 762192 764005 765477 765482 766033 770630 773554 775971 776503 781112 781791 783625 785093 786167 786279 790356 790614 792356 793406 794980 796246 797504 798645 799256 799413 801883 801898 802120 802436 803472 804073 804455 806104 806511 807389 807912 808182 808626 808946 809519 809723 810447 811081 813505 814376 814758 814880 815226 815256 815436 815534 815842 816068 816209 816562 816969 817233 818273 818277 818284 818335 820072 820339 821612 824315 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза mom сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза mom сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.70%) |
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.