Query Metrics
7
Database Queries
7
Different statements
188.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.03 ms (85.77%) |
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 569277 584342 589399 593183 593300 595540 599909 605923 606539 608432 609261 611282 611683 611948 612052 613271 613593 614950 616075 621592 621883 624212 624368 627577 627738 629334 630160 633471 636119 637389 639186 639912 641745 644014 645538 650067 656514 667179 668100 675253 682623 683006 687354 689584 690468 690528 692100 695456 695547 698468 701581 705305 708454 710208 710224 711850 714111 716588 716593 718071 718523 721385 723687 726756 741147 748299 752460 753929 756077 763878 769981 771400 772447 773259 774248 776745 777344 777715 777800 778572 779356 779711 779848 780461 782809 784434 785389 786198 786374 786427 786824 788337 789201 789495 789610 791819 792073 792747 792843 794568 794952 797669 797903 800119 800214 801378 801424 806002 806194 807068 808351 809174 810399 810560 810667 810797 811109 811968 812415 813412 ] |
||||||||||||||||||||||||||||||
|
15.41 ms (8.16%) |
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 683006 692100 695456 695547 698468 701581 705305 708454 710208 721385 645538 650067 656514 667179 668100 675253 682623 687354 689584 690468 690528 710224 711850 714111 716588 716593 718071 718523 569277 584342 593300 605923 611683 616075 624368 627577 633471 641745 644014 589399 613271 614950 624212 629334 639912 593183 606539 608432 609261 611282 611948 613593 627738 636119 637389 595540 599909 612052 621592 621883 630160 639186 776745 777344 777715 777800 778572 779356 779711 779848 780461 782809 785389 786198 786374 786824 789201 789495 792073 792747 792843 797669 800119 800214 801378 801424 807068 809174 812415 813412 786427 788337 794568 806002 808351 810560 811109 811968 723687 741147 748299 752460 753929 756077 763878 769981 771400 772447 773259 774248 784434 789610 791819 794952 797903 806194 810399 810667 810797 726756 ] |
||||||||||||||||||||||||||||||
|
3.92 ms (2.07%) |
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 569277 584342 589399 593183 593300 595540 599909 605923 606539 608432 609261 611282 611683 611948 612052 613271 613593 614950 616075 621592 621883 624212 624368 627577 627738 629334 630160 633471 636119 637389 639186 639912 641745 644014 645538 650067 656514 667179 668100 675253 682623 683006 687354 689584 690468 690528 692100 695456 695547 698468 701581 705305 708454 710208 710224 711850 714111 716588 716593 718071 718523 721385 723687 726756 741147 748299 752460 753929 756077 763878 769981 771400 772447 773259 774248 776745 777344 777715 777800 778572 779356 779711 779848 780461 782809 784434 785389 786198 786374 786427 786824 788337 789201 789495 789610 791819 792073 792747 792843 794568 794952 797669 797903 800119 800214 801378 801424 806002 806194 807068 808351 809174 810399 810560 810667 810797 811109 811968 812415 813412 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая длинные hair"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая длинные hair"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde long hair"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.89%) |
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.