Query Metrics
7
Database Queries
7
Different statements
160.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.46 ms (84.16%) |
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 181742 191914 192297 386467 389209 390754 392486 406945 410383 414242 418031 418976 429144 439191 449217 469956 475231 481335 484749 511407 513758 524964 532388 532395 536488 538539 538730 544219 545628 545930 547189 547299 554844 562742 564760 566670 576561 578907 588612 588756 591848 593049 599566 600486 601099 601122 602260 609976 611254 615949 616184 627156 636586 637632 640350 641636 644531 661329 692135 700239 701483 715103 715294 715983 717513 720540 731608 733455 738071 738248 738500 739368 742688 744213 744769 744799 748348 749087 750500 753692 754317 754605 754773 754977 754994 756339 759093 760585 760750 772621 774146 774730 774745 774754 777149 780998 781918 783291 783324 785146 785964 790242 790333 796862 796892 797339 801667 804248 804457 804646 807185 810808 811131 813723 814194 816106 819114 819273 824529 826602 ] |
||||||||||||||||||||||||||||||
|
15.18 ms (9.43%) |
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 615949 418031 524964 547189 554844 715294 756339 749087 562742 602260 389209 801667 754977 406945 418976 578907 588756 609976 484749 545628 439191 819114 449217 783291 804646 414242 181742 192297 816106 601122 636586 790333 811131 738248 511407 739368 475231 469956 513758 536488 753692 390754 826602 538730 532388 544219 564760 701483 599566 601099 616184 627156 593049 774745 774754 781918 754994 754605 742688 744799 644531 785146 819273 692135 774730 780998 774146 611254 804248 777149 785964 760750 410383 813723 576561 715103 759093 783324 738500 760585 191914 824529 814194 547299 720540 641636 588612 637632 804457 807185 744769 772621 733455 738071 744213 392486 810808 748348 538539 545930 566670 600486 754773 717513 386467 532395 715983 481335 640350 796862 796892 797339 429144 700239 661329 591848 790242 750500 754317 731608 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.84%) |
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 181742 191914 192297 386467 389209 390754 392486 406945 410383 414242 418031 418976 429144 439191 449217 469956 475231 481335 484749 511407 513758 524964 532388 532395 536488 538539 538730 544219 545628 545930 547189 547299 554844 562742 564760 566670 576561 578907 588612 588756 591848 593049 599566 600486 601099 601122 602260 609976 611254 615949 616184 627156 636586 637632 640350 641636 644531 661329 692135 700239 701483 715103 715294 715983 717513 720540 731608 733455 738071 738248 738500 739368 742688 744213 744769 744799 748348 749087 750500 753692 754317 754605 754773 754977 754994 756339 759093 760585 760750 772621 774146 774730 774745 774754 777149 780998 781918 783291 783324 785146 785964 790242 790333 796862 796892 797339 801667 804248 804457 804646 807185 810808 811131 813723 814194 816106 819114 819273 824529 826602 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits solo girl"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ соло девушк"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.92%) |
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.