Query Metrics
7
Database Queries
7
Different statements
210.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
185.98 ms (88.20%) |
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 95982 96205 118234 130289 218768 306089 310758 326134 383188 387293 393091 404743 405174 407454 409652 426511 426712 432766 442986 443726 449073 451758 452787 458115 464131 467715 470647 471406 474289 476112 477041 477868 482534 486768 494433 508679 516320 517012 518237 529897 531970 533594 533794 534328 546953 555130 567396 573932 576981 583712 588507 592027 596108 596815 599677 599999 603616 606405 606514 609603 610540 613825 623296 640858 641685 645879 649543 660427 665973 670098 671759 682250 697369 699516 699751 708449 711891 714626 718838 720139 720207 720264 723497 724182 724309 725400 727783 738824 738830 742356 745245 746366 748357 760507 761167 761781 771358 782677 790389 797080 798727 801934 801950 802517 804700 806943 808112 810829 815214 815442 815752 816568 817877 819503 820678 820771 820778 823809 824130 827201 ] |
||||||||||||||||||||||||||||||
|
13.54 ms (6.42%) |
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 738824 820678 816568 820771 567396 573932 660427 649543 596108 640858 641685 801950 810829 745245 748357 817877 531970 720264 310758 711891 720207 588507 790389 801934 738830 606514 797080 118234 95982 449073 546953 383188 218768 405174 824130 827201 820778 508679 699751 697369 723497 682250 599999 610540 606405 804700 761167 725400 742356 760507 516320 470647 426712 477041 432766 452787 458115 727783 494433 819503 798727 130289 326134 409652 407454 476112 467715 592027 806943 534328 517012 393091 306089 782677 771358 724182 387293 451758 442986 808112 746366 482534 404743 645879 96205 477868 443726 464131 426511 474289 518237 815442 823809 671759 699516 623296 802517 471406 533794 533594 529897 486768 583712 576981 665973 718838 761781 724309 613825 714626 720139 555130 815214 815752 670098 708449 603616 609603 596815 599677 ] |
||||||||||||||||||||||||||||||
|
3.94 ms (1.87%) |
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 95982 96205 118234 130289 218768 306089 310758 326134 383188 387293 393091 404743 405174 407454 409652 426511 426712 432766 442986 443726 449073 451758 452787 458115 464131 467715 470647 471406 474289 476112 477041 477868 482534 486768 494433 508679 516320 517012 518237 529897 531970 533594 533794 534328 546953 555130 567396 573932 576981 583712 588507 592027 596108 596815 599677 599999 603616 606405 606514 609603 610540 613825 623296 640858 641685 645879 649543 660427 665973 670098 671759 682250 697369 699516 699751 708449 711891 714626 718838 720139 720207 720264 723497 724182 724309 725400 727783 738824 738830 742356 745245 746366 748357 760507 761167 761781 771358 782677 790389 797080 798727 801934 801950 802517 804700 806943 808112 810829 815214 815442 815752 816568 817877 819503 820678 820771 820778 823809 824130 827201 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother double fuck"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин double секс"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мам женщин double секс"
]
|
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.