Query Metrics
7
Database Queries
7
Different statements
163.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.52 ms (85.24%) |
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 419951 459029 469153 524548 526715 530199 541947 542721 549471 554723 556090 556869 559615 559852 559853 560342 562200 576447 577052 585484 588293 594872 599592 599623 601830 604641 607873 613580 615308 618955 619815 626411 627894 628772 634362 635063 635569 636057 639680 648352 655549 658841 664630 668683 669899 669903 670623 675390 682763 689419 692713 694704 701628 702497 705726 711320 713690 718575 720502 721916 722109 722972 723173 726208 729357 730952 738951 739971 740063 741221 741583 741933 744971 746442 749409 750438 764367 771491 771534 777155 777556 777589 778186 779814 779871 780734 780742 781443 783268 783641 786388 787162 787605 788539 789037 791101 791297 793210 799297 799875 802023 802169 802804 803197 803199 803204 806955 809945 809987 811886 812047 813545 813585 813612 814057 816187 818688 819451 819536 827193 ] |
||||||||||||||||||||||||||||||
|
14.15 ms (8.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 777556 777155 542721 793210 802023 692713 813545 635569 780734 809987 814057 802804 746442 764367 827193 819451 819536 655549 615308 585484 811886 812047 741933 816187 541947 799875 635063 718575 722972 626411 556869 549471 607873 639680 788539 669899 701628 618955 786388 530199 689419 720502 787162 803199 744971 562200 627894 636057 726208 613580 560342 669903 634362 778186 813612 694704 780742 722109 802169 779814 730952 459029 594872 787605 670623 723173 648352 604641 783641 729357 789037 721916 526715 818688 524548 559852 559853 619815 803204 777589 791297 803197 740063 741221 628772 711320 741583 577052 813585 599592 809945 675390 738951 739971 419951 469153 713690 658841 705726 781443 750438 771534 682763 779871 806955 791101 556090 588293 576447 702497 668683 771491 783268 749409 664630 559615 601830 599623 554723 799297 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.65%) |
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 419951 459029 469153 524548 526715 530199 541947 542721 549471 554723 556090 556869 559615 559852 559853 560342 562200 576447 577052 585484 588293 594872 599592 599623 601830 604641 607873 613580 615308 618955 619815 626411 627894 628772 634362 635063 635569 636057 639680 648352 655549 658841 664630 668683 669899 669903 670623 675390 682763 689419 692713 694704 701628 702497 705726 711320 713690 718575 720502 721916 722109 722972 723173 726208 729357 730952 738951 739971 740063 741221 741583 741933 744971 746442 749409 750438 764367 771491 771534 777155 777556 777589 778186 779814 779871 780734 780742 781443 783268 783641 786388 787162 787605 788539 789037 791101 791297 793210 799297 799875 802023 802169 802804 803197 803199 803204 806955 809945 809987 811886 812047 813545 813585 813612 814057 816187 818688 819451 819536 827193 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"risky public"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"risky на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"risky на улиц"
]
|
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.