Query Metrics
7
Database Queries
7
Different statements
299.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
268.81 ms (89.76%) |
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 204778 458948 467061 613099 625534 627017 633591 705495 708317 710419 710437 711890 712813 713352 724118 726641 727448 730766 731120 731218 731386 732499 733015 733233 733264 733759 733944 733962 734990 735783 737150 738139 740195 741056 742051 743141 743851 744188 744689 745284 746409 746452 747178 747618 747644 748340 748423 748679 749812 753281 753578 753718 754302 754458 754528 755277 757119 757356 757486 758851 759383 761072 761242 762694 763804 763935 764083 764240 764632 765080 765273 765366 765753 765797 767911 768447 769080 769383 769833 770866 771052 771318 771485 772675 773179 773749 773852 775051 776546 776966 778132 778552 781363 783079 783164 786765 787437 787642 789167 789680 789855 793324 795284 796857 796985 797109 797143 800861 801594 801773 803181 805057 807222 808816 810164 811204 811804 ] |
||||||||||||||||||||||||||||||
|
18.43 ms (6.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 733233 733962 735783 743851 744936 747618 753281 754528 757356 761242 763935 765080 765273 769080 773179 781363 783079 783164 786765 787642 789167 789855 795284 796857 797109 797143 801594 803181 805057 808816 811804 727448 733015 733759 737150 738139 742051 744188 745284 747644 753718 754302 757119 758851 769383 771052 771485 747178 753578 757486 764083 764240 765366 765753 767911 770866 772838 724118 730766 732499 733264 733944 740195 741056 743141 744689 746452 748679 754458 755277 759383 762694 763699 763804 764632 768447 771318 773852 726641 731120 731218 731386 734990 746409 748340 748423 749812 761072 765797 769833 772675 773749 613099 625534 627017 633591 705495 708317 710419 710437 711890 712813 713352 775051 776546 776966 778132 778552 787437 789680 793324 796985 800861 801773 807222 810164 811204 458948 467061 204778 ] |
||||||||||||||||||||||||||||||
|
3.56 ms (1.19%) |
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 204778 458948 467061 613099 625534 627017 633591 705495 708317 710419 710437 711890 712813 713352 724118 726641 727448 730766 731120 731218 731386 732499 733015 733233 733264 733759 733944 733962 734990 735783 737150 738139 740195 741056 742051 743141 743851 744188 744689 745284 746409 746452 747178 747618 747644 748340 748423 748679 749812 753281 753578 753718 754302 754458 754528 755277 757119 757356 757486 758851 759383 761072 761242 762694 763804 763935 764083 764240 764632 765080 765273 765366 765753 765797 767911 768447 769080 769383 769833 770866 771052 771318 771485 772675 773179 773749 773852 775051 776546 776966 778132 778552 781363 783079 783164 786765 787437 787642 789167 789680 789855 793324 795284 796857 796985 797109 797143 800861 801594 801773 803181 805057 807222 808816 810164 811204 811804 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"люба"
]
|
||||||||||||||||||||||||||||||
|
2.35 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"люб"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.59%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"люб"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.