Query Metrics
7
Database Queries
7
Different statements
191.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.68 ms (89.47%) |
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 303426 391649 394035 396779 397499 398116 414349 477606 510727 545335 551003 553214 568017 583695 589644 609945 622850 635133 669546 709487 711050 714831 715621 718854 719401 720169 720563 721604 722315 723249 724905 725722 729071 729131 732952 733443 735790 743511 743996 744028 745996 748592 754235 754696 756197 756831 756993 757908 758710 760506 762974 763470 765958 765998 766116 766125 767678 768377 768726 768993 770101 771394 773052 776849 777244 777811 777825 778108 778127 778244 778890 782991 782997 786584 787253 787573 787607 787634 787692 787770 787837 788126 788724 789379 789567 789577 789630 791660 792758 793516 794457 794535 794729 795237 795347 795353 796357 796552 797033 797131 797567 797894 799442 800280 801104 801426 801671 801680 801930 802074 803850 805698 808439 808604 808611 809052 810857 819885 827455 ] |
||||||||||||||||||||||||||||||
|
10.73 ms (5.59%) |
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 553214 568017 796552 778244 635133 819885 827455 545335 718854 719401 721604 723249 711050 777244 787692 791660 794535 800280 810857 776849 778108 787573 787634 795347 797567 801671 801930 729071 733443 756993 782991 787253 789379 725722 735790 748592 754235 732952 743511 743996 744028 756197 760506 762974 766116 768377 745996 763261 766125 768993 771394 722315 777811 777825 778127 782997 786584 787837 795353 801426 414349 551003 622850 609945 709487 398116 477606 803850 757908 754696 589644 758710 394035 391649 303426 397499 396779 510727 583695 669546 714831 715621 778890 789577 794457 797131 801104 808611 809052 787607 787770 788126 788724 789567 789630 796357 797894 799442 801680 802074 767678 793516 797033 805698 808439 808604 765998 770101 763470 765958 768726 773052 724905 729131 756831 720169 720563 792758 794729 795237 ] |
||||||||||||||||||||||||||||||
|
2.99 ms (1.56%) |
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 303426 391649 394035 396779 397499 398116 414349 477606 510727 545335 551003 553214 568017 583695 589644 609945 622850 635133 669546 709487 711050 714831 715621 718854 719401 720169 720563 721604 722315 723249 724905 725722 729071 729131 732952 733443 735790 743511 743996 744028 745996 748592 754235 754696 756197 756831 756993 757908 758710 760506 762974 763470 765958 765998 766116 766125 767678 768377 768726 768993 770101 771394 773052 776849 777244 777811 777825 778108 778127 778244 778890 782991 782997 786584 787253 787573 787607 787634 787692 787770 787837 788126 788724 789379 789567 789577 789630 791660 792758 793516 794457 794535 794729 795237 795347 795353 796357 796552 797033 797131 797567 797894 799442 800280 801104 801426 801671 801680 801930 802074 803850 805698 808439 808604 808611 809052 810857 819885 827455 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"на дом"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.25 ms (0.65%) |
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.