Query Metrics
7
Database Queries
7
Different statements
150.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.68 ms (80.97%) |
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 31583 118900 199865 210106 393711 409984 420007 420011 429144 429252 462280 472305 490586 491010 491422 491853 517432 521447 525062 525481 527596 529594 530082 530658 535371 535601 535616 536488 539598 542321 544353 544454 545798 546820 547559 551567 551826 552547 556673 556838 558531 558612 559345 560166 570928 580934 580944 580956 586186 588293 589561 593661 601900 605134 606086 607244 615616 615831 619132 624527 634329 635223 662480 665038 685523 685527 695662 695984 696688 701204 713145 723357 732923 733506 734372 737569 740747 744933 748643 751377 753028 760298 765577 771406 777156 778228 788137 789025 789047 789064 790380 790881 792598 792623 792757 792779 792786 798746 804263 810621 812231 812238 812523 814166 817519 817627 817788 818742 820186 820869 821139 824269 824277 828158 828172 828259 828286 828371 ] |
||||||||||||||||||||||||||||||
|
17.52 ms (11.66%) |
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 792757 544353 546820 558612 817519 814166 817788 798746 812238 751377 580956 556673 788137 490586 536488 535371 593661 812231 777156 393711 828259 601900 701204 685527 558531 580944 665038 789025 732923 734372 634329 817627 821139 820869 828172 525481 530082 547559 580934 723357 606086 812523 792786 559345 199865 210106 552547 517432 789064 810621 804263 539598 420007 535616 589561 619132 409984 635223 556838 586186 118900 792779 31583 429252 588293 760298 771406 491422 535601 530658 695984 624527 778228 789047 790380 696688 824277 823060 828158 828061 828286 491853 560166 685523 713145 744933 765577 748643 792598 429144 529594 737569 824269 828371 792623 733506 420011 605134 545798 695662 662480 740747 753028 790881 551826 472305 491010 525062 527596 551567 542321 607244 615831 570928 615616 521447 544454 462280 818742 820186 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (2.18%) |
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 31583 118900 199865 210106 393711 409984 420007 420011 429144 429252 462280 472305 490586 491010 491422 491853 517432 521447 525062 525481 527596 529594 530082 530658 535371 535601 535616 536488 539598 542321 544353 544454 545798 546820 547559 551567 551826 552547 556673 556838 558531 558612 559345 560166 570928 580934 580944 580956 586186 588293 589561 593661 601900 605134 606086 607244 615616 615831 619132 624527 634329 635223 662480 665038 685523 685527 695662 695984 696688 701204 713145 723357 732923 733506 734372 737569 740747 744933 748643 751377 753028 760298 765577 771406 777156 778228 788137 789025 789047 789064 790380 790881 792598 792623 792757 792779 792786 798746 804263 810621 812231 812238 812523 814166 817519 817627 817788 818742 820186 820869 821139 824269 824277 828158 828172 828259 828286 828371 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits public"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.37%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ на улиц"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.12%) |
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.