Query Metrics
7
Database Queries
7
Different statements
183.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
159.06 ms (86.69%) |
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 386621 396302 398542 404076 409421 415356 427158 434458 460376 485389 515036 524175 547389 548161 556424 567639 574172 577751 579499 584753 587837 589316 591096 602347 605749 607350 620637 622560 624021 627624 630149 662002 682846 685422 697483 702288 707425 715190 715735 716227 716920 720064 722078 723476 723912 725718 729013 732215 732980 734672 735361 737051 738377 739111 741227 748117 748423 749373 751266 751269 754226 758387 758874 759552 760099 761114 763551 769272 772307 776072 777336 777542 777820 778617 780147 781088 781583 782786 783552 785036 785174 785918 787057 787825 789167 790282 790306 790526 791481 791593 791668 793912 795212 795241 795335 795933 796410 800145 800252 800938 801678 802173 805608 813631 816712 816760 819071 819163 819724 820087 823543 824643 824782 825620 825759 826920 827325 827784 827906 ] |
||||||||||||||||||||||||||||||
|
13.86 ms (7.55%) |
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 622560 624021 630149 605749 805608 778617 723912 732980 739111 725718 602347 620637 621128 707425 434458 584753 587837 591096 589316 734672 738377 759552 607350 396302 415356 819724 816712 816760 826920 827325 825759 824782 827906 827784 515036 524175 722078 723476 716227 720064 548161 556424 567639 777542 777820 780147 781583 785174 791593 800145 751269 758874 772307 790526 795335 729013 751266 754226 758387 735361 761114 732215 748117 737051 748423 749373 763551 716920 777336 785036 787057 787825 795212 800938 427158 819071 386621 702288 662002 791481 485389 547389 682846 685422 697483 627624 398542 404076 409421 813631 825620 824643 819163 823543 820087 460376 579499 574172 577751 715735 715190 776072 781088 782786 785918 790306 793912 795933 800252 802173 783552 791668 801678 741227 760099 769272 789167 790282 795241 796410 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.63%) |
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 386621 396302 398542 404076 409421 415356 427158 434458 460376 485389 515036 524175 547389 548161 556424 567639 574172 577751 579499 584753 587837 589316 591096 602347 605749 607350 620637 622560 624021 627624 630149 662002 682846 685422 697483 702288 707425 715190 715735 716227 716920 720064 722078 723476 723912 725718 729013 732215 732980 734672 735361 737051 738377 739111 741227 748117 748423 749373 751266 751269 754226 758387 758874 759552 760099 761114 763551 769272 772307 776072 777336 777542 777820 778617 780147 781088 781583 782786 783552 785036 785174 785918 787057 787825 789167 790282 790306 790526 791481 791593 791668 793912 795212 795241 795335 795933 796410 800145 800252 800938 801678 802173 805608 813631 816712 816760 819071 819163 819724 820087 823543 824643 824782 825620 825759 826920 827325 827784 827906 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur sister"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск sister"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск sister"
]
|
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.