Query Metrics
7
Database Queries
7
Different statements
182.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.34 ms (85.10%) |
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 95673 188269 382355 387544 387550 389899 391941 403010 405054 411638 413263 414184 416765 420547 426607 428334 428523 430704 434724 443113 443453 444046 445037 445363 446165 446330 447124 448810 448887 450515 451266 451963 452956 453512 457089 457983 458592 458992 459395 463162 464326 464506 464513 467839 468721 470389 470561 470641 470792 471412 471792 472125 472792 474461 475115 475630 477941 479064 479523 480941 481151 482317 482946 483037 483375 484092 490511 491938 492040 493304 496863 500571 501154 503336 503965 509448 509481 510589 510592 512436 515224 516241 516635 517749 518759 519949 521836 526133 545318 546106 546940 560188 561137 561898 564172 566297 567146 567457 574364 577356 579592 581738 586623 587263 593125 596809 598198 607924 609196 611986 613857 616994 624110 644959 653523 656158 659347 720885 748950 807927 ] |
||||||||||||||||||||||||||||||
|
17.40 ms (9.53%) |
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 517749 577356 464326 387544 458992 446330 480941 391941 403010 470641 510592 434724 564172 607924 748950 444046 509448 472125 586623 428523 450515 574364 464506 464513 445037 516241 496863 493304 593125 579592 475630 428334 448887 521836 598198 445363 470792 644959 566297 561898 656158 457089 659347 561137 413263 448810 510589 387550 416765 500571 405054 411638 451963 653523 807927 479523 482317 484092 611986 389899 483375 457983 567146 567457 587263 613857 472792 188269 453512 503965 483037 515224 609196 616994 95673 443453 459395 471412 581738 545318 624110 414184 382355 426607 447124 475115 470561 519949 516635 443113 430704 452956 458592 467839 470389 518759 546106 451266 560188 446165 720885 596809 492040 526133 490511 481151 463162 468721 477941 491938 482946 512436 474461 479064 509481 546940 503336 420547 471792 501154 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.53%) |
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 95673 188269 382355 387544 387550 389899 391941 403010 405054 411638 413263 414184 416765 420547 426607 428334 428523 430704 434724 443113 443453 444046 445037 445363 446165 446330 447124 448810 448887 450515 451266 451963 452956 453512 457089 457983 458592 458992 459395 463162 464326 464506 464513 467839 468721 470389 470561 470641 470792 471412 471792 472125 472792 474461 475115 475630 477941 479064 479523 480941 481151 482317 482946 483037 483375 484092 490511 491938 492040 493304 496863 500571 501154 503336 503965 509448 509481 510589 510592 512436 515224 516241 516635 517749 518759 519949 521836 526133 545318 546106 546940 560188 561137 561898 564172 566297 567146 567457 574364 577356 579592 581738 586623 587263 593125 596809 598198 607924 609196 611986 613857 616994 624110 644959 653523 656158 659347 720885 748950 807927 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс два мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс два мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"секс два мужика"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.87%) |
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.