Query Metrics
7
Database Queries
7
Different statements
158.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.14 ms (81.57%) |
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 254390 433721 434003 442652 448968 450654 454084 460577 463094 463826 464561 465608 469366 469686 472544 472669 475677 489325 491525 504908 510774 519215 519497 520405 521287 523907 525149 525156 525551 525864 526096 528088 528119 528197 529341 529952 531510 532273 532572 535486 535878 538695 539121 539147 541158 541167 541467 543144 549101 554143 557471 561121 563538 564562 566016 568136 568138 568377 569019 569041 570822 571666 577119 580300 587232 589365 591688 593098 593144 593146 593340 595323 596033 596115 597908 598328 603351 603396 604465 605340 605581 606618 616205 618960 619495 623650 624263 627064 629417 629882 633171 635280 637207 652544 674683 694203 695613 696553 710917 726800 751012 755343 758119 772410 773000 774393 775508 783405 785119 789760 790124 790170 794606 798600 799440 802445 804689 815269 817131 827080 ] |
||||||||||||||||||||||||||||||
|
20.02 ms (12.65%) |
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 525149 525551 566016 541167 557471 563538 674683 696553 554143 561121 568136 568138 589365 596033 624263 629417 635280 637207 587232 593146 597908 598328 603396 623650 591688 605340 627064 799440 775508 798600 802445 773000 783405 789760 790124 751012 758119 772410 774393 726800 755343 710917 785119 790170 794606 804689 254390 472669 464561 580300 532572 652544 629882 616205 504908 519497 525864 442652 434003 475677 535486 539147 528088 472544 491525 569041 543144 604465 454084 463094 465608 469686 519215 523907 528119 529341 489325 521287 541467 520405 528197 529952 531510 433721 817131 827080 815269 463826 450654 469366 448968 526096 538695 539121 510774 525156 532273 535878 460577 541158 568377 569019 570822 577119 694203 695613 549101 564562 571666 606618 633171 596115 593098 603351 605581 593144 593340 595323 618960 619495 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.49%) |
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 254390 433721 434003 442652 448968 450654 454084 460577 463094 463826 464561 465608 469366 469686 472544 472669 475677 489325 491525 504908 510774 519215 519497 520405 521287 523907 525149 525156 525551 525864 526096 528088 528119 528197 529341 529952 531510 532273 532572 535486 535878 538695 539121 539147 541158 541167 541467 543144 549101 554143 557471 561121 563538 564562 566016 568136 568138 568377 569019 569041 570822 571666 577119 580300 587232 589365 591688 593098 593144 593146 593340 595323 596033 596115 597908 598328 603351 603396 604465 605340 605581 606618 616205 618960 619495 623650 624263 627064 629417 629882 633171 635280 637207 652544 674683 694203 695613 696553 710917 726800 751012 755343 758119 772410 773000 774393 775508 783405 785119 789760 790124 790170 794606 798600 799440 802445 804689 815269 817131 827080 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"compilation mom"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.09%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"подборк mom"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"подборк mom"
]
|
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.