Query Metrics
7
Database Queries
7
Different statements
165.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.65 ms (80.36%) |
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 314541 388862 393233 415921 416737 418372 418968 425607 430875 431948 434576 435883 437706 437980 453366 455418 457608 462240 466692 467392 469792 484543 486908 487826 490965 499829 500294 501927 504727 510008 510943 517266 520699 525231 532385 534029 540097 540187 544891 546748 548712 548766 550180 559656 561001 567511 569821 571141 571732 573257 574522 587345 594014 595577 598535 604350 608894 623508 624829 631109 641097 643624 648758 653563 656106 660370 662387 665762 674582 676328 677061 684469 684903 686057 688996 692654 694612 695337 696576 706058 711947 712433 713067 714002 715012 715041 718657 718708 720815 722692 741545 743341 747313 747839 752677 753181 754186 755328 765947 770280 775561 775941 776248 777157 788686 791250 795417 797036 803122 806053 806425 807478 808333 809696 814128 814212 823403 825563 827080 827328 ] |
||||||||||||||||||||||||||||||
|
21.89 ms (13.26%) |
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 753181 755328 765947 430875 437706 425607 823403 457608 466692 534029 532385 571732 676328 711947 648758 684903 686057 559656 571141 574522 643624 623508 775561 791250 807478 754186 809696 435883 453366 467392 418372 415921 814128 469792 544891 548712 718708 653563 692654 706058 587345 594014 595577 604350 775941 795417 797036 806053 770280 803122 393233 314541 416737 814212 827328 825563 525231 540187 499829 540097 490965 548766 561001 712433 665762 722692 718657 546748 608894 641097 598535 624829 631109 788686 776248 808333 743341 806425 747839 752677 747313 741545 777157 434576 462240 486908 487826 501927 520699 388862 431948 437980 418968 827080 484543 455418 510008 504727 517266 510943 500294 550180 573257 567511 660370 688996 720815 662387 677061 684469 695337 696576 714002 656106 674582 694612 713067 715012 715041 569821 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.40%) |
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 314541 388862 393233 415921 416737 418372 418968 425607 430875 431948 434576 435883 437706 437980 453366 455418 457608 462240 466692 467392 469792 484543 486908 487826 490965 499829 500294 501927 504727 510008 510943 517266 520699 525231 532385 534029 540097 540187 544891 546748 548712 548766 550180 559656 561001 567511 569821 571141 571732 573257 574522 587345 594014 595577 598535 604350 608894 623508 624829 631109 641097 643624 648758 653563 656106 660370 662387 665762 674582 676328 677061 684469 684903 686057 688996 692654 694612 695337 696576 706058 711947 712433 713067 714002 715012 715041 718657 718708 720815 722692 741545 743341 747313 747839 752677 753181 754186 755328 765947 770280 775561 775941 776248 777157 788686 791250 795417 797036 803122 806053 806425 807478 808333 809696 814128 814212 823403 825563 827080 827328 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"all girl"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"all девушк"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"all девушк"
]
|
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.