Query Metrics
7
Database Queries
7
Different statements
181.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.25 ms (85.52%) |
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 383509 383727 385880 388795 413700 418138 420140 420157 420219 423812 429860 429886 434070 434325 434339 436937 450259 450549 450852 452620 454140 457063 457594 457997 458002 465431 465725 468299 469324 472665 473400 475633 475635 476877 476884 478798 481927 488947 494598 495031 507237 511375 514450 517533 520180 522171 525727 529176 530428 533988 542707 552569 553751 555236 558316 558681 559430 569315 571360 577107 577433 578198 581597 586566 588411 588628 592516 592573 592988 593034 593412 593545 594579 596796 600959 604737 604918 604935 604988 607149 613791 615145 638396 649637 656200 666026 666046 666091 681220 698156 713332 714309 714443 716058 735128 736039 738297 739783 753931 755345 758256 776824 785824 796577 803824 804443 804444 806986 807406 807408 808967 813793 818686 823892 824634 824837 825514 825560 826701 ] |
||||||||||||||||||||||||||||||
|
16.60 ms (9.14%) |
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 553751 552569 714443 581597 604918 596796 803824 796577 755345 713332 423812 469324 522171 494598 450259 586566 592988 558316 559430 577433 473400 465431 472665 385880 826701 824634 825560 824837 823892 488947 450852 514450 507237 571360 577107 649637 666026 656200 698156 666046 666091 592516 594579 604737 604988 593545 638396 593412 588628 804444 806986 807406 776824 804443 807408 808967 735128 753931 738297 739783 736039 758256 607149 716058 785824 383727 475635 517533 434339 434070 478798 452620 476877 520180 429860 429886 434325 418138 495031 529176 578198 542707 569315 592573 600959 615145 457063 714309 714349 525727 588411 454140 511375 420157 420219 436937 420140 450549 458002 457997 476884 681220 613791 604935 593034 383509 388795 413700 813793 818686 825514 457594 475633 481927 530428 533988 465725 468299 555236 558681 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.49%) |
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 383509 383727 385880 388795 413700 418138 420140 420157 420219 423812 429860 429886 434070 434325 434339 436937 450259 450549 450852 452620 454140 457063 457594 457997 458002 465431 465725 468299 469324 472665 473400 475633 475635 476877 476884 478798 481927 488947 494598 495031 507237 511375 514450 517533 520180 522171 525727 529176 530428 533988 542707 552569 553751 555236 558316 558681 559430 569315 571360 577107 577433 578198 581597 586566 588411 588628 592516 592573 592988 593034 593412 593545 594579 596796 600959 604737 604918 604935 604988 607149 613791 615145 638396 649637 656200 666026 666046 666091 681220 698156 713332 714309 714443 716058 735128 736039 738297 739783 753931 755345 758256 776824 785824 796577 803824 804443 804444 806986 807406 807408 808967 813793 818686 823892 824634 824837 825514 825560 826701 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf hairy solo"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf волосатая соло"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.70%) |
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.