Query Metrics
7
Database Queries
7
Different statements
173.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.32 ms (84.89%) |
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 73947 152544 161969 172541 260590 307352 321297 379578 385682 398702 400727 402928 404083 449272 533335 536133 538016 572434 573912 577677 588665 617179 628295 634064 641439 644338 652262 656796 668397 668887 669646 677735 686044 688639 697754 704409 710542 713983 716407 718497 722517 723555 724705 726449 726833 726850 727757 728176 728502 728900 734366 734415 736327 743548 744148 744830 746660 751756 752040 757282 757526 760634 772603 780372 782757 784204 788717 792204 792231 792939 793322 794518 795006 795025 797024 797606 798871 801905 803085 803564 807997 809701 810655 812924 813655 815766 817134 817296 817360 817517 817554 817835 818034 818144 818482 818575 818588 818836 819012 819076 819080 819439 819507 820198 820342 820681 820688 820750 822881 823157 824437 824497 824711 825065 825752 826409 826736 827198 827960 827974 ] |
||||||||||||||||||||||||||||||
|
17.00 ms (9.79%) |
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 824497 826409 819080 819439 824437 824711 825065 449272 536133 538016 533335 577677 573912 688639 704409 713983 718497 652262 656796 668397 686044 628295 644338 634064 617179 588665 641439 782757 792939 794518 757282 772603 793322 795006 795025 734415 728176 743548 728900 734366 744148 744830 746660 726449 728502 760634 697754 780372 792204 792231 797024 798871 803564 807997 400727 404083 402928 152544 172541 260590 817517 817554 818482 723555 813655 819012 817134 820750 822881 823157 817360 819507 827974 827960 572434 677735 722517 669646 716407 668887 809701 801905 812924 727757 784204 724705 726833 736327 726850 752040 751756 757526 710542 797606 803085 810655 161969 307352 379578 788717 321297 385682 73947 398702 815766 817296 817835 818034 818575 818836 819076 820688 825752 826736 818144 818588 820198 820342 820681 827198 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.53%) |
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 73947 152544 161969 172541 260590 307352 321297 379578 385682 398702 400727 402928 404083 449272 533335 536133 538016 572434 573912 577677 588665 617179 628295 634064 641439 644338 652262 656796 668397 668887 669646 677735 686044 688639 697754 704409 710542 713983 716407 718497 722517 723555 724705 726449 726833 726850 727757 728176 728502 728900 734366 734415 736327 743548 744148 744830 746660 751756 752040 757282 757526 760634 772603 780372 782757 784204 788717 792204 792231 792939 793322 794518 795006 795025 797024 797606 798871 801905 803085 803564 807997 809701 810655 812924 813655 815766 817134 817296 817360 817517 817554 817835 818034 818144 818482 818575 818588 818836 819012 819076 819080 819439 819507 820198 820342 820681 820688 820750 822881 823157 824437 824497 824711 825065 825752 826409 826736 827198 827960 827974 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс лиза"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебет потом лижет"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс лиза"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.87%) |
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.