Query Metrics
7
Database Queries
7
Different statements
198.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.21 ms (88.15%) |
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 76981 398679 428067 449115 459512 464366 466825 477097 487666 492340 523793 529851 540606 540858 543153 545075 546321 546562 546852 567559 576768 586616 619320 645754 648872 652672 688902 699316 703720 703737 703750 710141 720272 727984 728130 730079 730949 732608 734940 744576 744730 745197 746440 746986 747962 751476 753755 754984 755113 758023 759498 761341 762584 763802 766365 771914 771931 773601 777535 778314 778786 785996 789352 793164 795814 801563 811156 813687 816709 817437 817572 818735 818748 819281 819326 819391 819393 819785 819829 819988 820207 823656 823842 824053 824113 824144 824220 824529 824815 824948 824979 825006 825068 825080 825191 825460 825534 825615 825633 825705 825723 825792 825985 826003 826452 826478 826585 826586 827059 827142 827280 827562 828089 828438 828550 828555 828560 828787 ] |
||||||||||||||||||||||||||||||
|
13.42 ms (6.75%) |
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 793164 801563 811156 728130 730949 746440 754984 761341 762584 766365 773601 734940 744730 747962 727984 730079 732608 744576 745197 746986 753755 755113 758023 759498 763802 771914 751476 771931 619320 777535 778314 778786 785996 789352 795814 492340 449115 459512 487666 586616 464366 477097 523793 76981 398679 428067 817572 824220 824529 824815 825006 825080 825460 825633 825705 540858 826478 826586 819391 819988 820207 823656 823842 824948 825191 825192 825985 826151 826452 825723 826003 827059 827142 827280 827562 813687 816709 817437 818735 819281 819393 819785 819829 824053 824113 824979 825615 825792 818748 819326 825068 825534 826585 828089 828787 824144 828550 828555 828560 828438 540606 529851 466825 545075 546321 543153 546852 567559 546562 576768 652672 699316 703720 703737 703750 710141 720272 645754 648872 688902 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.45%) |
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 76981 398679 428067 449115 459512 464366 466825 477097 487666 492340 523793 529851 540606 540858 543153 545075 546321 546562 546852 567559 576768 586616 619320 645754 648872 652672 688902 699316 703720 703737 703750 710141 720272 727984 728130 730079 730949 732608 734940 744576 744730 745197 746440 746986 747962 751476 753755 754984 755113 758023 759498 761341 762584 763802 766365 771914 771931 773601 777535 778314 778786 785996 789352 793164 795814 801563 811156 813687 816709 817437 817572 818735 818748 819281 819326 819391 819393 819785 819829 819988 820207 823656 823842 824053 824113 824144 824220 824529 824815 824948 824979 825006 825068 825080 825191 825460 825534 825615 825633 825705 825723 825792 825985 826003 826452 826478 826585 826586 827059 827142 827280 827562 828089 828438 828550 828555 828560 828787 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum and"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.79%) |
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.