Query Metrics
7
Database Queries
7
Different statements
142.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.62 ms (83.41%) |
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 69739 131517 382203 387413 398199 412287 421691 424187 425573 446510 458806 475199 488510 500519 525128 526079 530419 530445 550570 555765 574499 579206 588937 592958 595117 600515 605589 612963 614550 615694 616085 619036 619670 619881 625753 630718 633060 639153 644069 647797 654137 655524 666347 692904 704346 705806 712143 715037 716960 722031 722171 723766 729677 730805 734108 734716 736070 737983 739140 742918 748884 751496 753773 761122 761520 761523 764280 765495 768633 768804 773532 778194 780290 780881 782051 783881 785189 786488 786994 787078 787288 787851 787958 787994 789065 789908 789990 791658 792681 794871 800353 800765 801541 802052 804885 809625 810315 810857 813768 818933 819406 823723 824044 824318 824774 824798 824813 825083 825101 825303 825576 826110 826565 826579 826923 826979 827049 827272 827479 827544 ] |
||||||||||||||||||||||||||||||
|
12.63 ms (8.88%) |
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 716960 778194 780881 792681 794871 809625 810315 424187 131517 823723 824044 824318 824813 826110 826565 819406 824774 825303 826923 827049 827272 827479 827544 813768 818933 824798 825101 825576 825083 826979 526079 530419 550570 574499 647797 666347 704346 715037 705806 654137 692904 722031 619881 614550 633060 644069 600515 780290 782051 787958 791658 810857 786994 789908 801541 723766 742918 748884 761523 768633 761122 768804 729677 730805 751496 765495 734716 737983 761520 639153 783881 785189 786488 787288 789990 800765 802052 804885 398199 655524 800353 753773 555765 630718 412287 458806 592958 605589 736070 382203 69739 425573 826579 530445 712143 787078 734108 789065 739140 446510 475199 421691 488510 625753 387413 525128 500519 579206 722171 588937 612963 619670 595117 615694 616085 619036 787851 787994 773532 764280 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (2.11%) |
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 69739 131517 382203 387413 398199 412287 421691 424187 425573 446510 458806 475199 488510 500519 525128 526079 530419 530445 550570 555765 574499 579206 588937 592958 595117 600515 605589 612963 614550 615694 616085 619036 619670 619881 625753 630718 633060 639153 644069 647797 654137 655524 666347 692904 704346 705806 712143 715037 716960 722031 722171 723766 729677 730805 734108 734716 736070 737983 739140 742918 748884 751496 753773 761122 761520 761523 764280 765495 768633 768804 773532 778194 780290 780881 782051 783881 785189 786488 786994 787078 787288 787851 787958 787994 789065 789908 789990 791658 792681 794871 800353 800765 801541 802052 804885 809625 810315 810857 813768 818933 819406 823723 824044 824318 824774 824798 824813 825083 825101 825303 825576 826110 826565 826579 826923 826979 827049 827272 827479 827544 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð╝ð░ÐüÐéÐâÐÇð▒ð░Ðåð©ÐÅ Ðüð┐ðÁÐÇð╝ð░ ðÂð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац сперм"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.21%) |
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.