Query Metrics
7
Database Queries
7
Different statements
145.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.96 ms (83.60%) |
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 94897 386325 492637 496326 530226 543538 557057 574796 595066 609717 610191 618411 618819 619859 621117 622926 626783 637929 652657 659375 663491 663904 663911 665217 665877 666807 667289 673455 699457 704144 706667 708871 709383 710994 714584 715576 715601 715678 718427 721184 730272 733393 733933 734005 734171 734340 737337 741135 742145 742830 745944 746639 748020 750165 753502 755757 763090 763380 764991 765154 765936 771387 772823 773509 776508 778312 778942 779508 779559 780287 781202 781344 782099 785265 788077 789194 792443 794579 795080 795831 797543 799316 800078 801922 802281 802348 802429 808876 810151 811717 812813 814205 814578 815933 816595 816600 816616 817227 817999 818570 819290 819477 819790 819967 820833 821326 823578 824607 825248 825380 826088 826312 826451 826456 826750 827421 827575 827582 827704 ] |
||||||||||||||||||||||||||||||
|
12.66 ms (8.67%) |
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 557057 622926 823722 715678 811717 94897 825380 802429 817999 821326 826312 826451 816600 819790 492637 574796 667289 618819 799316 808876 778942 781344 765154 812813 734340 745944 699457 789194 715576 610191 721184 814205 827575 819477 637929 771387 742145 772823 781202 826456 826088 609717 810151 800078 802348 742830 827582 819290 814578 652657 779508 733393 741135 782099 763380 730272 755757 765936 820833 825248 826750 827421 819967 823578 530226 659375 663911 706667 708871 715601 626783 595066 619859 778312 792443 780287 788077 794579 737337 748020 763090 785265 734171 714584 797543 386325 824607 665217 710994 666807 776508 802281 764991 746639 750165 718427 816616 818570 827704 496326 709383 673455 618411 779559 801922 734005 795080 753502 817227 816595 815933 543538 663491 663904 665877 704144 621117 795831 733933 773509 ] |
||||||||||||||||||||||||||||||
|
3.50 ms (2.40%) |
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 94897 386325 492637 496326 530226 543538 557057 574796 595066 609717 610191 618411 618819 619859 621117 622926 626783 637929 652657 659375 663491 663904 663911 665217 665877 666807 667289 673455 699457 704144 706667 708871 709383 710994 714584 715576 715601 715678 718427 721184 730272 733393 733933 734005 734171 734340 737337 741135 742145 742830 745944 746639 748020 750165 753502 755757 763090 763380 764991 765154 765936 771387 772823 773509 776508 778312 778942 779508 779559 780287 781202 781344 782099 785265 788077 789194 792443 794579 795080 795831 797543 799316 800078 801922 802281 802348 802429 808876 810151 811717 812813 814205 814578 815933 816595 816600 816616 817227 817999 818570 819290 819477 819790 819967 820833 821326 823578 824607 825248 825380 826088 826312 826451 826456 826750 827421 827575 827582 827704 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"him fuck"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"him секс"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"him секс"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.12%) |
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.