Query Metrics
7
Database Queries
7
Different statements
188.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.16 ms (83.43%) |
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 385411 389132 400518 424242 433376 460374 530564 541819 543561 543899 543941 545878 546291 551488 556173 561758 582522 599613 608528 612789 619907 628880 632077 642095 648607 650645 654377 655565 658363 659425 674309 676920 689762 694615 696110 697994 705358 715444 720952 723020 724966 725247 731889 733744 734323 734970 735987 741496 747572 748801 751300 754063 754584 755138 755866 766355 778198 778710 779418 779665 782368 790292 791426 791883 792272 794305 794816 795243 795715 796359 796925 798676 800595 802139 804936 811132 812468 813093 816611 816743 818051 818053 818760 818761 818763 818771 819800 819853 819893 819918 819924 819928 819935 820031 820077 820110 820197 820311 821755 821802 823645 823817 824230 824401 824660 824816 824849 825172 825716 825717 825972 825978 826379 826691 826757 827147 827967 828770 ] |
||||||||||||||||||||||||||||||
|
20.35 ms (10.80%) |
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 650645 696110 705358 723020 655565 689762 715444 628880 612789 619907 778198 790292 811132 740079 795243 802139 804936 766355 748801 795715 400518 642095 433376 820311 826691 819924 543899 543941 556173 582522 546291 791883 735987 792272 794305 813093 545878 821755 825716 827147 818051 816611 827967 460374 543561 654377 676920 599613 798676 779418 794309 731889 755866 796359 734970 754584 697994 779665 782368 674309 385411 424242 389132 800595 561758 658363 530564 541819 551488 659425 720952 648607 694615 608528 778710 794816 724966 725247 733744 755138 734323 747572 751300 754063 741496 632077 791426 796925 812468 819893 819918 819928 821802 824401 816743 818761 818771 820031 823645 824660 824816 825172 825978 826757 818053 818760 818763 819853 819935 820077 820110 823817 824230 824849 825717 819800 820197 825972 826379 828770 ] |
||||||||||||||||||||||||||||||
|
3.69 ms (1.96%) |
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 385411 389132 400518 424242 433376 460374 530564 541819 543561 543899 543941 545878 546291 551488 556173 561758 582522 599613 608528 612789 619907 628880 632077 642095 648607 650645 654377 655565 658363 659425 674309 676920 689762 694615 696110 697994 705358 715444 720952 723020 724966 725247 731889 733744 734323 734970 735987 741496 747572 748801 751300 754063 754584 755138 755866 766355 778198 778710 779418 779665 782368 790292 791426 791883 792272 794305 794816 795243 795715 796359 796925 798676 800595 802139 804936 811132 812468 813093 816611 816743 818051 818053 818760 818761 818763 818771 819800 819853 819893 819918 819924 819928 819935 820031 820077 820110 820197 820311 821755 821802 823645 823817 824230 824401 824660 824816 824849 825172 825716 825717 825972 825978 826379 826691 826757 827147 827967 828770 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass ukrainian"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп русск"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.