Query Metrics
7
Database Queries
7
Different statements
159.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.67 ms (78.60%) |
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 558013 563137 577735 577997 585261 587725 588313 590264 594912 596896 599229 601952 602942 603587 603836 606725 606775 609263 609942 613465 614193 614585 614614 615147 615712 618916 620901 624420 625380 631740 631778 631975 631976 631980 632440 635633 637701 639934 642697 698550 711297 721369 725369 725390 726744 727818 728874 728961 729421 730444 731803 733554 738758 743380 744665 745257 746158 746201 748138 748151 748999 749889 751094 753150 753465 754948 759567 760064 761086 761866 764806 765156 769819 770141 771874 772632 772959 773609 775733 776426 776468 776845 776971 778243 778471 779039 781999 782194 783486 784117 784837 786255 788879 789854 790356 790493 791355 792661 795497 796545 799456 800568 802580 802657 802750 802782 803091 803398 804380 804455 804748 807303 807902 812510 812575 812599 812604 812779 813039 813061 ] |
||||||||||||||||||||||||||||||
|
22.97 ms (14.37%) |
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 558013 563137 577735 577997 587725 588313 590264 596896 603836 606775 614614 625380 631976 635633 599229 601952 602942 603587 606725 613465 618916 624420 631740 631975 631980 639934 585261 594912 620901 637701 609263 609942 631778 776426 776468 778243 778471 783486 784117 786255 788879 790356 791355 795497 800568 802782 803398 807303 812604 813061 775733 776845 782194 784837 789854 790493 796545 799456 802750 803091 804380 804748 813039 725369 727818 729421 748999 753150 759567 761086 792661 802580 802657 804455 807902 812510 812575 812599 812779 725390 743380 745257 748138 748151 753465 754948 761866 764806 765156 730444 746201 760064 769819 773609 726744 728874 728961 731803 770141 771874 772632 772959 733554 738758 744665 746158 749889 751094 614193 614585 615147 615712 632440 642697 698550 711297 721369 776971 779039 781999 ] |
||||||||||||||||||||||||||||||
|
3.77 ms (2.36%) |
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 558013 563137 577735 577997 585261 587725 588313 590264 594912 596896 599229 601952 602942 603587 603836 606725 606775 609263 609942 613465 614193 614585 614614 615147 615712 618916 620901 624420 625380 631740 631778 631975 631976 631980 632440 635633 637701 639934 642697 698550 711297 721369 725369 725390 726744 727818 728874 728961 729421 730444 731803 733554 738758 743380 744665 745257 746158 746201 748138 748151 748999 749889 751094 753150 753465 754948 759567 760064 761086 761866 764806 765156 769819 770141 771874 772632 772959 773609 775733 776426 776468 776845 776971 778243 778471 779039 781999 782194 783486 784117 784837 786255 788879 789854 790356 790493 791355 792661 795497 796545 799456 800568 802580 802657 802750 802782 803091 803398 804380 804455 804748 807303 807902 812510 812575 812599 812604 812779 813039 813061 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"red pussy"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"red pussy"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"red pussy"
]
|
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.