Query Metrics
7
Database Queries
7
Different statements
168.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.37 ms (84.27%) |
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 150322 382281 393480 397265 400942 406128 410702 411872 413446 416731 416737 417366 422180 428235 430369 448824 450690 451251 452567 452791 457204 467982 468813 478508 499919 505459 507956 509976 516028 533655 536121 548969 554827 576534 578478 590372 590692 595438 597732 600423 604171 604361 612976 623275 624409 625624 634027 634261 639950 641714 661987 671049 679563 680801 691584 696975 707819 715700 718538 719955 720369 720648 724854 725628 725739 728306 729703 729815 730083 731357 731779 731834 731890 732261 734443 736809 738451 742307 745114 745121 749204 749256 749515 749679 749685 750344 751294 752657 752752 756832 757438 758068 760436 764817 764820 765097 765293 765367 765617 765677 768244 770379 770395 770860 771593 777633 782436 782782 783102 785855 788529 791181 792089 792092 793266 794541 799699 800528 801309 803101 ] |
||||||||||||||||||||||||||||||
|
16.73 ms (9.90%) |
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 679563 680801 691584 707819 715700 720369 548969 554827 576534 600423 641714 612976 634027 590372 623275 624409 634261 639950 590692 785855 793266 800528 777633 782436 782782 783102 791181 801309 803101 734443 736809 752752 760436 765097 788529 794541 799699 731834 732261 738451 745114 749204 752657 770379 730083 749256 749515 770860 725628 729815 731779 731890 745121 757438 765677 728306 729703 749679 749685 751294 756832 758068 765367 765617 768244 696975 718538 719955 720648 792089 509976 595438 750344 725739 382281 533655 765293 731357 450690 416737 413446 416731 422180 410702 467982 448824 499919 625624 724854 770395 468813 397265 507956 516028 411872 430369 428235 451251 393480 452567 452791 478508 457204 661987 771593 578478 671049 597732 604171 764820 764817 792092 604361 400942 406128 417366 742307 150322 505459 536121 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.39%) |
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 150322 382281 393480 397265 400942 406128 410702 411872 413446 416731 416737 417366 422180 428235 430369 448824 450690 451251 452567 452791 457204 467982 468813 478508 499919 505459 507956 509976 516028 533655 536121 548969 554827 576534 578478 590372 590692 595438 597732 600423 604171 604361 612976 623275 624409 625624 634027 634261 639950 641714 661987 671049 679563 680801 691584 696975 707819 715700 718538 719955 720369 720648 724854 725628 725739 728306 729703 729815 730083 731357 731779 731834 731890 732261 734443 736809 738451 742307 745114 745121 749204 749256 749515 749679 749685 750344 751294 752657 752752 756832 757438 758068 760436 764817 764820 765097 765293 765367 765617 765677 768244 770379 770395 770860 771593 777633 782436 782782 783102 785855 788529 791181 792089 792092 793266 794541 799699 800528 801309 803101 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð░ð¢ð░ð╗Ðîð¢ð¥ð╣ ð╝ð░ÐüÐéÐâÐÇð▒ð░Ðåð©ð©ÔÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.95%) |
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.