Query Metrics
7
Database Queries
7
Different statements
194.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.58 ms (89.42%) |
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 117073 159291 381885 384338 386813 386845 388481 391561 401088 401218 401582 402239 404633 413249 441490 447966 457451 459500 462192 462285 465315 468109 469852 474588 476601 478472 480038 485995 509648 521294 541303 545185 554252 565951 574780 580631 583510 587543 590812 591367 592182 593594 599939 604171 612905 617599 621951 650167 652906 655241 661967 661973 662171 663247 668099 674866 675859 677053 680143 684669 692380 699400 702630 707461 711328 712582 713301 715877 717256 717913 718127 722474 723266 728780 730744 732903 734472 734967 740248 740935 743578 750143 751424 752987 756089 760913 761605 762273 764817 764820 764879 765095 765441 765647 769771 769811 769841 769880 773734 775208 776026 777021 778115 781341 785579 787563 788170 788912 791092 800536 801634 802032 804325 809808 812996 820182 826299 826674 827275 827324 ] |
||||||||||||||||||||||||||||||
|
11.47 ms (5.91%) |
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 457451 480038 474588 650167 712582 684669 722474 612905 778115 769841 781341 769811 769880 730744 761605 769771 384338 401582 159291 402239 462192 541303 388481 580631 826299 827275 827324 545185 621951 775208 787563 732903 762273 465315 592182 117073 468109 386845 404633 441490 478472 661973 675859 699400 713301 718127 652906 707461 723266 617599 599939 812996 734472 740935 765441 760913 765095 750143 765647 717913 809808 391561 663247 785579 554252 565951 591367 459500 401218 485995 583510 680143 593594 604171 587543 764820 764879 764817 734967 702630 521294 751424 677053 661967 711328 655241 662171 668099 674866 692380 590812 801634 791092 802032 740248 728780 743578 756089 715877 788170 401088 413249 800536 381885 820182 826674 717256 776026 788912 752987 773734 777021 804325 386813 574780 462285 476601 509648 469852 447966 ] |
||||||||||||||||||||||||||||||
|
2.47 ms (1.27%) |
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 117073 159291 381885 384338 386813 386845 388481 391561 401088 401218 401582 402239 404633 413249 441490 447966 457451 459500 462192 462285 465315 468109 469852 474588 476601 478472 480038 485995 509648 521294 541303 545185 554252 565951 574780 580631 583510 587543 590812 591367 592182 593594 599939 604171 612905 617599 621951 650167 652906 655241 661967 661973 662171 663247 668099 674866 675859 677053 680143 684669 692380 699400 702630 707461 711328 712582 713301 715877 717256 717913 718127 722474 723266 728780 730744 732903 734472 734967 740248 740935 743578 750143 751424 752987 756089 760913 761605 762273 764817 764820 764879 765095 765441 765647 769771 769811 769841 769880 773734 775208 776026 777021 778115 781341 785579 787563 788170 788912 791092 800536 801634 802032 804325 809808 812996 820182 826299 826674 827275 827324 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"анал молодой девушки"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.72%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал молодой девушк"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.72%) |
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.