Query Metrics
7
Database Queries
7
Different statements
155.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.42 ms (83.97%) |
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 445814 453021 453731 459028 485021 486125 487449 497210 499911 509811 525741 527762 546994 549143 553703 555043 563871 570147 570159 573290 577677 579745 604806 612806 613255 616007 616993 617869 618761 622701 627491 628055 637208 648914 653264 656796 679361 690218 696430 705493 705702 709582 711341 712083 718479 720776 722816 724411 726116 726390 730048 730904 736417 744007 744169 744178 747432 751245 751386 752405 753643 754400 754529 758791 760918 764810 766365 766432 769194 769550 770348 771793 772444 773215 773532 775271 775313 776431 778049 779362 781128 781210 782582 787657 789278 792761 793676 795166 795498 795678 795708 796488 796544 797354 798791 799155 800069 807003 810089 812333 813687 813745 814123 814825 815540 816750 816768 818392 819174 819734 819922 825792 825902 826053 826466 826766 826949 828348 ] |
||||||||||||||||||||||||||||||
|
14.31 ms (9.21%) |
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 705702 718479 579745 604806 637208 613255 622701 618761 782582 795498 796488 775271 776431 792761 724411 747432 758791 773532 730904 744178 752405 726390 730048 769550 772444 736417 770348 617869 711341 797354 799155 800069 459028 487449 525741 819174 826053 816750 819734 826149 818392 819922 828348 705493 709582 628055 775313 795166 796544 744169 726116 764810 766365 766432 754400 753643 754529 771793 781210 555043 553703 453021 445814 527762 570159 616993 826949 813687 816768 825637 825792 825902 826466 577677 653264 690218 656796 612806 781128 778049 787657 793676 812333 769194 773215 760918 744007 751245 751386 795708 798791 810089 814825 453731 563871 546994 549143 648914 696430 486125 497210 509811 814123 813745 815540 826766 485021 499911 573290 570147 679361 712083 720776 722816 616007 627491 807003 779362 789278 795678 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.79%) |
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 445814 453021 453731 459028 485021 486125 487449 497210 499911 509811 525741 527762 546994 549143 553703 555043 563871 570147 570159 573290 577677 579745 604806 612806 613255 616007 616993 617869 618761 622701 627491 628055 637208 648914 653264 656796 679361 690218 696430 705493 705702 709582 711341 712083 718479 720776 722816 724411 726116 726390 730048 730904 736417 744007 744169 744178 747432 751245 751386 752405 753643 754400 754529 758791 760918 764810 766365 766432 769194 769550 770348 771793 772444 773215 773532 775271 775313 776431 778049 779362 781128 781210 782582 787657 789278 792761 793676 795166 795498 795678 795708 796488 796544 797354 798791 799155 800069 807003 810089 812333 813687 813745 814123 814825 815540 816750 816768 818392 819174 819734 819922 825792 825902 826053 826466 826766 826949 828348 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shaving her pussy"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"shaving her pussy"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"shaving her pussy"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (1.18%) |
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.