Query Metrics
7
Database Queries
7
Different statements
221.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
192.62 ms (87.15%) |
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 389273 404953 416236 417485 419819 421471 421660 423484 423572 423767 423920 424770 426616 434313 434336 434367 434371 442629 443112 450226 454524 454658 460619 463764 467886 467889 467908 467934 469514 474735 476409 477074 480760 490196 491230 491607 491926 492232 499378 502866 503115 503118 516023 522348 522604 522611 522918 538608 542610 544490 545649 546958 547474 549036 550124 550282 550672 553494 556018 561015 561040 561415 562842 562843 564227 564385 567343 568378 569168 569229 569526 569919 571024 573204 576686 580855 581269 590813 591109 592388 592444 595768 598090 598169 599783 599928 599963 600237 601749 602650 603686 603890 604103 605026 605133 606587 615921 618483 621680 624152 626399 627338 630420 643542 660416 668688 669012 669038 669074 669362 671044 695870 716160 738814 743890 744639 787491 815121 828871 ] |
||||||||||||||||||||||||||||||
|
18.02 ms (8.15%) |
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 621680 592388 643542 599783 618483 389273 421660 467889 477074 423767 419819 423484 416236 421471 491926 491230 569229 568378 626399 590813 600237 627338 716160 434336 424770 442629 815121 454524 522918 538608 469514 562842 573204 561415 564227 569168 547474 550672 569919 669038 669362 671044 669074 695870 660416 550282 561015 561040 580855 605133 606587 598169 601749 599928 603686 615921 598090 605026 630420 743890 744639 603890 467886 434313 434367 423920 434371 502866 499378 787491 476409 826362 423572 503118 549036 602650 417485 474735 490196 516023 522611 522348 460619 542610 545649 576686 564385 571024 581269 544490 556018 562843 569526 669012 546958 553494 599963 624152 591109 592444 604103 738814 467934 450226 492232 503115 463764 567343 828871 454658 595768 522604 550124 668688 404953 443112 426616 467908 480760 491607 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.27%) |
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 389273 404953 416236 417485 419819 421471 421660 423484 423572 423767 423920 424770 426616 434313 434336 434367 434371 442629 443112 450226 454524 454658 460619 463764 467886 467889 467908 467934 469514 474735 476409 477074 480760 490196 491230 491607 491926 492232 499378 502866 503115 503118 516023 522348 522604 522611 522918 538608 542610 544490 545649 546958 547474 549036 550124 550282 550672 553494 556018 561015 561040 561415 562842 562843 564227 564385 567343 568378 569168 569229 569526 569919 571024 573204 576686 580855 581269 590813 591109 592388 592444 595768 598090 598169 599783 599928 599963 600237 601749 602650 603686 603890 604103 605026 605133 606587 615921 618483 621680 624152 626399 627338 630420 643542 660416 668688 669012 669038 669074 669362 671044 695870 716160 738814 743890 744639 787491 815121 828871 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny anal milf"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые анал milf"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые анал milf"
]
|
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.