Query Metrics
7
Database Queries
7
Different statements
386.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.23 ms (53.65%) |
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 145516 385655 391270 442649 462680 464095 467180 502810 521213 539570 540197 547520 553876 560089 560910 561860 562554 563731 565148 565993 583853 585644 586068 587189 591043 591503 593184 594804 594973 599250 605392 607584 617364 622980 626889 641341 642243 648209 650524 658943 660436 661029 662877 665881 666683 667615 668155 668538 684251 693036 694505 698431 703140 707479 713087 713188 714377 715264 716487 718460 722152 722168 724220 730628 733389 733406 734370 734614 735976 739298 744188 750647 755414 755956 776639 782403 784013 789059 793632 794546 794559 794565 794566 794593 800419 801004 801616 801855 803490 804359 805385 806226 809338 811112 811893 811989 812171 812548 814747 815715 815874 815913 816036 816934 816980 818197 819244 819773 820940 821604 823410 823538 823549 823576 824632 824663 826620 826705 827176 827397 ] |
||||||||||||||||||||||||||||||
|
161.45 ms (41.80%) |
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 145516 385655 391270 442649 462680 464095 467180 502810 521213 539570 540197 547520 553876 560089 560910 561860 562554 563731 565148 565993 583853 585644 586068 587189 591043 591503 593184 594804 594973 599250 605392 607584 617364 622980 626889 641341 642243 648209 650524 658943 660436 661029 662877 665881 666683 667615 668155 668538 684251 693036 694505 698431 703140 707479 713087 713188 714377 715264 716487 718460 722152 722168 724220 730628 733389 733406 734370 734614 735976 739298 744188 750647 755414 755956 776639 782403 784013 789059 793632 794546 794559 794565 794566 794593 800419 801004 801616 801855 803490 804359 805385 806226 809338 811112 811893 811989 812171 812548 814747 815715 815874 815913 816036 816934 816980 818197 819244 819773 820940 821604 823410 823538 823549 823576 824632 824663 826620 826705 827176 827397 ] |
||||||||||||||||||||||||||||||
|
10.83 ms (2.80%) |
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 755414 735976 385655 391270 815715 816980 814747 815913 816934 819244 815874 816036 818197 820940 823410 823538 464095 467180 540197 502810 521213 539570 462680 565148 547520 553876 665881 722152 722168 648209 684251 693036 718460 560089 583853 585644 587189 594804 599250 626889 794546 794593 801616 794559 794565 803490 733406 734370 734614 750647 784013 800419 801855 804359 805385 806226 811112 811893 811989 812548 730628 739298 744188 733389 755956 724220 794566 809338 812171 145516 442649 823576 824632 824663 826620 826705 819773 823549 827176 827397 821604 562554 563731 560910 565993 650524 668155 694505 713188 714377 715264 716487 658943 703140 707479 660436 661029 662877 666683 667615 668538 698431 713087 561860 586068 591503 607584 642243 591043 622980 593184 605392 594973 617364 641341 789059 801004 776639 782403 793632 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy tits"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.36%) |
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.