Query Metrics
7
Database Queries
7
Different statements
147.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.24 ms (82.85%) |
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 7748 304698 390391 396827 397618 403560 411202 415488 416333 416871 417005 420310 425269 428804 442442 443632 446765 453989 454031 454205 459356 460195 464423 470851 479276 479647 483503 484934 485692 491494 499748 503738 504676 507084 511719 514607 515313 524314 531971 547066 549655 549662 560932 562461 565424 573362 575373 581377 587533 591529 591820 591895 595214 596322 597763 603257 607224 618538 620565 625245 629108 634760 634873 635967 645949 648762 665053 666786 669859 671328 688016 703949 707357 714242 717461 726536 727328 731064 740149 745415 749602 755916 756275 756874 759690 759793 761838 763187 767284 773897 778858 781823 783871 784471 787824 792772 794637 796272 797312 797352 798640 800922 801320 801364 802278 803031 803799 804445 806017 807148 810644 813795 814115 815341 817859 819363 820540 820947 823362 823433 ] |
||||||||||||||||||||||||||||||
|
14.92 ms (10.11%) |
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 485692 499748 703949 759690 491494 823433 807148 390391 428804 397618 814115 575373 665053 669859 778858 727328 634760 304698 479647 802278 823362 470851 549655 560932 562461 714242 648762 595214 596322 597763 618538 797352 781823 794637 756874 787824 756275 767284 773897 749602 454031 813795 820540 820947 817859 688016 591895 625245 803799 755916 607224 453989 479276 459356 549662 671328 634873 803031 417005 411202 416871 515313 763187 425269 396827 797312 416333 801320 804445 484934 531971 504676 524314 547066 745415 731064 415488 707357 740149 620565 446765 629108 759793 810644 819363 666786 717461 581377 801364 800922 806017 726536 503738 460195 645949 573362 591529 587533 591820 798640 603257 443632 442442 454205 796272 483503 507084 565424 635967 784471 792772 761838 783871 403560 7748 511719 420310 815341 464423 514607 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (2.18%) |
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 7748 304698 390391 396827 397618 403560 411202 415488 416333 416871 417005 420310 425269 428804 442442 443632 446765 453989 454031 454205 459356 460195 464423 470851 479276 479647 483503 484934 485692 491494 499748 503738 504676 507084 511719 514607 515313 524314 531971 547066 549655 549662 560932 562461 565424 573362 575373 581377 587533 591529 591820 591895 595214 596322 597763 603257 607224 618538 620565 625245 629108 634760 634873 635967 645949 648762 665053 666786 669859 671328 688016 703949 707357 714242 717461 726536 727328 731064 740149 745415 749602 755916 756275 756874 759690 759793 761838 763187 767284 773897 778858 781823 783871 784471 787824 792772 794637 796272 797312 797352 798640 800922 801320 801364 802278 803031 803799 804445 806017 807148 810644 813795 814115 815341 817859 819363 820540 820947 823362 823433 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits horny"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ horny"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ horny"
]
|
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.