Query Metrics
7
Database Queries
7
Different statements
174.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.66 ms (84.48%) |
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 154491 382043 382304 383388 388363 408885 416174 418780 438543 441070 452920 452953 453223 453649 465691 467114 467633 467636 468146 469451 475422 476664 484754 491107 500263 511856 513220 521842 523884 524215 527920 531834 534772 537138 538045 538759 545379 548835 564518 569391 571042 572778 574391 580069 580132 580832 583694 586136 587208 589254 591156 591884 593267 594363 597277 600144 602136 602277 607683 608650 611274 614078 624742 635129 640131 653028 660412 666682 668315 669056 671018 671045 672939 682822 686106 700690 700906 703339 704072 704700 706720 713788 722398 726066 750764 753207 757448 769015 769030 772261 772262 776037 782057 782334 782554 782854 782952 784030 785079 788753 788870 789234 791437 792721 794013 796946 803530 803534 803624 803770 806495 806764 807160 807590 807825 813793 827181 827290 ] |
||||||||||||||||||||||||||||||
|
16.06 ms (9.19%) |
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 789234 635129 803770 806495 827290 476664 538045 587208 154491 382304 416174 531834 467636 564518 574391 580832 580069 600144 782057 782854 803534 524215 441070 467114 572778 602136 438543 523884 826398 453649 475422 611274 534772 467633 564310 672939 660412 669056 671018 671045 686106 807590 527920 571042 586136 452953 653028 668315 706720 700906 666682 700690 607683 591156 782554 794013 726066 382043 511856 468146 569391 713788 722398 703339 614078 597277 782952 807160 776037 788753 788870 796946 753207 772261 772262 785079 791437 769015 769030 750764 640131 782334 792721 806764 807825 383388 813793 757448 704700 784030 580132 624742 388363 452920 538759 593267 484754 491107 704072 803624 803530 453223 469451 465691 500263 537138 583694 682822 591884 594363 608650 589254 602277 827181 418780 521842 408885 513220 545379 548835 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (1.86%) |
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 154491 382043 382304 383388 388363 408885 416174 418780 438543 441070 452920 452953 453223 453649 465691 467114 467633 467636 468146 469451 475422 476664 484754 491107 500263 511856 513220 521842 523884 524215 527920 531834 534772 537138 538045 538759 545379 548835 564518 569391 571042 572778 574391 580069 580132 580832 583694 586136 587208 589254 591156 591884 593267 594363 597277 600144 602136 602277 607683 608650 611274 614078 624742 635129 640131 653028 660412 666682 668315 669056 671018 671045 672939 682822 686106 700690 700906 703339 704072 704700 706720 713788 722398 726066 750764 753207 757448 769015 769030 772261 772262 776037 782057 782334 782554 782854 782952 784030 785079 788753 788870 789234 791437 792721 794013 796946 803530 803534 803624 803770 806495 806764 807160 807590 807825 813793 827181 827290 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam big dildo"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер большие дилд"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.