Query Metrics
7
Database Queries
7
Different statements
210.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.64 ms (85.44%) |
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 461037 461240 466954 470432 472151 472700 476308 485751 500470 500982 503842 505343 505690 505692 506778 510872 510874 512067 512993 513335 514774 517480 517490 517826 518826 518836 518847 518854 520373 520520 524867 524880 525490 528524 529400 534138 543575 546122 546878 547538 548231 548264 549222 551932 553215 554110 554442 554448 554459 554500 554839 555007 555285 555348 555402 556586 557267 558287 559165 560869 561507 562962 562975 563424 565749 566361 567143 567339 570933 570966 573196 577037 577132 578146 579425 581203 582317 582462 584019 584212 585050 588804 589664 589670 590410 590524 591861 592636 593856 598840 601342 603930 604577 605460 605904 612056 612276 612996 614350 620349 622503 625807 644092 644198 652644 663485 663926 664542 664593 664858 665236 665454 667195 667344 667555 668639 668676 675145 690916 766583 ] |
||||||||||||||||||||||||||||||
|
18.51 ms (8.81%) |
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 582462 546122 547538 548231 554110 554500 563424 565749 578146 667195 667555 668676 675145 664858 665236 690916 555348 562975 577037 591861 598840 620349 644198 593856 603930 605904 612276 612996 614350 644092 589664 589670 592636 601342 605460 622503 588804 590410 590524 625807 766583 604577 612056 585050 466954 472700 461037 472151 476308 485751 500470 505692 510874 517826 518826 520520 525490 500982 506778 510872 517490 518836 518847 518854 520373 505343 513335 517480 524867 528524 529400 503842 505690 512067 512993 514774 524880 534138 461240 470432 549222 551932 554448 554459 555402 558287 559165 567143 567339 577132 581203 582317 543575 555285 556586 560869 570966 573196 579425 548264 554442 554839 555007 562962 570933 584019 584212 663485 663926 664593 667344 664542 668639 652644 665454 546878 553215 557267 561507 566361 ] |
||||||||||||||||||||||||||||||
|
4.10 ms (1.95%) |
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 461037 461240 466954 470432 472151 472700 476308 485751 500470 500982 503842 505343 505690 505692 506778 510872 510874 512067 512993 513335 514774 517480 517490 517826 518826 518836 518847 518854 520373 520520 524867 524880 525490 528524 529400 534138 543575 546122 546878 547538 548231 548264 549222 551932 553215 554110 554442 554448 554459 554500 554839 555007 555285 555348 555402 556586 557267 558287 559165 560869 561507 562962 562975 563424 565749 566361 567143 567339 570933 570966 573196 577037 577132 578146 579425 581203 582317 582462 584019 584212 585050 588804 589664 589670 590410 590524 591861 592636 593856 598840 601342 603930 604577 605460 605904 612056 612276 612996 614350 620349 622503 625807 644092 644198 652644 663485 663926 664542 664593 664858 665236 665454 667195 667344 667555 668639 668676 675145 690916 766583 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"висячий"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"обвисший"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.