Query Metrics
7
Database Queries
7
Different statements
140.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.10 ms (84.25%) |
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 556648 563470 589464 592428 596041 599039 601304 612162 614185 614321 615810 621532 633908 634503 638177 649322 649955 652267 662158 663275 669210 670512 675037 675481 676778 680934 691761 692485 693126 693340 694079 700328 700834 705689 710351 718361 720775 721693 722560 722616 725306 726731 726917 726947 727458 727624 728097 729244 729253 729587 729816 729893 729919 729958 732208 732245 732739 733556 733608 734623 735769 736351 736999 737371 738274 739521 741606 743875 744867 745774 747396 748190 749121 754112 755174 757373 759525 759880 760251 760695 765273 770555 775618 775626 777036 779923 786515 788963 793738 794505 798271 801362 801383 804671 804987 806046 808423 811004 811045 813349 813500 813529 814999 815143 815225 815281 815412 815614 815687 816036 816894 817227 817789 818166 819039 820356 820724 821506 823091 823355 ] |
||||||||||||||||||||||||||||||
|
12.20 ms (8.70%) |
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 815225 815281 817227 817789 818166 819039 820356 814999 823091 823355 815143 815412 815614 815687 816036 816894 820724 821506 563470 556648 649955 652267 669210 680934 691761 693126 694079 700834 705689 649322 675481 676778 692485 693340 718361 721693 722560 662158 663275 670512 675037 700328 710351 720775 722616 638177 592428 596041 599039 614185 614321 621532 589464 612162 633908 634503 601304 615810 775618 786515 801383 804671 813349 813500 775626 777036 779923 788963 794505 801362 806046 808423 729919 733608 737371 741606 744867 749121 760251 765273 770555 793738 798271 804987 811004 811045 813529 725306 729587 729893 732208 732739 745774 748190 757373 759880 726917 727458 727624 728097 733556 734623 735769 738274 743875 747396 754112 755174 760695 726731 729816 729958 736351 739521 759525 726947 729244 729253 732245 736999 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.95%) |
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 556648 563470 589464 592428 596041 599039 601304 612162 614185 614321 615810 621532 633908 634503 638177 649322 649955 652267 662158 663275 669210 670512 675037 675481 676778 680934 691761 692485 693126 693340 694079 700328 700834 705689 710351 718361 720775 721693 722560 722616 725306 726731 726917 726947 727458 727624 728097 729244 729253 729587 729816 729893 729919 729958 732208 732245 732739 733556 733608 734623 735769 736351 736999 737371 738274 739521 741606 743875 744867 745774 747396 748190 749121 754112 755174 757373 759525 759880 760251 760695 765273 770555 775618 775626 777036 779923 786515 788963 793738 794505 798271 801362 801383 804671 804987 806046 808423 811004 811045 813349 813500 813529 814999 815143 815225 815281 815412 815614 815687 816036 816894 817227 817789 818166 819039 820356 820724 821506 823091 823355 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð░ð¢ð©ð╗ð©ð¢ð│ÐâÐü ð▒ð¥ð╗ÐîÐêð¥ð╣ ð┐ð¥ðÔÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анилингус большой большие"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.11%) |
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.