Query Metrics
7
Database Queries
7
Different statements
211.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.37 ms (87.74%) |
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 41776 42536 69969 105477 118889 134454 150470 153246 154675 187542 229704 248347 250396 349135 352187 352189 382207 382347 382411 383402 385021 385053 386023 386063 386974 387325 390678 390986 392019 393872 395523 396818 397675 398085 409060 410253 412663 415837 416593 424581 427722 435539 441126 441925 443095 443106 448090 454983 459659 462337 467636 471664 471685 487429 511862 512065 513968 518505 523726 529738 530438 531866 531876 531879 534056 534082 537750 540942 541278 547386 547788 548459 553789 554257 560570 564247 582522 591221 612913 622677 628096 641689 642029 656895 664226 668672 684706 696607 710211 714086 716744 725618 725619 735194 735914 738824 742360 750426 752594 753552 770210 788497 789028 789208 789463 792736 792739 794305 794322 806403 817007 827826 827839 827894 827907 827927 827939 827945 827962 ] |
||||||||||||||||||||||||||||||
|
16.27 ms (7.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 467636 547788 684706 591221 788497 397675 248347 471664 153246 352189 41776 415837 441925 454983 459659 471685 424581 512065 523726 518505 622677 531866 668672 656895 664226 710211 792736 725618 738824 752594 118889 250396 349135 827945 530438 641689 753552 386974 105477 628096 462337 541278 412663 448090 386063 385021 187542 393872 352187 42536 398085 817007 827907 827894 827839 827927 827939 827826 827962 537750 531876 534056 529738 560570 540942 553789 582522 548459 547386 554257 612913 794322 792739 757736 789208 794305 390678 395523 443095 487429 534082 511862 513968 696607 714086 642029 789028 789463 750426 742360 770210 725619 386023 383402 134454 229704 69969 410253 531879 564247 716744 735194 735914 806403 385053 154675 150470 392019 382207 382347 382411 387325 390986 396818 409060 416593 441126 443106 435539 427722 ] |
||||||||||||||||||||||||||||||
|
3.42 ms (1.62%) |
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 41776 42536 69969 105477 118889 134454 150470 153246 154675 187542 229704 248347 250396 349135 352187 352189 382207 382347 382411 383402 385021 385053 386023 386063 386974 387325 390678 390986 392019 393872 395523 396818 397675 398085 409060 410253 412663 415837 416593 424581 427722 435539 441126 441925 443095 443106 448090 454983 459659 462337 467636 471664 471685 487429 511862 512065 513968 518505 523726 529738 530438 531866 531876 531879 534056 534082 537750 540942 541278 547386 547788 548459 553789 554257 560570 564247 582522 591221 612913 622677 628096 641689 642029 656895 664226 668672 684706 696607 710211 714086 716744 725618 725619 735194 735914 738824 742360 750426 752594 753552 770210 788497 789028 789208 789463 792736 792739 794305 794322 806403 817007 827826 827839 827894 827907 827927 827939 827945 827962 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жесткое раком"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.71%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.44 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хардкор рак"
]
|
||||||||||||||||||||||||||||||
|
1.16 ms (0.55%) |
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.