Query Metrics
7
Database Queries
7
Different statements
179.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.94 ms (85.83%) |
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 207630 300984 389676 400884 483995 485016 486475 489119 490594 502544 504028 531595 532414 541017 543317 544877 545743 546146 547573 549031 554170 558674 559313 563685 567629 574143 576597 576791 578171 578510 585240 597663 599238 612169 612636 614222 614802 616381 616569 617568 619620 621382 623071 625209 626176 631459 634934 640361 641571 644218 650531 660383 661540 662424 666078 666094 666122 666680 666706 666713 666722 670263 684183 687103 697219 698916 705349 706895 708077 708706 708743 709611 709746 710229 710439 710856 712140 713440 714389 714418 722122 722681 724503 726636 728989 728996 732094 734661 735391 736044 739774 742280 743962 749493 749593 751230 771424 778481 781771 783924 788539 792711 793565 794430 794574 796466 796490 796741 801816 802219 802307 803136 803507 803927 804257 804738 807827 807850 811443 ] |
||||||||||||||||||||||||||||||
|
14.87 ms (8.29%) |
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 666094 709611 708706 641571 794574 751230 543317 490594 400884 502544 531595 541017 574143 545743 547573 567629 666122 666680 687103 698916 666722 705349 710229 650531 666078 670263 706895 710856 712140 597663 614222 614802 625209 626176 640361 616381 619620 621382 616512 616569 631459 794430 617568 634934 697219 710439 504028 489119 684183 714418 486475 742280 483995 532414 485016 546146 558674 576791 578171 549031 578510 544877 559313 563685 662424 708743 660383 666713 722681 554170 576597 623071 644218 599238 612169 778481 793565 811443 802307 803136 804257 804738 734661 771424 781771 796490 796741 802219 807850 724503 732094 735391 726636 728989 728996 749493 736044 739774 743962 749593 709746 713440 807827 389676 612636 666706 585240 207630 300984 661540 708077 714389 722122 783924 788539 792711 796466 801816 803507 803927 ] |
||||||||||||||||||||||||||||||
|
2.52 ms (1.41%) |
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 207630 300984 389676 400884 483995 485016 486475 489119 490594 502544 504028 531595 532414 541017 543317 544877 545743 546146 547573 549031 554170 558674 559313 563685 567629 574143 576597 576791 578171 578510 585240 597663 599238 612169 612636 614222 614802 616381 616569 617568 619620 621382 623071 625209 626176 631459 634934 640361 641571 644218 650531 660383 661540 662424 666078 666094 666122 666680 666706 666713 666722 670263 684183 687103 697219 698916 705349 706895 708077 708706 708743 709611 709746 710229 710439 710856 712140 713440 714389 714418 722122 722681 724503 726636 728989 728996 732094 734661 735391 736044 739774 742280 743962 749493 749593 751230 771424 778481 781771 783924 788539 792711 793565 794430 794574 796466 796490 796741 801816 802219 802307 803136 803507 803927 804257 804738 807827 807850 811443 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy amateur"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая любительск"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.90%) |
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.