Query Metrics
7
Database Queries
7
Different statements
155.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.75 ms (85.52%) |
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 427117 456357 458779 476980 481052 484153 512142 514346 530170 533713 544783 545584 547103 581275 585289 585401 585466 588003 588121 588798 590017 590383 594102 594639 595110 595379 599597 600708 603198 606079 606358 606893 606950 607633 609510 616053 617174 621777 621823 622275 626645 627059 627690 627692 629784 631526 635568 639203 639596 640492 641161 642216 682399 693187 699317 703352 703604 708084 713151 713436 714281 715435 720311 723165 730784 732155 733453 747991 751372 752196 754703 754966 759798 760210 761681 761847 762661 762793 766151 768468 768578 774033 778790 779301 779513 779790 780400 781099 783586 785229 785826 786701 787070 790923 791509 793221 793332 794470 795379 796182 797824 799477 800745 800889 802892 807106 810012 813190 813365 813635 817322 817464 819444 819870 823704 824063 824914 825392 825952 ] |
||||||||||||||||||||||||||||||
|
13.36 ms (8.61%) |
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 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 799477 810012 456357 427117 512142 693187 823704 819870 481052 544783 545584 699317 714281 682399 703604 720311 588121 603198 621823 588798 793221 778790 785229 796182 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.72%) |
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 427117 456357 458779 476980 481052 484153 512142 514346 530170 533713 544783 545584 547103 581275 585289 585401 585466 588003 588121 588798 590017 590383 594102 594639 595110 595379 599597 600708 603198 606079 606358 606893 606950 607633 609510 616053 617174 621777 621823 622275 626645 627059 627690 627692 629784 631526 635568 639203 639596 640492 641161 642216 682399 693187 699317 703352 703604 708084 713151 713436 714281 715435 720311 723165 730784 732155 733453 747991 751372 752196 754703 754966 759798 760210 761681 761847 762661 762793 766151 768468 768578 774033 778790 779301 779513 779790 780400 781099 783586 785229 785826 786701 787070 790923 791509 793221 793332 794470 795379 796182 797824 799477 800745 800889 802892 807106 810012 813190 813365 813635 817322 817464 819444 819870 823704 824063 824914 825392 825952 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur girlfriend"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск girlfriend"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.98%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск girlfriend"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.90%) |
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.