Query Metrics
7
Database Queries
7
Different statements
138.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.37 ms (83.16%) |
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 396335 482418 482884 483380 502781 508102 512596 533164 544462 546101 547084 551466 572277 576934 588133 588162 588906 614665 618157 618928 622288 626299 627714 630917 644781 645058 649071 650881 653648 661601 681509 687024 691434 704006 721125 723438 728116 731565 732016 733661 735388 743647 748385 762493 764433 764696 765033 766384 768611 770601 770792 771288 772792 773097 774311 775509 775672 776983 778159 778787 781110 782537 783055 783463 784140 784798 785313 787419 787853 788047 788675 789809 790609 791063 791174 791637 792075 792166 792201 792402 792659 794308 794353 796256 796596 796601 797419 797429 797565 798105 799577 802626 809764 813751 816827 817248 817658 817952 817970 817990 817995 818095 818677 819525 820218 820468 820528 821778 821925 823212 827588 827833 827836 827857 827887 827890 828460 ] |
||||||||||||||||||||||||||||||
|
13.08 ms (9.43%) |
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 802626 483380 774311 731565 588133 813751 817248 817952 818677 817995 820218 823212 827833 645058 649071 650881 691434 721125 681509 627714 622288 778787 796601 799577 781110 792659 797419 766384 770792 788047 790609 794308 794353 735388 728116 763812 748385 764696 626299 775509 775672 783055 784140 787853 788675 791174 792201 796596 798105 809764 512596 533164 630917 791637 773097 782537 817970 482418 508102 817658 820468 816827 818095 819525 820528 821778 827890 482884 502781 544462 546101 547084 551466 576934 653648 687024 723438 661601 704006 572277 588906 588162 614665 776983 792166 797429 797565 778159 772792 783463 784798 785313 787419 789809 732016 771288 733661 764433 765033 768611 772129 762493 743647 768119 644781 791063 792402 796256 792075 618157 618928 770601 396335 817990 821925 827836 827588 827857 827887 828460 ] |
||||||||||||||||||||||||||||||
|
3.19 ms (2.30%) |
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 396335 482418 482884 483380 502781 508102 512596 533164 544462 546101 547084 551466 572277 576934 588133 588162 588906 614665 618157 618928 622288 626299 627714 630917 644781 645058 649071 650881 653648 661601 681509 687024 691434 704006 721125 723438 728116 731565 732016 733661 735388 743647 748385 762493 764433 764696 765033 766384 768611 770601 770792 771288 772792 773097 774311 775509 775672 776983 778159 778787 781110 782537 783055 783463 784140 784798 785313 787419 787853 788047 788675 789809 790609 791063 791174 791637 792075 792166 792201 792402 792659 794308 794353 796256 796596 796601 797419 797429 797565 798105 799577 802626 809764 813751 816827 817248 817658 817952 817970 817990 817995 818095 818677 819525 820218 820468 820528 821778 821925 823212 827588 827833 827836 827857 827887 827890 828460 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.65%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"best pov"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"best пов"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"best пов"
]
|
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.