Query Metrics
7
Database Queries
7
Different statements
180.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.23 ms (87.24%) |
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 74508 91458 198644 239808 285875 307342 386965 393534 394400 417021 417716 425244 429217 429260 429941 430132 433781 433863 443313 443332 444766 444853 445007 446618 446719 453204 454304 458115 465020 465641 472087 476458 476596 476666 480240 481287 491283 492723 496175 505252 506147 511648 516251 520025 520685 539458 540019 553459 561658 566526 568429 568524 578142 579001 580695 584825 594859 601241 605791 619490 627161 633434 639253 664801 681193 700969 709825 718155 722071 728675 729804 739538 742204 742458 743024 744130 744566 746619 747288 747805 753004 753778 754436 754565 755245 755359 756339 756645 757077 758350 759809 759817 760373 760961 763895 764354 764386 765202 765878 768784 769993 771860 771900 772554 772796 778164 780226 783637 785662 785759 787298 790820 797281 801080 802259 803195 812023 813446 814566 821775 ] |
||||||||||||||||||||||||||||||
|
13.28 ms (7.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 739538 742458 747805 753004 753778 755245 755359 760373 763895 769993 728675 729804 743024 744130 744566 746619 747288 759809 764354 768784 771900 742204 754565 756339 756645 757077 758350 759817 760961 764386 765878 771860 619490 633434 709825 718155 722071 778164 780226 783637 785662 785759 790820 797281 801080 802259 803195 812023 813446 285875 307342 394400 444853 639253 417021 454304 465641 198644 239808 393534 91458 445007 425244 443332 417716 444766 465020 472087 516251 496175 511648 540019 506147 561658 568524 553459 568429 580695 664801 700969 681193 566526 578142 579001 584825 605791 594859 601241 765202 772554 772796 754436 627161 787298 443313 446618 453204 481287 429260 433781 433863 476458 476596 480240 429217 430132 446719 476666 429941 491283 505252 492723 458115 520685 539458 520025 74508 386965 814566 821775 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.50%) |
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 74508 91458 198644 239808 285875 307342 386965 393534 394400 417021 417716 425244 429217 429260 429941 430132 433781 433863 443313 443332 444766 444853 445007 446618 446719 453204 454304 458115 465020 465641 472087 476458 476596 476666 480240 481287 491283 492723 496175 505252 506147 511648 516251 520025 520685 539458 540019 553459 561658 566526 568429 568524 578142 579001 580695 584825 594859 601241 605791 619490 627161 633434 639253 664801 681193 700969 709825 718155 722071 728675 729804 739538 742204 742458 743024 744130 744566 746619 747288 747805 753004 753778 754436 754565 755245 755359 756339 756645 757077 758350 759809 759817 760373 760961 763895 764354 764386 765202 765878 768784 769993 771860 771900 772554 772796 778164 780226 783637 785662 785759 787298 790820 797281 801080 802259 803195 812023 813446 814566 821775 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde long hair"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.70 ms (0.94%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая длинные hair"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"беловолосая длинные hair"
]
|
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.