Query Metrics
7
Database Queries
7
Different statements
183.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.07 ms (85.42%) |
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 416038 422360 435613 443105 456030 469770 489207 490125 490646 507616 508602 517485 518860 519235 521210 525468 535324 535706 538956 544585 545744 549389 550356 555175 559920 570891 578866 584080 585416 585434 593261 594067 596041 601182 606362 608355 615810 629977 632949 633071 636968 637409 637538 648587 649955 652162 667172 674493 675230 684233 684965 687512 688019 688299 690084 692460 704097 705452 705796 707454 712183 714785 715472 715965 716516 717651 718985 722116 725447 733396 733962 744215 752914 774403 776325 776635 782534 788560 789616 794409 794414 796234 796265 800726 801844 804269 804769 805833 813613 813862 815398 815957 817058 817136 817789 817964 818510 818787 819350 819412 820085 820472 820493 821013 822158 823946 824365 824403 824553 824857 825183 826314 826597 826599 826787 827100 827102 827546 827689 828294 ] |
||||||||||||||||||||||||||||||
|
13.48 ms (7.33%) |
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 456030 416038 422360 435613 443105 489207 525468 490646 507616 517485 817964 819412 820472 820493 822158 824365 824403 824553 813613 774403 826597 826599 813862 817789 823946 826787 827100 827102 827546 817058 818510 818787 820085 821013 824857 815398 815957 817136 819350 825183 826314 828294 827689 490125 519235 521210 518860 535706 538956 508602 535324 469770 544585 550356 545744 549389 584080 559920 648587 649955 652162 674493 688019 692460 705796 714785 715472 715965 716516 684233 684965 690084 704097 705452 707454 712183 667172 675230 687512 688299 717651 718985 722116 555175 570891 578866 585416 632949 637409 596041 633071 637538 585434 593261 594067 601182 606362 629977 608355 615810 636968 776635 794409 794414 796234 801844 805833 776325 782534 788560 789616 796265 800726 804269 804769 725447 733396 733962 744215 752914 ] |
||||||||||||||||||||||||||||||
|
4.91 ms (2.67%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
3.43 ms (1.86%) |
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 416038 422360 435613 443105 456030 469770 489207 490125 490646 507616 508602 517485 518860 519235 521210 525468 535324 535706 538956 544585 545744 549389 550356 555175 559920 570891 578866 584080 585416 585434 593261 594067 596041 601182 606362 608355 615810 629977 632949 633071 636968 637409 637538 648587 649955 652162 667172 674493 675230 684233 684965 687512 688019 688299 690084 692460 704097 705452 705796 707454 712183 714785 715472 715965 716516 717651 718985 722116 725447 733396 733962 744215 752914 774403 776325 776635 782534 788560 789616 794409 794414 796234 796265 800726 801844 804269 804769 805833 813613 813862 815398 815957 817058 817136 817789 817964 818510 818787 819350 819412 820085 820472 820493 821013 822158 823946 824365 824403 824553 824857 825183 826314 826597 826599 826787 827100 827102 827546 827689 828294 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy hairy"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy волосатая"
]
|
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.