Query Metrics
7
Database Queries
7
Different statements
147.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.54 ms (82.35%) |
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 7219 13767 28397 81214 91248 233915 386212 391600 392902 395612 397413 400428 401146 401946 405777 409249 422499 435530 443489 447912 471759 472859 478256 489648 492109 495331 506518 531290 534585 535754 541558 545365 545765 546838 547432 548785 550948 551183 553472 554892 563333 566763 566858 577376 586939 593207 613643 614237 614292 620113 620240 637460 660612 661283 662916 669026 669045 670765 671247 672095 674658 685466 685524 686002 691598 693103 694062 695631 696522 699695 703088 703534 708475 712786 713486 715620 717206 719940 725618 726878 727689 729929 738641 738674 742015 743900 744270 745912 747129 747335 747503 751213 752625 757031 757915 760827 761157 764868 770304 779010 784260 791101 793219 794783 794852 798947 801322 802552 803687 811649 813549 814434 815898 819053 820642 821088 821182 821552 822786 824198 ] |
||||||||||||||||||||||||||||||
|
15.69 ms (10.63%) |
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 566763 401946 478256 553472 686002 779010 435530 471759 506518 472859 725618 662916 13767 793219 566858 670765 703534 802552 233915 814434 717206 794852 712786 752625 409249 819053 820642 824198 535754 547432 694062 674658 811649 685466 685524 541558 798947 422499 489648 563333 577376 545765 747129 729929 761157 784260 550948 669045 669026 803687 392902 586939 620240 760827 801322 443489 531290 671247 672095 695631 713486 715620 696522 699695 708475 554892 614237 794783 743900 747503 726878 757031 764868 727689 745912 747335 751213 757915 770304 614292 386212 495331 693103 405777 813549 534585 661283 738674 395612 637460 703088 791101 742015 744270 91248 546838 691598 545365 548785 551183 738641 397413 391600 492109 81214 447912 593207 7219 28397 401146 815898 821088 821552 822786 821182 660612 620113 613643 719940 400428 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.88%) |
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 7219 13767 28397 81214 91248 233915 386212 391600 392902 395612 397413 400428 401146 401946 405777 409249 422499 435530 443489 447912 471759 472859 478256 489648 492109 495331 506518 531290 534585 535754 541558 545365 545765 546838 547432 548785 550948 551183 553472 554892 563333 566763 566858 577376 586939 593207 613643 614237 614292 620113 620240 637460 660612 661283 662916 669026 669045 670765 671247 672095 674658 685466 685524 686002 691598 693103 694062 695631 696522 699695 703088 703534 708475 712786 713486 715620 717206 719940 725618 726878 727689 729929 738641 738674 742015 743900 744270 745912 747129 747335 747503 751213 752625 757031 757915 760827 761157 764868 770304 779010 784260 791101 793219 794783 794852 798947 801322 802552 803687 811649 813549 814434 815898 819053 820642 821088 821182 821552 822786 824198 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public solo anal"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.33%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц соло анал"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.15%) |
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.