Query Metrics
7
Database Queries
7
Different statements
382.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.46 ms (55.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
146.42 ms (38.27%) |
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 21506 34697 96946 100616 167756 338075 341889 389231 393004 394586 397873 401309 422672 430526 446359 447086 454370 478048 488727 533690 540076 546838 548619 557987 570423 587795 598565 601536 606489 622645 631934 632008 632593 633070 636269 639274 639879 643007 645964 649114 649187 650817 652885 653362 665662 670108 670761 671721 673365 673554 674430 674519 678915 679349 683291 683963 684053 692806 694201 694221 694554 698537 699608 699658 703436 705516 705537 705813 705828 706030 708103 710500 713014 715089 715497 716868 719102 720243 720340 720711 721116 721711 722792 727742 728271 736837 739860 744594 753549 770322 770787 770881 770926 771560 772708 775892 777039 778366 780637 789647 790959 792831 796250 799284 800606 801948 801963 808093 814139 814498 815099 815723 816015 816211 816222 816317 816937 817444 820953 822424 ] |
||||||||||||||||||||||||||||||
|
15.74 ms (4.11%) |
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 478048 546838 744594 796250 167756 34697 21506 96946 815723 817444 820953 815099 816015 816317 816937 814139 816211 488727 533690 540076 570423 653362 683291 699608 649187 670108 673554 674430 683963 694554 699658 705813 645964 652885 674519 684053 694221 698537 705537 705828 706030 722792 606489 631934 632008 633070 639274 778366 777039 727742 772708 792831 800606 801963 808093 770787 771560 728271 753549 770926 739860 770322 770881 703436 705516 721711 775892 780637 801948 341889 100616 401309 715089 447086 650817 720340 789647 393004 397873 649114 678915 713014 720711 665662 716868 636269 639879 587795 622645 799284 736837 601536 632593 446359 394586 338075 389231 422672 430526 814498 822424 816222 454370 557987 694201 708103 710500 715497 719102 670761 671721 679349 692806 673365 720243 721116 548619 598565 643007 790959 ] |
||||||||||||||||||||||||||||||
|
3.88 ms (1.02%) |
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 21506 34697 96946 100616 167756 338075 341889 389231 393004 394586 397873 401309 422672 430526 446359 447086 454370 478048 488727 533690 540076 546838 548619 557987 570423 587795 598565 601536 606489 622645 631934 632008 632593 633070 636269 639274 639879 643007 645964 649114 649187 650817 652885 653362 665662 670108 670761 671721 673365 673554 674430 674519 678915 679349 683291 683963 684053 692806 694201 694221 694554 698537 699608 699658 703436 705516 705537 705813 705828 706030 708103 710500 713014 715089 715497 716868 719102 720243 720340 720711 721116 721711 722792 727742 728271 736837 739860 744594 753549 770322 770787 770881 770926 771560 772708 775892 777039 778366 780637 789647 790959 792831 796250 799284 800606 801948 801963 808093 814139 814498 815099 815723 816015 816211 816222 816317 816937 817444 820953 822424 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal mmf"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.39%) |
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.