Query Metrics
7
Database Queries
7
Different statements
171.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.42 ms (82.99%) |
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 538891 539627 540257 541329 541373 541378 541388 541602 541605 541607 541625 541642 541643 541872 542190 542194 544267 544340 544349 546747 546779 546954 547265 548228 549267 549302 549369 549405 549780 549945 550322 562857 563079 566698 567008 567368 569295 570778 570804 571024 571240 572535 572653 574204 576623 576684 576715 577364 577370 580863 581353 583854 589761 592403 592456 603212 605512 615735 615737 615741 618868 622316 628297 649956 654400 668950 670111 670958 671316 671754 672099 672105 675327 678008 681002 681075 681118 681148 681153 681159 683371 684267 688078 692103 694023 694485 699689 702088 702456 702895 702947 702974 702977 703437 704084 706610 706612 708418 708790 719059 719062 719094 722190 724867 727299 727490 730853 732437 733020 752072 755463 755474 756418 758987 786031 789625 789981 800629 815531 815941 ] |
||||||||||||||||||||||||||||||
|
18.08 ms (10.54%) |
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 727490 542190 571024 572653 576715 577370 618868 681148 702974 541642 540257 549405 654400 546779 615741 550322 544267 549945 649956 688078 670111 671316 702456 704084 605512 800629 730853 752072 703437 719062 815531 538891 547265 549267 681153 708790 628297 758987 756418 732437 755463 706610 544349 699689 755474 541605 546954 541329 541625 603212 548228 577364 566698 576684 589761 592403 672099 786031 815941 569295 544340 570778 681118 702977 675327 694023 668950 672105 702895 615737 789625 724867 541373 541378 572535 541607 563079 583854 592456 539627 683371 706612 733020 541872 541388 581353 549369 670958 681002 681159 684267 694485 722190 546747 671754 567008 549302 549780 692103 719059 702947 562857 789981 574204 541602 615735 570804 719094 678008 702088 681075 708418 622316 727299 571240 580863 576623 567368 541643 542194 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (1.87%) |
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 538891 539627 540257 541329 541373 541378 541388 541602 541605 541607 541625 541642 541643 541872 542190 542194 544267 544340 544349 546747 546779 546954 547265 548228 549267 549302 549369 549405 549780 549945 550322 562857 563079 566698 567008 567368 569295 570778 570804 571024 571240 572535 572653 574204 576623 576684 576715 577364 577370 580863 581353 583854 589761 592403 592456 603212 605512 615735 615737 615741 618868 622316 628297 649956 654400 668950 670111 670958 671316 671754 672099 672105 675327 678008 681002 681075 681118 681148 681153 681159 683371 684267 688078 692103 694023 694485 699689 702088 702456 702895 702947 702974 702977 703437 704084 706610 706612 708418 708790 719059 719062 719094 722190 724867 727299 727490 730853 732437 733020 752072 755463 755474 756418 758987 786031 789625 789981 800629 815531 815941 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"long sex films"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"длинные секс фильм"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.