Query Metrics
7
Database Queries
7
Different statements
165.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.44 ms (86.57%) |
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 380621 382021 383932 385892 391632 397772 398690 400348 400573 400589 402929 409121 413142 413315 420303 426415 442963 460142 482615 485822 494764 507263 514362 517018 524621 532718 535086 552025 554940 589464 592400 592428 592668 596041 604697 613678 615810 620636 621946 626520 648326 652931 662158 663415 672092 675481 676778 678874 680534 680934 681246 683094 683784 693340 700328 706761 713186 713964 717085 720541 720775 720784 721775 775591 775599 775627 775658 777117 778280 778505 782525 782762 786205 788663 789556 789596 789686 792657 793245 794464 794486 795051 795091 795646 799728 801383 801616 803116 803453 803918 813794 815288 815920 817227 817628 817666 817847 817943 818326 818485 818831 819039 819207 819823 820019 820022 820356 820724 821506 822385 823539 823579 824184 824803 825991 826059 826163 826561 826843 827043 ] |
||||||||||||||||||||||||||||||
|
11.90 ms (7.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 717085 720784 775591 775599 777117 778280 778505 782525 788663 789556 794464 795646 803453 803918 391632 400573 413315 382021 524621 652931 678874 621946 620636 494764 385892 383932 380621 397772 400348 400589 398690 402929 420303 426415 409121 413142 442963 815288 817628 817666 820019 823539 824803 826059 826163 826561 824184 817227 818831 819039 819823 820022 820356 822385 826843 827043 817943 819207 825991 813794 815920 817847 818326 818485 820724 821506 823579 482615 485822 532718 507263 535086 514362 517018 460142 552025 554940 680934 683784 713186 713964 648326 663415 672092 675481 676778 680534 693340 706761 721775 662158 681246 683094 700328 720541 720775 604697 613678 592428 596041 589464 592668 592400 615810 626520 775627 775658 782762 786205 789596 789686 792657 793245 794486 795051 795091 799728 801383 801616 803116 ] |
||||||||||||||||||||||||||||||
|
3.03 ms (1.83%) |
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 380621 382021 383932 385892 391632 397772 398690 400348 400573 400589 402929 409121 413142 413315 420303 426415 442963 460142 482615 485822 494764 507263 514362 517018 524621 532718 535086 552025 554940 589464 592400 592428 592668 596041 604697 613678 615810 620636 621946 626520 648326 652931 662158 663415 672092 675481 676778 678874 680534 680934 681246 683094 683784 693340 700328 706761 713186 713964 717085 720541 720775 720784 721775 775591 775599 775627 775658 777117 778280 778505 782525 782762 786205 788663 789556 789596 789686 792657 793245 794464 794486 795051 795091 795646 799728 801383 801616 803116 803453 803918 813794 815288 815920 817227 817628 817666 817847 817943 818326 818485 818831 819039 819207 819823 820019 820022 820356 820724 821506 822385 823539 823579 824184 824803 825991 826059 826163 826561 826843 827043 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"один лижет"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"лиза"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"лиза"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.93%) |
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.