Query Metrics
7
Database Queries
7
Different statements
173.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.61 ms (86.01%) |
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 192861 219172 323088 382725 383097 384847 385036 386705 387636 392109 393502 396424 396745 397503 398753 399053 427183 429508 477633 484145 484413 517154 538043 540479 543146 543721 543740 544739 545090 545766 547939 548573 582239 587761 593358 596404 599533 610811 622090 622105 622582 633154 635842 636510 641749 645966 647606 650375 650786 650944 651259 651310 651597 653165 653376 661889 664271 665497 671760 680974 681049 692454 709415 709640 715191 716819 719142 719852 720916 721072 721113 721412 721933 722665 723967 726252 731058 731113 733178 739858 742197 742219 747560 755723 760060 770790 770871 773961 775754 775922 775931 793468 800709 801036 801894 802175 802953 805565 809526 814574 815421 815725 815799 815961 817190 818878 819193 820690 825644 ] |
||||||||||||||||||||||||||||||
|
13.97 ms (8.03%) |
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 219172 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 599533 385036 775931 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 651310 719852 651597 671760 680974 681049 716819 544739 545766 622090 610811 633154 622105 775754 801036 809526 775922 802175 742219 747560 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.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 12731 44998 78926 93079 95668 95873 95988 96468 96484 96665 188621 192861 219172 323088 382725 383097 384847 385036 386705 387636 392109 393502 396424 396745 397503 398753 399053 427183 429508 477633 484145 484413 517154 538043 540479 543146 543721 543740 544739 545090 545766 547939 548573 582239 587761 593358 596404 599533 610811 622090 622105 622582 633154 635842 636510 641749 645966 647606 650375 650786 650944 651259 651310 651597 653165 653376 661889 664271 665497 671760 680974 681049 692454 709415 709640 715191 716819 719142 719852 720916 721072 721113 721412 721933 722665 723967 726252 731058 731113 733178 739858 742197 742219 747560 755723 760060 770790 770871 773961 775754 775922 775931 793468 800709 801036 801894 802175 802953 805565 809526 814574 815421 815725 815799 815961 817190 818878 819193 820690 825644 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мжм 2009"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.89%) |
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.