Query Metrics
7
Database Queries
7
Different statements
206.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.41 ms (85.14%) |
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 14477 395890 396969 398459 398462 398534 398555 398749 400645 411012 411237 411621 411629 411767 411924 411956 412992 422406 425355 445665 445668 449084 450133 453121 456831 459828 461835 462074 464957 465555 465640 466925 469435 472655 474125 479028 481295 485813 487093 487354 493118 505971 506819 515697 519152 521448 521464 522760 526729 537828 540119 543940 546133 548067 548393 548525 549206 554510 554512 559344 567425 574448 577192 577267 589577 589579 589702 599794 610144 618392 624792 628637 629813 630049 643330 663383 667484 670488 670498 681312 698261 701182 709544 714204 720571 725348 736422 741787 742536 744206 744369 744996 746049 748656 758293 770117 770144 770211 770248 773901 776145 776148 780554 780670 781760 781976 784311 785106 785136 793536 794687 794734 795221 800699 800702 802442 804127 808001 808271 809753 ] |
||||||||||||||||||||||||||||||
|
18.05 ms (8.76%) |
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 746049 630049 720571 776145 780554 793536 804127 808001 400645 395890 521464 548067 474125 411237 445668 459828 472655 464957 526729 567425 453121 462074 411767 481295 522760 487093 521448 398462 398749 412992 422406 449084 456831 466925 493118 505971 506819 540119 519152 548525 554510 574448 554512 701182 670488 681312 670498 698261 709544 549206 577267 589702 618392 628637 629813 610144 736422 770248 773901 781976 794734 795221 808271 770117 744369 748656 741787 744206 624792 781760 785136 809753 398534 396969 411924 398459 465555 479028 485813 411956 14477 398555 411621 411012 411629 425355 445665 487354 450133 469435 515697 537828 461835 465640 546133 559344 543940 548393 577192 663383 667484 714204 599794 589577 643330 589579 776148 780670 794687 800699 800702 802442 725348 770211 742536 770144 744996 758293 784311 785106 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.40%) |
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 14477 395890 396969 398459 398462 398534 398555 398749 400645 411012 411237 411621 411629 411767 411924 411956 412992 422406 425355 445665 445668 449084 450133 453121 456831 459828 461835 462074 464957 465555 465640 466925 469435 472655 474125 479028 481295 485813 487093 487354 493118 505971 506819 515697 519152 521448 521464 522760 526729 537828 540119 543940 546133 548067 548393 548525 549206 554510 554512 559344 567425 574448 577192 577267 589577 589579 589702 599794 610144 618392 624792 628637 629813 630049 643330 663383 667484 670488 670498 681312 698261 701182 709544 714204 720571 725348 736422 741787 742536 744206 744369 744996 746049 748656 758293 770117 770144 770211 770248 773901 776145 776148 780554 780670 781760 781976 784311 785106 785136 793536 794687 794734 795221 800699 800702 802442 804127 808001 808271 809753 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"с бабушками"
]
|
||||||||||||||||||||||||||||||
|
2.24 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"бабушк"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (1.03%) |
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.