Query Metrics
7
Database Queries
7
Different statements
259.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
230.92 ms (88.95%) |
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 473323 534864 535359 535396 540055 540104 540117 541190 542475 542721 551221 552587 560493 561202 562529 562936 567891 568375 570893 572734 573989 575383 581180 584360 590606 603959 606114 606220 608047 611413 611687 611954 614385 617242 618072 618189 619646 621168 623236 627851 632282 634369 635057 635569 635720 637988 650037 650226 652563 661353 661383 661387 673996 683766 689266 692824 695594 695665 695969 696049 696062 696642 702370 714040 715963 717224 719889 728276 731031 731147 732584 733021 739718 745074 749572 749860 751242 758942 758949 767495 768591 768765 771514 773498 775130 775815 777601 778765 779324 779820 780734 781482 782745 784104 784264 785454 785526 786588 787145 789066 790647 791494 793050 795992 797920 807275 808304 809987 811853 812245 813329 813545 819148 820442 821477 828016 ] |
||||||||||||||||||||||||||||||
|
18.83 ms (7.25%) |
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 813545 473323 535359 534864 535396 562529 573989 575383 542475 542721 552587 541190 551221 560493 567891 572734 650226 661383 689266 692824 696049 696642 714040 717224 719889 661353 673996 695665 695969 696062 650037 661387 683766 584360 606114 635569 621168 634369 603959 606220 611687 635720 590606 608047 611413 614385 618072 618189 619646 623236 779324 780734 785526 786588 790647 807275 778765 782745 791494 809987 731031 751242 758949 768765 784104 793050 739718 749860 733021 769831 732584 745074 768591 728276 731147 758942 771514 773498 611954 617242 627851 635057 775130 775815 779820 781482 785454 813329 820442 819148 821477 828016 828355 540055 540104 540117 561202 562936 570893 581180 652563 702370 715963 695594 568375 599767 637988 777601 808304 784264 787145 795992 797920 811853 812245 749572 767495 632282 789066 828251 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.12%) |
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 473323 534864 535359 535396 540055 540104 540117 541190 542475 542721 551221 552587 560493 561202 562529 562936 567891 568375 570893 572734 573989 575383 581180 584360 590606 603959 606114 606220 608047 611413 611687 611954 614385 617242 618072 618189 619646 621168 623236 627851 632282 634369 635057 635569 635720 637988 650037 650226 652563 661353 661383 661387 673996 683766 689266 692824 695594 695665 695969 696049 696062 696642 702370 714040 715963 717224 719889 728276 731031 731147 732584 733021 739718 745074 749572 749860 751242 758942 758949 767495 768591 768765 771514 773498 775130 775815 777601 778765 779324 779820 780734 781482 782745 784104 784264 785454 785526 786588 787145 789066 790647 791494 793050 795992 797920 807275 808304 809987 811853 812245 813329 813545 819148 820442 821477 828016 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"улиц"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.73%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"улице"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"улиц"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.59%) |
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.