Query Metrics
7
Database Queries
7
Different statements
159.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.95 ms (84.41%) |
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 118900 420013 420015 425405 458380 472799 511580 513122 513986 514702 528943 530408 530638 530710 533077 534014 534712 539052 539582 540124 541102 541152 541488 541750 541815 542468 543025 546336 547070 547763 550166 550172 550470 554684 554831 555438 567496 570932 574656 574711 579127 579523 581000 586086 592666 599647 604090 605248 606123 608702 610268 614384 617713 618060 618951 622726 628592 629836 634375 634381 634453 634855 638463 641479 654083 660356 661339 668538 669903 682229 682886 690215 692715 707812 717383 731705 735672 738651 739397 746098 747124 751408 751422 752477 752503 752765 753994 759155 766084 766123 778537 779368 785401 785414 785420 786186 786948 787633 789676 790112 790421 790881 796338 797199 798772 803025 804263 804350 804826 810621 812243 813802 814165 816816 816839 816852 816862 819121 824502 827248 ] |
||||||||||||||||||||||||||||||
|
14.28 ms (8.94%) |
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 541750 541815 546336 541102 542468 550172 574711 554831 668538 604090 628592 634855 599647 618951 796338 804350 810621 812243 752477 618060 804263 425405 458380 579127 669903 752765 746098 751422 707812 514702 472799 816816 824502 816839 816852 827248 816862 819121 513122 539582 528943 530408 534712 533077 540124 534014 539052 567496 581000 541152 543025 550166 660356 717383 682229 690215 555438 638463 605248 622726 790112 790421 790881 778537 798772 739397 753994 766123 785414 787633 752503 779368 785401 786186 804826 554684 586086 814165 511580 550470 541488 682886 692715 654083 570932 592666 608702 634453 610268 614384 634375 634381 789676 803025 747124 731705 766084 735672 738651 617713 629836 785420 786948 797199 118900 530710 759155 420015 606123 513986 661339 420013 813802 530638 579523 547763 547070 574656 641479 751408 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (1.92%) |
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 118900 420013 420015 425405 458380 472799 511580 513122 513986 514702 528943 530408 530638 530710 533077 534014 534712 539052 539582 540124 541102 541152 541488 541750 541815 542468 543025 546336 547070 547763 550166 550172 550470 554684 554831 555438 567496 570932 574656 574711 579127 579523 581000 586086 592666 599647 604090 605248 606123 608702 610268 614384 617713 618060 618951 622726 628592 629836 634375 634381 634453 634855 638463 641479 654083 660356 661339 668538 669903 682229 682886 690215 692715 707812 717383 731705 735672 738651 739397 746098 747124 751408 751422 752477 752503 752765 753994 759155 766084 766123 778537 779368 785401 785414 785420 786186 786948 787633 789676 790112 790421 790881 796338 797199 798772 803025 804263 804350 804826 810621 812243 813802 814165 816816 816839 816852 816862 819121 824502 827248 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public toilette solo"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.17%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на toilette улиц соло"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"на toilette улиц соло"
]
|
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.