Query Metrics
7
Database Queries
7
Different statements
196.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.98 ms (87.64%) |
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 467138 490967 529753 530393 532462 535527 537048 545067 556538 567542 583272 588185 590137 606513 606970 608181 609065 610264 613527 613870 616574 618681 628660 634961 636160 636193 642227 643693 653583 653748 665092 666678 674542 674857 689977 694904 696409 700911 707959 709429 712665 717327 717443 717740 720525 720731 724015 725102 727584 729362 730084 730988 734299 735798 736655 736793 736929 739469 742645 743764 744680 746056 748284 748638 752874 753090 753101 754236 754565 754988 755433 758327 758357 758968 759441 761820 762662 766492 767446 769964 771937 772186 774566 774678 775102 777126 778202 782658 783292 784749 785692 786767 788232 788591 788873 790003 790161 790763 793911 794297 794723 795640 796795 799078 799670 800183 800858 801698 804383 804604 804769 805209 806753 806809 808132 808488 809739 810488 812408 813631 ] |
||||||||||||||||||||||||||||||
|
14.14 ms (7.20%) |
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 736793 758968 724015 729362 735798 739469 769964 736655 743764 759441 762662 744680 753090 753101 754565 755433 606513 717327 717443 782658 799078 800183 808488 813631 530393 529753 532462 535527 537048 467138 490967 556538 583272 545067 567542 674542 696409 712665 720731 653583 689977 700911 709429 717740 653748 665092 666678 674857 694904 707959 720525 590137 609065 616574 636160 642227 613870 634961 636193 610264 613527 628660 643693 588185 606970 608181 618681 774678 777126 783292 784749 788232 788873 790161 793911 794723 795640 796795 804383 804604 806809 810488 812408 774566 775102 778202 790003 794297 799670 800858 801698 804769 805209 806753 808132 809739 727584 730084 734299 754236 754988 758327 758357 766492 767446 772186 785692 786767 788591 790763 736929 748638 752874 761820 771937 725102 730988 742645 746056 748284 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.57%) |
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 467138 490967 529753 530393 532462 535527 537048 545067 556538 567542 583272 588185 590137 606513 606970 608181 609065 610264 613527 613870 616574 618681 628660 634961 636160 636193 642227 643693 653583 653748 665092 666678 674542 674857 689977 694904 696409 700911 707959 709429 712665 717327 717443 717740 720525 720731 724015 725102 727584 729362 730084 730988 734299 735798 736655 736793 736929 739469 742645 743764 744680 746056 748284 748638 752874 753090 753101 754236 754565 754988 755433 758327 758357 758968 759441 761820 762662 766492 767446 769964 771937 772186 774566 774678 775102 777126 778202 782658 783292 784749 785692 786767 788232 788591 788873 790003 790161 790763 793911 794297 794723 795640 796795 799078 799670 800183 800858 801698 804383 804604 804769 805209 806753 806809 808132 808488 809739 810488 812408 813631 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"твои"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"тво"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.78%) |
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.