Query Metrics
7
Database Queries
7
Different statements
173.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.59 ms (86.45%) |
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 4375 7170 7286 7441 14477 25069 44968 69589 129791 150507 188390 188447 196166 213692 233488 293121 326290 374819 384905 391545 391561 391696 392100 392277 393135 393326 400004 400026 400672 401209 401940 401975 404122 404188 404633 405421 406070 411119 419550 421562 421871 422958 422960 422989 426718 426725 428116 441765 442057 443893 443939 445833 446740 448810 451499 451983 454163 454840 457884 459842 461569 462434 462450 463936 466241 467113 468344 481760 486209 490143 503292 509223 512973 515996 522906 522949 523985 525695 527867 544142 550228 553472 558131 560990 562105 568936 571847 572763 586573 590542 594231 604364 605680 613836 620290 624226 626543 641006 645962 653033 656522 662913 702633 708457 709703 713181 715098 717892 718755 725934 738274 751500 760454 760925 760971 784600 801281 802715 809808 815950 ] |
||||||||||||||||||||||||||||||
|
14.22 ms (8.22%) |
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 815950 451499 69589 196166 401975 613836 594231 7441 515996 544142 560990 374819 442057 4375 404188 503292 393326 393135 293121 7286 404633 702633 708457 717892 784600 802715 760925 725934 760971 641006 718755 809808 468344 391561 401940 426718 421871 462450 448810 620290 604364 422960 451983 550228 572763 586573 422989 462434 466241 419550 445833 522949 392100 213692 188390 25069 400672 401209 441765 459842 486209 709703 624226 129791 44968 233488 422958 428116 457884 446740 527867 571847 558131 590542 454840 421562 481760 463936 461569 490143 512973 522906 523985 326290 7170 405421 406070 443893 467113 454163 553472 562105 653033 605680 391545 400026 404122 426725 443939 188447 411119 525695 656522 568936 760454 509223 384905 391696 645962 662913 713181 715098 626543 751500 801281 738274 150507 392277 14477 400004 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.73%) |
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 4375 7170 7286 7441 14477 25069 44968 69589 129791 150507 188390 188447 196166 213692 233488 293121 326290 374819 384905 391545 391561 391696 392100 392277 393135 393326 400004 400026 400672 401209 401940 401975 404122 404188 404633 405421 406070 411119 419550 421562 421871 422958 422960 422989 426718 426725 428116 441765 442057 443893 443939 445833 446740 448810 451499 451983 454163 454840 457884 459842 461569 462434 462450 463936 466241 467113 468344 481760 486209 490143 503292 509223 512973 515996 522906 522949 523985 525695 527867 544142 550228 553472 558131 560990 562105 568936 571847 572763 586573 590542 594231 604364 605680 613836 620290 624226 626543 641006 645962 653033 656522 662913 702633 708457 709703 713181 715098 717892 718755 725934 738274 751500 760454 760925 760971 784600 801281 802715 809808 815950 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мужикам в жопу"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мужчин анал"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.30 ms (0.75%) |
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.