Query Metrics
7
Database Queries
7
Different statements
156.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.96 ms (80.47%) |
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 390818 416000 416181 418440 418853 419595 424410 424461 428113 428706 429708 430806 432878 433652 434201 437797 439150 443695 448375 448726 452950 453161 454055 454298 454531 456219 458780 462008 464131 464306 466986 467034 469432 470286 470560 474685 474810 474818 476344 477116 479668 479765 481435 483149 483375 484639 485715 491769 493411 494231 505394 508575 509231 513785 516659 520992 522153 522592 524257 535535 541575 543480 553045 562147 562843 563489 581098 581126 582443 597736 598344 599557 604489 604737 605102 608939 609896 614244 618619 620163 624224 629428 639301 647641 665975 668385 670761 671712 671739 677973 684029 685001 685687 692786 699606 699607 712053 718496 722392 722478 724147 727742 728345 748253 753023 756406 783977 789516 799093 801944 802723 803492 808166 808658 815559 815714 818426 818460 821036 824791 ] |
||||||||||||||||||||||||||||||
|
19.56 ms (12.49%) |
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 699607 670761 685687 699606 647641 712053 614244 727742 789516 728345 609896 783977 808658 418440 483375 469432 454298 464131 513785 524257 416000 453161 483149 563489 677973 464306 535535 553045 598344 722392 448375 479765 541575 458780 581098 467034 430806 418853 818426 477116 474810 485715 671739 668385 722478 582443 604489 803492 522592 597736 494231 390818 416181 437797 434201 454531 491769 466986 479668 665975 756406 802723 748253 424410 462008 443695 432878 476344 424461 505394 484639 428706 522153 474818 493411 470286 452950 474685 516659 509231 604737 629428 428113 815714 818460 815559 821036 456219 454055 508575 481435 671712 684029 692786 718496 618619 620163 639301 801944 808166 753023 799093 724147 520992 581126 543480 562147 562843 685001 608939 624224 599557 448726 419595 433652 439150 429708 824791 605102 470560 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.87%) |
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 390818 416000 416181 418440 418853 419595 424410 424461 428113 428706 429708 430806 432878 433652 434201 437797 439150 443695 448375 448726 452950 453161 454055 454298 454531 456219 458780 462008 464131 464306 466986 467034 469432 470286 470560 474685 474810 474818 476344 477116 479668 479765 481435 483149 483375 484639 485715 491769 493411 494231 505394 508575 509231 513785 516659 520992 522153 522592 524257 535535 541575 543480 553045 562147 562843 563489 581098 581126 582443 597736 598344 599557 604489 604737 605102 608939 609896 614244 618619 620163 624224 629428 639301 647641 665975 668385 670761 671712 671739 677973 684029 685001 685687 692786 699606 699607 712053 718496 722392 722478 724147 727742 728345 748253 753023 756406 783977 789516 799093 801944 802723 803492 808166 808658 815559 815714 818426 818460 821036 824791 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal saggy hairy"
]
|
||||||||||||||||||||||||||||||
|
2.17 ms (1.39%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал saggy волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал saggy волосатая"
]
|
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.