Query Metrics
7
Database Queries
7
Different statements
166.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.41 ms (87.31%) |
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 185589 199058 339415 392236 512001 523627 526801 530282 530964 532093 532400 533444 535355 536800 537039 537053 537055 537079 537081 537085 537087 537089 537092 539330 553174 559815 567027 568308 568311 574202 580253 587827 590109 595321 616712 626818 627684 628029 628032 634867 646277 649840 652248 652956 652990 653363 663537 666376 681363 681392 681657 681736 683268 692104 692180 698213 703307 706607 706758 707206 713588 715434 717583 722251 730838 732202 735699 738148 742245 743840 744125 745880 746625 748027 748095 748122 748410 748508 748841 748877 749655 751931 757561 764155 768920 773904 774052 777093 780660 783143 785308 792020 793743 794086 796533 802399 811967 812133 816845 818195 818301 818931 820028 823063 823096 823900 824072 824426 824602 824624 824830 825337 825745 826261 826847 827703 828349 828351 ] |
||||||||||||||||||||||||||||||
|
11.96 ms (7.18%) |
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 553174 567027 530282 751931 663537 745880 828079 512001 526801 681392 634867 825337 530964 535355 627684 537085 185589 536800 826261 828349 692180 824602 735699 580253 537092 828351 532093 559815 777093 744125 825745 681657 824629 537089 537079 652956 626818 768920 537053 698213 713588 749655 820028 539330 628029 590109 748410 703307 715434 574202 706607 811967 537039 824426 537055 616712 774052 199058 823900 824830 824624 824072 785308 793743 812133 730838 743840 773904 748508 742245 748841 628032 783143 649840 652248 748122 826847 818195 818301 568311 692104 722251 653363 587827 792020 794086 746625 738148 748095 757561 392236 339415 818931 827703 823063 537087 533444 706758 666376 681363 595321 802399 732202 748027 796533 748877 764155 717583 780660 683268 823096 816845 523627 537081 532400 568308 681736 646277 707206 652990 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.27%) |
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 185589 199058 339415 392236 512001 523627 526801 530282 530964 532093 532400 533444 535355 536800 537039 537053 537055 537079 537081 537085 537087 537089 537092 539330 553174 559815 567027 568308 568311 574202 580253 587827 590109 595321 616712 626818 627684 628029 628032 634867 646277 649840 652248 652956 652990 653363 663537 666376 681363 681392 681657 681736 683268 692104 692180 698213 703307 706607 706758 707206 713588 715434 717583 722251 730838 732202 735699 738148 742245 743840 744125 745880 746625 748027 748095 748122 748410 748508 748841 748877 749655 751931 757561 764155 768920 773904 774052 777093 780660 783143 785308 792020 793743 794086 796533 802399 811967 812133 816845 818195 818301 818931 820028 823063 823096 823900 824072 824426 824602 824624 824830 825337 825745 826261 826847 827703 828349 828351 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"video girl"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"video девушк"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"video девушк"
]
|
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.