Query Metrics
7
Database Queries
7
Different statements
146.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.04 ms (82.19%) |
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 6804 206046 237950 305201 382024 392760 395861 395937 399738 401133 401334 402385 407569 407602 412089 418542 438403 454974 456188 465515 466043 487082 515734 537148 540390 542605 545493 555652 556296 557543 586636 596820 596944 599277 600398 600626 600805 600871 600882 621462 625282 625805 636238 637781 643368 643958 644375 663486 664606 665433 665477 665884 669774 671647 671942 673881 688633 697649 700842 701160 704425 712718 714191 716111 716193 716204 716896 718339 724312 724888 726149 730760 734630 742174 742209 748144 748399 748799 755133 759951 761509 771543 776696 777910 779039 781816 782016 782066 783277 784142 785721 786573 786763 787489 792622 794513 796235 796243 797247 798969 799874 800572 802170 804979 805350 807559 807633 808534 810071 812846 815123 816040 817934 818039 820369 820878 825555 827203 827315 ] |
||||||||||||||||||||||||||||||
|
15.00 ms (10.27%) |
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 6804 734630 782066 625282 786763 206046 382024 827203 673881 663486 716204 718339 671647 700842 714191 600626 777910 781816 794513 759951 783277 761509 755133 726149 716193 776696 782016 804979 808534 305201 800572 669774 643368 771543 799874 712718 402385 395861 644375 786573 418542 820878 818039 827315 537148 542605 665477 599277 600871 596820 596944 802170 798969 805350 748399 730760 785721 796235 817934 816040 748799 392760 412089 438403 697649 454974 779039 792622 487082 407602 688633 724312 742209 395937 784142 671942 704425 716111 600805 586636 636238 807633 773710 399738 600398 621462 637781 797247 625805 825555 556296 600882 407569 555652 701160 665884 716896 812846 787489 748144 643958 545493 401334 456188 796243 742174 237950 466043 465515 540390 664606 807559 724888 557543 665433 810071 515734 401133 820369 815123 ] |
||||||||||||||||||||||||||||||
|
3.38 ms (2.31%) |
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 6804 206046 237950 305201 382024 392760 395861 395937 399738 401133 401334 402385 407569 407602 412089 418542 438403 454974 456188 465515 466043 487082 515734 537148 540390 542605 545493 555652 556296 557543 586636 596820 596944 599277 600398 600626 600805 600871 600882 621462 625282 625805 636238 637781 643368 643958 644375 663486 664606 665433 665477 665884 669774 671647 671942 673881 688633 697649 700842 701160 704425 712718 714191 716111 716193 716204 716896 718339 724312 724888 726149 730760 734630 742174 742209 748144 748399 748799 755133 759951 761509 771543 776696 777910 779039 781816 782016 782066 783277 784142 785721 786573 786763 787489 792622 794513 796235 796243 797247 798969 799874 800572 802170 804979 805350 807559 807633 808534 810071 812846 815123 816040 817934 818039 820369 820878 825555 827203 827315 ] |
||||||||||||||||||||||||||||||
|
2.15 ms (1.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob to boss"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс boss"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс boss"
]
|
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.