Query Metrics
7
Database Queries
7
Different statements
163.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.16 ms (87.80%) |
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 421839 464896 477114 516985 519013 519593 521401 527154 533257 537488 540150 544618 557583 562743 566094 570856 579120 579437 583795 586636 589923 590227 590238 593805 599397 600858 608826 609422 615359 621217 623735 623759 645365 649289 650205 656526 661913 675276 688976 693782 694105 700803 703977 710310 711263 713714 720171 725639 727738 728503 730003 730825 731444 733047 734452 737614 742086 744165 749172 756718 757751 758581 763024 763225 765025 765028 765185 765454 765842 766615 767375 768553 771733 773403 773423 774285 777739 777759 777861 778748 779264 779369 781370 781428 783683 784641 786195 786269 786284 786577 787154 787490 787724 787726 790759 791248 796208 796214 797023 797455 797639 797752 798759 801074 802870 805361 805743 806054 806538 807515 809662 812440 817165 817688 817711 820107 824640 825773 826241 ] |
||||||||||||||||||||||||||||||
|
10.39 ms (6.37%) |
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 737614 742086 744165 763024 784641 786269 787490 787724 757751 765028 765842 728503 758581 765454 763225 773423 765025 766615 771733 720171 779264 786577 797455 797752 805743 608826 533257 825773 516985 566094 675276 779369 727738 733047 734452 731444 725639 797023 477114 557583 600858 519013 703977 623735 817711 820107 826241 824640 537488 562743 586636 786195 777759 790759 807515 730003 749172 765185 767375 773403 796214 802870 756718 768553 774285 777739 777861 778748 785027 787726 797639 806538 809662 464896 817165 817688 570856 621217 786284 796208 806054 812440 787154 791248 798759 805361 730825 781370 781428 783683 801074 615359 421839 527154 540150 544618 579120 583795 579437 645365 650205 656526 688976 693782 649289 694105 711263 661913 710310 713714 590227 599397 590238 623759 589923 593805 609422 700803 519593 521401 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.53%) |
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 421839 464896 477114 516985 519013 519593 521401 527154 533257 537488 540150 544618 557583 562743 566094 570856 579120 579437 583795 586636 589923 590227 590238 593805 599397 600858 608826 609422 615359 621217 623735 623759 645365 649289 650205 656526 661913 675276 688976 693782 694105 700803 703977 710310 711263 713714 720171 725639 727738 728503 730003 730825 731444 733047 734452 737614 742086 744165 749172 756718 757751 758581 763024 763225 765025 765028 765185 765454 765842 766615 767375 768553 771733 773403 773423 774285 777739 777759 777861 778748 779264 779369 781370 781428 783683 784641 786195 786269 786284 786577 787154 787490 787724 787726 790759 791248 796208 796214 797023 797455 797639 797752 798759 801074 802870 805361 805743 806054 806538 807515 809662 812440 817165 817688 817711 820107 824640 825773 826241 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom домашн любительск секс"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom домашн любительск секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom homemade sex"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (0.97%) |
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.