Query Metrics
7
Database Queries
7
Different statements
216.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
190.73 ms (88.22%) |
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 247381 389310 389629 393741 394224 396245 397811 399456 399551 409200 411726 411858 418316 419245 443673 443719 445052 445976 448958 455180 462506 464303 467304 491442 514787 515171 519973 520730 521225 531429 531430 531462 558052 564416 565100 567628 567670 569660 578483 588389 589616 596163 609052 618916 621067 621578 633516 633860 649130 660150 665274 665296 666141 667316 671396 674090 679380 683541 685686 697230 704547 711671 712712 712905 712907 714477 715138 716236 716528 718497 721369 721822 726640 728328 731805 732127 733274 735832 741906 744316 746158 748138 753279 753465 754206 758456 759567 760567 766030 767155 771874 774927 775284 776442 778364 779178 781019 781912 784925 786769 790246 790394 790614 790752 791355 800568 802654 804748 806122 807451 807516 807610 807698 807778 814122 814257 817902 821337 822650 823917 ] |
||||||||||||||||||||||||||||||
|
14.92 ms (6.90%) |
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 754206 735832 786769 515171 779178 389629 520730 565100 567670 569660 744316 445052 455180 464303 519973 721822 588389 633860 806122 790752 807451 731805 711671 781019 807778 491442 823917 718497 445976 448958 733274 790614 393741 394224 389310 396245 397811 399456 411858 418316 817902 814122 814257 821337 822650 467304 531462 514787 531429 531430 521225 564416 578483 558052 567628 665274 674090 683541 712712 714477 716528 660150 665296 667316 671396 679380 685686 697230 712905 716236 649130 666141 704547 712907 596163 633516 618916 621578 589616 609052 778364 791355 800568 807516 774927 781912 790394 804748 807610 758456 759567 767155 784925 790246 807698 732127 741906 748138 753465 728328 771874 726640 746158 753279 760567 766030 621067 715138 721369 775284 776442 802654 443719 247381 462506 399551 409200 411726 443673 419245 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.33%) |
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 247381 389310 389629 393741 394224 396245 397811 399456 399551 409200 411726 411858 418316 419245 443673 443719 445052 445976 448958 455180 462506 464303 467304 491442 514787 515171 519973 520730 521225 531429 531430 531462 558052 564416 565100 567628 567670 569660 578483 588389 589616 596163 609052 618916 621067 621578 633516 633860 649130 660150 665274 665296 666141 667316 671396 674090 679380 683541 685686 697230 704547 711671 712712 712905 712907 714477 715138 716236 716528 718497 721369 721822 726640 728328 731805 732127 733274 735832 741906 744316 746158 748138 753279 753465 754206 758456 759567 760567 766030 767155 771874 774927 775284 776442 778364 779178 781019 781912 784925 786769 790246 790394 790614 790752 791355 800568 802654 804748 806122 807451 807516 807610 807698 807778 814122 814257 817902 821337 822650 823917 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"lick ass young"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.84%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза жоп young"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза жоп young"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.80%) |
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.