Query Metrics
7
Database Queries
7
Different statements
175.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.88 ms (87.63%) |
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 8295 118316 185011 185013 185249 185377 185563 185708 185753 350951 382771 383778 389165 389648 390215 391036 397290 397477 401281 401484 402596 403236 411609 419115 420086 447020 447493 471916 493219 499815 504444 507306 507549 538352 545472 551354 551435 557266 561667 592701 610962 618938 621538 622178 622986 623570 623955 624709 630823 636522 651882 651930 652206 653245 653258 653260 654148 655418 661148 661693 661698 662723 663957 672528 672540 672561 676499 676513 676518 677039 679706 681024 682654 689325 694468 699505 701487 703506 706668 709408 709769 712166 712462 720791 721091 721225 725375 730686 733900 748663 748752 758980 759547 760933 762556 767748 768115 770007 770438 773071 774090 781677 784702 786356 797688 797697 797698 799635 800296 801666 811662 812078 815326 815403 816023 816429 816492 818151 823530 828417 ] |
||||||||||||||||||||||||||||||
|
12.44 ms (7.08%) |
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 720791 653245 653258 661693 661698 694468 610962 797697 811662 773071 733900 748752 389165 815403 676513 676518 701487 677039 760933 762556 471916 118316 816023 816429 507549 681024 721091 651882 661148 655418 561667 622178 797698 185013 402596 551354 507306 801666 828417 185753 401281 672540 672528 672561 758980 447493 493219 411609 557266 799635 712462 185708 391036 382771 651930 663957 703506 630823 768115 770007 781677 654148 689325 551435 622986 786356 774090 185011 652206 662723 800296 419115 401484 420086 499815 538352 504444 636522 618938 784702 748663 185249 447020 389648 816492 818151 812078 185563 185377 815326 823530 545472 676499 706668 709769 759547 8295 682654 679706 623955 725375 624709 403236 383778 350951 653260 709408 712166 721225 623570 621538 797688 767748 730686 770438 397477 699505 592701 390215 397290 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.57%) |
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 8295 118316 185011 185013 185249 185377 185563 185708 185753 350951 382771 383778 389165 389648 390215 391036 397290 397477 401281 401484 402596 403236 411609 419115 420086 447020 447493 471916 493219 499815 504444 507306 507549 538352 545472 551354 551435 557266 561667 592701 610962 618938 621538 622178 622986 623570 623955 624709 630823 636522 651882 651930 652206 653245 653258 653260 654148 655418 661148 661693 661698 662723 663957 672528 672540 672561 676499 676513 676518 677039 679706 681024 682654 689325 694468 699505 701487 703506 706668 709408 709769 712166 712462 720791 721091 721225 725375 730686 733900 748663 748752 758980 759547 760933 762556 767748 768115 770007 770438 773071 774090 781677 784702 786356 797688 797697 797698 799635 800296 801666 811662 812078 815326 815403 816023 816429 816492 818151 823530 828417 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fuck in massage"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс массаж"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.79%) |
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.