Query Metrics
7
Database Queries
7
Different statements
135.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.49 ms (86.66%) |
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 13338 21626 73672 190732 324827 365901 382385 438765 475280 518818 528397 547259 551024 565228 570686 573104 593193 601147 603001 603612 604163 611796 611905 612273 624462 633748 634954 638858 644273 671107 680583 693295 695638 699672 708107 710453 713657 716769 717833 717904 718606 721200 722113 722161 722440 724770 730763 733650 738178 741142 748477 749982 753405 755367 758870 760455 760851 760918 773380 773469 777460 779220 779509 780180 781121 787739 787882 793808 793894 795083 795880 796241 797524 797582 799403 800112 800688 802349 802399 804370 810626 813857 817873 819209 819210 819413 819778 820591 820734 823546 823554 823873 824910 825006 825434 825750 826300 826342 826792 826976 827105 827164 827403 827930 827946 828088 828106 828169 828195 828199 828336 828440 828452 828467 828493 828699 828725 828805 ] |
||||||||||||||||||||||||||||||
|
9.08 ms (6.70%) |
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 644273 518818 475280 828336 828440 324827 633748 826300 547259 716769 638858 796241 604163 593193 755367 828195 828199 828699 828452 438765 601147 190732 799403 826342 828169 825434 828467 570686 722161 612273 797582 804370 733650 717833 826792 826976 828106 828493 748477 760851 611905 693295 777460 762279 365901 382385 813857 828805 565228 671107 699672 717904 713657 634954 760455 795880 797524 741142 773469 773380 708107 528397 819413 827105 820734 680583 721200 779220 749982 722113 13338 795083 800112 21626 827164 611796 760918 827403 824910 823546 738178 722440 603612 603001 73672 817873 819210 820591 819209 819778 823554 825750 828088 828725 551024 573104 710453 718606 624462 802399 787739 724770 780180 781121 787882 823873 827946 810626 825006 826137 730763 800688 758870 827930 695638 779509 793808 793894 802349 753405 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.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 13338 21626 73672 190732 324827 365901 382385 438765 475280 518818 528397 547259 551024 565228 570686 573104 593193 601147 603001 603612 604163 611796 611905 612273 624462 633748 634954 638858 644273 671107 680583 693295 695638 699672 708107 710453 713657 716769 717833 717904 718606 721200 722113 722161 722440 724770 730763 733650 738178 741142 748477 749982 753405 755367 758870 760455 760851 760918 773380 773469 777460 779220 779509 780180 781121 787739 787882 793808 793894 795083 795880 796241 797524 797582 799403 800112 800688 802349 802399 804370 810626 813857 817873 819209 819210 819413 819778 820591 820734 823546 823554 823873 824910 825006 825434 825750 826300 826342 826792 826976 827105 827164 827403 827930 827946 828088 828106 828169 828195 828199 828336 828440 828452 828467 828493 828699 828725 828805 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex hot"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс hot"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс hot"
]
|
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.