Query Metrics
7
Database Queries
7
Different statements
190.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.04 ms (89.35%) |
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 458779 476980 484153 514346 530170 533713 547103 581275 585289 585401 585466 588003 590017 590383 594102 594639 595110 595379 599597 600708 606079 606358 606893 606950 607633 609510 616053 617174 621777 622275 626645 627059 627690 627692 629784 631526 635568 639203 639596 640492 641161 642216 653290 656660 657860 660716 664700 665332 668064 669622 670938 671256 672213 672894 676196 677913 689180 689571 690517 695008 695057 696380 696794 699135 703352 703625 703628 708084 713151 713436 715435 723165 730784 732155 733453 747991 751372 752196 754703 754966 759798 760210 761681 761847 762661 762793 766151 768468 768578 774033 779301 779513 779790 780400 781099 783586 785826 786701 787070 790923 791509 793332 794470 795379 797824 800745 800889 802892 807106 813190 813365 813635 817322 817464 819444 824063 824914 825392 825952 ] |
||||||||||||||||||||||||||||||
|
11.40 ms (5.99%) |
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 656660 660716 664700 670938 677913 695057 703625 703628 657860 665332 669622 671256 653290 668064 672213 672894 676196 689180 689571 690517 695008 696380 696794 699135 708084 713151 547103 585289 588003 590017 590383 594639 616053 621777 626645 629784 635568 642216 585401 595110 595379 606358 606950 607633 622275 627059 627692 599597 600708 639203 585466 594102 606079 606893 609510 639596 617174 627690 631526 640492 703352 713436 476980 514346 813635 817322 819444 817464 824063 824914 825392 825952 458779 484153 530170 533713 581275 715435 641161 781099 790923 797824 807106 779513 779790 793332 800745 800889 813365 766151 783586 791509 802892 813190 768578 733453 747991 732155 752196 754703 759798 760210 762661 762793 765594 768468 774033 730784 751372 754966 761681 761847 723165 779301 780400 785826 786701 787070 794470 795379 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.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 458779 476980 484153 514346 530170 533713 547103 581275 585289 585401 585466 588003 590017 590383 594102 594639 595110 595379 599597 600708 606079 606358 606893 606950 607633 609510 616053 617174 621777 622275 626645 627059 627690 627692 629784 631526 635568 639203 639596 640492 641161 642216 653290 656660 657860 660716 664700 665332 668064 669622 670938 671256 672213 672894 676196 677913 689180 689571 690517 695008 695057 696380 696794 699135 703352 703625 703628 708084 713151 713436 715435 723165 730784 732155 733453 747991 751372 752196 754703 754966 759798 760210 761681 761847 762661 762793 766151 768468 768578 774033 779301 779513 779790 780400 781099 783586 785826 786701 787070 790923 791509 793332 794470 795379 797824 800745 800889 802892 807106 813190 813365 813635 817322 817464 819444 824063 824914 825392 825952 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girlfriend amateur"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"girlfriend любительск"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"girlfriend любительск"
]
|
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.