Query Metrics
7
Database Queries
7
Different statements
187.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.54 ms (86.47%) |
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 381776 384856 386285 393750 394187 400439 400454 402081 402088 402093 403042 403053 408708 413228 416303 416965 419386 429234 435612 443362 451595 462288 463168 469905 469910 470842 484127 506213 512041 515140 515217 515219 527513 532153 540912 547753 549994 557064 566505 569665 569666 570061 570064 586632 590250 592735 596915 603160 624858 626752 646939 656779 663375 663882 665287 665295 666164 668894 669446 669737 676942 677044 677697 680864 681187 682510 682523 682538 684947 688032 694539 698657 701345 702852 705093 707312 718241 720456 720504 722670 722686 722705 722915 722916 723931 731386 732135 734613 741647 743063 743103 743127 744329 744790 746081 748128 748136 748386 759405 759553 759565 759591 759592 759609 765448 766035 766578 774109 774178 775383 775616 789212 789574 794769 804530 806031 812127 812129 812143 816661 ] |
||||||||||||||||||||||||||||||
|
14.41 ms (7.66%) |
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 806031 812129 748386 759565 759405 765448 746081 393750 400439 403053 469910 774109 759592 663375 394187 381776 419386 416965 515140 665295 707312 624858 586632 744329 722916 515219 527513 416303 557064 402088 743127 705093 402093 443362 435612 569666 566505 677044 569665 774178 386285 400454 463168 665287 646939 681187 722705 663882 682510 682538 722670 626752 794769 804530 732135 766578 759591 759609 748136 775383 816661 532153 694539 720504 590250 744790 741647 743063 701345 775616 403042 549994 722686 676942 668894 684947 743103 789212 812143 759553 812127 462288 512041 698657 731386 722915 748128 515217 656779 547753 666164 669446 669737 702852 677697 682523 688032 592735 789574 723931 766035 734613 720456 384856 402081 469905 429234 603160 718241 680864 506213 596915 470842 570064 570061 408708 451595 484127 540912 413228 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (1.75%) |
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 381776 384856 386285 393750 394187 400439 400454 402081 402088 402093 403042 403053 408708 413228 416303 416965 419386 429234 435612 443362 451595 462288 463168 469905 469910 470842 484127 506213 512041 515140 515217 515219 527513 532153 540912 547753 549994 557064 566505 569665 569666 570061 570064 586632 590250 592735 596915 603160 624858 626752 646939 656779 663375 663882 665287 665295 666164 668894 669446 669737 676942 677044 677697 680864 681187 682510 682523 682538 684947 688032 694539 698657 701345 702852 705093 707312 718241 720456 720504 722670 722686 722705 722915 722916 723931 731386 732135 734613 741647 743063 743103 743127 744329 744790 746081 748128 748136 748386 759405 759553 759565 759591 759592 759609 765448 766035 766578 774109 774178 775383 775616 789212 789574 794769 804530 806031 812127 812129 812143 816661 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young девушк old"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young girl old"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young девушк old"
]
|
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.