Query Metrics
7
Database Queries
7
Different statements
197.98 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
176.56 ms (89.18%) |
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 218669 293121 358410 385479 423426 427557 428089 429501 429614 448319 458574 472392 475699 476698 482948 486111 488848 494565 495266 500510 505578 506241 509006 521160 528126 531549 546517 548388 550303 551030 559035 565938 568151 571479 574314 579513 580271 580470 588363 589530 589786 591558 593112 593459 596766 598431 599419 600437 601251 605924 612450 615367 618719 622024 623919 626285 627131 630052 630836 632112 651708 654865 656197 673102 675885 679455 679467 695738 695773 696794 697221 697449 705409 710597 712731 713627 714558 715252 716172 716188 721883 723786 725231 725468 726602 726817 733061 733525 734311 741057 742228 745925 748590 759763 766289 774037 774642 784767 789767 790001 794290 795101 800754 804086 805111 806715 806727 811843 814404 814571 816392 817454 818234 818552 820156 823350 823606 825324 825358 826781 ] |
||||||||||||||||||||||||||||||
|
12.24 ms (6.18%) |
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 825324 495266 548388 591558 705409 795101 476698 428089 472392 826781 695738 551030 723786 505578 358410 475699 679455 800754 804086 427557 818552 814571 823606 823350 825358 528126 531549 494565 482948 574314 546517 695773 651708 673102 697449 714558 716172 716188 600437 601251 605924 632112 593459 726817 733061 733525 726602 748590 774037 627131 630052 385479 818234 715252 766289 218669 656197 725468 486111 423426 559035 571479 615367 789767 725231 790001 589786 598431 817454 458574 500510 565938 589530 593112 599419 721883 550303 759763 774642 429614 820156 568151 675885 654865 712731 713627 588363 806727 805111 734311 811843 741057 506241 488848 814404 521160 580470 596766 580271 816392 509006 679467 784767 622024 448319 579513 806715 612450 794290 293121 429501 697221 696794 710597 618719 626285 630836 623919 742228 745925 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (1.20%) |
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 218669 293121 358410 385479 423426 427557 428089 429501 429614 448319 458574 472392 475699 476698 482948 486111 488848 494565 495266 500510 505578 506241 509006 521160 528126 531549 546517 548388 550303 551030 559035 565938 568151 571479 574314 579513 580271 580470 588363 589530 589786 591558 593112 593459 596766 598431 599419 600437 601251 605924 612450 615367 618719 622024 623919 626285 627131 630052 630836 632112 651708 654865 656197 673102 675885 679455 679467 695738 695773 696794 697221 697449 705409 710597 712731 713627 714558 715252 716172 716188 721883 723786 725231 725468 726602 726817 733061 733525 734311 741057 742228 745925 748590 759763 766289 774037 774642 784767 789767 790001 794290 795101 800754 804086 805111 806715 806727 811843 814404 814571 816392 817454 818234 818552 820156 823350 823606 825324 825358 826781 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.02%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden ass fuck"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скрыт жоп секс"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.74%) |
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.