Query Metrics
7
Database Queries
7
Different statements
348.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.37 ms (60.38%) |
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 558496 561972 562564 563667 572959 586759 592150 593974 608380 624978 641176 644222 651296 679178 679191 679506 686347 692657 694751 697934 701660 705164 710094 711637 711773 713145 718068 722169 736963 738928 739124 739432 740384 740502 742847 744153 744461 746094 746425 749596 750391 751050 751352 756773 757070 757567 757910 758673 761142 761863 769066 769277 769963 770517 772951 772976 773290 773313 773317 774850 776994 777851 779615 779784 780039 780104 780848 781356 781426 782137 782584 782808 783020 783218 783966 784017 784407 784651 784846 785775 785974 786899 789849 790399 791301 791523 791542 791724 793110 793283 794840 795400 796999 798265 800954 801557 801626 801969 802504 806651 807261 808540 808542 809127 810777 811264 811570 811706 813369 813921 813926 814695 818062 818536 818751 819832 824102 826363 826455 827502 ] |
||||||||||||||||||||||||||||||
|
119.08 ms (34.18%) |
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 558496 561972 562564 563667 572959 586759 592150 593974 608380 624978 641176 644222 651296 679178 679191 679506 686347 692657 694751 697934 701660 705164 710094 711637 711773 713145 718068 722169 736963 738928 739124 739432 740384 740502 742847 744153 744461 746094 746425 749596 750391 751050 751352 756773 757070 757567 757910 758673 761142 761863 769066 769277 769963 770517 772951 772976 773290 773313 773317 774850 776994 777851 779615 779784 780039 780104 780848 781356 781426 782137 782584 782808 783020 783218 783966 784017 784407 784651 784846 785775 785974 786899 789849 790399 791301 791523 791542 791724 793110 793283 794840 795400 796999 798265 800954 801557 801626 801969 802504 806651 807261 808540 808542 809127 810777 811264 811570 811706 813369 813921 813926 814695 818062 818536 818751 819832 824102 826363 826455 827502 ] |
||||||||||||||||||||||||||||||
|
11.55 ms (3.32%) |
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 810777 811264 736963 739124 744461 769066 769963 772976 773290 740384 740502 749596 756773 773313 739432 742847 746094 751352 757567 744153 750391 757070 758673 761863 772951 773317 608380 641176 718068 722169 774850 776994 777851 779615 780848 782584 783966 785974 794840 806651 811570 811706 819832 694751 701660 679506 791542 808540 770517 761142 796999 558496 780039 751050 757910 808542 738928 814695 818751 827502 818062 824102 813921 813926 818536 826455 826363 563667 561972 572959 651296 705164 711637 711773 679178 692657 710094 713145 679191 686347 697934 562564 592150 586759 593974 624978 644222 780104 782808 783020 784017 784407 784846 785775 786899 790399 791724 793283 795400 807261 813369 779784 781426 782137 783218 791301 798265 800954 801626 802504 809127 746425 769277 781356 784651 789849 791523 793110 801557 801969 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (0.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"любительский onlyfans мастурбация"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.59%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск онлифанс социальн сет мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск онлифанс социальн сет мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.45%) |
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.