Query Metrics
7
Database Queries
7
Different statements
175.52 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.01 ms (86.61%) |
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 12731 44998 78926 93079 95668 95873 95988 96468 96484 96665 188621 192643 192861 192943 219172 323088 341645 382725 383097 384847 385036 385787 386200 386705 387636 392109 393502 396424 396745 397503 398753 399053 411367 427183 429508 444240 477633 484145 484413 506548 517154 538043 540479 540957 543146 543721 543740 545090 547939 548573 550303 555783 582239 587761 593358 596404 622155 622582 635842 636510 641749 645105 645966 647606 649615 649920 650375 650786 650944 651259 653165 653376 653619 661889 664271 664855 665497 665876 667656 671912 692454 709415 709640 715191 719142 720916 721072 721113 721412 721933 722665 723967 726252 731058 731113 733178 735078 739858 742197 755723 760060 770790 770871 773961 775931 793468 800709 801894 802953 805565 814574 815421 815725 815799 815961 817190 818878 819193 820690 825644 ] |
||||||||||||||||||||||||||||||
|
13.12 ms (7.48%) |
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 506548 550303 540957 665876 667656 649615 653619 664855 622155 735078 555783 219172 385787 760060 382725 323088 815725 484145 709415 665497 733178 770790 95668 719142 720916 722665 721933 641749 723967 731058 801894 593358 770871 773961 820690 538043 692454 664271 635842 636510 802953 739858 800709 731113 649920 192943 192643 444240 386200 411367 341645 671912 385036 775931 645105 188621 44998 96468 543721 645966 709640 653165 726252 721072 12731 96484 384847 93079 95988 396745 398753 399053 429508 817190 814574 818878 819193 477633 543740 547939 650944 653376 721412 587761 596404 622582 793468 755723 805565 742197 192861 427183 386705 484413 383097 96665 393502 392109 78926 95873 387636 396424 397503 815421 815799 815961 825644 517154 540479 582239 548573 543146 545090 647606 650786 661889 715191 721113 650375 651259 ] |
||||||||||||||||||||||||||||||
|
3.25 ms (1.85%) |
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 12731 44998 78926 93079 95668 95873 95988 96468 96484 96665 188621 192643 192861 192943 219172 323088 341645 382725 383097 384847 385036 385787 386200 386705 387636 392109 393502 396424 396745 397503 398753 399053 411367 427183 429508 444240 477633 484145 484413 506548 517154 538043 540479 540957 543146 543721 543740 545090 547939 548573 550303 555783 582239 587761 593358 596404 622155 622582 635842 636510 641749 645105 645966 647606 649615 649920 650375 650786 650944 651259 653165 653376 653619 661889 664271 664855 665497 665876 667656 671912 692454 709415 709640 715191 719142 720916 721072 721113 721412 721933 722665 723967 726252 731058 731113 733178 735078 739858 742197 755723 760060 770790 770871 773961 775931 793468 800709 801894 802953 805565 814574 815421 815725 815799 815961 817190 818878 819193 820690 825644 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mmf threesome"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.01%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мжм секс втро секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.91%) |
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.