Query Metrics
7
Database Queries
7
Different statements
161.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
138.11 ms (85.32%) |
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 4311 29148 50344 233234 233335 381962 385500 386985 387352 388346 391535 401022 404532 408837 424151 429696 438613 438957 454749 454900 455709 460979 461163 466449 469147 470042 470155 470687 476024 486106 491187 513602 519532 533647 533774 534110 537053 537079 537089 541450 543644 543726 543966 546368 552554 563249 563598 564955 582716 590552 596164 596181 597517 598045 598543 608188 621163 626019 627314 631246 631341 637454 659212 660283 666410 673006 680676 691810 697106 704969 706715 708090 713768 717716 731581 736070 739397 743228 745660 745720 748509 751025 753604 753658 754814 755891 760427 761974 766398 766432 767743 768430 768458 769336 774096 774653 777093 777770 778537 778557 782740 783313 787074 788027 790372 790421 790434 791038 791496 792107 803238 803842 804908 810156 810497 824610 825029 825720 825796 827335 ] |
||||||||||||||||||||||||||||||
|
12.88 ms (7.96%) |
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 552554 778557 769336 790434 736070 627314 454749 387352 233234 519532 486106 533774 659212 680676 660283 598045 751025 731581 470042 825029 596164 790421 777093 766432 717716 666410 388346 563598 631246 631341 790372 810497 804908 755891 791496 803238 533647 534110 673006 691810 621163 777770 543726 774653 385500 408837 460979 708090 563249 401022 461163 4311 386985 590552 424151 429696 438957 469147 825796 782740 810156 513602 637454 803842 748509 766398 783313 466449 233335 546368 824610 543966 564955 491187 582716 697106 608188 598543 745720 713768 391535 470155 476024 404532 381962 767743 827335 537089 537079 704969 706715 597517 788027 778537 792107 739397 743228 774096 753658 753604 760427 745660 768430 791038 543644 626019 761974 455709 454900 29148 470687 438613 50344 825720 537053 541450 596181 787074 754814 768458 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (1.89%) |
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 4311 29148 50344 233234 233335 381962 385500 386985 387352 388346 391535 401022 404532 408837 424151 429696 438613 438957 454749 454900 455709 460979 461163 466449 469147 470042 470155 470687 476024 486106 491187 513602 519532 533647 533774 534110 537053 537079 537089 541450 543644 543726 543966 546368 552554 563249 563598 564955 582716 590552 596164 596181 597517 598045 598543 608188 621163 626019 627314 631246 631341 637454 659212 660283 666410 673006 680676 691810 697106 704969 706715 708090 713768 717716 731581 736070 739397 743228 745660 745720 748509 751025 753604 753658 754814 755891 760427 761974 766398 766432 767743 768430 768458 769336 774096 774653 777093 777770 778537 778557 782740 783313 787074 788027 790372 790421 790434 791038 791496 792107 803238 803842 804908 810156 810497 824610 825029 825720 825796 827335 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian girl solo"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск девушк соло"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.