Query Metrics
7
Database Queries
7
Different statements
157.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.09 ms (82.85%) |
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 3699 11177 17216 34201 61789 73218 105224 151132 152655 178567 185049 185332 191420 197982 230399 310742 381949 381999 382488 382554 384556 384594 385360 386545 387125 388390 389976 398098 398865 398911 398995 400531 400619 401250 401352 401451 403414 410026 410963 412605 413779 413870 416455 419616 420919 426365 430455 430943 453315 454410 460707 467143 468002 474953 476366 478356 482590 490931 511316 523146 524476 529804 544974 545292 561697 567383 567822 573463 596830 598628 598964 607444 618675 618678 618712 622138 663230 663427 664288 664472 667644 675404 690020 696497 697449 702615 708701 712884 727588 730757 731428 739780 743788 749583 752604 755989 756237 758332 773463 775835 777169 778745 788364 790312 790671 792195 804353 807393 808108 808446 809297 809411 810449 810578 814045 814363 815369 821521 822705 823521 ] |
||||||||||||||||||||||||||||||
|
16.64 ms (10.60%) |
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 381999 474953 386545 105224 185049 185332 191420 310742 382488 73218 61789 34201 3699 17216 389976 387125 398098 398995 430455 410963 420919 426365 410026 413779 814045 822705 814363 815369 453315 460707 482590 454410 523146 468002 561697 664472 675404 696497 708701 712884 663230 697449 598628 596830 618712 622138 598964 788364 809297 775835 777169 778745 792195 808446 809411 810449 810578 730757 756237 790671 731428 739780 743788 755989 773463 727588 758332 618675 790312 804353 808108 151132 152655 400619 403414 430943 197982 398865 401451 412605 382554 384594 416455 178567 230399 385360 400531 401250 401352 419616 476366 511316 398911 823521 821521 524476 529804 544974 702615 618678 752604 807393 749583 607444 381949 384556 11177 388390 413870 478356 490931 467143 545292 567383 567822 573463 663427 667644 690020 664288 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (2.05%) |
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 3699 11177 17216 34201 61789 73218 105224 151132 152655 178567 185049 185332 191420 197982 230399 310742 381949 381999 382488 382554 384556 384594 385360 386545 387125 388390 389976 398098 398865 398911 398995 400531 400619 401250 401352 401451 403414 410026 410963 412605 413779 413870 416455 419616 420919 426365 430455 430943 453315 454410 460707 467143 468002 474953 476366 478356 482590 490931 511316 523146 524476 529804 544974 545292 561697 567383 567822 573463 596830 598628 598964 607444 618675 618678 618712 622138 663230 663427 664288 664472 667644 675404 690020 696497 697449 702615 708701 712884 727588 730757 731428 739780 743788 749583 752604 755989 756237 758332 773463 775835 777169 778745 788364 790312 790671 792195 804353 807393 808108 808446 809297 809411 810449 810578 814045 814363 815369 821521 822705 823521 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette boobs"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая boobs"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая boobs"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.01%) |
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.