Query Metrics
7
Database Queries
7
Different statements
657.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
417.08 ms (63.47%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature большие"
]
|
||||||||||||||||||||||||||||||
|
216.81 ms (33.00%) |
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 7365 187516 187636 187938 187956 188390 188456 233570 233889 236765 358603 384279 388200 388203 388329 388364 388570 388714 388719 388784 388968 389582 389639 389729 391077 392030 396941 397882 397884 398557 399075 406067 407763 409938 409942 410237 411350 411629 411907 413279 427981 439749 446786 453096 456516 466015 466748 468167 476343 482374 487315 503569 517013 519184 554322 563127 588077 588084 648199 663461 664290 664809 665095 665312 665890 667291 667701 668181 670233 675498 678775 680704 681137 702158 710579 712332 713635 714152 714156 718549 718559 720583 720591 721095 721706 723984 726556 726588 726902 727050 728443 728446 728451 731686 732356 733291 743811 746890 759929 770913 774144 780634 781970 799971 802463 808015 817308 817687 818593 818660 818739 823688 823857 824023 824094 824171 824604 824937 826655 827054 ] |
||||||||||||||||||||||||||||||
|
14.48 ms (2.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 456516 466748 519184 503569 446786 439749 681137 427981 670233 388203 409942 802463 389582 818593 827054 388329 188456 743811 823857 388200 823688 818739 409938 728451 388714 726902 388784 187956 817687 733291 726556 410237 563127 391077 188390 389639 236765 398557 780634 388968 817308 824171 663461 453096 397884 399075 411629 482374 664809 770913 824094 824937 554322 720591 774144 392030 388570 675498 824023 680704 710579 407763 588077 799971 728446 389729 384279 665890 702158 714156 726588 731686 728443 824604 714152 781970 721095 468167 388364 665312 388719 668181 7365 406067 413279 721706 588084 759929 233570 397882 476343 411350 466015 487315 517013 667701 648199 187938 664290 667291 665095 712332 713635 718549 723984 732356 727050 718559 187516 233889 678775 720583 187636 358603 396941 411907 818660 826655 808015 746890 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (0.46%) |
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 7365 187516 187636 187938 187956 188390 188456 233570 233889 236765 358603 384279 388200 388203 388329 388364 388570 388714 388719 388784 388968 389582 389639 389729 391077 392030 396941 397882 397884 398557 399075 406067 407763 409938 409942 410237 411350 411629 411907 413279 427981 439749 446786 453096 456516 466015 466748 468167 476343 482374 487315 503569 517013 519184 554322 563127 588077 588084 648199 663461 664290 664809 665095 665312 665890 667291 667701 668181 670233 675498 678775 680704 681137 702158 710579 712332 713635 714152 714156 718549 718559 720583 720591 721095 721706 723984 726556 726588 726902 727050 728443 728446 728451 731686 732356 733291 743811 746890 759929 770913 774144 780634 781970 799971 802463 808015 817308 817687 818593 818660 818739 823688 823857 824023 824094 824171 824604 824937 826655 827054 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature big"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature большие"
]
|
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.