Query Metrics
7
Database Queries
7
Different statements
194.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.77 ms (87.82%) |
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 4463 7065 61762 124361 145335 187723 188009 188335 188373 233667 236765 311235 323041 358365 361315 382746 383169 386044 388739 388968 389582 391652 392600 392673 394190 394218 395899 396941 397871 397885 398514 398557 398935 398956 404441 408207 409380 409938 411249 411347 411762 411907 413972 443690 465524 465525 466310 466982 472235 477985 480757 487339 490409 520142 525528 584073 598988 620256 663395 665890 688078 702158 710587 712987 714153 714156 714165 716077 718836 722676 726572 726588 726955 726962 727513 731686 733315 735863 737083 739955 740792 741653 741896 743800 743811 744475 748252 752523 759596 759808 774200 777250 779197 780634 781678 781688 781706 781731 781742 782158 782183 807600 808500 808506 810286 816766 816769 816791 818660 818665 818720 818770 818814 823586 823637 823909 823910 824588 825037 828373 ] |
||||||||||||||||||||||||||||||
|
14.54 ms (7.48%) |
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 411249 188373 386044 392673 358365 394190 443690 233667 397885 404441 236765 124361 188009 388739 398557 409938 780634 740792 741896 739955 743811 774200 4463 388968 389582 398935 391652 411347 752523 810286 748252 825037 823910 688078 663395 714165 722676 737083 726962 759596 743800 323041 413972 466982 487339 520142 465524 465525 472235 584073 718836 466310 480757 490409 382746 383169 396941 408207 411907 409380 818660 818814 824588 665890 710587 712987 702158 714156 716077 598988 620256 779197 781706 781731 781742 782158 782183 777250 807600 744475 781678 781688 726588 731686 735863 726572 726955 727513 741653 759808 733315 714153 808500 808506 187723 188335 311235 397871 398956 411762 477985 392600 361315 145335 394218 395899 61762 7065 398514 816766 818665 816769 816791 823637 818720 818770 823586 823909 828373 525528 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.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 4463 7065 61762 124361 145335 187723 188009 188335 188373 233667 236765 311235 323041 358365 361315 382746 383169 386044 388739 388968 389582 391652 392600 392673 394190 394218 395899 396941 397871 397885 398514 398557 398935 398956 404441 408207 409380 409938 411249 411347 411762 411907 413972 443690 465524 465525 466310 466982 472235 477985 480757 487339 490409 520142 525528 584073 598988 620256 663395 665890 688078 702158 710587 712987 714153 714156 714165 716077 718836 722676 726572 726588 726955 726962 727513 731686 733315 735863 737083 739955 740792 741653 741896 743800 743811 744475 748252 752523 759596 759808 774200 777250 779197 780634 781678 781688 781706 781731 781742 782158 782183 807600 808500 808506 810286 816766 816769 816791 818660 818665 818720 818770 818814 823586 823637 823909 823910 824588 825037 828373 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature and young"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature young"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.80%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature young"
]
|
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.