Query Metrics
7
Database Queries
7
Different statements
159.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.51 ms (85.72%) |
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 152027 479446 507815 532135 536727 544749 545420 547656 553889 556060 563064 575636 616573 644989 695849 702522 707774 708399 718498 718587 718848 720104 722443 723733 725227 726539 726564 729738 730370 733387 733588 733946 734929 736258 738310 738404 738618 739409 739739 740645 742195 742812 742889 742912 742949 743679 743800 744637 744728 745252 746381 746932 746993 749751 749940 752787 755576 757003 757846 758328 761359 761685 762015 763629 771344 779894 780485 780628 780667 782394 782440 783138 785171 785650 787936 788098 788411 788945 789003 789089 789113 789829 791747 792441 795093 795611 796859 798860 802016 802186 802187 804376 804513 804827 804853 808128 810316 810711 810894 812559 812908 812996 816693 817652 818083 818937 820079 820086 821800 821861 823910 824005 824145 824860 825078 825682 826645 826734 827153 827465 ] |
||||||||||||||||||||||||||||||
|
11.39 ms (7.15%) |
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 817652 821800 816693 818937 824145 827153 820086 479446 536727 575636 563064 708399 720104 695849 785171 789113 795093 796859 798860 804513 780628 782440 802186 802187 744637 758328 791747 804827 808128 739739 749751 761685 762015 746993 742812 745252 746932 789003 795611 802016 804853 810316 152027 788945 792441 556060 507815 818083 824860 825078 644989 826645 826734 820079 824005 821861 823910 825682 827465 532135 553889 545420 547656 707774 718587 718498 718848 722443 544749 616573 779894 788411 810711 789089 812996 725227 729738 733387 738404 740645 742195 742889 743679 782394 785650 810894 812559 733946 736258 738310 742949 744728 749940 757846 723733 726564 730370 734929 738618 746381 752787 726539 739409 742912 743800 755576 761359 763629 733588 757003 771344 702522 780485 780667 783138 787936 788098 789829 804376 812908 ] |
||||||||||||||||||||||||||||||
|
3.31 ms (2.08%) |
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 152027 479446 507815 532135 536727 544749 545420 547656 553889 556060 563064 575636 616573 644989 695849 702522 707774 708399 718498 718587 718848 720104 722443 723733 725227 726539 726564 729738 730370 733387 733588 733946 734929 736258 738310 738404 738618 739409 739739 740645 742195 742812 742889 742912 742949 743679 743800 744637 744728 745252 746381 746932 746993 749751 749940 752787 755576 757003 757846 758328 761359 761685 762015 763629 771344 779894 780485 780628 780667 782394 782440 783138 785171 785650 787936 788098 788411 788945 789003 789089 789113 789829 791747 792441 795093 795611 796859 798860 802016 802186 802187 804376 804513 804827 804853 808128 810316 810711 810894 812559 812908 812996 816693 817652 818083 818937 820079 820086 821800 821861 823910 824005 824145 824860 825078 825682 826645 826734 827153 827465 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade old"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.25%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск old"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск old"
]
|
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.