Query Metrics
7
Database Queries
7
Different statements
197.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
171.38 ms (86.96%) |
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 96269 96623 182749 192691 198857 324183 341691 393326 396030 410937 413376 413398 414259 424791 429805 430261 431805 474977 478548 481149 495397 525020 530295 541064 544713 544749 547961 547983 558124 564554 594604 597204 597254 604420 612976 613516 619307 620471 632632 632658 633179 633602 633807 634480 635835 636991 637432 640777 641070 650373 651620 652850 654097 655586 664481 671761 673526 674507 679770 679775 680151 680615 681515 685775 686183 690000 692096 692261 695923 696331 699719 702342 706652 708494 713113 714281 718159 719001 720684 720834 720837 720871 722945 723094 730246 734412 738121 738556 740269 743888 744390 745924 745927 745936 748950 749990 750719 766704 767036 770396 771038 775883 777876 782439 792753 793262 796430 796652 800331 800410 805023 805228 806376 806423 811941 817139 817624 820672 822304 823721 ] |
||||||||||||||||||||||||||||||
|
14.19 ms (7.20%) |
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 674507 680151 706652 719001 671761 679770 651620 679775 720684 720837 720871 558124 597254 613516 637432 632658 636991 640777 805023 806423 800331 748950 770396 633807 641070 413398 414259 431805 96269 474977 424791 430261 410937 413376 478548 525020 198857 192691 817139 544713 547983 541064 664481 673526 680615 692261 722945 655586 685775 690000 696331 720834 594604 619307 612976 620471 782439 792753 793262 796430 734412 767036 738556 743888 744390 730246 745936 777876 632632 429805 597204 481149 495397 393326 341691 182749 817624 823721 822304 820672 530295 547961 564554 650373 654097 681515 695923 708494 714281 713113 652850 686183 692096 718159 544749 633179 635835 633602 775883 800410 805228 796652 806376 766704 750719 771038 738121 740269 745924 745927 749990 604420 634480 699719 702342 723094 811941 324183 96623 396030 ] |
||||||||||||||||||||||||||||||
|
4.38 ms (2.22%) |
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 96269 96623 182749 192691 198857 324183 341691 393326 396030 410937 413376 413398 414259 424791 429805 430261 431805 474977 478548 481149 495397 525020 530295 541064 544713 544749 547961 547983 558124 564554 594604 597204 597254 604420 612976 613516 619307 620471 632632 632658 633179 633602 633807 634480 635835 636991 637432 640777 641070 650373 651620 652850 654097 655586 664481 671761 673526 674507 679770 679775 680151 680615 681515 685775 686183 690000 692096 692261 695923 696331 699719 702342 706652 708494 713113 714281 718159 719001 720684 720834 720837 720871 722945 723094 730246 734412 738121 738556 740269 743888 744390 745924 745927 745936 748950 749990 750719 766704 767036 770396 771038 775883 777876 782439 792753 793262 796430 796652 800331 800410 805023 805228 806376 806423 811941 817139 817624 820672 822304 823721 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double penetration teens"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double penetration teens"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double penetration teens"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.78%) |
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.