SELECT `xf_mg_media_item`.*, `xf_mg_album_Album_1`.*, `xf_mg_category_Category_2`.*, `xf_user_User_3`.*, `xf_attachment_Attachment_4`.*, `xf_attachment_data_Data_5`.*
FROM `xf_mg_media_item`
LEFT JOIN `xf_mg_album` AS `xf_mg_album_Album_1` ON (`xf_mg_album_Album_1`.`album_id` = `xf_mg_media_item`.`album_id`)
LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_2` ON (`xf_mg_category_Category_2`.`category_id` = `xf_mg_media_item`.`category_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_mg_media_item`.`user_id`)
LEFT JOIN `xf_attachment` AS `xf_attachment_Attachment_4` ON (`xf_attachment_Attachment_4`.`content_type` = 'xfmg_media' AND `xf_attachment_Attachment_4`.`content_id` = `xf_mg_media_item`.`media_id`)
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_5` ON (`xf_attachment_data_Data_5`.`data_id` = `xf_attachment_Attachment_4`.`data_id`)
WHERE (IF(`xf_mg_media_item`.`album_id` > 0, `xf_mg_album_Album_1`.`album_state` = 'visible', 1=1)) AND ((`xf_mg_media_item`.`category_id` = 0 AND `xf_mg_album_Album_1`.`view_privacy` = 'public')) AND (`xf_mg_media_item`.`media_state` = 'visible') AND (`xf_mg_media_item`.`media_id` IN (561, 650, 821, 1011, 693, 781, 450, 923, 999, 756, 915, 985, 1043, 715, 908, 651, 984, 646, 480, 981, 623, 616, 783, 1047, 995, 618, 448, 699, 841, 988, 647, 782, 455, 560, 1035, 458, 690, 901, 24, 823, 998, 1044, 917, 621, 390, 426, 493, 624, 371, 856, 606, 698, 843, 914, 925, 602, 819, 906, 986, 860, 367, 464, 1001, 380, 610, 694, 804, 937, 1045, 916, 757, 585, 604, 366, 881, 394, 820, 822, 780, 574, 622, 857, 481, 649, 483, 883, 1046, 365, 766, 370, 520, 697, 940, 802, 617, 1012, 524, 805, 393, 987, 363, 575, 556, 692, 619, 494, 521, 902, 762, 965, 422, 882, 607, 373, 1036, 688, 869, 778, 926, 884, 918, 877, 645, 871, 761, 461, 903, 451, 714, 696, 879, 717, 801, 867, 754, 459, 423, 842, 449, 716, 760, 391, 523, 612, 490, 969, 982, 892, 878, 922, 460, 571, 941, 392, 1038, 381, 691, 429, 1008, 456, 880, 755, 876, 1037, 769, 368, 968, 924, 584, 484, 1000, 562, 938, 777, 905, 427, 587, 491, 791, 793, 588, 462, 689, 983, 1039, 425, 453, 768, 844, 779, 428, 577, 904, 695, 996, 492, 559, 648, 893, 609, 620, 868, 789, 378, 891, 573, 379, 582, 907, 767, 997, 870, 966, 557, 597, 939, 369, 555, 424, 776, 603, 989, 572, 713, 382, 364, 1010, 858, 554, 430, 967, 452, 608, 463, 840, 859, 687, 889, 1009, 686, 890, 522, 558, 457, 770, 482, 792, 454, 803))
LIMIT 1000
Run Time: 0.012186
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_album_Album_1 | ALL | PRIMARY | | | | 30 | Using where |
SIMPLE | xf_mg_media_item | ref | PRIMARY,album_id_media_date,category_id_media_date | album_id_media_date | 4 | cj67783_ertos.xf_mg_album_Album_1.album_id | 17 | Using index condition; Using where |
SIMPLE | xf_mg_category_Category_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_mg_media_item.user_id | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,cj67783_ertos.xf_mg_media_item.media_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_attachment_Attachment_4.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1392
- XF\Mvc\Entity\Finder->fetch() in src/addons/XFMG/Widget/MediaSlider.php at line 100
- XFMG\Widget\MediaSlider->render() in internal_data/code_cache/widgets/_13_xfmg_media_slider.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7653
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1936
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s3/public/forum_list.php at line 219
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2353
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_user_LastPoster_4`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPoster_4` ON (`xf_user_LastPoster_4`.`user_id` = `xf_thread`.`last_post_user_id`)
WHERE (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (1) AND (`xf_thread`.`node_id` IN (2, 3, 4, 5, 6, 7, 8, 10, 12, 13, 14, 15, 16, 18, 19, 20, 21, 25, 26, 27, 28, 30, 31, 32, 33, 37, 46, 49, 56, 57, 58, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 83))
ORDER BY `xf_thread`.`last_post_date` DESC
LIMIT 20
Run Time: 0.001263
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | index | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score | last_post_date | 4 | | 20 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_thread.user_id | 1 | |
SIMPLE | xf_user_LastPoster_4 | eq_ref | PRIMARY | PRIMARY | 4 | cj67783_ertos.xf_thread.last_post_user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1392
- XF\Mvc\Entity\Finder->fetch() in src/addons/BR/ModernStatistic/Repository/ModernStatistic.php at line 508
- BR\ModernStatistic\Repository\ModernStatistic->getThreadStatistics() in src/addons/BR/ModernStatistic/Repository/ModernStatistic.php at line 272
- BR\ModernStatistic\Repository\ModernStatistic->getStatisticTabParams() in src/addons/BR/ModernStatistic/Service/ModernStatistic/Render.php at line 173
- BR\ModernStatistic\Service\ModernStatistic\Render->render() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 13
- BR\ModernStatistic\XF\Template\Templater->callAdsMacro() in internal_data/code_cache/templates/l3/s3/public/forum_overview_wrapper.php at line 7
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1651
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1048
- XF\Template\Templater->applyWrappedTemplate() in src/XF/Template/Templater.php at line 1666
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2353
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20