Query Metrics
7
Database Queries
7
Different statements
193.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
169.01 ms (87.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 193462 207970 397689 398643 460245 483792 512841 529691 539949 541043 550968 552180 552713 558590 559334 561052 563268 574020 577034 577610 583453 586377 586657 591975 598943 607365 611260 616846 617368 617889 622303 626398 627332 631298 632793 642144 644600 647530 653066 654911 657234 665076 667998 668814 669858 676555 677366 684583 689871 700947 704629 705769 705784 716125 719987 720541 721149 724780 728916 729038 729262 736334 739288 741503 742903 743860 744159 744171 746197 746199 746293 747482 747510 748499 748593 749641 751319 751943 756975 757126 761728 764836 767519 773334 773351 774872 775590 775624 775658 780028 780323 781515 782109 782749 782936 783029 783186 783370 785366 785651 785653 786366 790463 792253 792668 794639 794765 795070 798769 799423 800041 801818 810904 812106 812695 813331 816152 817028 827394 827578 ] |
||||||||||||||||||||||||||||||
|
12.69 ms (6.55%) |
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 563268 577610 583453 653066 654911 667998 700947 705784 716125 647530 705769 719987 720541 586377 617889 626398 644600 591975 632793 627332 774872 775658 782749 785653 792253 801818 783186 794639 736334 741503 744171 746199 746293 748499 751943 757126 782109 782936 783370 792668 794765 729038 739288 744159 747510 773334 724780 728916 729262 742903 747482 748593 773351 751319 761728 767519 743860 756975 775590 775624 780028 780323 795070 798769 812695 398643 207970 193462 397689 827578 827394 816152 817028 483792 460245 529691 539949 512841 552180 558590 559334 541043 550968 552713 561052 574020 657234 665076 721149 669858 684583 704629 668814 676555 677366 689871 577034 607365 611260 616846 617368 622303 586657 598943 642144 631298 785366 786366 799423 813331 783029 785651 790463 800041 810904 812106 746197 749641 764836 781515 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (1.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс orgasm"
]
|
||||||||||||||||||||||||||||||
|
3.14 ms (1.62%) |
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 193462 207970 397689 398643 460245 483792 512841 529691 539949 541043 550968 552180 552713 558590 559334 561052 563268 574020 577034 577610 583453 586377 586657 591975 598943 607365 611260 616846 617368 617889 622303 626398 627332 631298 632793 642144 644600 647530 653066 654911 657234 665076 667998 668814 669858 676555 677366 684583 689871 700947 704629 705769 705784 716125 719987 720541 721149 724780 728916 729038 729262 736334 739288 741503 742903 743860 744159 744171 746197 746199 746293 747482 747510 748499 748593 749641 751319 751943 756975 757126 761728 764836 767519 773334 773351 774872 775590 775624 775658 780028 780323 781515 782109 782749 782936 783029 783186 783370 785366 785651 785653 786366 790463 792253 792668 794639 794765 795070 798769 799423 800041 801818 810904 812106 812695 813331 816152 817028 827394 827578 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс orgasm"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck to orgasm"
]
|
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.