Query Metrics
7
Database Queries
7
Different statements
182.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.91 ms (85.96%) |
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 89346 337704 387680 415957 416539 416583 416708 417491 421520 430374 432771 434067 443242 443247 443323 447305 447668 448823 458114 467889 476054 477074 478442 478833 481150 485233 485502 491608 491614 497697 500725 511240 512453 517416 518470 523576 527921 530624 530759 534546 536242 537467 537654 537904 541073 541654 541674 541867 542512 542705 544493 544823 545190 545411 545455 548723 549041 551063 552064 552398 552800 555109 556795 558819 562377 565263 568267 569533 573932 574386 575154 576646 580122 580189 583468 585960 586423 597226 598115 599958 600171 600215 600334 606299 606546 609920 612070 617969 619552 620901 630582 633747 633798 634509 649140 652199 654086 654898 660364 660380 675815 680172 683291 694554 722522 730692 735524 740335 742286 742459 745129 762257 785606 799762 806789 809308 811850 817510 818377 819613 ] |
||||||||||||||||||||||||||||||
|
15.85 ms (8.68%) |
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 416539 430374 447305 417491 512453 500725 89346 818377 819613 485233 491608 478442 534546 537467 527921 536242 545411 580189 568267 573932 552064 649140 652199 654086 660380 683291 660364 680172 694554 675815 722522 548723 555109 617969 598115 597226 609920 620901 630582 730692 742286 785606 799762 745129 762257 742459 735524 612070 806789 811850 387680 443242 511240 541674 447668 517416 541073 542512 599958 606299 619552 634509 809308 537654 337704 421520 432771 530759 544823 544493 574386 600215 600334 518470 443323 448823 586423 633798 817510 458114 481150 478833 497697 537904 491614 545455 558819 583468 541867 545190 575154 541654 542705 552398 565263 576646 654898 549041 551063 552800 556795 562377 580122 606546 740335 416708 476054 467889 477074 485502 530624 569533 633747 585960 523576 600171 415957 443247 434067 416583 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.60%) |
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 89346 337704 387680 415957 416539 416583 416708 417491 421520 430374 432771 434067 443242 443247 443323 447305 447668 448823 458114 467889 476054 477074 478442 478833 481150 485233 485502 491608 491614 497697 500725 511240 512453 517416 518470 523576 527921 530624 530759 534546 536242 537467 537654 537904 541073 541654 541674 541867 542512 542705 544493 544823 545190 545411 545455 548723 549041 551063 552064 552398 552800 555109 556795 558819 562377 565263 568267 569533 573932 574386 575154 576646 580122 580189 583468 585960 586423 597226 598115 599958 600171 600215 600334 606299 606546 609920 612070 617969 619552 620901 630582 633747 633798 634509 649140 652199 654086 654898 660364 660380 675815 680172 683291 694554 722522 730692 735524 740335 742286 742459 745129 762257 785606 799762 806789 809308 811850 817510 818377 819613 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny anal gape"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.45 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые анал большая большие дырк"
]
|
||||||||||||||||||||||||||||||
|
1.35 ms (0.74%) |
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.