Query Metrics
7
Database Queries
7
Different statements
142.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.29 ms (84.38%) |
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 131462 181851 358525 396037 402960 444474 444519 468505 470212 472856 476184 513205 518974 522625 529535 531983 533237 537707 541906 543230 543500 545786 550039 561445 564341 566798 583919 597898 611712 612041 622922 634758 639795 641456 644069 645829 651008 665951 670698 671654 677975 687571 691600 698038 709671 709855 719939 721865 722721 724294 724323 728773 731482 732708 736031 738651 743225 744189 748175 750874 752618 754300 754844 758159 758700 759123 760725 761188 761589 769979 771590 776643 776733 779327 781966 784262 784553 785429 789990 790979 792808 796119 798746 798999 800582 801327 801374 802144 803007 803021 803266 806944 807458 807601 809253 811928 812741 812924 813527 813655 814766 815238 815335 815468 815575 816305 817180 818271 818446 818473 818726 818880 820002 821326 821377 822418 823690 824470 824573 828749 ] |
||||||||||||||||||||||||||||||
|
11.13 ms (7.81%) |
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 687571 803007 806944 807458 758159 796119 468505 476184 402960 800582 802144 131462 396037 815335 817180 818880 821326 824470 813655 814766 815575 818271 820002 822418 816305 818726 823690 824573 828749 472856 522625 529535 531983 518974 537707 533237 583919 543230 543500 550039 564341 541906 545786 566798 651008 670698 691600 719939 722721 645829 665951 677975 709671 634758 644069 611712 622922 639795 776643 790979 798746 803021 776733 779327 784262 792808 812924 724294 736031 752618 759123 784553 785429 807601 809253 811928 812741 813527 728773 748175 750874 758700 738651 754300 769979 743225 744189 732708 754844 760725 771590 612041 641456 709855 721865 781966 789990 801374 803266 181851 731482 818473 821377 815238 815468 671654 698038 561445 597898 798999 761188 358525 444519 724323 513205 444474 818446 470212 801327 761589 ] |
||||||||||||||||||||||||||||||
|
3.15 ms (2.21%) |
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 131462 181851 358525 396037 402960 444474 444519 468505 470212 472856 476184 513205 518974 522625 529535 531983 533237 537707 541906 543230 543500 545786 550039 561445 564341 566798 583919 597898 611712 612041 622922 634758 639795 641456 644069 645829 651008 665951 670698 671654 677975 687571 691600 698038 709671 709855 719939 721865 722721 724294 724323 728773 731482 732708 736031 738651 743225 744189 748175 750874 752618 754300 754844 758159 758700 759123 760725 761188 761589 769979 771590 776643 776733 779327 781966 784262 784553 785429 789990 790979 792808 796119 798746 798999 800582 801327 801374 802144 803007 803021 803266 806944 807458 807601 809253 811928 812741 812924 813527 813655 814766 815238 815335 815468 815575 816305 817180 818271 818446 818473 818726 818880 820002 821326 821377 822418 823690 824470 824573 828749 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass mother"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.29%) |
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.