Query Metrics
7
Database Queries
7
Different statements
168.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.72 ms (88.07%) |
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 108138 109356 389712 390580 398428 545771 555724 557073 584956 710293 710819 714581 715690 716651 716863 716916 722087 724057 724635 730189 730495 730980 731192 732578 734190 735932 736499 737004 739360 742265 746691 749034 753953 755242 757651 758046 758867 759105 759788 759846 763524 764026 764540 764749 766919 767681 767699 767762 767876 768288 768653 768809 768830 769053 769207 771025 771394 771685 771718 771873 772349 772798 773781 774265 775512 776363 777135 777798 777822 778127 778312 778708 778822 779952 780949 781077 782784 783682 783782 784572 785265 786136 786188 786545 786556 787285 787382 787414 787459 787822 788644 789144 789365 789379 790070 790783 792449 793894 794431 794580 795730 795898 796257 796419 797037 801501 802021 802292 802858 803272 803871 804857 805096 809774 811086 812441 813995 817403 828070 ] |
||||||||||||||||||||||||||||||
|
8.75 ms (5.18%) |
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 786136 787414 789144 789365 793894 796419 811086 724057 734190 749034 759105 769053 769207 772798 786188 787285 787459 788644 789379 794580 802292 802858 724635 730980 768288 771718 730189 764540 767762 768830 736499 755242 758046 759846 764026 766919 772349 731192 757651 767699 771025 771394 773781 716651 716863 716916 722087 777135 777822 778127 778708 784572 786545 786556 787822 790070 790783 792449 795730 796257 797037 802021 803871 809774 398428 108138 555724 782784 739360 813995 710293 710819 584956 775512 778312 779952 783782 794431 777798 778822 780949 783682 795898 801501 812441 742265 767681 785265 787382 804857 805096 764749 768809 774265 765166 730495 732578 735932 746691 759788 763524 767876 768653 771873 737004 753953 758867 771685 714581 776363 781077 803272 109356 389712 390580 817403 828070 557073 545771 715690 ] |
||||||||||||||||||||||||||||||
|
3.89 ms (2.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сперм любительск"
]
|
||||||||||||||||||||||||||||||
|
2.29 ms (1.35%) |
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 108138 109356 389712 390580 398428 545771 555724 557073 584956 710293 710819 714581 715690 716651 716863 716916 722087 724057 724635 730189 730495 730980 731192 732578 734190 735932 736499 737004 739360 742265 746691 749034 753953 755242 757651 758046 758867 759105 759788 759846 763524 764026 764540 764749 766919 767681 767699 767762 767876 768288 768653 768809 768830 769053 769207 771025 771394 771685 771718 771873 772349 772798 773781 774265 775512 776363 777135 777798 777822 778127 778312 778708 778822 779952 780949 781077 782784 783682 783782 784572 785265 786136 786188 786545 786556 787285 787382 787414 787459 787822 788644 789144 789365 789379 790070 790783 792449 793894 794431 794580 795730 795898 796257 796419 797037 801501 802021 802292 802858 803272 803871 804857 805096 809774 811086 812441 813995 817403 828070 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сперм любительск"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sperm amateur"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.91%) |
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.