Query Metrics
7
Database Queries
7
Different statements
221.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
201.56 ms (90.82%) |
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 448954 487661 490237 531739 538176 542349 545175 545646 555408 557617 561296 575591 581918 621381 627167 632300 634289 634618 635530 647797 651030 652469 671913 688127 695410 697736 715535 715828 718610 719879 719954 720149 722268 722957 723214 723249 723712 724754 726333 726964 730588 732940 734530 738256 740762 742485 742527 747788 750004 758609 761901 762126 764049 764062 764810 764988 766784 769331 777244 777897 778369 778697 780083 780110 780225 780562 780767 782355 782730 786674 787648 788399 789644 790100 793805 795197 795660 795787 799100 801219 803792 808251 816110 816679 816795 817206 817532 818392 819184 819296 819921 819930 820146 820193 821758 823554 824066 824237 824448 824736 824907 825048 825085 825152 825480 825657 825822 825953 825984 826042 826335 826572 826708 828167 828314 828442 828607 ] |
||||||||||||||||||||||||||||||
|
10.50 ms (4.73%) |
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 825657 490237 581918 695410 651030 723214 671913 545175 627167 778369 780083 780225 788399 789644 793805 777897 780767 723712 732940 742485 758609 786674 761901 724754 726964 734530 738256 742527 762126 764062 747788 769331 799100 819296 820146 816795 825822 826132 817532 819184 823554 824066 826644 818392 820193 824448 828167 828442 795197 730588 740762 764988 787648 801219 803792 808251 764810 766784 764049 750004 780110 780562 790100 795660 795787 726333 632300 715828 575591 561296 824205 448954 634618 824237 825953 825984 826708 826572 819921 819930 824736 825085 825152 816679 821758 826335 816110 817206 824907 825048 825480 828314 826042 828607 487661 538176 531739 545646 542349 555408 557617 647797 715535 719879 720149 722268 723249 697736 652469 688127 718610 719954 722957 635530 634289 621381 777244 778697 782355 782730 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.31%) |
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 448954 487661 490237 531739 538176 542349 545175 545646 555408 557617 561296 575591 581918 621381 627167 632300 634289 634618 635530 647797 651030 652469 671913 688127 695410 697736 715535 715828 718610 719879 719954 720149 722268 722957 723214 723249 723712 724754 726333 726964 730588 732940 734530 738256 740762 742485 742527 747788 750004 758609 761901 762126 764049 764062 764810 764988 766784 769331 777244 777897 778369 778697 780083 780110 780225 780562 780767 782355 782730 786674 787648 788399 789644 790100 793805 795197 795660 795787 799100 801219 803792 808251 816110 816679 816795 817206 817532 818392 819184 819296 819921 819930 820146 820193 821758 823554 824066 824237 824448 824736 824907 825048 825085 825152 825480 825657 825822 825953 825984 826042 826335 826572 826708 828167 828314 828442 828607 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur fucked"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск fucked"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск fucked"
]
|
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.