Query Metrics
7
Database Queries
7
Different statements
155.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.19 ms (83.88%) |
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 44120 95562 96393 96445 96468 96479 96530 96968 96997 192888 198857 323088 324183 341691 341753 383641 387445 387550 388919 390024 390766 396989 398317 398545 404787 404952 410093 410930 410937 411014 418478 419064 420216 447808 448560 448633 457651 461086 478548 484791 497590 508213 534808 536614 543177 547946 554816 566690 583470 601622 603682 609121 620164 623263 630497 639076 644321 650667 650835 651317 652850 653600 654184 665662 670487 672987 672999 673526 674107 677958 681661 690012 699596 703087 706939 709684 711896 714279 716745 727850 729826 729839 732053 733889 736778 740392 743644 749990 759848 770546 770819 770877 770909 772804 775054 775479 775836 775846 775883 775896 780688 783109 792583 801949 801966 801972 805484 806113 806376 808116 809468 809471 809533 815051 815276 816882 817377 818852 825998 827523 ] |
||||||||||||||||||||||||||||||
|
14.77 ms (9.52%) |
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 390766 198857 714279 809533 396989 809471 817377 818852 673526 461086 96530 665662 601622 770877 96393 398317 825998 547946 554816 670487 653600 543177 447808 677958 706939 583470 729826 323088 674107 341753 815276 827523 508213 536614 534808 699596 716745 672999 566690 609121 623263 775846 806113 775479 732053 772804 783109 801966 805484 808116 733889 759848 770546 792583 650835 780688 743644 729839 816882 801949 192888 775836 801972 672987 770909 711896 650667 709684 740392 410093 644321 603682 620164 410930 639076 95562 815051 681661 410937 457651 448560 809468 404787 398545 478548 497590 388919 404952 96968 96468 96479 630497 387445 770819 387550 418478 419064 484791 383641 96997 448633 390024 44120 690012 775054 727850 775896 420216 411014 651317 749990 703087 324183 654184 736778 341691 96445 652850 775883 806376 ] |
||||||||||||||||||||||||||||||
|
2.59 ms (1.67%) |
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 44120 95562 96393 96445 96468 96479 96530 96968 96997 192888 198857 323088 324183 341691 341753 383641 387445 387550 388919 390024 390766 396989 398317 398545 404787 404952 410093 410930 410937 411014 418478 419064 420216 447808 448560 448633 457651 461086 478548 484791 497590 508213 534808 536614 543177 547946 554816 566690 583470 601622 603682 609121 620164 623263 630497 639076 644321 650667 650835 651317 652850 653600 654184 665662 670487 672987 672999 673526 674107 677958 681661 690012 699596 703087 706939 709684 711896 714279 716745 727850 729826 729839 732053 733889 736778 740392 743644 749990 759848 770546 770819 770877 770909 772804 775054 775479 775836 775846 775883 775896 780688 783109 792583 801949 801966 801972 805484 806113 806376 808116 809468 809471 809533 815051 815276 816882 817377 818852 825998 827523 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blowjob double ммж"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс double мжм секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.03%) |
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.