Query Metrics
7
Database Queries
7
Different statements
148.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.41 ms (85.38%) |
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 13035 14105 21642 80529 143396 169272 213017 302173 388949 391395 393347 398212 403765 408770 427946 444414 444430 446755 457661 479275 484063 487775 489994 517795 527919 530994 533630 534014 553298 567116 584120 586552 589971 591569 595434 596041 596797 599247 603557 605707 614585 615377 618747 619907 620147 626280 634448 634863 641138 641847 642666 644255 644288 664535 667649 673782 680570 687144 693137 693717 700855 705738 708504 710228 713476 716797 733535 741291 745422 749362 750483 752221 754436 755214 755398 758280 759712 759856 760608 760831 773206 776421 779464 786457 788904 789509 789693 792310 793844 795052 795422 797637 798271 798967 800004 801383 801475 802818 803055 806181 807387 807991 808061 808068 809372 811114 811557 812534 812555 812798 815770 817358 818394 818507 826604 827583 828502 828643 ] |
||||||||||||||||||||||||||||||
|
12.63 ms (8.53%) |
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 664535 667649 680570 687144 693137 700855 710228 716797 553298 567116 620147 641847 644288 586552 595434 599247 589971 591569 605707 634448 776421 793844 797637 800004 802818 807387 788904 789693 798967 801475 809372 745422 750483 758280 792310 806181 808068 759712 755214 760831 773206 741291 754436 760608 603557 614585 626280 634863 641138 705738 779464 807991 812798 391395 446755 398212 444430 388949 408770 457661 479275 444414 527919 489994 487775 517795 169272 393347 80529 403765 826604 815770 827583 818394 534014 642666 713476 143396 818507 828643 828502 533630 708504 618747 803055 811114 759856 213017 427946 584120 13035 596041 795052 798271 808061 811557 14105 801383 772851 302173 21642 817358 530994 484063 673782 693717 615377 596797 644255 619907 786457 789509 795422 752221 812534 812555 749362 768810 733535 755398 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.82%) |
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 13035 14105 21642 80529 143396 169272 213017 302173 388949 391395 393347 398212 403765 408770 427946 444414 444430 446755 457661 479275 484063 487775 489994 517795 527919 530994 533630 534014 553298 567116 584120 586552 589971 591569 595434 596041 596797 599247 603557 605707 614585 615377 618747 619907 620147 626280 634448 634863 641138 641847 642666 644255 644288 664535 667649 673782 680570 687144 693137 693717 700855 705738 708504 710228 713476 716797 733535 741291 745422 749362 750483 752221 754436 755214 755398 758280 759712 759856 760608 760831 773206 776421 779464 786457 788904 789509 789693 792310 793844 795052 795422 797637 798271 798967 800004 801383 801475 802818 803055 806181 807387 807991 808061 808068 809372 811114 811557 812534 812555 812798 815770 817358 818394 818507 826604 827583 828502 828643 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs ass"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs жоп"
]
|
||||||||||||||||||||||||||||||
|
1.27 ms (0.86%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs жоп"
]
|
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.