Query Metrics
7
Database Queries
7
Different statements
164.44 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.38 ms (83.54%) |
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 58408 153490 305464 396470 398387 400571 401754 404766 415711 416901 420078 421801 423101 426837 427493 435610 448092 449246 449306 450219 455493 456777 458256 460573 461631 466333 467738 469706 470188 470406 470548 470888 472262 478841 480935 481360 483256 483336 493962 494412 496196 498875 498979 503663 507740 513734 513862 518781 519678 519997 522522 536143 539243 540729 544953 550718 552752 560341 560927 562735 564727 568062 569623 572887 573380 573922 575630 578159 585780 588092 589105 592735 599111 599261 607497 609496 614820 614835 618365 620045 626002 627359 628589 629592 636566 636943 656582 663162 667147 669258 672272 679659 688680 689191 696772 704280 706631 708292 711225 719794 720549 734778 735026 757635 761680 772352 773058 776552 778784 780374 782543 785912 787857 791886 792196 798177 803599 809354 813522 825481 ] |
||||||||||||||||||||||||||||||
|
15.91 ms (9.67%) |
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 656582 711225 720549 672272 607497 627359 636943 734778 773058 735026 757635 772352 791886 813522 58408 493962 404766 540729 572887 564727 573922 620045 787857 809354 423101 396470 427493 448092 519997 498979 498875 305464 449246 550718 398387 416901 455493 470406 513862 522522 536143 460573 472262 544953 667147 575630 585780 614820 614835 599111 792196 778784 780374 798177 782543 761680 629592 704280 401754 421801 435610 456777 469706 503663 494412 470888 458256 470188 569623 578159 679659 688680 560927 626002 592735 776552 803599 785912 449306 153490 420078 478841 426837 496196 573380 470548 562735 618365 589105 519678 568062 461631 588092 415711 467738 483256 513734 481360 518781 450219 507740 480935 400571 825481 483336 539243 466333 552752 560341 669258 689191 696772 706631 708292 663162 719794 609496 628589 636566 599261 ] |
||||||||||||||||||||||||||||||
|
3.17 ms (1.93%) |
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 58408 153490 305464 396470 398387 400571 401754 404766 415711 416901 420078 421801 423101 426837 427493 435610 448092 449246 449306 450219 455493 456777 458256 460573 461631 466333 467738 469706 470188 470406 470548 470888 472262 478841 480935 481360 483256 483336 493962 494412 496196 498875 498979 503663 507740 513734 513862 518781 519678 519997 522522 536143 539243 540729 544953 550718 552752 560341 560927 562735 564727 568062 569623 572887 573380 573922 575630 578159 585780 588092 589105 592735 599111 599261 607497 609496 614820 614835 618365 620045 626002 627359 628589 629592 636566 636943 656582 663162 667147 669258 672272 679659 688680 689191 696772 704280 706631 708292 711225 719794 720549 734778 735026 757635 761680 772352 773058 776552 778784 780374 782543 785912 787857 791886 792196 798177 803599 809354 813522 825481 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"выебал жену красавицу"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.25%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс жен красивая"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.07%) |
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.