Query Metrics
7
Database Queries
7
Different statements
441.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.16 ms (48.32%) |
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 11991 12775 47606 100665 102702 153425 238875 281801 385911 392967 394739 395405 397345 403425 404555 406596 410807 414220 417656 418524 421010 422716 424652 426926 440971 445414 445833 448798 451250 452376 454649 461729 465034 471443 487197 488536 517564 519447 531464 533353 542685 543044 543476 548903 559394 561086 562754 568313 581453 581821 586674 588601 596534 597923 611730 611948 615599 623143 623440 633744 636053 641931 645966 648634 673138 676973 681686 684017 689738 704955 704966 709881 716406 717944 723616 728397 747066 749338 750042 755974 765472 766881 767548 767601 770884 776054 779016 784703 789478 790001 790872 791558 792423 795514 797667 797787 801596 802123 803694 804706 807551 809419 810101 810139 814623 814778 814926 815219 817266 817469 818179 818206 819611 821186 821691 823246 823320 823498 823923 826764 ] |
||||||||||||||||||||||||||||||
|
206.71 ms (46.86%) |
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 11991 12775 47606 100665 102702 153425 238875 281801 385911 392967 394739 395405 397345 403425 404555 406596 410807 414220 417656 418524 421010 422716 424652 426926 440971 445414 445833 448798 451250 452376 454649 461729 465034 471443 487197 488536 517564 519447 531464 533353 542685 543044 543476 548903 559394 561086 562754 568313 581453 581821 586674 588601 596534 597923 611730 611948 615599 623143 623440 633744 636053 641931 645966 648634 673138 676973 681686 684017 689738 704955 704966 709881 716406 717944 723616 728397 747066 749338 750042 755974 765472 766881 767548 767601 770884 776054 779016 784703 789478 790001 790872 791558 792423 795514 797667 797787 801596 802123 803694 804706 807551 809419 810101 810139 814623 814778 814926 815219 817266 817469 818179 818206 819611 821186 821691 823246 823320 823498 823923 826764 ] |
||||||||||||||||||||||||||||||
|
14.31 ms (3.24%) |
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 716406 676973 641931 770884 717944 519447 488536 392967 406596 689738 548903 784703 810139 461729 819611 817469 684017 802123 417656 454649 561086 795514 426926 818206 568313 673138 623440 487197 531464 681686 755974 767601 779016 517564 817266 704955 804706 789478 767548 704966 281801 403425 153425 445414 452376 596534 728397 543044 623143 797667 422716 414220 723616 765472 542685 533353 648634 11991 645966 100665 445833 471443 47606 821186 821691 790001 385911 581821 421010 814926 636053 749338 776054 807551 397345 562754 410807 588601 792423 823320 818179 823498 814623 823246 823923 611948 791558 803694 790872 766881 709881 404555 615599 102702 597923 586674 394739 633744 809419 448798 12775 797787 238875 747066 465034 750042 810101 440971 424652 581453 559394 418524 395405 451250 815219 543476 611730 801596 814778 826764 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"deepthroat ass licking"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубокийминет минет оральн секс жоп лиза"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.