Query Metrics
7
Database Queries
7
Different statements
284.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
257.82 ms (90.70%) |
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 384578 385009 389522 389911 391006 391209 396791 396942 397585 397962 401431 409667 412194 419432 420130 420344 425670 425757 435722 437926 439192 442263 449793 450378 451746 454264 455748 464273 465099 466923 473289 476775 479758 481795 483013 483486 484749 492399 502763 504899 506254 515374 516437 516795 520901 523888 525336 526433 528883 531034 534045 536750 540997 542262 546567 546639 547673 550015 559477 562518 563953 564749 570901 571791 574722 592498 599084 599656 600895 614474 615688 620743 620825 622627 624811 634068 651296 652886 669436 671092 678748 681394 683825 697155 698122 699731 703950 706001 713296 714203 718494 718899 722687 732402 736024 736938 737413 737908 745521 750302 751421 756368 758229 759112 759686 769413 773716 777680 784679 790210 798433 803036 803046 803047 804375 811267 819160 824856 826049 827700 ] |
||||||||||||||||||||||||||||||
|
17.61 ms (6.19%) |
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 714203 599656 599084 624811 777680 784679 769413 803047 745521 736024 391209 425670 425757 520901 454264 502763 420130 574722 758229 409667 528883 563953 547673 546567 550015 391006 466923 401431 600895 571791 389522 824856 564749 651296 698122 703950 706001 620825 811267 790210 759686 736938 737908 713296 683825 826049 827700 515374 435722 397962 531034 389911 819160 718494 737413 652886 669436 614474 615688 437926 450378 385009 546639 681394 570901 634068 412194 397585 419432 622627 759112 420344 559477 473289 483486 481795 523888 464273 620743 449793 442263 504899 384578 534045 483013 718899 699731 804375 396791 484749 476775 506254 525336 542262 562518 722687 732402 803036 697155 526433 465099 516437 479758 678748 592498 750302 756368 773716 751421 396942 439192 492399 455748 451746 803046 516795 536750 540997 671092 798433 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (0.81%) |
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 384578 385009 389522 389911 391006 391209 396791 396942 397585 397962 401431 409667 412194 419432 420130 420344 425670 425757 435722 437926 439192 442263 449793 450378 451746 454264 455748 464273 465099 466923 473289 476775 479758 481795 483013 483486 484749 492399 502763 504899 506254 515374 516437 516795 520901 523888 525336 526433 528883 531034 534045 536750 540997 542262 546567 546639 547673 550015 559477 562518 563953 564749 570901 571791 574722 592498 599084 599656 600895 614474 615688 620743 620825 622627 624811 634068 651296 652886 669436 671092 678748 681394 683825 697155 698122 699731 703950 706001 713296 714203 718494 718899 722687 732402 736024 736938 737413 737908 745521 750302 751421 756368 758229 759112 759686 769413 773716 777680 784679 790210 798433 803036 803046 803047 804375 811267 819160 824856 826049 827700 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.61%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие девушк"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.58%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие девушк"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big girls"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.54%) |
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.