Query Metrics
7
Database Queries
7
Different statements
159.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.63 ms (83.27%) |
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 458932 511314 513170 522162 539647 541519 548194 556897 558521 563089 568499 571360 576163 576918 577116 578621 586934 593912 595684 603747 606146 614193 614385 614582 615691 616991 626411 628682 631728 636502 643755 646949 652148 657527 663293 677740 689830 694631 699232 699885 701658 703950 704045 704074 708446 713120 722360 722370 722405 723266 740434 740836 744261 746799 749015 753588 754351 756967 757829 758088 760485 765665 768765 768805 769153 769165 769411 770048 770207 771882 771939 772637 772654 774782 774793 776819 777587 780303 780547 780887 780895 781645 781831 782584 784029 785605 785911 787373 787534 789436 790137 791179 792586 793110 796514 797053 798770 798964 799044 800672 801573 803625 803762 803770 803778 803816 804380 804617 804680 806642 806647 806658 807862 808967 812759 813182 818062 819926 819939 825488 ] |
||||||||||||||||||||||||||||||
|
16.00 ms (10.04%) |
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 577116 704045 689830 652148 677740 722360 723266 556897 576163 576918 578621 586934 593912 614582 614385 774782 780895 785911 792586 799044 803762 776819 785605 803778 804680 749015 754351 768765 801573 806658 770207 744261 769165 770048 765665 769411 771882 699232 701658 803625 803770 806642 813182 522162 798770 804617 804380 614193 819926 818062 819939 825488 458932 513170 511314 539647 571360 548194 568499 541519 558521 563089 646949 657527 699885 703950 708446 713120 722405 663293 694631 722370 595684 603747 606146 626411 628682 631728 616991 636502 643755 780887 790137 798964 800672 812759 774793 777587 787534 791179 796514 806647 760485 772637 781645 784029 787373 793110 808967 740434 769153 771939 772654 753588 756967 746799 757829 768805 740836 758088 615691 704074 780303 780547 781831 782584 789436 797053 803816 807862 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (1.84%) |
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 458932 511314 513170 522162 539647 541519 548194 556897 558521 563089 568499 571360 576163 576918 577116 578621 586934 593912 595684 603747 606146 614193 614385 614582 615691 616991 626411 628682 631728 636502 643755 646949 652148 657527 663293 677740 689830 694631 699232 699885 701658 703950 704045 704074 708446 713120 722360 722370 722405 723266 740434 740836 744261 746799 749015 753588 754351 756967 757829 758088 760485 765665 768765 768805 769153 769165 769411 770048 770207 771882 771939 772637 772654 774782 774793 776819 777587 780303 780547 780887 780895 781645 781831 782584 784029 785605 785911 787373 787534 789436 790137 791179 792586 793110 796514 797053 798770 798964 799044 800672 801573 803625 803762 803770 803778 803816 804380 804617 804680 806642 806647 806658 807862 808967 812759 813182 818062 819926 819939 825488 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hair рыжая соло"
]
|
||||||||||||||||||||||||||||||
|
2.03 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hair redhead solo"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hair рыжая соло"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.06%) |
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.