Query Metrics
7
Database Queries
7
Different statements
231.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
207.34 ms (89.56%) |
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 30967 322090 395332 397089 397417 406724 409613 415451 416863 417733 421068 421412 422280 424541 434992 440947 450160 484304 504748 520163 528848 551221 552928 558048 562688 565291 566051 566287 581418 593790 596944 599318 606253 620707 621715 621979 625492 630769 638147 639882 647607 668034 671220 673860 673908 675536 684533 685432 687140 690052 692378 694661 697203 698352 705726 711358 713208 715435 718864 719457 722253 722434 722709 723819 729789 731580 733671 737587 739459 743892 747429 747982 752580 755352 758420 759608 763529 763589 764518 767983 769585 771442 774698 775826 779289 779427 779806 782307 785029 785229 789922 792570 793680 793755 793787 795089 799446 799864 801737 803714 804864 807417 809592 810924 816001 818404 818826 818835 819720 819872 819938 820196 820709 820757 821122 821586 822201 823720 824546 825581 ] |
||||||||||||||||||||||||||||||
|
15.36 ms (6.63%) |
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 764518 755352 687140 819720 820757 820196 818826 562688 722434 621715 752580 747982 792570 675536 690052 638147 639882 789922 685432 566287 668034 810924 30967 799864 818404 620707 731580 733671 520163 821122 719457 722253 715435 774698 807417 739459 767983 397417 434992 409613 421412 818835 566051 558048 785229 723819 722709 775826 819872 825581 630769 785029 698352 417733 801737 606253 793680 803714 484304 819938 684533 694661 397089 593790 422280 711358 596944 771442 415451 737587 816001 647607 824546 820709 565291 625492 793755 793787 759608 747429 758420 450160 718864 713208 322090 763529 769585 729789 804864 528848 671220 763589 779427 697203 823720 743892 416863 421068 799446 581418 705726 621979 552928 692378 779806 395332 673860 504748 440947 821586 822201 809592 424541 551221 673908 599318 779289 782307 795089 406724 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.92%) |
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 30967 322090 395332 397089 397417 406724 409613 415451 416863 417733 421068 421412 422280 424541 434992 440947 450160 484304 504748 520163 528848 551221 552928 558048 562688 565291 566051 566287 581418 593790 596944 599318 606253 620707 621715 621979 625492 630769 638147 639882 647607 668034 671220 673860 673908 675536 684533 685432 687140 690052 692378 694661 697203 698352 705726 711358 713208 715435 718864 719457 722253 722434 722709 723819 729789 731580 733671 737587 739459 743892 747429 747982 752580 755352 758420 759608 763529 763589 764518 767983 769585 771442 774698 775826 779289 779427 779806 782307 785029 785229 789922 792570 793680 793755 793787 795089 799446 799864 801737 803714 804864 807417 809592 810924 816001 818404 818826 818835 819720 819872 819938 820196 820709 820757 821122 821586 822201 823720 824546 825581 ] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.74%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real минет оральн секс сперм"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real минет оральн секс сперм"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real blowjob sperm"
]
|
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.