Query Metrics
7
Database Queries
7
Different statements
183.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.29 ms (85.82%) |
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 161581 382104 385166 385603 385682 386996 392077 395235 398804 399351 399853 405612 408458 408841 414618 417064 418049 418430 420760 423554 424071 426349 429279 431611 434223 437877 442691 442999 443725 445524 452500 457748 462033 464177 465103 466695 472229 472337 472599 475091 480760 482793 483954 484088 487820 489042 489370 505021 505648 505884 508438 510508 511648 512302 514606 516055 516108 517292 524514 527552 534355 550408 553082 555869 559721 560653 561679 561707 566029 571898 572137 572171 573004 573051 573875 573881 573901 574608 588262 591788 606227 607232 611817 634423 642143 658080 668607 675024 682623 683593 683804 701047 713364 714405 716593 720676 736614 736845 738270 744600 756461 758851 758970 779254 780124 784203 784226 792679 792747 796513 816305 818586 819114 819766 820606 821526 822818 827163 827576 828417 ] |
||||||||||||||||||||||||||||||
|
16.28 ms (8.88%) |
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 429279 472337 405612 443725 464177 472229 505884 510508 516055 489370 487820 489042 505021 505648 517292 524514 483954 484088 516108 560653 559721 573875 573901 574608 683593 161581 392077 642143 611817 796513 756461 758851 738270 634423 792679 423554 417064 442691 465103 414618 452500 508438 821526 822818 827163 827576 607232 466695 511648 588262 457748 514606 779254 386996 434223 571898 550408 553082 561679 561707 555869 566029 385603 385682 382104 820606 818586 819114 816305 819766 828417 527552 472599 658080 675024 758970 736845 385166 572171 573004 573881 668607 713364 572137 573051 606227 462033 591788 534355 683804 720676 682623 701047 716593 784226 792747 784203 744600 714405 780124 395235 418430 736614 398804 408841 424071 431611 512302 420760 399351 399853 418049 426349 437877 442999 408458 482793 475091 480760 445524 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.43%) |
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 161581 382104 385166 385603 385682 386996 392077 395235 398804 399351 399853 405612 408458 408841 414618 417064 418049 418430 420760 423554 424071 426349 429279 431611 434223 437877 442691 442999 443725 445524 452500 457748 462033 464177 465103 466695 472229 472337 472599 475091 480760 482793 483954 484088 487820 489042 489370 505021 505648 505884 508438 510508 511648 512302 514606 516055 516108 517292 524514 527552 534355 550408 553082 555869 559721 560653 561679 561707 566029 571898 572137 572171 573004 573051 573875 573881 573901 574608 588262 591788 606227 607232 611817 634423 642143 658080 668607 675024 682623 683593 683804 701047 713364 714405 716593 720676 736614 736845 738270 744600 756461 758851 758970 779254 780124 784203 784226 792679 792747 796513 816305 818586 819114 819766 820606 821526 822818 827163 827576 828417 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"блондинка маленькие Ñ%…"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая маленькая"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.