Query Metrics
7
Database Queries
7
Different statements
169.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.56 ms (79.46%) |
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 114767 382630 396534 407812 417473 420155 422666 449885 486730 513919 515945 516950 519934 520531 524271 524783 527001 528847 535533 537008 541177 541239 542652 543243 545028 546425 549410 553489 554153 558010 563533 563731 565921 565973 566675 567097 568117 568280 568452 569031 569198 569994 571684 571762 571827 574191 574451 576009 576705 577393 577422 577642 578057 578124 578400 578418 580288 580695 580802 580821 581972 582787 583860 584244 584667 584698 585646 586448 587813 589256 590164 590948 591160 592450 592457 592481 593543 593750 594126 596107 596445 599213 599243 601269 601602 601838 603019 603273 603330 603905 604156 606759 606863 607711 608124 612026 615433 615554 615728 620151 621661 628348 629898 634633 634861 645878 645937 649949 650259 663938 670285 671707 672110 672771 689338 689376 690406 813946 814335 814958 ] |
||||||||||||||||||||||||||||||
|
24.16 ms (14.26%) |
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 543243 549410 568117 574191 580695 580821 690406 671707 649949 689376 565921 567097 574451 590164 592450 594126 601602 607711 604156 615433 587813 593543 599213 593750 599243 620151 634861 603330 629898 396534 524271 558010 541239 571762 527001 577393 569198 571827 581972 584667 645937 606759 114767 417473 563731 554153 634633 585646 382630 407812 814335 814958 513919 524783 535533 520531 528847 537008 486730 545028 565973 566675 571684 584244 563533 577642 578418 582787 584698 541177 542652 553489 576009 576705 578400 650259 672110 689338 670285 645878 663938 672771 546425 568452 569031 569994 577422 578057 578124 580288 583860 592457 592481 601838 603273 590948 596107 615728 591160 596445 601269 603019 612026 586448 589256 603905 606863 608124 615554 621661 628348 422666 420155 449885 515945 516950 519934 813946 568280 580802 ] |
||||||||||||||||||||||||||||||
|
3.44 ms (2.03%) |
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 114767 382630 396534 407812 417473 420155 422666 449885 486730 513919 515945 516950 519934 520531 524271 524783 527001 528847 535533 537008 541177 541239 542652 543243 545028 546425 549410 553489 554153 558010 563533 563731 565921 565973 566675 567097 568117 568280 568452 569031 569198 569994 571684 571762 571827 574191 574451 576009 576705 577393 577422 577642 578057 578124 578400 578418 580288 580695 580802 580821 581972 582787 583860 584244 584667 584698 585646 586448 587813 589256 590164 590948 591160 592450 592457 592481 593543 593750 594126 596107 596445 599213 599243 601269 601602 601838 603019 603273 603330 603905 604156 606759 606863 607711 608124 612026 615433 615554 615728 620151 621661 628348 629898 634633 634861 645878 645937 649949 650259 663938 670285 671707 672110 672771 689338 689376 690406 813946 814335 814958 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"скачет милф"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"скачет милфа"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"скачет милф"
]
|
||||||||||||||||||||||||||||||
|
1.62 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.