Query Metrics
7
Database Queries
7
Different statements
170.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.69 ms (87.23%) |
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 472888 500310 511424 530128 531605 533602 535136 537630 538042 538749 538919 542278 544462 544638 545043 546296 547077 548116 556091 556146 556952 561265 572671 577654 577734 581845 584697 584966 588063 596574 606212 606521 606524 606539 606843 615291 616178 616534 616571 616671 617492 618074 623183 632418 633427 633929 633945 633974 634039 636605 636995 637028 639078 641488 642596 645213 647915 648279 648393 651243 651355 653737 654221 654973 654974 658245 658638 665939 674136 675636 683932 685933 694861 696248 696407 703428 704114 705306 708125 711268 717219 717955 719915 719941 720780 720826 725757 726264 728718 728750 733571 734996 738241 738391 739720 741064 741682 746470 747058 748118 748395 750133 750277 750303 750884 751857 752956 758321 764448 771071 773857 785710 792804 795967 797385 798279 808298 811658 811996 812877 ] |
||||||||||||||||||||||||||||||
|
11.52 ms (6.76%) |
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 511424 531605 530128 533602 535136 537630 538042 538749 538919 500310 472888 542278 544462 548116 561265 581845 584966 544638 546296 547077 556091 577734 556146 556952 584697 648279 648393 651243 653737 654974 658638 675636 694861 703428 704114 711268 717955 719915 720780 645213 647915 651355 654221 665939 674136 696407 705306 654973 658245 683932 685933 696248 708125 717219 719941 720826 545043 572671 577654 588063 596574 606212 616178 639078 633929 642596 606521 606539 616571 616671 618074 623183 632418 633427 633974 634039 636995 641488 616534 617492 633945 636605 637028 808298 812877 792804 798279 738241 750277 752956 758321 785710 795967 797385 811658 811996 738391 741682 750884 726264 734996 750133 764448 771071 725757 728718 728750 733571 741064 746470 748118 750303 751857 773857 739720 747058 748395 606524 606843 615291 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.77%) |
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 472888 500310 511424 530128 531605 533602 535136 537630 538042 538749 538919 542278 544462 544638 545043 546296 547077 548116 556091 556146 556952 561265 572671 577654 577734 581845 584697 584966 588063 596574 606212 606521 606524 606539 606843 615291 616178 616534 616571 616671 617492 618074 623183 632418 633427 633929 633945 633974 634039 636605 636995 637028 639078 641488 642596 645213 647915 648279 648393 651243 651355 653737 654221 654973 654974 658245 658638 665939 674136 675636 683932 685933 694861 696248 696407 703428 704114 705306 708125 711268 717219 717955 719915 719941 720780 720826 725757 726264 728718 728750 733571 734996 738241 738391 739720 741064 741682 746470 747058 748118 748395 750133 750277 750303 750884 751857 752956 758321 764448 771071 773857 785710 792804 795967 797385 798279 808298 811658 811996 812877 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy interracial"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак межрасов"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.81%) |
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.