Query Metrics
7
Database Queries
7
Different statements
190.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
167.64 ms (87.90%) |
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 2595 76906 117425 155291 160270 168297 181926 382931 383096 390805 394582 412158 441541 531618 531801 536208 537294 544774 550936 566700 572089 574758 577045 584387 584664 595599 598789 601304 624093 638014 644101 648199 651801 655841 665482 667084 667138 670255 670395 670987 673437 673813 676518 684799 691422 700911 703111 707093 718863 719814 719892 720205 720378 721091 721806 722772 722960 726641 729416 729786 731380 731490 731878 744740 754061 754220 755017 756090 758882 759213 759544 762136 763776 764696 764861 767313 767555 767847 768699 774640 778547 778667 779623 781212 782578 782590 782739 783178 783275 784214 786590 786746 786997 788957 791586 792248 792838 793714 795086 795119 795607 795899 796323 798890 799303 799521 802863 804360 807932 811049 812213 817818 820154 821072 822278 823193 824093 825468 825779 ] |
||||||||||||||||||||||||||||||
|
12.66 ms (6.64%) |
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 799521 812213 2595 759544 382931 719814 729786 767847 784214 574758 577045 729416 767313 791586 412158 821072 824093 825779 537294 665482 703111 700911 667138 673813 676518 624093 601304 781212 793714 774640 786590 792838 798890 802863 786997 731380 767555 762136 755017 759213 726641 731490 744740 720378 778667 779623 782578 795607 390805 383096 76906 394582 441541 822278 823193 670987 673437 722772 670255 598789 795899 807932 778547 782739 786746 758882 788957 799303 811049 764861 754220 756090 763776 764696 783275 804360 168297 160270 817818 820154 531801 572089 584387 651801 648199 720205 722960 595599 644101 638014 778252 782590 792248 795086 796323 754061 731878 768699 707093 721806 783178 795119 117425 155291 181926 825468 536208 531618 566700 550936 544774 584664 655841 670395 684799 691422 718863 719892 721091 667084 ] |
||||||||||||||||||||||||||||||
|
4.04 ms (2.12%) |
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 2595 76906 117425 155291 160270 168297 181926 382931 383096 390805 394582 412158 441541 531618 531801 536208 537294 544774 550936 566700 572089 574758 577045 584387 584664 595599 598789 601304 624093 638014 644101 648199 651801 655841 665482 667084 667138 670255 670395 670987 673437 673813 676518 684799 691422 700911 703111 707093 718863 719814 719892 720205 720378 721091 721806 722772 722960 726641 729416 729786 731380 731490 731878 744740 754061 754220 755017 756090 758882 759213 759544 762136 763776 764696 764861 767313 767555 767847 768699 774640 778547 778667 779623 781212 782578 782590 782739 783178 783275 784214 786590 786746 786997 788957 791586 792248 792838 793714 795086 795119 795607 795899 796323 798890 799303 799521 802863 804360 807932 811049 812213 817818 820154 821072 822278 823193 824093 825468 825779 ] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sweet sex"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.83%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"милая секс"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.74%) |
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.