Query Metrics
7
Database Queries
7
Different statements
280.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
256.05 ms (91.39%) |
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 116701 338474 387515 390931 401727 458567 459275 522401 537179 537662 540777 543248 548362 548722 550568 563830 566300 566398 570216 572140 573104 573706 573867 645047 647766 648233 648754 649035 653540 653674 654831 655309 655422 655527 655613 655643 655652 655953 656032 656759 657028 657384 657927 658376 658426 659581 660545 660930 661609 663077 666467 671137 671145 671360 672410 673334 675758 677335 678414 683293 683789 687118 689119 689140 697945 702546 704998 705465 706607 709582 713258 714572 717648 719006 745078 784281 789586 795305 798624 803246 806030 807776 808073 810675 812214 815455 816563 816783 818780 819489 819578 820443 820605 820796 821190 821429 821664 821727 821729 821894 822204 822527 822589 822728 822922 822943 823008 823063 823124 823495 824776 825084 825513 826186 827727 828208 ] |
||||||||||||||||||||||||||||||
|
13.01 ms (4.64%) |
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 784281 789586 795305 803246 806030 807776 810675 812214 401727 458567 390931 387515 537662 548722 798624 745078 808073 459275 116701 338474 816563 820605 820796 821729 821894 822527 823124 826186 540777 816783 818780 822943 823495 825513 815455 820443 821429 821727 822204 822728 822922 823008 823063 824210 819489 819578 821190 821664 822589 824776 824851 825084 828208 827727 522401 537179 563830 570216 573706 543248 550568 548362 566300 566398 572140 573104 573867 645047 648754 653540 655422 655527 656032 657927 658426 660545 660930 661609 671360 683789 687118 689140 702546 713258 717648 719006 647766 649035 654831 655643 655652 655953 656759 657028 657384 658376 659581 663077 666467 671137 671145 672410 673334 675758 677335 678414 683293 688854 689119 697945 704998 705465 706607 709582 714572 648233 648936 653674 655309 655613 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.15%) |
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 116701 338474 387515 390931 401727 458567 459275 522401 537179 537662 540777 543248 548362 548722 550568 563830 566300 566398 570216 572140 573104 573706 573867 645047 647766 648233 648754 649035 653540 653674 654831 655309 655422 655527 655613 655643 655652 655953 656032 656759 657028 657384 657927 658376 658426 659581 660545 660930 661609 663077 666467 671137 671145 671360 672410 673334 675758 677335 678414 683293 683789 687118 689119 689140 697945 702546 704998 705465 706607 709582 713258 714572 717648 719006 745078 784281 789586 795305 798624 803246 806030 807776 808073 810675 812214 815455 816563 816783 818780 819489 819578 820443 820605 820796 821190 821429 821664 821727 821729 821894 822204 822527 822589 822728 822922 822943 823008 823063 823124 823495 824776 825084 825513 826186 827727 828208 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"shaving cock"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (0.75%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"shaving cock"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.58 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"shaving cock"
]
|
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.