Query Metrics
7
Database Queries
7
Different statements
229.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.99 ms (91.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 427558 444722 445306 452175 454434 456037 459584 471300 479387 483025 507537 516969 518305 522423 527018 527161 535426 547841 551451 563721 563951 574689 577512 580158 584160 584927 585638 589467 592895 596714 602920 603173 612682 614931 615173 617396 622691 624021 625631 636394 645045 652468 657867 658764 666737 668712 669409 676676 689054 689161 691674 697685 701552 702380 706479 711735 713434 714189 716122 718156 725186 728935 732155 736958 738218 742070 744462 753176 753946 756320 756387 756826 757126 757528 757744 759367 761112 761151 761895 766890 768281 770344 773907 774058 777844 782341 782928 784552 784805 785442 787706 789149 789450 789612 791106 791641 791783 793900 794039 794470 794760 797103 797414 800635 804736 807318 809997 813015 813745 818826 818846 819197 823602 823883 824194 824544 825630 826166 827768 ] |
||||||||||||||||||||||||||||||
|
11.32 ms (4.94%) |
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 826166 818846 824544 818826 827768 584160 714189 645045 689054 718156 624021 785442 757126 756387 742070 761151 756320 782928 676676 691674 701552 612682 768281 809997 535426 791641 759367 479387 483025 596714 823602 563951 652468 702380 589467 603173 784805 789450 800635 807318 789149 725186 756826 728935 757744 732155 738218 761112 791783 794470 454434 522423 784552 793900 789612 794760 791106 507537 819197 823883 527018 518305 574689 706479 689161 636394 602920 615173 777844 797414 782341 804736 753946 757528 736958 753176 774058 614931 711735 794039 444722 516969 456037 547841 716122 551451 625631 459584 471300 813745 824194 825630 521651 563721 577512 668712 657867 658764 697685 713434 666737 622691 617396 585638 592895 787706 813015 773907 761895 766890 770344 744462 797103 445306 527161 669409 427558 452175 580158 584927 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.18%) |
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 427558 444722 445306 452175 454434 456037 459584 471300 479387 483025 507537 516969 518305 522423 527018 527161 535426 547841 551451 563721 563951 574689 577512 580158 584160 584927 585638 589467 592895 596714 602920 603173 612682 614931 615173 617396 622691 624021 625631 636394 645045 652468 657867 658764 666737 668712 669409 676676 689054 689161 691674 697685 701552 702380 706479 711735 713434 714189 716122 718156 725186 728935 732155 736958 738218 742070 744462 753176 753946 756320 756387 756826 757126 757528 757744 759367 761112 761151 761895 766890 768281 770344 773907 774058 777844 782341 782928 784552 784805 785442 787706 789149 789450 789612 791106 791641 791783 793900 794039 794470 794760 797103 797414 800635 804736 807318 809997 813015 813745 818826 818846 819197 823602 823883 824194 824544 825630 826166 827768 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"i fucked her"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.68%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.66%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"i fucked her"
]
|
||||||||||||||||||||||||||||||
|
1.23 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"i fucked her"
]
|
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.