Query Metrics
7
Database Queries
7
Different statements
149.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.69 ms (85.53%) |
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 551113 551811 576918 580853 584961 585944 586934 589857 591818 596441 600993 603567 606064 606358 606516 610642 611144 612586 613879 614560 615922 616243 618961 620908 629964 632048 633602 634941 635835 636472 638184 639574 641567 650058 652850 656096 668750 678586 679044 679049 679067 679096 679114 679135 690834 690855 690913 691458 693039 693041 693860 694052 694495 694522 694562 695405 695621 695631 695634 695635 696097 696278 697373 698548 699390 699743 701535 709358 714954 716288 716640 720008 722448 725540 726365 728022 728850 730222 732551 733500 734929 736107 736844 737328 738054 738462 740461 742551 742906 744677 745488 747503 748304 748689 752509 755358 756373 757680 761077 762339 767066 769828 771038 773388 774251 777957 779187 783381 784388 793231 796101 798993 799448 800319 800750 800971 801053 801440 801733 804503 ] |
||||||||||||||||||||||||||||||
|
11.09 ms (7.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 679044 679067 690855 690913 691458 693039 694052 694495 694522 695405 695631 696278 716640 678586 679096 679114 679135 690834 693860 694562 695621 695634 698548 699390 699743 701535 709358 716288 720008 650058 652850 656096 668750 679049 693041 695635 696097 697373 714954 722448 551113 551811 576918 580853 584961 586934 606064 610642 613879 614560 616243 632048 635835 641567 589857 596441 606358 606516 611144 633602 636472 638184 639574 600993 615922 629964 634941 585944 591818 603567 612586 618961 620908 793231 796101 798993 800319 800971 801053 804503 777957 779187 799448 800750 801440 725540 728850 730222 738054 742906 756373 769828 783381 784388 801733 732551 736844 747503 761077 726365 728022 733500 734929 736107 737328 740461 745488 752509 755358 773388 774251 738462 742551 748304 748689 757680 762339 767066 771038 744677 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.90%) |
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 551113 551811 576918 580853 584961 585944 586934 589857 591818 596441 600993 603567 606064 606358 606516 610642 611144 612586 613879 614560 615922 616243 618961 620908 629964 632048 633602 634941 635835 636472 638184 639574 641567 650058 652850 656096 668750 678586 679044 679049 679067 679096 679114 679135 690834 690855 690913 691458 693039 693041 693860 694052 694495 694522 694562 695405 695621 695631 695634 695635 696097 696278 697373 698548 699390 699743 701535 709358 714954 716288 716640 720008 722448 725540 726365 728022 728850 730222 732551 733500 734929 736107 736844 737328 738054 738462 740461 742551 742906 744677 745488 747503 748304 748689 752509 755358 756373 757680 761077 762339 767066 769828 771038 773388 774251 777957 779187 783381 784388 793231 796101 798993 799448 800319 800750 800971 801053 801440 801733 804503 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.62%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"два"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"два"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.