Query Metrics
7
Database Queries
7
Different statements
227.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
202.05 ms (88.98%) |
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 414116 417608 427203 445978 447342 454472 457946 460128 469428 469433 473223 493834 514161 545669 553810 567440 590365 602597 606713 613614 618726 637890 649796 669314 676375 694875 707808 716131 720896 724102 724592 725226 725294 733067 734467 736025 737946 738763 742808 742888 743938 745707 745883 746352 746988 752289 752335 752353 752389 758449 759029 759551 760233 760838 763916 769387 770101 771295 773774 775008 775044 776139 778299 779910 784368 784767 785307 786138 787563 788538 791613 792865 794948 795007 795710 796242 797024 797313 798263 800819 801104 801586 801671 802388 804015 808426 809549 810115 810135 810583 811455 811899 812201 812334 813724 813727 813736 813856 813885 817076 817372 818576 818816 818881 818957 819379 819408 820128 820137 823651 824039 824307 824795 824954 825152 825989 827354 827600 828829 ] |
||||||||||||||||||||||||||||||
|
14.05 ms (6.19%) |
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 613614 618726 606713 637890 778299 810115 811899 792865 797313 811455 752335 771295 733067 752389 725294 758449 760233 734467 742808 742877 742888 752289 773774 737946 745883 763916 720896 784368 795007 797024 810135 414116 427203 454472 445978 447342 473223 493834 676375 590365 784767 724102 417608 469428 469433 457946 817372 818957 819408 820137 824039 824954 817076 818816 825152 825989 827354 827600 813724 813856 818576 823651 824307 813727 813736 813885 818881 819379 820128 824795 828829 460128 514161 545669 567440 649796 669314 716131 694875 707808 553810 602597 775008 776139 791613 794948 795710 796242 801104 801586 802388 809549 810583 812201 775044 779910 787563 788538 798263 800819 801671 804015 812334 736025 743938 745707 746352 752353 759029 759551 769387 785307 786138 808426 724592 725226 738763 746988 760838 770101 ] |
||||||||||||||||||||||||||||||
|
3.45 ms (1.52%) |
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 414116 417608 427203 445978 447342 454472 457946 460128 469428 469433 473223 493834 514161 545669 553810 567440 590365 602597 606713 613614 618726 637890 649796 669314 676375 694875 707808 716131 720896 724102 724592 725226 725294 733067 734467 736025 737946 738763 742808 742888 743938 745707 745883 746352 746988 752289 752335 752353 752389 758449 759029 759551 760233 760838 763916 769387 770101 771295 773774 775008 775044 776139 778299 779910 784368 784767 785307 786138 787563 788538 791613 792865 794948 795007 795710 796242 797024 797313 798263 800819 801104 801586 801671 802388 804015 808426 809549 810115 810135 810583 811455 811899 812201 812334 813724 813727 813736 813856 813885 817076 817372 818576 818816 818881 818957 819379 819408 820128 820137 823651 824039 824307 824795 824954 825152 825989 827354 827600 828829 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"webcam latina"
]
|
||||||||||||||||||||||||||||||
|
2.08 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"вебкамер латинская"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.74%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.65%) |
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.