Query Metrics
7
Database Queries
7
Different statements
182.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.72 ms (86.84%) |
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 81603 147313 147403 163310 203480 336860 401570 407369 411228 414175 415273 416000 417338 424293 425025 446682 452950 454931 457152 458031 468282 472105 473609 482536 483212 484418 484622 490192 490606 496647 500034 500482 503546 504141 504227 506433 506820 506966 508489 508856 509256 511567 511946 512851 513103 513492 516673 517325 520262 520598 521199 523748 523829 525061 527666 543251 543492 545329 557172 565584 566122 570535 572199 574833 576112 577556 584054 591428 593108 593114 596839 598698 599441 599962 600458 601511 602594 605544 606806 617212 617621 618008 621020 621607 628324 633257 633498 640987 656841 662445 664221 668818 670424 702756 704913 705609 707295 718158 725449 739009 740176 740705 741165 750219 752908 752992 753538 753734 754631 770637 773603 776686 777943 778371 778674 790027 790043 798684 802427 ] |
||||||||||||||||||||||||||||||
|
15.15 ms (8.29%) |
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 506433 508489 511567 513103 513492 525061 500034 504227 508856 523829 662445 617212 147313 336860 753734 416000 414175 458031 484418 527666 500482 516673 570535 572199 574833 565584 598698 593114 599441 600458 617621 605544 628324 798684 468282 417338 425025 472105 473609 452950 503546 520262 504141 506820 512851 520598 483212 490192 496647 509256 147403 163310 656841 778674 754631 790043 81603 401570 596839 523748 718158 790027 773672 740705 752908 739009 770637 750219 752992 484622 482536 577556 566122 576112 545329 601511 606806 602594 621020 621607 599962 618008 633498 591428 415273 457152 446682 454931 511946 517325 490606 506966 411228 543251 702756 670424 704913 776686 778371 773603 802427 740176 753538 725449 741165 640987 705609 777943 203480 407369 424293 521199 584054 543492 707295 668818 664221 557172 633257 593108 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.24%) |
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 81603 147313 147403 163310 203480 336860 401570 407369 411228 414175 415273 416000 417338 424293 425025 446682 452950 454931 457152 458031 468282 472105 473609 482536 483212 484418 484622 490192 490606 496647 500034 500482 503546 504141 504227 506433 506820 506966 508489 508856 509256 511567 511946 512851 513103 513492 516673 517325 520262 520598 521199 523748 523829 525061 527666 543251 543492 545329 557172 565584 566122 570535 572199 574833 576112 577556 584054 591428 593108 593114 596839 598698 599441 599962 600458 601511 602594 605544 606806 617212 617621 618008 621020 621607 628324 633257 633498 640987 656841 662445 664221 668818 670424 702756 704913 705609 707295 718158 725449 739009 740176 740705 741165 750219 752908 752992 753538 753734 754631 770637 773603 776686 777943 778371 778674 790027 790043 798684 802427 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сво"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"свое"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.73%) |
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.