Query Metrics
7
Database Queries
7
Different statements
197.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.04 ms (87.70%) |
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 117806 233521 301402 317898 385479 388709 390955 391820 396832 402611 403685 415344 420319 420326 420332 425268 428064 429614 441892 444670 453487 453850 453871 461997 470079 471576 475875 476989 477638 479377 480973 490325 496625 497971 500389 504212 506241 511425 513451 523464 530070 530639 537625 537626 537628 537630 541000 547967 553154 557311 566267 566500 568753 570677 578808 591096 601225 606784 611382 614004 614937 618749 622688 622841 631294 633989 634397 637727 637828 645071 654865 669277 673175 674494 675885 680537 687847 688405 701243 701453 707239 707865 710178 712172 715442 716612 721957 721961 729124 733065 733458 734690 740894 744923 746037 747618 747627 748408 750292 750352 754022 756290 757795 762945 763310 767771 767973 769011 782306 783692 795035 795298 795653 795866 795947 798864 801690 811804 812096 817649 ] |
||||||||||||||||||||||||||||||
|
13.64 ms (6.91%) |
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 746037 748408 633989 637828 707865 712172 715442 541000 767973 317898 385479 428064 530070 537628 566500 611382 733065 537630 480973 801690 762945 795035 769011 754022 721961 795653 420319 388709 420332 233521 402611 470079 453850 453487 622841 674494 747618 500389 403685 537626 669277 425268 471576 496625 537625 557311 566267 570677 673175 675885 701453 645071 688405 710178 654865 687847 568753 606784 631294 634397 614937 618749 744923 750352 637727 701243 716612 461997 477638 578808 591096 614004 783692 729124 530639 497971 601225 733458 513451 453871 301402 429614 511425 795866 795947 734690 811804 812096 756290 740894 750292 757795 767771 747627 763310 721957 782306 444670 420326 396832 817649 798864 795298 117806 506241 490325 475875 415344 390955 441892 547967 553154 479377 391820 523464 680537 622688 707239 476989 504212 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (1.59%) |
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 117806 233521 301402 317898 385479 388709 390955 391820 396832 402611 403685 415344 420319 420326 420332 425268 428064 429614 441892 444670 453487 453850 453871 461997 470079 471576 475875 476989 477638 479377 480973 490325 496625 497971 500389 504212 506241 511425 513451 523464 530070 530639 537625 537626 537628 537630 541000 547967 553154 557311 566267 566500 568753 570677 578808 591096 601225 606784 611382 614004 614937 618749 622688 622841 631294 633989 634397 637727 637828 645071 654865 669277 673175 674494 675885 680537 687847 688405 701243 701453 707239 707865 710178 712172 715442 716612 721957 721961 729124 733065 733458 734690 740894 744923 746037 747618 747627 748408 750292 750352 754022 756290 757795 762945 763310 767771 767973 769011 782306 783692 795035 795298 795653 795866 795947 798864 801690 811804 812096 817649 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden amateur"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт любительск"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.81%) |
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.