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 (441, 722, 410, 593, 503, 703, 729, 686, 607, 883, 418, 431, 1010, 499, 689, 899, 1006, 386, 591, 889, 802, 556, 831, 471, 645, 500, 829, 367, 920, 1005, 747, 652, 902, 448, 399, 1009, 1047, 385, 809, 833, 725, 1046, 776, 807, 443, 596, 366, 1029, 463, 716, 803, 384, 610, 619, 1038, 717, 750, 1028, 604, 402, 648, 383, 608, 504, 930, 416, 865, 557, 381, 473, 804, 417, 446, 688, 363, 527, 555, 585, 464, 558, 1050, 622, 449, 701, 724, 587, 1020, 649, 777, 779, 523, 711, 577, 526, 1021, 869, 634, 623, 401, 778, 868, 432, 419, 502, 1037, 440, 380, 574, 630, 592, 904, 714, 1026, 1018, 1048, 916, 654, 602, 1039, 579, 616, 749, 720, 1041, 617, 1007, 931, 590, 1040, 554, 400, 879, 901, 392, 727, 638, 891, 921, 923, 719, 723, 430, 712, 881, 721, 575, 808, 609, 497, 888, 631, 801, 884, 1025, 929, 890, 620, 1019, 597, 1011, 409, 826, 932, 442, 633, 434, 1049, 806, 524, 1017, 398, 882, 618, 647, 1016, 715, 603, 462, 24, 433, 382, 827, 748, 708, 898, 364, 589, 472, 728, 653, 606, 650, 393, 582, 470, 469, 461, 903, 394, 651, 584, 918, 447, 420, 621, 704, 687, 501, 917, 933, 655, 690, 892, 465, 408, 646, 391, 780, 866, 718, 1008, 886, 922, 705, 919, 828, 880, 525, 1027, 702, 830, 726, 365, 805, 709, 578, 710, 887, 900, 746, 885, 624, 413, 893, 444, 412, 450, 588, 395, 867, 411, 810))
LIMIT 1000
Run Time: 0.014698
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.001348
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