Query Metrics
7
Database Queries
7
Different statements
152.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.44 ms (82.09%) |
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 414078 417238 424778 425422 426968 427916 433814 446218 452290 458545 463793 464855 476153 478069 481383 487268 489165 493858 500880 502854 503069 504866 506243 507018 510901 511247 526590 528511 531000 537173 540766 547103 549102 550525 551729 552689 552737 555251 555467 556289 560990 562018 563005 563684 565762 565935 567614 568334 570131 571353 572649 576421 577020 577446 577460 578156 582931 584155 584469 584944 585289 585595 586309 587769 588181 588526 589857 591822 593722 604747 606991 617974 622529 626298 628677 629443 629784 633634 636252 639260 645698 647108 648057 662889 663174 663704 663738 664745 667098 669279 671218 672795 673212 679000 679660 679836 685805 692841 693345 694614 696373 701819 717127 754865 764833 767276 773002 773844 777320 779890 780764 785328 789180 791252 794582 797012 797682 798718 798793 809307 ] |
||||||||||||||||||||||||||||||
|
16.26 ms (10.64%) |
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 584469 552689 570131 577460 552737 663704 667098 671218 672795 679660 679836 673212 685805 694614 645698 647108 662889 663174 663738 664745 669279 679000 692841 693345 696373 547103 549102 565935 585289 604747 628677 629784 633634 636252 588526 589857 617974 639260 585595 606991 629443 779890 785328 798718 798793 809307 780764 791252 794582 797012 789180 797682 764833 773002 754865 767276 773844 701819 777320 424778 458545 507018 563684 588181 414078 425422 433814 537173 576421 555467 577020 577446 550525 556289 591822 622529 481383 478069 487268 540766 562018 563005 565762 567614 568334 648057 555251 584944 587769 593722 586309 446218 476153 504866 502854 493858 417238 551729 626298 426968 427916 463793 452290 464855 500880 503069 510901 511247 506243 526590 528511 531000 489165 571353 572649 578156 582931 560990 584155 717127 ] |
||||||||||||||||||||||||||||||
|
3.39 ms (2.22%) |
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 414078 417238 424778 425422 426968 427916 433814 446218 452290 458545 463793 464855 476153 478069 481383 487268 489165 493858 500880 502854 503069 504866 506243 507018 510901 511247 526590 528511 531000 537173 540766 547103 549102 550525 551729 552689 552737 555251 555467 556289 560990 562018 563005 563684 565762 565935 567614 568334 570131 571353 572649 576421 577020 577446 577460 578156 582931 584155 584469 584944 585289 585595 586309 587769 588181 588526 589857 591822 593722 604747 606991 617974 622529 626298 628677 629443 629784 633634 636252 639260 645698 647108 648057 662889 663174 663704 663738 664745 667098 669279 671218 672795 673212 679000 679660 679836 685805 692841 693345 694614 696373 701819 717127 754865 764833 767276 773002 773844 777320 779890 780764 785328 789180 791252 794582 797012 797682 798718 798793 809307 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov vagina"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов вагин"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.10%) |
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.