Query Metrics
7
Database Queries
7
Different statements
240.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
217.46 ms (90.33%) |
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 464963 476778 489721 491217 496470 497146 498095 500024 502719 511475 512029 512902 516619 517477 521696 525961 526160 526329 526394 527098 527170 527291 528326 528529 529052 530131 531702 532309 532595 536058 537531 539106 539469 540583 542407 542597 543378 543910 546023 546332 551831 551939 554615 555664 556398 556471 556996 558318 558670 558819 561177 562499 564366 567271 568047 568137 568144 569766 572854 574109 575009 576510 576543 578037 578041 579631 580824 580897 581238 581254 581575 581716 584009 584188 585438 586905 588033 592276 593068 593139 593191 593990 594293 595572 595579 596729 597284 597738 598129 598256 599004 599802 600248 601175 601667 602636 602952 602997 603993 615281 616766 620056 624965 625930 626753 626949 628604 630119 630461 630713 633540 634095 635694 644345 646336 651920 652683 659615 671817 ] |
||||||||||||||||||||||||||||||
|
14.35 ms (5.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 595579 633540 491217 496470 512902 517477 528326 516619 529052 531702 532595 537531 511475 476778 489721 542407 542597 546023 546332 555664 558819 568144 572854 578037 558318 564366 575009 580897 581716 543378 551939 556471 556996 568137 581238 651920 652683 664464 671817 551831 602997 585438 593191 599802 602636 620056 624965 635694 593990 603993 626753 630119 630461 588033 592276 601175 601667 626949 628604 630713 497146 512029 595572 539106 539469 500024 502719 525961 526160 526394 527098 528529 530131 532309 540583 526329 527170 527291 536058 498095 521696 464963 568047 569766 578041 579631 543910 576543 581254 581575 554615 556398 584009 584188 659615 646336 558670 561177 567271 574109 576510 580824 593139 596729 597738 644345 593068 634095 594293 597284 598256 599004 600248 616766 586905 598129 602952 625930 615281 562499 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.05%) |
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 464963 476778 489721 491217 496470 497146 498095 500024 502719 511475 512029 512902 516619 517477 521696 525961 526160 526329 526394 527098 527170 527291 528326 528529 529052 530131 531702 532309 532595 536058 537531 539106 539469 540583 542407 542597 543378 543910 546023 546332 551831 551939 554615 555664 556398 556471 556996 558318 558670 558819 561177 562499 564366 567271 568047 568137 568144 569766 572854 574109 575009 576510 576543 578037 578041 579631 580824 580897 581238 581254 581575 581716 584009 584188 585438 586905 588033 592276 593068 593139 593191 593990 594293 595572 595579 596729 597284 597738 598129 598256 599004 599802 600248 601175 601667 602636 602952 602997 603993 615281 616766 620056 624965 625930 626753 626949 628604 630119 630461 630713 633540 634095 635694 644345 646336 651920 652683 659615 671817 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"в короткий"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в коротком"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.61%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.32 ms (0.55%) |
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.