Query Metrics
7
Database Queries
7
Different statements
164.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.66 ms (86.56%) |
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 95873 96468 97107 103696 189022 192951 383832 384811 385264 388847 393416 396787 429278 435926 441829 452097 454462 478577 494935 523059 524713 525896 533219 546296 547136 547268 548443 549326 550068 553245 560205 576806 585269 592902 597736 597903 600955 606742 612821 618352 621066 622086 630203 632441 633537 635514 640909 640917 643008 649114 649546 650786 653618 653624 665928 676196 676295 682924 686860 692457 700196 702892 706211 706602 708747 713686 715352 718976 720379 721930 726638 726657 728742 729538 730753 731944 732326 732704 738779 758074 763367 766036 767190 767861 769161 770797 771255 771986 772026 773961 775754 778420 781996 784798 784803 788831 793468 793472 795869 804979 808065 809519 809526 810227 810376 811540 815339 815961 818447 819180 819193 820032 823252 823471 824325 824420 824421 825998 826230 828758 ] |
||||||||||||||||||||||||||||||
|
12.23 ms (7.42%) |
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 547268 784803 758074 784798 632441 547136 804979 706602 795869 706211 700196 713686 820032 778420 606742 649546 524713 825998 819180 718976 823252 788831 618352 793468 775754 553245 546296 708747 823471 548443 715352 769161 818447 824325 692457 622086 732704 702892 810376 767861 826230 771986 811540 597903 96468 621066 95873 810227 441829 771255 643008 454462 676196 682924 452097 494935 728742 815339 640909 103696 653624 767190 721930 384811 793472 640917 653618 665928 731944 429278 550068 549326 809519 726638 828758 635514 383832 676295 772026 630203 97107 770797 576806 612821 592902 385264 533219 525896 819193 815961 650786 809526 738779 773961 824420 686860 585269 808065 781996 824421 600955 729538 730753 726657 763367 388847 633537 766036 597736 478577 189022 523059 393416 560205 396787 435926 720379 732326 192951 649114 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.96%) |
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 95873 96468 97107 103696 189022 192951 383832 384811 385264 388847 393416 396787 429278 435926 441829 452097 454462 478577 494935 523059 524713 525896 533219 546296 547136 547268 548443 549326 550068 553245 560205 576806 585269 592902 597736 597903 600955 606742 612821 618352 621066 622086 630203 632441 633537 635514 640909 640917 643008 649114 649546 650786 653618 653624 665928 676196 676295 682924 686860 692457 700196 702892 706211 706602 708747 713686 715352 718976 720379 721930 726638 726657 728742 729538 730753 731944 732326 732704 738779 758074 763367 766036 767190 767861 769161 770797 771255 771986 772026 773961 775754 778420 781996 784798 784803 788831 793468 793472 795869 804979 808065 809519 809526 810227 810376 811540 815339 815961 818447 819180 819193 820032 823252 823471 824325 824420 824421 825998 826230 828758 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina sex"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская секс"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.94%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.