Query Metrics
7
Database Queries
7
Different statements
148.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.33 ms (84.27%) |
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 397738 400579 418155 418158 418268 422140 424038 427623 432670 434877 436649 437360 441109 441755 441808 444848 445713 445717 445724 445752 445768 449272 449276 449310 450370 457809 459899 462069 462072 467895 485669 486136 495638 504118 506474 507975 521693 577558 587967 590455 616808 621468 636477 639986 674233 694568 705769 706721 717412 720570 721227 724475 724516 726116 727558 728187 729241 733280 733450 736755 739288 739899 741503 742838 744146 744812 745681 747492 749011 759738 759775 772572 773349 773371 775641 775650 775651 775659 776963 780297 780379 786877 786882 786905 787649 790945 792305 792769 793218 794453 794615 794639 795885 796472 798257 800131 804398 804400 804414 812439 817128 817675 820000 820688 824204 824208 824437 824559 824658 825028 825129 825227 826349 826694 826773 827084 827267 827375 827478 828228 ] |
||||||||||||||||||||||||||||||
|
14.54 ms (9.78%) |
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 397738 827375 812439 780379 726116 772572 804414 636477 418268 504118 824658 825227 824437 449272 787649 424038 616808 706721 467895 434877 824208 775650 780297 775641 441808 506474 485669 817675 820688 824559 826773 827267 820000 825028 826349 674233 590455 639986 775651 792305 733280 773349 744812 736755 773371 727558 794615 795885 798257 728187 796472 427623 445724 507975 445752 733450 759775 437360 449276 450370 717412 794453 800131 724516 747492 793218 400579 445768 418158 432670 444848 739288 826694 827478 521693 577558 694568 720570 721227 621468 775659 786905 790945 804398 744146 786877 749011 729241 742838 745681 792769 705769 724475 794639 741503 418155 441755 422140 436649 441109 445713 449310 445717 462072 587967 776963 786882 457809 459899 462069 486136 739899 759738 804400 827084 824204 817128 825129 828228 495638 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.50%) |
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 397738 400579 418155 418158 418268 422140 424038 427623 432670 434877 436649 437360 441109 441755 441808 444848 445713 445717 445724 445752 445768 449272 449276 449310 450370 457809 459899 462069 462072 467895 485669 486136 495638 504118 506474 507975 521693 577558 587967 590455 616808 621468 636477 639986 674233 694568 705769 706721 717412 720570 721227 724475 724516 726116 727558 728187 729241 733280 733450 736755 739288 739899 741503 742838 744146 744812 745681 747492 749011 759738 759775 772572 773349 773371 775641 775650 775651 775659 776963 780297 780379 786877 786882 786905 787649 790945 792305 792769 793218 794453 794615 794639 795885 796472 798257 800131 804398 804400 804414 812439 817128 817675 820000 820688 824204 824208 824437 824559 824658 825028 825129 825227 826349 826694 826773 827084 827267 827375 827478 828228 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"licking wife orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза жен orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза жен orgasm"
]
|
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.