Query Metrics
7
Database Queries
7
Different statements
144.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.96 ms (84.53%) |
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 173960 391906 397760 404443 410312 416170 417789 418018 425526 425984 426167 435689 443255 445097 446778 450455 451029 454342 464964 466408 477021 486784 492426 498511 505343 507798 508250 518550 528775 529884 530569 533266 539319 545663 548010 548835 561038 579670 580532 582900 584026 586289 587178 589191 595116 602811 607629 615823 615921 617118 618247 628615 644883 650440 656672 665971 669067 669079 669332 669386 671044 681539 707626 709729 714380 716493 722385 730628 734614 735783 739127 741878 749362 752626 758787 762706 764321 768078 769568 771802 772768 774672 778064 782015 783136 785496 788209 788953 792274 793455 793844 794570 794577 794584 797120 797631 797853 798961 801008 802272 805319 806309 807616 808514 808665 808673 813793 818736 819277 820723 821775 823758 824079 824735 826114 826532 826643 828847 ] |
||||||||||||||||||||||||||||||
|
11.72 ms (8.12%) |
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 615921 788209 788953 741878 758787 615823 451029 426167 498511 518550 466408 533266 584026 582900 818736 828847 722385 797853 767890 749362 771802 778064 410312 774672 425526 464964 425984 417789 446778 450455 505343 508250 579670 548835 656672 671044 665971 669067 709729 587178 764321 794577 806309 762706 783136 792274 772768 492426 808514 793844 644883 530569 545663 707626 628615 595116 607629 539319 794570 173960 445097 824735 548010 768078 416170 443255 561038 669332 669386 617118 586289 630427 752626 404443 528775 819277 824079 826532 826114 820723 716493 589191 808665 793455 734614 735783 807616 730628 739127 769568 785496 454342 391906 650440 618247 813793 529884 782015 797631 397760 823758 826643 821775 805319 808673 801008 794584 797120 798961 802272 418018 435689 580532 477021 486784 507798 714380 669079 681539 602811 ] |
||||||||||||||||||||||||||||||
|
3.52 ms (2.44%) |
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 173960 391906 397760 404443 410312 416170 417789 418018 425526 425984 426167 435689 443255 445097 446778 450455 451029 454342 464964 466408 477021 486784 492426 498511 505343 507798 508250 518550 528775 529884 530569 533266 539319 545663 548010 548835 561038 579670 580532 582900 584026 586289 587178 589191 595116 602811 607629 615823 615921 617118 618247 628615 644883 650440 656672 665971 669067 669079 669332 669386 671044 681539 707626 709729 714380 716493 722385 730628 734614 735783 739127 741878 749362 752626 758787 762706 764321 768078 769568 771802 772768 774672 778064 782015 783136 785496 788209 788953 792274 793455 793844 794570 794577 794584 797120 797631 797853 798961 801008 802272 805319 806309 807616 808514 808665 808673 813793 818736 819277 820723 821775 823758 824079 824735 826114 826532 826643 828847 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные boobs домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.30%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge boobs homemade"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"огромные boobs домашн любительск"
]
|
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.