Query Metrics
7
Database Queries
7
Different statements
168.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.31 ms (85.24%) |
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 162000 187048 187847 188066 188240 233641 233683 352189 358272 358437 359102 381818 382094 382244 382446 383241 388716 390918 391659 391858 395556 397930 401058 407707 411960 452856 463112 466318 468752 471850 474397 476266 490902 491830 511570 514578 529943 531240 536352 537147 542215 542783 546927 546962 561459 564197 583914 587180 593582 603135 603399 619629 621456 646868 657788 667209 678775 694443 701181 712332 712338 713193 714171 715473 718549 718566 720535 720583 720713 721459 725363 727050 727935 728228 728237 730076 735484 742433 742595 742603 744229 747073 748219 748220 754131 758427 766597 766690 770226 770241 770585 772114 773543 774172 774187 774394 776845 781646 781689 782235 789699 790983 800338 801077 802380 803091 803941 808013 808035 808667 810771 815395 816776 816784 816785 817349 817398 818733 823804 823806 ] |
||||||||||||||||||||||||||||||
|
14.79 ms (8.80%) |
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 748219 758427 766690 715473 781646 801077 803941 808035 808667 397930 382244 476266 466318 187048 188066 382446 382094 667209 782235 790983 803091 490902 395556 491830 358437 816776 816784 816785 714171 744229 742595 678775 720583 774187 358272 407707 546962 233683 359102 391659 529943 603399 514578 188240 542783 564197 187847 720713 537147 657788 162000 352189 390918 411960 823806 712332 718549 725363 747073 727050 728237 730076 735484 766597 728228 742433 773543 383241 233641 452856 381818 401058 463112 511570 474397 770226 388716 583914 774394 815395 471850 468752 531240 536352 542215 720535 587180 800338 802380 810771 742603 770241 701181 789699 391858 818733 817349 817398 823804 561459 694443 713193 646868 712338 718566 721459 546927 593582 619629 621456 603135 781689 808013 776845 748220 754131 770585 772114 774172 727935 ] |
||||||||||||||||||||||||||||||
|
2.83 ms (1.68%) |
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 162000 187048 187847 188066 188240 233641 233683 352189 358272 358437 359102 381818 382094 382244 382446 383241 388716 390918 391659 391858 395556 397930 401058 407707 411960 452856 463112 466318 468752 471850 474397 476266 490902 491830 511570 514578 529943 531240 536352 537147 542215 542783 546927 546962 561459 564197 583914 587180 593582 603135 603399 619629 621456 646868 657788 667209 678775 694443 701181 712332 712338 713193 714171 715473 718549 718566 720535 720583 720713 721459 725363 727050 727935 728228 728237 730076 735484 742433 742595 742603 744229 747073 748219 748220 754131 758427 766597 766690 770226 770241 770585 772114 773543 774172 774187 774394 776845 781646 781689 782235 789699 790983 800338 801077 802380 803091 803941 808013 808035 808667 810771 815395 816776 816784 816785 817349 817398 818733 823804 823806 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature stockings"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature чулк нижн бел"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.95%) |
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.