Query Metrics
7
Database Queries
7
Different statements
144.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.87 ms (84.94%) |
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 4387 310133 390233 393782 420001 443690 451748 529657 529689 530158 530170 530181 531363 531394 534044 543283 543662 544711 545251 546193 546563 549112 550612 562219 575680 576945 590969 594558 596394 613958 615914 617229 619427 625872 633244 635855 636585 640841 651253 704877 706407 707409 707447 707532 711052 714584 714599 714616 719793 720676 721160 721593 722046 722426 725336 725445 726313 730128 730552 731212 732955 733284 739634 742278 742841 743795 747241 747529 748631 753212 758860 761282 761522 761524 762774 763274 763502 763550 764850 765208 765424 765476 788659 789489 790955 791547 794855 794860 794962 794971 795335 795978 797221 799455 800357 800388 800407 801561 804604 804676 806712 806716 808705 810083 812128 812171 813315 816835 817652 817679 818158 824093 825344 826197 826927 827279 828653 ] |
||||||||||||||||||||||||||||||
|
12.23 ms (8.45%) |
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 817679 824638 826428 816835 826927 827279 818158 826197 824093 531394 530181 534044 529689 531363 544711 550612 543283 543662 545251 576945 706407 707409 707447 714584 707532 714599 714616 721160 719793 721593 722046 546193 546563 549112 575680 633244 590969 594558 615914 635855 636585 619427 597860 613958 617229 640841 788659 791547 794860 797221 804604 804676 794971 801561 725336 730552 742278 742841 753212 761282 761524 762774 764850 765424 765476 794855 794962 795335 799455 800357 800407 806716 808705 810083 739634 748631 758860 765208 726313 730128 732955 763502 733284 747241 747529 763274 763550 731212 743795 761522 625872 711052 722426 789489 800388 806712 812128 812171 813315 4387 390233 393782 451748 420001 562219 790955 443690 720676 310133 795978 817652 825344 828653 530158 530170 529657 704877 651253 596394 725445 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.85%) |
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 4387 310133 390233 393782 420001 443690 451748 529657 529689 530158 530170 530181 531363 531394 534044 543283 543662 544711 545251 546193 546563 549112 550612 562219 575680 576945 590969 594558 596394 613958 615914 617229 619427 625872 633244 635855 636585 640841 651253 704877 706407 707409 707447 707532 711052 714584 714599 714616 719793 720676 721160 721593 722046 722426 725336 725445 726313 730128 730552 731212 732955 733284 739634 742278 742841 743795 747241 747529 748631 753212 758860 761282 761522 761524 762774 763274 763502 763550 764850 765208 765424 765476 788659 789489 790955 791547 794855 794860 794962 794971 795335 795978 797221 799455 800357 800388 800407 801561 804604 804676 806712 806716 808705 810083 812128 812171 813315 816835 817652 817679 818158 824093 825344 826197 826927 827279 828653 ] |
||||||||||||||||||||||||||||||
|
2.21 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"такой крохотный член"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.33%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленький член"
]
|
||||||||||||||||||||||||||||||
|
1.26 ms (0.87%) |
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.