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 (12898, 10555, 10554, 10553, 10552, 9543, 9541, 9540, 9353, 9352, 9351, 9350, 9349, 9348, 9347, 9346, 9345, 8741, 8457, 8456, 8455, 8454, 8453, 8452, 8451, 8450, 8449, 8448, 8447, 8446, 8445, 8444, 8443, 8442, 8441, 8440, 8439, 8438, 8437, 8436, 8435, 8434, 8433, 8432, 8431, 8430, 8429, 8428, 8427, 8426, 8425, 8424, 8423, 8422, 8421, 8420, 8419, 7066, 7065, 7064, 7063, 7062, 7061, 7060, 7059, 7058, 7057, 7056, 7055, 7054, 7053, 7052, 7051, 7050, 7049, 7048, 7047, 7046, 7045, 7044, 7043, 7042, 7041, 7040, 7039, 7038, 7037, 7036, 7035, 7034, 7033, 7032, 7031, 7030, 7029, 7028, 7027, 7026, 7025, 7024, 7023, 7022, 7021, 6931, 6841, 6840, 6839, 6838, 6837, 6836, 6835, 6834, 6833, 6832, 6831, 6830, 6829, 6828, 6827, 6826, 6825, 6824, 6823, 6822, 6821, 6820, 6819, 6818, 6817, 6816, 6815, 6814, 6813, 6812, 6811, 6810, 6809, 6808, 6807, 6806, 6805, 6593, 6582, 6581, 6580, 6579, 6578, 6577, 6576, 6575, 6574, 6573, 6572, 6571, 6570, 6569, 6568, 6567, 6566, 6565, 6559, 6558, 6557, 6556, 6555, 6554, 6553, 6552, 6551, 6550, 6549, 6548, 6547, 6546, 6545, 6544, 6543, 6542, 6540, 6539, 6538, 6537, 6536, 6535, 6534, 6533, 6532, 6531, 6530, 6529, 6528, 6527, 6526, 6525, 6524, 6523, 6522, 6521, 6519))
Run Time: 0.005192
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_media_item | range | PRIMARY | PRIMARY | 4 | | 199 | 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: 1773, 0, 1716198485, {"xfmg_media-12898":["xfmg_media",12898],"xfmg_media-10555":["xfmg_media",10555],"xfmg_media-10554":["xfmg_media",10554],"xfmg_media-10553":["xfmg_media",10553],"xfmg_media-10552":["xfmg_media",10552],"xfmg_media-9543":["xfmg_media",9543],"xfmg_media-9541":["xfmg_media",9541],"xfmg_media-9540":["xfmg_media",9540],"xfmg_media-9353":["xfmg_media",9353],"xfmg_media-9352":["xfmg_media",9352],"xfmg_media-9351":["xfmg_media",9351],"xfmg_media-9350":["xfmg_media",9350],"xfmg_media-9349":["xfmg_media",9349],"xfmg_media-9348":["xfmg_media",9348],"xfmg_media-9347":["xfmg_media",9347],"xfmg_media-9346":["xfmg_media",9346],"xfmg_media-9345":["xfmg_media",9345],"xfmg_media-8741":["xfmg_media",8741],"xfmg_media-8457":["xfmg_media",8457],"xfmg_media-8456":["xfmg_media",8456],"xfmg_media-8455":["xfmg_media",8455],"xfmg_media-8454":["xfmg_media",8454],"xfmg_media-8453":["xfmg_media",8453],"xfmg_media-8452":["xfmg_media",8452],"xfmg_media-8451":["xfmg_media",8451],"xfmg_media-8450":["xfmg_media",8450],"xfmg_media-8449":["xfmg_media",8449],"xfmg_media-8448":["xfmg_media",8448],"xfmg_media-8447":["xfmg_media",8447],"xfmg_media-8446":["xfmg_media",8446],"xfmg_media-8445":["xfmg_media",8445],"xfmg_media-8444":["xfmg_media",8444],"xfmg_media-8443":["xfmg_media",8443],"xfmg_media-8442":["xfmg_media",8442],"xfmg_media-8441":["xfmg_media",8441],"xfmg_media-8440":["xfmg_media",8440],"xfmg_media-8439":["xfmg_media",8439],"xfmg_media-8438":["xfmg_media",8438],"xfmg_media-8437":["xfmg_media",8437],"xfmg_media-8436":["xfmg_media",8436],"xfmg_media-8435":["xfmg_media",8435],"xfmg_media-8434":["xfmg_media",8434],"xfmg_media-8433":["xfmg_media",8433],"xfmg_media-8432":["xfmg_media",8432],"xfmg_media-8431":["xfmg_media",8431],"xfmg_media-8430":["xfmg_media",8430],"xfmg_media-8429":["xfmg_media",8429],"xfmg_media-8428":["xfmg_media",8428],"xfmg_media-8427":["xfmg_media",8427],"xfmg_media-8426":["xfmg_media",8426],"xfmg_media-8425":["xfmg_media",8425],"xfmg_media-8424":["xfmg_media",8424],"xfmg_media-8423":["xfmg_media",8423],"xfmg_media-8422":["xfmg_media",8422],"xfmg_media-8421":["xfmg_media",8421],"xfmg_media-8420":["xfmg_media",8420],"xfmg_media-8419":["xfmg_media",8419],"xfmg_media-7066":["xfmg_media",7066],"xfmg_media-7065":["xfmg_media",7065],"xfmg_media-7064":["xfmg_media",7064],"xfmg_media-7063":["xfmg_media",7063],"xfmg_media-7062":["xfmg_media",7062],"xfmg_media-7061":["xfmg_media",7061],"xfmg_media-7060":["xfmg_media",7060],"xfmg_media-7059":["xfmg_media",7059],"xfmg_media-7058":["xfmg_media",7058],"xfmg_media-7057":["xfmg_media",7057],"xfmg_media-7056":["xfmg_media",7056],"xfmg_media-7055":["xfmg_media",7055],"xfmg_media-7054":["xfmg_media",7054],"xfmg_media-7053":["xfmg_media",7053],"xfmg_media-7052":["xfmg_media",7052],"xfmg_media-7051":["xfmg_media",7051],"xfmg_media-7050":["xfmg_media",7050],"xfmg_media-7049":["xfmg_media",7049],"xfmg_media-7048":["xfmg_media",7048],"xfmg_media-7047":["xfmg_media",7047],"xfmg_media-7046":["xfmg_media",7046],"xfmg_media-7045":["xfmg_media",7045],"xfmg_media-7044":["xfmg_media",7044],"xfmg_media-7043":["xfmg_media",7043],"xfmg_media-7042":["xfmg_media",7042],"xfmg_media-7041":["xfmg_media",7041],"xfmg_media-7040":["xfmg_media",7040],"xfmg_media-7039":["xfmg_media",7039],"xfmg_media-7038":["xfmg_media",7038],"xfmg_media-7037":["xfmg_media",7037],"xfmg_media-7036":["xfmg_media",7036],"xfmg_media-7035":["xfmg_media",7035],"xfmg_media-7034":["xfmg_media",7034],"xfmg_media-7033":["xfmg_media",7033],"xfmg_media-7032":["xfmg_media",7032],"xfmg_media-7031":["xfmg_media",7031],"xfmg_media-7030":["xfmg_media",7030],"xfmg_media-7029":["xfmg_media",7029],"xfmg_media-7028":["xfmg_media",7028],"xfmg_media-7027":["xfmg_media",7027],"xfmg_media-7026":["xfmg_media",7026],"xfmg_media-7025":["xfmg_media",7025],"xfmg_media-7024":["xfmg_media",7024],"xfmg_media-7023":["xfmg_media",7023],"xfmg_media-7022":["xfmg_media",7022],"xfmg_media-7021":["xfmg_media",7021],"xfmg_media-6931":["xfmg_media",6931],"thread-84793":["thread",84793],"xfmg_media-6841":["xfmg_media",6841],"xfmg_media-6840":["xfmg_media",6840],"xfmg_media-6839":["xfmg_media",6839],"xfmg_media-6838":["xfmg_media",6838],"xfmg_media-6837":["xfmg_media",6837],"xfmg_media-6836":["xfmg_media",6836],"xfmg_media-6835":["xfmg_media",6835],"xfmg_media-6834":["xfmg_media",6834],"xfmg_media-6833":["xfmg_media",6833],"xfmg_media-6832":["xfmg_media",6832],"xfmg_media-6831":["xfmg_media",6831],"xfmg_media-6830":["xfmg_media",6830],"xfmg_media-6829":["xfmg_media",6829],"xfmg_media-6828":["xfmg_media",6828],"xfmg_media-6827":["xfmg_media",6827],"xfmg_media-6826":["xfmg_media",6826],"xfmg_media-6825":["xfmg_media",6825],"xfmg_media-6824":["xfmg_media",6824],"xfmg_media-6823":["xfmg_media",6823],"xfmg_media-6822":["xfmg_media",6822],"xfmg_media-6821":["xfmg_media",6821],"xfmg_media-6820":["xfmg_media",6820],"xfmg_media-6819":["xfmg_media",6819],"xfmg_media-6818":["xfmg_media",6818],"xfmg_media-6817":["xfmg_media",6817],"xfmg_media-6816":["xfmg_media",6816],"xfmg_media-6815":["xfmg_media",6815],"xfmg_media-6814":["xfmg_media",6814],"xfmg_media-6813":["xfmg_media",6813],"xfmg_media-6812":["xfmg_media",6812],"xfmg_media-6811":["xfmg_media",6811],"xfmg_media-6810":["xfmg_media",6810],"xfmg_media-6809":["xfmg_media",6809],"xfmg_media-6808":["xfmg_media",6808],"xfmg_media-6807":["xfmg_media",6807],"xfmg_media-6806":["xfmg_media",6806],"xfmg_media-6805":["xfmg_media",6805],"xfmg_media-6593":["xfmg_media",6593],"xfmg_media-6582":["xfmg_media",6582],"xfmg_media-6581":["xfmg_media",6581],"xfmg_media-6580":["xfmg_media",6580],"xfmg_media-6579":["xfmg_media",6579],"xfmg_media-6578":["xfmg_media",6578],"xfmg_media-6577":["xfmg_media",6577],"xfmg_media-6576":["xfmg_media",6576],"xfmg_media-6575":["xfmg_media",6575],"xfmg_media-6574":["xfmg_media",6574],"xfmg_media-6573":["xfmg_media",6573],"xfmg_media-6572":["xfmg_media",6572],"xfmg_media-6571":["xfmg_media",6571],"xfmg_media-6570":["xfmg_media",6570],"xfmg_media-6569":["xfmg_media",6569],"xfmg_media-6568":["xfmg_media",6568],"xfmg_media-6567":["xfmg_media",6567],"xfmg_media-6566":["xfmg_media",6566],"xfmg_media-6565":["xfmg_media",6565],"xfmg_media-6559":["xfmg_media",6559],"xfmg_media-6558":["xfmg_media",6558],"xfmg_media-6557":["xfmg_media",6557],"xfmg_media-6556":["xfmg_media",6556],"xfmg_media-6555":["xfmg_media",6555],"xfmg_media-6554":["xfmg_media",6554],"xfmg_media-6553":["xfmg_media",6553],"xfmg_media-6552":["xfmg_media",6552],"xfmg_media-6551":["xfmg_media",6551],"xfmg_media-6550":["xfmg_media",6550],"xfmg_media-6549":["xfmg_media",6549],"xfmg_media-6548":["xfmg_media",6548],"xfmg_media-6547":["xfmg_media",6547],"xfmg_media-6546":["xfmg_media",6546],"xfmg_media-6545":["xfmg_media",6545],"xfmg_media-6544":["xfmg_media",6544],"xfmg_media-6543":["xfmg_media",6543],"xfmg_media-6542":["xfmg_media",6542],"xfmg_media-6540":["xfmg_media",6540],"xfmg_media-6539":["xfmg_media",6539],"xfmg_media-6538":["xfmg_media",6538],"xfmg_media-6537":["xfmg_media",6537],"xfmg_media-6536":["xfmg_media",6536],"xfmg_media-6535":["xfmg_media",6535],"xfmg_media-6534":["xfmg_media",6534],"xfmg_media-6533":["xfmg_media",6533],"xfmg_media-6532":["xfmg_media",6532],"xfmg_media-6531":["xfmg_media",6531],"xfmg_media-6530":["xfmg_media",6530],"xfmg_media-6529":["xfmg_media",6529],"xfmg_media-6528":["xfmg_media",6528],"xfmg_media-6527":["xfmg_media",6527],"xfmg_media-6526":["xfmg_media",6526],"xfmg_media-6525":["xfmg_media",6525],"xfmg_media-6524":["xfmg_media",6524],"xfmg_media-6523":["xfmg_media",6523],"xfmg_media-6522":["xfmg_media",6522],"xfmg_media-6521":["xfmg_media",6521],"xfmg_media-6519":["xfmg_media",6519]}, , 1716194885
Run Time: 0.000272
- 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