Query Metrics
7
Database Queries
7
Different statements
180.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.58 ms (86.08%) |
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 385928 395465 398941 402950 403973 414271 416652 416737 418530 419062 424581 427539 428851 433295 441021 441073 441093 441102 441495 443496 444338 446274 447600 449173 450679 451121 451316 451775 453678 463855 465320 466563 468434 473406 477118 477418 477537 479821 488247 488803 492286 493684 493757 493778 493838 497509 499211 499617 504509 508666 511866 520400 528474 534590 541322 541328 541782 542268 544108 547236 547386 547848 548460 556876 559406 564301 565142 576564 597457 597502 614957 619347 646655 657505 670357 670366 671038 673696 681643 696236 708923 709565 709850 710362 710659 713185 716118 717516 720065 723161 725030 725115 728745 729231 729301 733862 733904 738826 749012 749245 758799 770264 775572 777847 778850 782040 782090 782351 782789 783382 791930 792654 795689 796939 801298 804230 805231 810436 814232 817278 ] |
||||||||||||||||||||||||||||||
|
14.71 ms (8.14%) |
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 619347 792654 416652 428851 542268 681643 738826 791930 402950 670366 733904 770264 477118 444338 433295 463855 817278 511866 548460 547236 670357 696236 565142 782351 725030 419062 564301 778850 414271 614957 398941 547848 597457 749012 728745 782040 395465 416737 441093 441073 441495 427539 441102 443496 814232 446274 468434 473406 477418 479821 488803 493684 493757 450679 465320 497509 534590 477537 492286 544108 541322 541328 710659 713185 716118 657505 708923 709850 671038 717516 597502 777847 782789 749245 758799 725115 729231 796939 804230 466563 385928 403973 453678 424581 499617 499211 508666 488247 493778 493838 520400 733862 449173 451121 451316 447600 556876 451775 418530 441021 504509 528474 541782 576564 710362 723161 646655 673696 709565 720065 547386 559406 775572 782090 795689 810436 783382 801298 805231 729301 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.63%) |
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 385928 395465 398941 402950 403973 414271 416652 416737 418530 419062 424581 427539 428851 433295 441021 441073 441093 441102 441495 443496 444338 446274 447600 449173 450679 451121 451316 451775 453678 463855 465320 466563 468434 473406 477118 477418 477537 479821 488247 488803 492286 493684 493757 493778 493838 497509 499211 499617 504509 508666 511866 520400 528474 534590 541322 541328 541782 542268 544108 547236 547386 547848 548460 556876 559406 564301 565142 576564 597457 597502 614957 619347 646655 657505 670357 670366 671038 673696 681643 696236 708923 709565 709850 710362 710659 713185 716118 717516 720065 723161 725030 725115 728745 729231 729301 733862 733904 738826 749012 749245 758799 770264 775572 777847 778850 782040 782090 782351 782789 783382 791930 792654 795689 796939 801298 804230 805231 810436 814232 817278 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hole anal"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дырк анал"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (0.93%) |
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.