Query Metrics
7
Database Queries
7
Different statements
157.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.96 ms (82.97%) |
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 89421 392184 403624 422700 426291 430862 446534 452879 454516 457799 462128 465595 468925 472357 485321 485592 488038 488956 491004 491766 494803 513986 517437 524548 527801 532884 533711 533827 539598 541795 548634 550119 553932 557048 564225 569379 574656 575392 575663 579127 585080 588596 605173 606111 616207 621230 621761 625796 626831 638031 638182 640393 641161 645751 650270 652283 656938 669905 671563 692697 692712 692744 697934 707812 713018 713145 713167 715166 717595 721178 727320 734827 739669 744933 745142 748509 751422 751743 752145 755183 758648 770452 774793 780137 785404 788366 789090 790430 791492 792871 793940 794221 796927 796952 798387 798709 800229 802236 804389 804437 805290 809948 809966 810018 810208 811790 811813 811987 812011 812040 812394 812428 812523 813298 813587 814157 821139 828021 828243 ] |
||||||||||||||||||||||||||||||
|
16.67 ms (10.56%) |
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 692697 640393 796952 800229 739669 751743 755183 727320 715166 721178 789090 588596 533711 546559 575663 713145 669905 697934 810208 804389 809948 744933 621230 809966 811987 652283 780137 813587 788366 812040 465595 488038 550119 579127 751422 707812 532884 533827 524548 564225 713018 606111 625796 641161 790430 548634 812428 575392 821139 472357 541795 645751 656938 805290 812523 734827 748509 745142 785404 794221 796927 804437 828021 422700 585080 814157 557048 569379 770452 811790 811813 692712 89421 553932 798709 513986 626831 616207 539598 713167 813298 446534 452879 468925 527801 802236 758648 791492 491766 485321 491004 462128 457799 430862 494803 426291 454516 488956 671563 621761 774793 792871 812394 403624 485592 392184 574656 752145 793940 828243 517437 692744 717595 650270 638182 605173 638031 798387 810018 812011 ] |
||||||||||||||||||||||||||||||
|
3.48 ms (2.21%) |
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 89421 392184 403624 422700 426291 430862 446534 452879 454516 457799 462128 465595 468925 472357 485321 485592 488038 488956 491004 491766 494803 513986 517437 524548 527801 532884 533711 533827 539598 541795 548634 550119 553932 557048 564225 569379 574656 575392 575663 579127 585080 588596 605173 606111 616207 621230 621761 625796 626831 638031 638182 640393 641161 645751 650270 652283 656938 669905 671563 692697 692712 692744 697934 707812 713018 713145 713167 715166 717595 721178 727320 734827 739669 744933 745142 748509 751422 751743 752145 755183 758648 770452 774793 780137 785404 788366 789090 790430 791492 792871 793940 794221 796927 796952 798387 798709 800229 802236 804389 804437 805290 809948 809966 810018 810208 811790 811813 811987 812011 812040 812394 812428 812523 813298 813587 814157 821139 828021 828243 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"public solo masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"на улиц соло мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.90%) |
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.