Query Metrics
7
Database Queries
7
Different statements
632.95 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
610.56 ms (96.46%) |
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 4446 7166 34351 71071 80747 101932 183401 191246 191474 222222 230399 317866 357845 385751 386080 390856 391556 391560 405972 416448 447364 507816 520242 526485 530095 533118 535151 536313 539643 561493 562536 565789 566877 575334 576542 585840 587301 595379 598768 621829 623943 623966 626248 628826 630447 634011 634697 634756 635889 635938 640039 640315 640353 644700 645207 649372 653047 662545 668500 670731 677510 701224 704281 713444 715265 717147 718823 726076 726821 733504 735783 736446 738937 741186 742672 744369 746262 748481 752125 754426 756144 757666 761398 762741 766077 767953 769363 772026 772040 777687 786084 790883 791357 793487 793780 795213 796418 797041 797485 797794 797832 800908 801115 804146 808552 813740 814354 816173 818081 819265 820045 822890 824633 826414 826661 826725 827297 827315 827866 828395 ] |
||||||||||||||||||||||||||||||
|
12.80 ms (2.02%) |
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 575334 668500 761398 71071 628826 790883 34351 7166 827866 447364 670731 735783 754426 757666 762741 738937 746262 756144 704281 183401 4446 828395 797041 357845 653047 621829 626248 416448 385751 191474 390856 405972 816173 820045 677510 644700 793487 766077 222222 386080 101932 317866 391556 391560 533118 562536 598768 772026 191246 230399 814354 813740 822890 535151 791357 733504 742672 748481 507816 526485 645207 801115 796418 80747 818081 826661 826725 827297 826414 819265 824633 827315 520242 536313 530095 539643 561493 565789 576542 566877 662545 715265 649372 701224 718823 587301 634011 634697 634756 635889 640315 595379 640039 623966 635938 585840 623943 630447 640353 795213 797485 797832 800908 804146 741186 769363 793780 797794 808552 767953 772040 736446 744369 726821 752125 726076 713444 717147 777687 786084 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (0.43%) |
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 4446 7166 34351 71071 80747 101932 183401 191246 191474 222222 230399 317866 357845 385751 386080 390856 391556 391560 405972 416448 447364 507816 520242 526485 530095 533118 535151 536313 539643 561493 562536 565789 566877 575334 576542 585840 587301 595379 598768 621829 623943 623966 626248 628826 630447 634011 634697 634756 635889 635938 640039 640315 640353 644700 645207 649372 653047 662545 668500 670731 677510 701224 704281 713444 715265 717147 718823 726076 726821 733504 735783 736446 738937 741186 742672 744369 746262 748481 752125 754426 756144 757666 761398 762741 766077 767953 769363 772026 772040 777687 786084 790883 791357 793487 793780 795213 796418 797041 797485 797794 797832 800908 801115 804146 808552 813740 814354 816173 818081 819265 820045 822890 824633 826414 826661 826725 827297 827315 827866 828395 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (0.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding big tits"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding большие сиськ"
]
|
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.