Query Metrics
7
Database Queries
7
Different statements
144.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.87 ms (83.24%) |
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 80230 145706 146006 184943 223663 233674 241970 350614 359492 382665 382924 384170 384460 385728 386467 387425 388555 389657 389661 396558 401463 404841 485942 497792 510587 515024 530568 532696 534963 543074 549998 554350 564142 570314 571187 577268 581267 587979 594426 597166 599566 612041 622695 626807 628325 629311 631253 634877 636012 636052 641456 649280 650204 651212 667456 675827 682414 694195 696275 697211 698580 699638 700669 710878 712026 715479 716293 725437 732177 732963 733129 733366 735991 736041 739941 742048 742572 742792 744174 750302 751524 759697 760077 770867 773716 773754 786452 793535 794519 794577 796704 801862 802303 802304 805724 808232 808656 810010 810011 810318 812187 812469 813619 813753 815222 816054 819229 819263 821142 823446 823862 824042 824086 825152 826602 826627 827208 827272 827577 827630 ] |
||||||||||||||||||||||||||||||
|
12.85 ms (8.92%) |
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 359492 401463 698580 694195 587979 735991 773754 612041 675827 794577 802303 796704 742572 386467 350614 530568 710878 594426 812187 760077 808232 733129 786452 739941 384460 744174 396558 821142 826627 816054 825152 712026 742048 641456 699638 682414 388555 485942 793535 750302 773716 770867 810011 813619 827272 827577 819229 532696 549998 667456 650204 700669 622695 631253 810318 801862 802304 733366 805724 732177 794519 384170 233674 389661 826602 715479 382924 599566 389657 823862 184943 543074 570314 581267 554350 696275 628325 810010 697211 146006 80230 827208 827630 819263 823446 813753 824042 824086 497792 510587 534963 564142 577268 651212 597166 629311 626807 636052 812469 808656 725437 732963 742792 736041 751524 759697 571187 515024 649280 634877 815222 385728 404841 145706 636012 241970 387425 382665 223663 716293 ] |
||||||||||||||||||||||||||||||
|
3.97 ms (2.76%) |
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 80230 145706 146006 184943 223663 233674 241970 350614 359492 382665 382924 384170 384460 385728 386467 387425 388555 389657 389661 396558 401463 404841 485942 497792 510587 515024 530568 532696 534963 543074 549998 554350 564142 570314 571187 577268 581267 587979 594426 597166 599566 612041 622695 626807 628325 629311 631253 634877 636012 636052 641456 649280 650204 651212 667456 675827 682414 694195 696275 697211 698580 699638 700669 710878 712026 715479 716293 725437 732177 732963 733129 733366 735991 736041 739941 742048 742572 742792 744174 750302 751524 759697 760077 770867 773716 773754 786452 793535 794519 794577 796704 801862 802303 802304 805724 808232 808656 810010 810011 810318 812187 812469 813619 813753 815222 816054 819229 819263 821142 823446 823862 824042 824086 825152 826602 826627 827208 827272 827577 827630 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy big tits"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (1.06%) |
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.