Query Metrics
7
Database Queries
7
Different statements
395.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.31 ms (54.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"best friend жен"
]
|
||||||||||||||||||||||||||||||
|
158.72 ms (40.18%) |
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 396944 408427 441892 446154 456200 466620 485611 488822 489033 504079 511199 518952 521505 521513 527284 529742 534183 536392 545014 546089 556998 557051 557096 562192 563721 577537 578521 578545 578579 588121 592708 593967 599151 604993 615079 621718 625608 631417 631851 632989 637765 644030 648655 648672 648984 650258 650602 654614 655449 657852 661950 664616 665966 665989 666030 666046 672281 677511 679660 684531 694896 699428 702275 702302 704314 712959 718849 719792 728642 730928 732016 732916 734079 734701 736169 737537 739956 742022 744381 744820 745954 749555 750618 751946 756680 756811 757732 757866 758680 759760 761670 764125 764378 766171 766333 766762 770591 774282 780743 785035 785157 786565 787024 787102 791174 791742 792571 793081 793223 794433 798161 798778 799720 800012 800784 801074 803590 810017 812812 ] |
||||||||||||||||||||||||||||||
|
14.70 ms (3.72%) |
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 650602 679660 648984 665966 665989 577537 578579 588121 780743 812812 786565 794433 728642 734079 756680 764378 764125 766762 644030 801074 810017 521505 396944 798778 745954 799720 791174 488822 441892 485611 456200 702302 664616 545014 592708 758680 785035 744820 757866 766171 739943 749555 734701 737537 730928 712959 599151 787024 792571 750618 732916 672281 654614 744381 759760 511199 521513 529742 534183 536392 557051 563721 546089 648672 661950 677511 666046 615079 621718 631851 593967 604993 637765 625608 631417 793223 793081 800784 791742 798161 742022 756811 766333 770591 446154 527284 518952 702275 650258 736169 648655 785157 803590 787102 732016 751946 632989 489033 578521 557096 562192 657852 666030 718849 684531 699428 704314 739956 556998 757732 466620 800012 774282 761670 408427 504079 578545 694896 719792 655449 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (0.69%) |
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 396944 408427 441892 446154 456200 466620 485611 488822 489033 504079 511199 518952 521505 521513 527284 529742 534183 536392 545014 546089 556998 557051 557096 562192 563721 577537 578521 578545 578579 588121 592708 593967 599151 604993 615079 621718 625608 631417 631851 632989 637765 644030 648655 648672 648984 650258 650602 654614 655449 657852 661950 664616 665966 665989 666030 666046 672281 677511 679660 684531 694896 699428 702275 702302 704314 712959 718849 719792 728642 730928 732016 732916 734079 734701 736169 737537 739956 742022 744381 744820 745954 749555 750618 751946 756680 756811 757732 757866 758680 759760 761670 764125 764378 766171 766333 766762 770591 774282 780743 785035 785157 786565 787024 787102 791174 791742 792571 793081 793223 794433 798161 798778 799720 800012 800784 801074 803590 810017 812812 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (0.60%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"best friend жен"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"best friend wife"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.38%) |
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.