Query Metrics
7
Database Queries
7
Different statements
143.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.11 ms (82.86%) |
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 48153 86510 88945 90091 237886 364775 383792 393863 491301 494903 529347 538035 549305 555198 558428 568999 569213 569535 571202 574765 619569 619686 628803 629780 630377 654198 661957 663356 680049 680936 683282 689801 698936 701311 705977 707581 709337 709714 710378 712667 720333 720841 721751 723635 724661 726128 727262 732028 732940 736297 738543 741456 745867 745882 745887 745903 746306 747251 748838 750743 755242 756878 757382 759847 761938 761957 762981 764716 764874 765387 765718 765936 766142 770204 771101 773667 778500 780877 783440 783909 784165 786961 795786 799067 799167 799856 800439 801197 803209 805939 811192 815145 815244 815403 815407 815551 815701 815780 816202 816927 817738 817741 818542 818584 818935 819998 820400 820994 821304 821682 821729 823505 823916 824042 824135 825216 825314 827972 828193 828335 ] |
||||||||||||||||||||||||||||||
|
11.06 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 619569 823916 828193 86510 821729 803209 745903 654198 750743 705977 820994 709337 771101 745882 818542 824135 799167 568999 90091 821682 569535 701311 707581 773667 745867 799067 529347 816202 815780 819998 815407 558428 569213 571202 698936 709714 619686 805939 748838 745887 761938 732028 755242 628803 88945 555198 732940 766142 817738 815701 723635 815145 815551 663356 783440 746306 811192 818584 828335 494903 726128 712667 364775 821304 816927 538035 661957 780877 765387 765936 237886 815244 823505 818935 824042 680049 689801 680936 721751 630377 784165 741456 764716 799856 724661 736297 770204 747251 738543 756878 778500 48153 574765 383792 393863 820400 825216 815403 825314 491301 710378 720333 786961 757382 727262 827972 683282 629780 783909 800439 801197 764874 795786 762981 761957 765718 817741 549305 720841 759847 ] |
||||||||||||||||||||||||||||||
|
5.16 ms (3.59%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"dirty секс"
]
|
||||||||||||||||||||||||||||||
|
3.18 ms (2.21%) |
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 48153 86510 88945 90091 237886 364775 383792 393863 491301 494903 529347 538035 549305 555198 558428 568999 569213 569535 571202 574765 619569 619686 628803 629780 630377 654198 661957 663356 680049 680936 683282 689801 698936 701311 705977 707581 709337 709714 710378 712667 720333 720841 721751 723635 724661 726128 727262 732028 732940 736297 738543 741456 745867 745882 745887 745903 746306 747251 748838 750743 755242 756878 757382 759847 761938 761957 762981 764716 764874 765387 765718 765936 766142 770204 771101 773667 778500 780877 783440 783909 784165 786961 795786 799067 799167 799856 800439 801197 803209 805939 811192 815145 815244 815403 815407 815551 815701 815780 816202 816927 817738 817741 818542 818584 818935 819998 820400 820994 821304 821682 821729 823505 823916 824042 824135 825216 825314 827972 828193 828335 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"dirty sex"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"dirty секс"
]
|
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.