Query Metrics
7
Database Queries
7
Different statements
173.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.36 ms (86.10%) |
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 384871 390105 418663 441284 462584 479864 480019 490095 492465 493342 498378 507191 510542 513642 514219 514224 514420 517500 535294 542061 548395 549603 550592 553319 555714 558143 562461 575844 586309 587491 591945 597111 599515 600887 603968 614631 614842 619336 627281 627838 631339 636156 638674 642273 656186 672822 688914 688922 703586 706004 709534 710807 712627 717486 724769 727541 728672 728706 733927 735807 740375 742342 751316 751322 751349 752838 754903 758256 758386 758903 766376 768258 769161 769386 771591 772965 772976 773294 774826 779615 780350 783316 784094 784743 784796 784969 785462 785574 787064 787281 787502 788140 789609 791429 791885 793062 793173 793884 796047 797180 797182 797315 799124 802243 803504 804668 806692 806812 807295 809948 809966 810208 810800 811668 812027 812691 813811 819730 823889 824532 ] |
||||||||||||||||||||||||||||||
|
13.57 ms (7.82%) |
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 631339 587491 603968 586309 627838 599515 638674 788140 789609 793173 802243 810208 812691 796047 740375 752838 758386 784094 809948 766376 772965 772976 742342 758903 751322 768258 727541 728672 751316 758256 710807 779615 785574 793062 809966 810800 498378 514219 384871 390105 441284 813811 819730 550592 549603 548395 553319 575844 688922 703586 712627 709534 717486 591945 600887 636156 642273 787502 797182 784969 793884 797315 804668 733927 784743 735807 754903 769161 751349 769386 773294 614842 619336 785462 791429 799124 803504 493342 517500 513642 418663 823889 824532 492465 480019 462584 479864 535294 507191 510542 490095 555714 542061 558143 562461 656186 672822 688914 706004 614631 597111 783316 797180 807295 812027 774826 780350 784796 791885 806692 806812 787064 787281 811668 724769 728706 771591 627281 514224 514420 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (1.70%) |
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 384871 390105 418663 441284 462584 479864 480019 490095 492465 493342 498378 507191 510542 513642 514219 514224 514420 517500 535294 542061 548395 549603 550592 553319 555714 558143 562461 575844 586309 587491 591945 597111 599515 600887 603968 614631 614842 619336 627281 627838 631339 636156 638674 642273 656186 672822 688914 688922 703586 706004 709534 710807 712627 717486 724769 727541 728672 728706 733927 735807 740375 742342 751316 751322 751349 752838 754903 758256 758386 758903 766376 768258 769161 769386 771591 772965 772976 773294 774826 779615 780350 783316 784094 784743 784796 784969 785462 785574 787064 787281 787502 788140 789609 791429 791885 793062 793173 793884 796047 797180 797182 797315 799124 802243 803504 804668 806692 806812 807295 809948 809966 810208 810800 811668 812027 812691 813811 819730 823889 824532 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"myself"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"myself"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"myself"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.