Query Metrics
7
Database Queries
7
Different statements
151.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.54 ms (80.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 4311 233335 391572 417293 420003 420577 423957 425541 446492 451701 453767 457018 458360 458642 466398 469620 476297 476487 476758 483218 493777 526303 533706 536062 542701 545770 545906 546059 546360 546629 547786 548387 555001 555005 559396 560981 564688 565080 565657 567240 568591 571432 572361 572690 573279 574408 574609 578005 578169 581514 585735 588695 593774 601606 608814 620259 623745 624599 631341 641128 649329 663842 666464 670272 673420 678698 683305 685381 685422 685509 685524 690746 695788 701888 714865 729205 731652 733661 734140 736847 737095 742405 745963 747429 754657 758182 760428 761607 762193 763876 764173 765112 766011 768042 768453 768491 768643 769133 769141 769409 779255 779637 782184 784319 788072 790307 792307 794073 795803 804924 809551 819945 823647 824084 825719 827564 827937 828151 828563 ] |
||||||||||||||||||||||||||||||
|
20.48 ms (13.53%) |
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 545906 578005 663842 649329 673919 683305 685381 685422 685524 695788 701888 567240 588695 601606 608814 623745 809551 779255 731652 737095 784319 788072 794073 762193 766011 768453 729205 733661 768042 736847 768491 747429 758182 761607 764173 714865 782184 233335 420577 417293 533706 742405 458360 391572 819945 823647 825719 827937 457018 571432 4311 827564 824084 828151 828563 565080 631341 790307 795803 804924 792307 768643 769141 769133 754657 745963 446492 458642 483218 476297 493777 526303 536062 545770 546360 546629 565657 574408 546059 578169 542701 548387 555001 560981 572361 572690 673420 678698 685509 690746 666464 670272 547786 555005 559396 564688 568591 573279 574609 581514 585735 593774 620259 624599 641128 779637 734140 760428 769409 765112 763876 420003 423957 451701 466398 476487 425541 453767 469620 476758 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.59%) |
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 4311 233335 391572 417293 420003 420577 423957 425541 446492 451701 453767 457018 458360 458642 466398 469620 476297 476487 476758 483218 493777 526303 533706 536062 542701 545770 545906 546059 546360 546629 547786 548387 555001 555005 559396 560981 564688 565080 565657 567240 568591 571432 572361 572690 573279 574408 574609 578005 578169 581514 585735 588695 593774 601606 608814 620259 623745 624599 631341 641128 649329 663842 666464 670272 673420 678698 683305 685381 685422 685509 685524 690746 695788 701888 714865 729205 731652 733661 734140 736847 737095 742405 745963 747429 754657 758182 760428 761607 762193 763876 764173 765112 766011 768042 768453 768491 768643 769133 769141 769409 779255 779637 782184 784319 788072 790307 792307 794073 795803 804924 809551 819945 823647 824084 825719 827564 827937 828151 828563 ] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"крупно русское"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"крупныйпла русск"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"крупныйпла русск"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.86%) |
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.