Query Metrics
7
Database Queries
7
Different statements
156.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.63 ms (84.59%) |
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 35136 390220 400894 401546 401684 401861 422388 423988 424048 428828 438650 450264 454083 469173 471050 475756 481927 499335 502756 506057 507631 508578 515457 527914 529860 536100 539219 541802 545125 545299 550677 563688 570120 571791 580230 583205 585258 589229 590337 591320 604162 605087 609551 625817 629479 630370 639221 640285 658980 668694 687306 697579 712212 714634 715473 716058 724954 726653 728048 729370 735498 738101 740552 742298 742364 749669 750387 753135 754487 755488 756745 758272 759160 765179 769528 770221 770610 772547 772552 772979 775240 777154 777667 778815 780553 781250 782651 784379 784744 784980 786365 786611 788555 790625 790635 791036 794019 795400 795884 795979 797046 797182 799944 801799 801988 803543 803767 803826 803841 804682 806144 806635 808144 808162 810520 810776 811264 811915 812388 816728 ] |
||||||||||||||||||||||||||||||
|
13.79 ms (8.79%) |
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 775240 777154 778815 788555 795400 795884 801988 777667 786365 790625 810776 772979 799944 808162 810520 811264 740552 735498 754487 759160 769528 770221 726653 605087 625817 697579 716058 784379 786611 811915 507631 580230 390220 423988 475756 529860 583205 563688 687306 640285 790635 806144 780553 755488 782651 784744 508578 401684 724954 728048 424048 515457 469173 502756 806635 471050 401546 438650 454083 450264 506057 527914 35136 422388 816728 481927 539219 499335 536100 541802 550677 570120 658980 714634 668694 545125 545299 571791 585258 590337 591320 630370 589229 604162 609551 639221 781250 784980 794019 795979 797182 803841 804682 812388 750387 753135 772547 801799 803543 803767 803826 808144 738101 756745 742364 765179 770610 772552 729370 742298 749669 758272 629479 712212 715473 791036 797046 401861 400894 428828 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (2.19%) |
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 35136 390220 400894 401546 401684 401861 422388 423988 424048 428828 438650 450264 454083 469173 471050 475756 481927 499335 502756 506057 507631 508578 515457 527914 529860 536100 539219 541802 545125 545299 550677 563688 570120 571791 580230 583205 585258 589229 590337 591320 604162 605087 609551 625817 629479 630370 639221 640285 658980 668694 687306 697579 712212 714634 715473 716058 724954 726653 728048 729370 735498 738101 740552 742298 742364 749669 750387 753135 754487 755488 756745 758272 759160 765179 769528 770221 770610 772547 772552 772979 775240 777154 777667 778815 780553 781250 782651 784379 784744 784980 786365 786611 788555 790625 790635 791036 794019 795400 795884 795979 797046 797182 799944 801799 801988 803543 803767 803826 803841 804682 806144 806635 808144 808162 810520 810776 811264 811915 812388 816728 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hot ass solo"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hot жоп соло"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hot жоп соло"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.