Query Metrics
7
Database Queries
7
Different statements
218.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
195.24 ms (89.52%) |
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 385004 394229 394238 403765 417307 420067 465165 471600 514117 514684 520725 520731 524658 528303 531648 534911 536951 538899 541176 546561 549389 557862 558271 558971 577286 586894 592267 596253 606316 615931 618537 624816 627114 627581 634914 640631 641049 641391 642166 645881 645943 647481 650646 653527 655288 666101 674795 680581 692824 695358 695392 695578 701216 702382 705335 706566 707239 713414 717445 717611 718058 724300 732820 735817 736088 741086 743180 748331 748495 749460 750037 751359 751383 753667 754236 755035 755913 764918 767534 768930 770015 776970 776999 777205 787749 788088 788623 788624 789030 791539 792279 792838 795573 795588 798281 799749 803249 810019 810631 811553 815494 816134 818030 818031 818070 818921 819276 819810 820115 820658 820757 821801 824103 824255 827266 828335 828796 ] |
||||||||||||||||||||||||||||||
|
11.31 ms (5.19%) |
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 471600 394238 420067 820658 528303 394229 520725 520731 828796 701216 645943 810019 514684 821801 538899 403765 824629 641391 735817 750037 536951 753667 627581 810631 417307 818030 824686 828335 534911 558971 645881 674795 748331 762823 718058 385004 818070 531648 546561 695392 618537 788624 792279 811553 788088 748495 764918 732820 751359 768930 634914 713414 798281 820757 824255 465165 541176 558271 549389 557862 577286 655288 695358 666101 624816 777205 791539 803249 792838 741086 754236 755913 799749 770015 751383 606316 706566 776970 776999 795573 816134 818031 818921 824103 827266 514117 680581 695578 653527 717445 586894 596253 615931 642166 592267 627114 787749 789030 795588 743180 767534 736088 749460 724300 755035 640631 641049 707239 788623 819276 820115 819810 815494 524658 647481 692824 702382 705335 717611 650646 ] |
||||||||||||||||||||||||||||||
|
4.97 ms (2.28%) |
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 385004 394229 394238 403765 417307 420067 465165 471600 514117 514684 520725 520731 524658 528303 531648 534911 536951 538899 541176 546561 549389 557862 558271 558971 577286 586894 592267 596253 606316 615931 618537 624816 627114 627581 634914 640631 641049 641391 642166 645881 645943 647481 650646 653527 655288 666101 674795 680581 692824 695358 695392 695578 701216 702382 705335 706566 707239 713414 717445 717611 718058 724300 732820 735817 736088 741086 743180 748331 748495 749460 750037 751359 751383 753667 754236 755035 755913 764918 767534 768930 770015 776970 776999 777205 787749 788088 788623 788624 789030 791539 792279 792838 795573 795588 798281 799749 803249 810019 810631 811553 815494 816134 818030 818031 818070 818921 819276 819810 820115 820658 820757 821801 824103 824255 827266 828335 828796 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"door-to-door"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"door door"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.76%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"door door"
]
|
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.