Query Metrics
7
Database Queries
7
Different statements
390.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.62 ms (54.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"Ðüð║ð░Ðçð░ÐéÐî ð┐ð¥ÐÇð¢ð░ ð▓ ð▓ð░ð¢ð¢ð¥ðÔǪ"
]
|
||||||||||||||||||||||||||||||
|
152.93 ms (39.18%) |
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 24363 30208 62010 86766 191698 309480 383388 383820 384046 386824 387362 396323 397190 400507 416102 420333 423445 424141 425549 425577 429552 433904 436452 436965 442915 446251 447642 448699 451560 454290 459963 461719 464064 470260 470400 476526 477429 479486 481927 487998 489381 497809 500639 501342 503648 504347 509430 509471 509936 517534 518301 521663 528294 528762 542980 550495 553166 555808 558402 563830 567740 569558 569637 571917 575847 576761 577897 579991 581760 584020 585849 588125 588480 589659 596997 599829 599998 601076 609505 624128 650137 661046 665257 668658 669452 676687 678906 683404 688901 688922 691026 694923 695014 703650 704410 704613 706758 714655 719327 721942 721945 754478 755251 758134 771145 775064 776597 785885 786799 788031 794872 797175 813818 814450 816841 825059 825513 827227 828472 828520 ] |
||||||||||||||||||||||||||||||
|
16.49 ms (4.23%) |
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 577897 429552 436452 447642 62010 433904 446251 451560 424141 425577 461719 509430 518301 521663 501342 487998 503648 504347 489381 191698 814450 816841 825513 827227 825059 828520 828472 563830 650137 706758 661046 668658 785885 786799 788031 758134 754478 755251 771145 704410 387362 386824 383388 384046 383820 309480 86766 24363 30208 396323 397190 400507 416102 425549 436965 420333 423445 442915 813818 470260 470400 477429 459963 464064 479486 448699 454290 481927 509471 497809 500639 517534 528762 509936 528294 476526 542980 569637 571917 550495 553166 558402 575847 555808 669452 688922 703650 714655 665257 676687 678906 683404 688901 691026 694923 695014 704613 719327 721942 721945 567740 569558 576761 579991 581760 584020 588125 588480 589659 599829 609505 585849 596997 599998 601076 624128 775064 776597 794872 797175 ] |
||||||||||||||||||||||||||||||
|
3.71 ms (0.95%) |
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 24363 30208 62010 86766 191698 309480 383388 383820 384046 386824 387362 396323 397190 400507 416102 420333 423445 424141 425549 425577 429552 433904 436452 436965 442915 446251 447642 448699 451560 454290 459963 461719 464064 470260 470400 476526 477429 479486 481927 487998 489381 497809 500639 501342 503648 504347 509430 509471 509936 517534 518301 521663 528294 528762 542980 550495 553166 555808 558402 563830 567740 569558 569637 571917 575847 576761 577897 579991 581760 584020 585849 588125 588480 589659 596997 599829 599998 601076 609505 624128 650137 661046 665257 668658 669452 676687 678906 683404 688901 688922 691026 694923 695014 703650 704410 704613 706758 714655 719327 721942 721945 754478 755251 758134 771145 775064 776597 785885 786799 788031 794872 797175 813818 814450 816841 825059 825513 827227 828472 828520 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скача порн ван"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"скача порн ван"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.43%) |
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.