Query Metrics
7
Database Queries
7
Different statements
147.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.09 ms (86.70%) |
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 3869 50258 72782 188031 281095 384046 384094 389788 392524 397405 398579 401872 406070 411279 413008 417870 420389 421783 428041 432573 441336 441583 452217 454460 454682 458564 465223 466703 492755 494694 510303 510878 516044 518177 530298 530498 531449 534180 534480 534893 535900 538480 539453 574967 624351 631020 641189 641247 699298 709102 713021 720662 721260 724905 727021 731051 731398 732524 734059 734574 738419 742497 742740 744371 744376 744751 745474 746105 746629 747160 748355 750284 750390 752025 752246 752332 753980 754313 755602 758924 760554 762129 762344 763477 764293 765419 766573 766962 767240 768230 770075 772031 773938 778433 792503 792534 794070 794098 795619 795654 795730 797059 800449 800817 804023 809863 810307 810323 811251 811622 811712 811834 812452 812835 814356 824689 828808 ] |
||||||||||||||||||||||||||||||
|
10.29 ms (6.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 731051 732524 738419 744751 750390 752246 755602 758924 767240 770075 792503 792534 800449 804023 811251 811834 812835 744371 748355 762344 731398 742740 745474 747160 750284 752025 754313 762823 764293 746105 746629 762129 763477 765419 766573 766962 769111 772031 773938 724905 727021 734059 734574 742497 744376 752332 753980 760554 768230 631020 641189 641247 699298 709102 713021 720662 721260 774503 778433 794070 794098 795619 795654 795730 797059 800817 809863 810307 810323 811622 811712 812452 3869 401872 397405 50258 281095 494694 828808 574967 624351 72782 384046 384094 188031 392524 389788 398579 406070 417870 421783 432573 441336 411279 420389 441583 413008 428041 814356 824689 458564 465223 466703 452217 454460 454682 492755 534180 535900 516044 518177 534480 538480 510878 530498 534893 510303 530298 531449 539453 ] |
||||||||||||||||||||||||||||||
|
2.71 ms (1.84%) |
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 3869 50258 72782 188031 281095 384046 384094 389788 392524 397405 398579 401872 406070 411279 413008 417870 420389 421783 428041 432573 441336 441583 452217 454460 454682 458564 465223 466703 492755 494694 510303 510878 516044 518177 530298 530498 531449 534180 534480 534893 535900 538480 539453 574967 624351 631020 641189 641247 699298 709102 713021 720662 721260 724905 727021 731051 731398 732524 734059 734574 738419 742497 742740 744371 744376 744751 745474 746105 746629 747160 748355 750284 750390 752025 752246 752332 753980 754313 755602 758924 760554 762129 762344 763477 764293 765419 766573 766962 767240 768230 770075 772031 773938 778433 792503 792534 794070 794098 795619 795654 795730 797059 800449 800817 804023 809863 810307 810323 811251 811622 811712 811834 812452 812835 814356 824689 828808 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"скачать порно жопы"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скача порн жоп"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (1.05%) |
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.