Query Metrics
8
Database Queries
8
Different statements
201.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.89 ms (77.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 388544 428631 436860 454975 456182 467162 467476 467486 482586 488728 496510 497615 512085 514150 525969 528448 546086 549146 563479 564042 564481 567240 567642 569930 596437 598869 604137 608262 611495 615628 620251 625018 625639 645663 649715 659330 667178 671243 672851 675178 677132 691326 700941 708141 712892 714583 718134 718143 719324 721889 722348 724834 729705 735064 735831 736342 736680 740168 740176 740839 743496 747302 748639 752424 754047 754869 758270 758999 759313 761777 761818 763518 764179 764615 766098 768739 770549 775148 776235 778149 778588 778743 778825 779152 779367 779894 781640 783359 783563 785185 785441 786022 786796 786886 787890 788028 789089 789591 791413 791869 793920 793944 795440 797812 798860 798868 802938 806054 807457 808507 810205 810349 812440 818279 821772 825667 827103 827812 ] |
||||||||||||||||||||||||||||||
|
18.72 ms (9.28%) |
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 722348 808507 807457 735064 743496 770549 482586 818279 783563 789591 564042 718143 752424 754047 797812 754869 783359 791869 789089 456182 615628 719324 512085 793920 776235 691326 667178 675178 567240 428631 793944 718134 729705 766098 768119 388544 620251 467486 736342 564481 569930 596437 759313 671243 785441 821772 778825 786796 736680 735831 724834 747302 781640 798868 740839 563479 625018 712892 761818 694097 787890 798860 786886 810205 764615 802938 785185 567642 625639 786022 791413 708141 825667 758270 827103 778743 779894 779367 779152 467162 768739 778588 496510 748639 645663 497615 488728 827812 546086 758999 740168 763518 436860 806054 812440 721889 528448 598869 795440 775148 454975 714583 810349 700941 778149 764179 649715 677132 611495 740176 608262 788028 514150 761777 525969 659330 604137 672851 467476 549146 ] |
||||||||||||||||||||||||||||||
|
17.34 ms (8.60%) |
1 |
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance` FROM `search_log` WHERE MATCH (`query`) AGAINST (?) AND `query` <> ? AND `blocked` = 0 ORDER BY `relevance` DESC LIMIT ?
Parameters:
[ "student deepthroat homemade" "student deepthroat homemade" "student deepthroat homemade" 20 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.37%) |
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 388544 428631 436860 454975 456182 467162 467476 467486 482586 488728 496510 497615 512085 514150 525969 528448 546086 549146 563479 564042 564481 567240 567642 569930 596437 598869 604137 608262 611495 615628 620251 625018 625639 645663 649715 659330 667178 671243 672851 675178 677132 691326 700941 708141 712892 714583 718134 718143 719324 721889 722348 724834 729705 735064 735831 736342 736680 740168 740176 740839 743496 747302 748639 752424 754047 754869 758270 758999 759313 761777 761818 763518 764179 764615 766098 768739 770549 775148 776235 778149 778588 778743 778825 779152 779367 779894 781640 783359 783563 785185 785441 786022 786796 786886 787890 788028 789089 789591 791413 791869 793920 793944 795440 797812 798860 798868 802938 806054 807457 808507 810205 810349 812440 818279 821772 825667 827103 827812 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"student deepthroat homemade"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"student глубокийминет минет оральн секс домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.57 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"student глубокийминет минет оральн секс домашн любительск"
]
|
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.