Query Metrics
7
Database Queries
7
Different statements
175.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.92 ms (86.51%) |
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 420736 511321 534192 558917 562392 563838 617104 621534 626440 627663 672693 685785 691763 695728 700076 701215 702358 704165 712576 713410 718609 725545 731438 732992 733736 734732 734753 736167 736288 736497 736608 736755 738875 739516 739785 745299 747813 748058 749536 750671 752816 756366 757902 757923 758914 759174 764749 766383 767243 767411 767929 768721 768789 769046 770075 770616 770619 773170 777483 777690 778162 778708 778948 779379 779407 781538 782164 783782 785796 787045 787822 789116 789135 789339 789899 790057 791254 791767 792449 792496 793576 793925 794932 795903 796098 796791 799251 800279 800280 803567 803986 804834 806257 806858 812456 813323 813965 813983 816636 816681 816770 817525 817988 819797 819933 820031 821003 824249 824284 824714 825369 825423 826335 826338 826647 827368 827649 ] |
||||||||||||||||||||||||||||||
|
12.81 ms (7.29%) |
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 621534 785796 739516 766383 789339 745299 764749 770619 762910 768721 731438 759174 806257 816681 819933 820031 827368 819797 817525 558917 695728 685785 627663 779379 796098 777690 778948 792496 803567 736167 748058 750671 770616 773537 791767 768789 769046 734753 767243 787045 793576 826338 826335 824714 511321 562392 712576 713410 672693 702358 617104 778162 800280 777483 725545 770075 749536 733736 736755 739785 752816 757902 756366 626440 700076 778708 787822 792449 420736 825423 826647 816636 821003 825369 816770 824249 825928 813965 813983 817988 824284 827649 534192 563838 701215 718609 691763 704165 779407 783782 789899 796791 789116 790057 791254 793925 794932 799251 800279 804834 812456 813323 732992 758914 767411 767929 773170 781538 782164 789135 795903 803986 806858 736288 736608 757923 734732 736497 738875 747813 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (1.97%) |
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 420736 511321 534192 558917 562392 563838 617104 621534 626440 627663 672693 685785 691763 695728 700076 701215 702358 704165 712576 713410 718609 725545 731438 732992 733736 734732 734753 736167 736288 736497 736608 736755 738875 739516 739785 745299 747813 748058 749536 750671 752816 756366 757902 757923 758914 759174 764749 766383 767243 767411 767929 768721 768789 769046 770075 770616 770619 773170 777483 777690 778162 778708 778948 779379 779407 781538 782164 783782 785796 787045 787822 789116 789135 789339 789899 790057 791254 791767 792449 792496 793576 793925 794932 795903 796098 796791 799251 800279 800280 803567 803986 804834 806257 806858 812456 813323 813965 813983 816636 816681 816770 817525 817988 819797 819933 820031 821003 824249 824284 824714 825369 825423 826335 826338 826647 827368 827649 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stepsister sex"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"stepsister секс"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"stepsister секс"
]
|
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.