Query Metrics
7
Database Queries
7
Different statements
187.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.20 ms (85.64%) |
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 4329 172322 172340 172514 197892 233330 355579 382508 383111 391683 396808 420474 443538 446457 455309 465749 478614 496727 503321 511800 517049 517691 520377 533898 533899 540718 543822 549717 550146 553203 557358 560804 561522 561886 568596 583447 584397 586886 591033 591525 591550 599849 612656 614498 615059 617999 627773 631253 633258 634914 641414 642252 642292 642365 644341 659175 660725 667886 682272 691373 697204 702236 703787 705313 712255 712690 713432 714112 720133 720517 721231 725722 726609 727047 734358 734657 736010 740557 744529 744762 746063 746642 754173 758128 763470 763868 765938 765958 767755 773504 775096 778292 778600 782169 782172 786680 787146 789350 789454 789464 789601 789630 793925 795046 795590 796535 796552 797848 801426 801429 801439 801781 802074 802092 803140 804606 810421 810816 812358 812469 ] |
||||||||||||||||||||||||||||||
|
15.55 ms (8.31%) |
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 682272 705313 659175 591525 612656 633258 642365 644341 631253 801439 778292 789630 802074 796552 801781 804606 725722 763470 765958 767755 773504 744529 726609 763868 617999 697204 702236 786680 801426 810421 233330 355579 517049 591033 443538 446457 396808 549717 561886 591550 782172 560804 503321 197892 4329 420474 478614 520377 511800 540718 553203 550146 583447 584397 660725 703787 712255 714112 667886 713432 720133 720517 691373 712690 721231 557358 561522 599849 614498 642252 642292 615059 778600 812469 775096 793925 795046 802092 803140 810816 812358 727047 734657 740557 754173 789350 795590 796535 744762 758128 765938 746642 746063 634914 787146 789454 789464 789601 801429 641414 782169 797848 391683 586886 627773 734358 736010 383111 568596 455309 172340 172322 172514 382508 517691 533898 533899 496727 465749 543822 ] |
||||||||||||||||||||||||||||||
|
4.46 ms (2.38%) |
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 4329 172322 172340 172514 197892 233330 355579 382508 383111 391683 396808 420474 443538 446457 455309 465749 478614 496727 503321 511800 517049 517691 520377 533898 533899 540718 543822 549717 550146 553203 557358 560804 561522 561886 568596 583447 584397 586886 591033 591525 591550 599849 612656 614498 615059 617999 627773 631253 633258 634914 641414 642252 642292 642365 644341 659175 660725 667886 682272 691373 697204 702236 703787 705313 712255 712690 713432 714112 720133 720517 721231 725722 726609 727047 734358 734657 736010 740557 744529 744762 746063 746642 754173 758128 763470 763868 765938 765958 767755 773504 775096 778292 778600 782169 782172 786680 787146 789350 789454 789464 789601 789630 793925 795046 795590 796535 796552 797848 801426 801429 801439 801781 802074 802092 803140 804606 810421 810816 812358 812469 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на кухня"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на кухн"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.78%) |
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.