Query Metrics
7
Database Queries
7
Different statements
135.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.87 ms (86.34%) |
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 130641 209941 384906 392075 506283 515311 521659 531928 532081 534799 534892 535680 539528 547021 549417 554310 564677 570821 573195 585761 594576 596542 596558 597905 613715 618184 621290 623123 625577 630880 636866 637858 641331 641549 643801 654701 655099 655201 655352 656055 657052 657063 657652 658736 666308 668417 677975 678243 683426 689048 693350 693700 694347 696293 697695 698803 699121 700635 706857 707515 707726 718123 719248 719283 719401 721568 731141 735334 738654 746113 753661 759671 764286 766090 771139 773462 773803 775407 777855 779147 781030 782716 784173 790121 791207 792647 793554 794626 796910 799576 800170 800259 801032 801945 803638 804810 810135 814560 817003 817016 817403 817631 818412 818676 818880 819792 821491 821805 822475 823158 823166 823379 825035 825082 825111 826131 827438 828361 828463 ] |
||||||||||||||||||||||||||||||
|
9.58 ms (7.08%) |
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 823379 821491 819792 822475 823166 825111 828361 506283 532081 539528 554310 547021 658736 697695 718123 719248 666308 678243 689048 698803 706857 625577 637858 621290 794626 779147 790121 793554 796910 799576 731141 766090 792647 801945 759671 738654 764286 771167 753661 771139 773462 735334 746113 773803 707515 719283 784173 800170 801032 810135 384906 209941 130641 392075 817403 817631 818412 818880 821805 817016 827438 814560 818676 817003 823158 825035 825082 826131 828463 515311 534892 535680 521659 531928 534799 570821 573195 549417 564677 654701 655201 668417 707726 719401 656055 657063 657652 683426 693350 694347 699121 655099 655352 657052 677975 693700 696293 700635 721568 585761 597905 613715 618184 623123 594576 630880 636866 596542 596558 641331 641549 643801 777855 775407 781030 782716 791207 800259 803638 804810 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"love xxx"
]
|
||||||||||||||||||||||||||||||
|
1.97 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 130641 209941 384906 392075 506283 515311 521659 531928 532081 534799 534892 535680 539528 547021 549417 554310 564677 570821 573195 585761 594576 596542 596558 597905 613715 618184 621290 623123 625577 630880 636866 637858 641331 641549 643801 654701 655099 655201 655352 656055 657052 657063 657652 658736 666308 668417 677975 678243 683426 689048 693350 693700 694347 696293 697695 698803 699121 700635 706857 707515 707726 718123 719248 719283 719401 721568 731141 735334 738654 746113 753661 759671 764286 766090 771139 773462 773803 775407 777855 779147 781030 782716 784173 790121 791207 792647 793554 794626 796910 799576 800170 800259 801032 801945 803638 804810 810135 814560 817003 817016 817403 817631 818412 818676 818880 819792 821491 821805 822475 823158 823166 823379 825035 825082 825111 826131 827438 828361 828463 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"love xxx"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"love xxx"
]
|
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.