Query Metrics
7
Database Queries
7
Different statements
141.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.30 ms (81.74%) |
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 6643 228398 385357 391977 396322 398308 420037 426819 443140 456997 459556 466045 484096 484116 505636 511806 512632 532157 535207 535992 606844 706441 718019 720953 724003 724586 724977 725939 726243 727309 728463 728945 731278 732401 737255 738268 738573 738942 739324 739600 739708 740623 743328 743791 743901 745509 745830 746467 747837 748855 749256 750517 751130 751929 751946 752763 753231 756318 758393 758405 760297 762261 763877 764126 764699 764751 764880 765641 766632 768441 768695 768832 769264 771658 772619 773361 773590 778686 779829 780813 781297 781658 782381 782486 782640 783084 784587 785389 785801 786276 787106 788620 788726 789164 789538 790472 791083 792139 792903 794347 794812 797019 799006 801289 802745 805012 805463 808799 809969 813318 817235 818104 818267 818642 818952 820165 821784 823405 827869 827949 ] |
||||||||||||||||||||||||||||||
|
14.66 ms (10.39%) |
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 779829 780813 782381 782640 785389 786276 789538 792139 792903 805012 805463 813318 778686 788726 797019 801289 743328 743791 746467 764699 764751 765641 768832 781297 783084 785801 788620 790472 791083 794347 794812 799006 724586 724977 732401 739324 745509 745830 747837 751130 758405 762261 766632 724003 726243 728463 738268 738573 739600 740623 743901 749256 751929 751946 756318 758393 764126 768695 769264 737255 739708 748855 763877 768441 725939 727309 728945 731278 738942 750517 752763 753231 764880 771658 772619 773361 773590 606844 706441 718019 720953 781658 782486 784587 787106 789164 802745 808799 809969 6643 228398 420037 391977 398308 466045 443140 760297 385357 396322 426819 818267 821784 817235 818104 818642 818952 820165 823405 827869 827949 456997 459556 484096 532157 505636 535207 511806 535992 512632 484116 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (2.32%) |
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 6643 228398 385357 391977 396322 398308 420037 426819 443140 456997 459556 466045 484096 484116 505636 511806 512632 532157 535207 535992 606844 706441 718019 720953 724003 724586 724977 725939 726243 727309 728463 728945 731278 732401 737255 738268 738573 738942 739324 739600 739708 740623 743328 743791 743901 745509 745830 746467 747837 748855 749256 750517 751130 751929 751946 752763 753231 756318 758393 758405 760297 762261 763877 764126 764699 764751 764880 765641 766632 768441 768695 768832 769264 771658 772619 773361 773590 778686 779829 780813 781297 781658 782381 782486 782640 783084 784587 785389 785801 786276 787106 788620 788726 789164 789538 790472 791083 792139 792903 794347 794812 797019 799006 801289 802745 805012 805463 808799 809969 813318 817235 818104 818267 818642 818952 820165 821784 823405 827869 827949 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"xxx boyfriend"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (1.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"xxx boyfriend"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"xxx boyfriend"
]
|
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.