Query Metrics
7
Database Queries
7
Different statements
169.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.04 ms (85.20%) |
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 45985 383433 384813 386880 388350 403272 412001 413143 413535 415934 417711 426256 434672 437980 445046 446691 447092 447778 460572 460635 466470 466568 466905 468857 474381 475819 488008 492223 492402 492630 493841 499369 501746 510995 512920 516378 516401 519079 530860 540021 550042 551828 559584 565757 580567 580881 581878 584957 585075 589953 598885 599548 600980 606714 607650 616615 617855 620805 621073 621958 624890 625866 628667 632830 634956 640830 644010 644223 659945 698853 701199 707592 709006 709131 711604 715711 723744 726788 728088 728684 730741 732153 735964 738212 738511 748663 755001 755838 756874 756994 757368 758123 759133 759460 764213 768200 768947 773206 777676 779490 784677 788280 789636 791033 793700 796086 801145 804271 808102 810042 810256 810259 813116 813783 814395 815386 816703 824370 824769 826117 ] |
||||||||||||||||||||||||||||||
|
15.10 ms (8.93%) |
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 584957 589953 606714 620805 621958 644010 621073 616615 784677 813116 788280 796086 768200 793700 728684 723744 748663 759460 726788 735964 730741 756994 607650 632830 474381 412001 492223 447092 512920 698853 551828 732153 728088 758123 625866 45985 417711 813783 824769 815386 824370 466905 492630 492402 530860 565757 580881 581878 659945 701199 709006 711604 550042 644223 599548 628667 617855 640830 810259 756874 759133 808102 755838 757368 764213 634956 707592 434672 488008 715711 413535 403272 426256 445046 460572 460635 580567 559584 598885 777676 738212 773206 709131 413143 384813 383433 437980 814395 826117 585075 816703 466568 466470 493841 540021 510995 624890 600980 789636 801145 779490 810042 755001 738511 768947 791033 804271 810256 386880 388350 447778 475819 415934 516378 499369 516401 501746 519079 468857 446691 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (1.99%) |
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 45985 383433 384813 386880 388350 403272 412001 413143 413535 415934 417711 426256 434672 437980 445046 446691 447092 447778 460572 460635 466470 466568 466905 468857 474381 475819 488008 492223 492402 492630 493841 499369 501746 510995 512920 516378 516401 519079 530860 540021 550042 551828 559584 565757 580567 580881 581878 584957 585075 589953 598885 599548 600980 606714 607650 616615 617855 620805 621073 621958 624890 625866 628667 632830 634956 640830 644010 644223 659945 698853 701199 707592 709006 709131 711604 715711 723744 726788 728088 728684 730741 732153 735964 738212 738511 748663 755001 755838 756874 756994 757368 758123 759133 759460 764213 768200 768947 773206 777676 779490 784677 788280 789636 791033 793700 796086 801145 804271 808102 810042 810256 810259 813116 813783 814395 815386 816703 824370 824769 826117 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"body big"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.55 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"body большие"
]
|
||||||||||||||||||||||||||||||
|
1.28 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"body большие"
]
|
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.