Query Metrics
7
Database Queries
7
Different statements
178.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.11 ms (85.81%) |
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 29148 61437 163135 381997 385884 385930 401193 402083 411285 412852 416581 416703 417783 420432 428241 430103 439033 439135 443516 454725 475457 478029 483742 484934 500313 510354 515267 517888 521294 527920 528034 529034 531767 533292 534066 536267 536641 538326 539706 542711 548945 565480 576314 577381 577780 581407 584341 584606 586834 592333 594321 598778 600037 600150 600895 606123 607755 608001 617524 628205 630039 644041 644043 650232 657537 661034 662131 666858 670762 671098 683296 684843 684855 684888 693084 701291 702910 703668 705389 706520 711000 717322 739320 742455 743157 743160 743285 745113 749134 749380 750344 750362 751319 751415 751792 751808 756562 756830 757190 758821 773146 774872 780382 780393 780403 783190 783707 783948 785114 785125 786259 792064 803124 804900 807616 808126 808412 809018 812235 819958 ] |
||||||||||||||||||||||||||||||
|
15.01 ms (8.42%) |
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 757190 758821 739320 751319 751808 743157 756830 630039 644041 644043 706520 711000 780382 783707 783948 792064 804900 163135 401193 381997 510354 430103 411285 385930 61437 517888 661034 628205 534066 484934 439135 416703 443516 428241 416581 417783 439033 529034 483742 412852 581407 385884 29148 819958 475457 536267 539706 515267 533292 538326 584341 650232 657537 662131 684888 705389 684843 684855 693084 717322 586834 598778 600037 600150 607755 606123 594321 774872 780393 785114 785125 786259 808412 780403 751415 751792 783190 807616 812235 749380 745113 756562 773146 743285 749134 608001 617524 702910 703668 803124 808126 683296 750344 742455 536641 527920 521294 576314 584606 592333 500313 528034 577381 577780 420432 402083 531767 548945 666858 671098 670762 600895 809018 750362 743160 701291 478029 454725 565480 542711 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.59%) |
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 29148 61437 163135 381997 385884 385930 401193 402083 411285 412852 416581 416703 417783 420432 428241 430103 439033 439135 443516 454725 475457 478029 483742 484934 500313 510354 515267 517888 521294 527920 528034 529034 531767 533292 534066 536267 536641 538326 539706 542711 548945 565480 576314 577381 577780 581407 584341 584606 586834 592333 594321 598778 600037 600150 600895 606123 607755 608001 617524 628205 630039 644041 644043 650232 657537 661034 662131 666858 670762 671098 683296 684843 684855 684888 693084 701291 702910 703668 705389 706520 711000 717322 739320 742455 743157 743160 743285 745113 749134 749380 750344 750362 751319 751415 751792 751808 756562 756830 757190 758821 773146 774872 780382 780393 780403 783190 783707 783948 785114 785125 786259 792064 803124 804900 807616 808126 808412 809018 812235 819958 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo teen girls"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло teen девушк"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло teen девушк"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.86%) |
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.