Query Metrics
7
Database Queries
7
Different statements
232.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.39 ms (88.71%) |
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 232995 365839 384779 388760 392032 392599 401774 411335 417511 439798 440651 444129 445220 448055 449981 461248 467847 469893 470721 474904 477114 478023 478902 486590 496762 506074 508669 508746 509430 510425 511127 512717 513906 521690 535604 540707 545994 551888 552190 555989 560612 562321 562322 584864 586279 596507 598768 608784 618008 635781 653273 658052 658360 658487 660867 661270 662790 665872 666491 673256 675464 679353 685450 689132 693264 697598 700908 704586 705422 706410 707081 707507 715422 716695 721497 723241 729737 730672 733736 734709 736058 741744 742157 760677 762274 762517 763741 764821 766783 773686 778183 778500 778948 779274 779930 780853 782264 787340 790280 791016 793895 793933 793989 795108 795109 803262 806289 810637 811819 816120 817437 817835 817880 818038 818778 819930 819940 819991 824596 825698 ] |
||||||||||||||||||||||||||||||
|
16.08 ms (6.91%) |
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 535604 653273 707507 816120 817437 584864 766783 477114 618008 445220 448055 511127 508669 817835 819940 658052 693264 793895 810637 762517 440651 508746 232995 509430 736058 825698 819930 817880 818038 819991 540707 715422 658487 795108 734709 795109 763741 478902 790280 551888 741744 496762 762274 411335 467847 449981 478023 586279 679353 700908 793989 779274 742157 779930 555989 510425 384779 704586 707081 778948 793933 760677 662790 697598 675464 730672 733736 598768 401774 521690 512717 513906 596507 417511 439798 461248 764821 444129 818778 824596 562322 689132 660867 665872 706410 658360 705422 721497 608784 635781 778183 787340 811819 773686 778500 782264 803262 552190 780853 388760 365839 470721 469893 685450 806289 545994 392032 392599 486590 474904 506074 562321 716695 723241 661270 666491 673256 560612 791016 729737 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.33%) |
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 232995 365839 384779 388760 392032 392599 401774 411335 417511 439798 440651 444129 445220 448055 449981 461248 467847 469893 470721 474904 477114 478023 478902 486590 496762 506074 508669 508746 509430 510425 511127 512717 513906 521690 535604 540707 545994 551888 552190 555989 560612 562321 562322 584864 586279 596507 598768 608784 618008 635781 653273 658052 658360 658487 660867 661270 662790 665872 666491 673256 675464 679353 685450 689132 693264 697598 700908 704586 705422 706410 707081 707507 715422 716695 721497 723241 729737 730672 733736 734709 736058 741744 742157 760677 762274 762517 763741 764821 766783 773686 778183 778500 778948 779274 779930 780853 782264 787340 790280 791016 793895 793933 793989 795108 795109 803262 806289 810637 811819 816120 817437 817835 817880 818038 818778 819930 819940 819991 824596 825698 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск shower секс"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск shower секс"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian shower fuck"
]
|
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.