Query Metrics
7
Database Queries
7
Different statements
163.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.12 ms (86.66%) |
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 309286 327965 383299 389225 393222 393309 397791 402083 409811 411167 420799 423673 426051 453284 470820 473692 478735 485592 493363 503651 505331 512147 513744 524847 525326 525690 529638 533914 534066 542705 552197 568744 583639 584882 585054 602023 607350 611178 624654 631386 632085 708588 722383 730061 731909 734995 738535 739368 740126 740197 740210 740272 740943 743157 743289 743693 743969 745654 749921 750023 750447 750956 751319 752473 752556 753016 753035 753601 754202 754719 754758 754915 754921 755081 755431 756997 757121 758518 758975 764204 764795 768431 768858 768923 773126 774121 774824 779323 780123 780309 782904 782951 783426 786200 786802 786810 787000 787022 787162 790062 791019 793101 793119 806498 807616 809000 810498 810610 810923 811894 812420 813117 813928 819060 819106 821031 822488 824157 824191 827970 ] |
||||||||||||||||||||||||||||||
|
11.95 ms (7.29%) |
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 810498 812420 730061 731909 738535 743289 750023 754202 758518 782904 783426 786200 786810 787022 787162 790062 793101 807616 810610 811894 740210 750956 753016 753035 754719 754758 754915 764795 740272 745654 752473 753601 754921 755431 756997 758975 764204 773126 740943 743969 751319 755081 768431 768923 734995 740126 740197 743157 743693 749921 750447 752556 757121 768858 774121 602023 607350 611178 624654 631386 632085 708588 722383 774824 779323 780123 780309 782951 786802 787000 791019 793119 806498 810923 813117 411167 309286 393309 409811 568744 583639 542705 584882 585054 552197 809000 739368 426051 383299 423673 420799 503651 525326 534066 505331 513744 485592 512147 393222 327965 389225 397791 402083 822488 819060 813928 819106 821031 827970 824157 824191 470820 473692 453284 478735 493363 524847 525690 529638 533914 ] |
||||||||||||||||||||||||||||||
|
2.82 ms (1.72%) |
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 309286 327965 383299 389225 393222 393309 397791 402083 409811 411167 420799 423673 426051 453284 470820 473692 478735 485592 493363 503651 505331 512147 513744 524847 525326 525690 529638 533914 534066 542705 552197 568744 583639 584882 585054 602023 607350 611178 624654 631386 632085 708588 722383 730061 731909 734995 738535 739368 740126 740197 740210 740272 740943 743157 743289 743693 743969 745654 749921 750023 750447 750956 751319 752473 752556 753016 753035 753601 754202 754719 754758 754915 754921 755081 755431 756997 757121 758518 758975 764204 764795 768431 768858 768923 773126 774121 774824 779323 780123 780309 782904 782951 783426 786200 786802 786810 787000 787022 787162 790062 791019 793101 793119 806498 807616 809000 810498 810610 810923 811894 812420 813117 813928 819060 819106 821031 822488 824157 824191 827970 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny teens solo"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые teens соло"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые teens соло"
]
|
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.