Query Metrics
7
Database Queries
7
Different statements
194.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.19 ms (86.29%) |
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 387693 395184 415223 417238 421807 425592 441978 447416 462167 463199 473766 475588 476438 477187 479978 481734 484928 493770 513888 515455 518031 523247 525443 525935 527573 538055 538436 539244 540736 543734 550691 550718 553109 556580 558816 560157 564019 566778 567240 568165 569014 573477 574964 579311 579368 580702 581168 581701 582218 584358 584540 585717 589015 589510 591640 592906 592924 594770 595855 598568 599791 603937 606783 612014 618895 627745 630612 636252 638457 639669 652760 668087 672744 678608 678671 680251 694119 732001 742507 756259 757340 758891 766021 767480 768179 772635 777700 778662 778800 781099 791268 797355 799809 800868 802016 804532 804918 810032 810544 810566 810775 813183 814220 817746 819444 820313 821370 821605 823049 823244 824014 824644 825696 827535 827857 827869 827887 827890 827912 828653 ] |
||||||||||||||||||||||||||||||
|
14.92 ms (7.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 525935 558816 560157 579311 581168 581701 584358 580702 582218 594770 598568 585717 603937 589015 618895 630612 810775 758891 766021 479978 473766 477187 447416 463199 475588 527573 515455 525443 592906 742507 417238 481734 425592 395184 564019 568165 553109 652760 606783 804532 756259 639669 800868 441978 817746 819444 827535 823049 825696 827890 827912 828653 540736 538055 550691 543734 574964 567240 589510 638457 781099 810544 777700 778662 804918 810566 767480 813183 757340 768179 772635 778800 791268 797355 799809 802016 387693 421807 462167 415223 814220 821370 821605 476438 484928 573477 579368 584540 569014 550718 591640 627745 513888 518031 672744 694119 680251 599791 810032 732001 595855 824644 820313 824014 823244 827869 827857 827887 493770 538436 539244 523247 566778 556580 668087 678608 678671 592924 636252 612014 ] |
||||||||||||||||||||||||||||||
|
4.40 ms (2.26%) |
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 387693 395184 415223 417238 421807 425592 441978 447416 462167 463199 473766 475588 476438 477187 479978 481734 484928 493770 513888 515455 518031 523247 525443 525935 527573 538055 538436 539244 540736 543734 550691 550718 553109 556580 558816 560157 564019 566778 567240 568165 569014 573477 574964 579311 579368 580702 581168 581701 582218 584358 584540 585717 589015 589510 591640 592906 592924 594770 595855 598568 599791 603937 606783 612014 618895 627745 630612 636252 638457 639669 652760 668087 672744 678608 678671 680251 694119 732001 742507 756259 757340 758891 766021 767480 768179 772635 777700 778662 778800 781099 791268 797355 799809 800868 802016 804532 804918 810032 810544 810566 810775 813183 814220 817746 819444 820313 821370 821605 823049 823244 824014 824644 825696 827535 827857 827869 827887 827890 827912 828653 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"pov young in"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов young"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пов young"
]
|
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.