Query Metrics
7
Database Queries
7
Different statements
164.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.26 ms (86.64%) |
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 3371 3826 73571 73672 73774 74302 74426 238771 358879 389661 395939 455746 478103 481088 496385 516738 530615 547259 550546 559087 567465 567471 572590 590654 591939 592542 607055 626187 635647 638524 641200 656219 670079 670754 680606 687132 689167 690494 690925 692154 693437 694164 699162 704432 704434 705365 706439 712520 712812 714229 714252 714693 719283 720987 722440 725079 725766 730792 730840 731142 732336 732827 739688 744376 745857 745882 745904 748841 748844 749779 757937 758235 759051 760219 760510 762019 766253 766303 768029 768565 768841 773473 777949 778175 786158 790395 790718 791310 791795 792028 793860 794157 794523 796554 798940 804917 810393 810586 811209 812086 812264 813456 818431 818844 819050 819079 819998 820689 820749 823812 824516 824539 824701 825118 825775 825867 826755 827448 827471 828397 ] |
||||||||||||||||||||||||||||||
|
11.47 ms (6.99%) |
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 455746 592542 812086 656219 559087 481088 725079 824516 828397 798940 739688 238771 824539 826755 478103 547259 670754 766253 811209 687132 778175 792028 760510 827448 572590 796554 496385 689167 714252 793860 730840 773473 768565 825775 607055 722440 74302 395939 358879 73672 825118 516738 670079 680606 730792 758235 719283 73774 820749 626187 635647 777949 748841 819050 705365 794157 810586 73571 389661 567471 712812 714229 714693 567465 591939 790395 810393 745882 768841 641200 820689 693437 590654 762019 732336 813456 818844 824701 530615 692154 3826 819079 818431 712520 690494 786158 791310 766303 3371 819998 827471 550546 690925 699162 694164 704434 706439 704432 638524 790718 804917 812264 760219 794523 732827 749779 745857 748844 759051 768029 725766 731142 757937 744376 745904 791795 74426 825867 823812 720987 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.73%) |
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 3371 3826 73571 73672 73774 74302 74426 238771 358879 389661 395939 455746 478103 481088 496385 516738 530615 547259 550546 559087 567465 567471 572590 590654 591939 592542 607055 626187 635647 638524 641200 656219 670079 670754 680606 687132 689167 690494 690925 692154 693437 694164 699162 704432 704434 705365 706439 712520 712812 714229 714252 714693 719283 720987 722440 725079 725766 730792 730840 731142 732336 732827 739688 744376 745857 745882 745904 748841 748844 749779 757937 758235 759051 760219 760510 762019 766253 766303 768029 768565 768841 773473 777949 778175 786158 790395 790718 791310 791795 792028 793860 794157 794523 796554 798940 804917 810393 810586 811209 812086 812264 813456 818431 818844 819050 819079 819998 820689 820749 823812 824516 824539 824701 825118 825775 825867 826755 827448 827471 828397 ] |
||||||||||||||||||||||||||||||
|
2.24 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex-couple"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс couple"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс couple"
]
|
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.