Query Metrics
7
Database Queries
7
Different statements
198.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.36 ms (85.24%) |
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 78637 80578 86926 386743 438053 454899 455769 457408 468580 480277 496377 497807 503069 511087 513111 525548 526678 531852 533817 536553 550467 553881 556239 558073 558455 559805 561352 566596 586885 593978 595746 598662 624091 628245 629600 636472 638507 646324 662584 667120 675030 681357 681938 684705 685176 689214 693802 699646 702440 703252 705040 705649 707774 710620 712101 712496 714806 715381 716000 717812 722978 727907 730023 734297 737121 738533 738618 739834 740565 743468 745720 751608 752758 757051 757089 757117 757133 757401 758358 758556 761426 764309 764961 765256 767078 769431 771854 774180 775306 775712 775832 776287 776523 778212 778988 780541 783138 784122 784459 785294 788128 789688 790768 791866 798079 798321 800292 800298 800302 801719 802735 802830 806889 808256 811489 813444 813884 813892 813938 814582 ] |
||||||||||||||||||||||||||||||
|
17.93 ms (9.03%) |
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 814582 813938 454899 480277 511087 533817 513111 531852 556239 558455 559805 550467 561352 662584 681357 705649 707774 712101 712496 681938 693802 705040 710620 722978 646324 667120 675030 684705 685176 689214 715381 716000 717812 553881 558073 566596 629600 638507 595746 624091 628245 636472 593978 598662 586885 776287 778212 778988 784122 790768 798321 806889 808256 775712 775832 780541 784459 798079 802830 813444 730023 737121 757117 764961 769431 785294 788128 791866 801719 802735 811489 734297 738533 745720 751608 764309 765256 738618 739834 743468 774180 740565 752758 761426 771854 727907 757051 757089 757133 757401 758358 758556 767078 699646 702440 703252 714806 775306 776523 783138 789688 800292 800298 800302 438053 497807 386743 80578 78637 86926 813884 813892 468580 457408 455769 503069 525548 526678 536553 496377 ] |
||||||||||||||||||||||||||||||
|
3.78 ms (1.90%) |
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 78637 80578 86926 386743 438053 454899 455769 457408 468580 480277 496377 497807 503069 511087 513111 525548 526678 531852 533817 536553 550467 553881 556239 558073 558455 559805 561352 566596 586885 593978 595746 598662 624091 628245 629600 636472 638507 646324 662584 667120 675030 681357 681938 684705 685176 689214 693802 699646 702440 703252 705040 705649 707774 710620 712101 712496 714806 715381 716000 717812 722978 727907 730023 734297 737121 738533 738618 739834 740565 743468 745720 751608 752758 757051 757089 757117 757133 757401 758358 758556 761426 764309 764961 765256 767078 769431 771854 774180 775306 775712 775832 776287 776523 778212 778988 780541 783138 784122 784459 785294 788128 789688 790768 791866 798079 798321 800292 800298 800302 801719 802735 802830 806889 808256 811489 813444 813884 813892 813938 814582 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"самая"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сам"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сам"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.