Query Metrics
7
Database Queries
7
Different statements
215.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.43 ms (88.68%) |
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 24087 24158 148408 325804 383726 412616 415787 422168 423318 426480 426510 439732 439779 445204 450803 458053 460327 462198 469641 486960 489325 500911 504927 506518 506770 512688 515685 517790 523370 523412 524669 528215 538970 541094 543794 543956 547252 553478 560678 561454 563075 578642 579472 580480 580642 600863 608771 609968 612904 618861 619140 621628 646169 650711 650723 666087 666360 666914 668135 670839 701938 703689 704599 720543 726156 727322 739684 744764 750988 759019 769538 771145 780371 782770 787092 788031 789285 789639 790275 791477 794107 795346 800634 801701 803301 803874 804274 808277 810029 811864 812276 813856 816841 817803 818111 818193 818813 818914 819807 820134 820321 823820 823891 824385 824462 824479 825922 825990 826201 826210 826678 826679 827025 827085 828472 828520 828582 828688 828705 828803 ] |
||||||||||||||||||||||||||||||
|
13.53 ms (6.27%) |
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 504927 423318 426480 426510 458053 462198 524669 506518 506770 541094 561454 563075 670839 578642 580480 580642 609968 619140 800634 450803 415787 445204 538970 515685 528215 523370 469641 826201 823891 823820 826210 780371 744764 808277 726156 512688 547252 621628 460327 412616 825990 818914 828582 543956 789639 794107 827085 148408 325804 818193 826678 827025 824385 825922 650711 720543 791477 801701 804274 812276 759019 803301 739684 790275 813856 824479 646169 704599 810029 787092 523412 500911 543794 553478 600863 618861 612904 422168 439732 489325 486960 517790 820134 789285 727322 608771 439779 816841 818111 820321 826679 817803 819807 824462 828803 828520 828472 828688 828705 666360 666087 579472 782770 795346 788031 771145 769538 24158 818813 666914 803874 750988 811864 24087 668135 383726 560678 650723 701938 703689 ] |
||||||||||||||||||||||||||||||
|
3.65 ms (1.69%) |
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 24087 24158 148408 325804 383726 412616 415787 422168 423318 426480 426510 439732 439779 445204 450803 458053 460327 462198 469641 486960 489325 500911 504927 506518 506770 512688 515685 517790 523370 523412 524669 528215 538970 541094 543794 543956 547252 553478 560678 561454 563075 578642 579472 580480 580642 600863 608771 609968 612904 618861 619140 621628 646169 650711 650723 666087 666360 666914 668135 670839 701938 703689 704599 720543 726156 727322 739684 744764 750988 759019 769538 771145 780371 782770 787092 788031 789285 789639 790275 791477 794107 795346 800634 801701 803301 803874 804274 808277 810029 811864 812276 813856 816841 817803 818111 818193 818813 818914 819807 820134 820321 823820 823891 824385 824462 824479 825922 825990 826201 826210 826678 826679 827025 827085 828472 828520 828582 828688 828705 828803 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в туалете жену"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"туалет жен"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"туалет жен"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.73%) |
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.