Query Metrics
7
Database Queries
7
Different statements
152.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.60 ms (84.83%) |
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 405423 487495 514208 538699 556268 559207 572701 576597 588134 588945 595485 599601 602915 605535 618429 621447 621721 623226 626624 629667 631010 632418 636118 639186 640844 644049 644115 646482 649268 650565 656830 659476 660131 661514 668034 687935 697662 698187 698471 703024 703310 710858 711620 724739 724820 727331 731237 731280 731311 732752 735254 736155 737300 738218 738807 738839 738937 740281 744430 748498 748908 748939 750276 750470 751396 755581 756257 756826 757587 757646 758741 760192 760436 761802 762067 762242 763424 764623 764889 767092 767634 769101 769479 770590 771784 775646 778008 778074 779094 779255 779620 780323 781244 782117 786883 787696 788383 789649 791878 793228 793775 793966 794282 796491 799700 802040 804039 804816 804978 806116 810167 810559 812287 813098 816152 819159 819764 823557 827271 ] |
||||||||||||||||||||||||||||||
|
12.43 ms (8.14%) |
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 796491 802040 731237 762067 767092 767634 738839 738937 763424 764623 732752 744430 769101 757646 779620 780323 781244 788383 793228 794282 799700 804816 804978 806116 810167 487495 538699 514208 556268 656830 703310 711620 649268 650565 659476 661514 668034 646482 687935 697662 703024 710858 588134 626624 636118 588945 595485 599601 618429 629667 644049 644115 602915 631010 639186 724739 758741 698187 698471 804039 559207 572701 623802 605535 793775 775646 779255 787696 789649 778074 623226 405423 819764 823557 827271 816152 819159 660131 576597 621447 632418 640844 778008 779094 786883 810559 812287 813098 736155 755581 756826 760192 760436 770590 782117 791878 793966 731280 740281 756257 764889 769479 727331 731311 735254 737300 748498 750276 738218 738807 748908 748939 761802 762242 724820 750470 751396 757587 771784 621721 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.06%) |
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 405423 487495 514208 538699 556268 559207 572701 576597 588134 588945 595485 599601 602915 605535 618429 621447 621721 623226 626624 629667 631010 632418 636118 639186 640844 644049 644115 646482 649268 650565 656830 659476 660131 661514 668034 687935 697662 698187 698471 703024 703310 710858 711620 724739 724820 727331 731237 731280 731311 732752 735254 736155 737300 738218 738807 738839 738937 740281 744430 748498 748908 748939 750276 750470 751396 755581 756257 756826 757587 757646 758741 760192 760436 761802 762067 762242 763424 764623 764889 767092 767634 769101 769479 770590 771784 775646 778008 778074 779094 779255 779620 780323 781244 782117 786883 787696 788383 789649 791878 793228 793775 793966 794282 796491 799700 802040 804039 804816 804978 806116 810167 810559 812287 813098 816152 819159 819764 823557 827271 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск sister"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur sister"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск sister"
]
|
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.