Query Metrics
7
Database Queries
7
Different statements
170.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.71 ms (85.32%) |
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 16897 87974 88664 151179 154171 154257 188560 248347 352142 352189 382304 382512 390670 398025 399028 401768 403973 413673 414062 415292 415300 415311 415319 428171 439518 448115 452846 464951 473450 493717 505336 513968 530698 531588 531638 531866 531877 532634 537138 546129 547475 547502 547854 548941 550925 551556 559360 561019 564291 564500 580069 581064 590806 597111 601367 604228 624682 626317 628106 639736 639803 642048 644036 655247 658777 658819 660369 660415 662165 662886 664733 664747 669357 670356 671008 671038 672315 672925 672944 672952 703586 703619 706133 712231 718701 722273 722354 723461 734483 735248 736802 737117 739132 739558 749264 750565 750917 751309 752709 756233 765569 770400 770401 776927 782511 783702 783709 784227 785981 787505 790399 793281 795542 802925 806938 808328 815536 817240 824668 825442 ] |
||||||||||||||||||||||||||||||
|
14.67 ms (8.59%) |
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 439518 530698 352142 658777 16897 735248 415319 672944 670356 87974 547502 414062 551556 664747 706133 722354 626317 639803 590806 783702 790399 793281 795542 808328 787505 750917 752709 765569 737117 750565 770400 642048 644036 782511 784227 390670 531588 531638 703586 448115 548941 749264 399028 531866 559360 564291 564500 581064 547854 550925 723461 658819 597111 751309 739558 739132 639736 783709 802925 188560 531877 532634 547475 561019 669357 660369 672315 672952 660415 671038 718701 624682 403973 428171 452846 712231 655247 664733 785981 734483 736802 415311 398025 672925 703619 662165 662886 546129 604228 756233 382512 382304 401768 413673 671008 580069 806938 628106 248347 352189 415300 473450 513968 464951 415292 151179 154257 825442 824668 493717 722273 776927 770401 88664 154171 505336 537138 601367 815536 817240 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.92%) |
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 16897 87974 88664 151179 154171 154257 188560 248347 352142 352189 382304 382512 390670 398025 399028 401768 403973 413673 414062 415292 415300 415311 415319 428171 439518 448115 452846 464951 473450 493717 505336 513968 530698 531588 531638 531866 531877 532634 537138 546129 547475 547502 547854 548941 550925 551556 559360 561019 564291 564500 580069 581064 590806 597111 601367 604228 624682 626317 628106 639736 639803 642048 644036 655247 658777 658819 660369 660415 662165 662886 664733 664747 669357 670356 671008 671038 672315 672925 672944 672952 703586 703619 706133 712231 718701 722273 722354 723461 734483 735248 736802 737117 739132 739558 749264 750565 750917 751309 752709 756233 765569 770400 770401 776927 782511 783702 783709 784227 785981 787505 790399 793281 795542 802925 806938 808328 815536 817240 824668 825442 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"в жопу дилдо"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал дилд"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.95%) |
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.