Query Metrics
7
Database Queries
7
Different statements
160.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.49 ms (86.96%) |
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 4324 47128 351702 354774 381919 385788 386796 423922 457230 458524 478767 495201 505706 513184 521969 530563 537619 546150 551009 553206 567477 574964 594118 594547 598028 602366 606670 610862 612577 615256 616783 618729 619393 620685 621615 626678 627618 628184 630222 630345 630920 632784 639111 639895 649034 650881 660622 662860 665827 672867 678850 679564 687665 690946 691155 692248 693028 695283 696354 696665 696687 696698 698421 698476 707076 707214 707512 712166 715872 717137 722336 723902 728480 729354 730052 732216 732840 734461 736112 738121 741877 744610 745859 745884 748117 759608 760461 764245 764699 770423 772672 778075 778839 782613 783752 784130 784480 784844 787330 788464 791010 795833 800380 801538 802483 803162 803425 810904 811468 812178 812267 817264 818005 820666 822991 823088 823089 823720 828845 ] |
||||||||||||||||||||||||||||||
|
11.21 ms (6.99%) |
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 650881 660622 665827 707076 610862 627618 619393 621615 594547 788464 803425 812178 732840 770423 748117 730052 764245 615256 632784 698421 812267 381919 521969 351702 4324 818005 820666 823088 823089 530563 505706 513184 478767 574964 551009 692248 696698 707214 707512 672867 678850 687665 696665 712166 722336 662860 693028 695283 546150 553206 567477 602366 612577 606670 639111 620685 626678 639895 594118 618729 784844 795833 778839 782613 810904 723902 732216 745884 764699 772672 784480 787330 745859 759608 728480 767117 744610 696687 698476 791010 801538 802483 423922 495201 47128 628184 823720 800380 630222 630920 457230 458524 760461 822991 828845 537619 690946 679564 715872 649034 691155 696354 598028 616783 630345 778075 803162 811468 734461 784130 741877 729354 736112 738121 717137 783752 385788 354774 386796 817264 ] |
||||||||||||||||||||||||||||||
|
2.73 ms (1.70%) |
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 4324 47128 351702 354774 381919 385788 386796 423922 457230 458524 478767 495201 505706 513184 521969 530563 537619 546150 551009 553206 567477 574964 594118 594547 598028 602366 606670 610862 612577 615256 616783 618729 619393 620685 621615 626678 627618 628184 630222 630345 630920 632784 639111 639895 649034 650881 660622 662860 665827 672867 678850 679564 687665 690946 691155 692248 693028 695283 696354 696665 696687 696698 698421 698476 707076 707214 707512 712166 715872 717137 722336 723902 728480 729354 730052 732216 732840 734461 736112 738121 741877 744610 745859 745884 748117 759608 760461 764245 764699 770423 772672 778075 778839 782613 783752 784130 784480 784844 787330 788464 791010 795833 800380 801538 802483 803162 803425 810904 811468 812178 812267 817264 818005 820666 822991 823088 823089 823720 828845 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck video"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.76 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс video"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.91%) |
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.