Query Metrics
7
Database Queries
7
Different statements
188.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.11 ms (81.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 382661 384233 386326 388482 393706 393757 393782 395899 398514 400467 402088 402249 413243 415360 429234 458039 466154 466821 470842 470847 472439 473928 488004 515096 515135 515136 515165 515198 515227 525671 550448 557274 562875 566521 567670 569660 569663 569676 569679 569683 569689 569690 569692 569784 570055 570059 570061 570062 570064 570065 570066 570073 570075 570077 587297 605543 649561 652998 663434 663899 663901 663904 663947 663972 664281 664839 665213 665238 665423 665443 665486 665502 665512 665851 665857 666163 667517 667850 667868 669735 670471 670498 673575 678972 685891 688370 691994 694536 700654 704841 709539 722659 724175 736403 736917 743158 743369 744359 746112 747854 751648 759564 767950 767961 770862 774155 774160 778550 780609 780645 789198 800700 802632 810775 812097 812150 817364 818731 826319 827307 ] |
||||||||||||||||||||||||||||||
|
24.00 ms (12.77%) |
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 665238 704841 751648 570055 569690 569683 587297 402088 744359 747854 778550 666163 570065 569784 570066 569676 570062 570075 466154 570073 515165 569689 810775 570059 566521 488004 525671 664281 398514 562875 818731 826319 665502 667850 780645 384233 470842 470847 393706 395899 400467 413243 665512 665857 667517 663904 685891 393782 382661 567670 569660 473928 472439 515136 458039 429234 570061 569692 515135 649561 800700 736917 774160 743369 665443 688370 678972 694536 743158 746112 780609 466821 663947 569663 570064 557274 415360 670471 665486 767961 393757 817364 709539 663899 667868 673575 663434 665423 700654 605543 789198 767950 724175 802632 550448 669735 691994 736403 570077 386326 402249 515198 722659 670498 812097 759564 812150 770862 774155 388482 515227 569679 827307 515096 664839 665213 663901 665851 652998 663972 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.48%) |
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 382661 384233 386326 388482 393706 393757 393782 395899 398514 400467 402088 402249 413243 415360 429234 458039 466154 466821 470842 470847 472439 473928 488004 515096 515135 515136 515165 515198 515227 525671 550448 557274 562875 566521 567670 569660 569663 569676 569679 569683 569689 569690 569692 569784 570055 570059 570061 570062 570064 570065 570066 570073 570075 570077 587297 605543 649561 652998 663434 663899 663901 663904 663947 663972 664281 664839 665213 665238 665423 665443 665486 665502 665512 665851 665857 666163 667517 667850 667868 669735 670471 670498 673575 678972 685891 688370 691994 694536 700654 704841 709539 722659 724175 736403 736917 743158 743369 744359 746112 747854 751648 759564 767950 767961 770862 774155 774160 778550 780609 780645 789198 800700 802632 810775 812097 812150 817364 818731 826319 827307 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"old sex"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"old секс"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"old секс"
]
|
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.