Query Metrics
7
Database Queries
7
Different statements
370.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
206.31 ms (55.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big dildo wife"
]
|
||||||||||||||||||||||||||||||
|
143.29 ms (38.64%) |
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 119927 391992 401374 402630 408885 408928 411211 419824 424693 427008 427646 435136 437723 444896 445945 446447 448008 455915 459198 461100 467939 477021 483735 493443 505356 513220 513522 518611 520913 521238 524964 525468 529599 530166 534447 534574 537138 540746 544001 550857 551646 555004 559810 561015 561040 569302 575956 577520 580132 583694 584046 584999 585251 586834 587576 589166 589254 591156 591884 592046 592184 593296 594363 601095 604870 607487 608650 615921 616117 620323 621229 622723 630054 634317 635129 640306 640353 653028 664149 666682 669038 669067 671044 687369 695870 697610 700690 706720 711624 718835 726066 741186 746191 746515 751706 752649 752706 753120 756785 759198 766298 768450 768650 779263 782554 784035 788953 794706 797035 800530 802898 803770 806139 806495 807642 811913 812374 812493 813793 813817 ] |
||||||||||||||||||||||||||||||
|
14.00 ms (3.78%) |
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 621229 640353 741186 812493 759198 784035 446447 630054 402630 534447 408885 513220 577520 589166 620323 615921 752706 408928 752649 585251 746515 444896 455915 477021 592046 483735 524964 601095 753120 768650 419824 467939 569302 604870 593296 518611 559810 575956 697610 586834 634317 794706 797035 746191 756785 766298 779263 800530 806139 807642 505356 534574 391992 459198 525468 461100 427646 540746 537138 583694 551646 591884 594363 608650 589254 813817 529599 550857 616117 622723 640306 607487 811913 751706 768450 635129 718835 803770 806495 445945 584999 448008 493443 584046 587576 424693 520913 813793 653028 706720 711624 687369 666682 700690 555004 591156 782554 726066 812374 580132 401374 437723 802898 544001 530166 435136 411211 669038 671044 695870 664149 669067 561015 561040 592184 788953 427008 513522 521238 119927 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (0.64%) |
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 119927 391992 401374 402630 408885 408928 411211 419824 424693 427008 427646 435136 437723 444896 445945 446447 448008 455915 459198 461100 467939 477021 483735 493443 505356 513220 513522 518611 520913 521238 524964 525468 529599 530166 534447 534574 537138 540746 544001 550857 551646 555004 559810 561015 561040 569302 575956 577520 580132 583694 584046 584999 585251 586834 587576 589166 589254 591156 591884 592046 592184 593296 594363 601095 604870 607487 608650 615921 616117 620323 621229 622723 630054 634317 635129 640306 640353 653028 664149 666682 669038 669067 671044 687369 695870 697610 700690 706720 711624 718835 726066 741186 746191 746515 751706 752649 752706 753120 756785 759198 766298 768450 768650 779263 782554 784035 788953 794706 797035 800530 802898 803770 806139 806495 807642 811913 812374 812493 813793 813817 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие дилд жен"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие дилд жен"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.40%) |
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.