Query Metrics
7
Database Queries
7
Different statements
158.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.58 ms (84.34%) |
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 186592 212750 233347 362712 381996 382274 389675 402556 407411 414122 418219 448898 454023 461252 463689 466601 468220 469468 474163 500803 515398 526041 528997 529015 530199 533756 535972 540712 547111 547233 548313 550172 552401 552805 553828 560353 562215 564931 565644 567678 576158 579545 580139 581929 588968 590780 594549 598867 605661 607217 615339 623403 629528 656202 662849 670779 705210 716125 720179 722944 725420 735828 739101 739136 744183 744688 745654 749426 749958 750998 753625 754773 754925 762130 774062 776538 777529 777748 777789 780164 780886 782080 782658 785606 791350 792227 793194 794741 795921 796659 796709 799945 800649 800655 800673 800693 800715 803995 805949 805981 806540 806828 807088 807110 807121 810480 811104 811112 813557 813643 813930 813942 814530 822060 823789 824196 825795 825858 826143 ] |
||||||||||||||||||||||||||||||
|
14.27 ms (9.01%) |
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 780886 782080 782658 791350 794741 807088 807121 526041 414122 515398 468220 581929 552401 567678 588968 594549 463689 418219 598867 469468 461252 212750 186592 362712 381996 389675 402556 407411 813930 826143 825858 823789 822060 454023 530199 540712 474163 552786 548313 553828 562215 656202 670779 716125 722944 662849 705210 590780 615339 629528 607217 623403 777529 777748 799945 807110 776538 777789 800649 800693 800715 805949 811104 725420 744183 774062 792227 796659 800655 803995 806540 811112 735828 739136 750998 762130 739101 745654 744688 749958 753625 754773 749426 754925 720179 780164 793194 795921 796709 800673 805981 806828 810480 233347 785606 547233 448898 466601 580139 605661 500803 382274 813643 824196 813557 825795 813942 814530 529015 533756 528997 535972 564931 576158 579545 547111 550172 552805 565644 560353 ] |
||||||||||||||||||||||||||||||
|
3.66 ms (2.31%) |
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 186592 212750 233347 362712 381996 382274 389675 402556 407411 414122 418219 448898 454023 461252 463689 466601 468220 469468 474163 500803 515398 526041 528997 529015 530199 533756 535972 540712 547111 547233 548313 550172 552401 552805 553828 560353 562215 564931 565644 567678 576158 579545 580139 581929 588968 590780 594549 598867 605661 607217 615339 623403 629528 656202 662849 670779 705210 716125 720179 722944 725420 735828 739101 739136 744183 744688 745654 749426 749958 750998 753625 754773 754925 762130 774062 776538 777529 777748 777789 780164 780886 782080 782658 785606 791350 792227 793194 794741 795921 796659 796709 799945 800649 800655 800673 800693 800715 803995 805949 805981 806540 806828 807088 807110 807121 810480 811104 811112 813557 813643 813930 813942 814530 822060 823789 824196 825795 825858 826143 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo tights"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло колготк"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.90%) |
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.