Query Metrics
7
Database Queries
7
Different statements
166.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.19 ms (83.03%) |
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 397284 490812 541592 541618 541634 541671 541690 541738 541806 541821 541830 541872 541886 543471 544281 548278 561007 561030 562823 564545 567396 573914 576623 576626 576629 576641 576645 576706 576711 576713 577358 577368 581372 583533 592514 595731 619405 620172 621319 621698 622979 628148 641120 641879 643007 643114 644309 644922 651630 662137 670103 670108 670110 670761 670772 670773 671714 671751 672151 672181 681040 681085 687119 687249 689699 689702 690810 699546 699594 699667 703037 703046 703051 703062 703091 703097 703432 703509 703512 703521 703554 705278 705514 705520 705521 705537 705546 705878 705913 706611 706899 707318 708099 708421 708422 708424 708468 708476 708525 711997 712001 713695 719097 719137 720726 724173 725568 726205 744276 744287 755460 755474 784308 789659 797771 800625 805433 810689 813115 818278 ] |
||||||||||||||||||||||||||||||
|
17.58 ms (10.56%) |
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 541872 573914 541806 548278 562823 576713 543471 576645 576706 576711 592514 622979 619405 576641 699594 703097 703512 713695 681085 705521 620172 641879 800625 813115 744276 744287 703037 703046 703521 490812 681040 818278 687249 670103 561007 541618 561030 705278 705514 707318 711997 703432 705520 719137 671714 689699 699667 703554 708525 576626 644309 643114 628148 789659 703062 712001 577368 541738 544281 689702 662137 576623 583533 621698 670772 755474 541634 541690 541592 576629 541830 541886 541821 541671 397284 644922 564545 703051 705878 703509 720726 708468 595731 810689 567396 577358 581372 670110 670773 708421 708424 719097 651630 670108 670761 672151 672181 690810 706611 671751 687119 699546 705537 705546 705913 708422 708476 621319 643007 641120 805433 755460 784308 797771 724173 726205 725568 703091 706899 708099 ] |
||||||||||||||||||||||||||||||
|
3.43 ms (2.06%) |
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 397284 490812 541592 541618 541634 541671 541690 541738 541806 541821 541830 541872 541886 543471 544281 548278 561007 561030 562823 564545 567396 573914 576623 576626 576629 576641 576645 576706 576711 576713 577358 577368 581372 583533 592514 595731 619405 620172 621319 621698 622979 628148 641120 641879 643007 643114 644309 644922 651630 662137 670103 670108 670110 670761 670772 670773 671714 671751 672151 672181 681040 681085 687119 687249 689699 689702 690810 699546 699594 699667 703037 703046 703051 703062 703091 703097 703432 703509 703512 703521 703554 705278 705514 705520 705521 705537 705546 705878 705913 706611 706899 707318 708099 708421 708422 708424 708468 708476 708525 711997 712001 713695 719097 719137 720726 724173 725568 726205 744276 744287 755460 755474 784308 789659 797771 800625 805433 810689 813115 818278 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"films anal"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фильм анал"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.02%) |
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.