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 (`xf_mg_media_item`.`media_id` IN (20759, 20685, 20684, 20683, 20682, 20681, 20680, 20623, 20620, 20619, 20618, 20617, 20616, 20615, 20614, 20613, 20612, 20611, 20610, 20609, 20608, 20607, 20524, 20361, 19585, 19581, 19122, 19121, 19049, 18769, 18583, 18451, 18200, 18115, 18112, 18111, 18110, 18109, 18108, 18107, 18106, 18105, 18104, 18103, 18102, 18101, 18099, 18098, 18097, 18096, 18095, 18094, 18093, 18092, 18091, 18090, 18089, 18088, 18087, 18086, 18085, 18084, 18083, 18082, 18081, 18080, 18079, 18078, 18077, 18076, 18075, 18074, 18072, 18071, 18070, 18069, 18068, 18067, 18066, 18065, 18064, 18063, 18062, 18061, 18060, 18059, 18058, 18057, 18056, 18055, 18054, 17906, 17904, 17861, 17860, 17859, 17858, 17857, 17855, 17852, 17848, 17847, 17846, 17845, 17844, 17843, 17842, 17841, 17840, 17839, 17838, 17837, 17700, 17699, 17698, 17697, 17599, 17598, 17597, 17596, 17595, 17594, 17593, 17592, 17591, 17590, 17583, 17582, 17581, 17580, 17579, 17578, 17577, 17576, 17575, 17574, 17573, 17572, 17571, 17570, 17484, 17474, 17473, 17433, 17415, 17414, 17413, 17412, 17411, 17410, 17409, 17408, 17407, 17406, 17405, 17404, 17403, 17402, 17401, 17400, 17399, 17398, 17397, 17396, 17395, 17374, 17373, 17372, 17371, 17370, 17369, 17368, 17363, 17362, 17361, 17360, 17359, 17358, 17357, 17356, 17355, 17354, 17353, 17352, 17351, 17350, 17349, 17348, 17347, 17340, 17339, 17338, 17337, 17336, 17335, 17334, 17333, 17332, 17331, 17330))
Run Time: 0.006967
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_media_item | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | xf_mg_album_Album_1 | eq_ref | PRIMARY | PRIMARY | 4 | devadriaforum.xf_mg_media_item.album_id | 1 | |
SIMPLE | xf_mg_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | devadriaforum.xf_mg_media_item.category_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | devadriaforum.xf_mg_media_item.user_id | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,devadriaforum.xf_mg_media_item.media_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | devadriaforum.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 1387
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2729
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 731
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 137
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 263
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 3, 0, 1715426804, {"xfmg_media-20759":["xfmg_media",20759],"xfmg_media-20607":["xfmg_media",20607],"xfmg_media-20524":["xfmg_media",20524],"xfmg_media-20361":["xfmg_media",20361],"xfmg_media-19585":["xfmg_media",19585],"xfmg_media-19581":["xfmg_media",19581],"xfmg_media-19122":["xfmg_media",19122],"xfmg_media-19121":["xfmg_media",19121],"xfmg_media-19049":["xfmg_media",19049],"xfmg_media-18769":["xfmg_media",18769],"xfmg_media-18583":["xfmg_media",18583],"xfmg_media-18451":["xfmg_media",18451],"xfmg_media-18200":["xfmg_media",18200],"xfmg_media-18115":["xfmg_media",18115],"xfmg_media-18112":["xfmg_media",18112],"xfmg_media-18111":["xfmg_media",18111],"xfmg_media-18110":["xfmg_media",18110],"xfmg_media-18109":["xfmg_media",18109],"xfmg_media-18108":["xfmg_media",18108],"xfmg_media-18107":["xfmg_media",18107],"xfmg_media-18106":["xfmg_media",18106],"xfmg_media-18105":["xfmg_media",18105],"xfmg_media-18104":["xfmg_media",18104],"xfmg_media-18103":["xfmg_media",18103],"xfmg_media-18102":["xfmg_media",18102],"xfmg_media-18101":["xfmg_media",18101],"xfmg_media-18099":["xfmg_media",18099],"xfmg_media-18098":["xfmg_media",18098],"xfmg_media-18097":["xfmg_media",18097],"xfmg_media-18096":["xfmg_media",18096],"xfmg_media-18095":["xfmg_media",18095],"xfmg_media-18094":["xfmg_media",18094],"xfmg_media-18093":["xfmg_media",18093],"xfmg_media-18092":["xfmg_media",18092],"xfmg_media-18091":["xfmg_media",18091],"xfmg_media-18090":["xfmg_media",18090],"xfmg_media-18089":["xfmg_media",18089],"xfmg_media-18088":["xfmg_media",18088],"xfmg_media-18087":["xfmg_media",18087],"xfmg_media-18086":["xfmg_media",18086],"xfmg_media-18085":["xfmg_media",18085],"xfmg_media-18084":["xfmg_media",18084],"xfmg_media-18083":["xfmg_media",18083],"xfmg_media-18082":["xfmg_media",18082],"xfmg_media-18081":["xfmg_media",18081],"xfmg_media-18080":["xfmg_media",18080],"xfmg_media-18079":["xfmg_media",18079],"xfmg_media-18078":["xfmg_media",18078],"xfmg_media-18077":["xfmg_media",18077],"xfmg_media-18076":["xfmg_media",18076],"xfmg_media-18075":["xfmg_media",18075],"xfmg_media-18074":["xfmg_media",18074],"xfmg_media-18072":["xfmg_media",18072],"xfmg_media-18071":["xfmg_media",18071],"xfmg_media-18070":["xfmg_media",18070],"xfmg_media-18069":["xfmg_media",18069],"xfmg_media-18068":["xfmg_media",18068],"xfmg_media-18067":["xfmg_media",18067],"xfmg_media-18066":["xfmg_media",18066],"xfmg_media-18065":["xfmg_media",18065],"xfmg_media-18064":["xfmg_media",18064],"xfmg_media-18063":["xfmg_media",18063],"xfmg_media-18062":["xfmg_media",18062],"xfmg_media-18061":["xfmg_media",18061],"xfmg_media-18060":["xfmg_media",18060],"xfmg_media-18059":["xfmg_media",18059],"xfmg_media-18058":["xfmg_media",18058],"xfmg_media-18057":["xfmg_media",18057],"xfmg_media-18056":["xfmg_media",18056],"xfmg_media-18055":["xfmg_media",18055],"xfmg_media-18054":["xfmg_media",18054],"xfmg_media-17906":["xfmg_media",17906],"xfmg_media-17904":["xfmg_media",17904],"xfmg_media-17861":["xfmg_media",17861],"xfmg_media-17860":["xfmg_media",17860],"xfmg_media-17859":["xfmg_media",17859],"xfmg_media-17858":["xfmg_media",17858],"xfmg_media-17857":["xfmg_media",17857],"xfmg_media-17855":["xfmg_media",17855],"xfmg_media-17852":["xfmg_media",17852],"xfmg_media-17848":["xfmg_media",17848],"xfmg_media-17847":["xfmg_media",17847],"xfmg_media-17846":["xfmg_media",17846],"xfmg_media-17845":["xfmg_media",17845],"xfmg_media-17844":["xfmg_media",17844],"xfmg_media-17843":["xfmg_media",17843],"xfmg_media-17842":["xfmg_media",17842],"xfmg_media-17841":["xfmg_media",17841],"xfmg_media-17840":["xfmg_media",17840],"xfmg_media-17839":["xfmg_media",17839],"xfmg_media-17838":["xfmg_media",17838],"xfmg_media-17837":["xfmg_media",17837],"xfmg_media-17700":["xfmg_media",17700],"xfmg_media-17699":["xfmg_media",17699],"xfmg_media-17698":["xfmg_media",17698],"xfmg_media-17697":["xfmg_media",17697],"xfmg_media-17599":["xfmg_media",17599],"xfmg_media-17598":["xfmg_media",17598],"xfmg_media-17597":["xfmg_media",17597],"xfmg_media-17596":["xfmg_media",17596],"xfmg_media-17595":["xfmg_media",17595],"xfmg_media-17594":["xfmg_media",17594],"xfmg_media-17593":["xfmg_media",17593],"xfmg_media-17592":["xfmg_media",17592],"xfmg_media-17591":["xfmg_media",17591],"xfmg_media-17590":["xfmg_media",17590],"xfmg_media-17583":["xfmg_media",17583],"xfmg_media-17582":["xfmg_media",17582],"xfmg_media-17581":["xfmg_media",17581],"xfmg_media-17580":["xfmg_media",17580],"xfmg_media-17579":["xfmg_media",17579],"xfmg_media-17578":["xfmg_media",17578],"xfmg_media-17577":["xfmg_media",17577],"xfmg_media-17576":["xfmg_media",17576],"xfmg_media-17575":["xfmg_media",17575],"xfmg_media-17574":["xfmg_media",17574],"xfmg_media-17573":["xfmg_media",17573],"xfmg_media-17572":["xfmg_media",17572],"xfmg_media-17571":["xfmg_media",17571],"xfmg_media-17570":["xfmg_media",17570],"xfmg_media-17484":["xfmg_media",17484],"xfmg_media-17474":["xfmg_media",17474],"xfmg_media-17473":["xfmg_media",17473],"xfmg_media-17433":["xfmg_media",17433],"xfmg_media-17415":["xfmg_media",17415],"xfmg_media-17414":["xfmg_media",17414],"xfmg_media-17413":["xfmg_media",17413],"xfmg_media-17412":["xfmg_media",17412],"xfmg_media-17411":["xfmg_media",17411],"xfmg_media-17410":["xfmg_media",17410],"xfmg_media-17409":["xfmg_media",17409],"xfmg_media-17408":["xfmg_media",17408],"xfmg_media-17407":["xfmg_media",17407],"xfmg_media-17406":["xfmg_media",17406],"xfmg_media-17405":["xfmg_media",17405],"xfmg_media-17404":["xfmg_media",17404],"xfmg_media-17403":["xfmg_media",17403],"xfmg_media-17402":["xfmg_media",17402],"xfmg_media-17401":["xfmg_media",17401],"xfmg_media-17400":["xfmg_media",17400],"xfmg_media-17399":["xfmg_media",17399],"xfmg_media-17398":["xfmg_media",17398],"xfmg_media-17397":["xfmg_media",17397],"xfmg_media-17396":["xfmg_media",17396],"xfmg_media-17395":["xfmg_media",17395],"xfmg_media-17374":["xfmg_media",17374],"xfmg_media-17373":["xfmg_media",17373],"xfmg_media-17372":["xfmg_media",17372],"xfmg_media-17371":["xfmg_media",17371],"xfmg_media-17370":["xfmg_media",17370],"xfmg_media-17369":["xfmg_media",17369],"xfmg_media-17368":["xfmg_media",17368],"xfmg_media-17363":["xfmg_media",17363],"xfmg_media-17362":["xfmg_media",17362],"xfmg_media-17361":["xfmg_media",17361],"xfmg_media-17360":["xfmg_media",17360],"xfmg_media-17359":["xfmg_media",17359],"xfmg_media-17358":["xfmg_media",17358],"xfmg_media-17357":["xfmg_media",17357],"xfmg_media-17356":["xfmg_media",17356],"xfmg_media-17355":["xfmg_media",17355],"xfmg_media-17354":["xfmg_media",17354],"xfmg_media-17353":["xfmg_media",17353],"xfmg_media-17352":["xfmg_media",17352],"xfmg_media-17351":["xfmg_media",17351],"xfmg_media-17350":["xfmg_media",17350],"xfmg_media-17349":["xfmg_media",17349],"xfmg_media-17348":["xfmg_media",17348]}, , 1715423204
Run Time: 0.000211
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 223
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 263
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20