Query Metrics
7
Database Queries
7
Different statements
137.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.68 ms (85.36%) |
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 213136 387623 391681 393782 397666 403099 461127 533265 541176 543081 557111 561976 564666 575044 584032 584091 587917 593241 603733 610953 614930 629601 641422 647765 651236 662828 668686 668849 679701 684843 691362 701000 701453 702729 705583 705830 712164 719538 723525 723848 726890 729172 731808 737135 739711 742851 745987 749998 750348 752552 754179 754515 754872 755066 755100 757344 757615 757629 759050 760082 760547 769053 770092 770604 772087 772799 774197 775110 776685 779158 779593 780084 781338 782461 783710 785081 785189 785735 786158 786530 789965 790718 794123 794806 795232 795405 796113 797805 799744 800120 800449 804486 804934 811136 811901 812334 813117 813302 813697 813885 814097 816869 817409 817930 820342 821116 821183 823482 823596 823723 824206 824991 825133 825411 825448 825538 826665 827092 ] |
||||||||||||||||||||||||||||||
|
10.60 ms (7.69%) |
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 780084 785735 795405 737135 781338 796113 811901 754179 757629 759050 770604 729172 752552 772799 775110 799744 804486 397666 387623 816869 821116 825133 826665 584091 651236 691362 593241 783710 800120 782461 749998 786530 750348 755100 723848 760082 760547 754515 754872 701000 712164 813117 393782 213136 391681 817409 817930 823723 820342 823596 824991 827092 824206 813885 825336 825538 533265 543081 575044 647765 705583 557111 629601 603733 779158 789965 790718 813302 785081 786158 794123 804934 812334 755066 769053 794806 795232 797805 800449 811136 726890 739711 757344 770092 770353 742851 731808 757615 772087 745987 774197 614930 702729 705830 776685 779593 785189 403099 814097 723525 823482 813697 821183 825411 825448 461127 541176 564666 584032 701453 668686 668849 679701 719538 662828 684843 561976 587917 641422 610953 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (2.09%) |
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 213136 387623 391681 393782 397666 403099 461127 533265 541176 543081 557111 561976 564666 575044 584032 584091 587917 593241 603733 610953 614930 629601 641422 647765 651236 662828 668686 668849 679701 684843 691362 701000 701453 702729 705583 705830 712164 719538 723525 723848 726890 729172 731808 737135 739711 742851 745987 749998 750348 752552 754179 754515 754872 755066 755100 757344 757615 757629 759050 760082 760547 769053 770092 770604 772087 772799 774197 775110 776685 779158 779593 780084 781338 782461 783710 785081 785189 785735 786158 786530 789965 790718 794123 794806 795232 795405 796113 797805 799744 800120 800449 804486 804934 811136 811901 812334 813117 813302 813697 813885 814097 816869 817409 817930 820342 821116 821183 823482 823596 823723 824206 824991 825133 825411 825448 825538 826665 827092 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl horny"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк horny"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк horny"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (1.14%) |
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.