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 (19065, 17994, 15895, 15852, 15259, 15088, 15087, 15086, 15085, 15084, 15083, 15082, 15081, 15080, 15079, 15078, 15077, 15076, 15075, 15074, 15073, 15072, 15071, 15070, 15069, 15068, 15067, 15066, 15065, 15064, 15063, 15062, 15061, 15060, 15058, 15057, 15056, 15055, 15054, 15053, 15052, 15051, 15050, 15049, 15048, 15047, 15046, 15045, 15044, 15043, 15042, 15041, 15040, 15039, 15038, 15037, 15036, 15035, 15034, 15033, 15032, 15031, 15030, 15029, 15028, 15027, 14369, 14368, 14367, 14366, 14365, 14364, 14363, 14362, 14361, 13303, 13302, 13301, 13300, 13299, 13298, 13297, 13296, 13295, 13294, 13293, 13292, 13291, 13290, 13289, 13288, 13287, 13286, 13285, 13284, 13283, 13282, 13281, 13280, 13279, 13278, 13277, 13276, 13275, 13274, 13273, 13272, 13271, 13270, 13269, 13268, 13267, 13266, 13265, 13264, 13263, 13262, 13261, 13260, 13259, 13258, 13257, 13256, 13255, 13254, 13253, 13252, 13251, 13250, 13249, 13248, 13247, 13246, 2655, 2610, 2609, 2608, 2607, 2606, 2605, 2604, 2603, 2602, 2601, 2600, 2599, 2598, 2597, 2596, 2595, 2593, 2592, 2591, 2590, 2589, 2588, 896))
Run Time: 0.004706
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_media_item | range | PRIMARY | PRIMARY | 4 | | 157 | 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: 370, 0, 1715085827, {"xfmg_media-19065":["xfmg_media",19065],"xfmg_media-17994":["xfmg_media",17994],"xfmg_media-15895":["xfmg_media",15895],"xfmg_media-15852":["xfmg_media",15852],"xfmg_media-15259":["xfmg_media",15259],"thread-85817":["thread",85817],"xfmg_media-15088":["xfmg_media",15088],"xfmg_media-15087":["xfmg_media",15087],"xfmg_media-15086":["xfmg_media",15086],"xfmg_media-15085":["xfmg_media",15085],"xfmg_media-15084":["xfmg_media",15084],"xfmg_media-15083":["xfmg_media",15083],"xfmg_media-15082":["xfmg_media",15082],"xfmg_media-15081":["xfmg_media",15081],"xfmg_media-15080":["xfmg_media",15080],"xfmg_media-15079":["xfmg_media",15079],"xfmg_media-15078":["xfmg_media",15078],"xfmg_media-15077":["xfmg_media",15077],"xfmg_media-15076":["xfmg_media",15076],"xfmg_media-15075":["xfmg_media",15075],"xfmg_media-15074":["xfmg_media",15074],"xfmg_media-15073":["xfmg_media",15073],"xfmg_media-15072":["xfmg_media",15072],"xfmg_media-15071":["xfmg_media",15071],"xfmg_media-15070":["xfmg_media",15070],"xfmg_media-15069":["xfmg_media",15069],"xfmg_media-15068":["xfmg_media",15068],"xfmg_media-15067":["xfmg_media",15067],"xfmg_media-15066":["xfmg_media",15066],"xfmg_media-15065":["xfmg_media",15065],"xfmg_media-15064":["xfmg_media",15064],"xfmg_media-15063":["xfmg_media",15063],"xfmg_media-15062":["xfmg_media",15062],"xfmg_media-15061":["xfmg_media",15061],"xfmg_media-15060":["xfmg_media",15060],"xfmg_media-15058":["xfmg_media",15058],"xfmg_media-15057":["xfmg_media",15057],"xfmg_media-15056":["xfmg_media",15056],"xfmg_media-15055":["xfmg_media",15055],"xfmg_media-15054":["xfmg_media",15054],"xfmg_media-15053":["xfmg_media",15053],"xfmg_media-15052":["xfmg_media",15052],"xfmg_media-15051":["xfmg_media",15051],"xfmg_media-15050":["xfmg_media",15050],"xfmg_media-15049":["xfmg_media",15049],"xfmg_media-15048":["xfmg_media",15048],"xfmg_media-15047":["xfmg_media",15047],"xfmg_media-15046":["xfmg_media",15046],"xfmg_media-15045":["xfmg_media",15045],"xfmg_media-15044":["xfmg_media",15044],"xfmg_media-15043":["xfmg_media",15043],"xfmg_media-15042":["xfmg_media",15042],"xfmg_media-15041":["xfmg_media",15041],"xfmg_media-15040":["xfmg_media",15040],"xfmg_media-15039":["xfmg_media",15039],"xfmg_media-15038":["xfmg_media",15038],"xfmg_media-15037":["xfmg_media",15037],"xfmg_media-15036":["xfmg_media",15036],"xfmg_media-15035":["xfmg_media",15035],"xfmg_media-15034":["xfmg_media",15034],"xfmg_media-15033":["xfmg_media",15033],"xfmg_media-15032":["xfmg_media",15032],"xfmg_media-15031":["xfmg_media",15031],"xfmg_media-15030":["xfmg_media",15030],"xfmg_media-15029":["xfmg_media",15029],"xfmg_media-15028":["xfmg_media",15028],"xfmg_media-15027":["xfmg_media",15027],"xfmg_media-14369":["xfmg_media",14369],"xfmg_media-14368":["xfmg_media",14368],"xfmg_media-14367":["xfmg_media",14367],"xfmg_media-14366":["xfmg_media",14366],"xfmg_media-14365":["xfmg_media",14365],"xfmg_media-14364":["xfmg_media",14364],"xfmg_media-14363":["xfmg_media",14363],"xfmg_media-14362":["xfmg_media",14362],"xfmg_media-14361":["xfmg_media",14361],"thread-85611":["thread",85611],"xfmg_media-13303":["xfmg_media",13303],"xfmg_media-13302":["xfmg_media",13302],"xfmg_media-13301":["xfmg_media",13301],"xfmg_media-13300":["xfmg_media",13300],"xfmg_media-13299":["xfmg_media",13299],"xfmg_media-13298":["xfmg_media",13298],"xfmg_media-13297":["xfmg_media",13297],"xfmg_media-13296":["xfmg_media",13296],"xfmg_media-13295":["xfmg_media",13295],"xfmg_media-13294":["xfmg_media",13294],"xfmg_media-13293":["xfmg_media",13293],"xfmg_media-13292":["xfmg_media",13292],"xfmg_media-13291":["xfmg_media",13291],"xfmg_media-13290":["xfmg_media",13290],"xfmg_media-13289":["xfmg_media",13289],"xfmg_media-13288":["xfmg_media",13288],"xfmg_media-13287":["xfmg_media",13287],"xfmg_media-13286":["xfmg_media",13286],"xfmg_media-13285":["xfmg_media",13285],"xfmg_media-13284":["xfmg_media",13284],"xfmg_media-13283":["xfmg_media",13283],"xfmg_media-13282":["xfmg_media",13282],"xfmg_media-13281":["xfmg_media",13281],"xfmg_media-13280":["xfmg_media",13280],"xfmg_media-13279":["xfmg_media",13279],"xfmg_media-13278":["xfmg_media",13278],"xfmg_media-13277":["xfmg_media",13277],"xfmg_media-13276":["xfmg_media",13276],"xfmg_media-13275":["xfmg_media",13275],"xfmg_media-13274":["xfmg_media",13274],"xfmg_media-13273":["xfmg_media",13273],"xfmg_media-13272":["xfmg_media",13272],"xfmg_media-13271":["xfmg_media",13271],"xfmg_media-13270":["xfmg_media",13270],"xfmg_media-13269":["xfmg_media",13269],"xfmg_media-13268":["xfmg_media",13268],"xfmg_media-13267":["xfmg_media",13267],"xfmg_media-13266":["xfmg_media",13266],"xfmg_media-13265":["xfmg_media",13265],"xfmg_media-13264":["xfmg_media",13264],"xfmg_media-13263":["xfmg_media",13263],"xfmg_media-13262":["xfmg_media",13262],"xfmg_media-13261":["xfmg_media",13261],"xfmg_media-13260":["xfmg_media",13260],"xfmg_media-13259":["xfmg_media",13259],"xfmg_media-13258":["xfmg_media",13258],"xfmg_media-13257":["xfmg_media",13257],"xfmg_media-13256":["xfmg_media",13256],"xfmg_media-13255":["xfmg_media",13255],"xfmg_media-13254":["xfmg_media",13254],"xfmg_media-13253":["xfmg_media",13253],"xfmg_media-13252":["xfmg_media",13252],"xfmg_media-13251":["xfmg_media",13251],"xfmg_media-13250":["xfmg_media",13250],"xfmg_media-13249":["xfmg_media",13249],"xfmg_media-13248":["xfmg_media",13248],"xfmg_media-13247":["xfmg_media",13247],"xfmg_media-13246":["xfmg_media",13246],"xfmg_media-2655":["xfmg_media",2655],"xfmg_media-2610":["xfmg_media",2610],"xfmg_media-2609":["xfmg_media",2609],"xfmg_media-2608":["xfmg_media",2608],"xfmg_media-2607":["xfmg_media",2607],"xfmg_media-2606":["xfmg_media",2606],"xfmg_media-2605":["xfmg_media",2605],"xfmg_media-2604":["xfmg_media",2604],"xfmg_media-2603":["xfmg_media",2603],"xfmg_media-2602":["xfmg_media",2602],"xfmg_media-2601":["xfmg_media",2601],"xfmg_media-2600":["xfmg_media",2600],"xfmg_media-2599":["xfmg_media",2599],"xfmg_media-2598":["xfmg_media",2598],"xfmg_media-2597":["xfmg_media",2597],"xfmg_media-2596":["xfmg_media",2596],"xfmg_media-2595":["xfmg_media",2595],"xfmg_media-2593":["xfmg_media",2593],"xfmg_media-2592":["xfmg_media",2592],"xfmg_media-2591":["xfmg_media",2591],"xfmg_media-2590":["xfmg_media",2590],"xfmg_media-2589":["xfmg_media",2589],"xfmg_media-2588":["xfmg_media",2588],"xfmg_media-896":["xfmg_media",896]}, , 1715082227
Run Time: 0.000208
- 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