Query Metrics
7
Database Queries
7
Different statements
172.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.69 ms (84.24%) |
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 408355 484063 529698 538835 550991 568118 577672 582816 584221 585283 587320 589438 592011 596513 616070 616245 616656 617300 633900 637617 638433 641125 648332 648896 650221 653821 661294 665999 670764 683359 684917 687135 687697 689079 689983 691927 696700 698347 701059 708955 710431 711650 712236 712979 717578 721132 724666 726284 730408 735124 735158 735285 740759 743013 743894 744688 744806 746230 749774 751220 753513 756910 758351 759522 762228 767930 770616 771079 775096 778835 779055 779308 779726 779952 782433 783242 784291 787113 789527 790670 791287 791668 792672 792728 794215 795126 795596 795879 797453 798984 799398 800127 800526 800855 800949 801818 804832 805029 807651 809968 810152 811157 812919 814089 814458 814578 815622 817927 818489 818526 818644 819049 819382 823823 824254 825295 825639 827967 828714 ] |
||||||||||||||||||||||||||||||
|
16.27 ms (9.41%) |
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 617300 596513 798984 801818 810152 779726 782433 783242 789527 790670 791668 794215 800526 800855 805029 809968 812919 744806 804832 726284 749774 753513 759522 762228 762326 724666 735124 743894 771079 730408 744688 751220 767930 735158 735285 740759 746230 756910 616070 616245 708955 712236 717578 721132 784291 797453 807651 408355 814458 825295 814089 819049 824254 825639 815622 817927 819382 823823 814578 818489 818526 818644 827967 828714 529698 538835 484063 550991 568118 582816 701059 648332 665999 687135 687697 689079 698347 712979 648896 650221 653821 661294 670764 683359 684917 689983 691927 696700 710431 711650 577672 584221 585283 638433 637617 589438 592011 641125 587320 616656 633900 778835 779055 779952 795596 799398 800127 800949 811157 775096 779308 792672 795879 743013 758351 770616 787113 791287 792728 795126 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.50%) |
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 408355 484063 529698 538835 550991 568118 577672 582816 584221 585283 587320 589438 592011 596513 616070 616245 616656 617300 633900 637617 638433 641125 648332 648896 650221 653821 661294 665999 670764 683359 684917 687135 687697 689079 689983 691927 696700 698347 701059 708955 710431 711650 712236 712979 717578 721132 724666 726284 730408 735124 735158 735285 740759 743013 743894 744688 744806 746230 749774 751220 753513 756910 758351 759522 762228 767930 770616 771079 775096 778835 779055 779308 779726 779952 782433 783242 784291 787113 789527 790670 791287 791668 792672 792728 794215 795126 795596 795879 797453 798984 799398 800127 800526 800855 800949 801818 804832 805029 807651 809968 810152 811157 812919 814089 814458 814578 815622 817927 818489 818526 818644 819049 819382 823823 824254 825295 825639 827967 828714 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fucks girl"
]
|
||||||||||||||||||||||||||||||
|
2.26 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fucks девушк"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fucks девушк"
]
|
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.