Query Metrics
7
Database Queries
7
Different statements
266.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
234.44 ms (87.83%) |
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 145163 280774 385398 401215 408880 413673 414595 420442 428375 443084 444922 445834 445964 446017 452351 452778 453649 454734 456106 456127 457605 457615 457666 459461 459466 460461 464364 465003 466999 470023 470225 471050 473072 477227 477646 480235 480721 484960 484962 485596 490475 493353 499930 507830 509113 511286 513374 517054 523229 524470 532545 542029 542772 549655 550165 551818 553541 556096 560740 564215 573929 576188 577458 579510 582032 590128 591037 591993 598746 599879 603314 604804 618945 620455 627442 628586 650666 651684 653192 659209 666428 670364 671070 687306 700462 705312 706889 710240 715567 744389 746122 747322 752500 756043 763738 765870 766433 777677 778445 781936 782449 783939 787774 790635 791911 791917 792749 795718 796826 799033 803635 803937 806321 808884 810482 811097 812742 813332 817271 819238 ] |
||||||||||||||||||||||||||||||
|
22.28 ms (8.35%) |
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 499930 523229 532545 511286 524470 460461 466999 480235 549655 556096 582032 579510 542029 542772 560740 573929 576188 577458 651684 659209 666428 670364 705312 706889 650666 671070 715567 653192 687306 710240 550165 551818 553541 564215 591037 620455 598746 599879 604804 628586 590128 591993 603314 627442 778445 787774 790635 803937 791911 810482 812742 744389 746122 766433 783939 791917 796826 803635 808884 811097 752500 756043 765870 747322 763738 618945 700462 777677 781936 782449 792749 795718 799033 806321 813332 428375 445834 459466 471050 480721 470023 420442 477227 456106 459461 477646 509113 484960 485596 517054 493353 507830 484962 513374 385398 145163 280774 401215 413673 408880 414595 443084 444922 819238 817271 453649 473072 445964 446017 456127 457666 465003 470225 452351 452778 454734 457605 457615 464364 490475 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.14%) |
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 145163 280774 385398 401215 408880 413673 414595 420442 428375 443084 444922 445834 445964 446017 452351 452778 453649 454734 456106 456127 457605 457615 457666 459461 459466 460461 464364 465003 466999 470023 470225 471050 473072 477227 477646 480235 480721 484960 484962 485596 490475 493353 499930 507830 509113 511286 513374 517054 523229 524470 532545 542029 542772 549655 550165 551818 553541 556096 560740 564215 573929 576188 577458 579510 582032 590128 591037 591993 598746 599879 603314 604804 618945 620455 627442 628586 650666 651684 653192 659209 666428 670364 671070 687306 700462 705312 706889 710240 715567 744389 746122 747322 752500 756043 763738 765870 766433 777677 778445 781936 782449 783939 787774 790635 791911 791917 792749 795718 796826 799033 803635 803937 806321 808884 810482 811097 812742 813332 817271 819238 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"горничн соло"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.66%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"maids solo"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"горничн соло"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.59%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.