Query Metrics
8
Database Queries
8
Different statements
216.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
186.87 ms (86.28%) |
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 13250 28382 54371 99632 176969 209385 240594 368131 382318 386783 389588 403999 419221 420166 433622 448054 464120 498358 528921 528925 530047 532845 558218 568651 600838 605165 615453 617596 623267 639795 641456 643087 649937 652992 655295 659426 667752 671349 675672 688976 692745 693665 701470 702106 706069 707856 710119 711575 716278 736465 738206 738927 740886 742648 746237 748175 752618 752943 756669 757919 766572 776402 781794 781818 784108 784180 784836 785050 785479 788546 788728 788857 789447 790808 790826 792678 793085 795049 797360 797410 799567 800860 800863 802446 803401 805992 806119 806551 808056 808414 808421 809257 811897 814199 814702 814706 814962 814981 817308 817881 817941 819972 820847 821486 824211 824269 824341 825168 826178 826381 826395 826465 826811 827679 827735 827880 828311 828416 828719 ] |
||||||||||||||||||||||||||||||
|
15.99 ms (7.38%) |
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 528921 498358 528925 659426 701470 605165 806119 738206 808056 386783 420166 13250 826178 752943 403999 28382 814706 814962 530047 558218 568651 655295 667752 675672 688976 692745 706069 649937 710119 716278 652992 671349 693665 702106 707856 615453 617596 623267 781818 788857 799567 800860 803401 808421 789447 792678 805992 808414 811897 736465 746237 785479 797360 806551 757919 766572 742648 756669 711575 776402 784108 784836 790826 793085 797410 800863 809257 419221 600838 448054 820847 824341 639795 643087 752618 784180 790808 748175 738927 641456 802446 814981 788546 209385 99632 240594 368131 389588 433622 817308 821486 826811 817941 827735 827679 464120 532845 788728 740886 781794 785050 795049 54371 382318 176969 824211 814199 826381 826395 814702 824269 826465 817881 819972 825168 828416 828311 827880 828298 828719 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.35%) |
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 13250 28382 54371 99632 176969 209385 240594 368131 382318 386783 389588 403999 419221 420166 433622 448054 464120 498358 528921 528925 530047 532845 558218 568651 600838 605165 615453 617596 623267 639795 641456 643087 649937 652992 655295 659426 667752 671349 675672 688976 692745 693665 701470 702106 706069 707856 710119 711575 716278 736465 738206 738927 740886 742648 746237 748175 752618 752943 756669 757919 766572 776402 781794 781818 784108 784180 784836 785050 785479 788546 788728 788857 789447 790808 790826 792678 793085 795049 797360 797410 799567 800860 800863 802446 803401 805992 806119 806551 808056 808414 808421 809257 811897 814199 814702 814706 814962 814981 817308 817881 817941 819972 820847 821486 824211 824269 824341 825168 826178 826381 826395 826465 826811 827679 827735 827880 828311 828416 828719 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass boobs"
]
|
||||||||||||||||||||||||||||||
|
2.38 ms (1.10%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01–~^\x03Fr\x1D’¯¢öG,FT"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп boobs"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп boobs"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.87%) |
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.