Query Metrics
7
Database Queries
7
Different statements
199.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
174.60 ms (87.38%) |
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 13570 50562 97462 154576 182192 182735 202846 202970 298529 373277 381818 381996 384258 384453 385930 386442 387132 387738 389819 390027 390671 390899 392843 392923 396026 398078 399525 401374 415757 422101 448914 452348 467603 468244 468251 468818 469147 471086 471686 475332 484234 484337 498648 519361 530080 534007 536487 537781 540459 541086 570892 582013 585385 589554 592227 593400 594552 596044 602111 602335 603136 614297 626554 628750 628755 634876 639124 640046 641137 641189 641339 643257 643690 648787 650649 664191 668594 669589 669689 673254 675350 706373 709340 709855 710495 711749 720514 734828 736037 738494 742312 747507 753762 757257 758541 759073 760411 774646 774842 776829 777757 778377 784641 786342 788778 790444 790912 796695 801776 802145 802373 804428 806944 806966 807129 808159 808607 811727 811878 813646 ] |
||||||||||||||||||||||||||||||
|
14.79 ms (7.40%) |
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 540459 626554 534007 50562 811878 808159 802373 668594 801776 806966 385930 536487 641189 709855 808607 392923 97462 806944 634876 202970 720514 802145 804428 807129 386442 706373 592227 788778 760411 537781 570892 390027 593400 742312 399525 710495 381818 390899 381996 398078 648787 628755 641137 643257 602335 759073 384258 182192 387132 641339 734828 774842 154576 390671 469147 471086 484234 541086 603136 784641 747507 709340 711749 738494 384453 596044 387738 202846 650649 639124 777757 298529 673254 675350 643690 753762 614297 582013 519361 389819 468251 602111 776829 401374 498648 373277 415757 530080 669689 664191 594552 628750 786342 736037 757257 640046 182735 467603 475332 774646 471686 422101 448914 468818 484337 669589 585385 589554 796695 790912 811727 790444 468244 758541 778377 392843 13570 396026 813646 452348 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.30%) |
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 13570 50562 97462 154576 182192 182735 202846 202970 298529 373277 381818 381996 384258 384453 385930 386442 387132 387738 389819 390027 390671 390899 392843 392923 396026 398078 399525 401374 415757 422101 448914 452348 467603 468244 468251 468818 469147 471086 471686 475332 484234 484337 498648 519361 530080 534007 536487 537781 540459 541086 570892 582013 585385 589554 592227 593400 594552 596044 602111 602335 603136 614297 626554 628750 628755 634876 639124 640046 641137 641189 641339 643257 643690 648787 650649 664191 668594 669589 669689 673254 675350 706373 709340 709855 710495 711749 720514 734828 736037 738494 742312 747507 753762 757257 758541 759073 760411 774646 774842 776829 777757 778377 784641 786342 788778 790444 790912 796695 801776 802145 802373 804428 806944 806966 807129 808159 808607 811727 811878 813646 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo doggy"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло рак"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.85%) |
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.