Query Metrics
7
Database Queries
7
Different statements
177.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.13 ms (87.51%) |
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 56349 133707 145988 387198 390133 398599 418160 420823 424262 424562 435548 446419 446954 449258 449290 451048 468616 492537 496252 496377 522757 527477 536062 536140 553240 553342 556745 576167 576173 580963 584517 604444 613899 614789 617568 618930 618934 619854 620027 627491 639181 651690 652757 660649 664723 669286 677918 678989 684839 687620 695857 703255 704079 713325 714181 725651 726557 727561 730446 735756 736070 736738 739316 742981 743610 744153 744214 747569 748266 748272 748282 748511 750293 758878 758966 759720 760511 765897 766432 767350 769600 783183 783671 784958 785164 785221 786856 787697 788024 790478 791130 792197 793792 794991 796381 796844 797413 800054 800131 800712 800728 803554 803821 804116 806675 806803 808125 808601 813341 814394 820172 824621 824651 824845 824854 825027 825439 826404 826455 828722 ] |
||||||||||||||||||||||||||||||
|
12.77 ms (7.20%) |
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 765897 767350 769600 617568 792197 796844 803821 804116 806803 424262 787697 788024 736070 468616 496252 536062 553240 424562 435548 398599 449290 492537 527477 56349 820172 824651 826404 824854 828722 744214 814394 451048 664723 604444 133707 806675 766432 790478 743610 420823 553342 580963 684839 695857 556745 618930 785164 813341 785221 783183 808125 748511 758878 739316 618934 703255 713325 796381 803554 145988 387198 390133 418160 824845 824621 825439 825027 826455 446954 446419 449258 536140 496377 522757 584517 652757 660649 704079 651690 669286 677918 687620 714181 678989 576167 576173 613899 619854 614789 620027 627491 639181 793792 794991 800054 800712 808601 783671 784958 791130 797413 800131 800728 735756 747569 760511 786856 727561 736738 748266 759720 726557 730446 750293 758966 725651 742981 748282 744153 748272 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.42%) |
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 56349 133707 145988 387198 390133 398599 418160 420823 424262 424562 435548 446419 446954 449258 449290 451048 468616 492537 496252 496377 522757 527477 536062 536140 553240 553342 556745 576167 576173 580963 584517 604444 613899 614789 617568 618930 618934 619854 620027 627491 639181 651690 652757 660649 664723 669286 677918 678989 684839 687620 695857 703255 704079 713325 714181 725651 726557 727561 730446 735756 736070 736738 739316 742981 743610 744153 744214 747569 748266 748272 748282 748511 750293 758878 758966 759720 760511 765897 766432 767350 769600 783183 783671 784958 785164 785221 786856 787697 788024 790478 791130 792197 793792 794991 796381 796844 797413 800054 800131 800712 800728 803554 803821 804116 806675 806803 808125 808601 813341 814394 820172 824621 824651 824845 824854 825027 825439 826404 826455 828722 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation pussy"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац pussy"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мастурбац pussy"
]
|
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.