Query Metrics
7
Database Queries
7
Different statements
151.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.09 ms (85.80%) |
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 401811 497055 545813 548499 551118 552590 552906 562451 566570 581980 584042 584475 606767 611193 614033 617602 619443 620431 627554 632763 635608 636400 636930 649245 653174 656622 657227 661908 665307 666686 667473 671242 676617 690198 702332 702995 708086 710996 712183 714965 715002 722920 724021 729723 731133 733316 733933 734202 736254 737277 740022 740730 742070 743973 745616 748458 750507 756716 760690 761511 762596 763570 764456 764520 767771 768237 769935 773407 777980 778009 779265 780237 783055 783354 783699 784024 784339 785918 786677 787745 787923 788648 788742 790325 791651 791822 792227 793946 795258 795601 797297 797490 798984 799482 802985 803536 803809 804749 808893 813392 814414 815223 815242 815452 815749 816020 816246 816542 816554 816695 816925 816932 817951 819667 823243 823274 825277 826998 ] |
||||||||||||||||||||||||||||||
|
11.89 ms (7.84%) |
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 635608 786677 799482 804749 788648 793946 736254 764520 765378 731133 784339 653174 661908 816246 816542 815749 562451 671242 552906 632763 740022 769935 734202 767771 708086 714965 791822 816925 566570 665307 657227 710996 656622 636930 620431 636400 795258 745616 606767 815223 816020 545813 614033 798984 729723 733933 768237 764456 742070 627554 803809 401811 823243 814414 817951 816554 584042 584475 666686 712183 690198 617602 785918 778009 787923 788742 802985 808893 762596 783354 783699 790325 792227 795601 740730 743973 761511 779265 783055 797297 797490 667473 676617 722920 733316 748458 813392 826998 815452 548499 823274 815242 825277 497055 552590 702995 551118 619443 777980 780237 784024 791651 737277 763570 756716 715002 803536 581980 649245 724021 787745 762326 773407 750507 760690 611193 702332 819667 816695 816932 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.92%) |
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 401811 497055 545813 548499 551118 552590 552906 562451 566570 581980 584042 584475 606767 611193 614033 617602 619443 620431 627554 632763 635608 636400 636930 649245 653174 656622 657227 661908 665307 666686 667473 671242 676617 690198 702332 702995 708086 710996 712183 714965 715002 722920 724021 729723 731133 733316 733933 734202 736254 737277 740022 740730 742070 743973 745616 748458 750507 756716 760690 761511 762596 763570 764456 764520 767771 768237 769935 773407 777980 778009 779265 780237 783055 783354 783699 784024 784339 785918 786677 787745 787923 788648 788742 790325 791651 791822 792227 793946 795258 795601 797297 797490 798984 799482 802985 803536 803809 804749 808893 813392 814414 815223 815242 815452 815749 816020 816246 816542 816554 816695 816925 816932 817951 819667 823243 823274 825277 826998 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"on work sex"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"work секс"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"work секс"
]
|
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.