Query Metrics
7
Database Queries
7
Different statements
148.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
124.33 ms (83.54%) |
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 103696 389409 389891 395718 396753 397348 400947 409405 410934 410936 410937 413376 413398 414259 424791 429805 430261 431805 461591 474977 478548 500971 509802 514034 524213 525020 532659 534028 536249 540333 540559 540969 545488 558124 585963 589185 597254 602966 605334 613516 627412 628403 628602 630798 632658 632669 633807 636991 637128 637432 640777 641070 644894 650392 651620 652831 655247 661455 666548 666877 669298 672681 672987 673942 674107 676066 677784 679770 679775 682986 686511 690012 697001 699531 700291 703070 705794 706652 708597 709684 712887 719001 719059 720219 720684 720871 721307 722884 727807 727850 732954 733894 734483 738820 748950 749269 758599 759910 768347 769885 770396 772728 773467 775054 775896 775899 775904 780608 790234 791127 792246 799944 800331 805023 814139 815536 817240 818377 819311 ] |
||||||||||||||||||||||||||||||
|
14.83 ms (9.96%) |
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 706652 719001 679770 651620 679775 720684 720871 558124 597254 613516 637432 632658 636991 640777 805023 800331 748950 770396 633807 641070 413398 414259 431805 96269 474977 424791 430261 410937 413376 478548 525020 400947 818377 814139 721307 652831 650392 637128 585963 589185 605334 727807 772728 773467 722884 780608 397348 534028 536249 790234 410936 410934 461591 524213 500971 540559 545488 677784 602966 395718 103696 409405 644894 815536 819311 817240 514034 532659 540969 673942 690012 708597 719059 720219 655247 661455 669298 699531 672987 674107 682986 686511 705794 712887 628602 630798 627412 775054 775904 775899 792246 732954 758599 759910 768347 769885 791127 799944 734483 738820 749269 727850 703070 709684 775896 389409 396753 509802 540333 666877 666548 672681 700291 676066 628403 632669 733894 697001 389891 429805 ] |
||||||||||||||||||||||||||||||
|
3.32 ms (2.23%) |
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 103696 389409 389891 395718 396753 397348 400947 409405 410934 410936 410937 413376 413398 414259 424791 429805 430261 431805 461591 474977 478548 500971 509802 514034 524213 525020 532659 534028 536249 540333 540559 540969 545488 558124 585963 589185 597254 602966 605334 613516 627412 628403 628602 630798 632658 632669 633807 636991 637128 637432 640777 641070 644894 650392 651620 652831 655247 661455 666548 666877 669298 672681 672987 673942 674107 676066 677784 679770 679775 682986 686511 690012 697001 699531 700291 703070 705794 706652 708597 709684 712887 719001 719059 720219 720684 720871 721307 722884 727807 727850 732954 733894 734483 738820 748950 749269 758599 759910 768347 769885 770396 772728 773467 775054 775896 775899 775904 780608 790234 791127 792246 799944 800331 805023 814139 815536 817240 818377 819311 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen double penetration"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen double penetration"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen double penetration"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.93%) |
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.