Query Metrics
7
Database Queries
7
Different statements
154.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.56 ms (83.87%) |
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 86826 113951 228398 468552 482871 486070 542178 560263 587924 594218 596381 597844 599207 600235 603786 604323 608630 614281 616209 626121 630238 636441 642226 647365 647822 664681 673052 681635 688190 691303 693333 697481 709797 731032 734090 746262 754939 755330 756094 756194 760397 760512 763550 763677 764510 764912 765591 766239 766293 768357 769887 772394 772551 774975 779085 779513 779825 781222 781482 783199 783354 783803 784232 784445 784609 785218 785324 785985 786071 786684 787306 787658 789405 789898 790915 791254 792042 792430 792500 792519 793633 795121 795154 797167 797179 798921 799321 799603 799609 799742 800343 800840 802491 802506 802515 802706 802942 803065 803181 804393 804929 807924 808619 809118 809739 809861 809953 810443 811129 811403 812999 814307 815106 815122 815129 817493 ] |
||||||||||||||||||||||||||||||
|
13.81 ms (8.94%) |
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 779825 787306 802942 228398 815106 482871 673052 630238 791254 800840 772394 783803 792519 797179 803065 798921 799609 795121 815129 790915 783199 792430 755330 764510 616209 786071 113951 86826 596381 642226 636441 604323 797167 799742 802515 779513 784232 807924 767642 787658 765591 760512 697481 774975 787390 804393 810443 814307 691303 594218 795154 731032 764912 468552 542178 681635 688190 587924 597844 600235 608630 781222 784445 785324 792042 799321 800343 802491 802506 786684 793633 809953 812999 756094 784609 789405 808619 734090 769887 756194 763677 766239 766293 771059 779085 781482 783559 785218 804929 603786 486070 693333 647365 647822 664681 709797 626121 599207 789898 799603 802706 809118 811129 809739 809861 783354 792500 803181 760397 754939 746262 763550 772551 614281 785985 815122 768357 817493 811403 560263 ] |
||||||||||||||||||||||||||||||
|
3.35 ms (2.17%) |
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 86826 113951 228398 468552 482871 486070 542178 560263 587924 594218 596381 597844 599207 600235 603786 604323 608630 614281 616209 626121 630238 636441 642226 647365 647822 664681 673052 681635 688190 691303 693333 697481 709797 731032 734090 746262 754939 755330 756094 756194 760397 760512 763550 763677 764510 764912 765591 766239 766293 768357 769887 772394 772551 774975 779085 779513 779825 781222 781482 783199 783354 783803 784232 784445 784609 785218 785324 785985 786071 786684 787306 787658 789405 789898 790915 791254 792042 792430 792500 792519 793633 795121 795154 797167 797179 798921 799321 799603 799609 799742 800343 800840 802491 802506 802515 802706 802942 803065 803181 804393 804929 807924 808619 809118 809739 809861 809953 810443 811129 811403 812999 814307 815106 815122 815129 817493 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.32%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov sex"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов секс"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов секс"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.16%) |
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.