Query Metrics
7
Database Queries
7
Different statements
189.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.83 ms (86.40%) |
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 32994 431410 457479 458915 465099 467678 491022 515226 515231 515724 519990 520714 525778 545420 545538 548533 548537 548558 550236 550320 550663 559205 578928 585169 590311 590496 596353 598583 598590 603940 605526 612842 617848 618893 624854 626742 626844 628308 628309 628516 633160 644989 645965 649561 655392 655747 655977 656751 659280 661670 661905 663374 663411 663883 664808 664842 664958 665830 666767 666769 668730 670238 670394 676467 679826 680036 687490 691994 693870 694122 694635 695921 699480 701984 707786 709982 717357 719989 720440 727490 728814 733523 743009 744637 746471 756090 756620 759409 759665 773071 773199 773522 773973 775621 775737 776016 783138 789203 797688 797697 800273 802069 803342 804376 807020 807537 810064 813318 813599 814034 814064 817014 817367 817618 818379 820958 822043 825078 827204 827465 ] |
||||||||||||||||||||||||||||||
|
16.21 ms (8.55%) |
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 695921 719989 585169 612842 810064 756090 773522 32994 548533 664958 659280 457479 431410 515724 515231 520714 598590 515226 759665 519990 676467 624854 578928 596353 817014 814064 818379 663411 668730 680036 661905 666769 649561 656751 661670 709982 598583 628516 603940 628309 789203 802069 813318 775737 727490 744637 797688 759409 733523 699480 775621 807537 773199 746471 491022 467678 545538 679826 814034 825078 644989 813599 827204 827465 525778 545420 550663 645965 655747 664808 691994 694635 701984 664842 687490 717357 655977 633160 626742 776016 797697 803342 773071 773973 756620 728814 720440 783138 800273 804376 628308 617848 743009 458915 465099 550236 548558 550320 548537 663374 666767 618893 817618 822043 817367 820958 559205 663883 670394 694122 665830 655392 670238 693870 707786 590496 626844 605526 590311 807020 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.35%) |
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 32994 431410 457479 458915 465099 467678 491022 515226 515231 515724 519990 520714 525778 545420 545538 548533 548537 548558 550236 550320 550663 559205 578928 585169 590311 590496 596353 598583 598590 603940 605526 612842 617848 618893 624854 626742 626844 628308 628309 628516 633160 644989 645965 649561 655392 655747 655977 656751 659280 661670 661905 663374 663411 663883 664808 664842 664958 665830 666767 666769 668730 670238 670394 676467 679826 680036 687490 691994 693870 694122 694635 695921 699480 701984 707786 709982 717357 719989 720440 727490 728814 733523 743009 744637 746471 756090 756620 759409 759665 773071 773199 773522 773973 775621 775737 776016 783138 789203 797688 797697 800273 802069 803342 804376 807020 807537 810064 813318 813599 814034 814064 817014 817367 817618 818379 820958 822043 825078 827204 827465 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"дрочит деду"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дрочк старый"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.79%) |
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.