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 (14815, 14814, 14788, 14787, 9874, 9826, 9825, 9824, 9823, 9822, 9821, 9820, 9819, 9818, 9817, 9816, 9815, 9814, 9813, 9812, 9811, 9810, 9809, 9808, 9800, 9799, 9798, 9797, 9796, 9795, 9794, 9793, 9792, 9791, 9790, 9789, 9788, 9787, 9786, 9784, 9783, 9782, 9780, 9779, 9778, 9777, 9776, 9775, 9774, 9773, 9772, 9771, 9770, 9769, 9754, 9753, 9752, 9751, 9750, 9749, 9748, 9747, 9746, 9745, 9744, 9743, 9742, 9741, 9740, 9739, 9738, 9737, 9735, 9734, 9733, 9732, 9731, 9730, 9725, 9724, 9723, 9722, 9721, 9720, 9719, 9718, 9717, 9716, 9715, 9711, 9710, 9709, 9708, 9707, 9706, 9705, 9704, 9703, 9702, 9701, 9700, 9699, 9698, 9697, 9696, 9695, 9694, 9693, 9692, 9691, 9690, 9689, 9688, 9687, 9686, 9685, 9684, 9683, 9682, 9681, 9680, 9679, 9678, 9677, 9676, 9675, 9658, 9657, 9656, 9655, 9614, 9610, 9609, 9608, 9606, 9605, 9604, 9603, 9602, 9601, 9600, 9599, 9598, 9597, 9595, 9594, 9593, 9592, 9591, 9590, 9589, 9587, 9586, 9585, 9583, 9582, 9581, 9563, 9562, 9561, 9560, 9559, 9558, 9557, 9556, 9548, 9528, 9527, 9526, 9525, 9524, 9523, 9522, 9521, 9520, 9519, 9518, 9517, 9516, 9515, 9514, 9513, 9512, 9511, 9510, 9509, 9508, 9507, 9506, 9491, 9490, 9489, 9488, 9487, 9486, 9485, 9484, 9483))
Run Time: 0.005550
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_media_item | range | PRIMARY | PRIMARY | 4 | | 198 | 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: 2503, 0, 1715504705, {"xfmg_media-14815":["xfmg_media",14815],"xfmg_media-14814":["xfmg_media",14814],"xfmg_media-14788":["xfmg_media",14788],"xfmg_media-14787":["xfmg_media",14787],"xfmg_media-9826":["xfmg_media",9826],"xfmg_media-9825":["xfmg_media",9825],"xfmg_media-9824":["xfmg_media",9824],"xfmg_media-9823":["xfmg_media",9823],"xfmg_media-9822":["xfmg_media",9822],"xfmg_media-9821":["xfmg_media",9821],"xfmg_media-9820":["xfmg_media",9820],"xfmg_media-9819":["xfmg_media",9819],"xfmg_media-9818":["xfmg_media",9818],"xfmg_media-9817":["xfmg_media",9817],"xfmg_media-9816":["xfmg_media",9816],"xfmg_media-9815":["xfmg_media",9815],"xfmg_media-9814":["xfmg_media",9814],"xfmg_media-9813":["xfmg_media",9813],"xfmg_media-9812":["xfmg_media",9812],"xfmg_media-9811":["xfmg_media",9811],"xfmg_media-9810":["xfmg_media",9810],"xfmg_media-9809":["xfmg_media",9809],"xfmg_media-9808":["xfmg_media",9808],"xfmg_media-9800":["xfmg_media",9800],"xfmg_media-9799":["xfmg_media",9799],"xfmg_media-9798":["xfmg_media",9798],"xfmg_media-9797":["xfmg_media",9797],"xfmg_media-9796":["xfmg_media",9796],"xfmg_media-9795":["xfmg_media",9795],"xfmg_media-9794":["xfmg_media",9794],"xfmg_media-9793":["xfmg_media",9793],"xfmg_media-9792":["xfmg_media",9792],"xfmg_media-9791":["xfmg_media",9791],"xfmg_media-9790":["xfmg_media",9790],"xfmg_media-9789":["xfmg_media",9789],"xfmg_media-9788":["xfmg_media",9788],"xfmg_media-9787":["xfmg_media",9787],"xfmg_media-9786":["xfmg_media",9786],"xfmg_media-9784":["xfmg_media",9784],"xfmg_media-9783":["xfmg_media",9783],"xfmg_media-9782":["xfmg_media",9782],"xfmg_media-9780":["xfmg_media",9780],"xfmg_media-9779":["xfmg_media",9779],"xfmg_media-9778":["xfmg_media",9778],"xfmg_media-9777":["xfmg_media",9777],"xfmg_media-9776":["xfmg_media",9776],"xfmg_media-9775":["xfmg_media",9775],"xfmg_media-9774":["xfmg_media",9774],"xfmg_media-9773":["xfmg_media",9773],"xfmg_media-9772":["xfmg_media",9772],"xfmg_media-9771":["xfmg_media",9771],"xfmg_media-9770":["xfmg_media",9770],"xfmg_media-9769":["xfmg_media",9769],"xfmg_media-9754":["xfmg_media",9754],"xfmg_media-9753":["xfmg_media",9753],"xfmg_media-9752":["xfmg_media",9752],"xfmg_media-9751":["xfmg_media",9751],"xfmg_media-9750":["xfmg_media",9750],"xfmg_media-9749":["xfmg_media",9749],"xfmg_media-9748":["xfmg_media",9748],"xfmg_media-9747":["xfmg_media",9747],"xfmg_media-9746":["xfmg_media",9746],"xfmg_media-9745":["xfmg_media",9745],"xfmg_media-9744":["xfmg_media",9744],"xfmg_media-9743":["xfmg_media",9743],"xfmg_media-9742":["xfmg_media",9742],"xfmg_media-9741":["xfmg_media",9741],"xfmg_media-9740":["xfmg_media",9740],"xfmg_media-9739":["xfmg_media",9739],"xfmg_media-9738":["xfmg_media",9738],"xfmg_media-9737":["xfmg_media",9737],"xfmg_media-9735":["xfmg_media",9735],"xfmg_media-9734":["xfmg_media",9734],"xfmg_media-9733":["xfmg_media",9733],"xfmg_media-9732":["xfmg_media",9732],"xfmg_media-9731":["xfmg_media",9731],"xfmg_media-9730":["xfmg_media",9730],"xfmg_media-9725":["xfmg_media",9725],"xfmg_media-9724":["xfmg_media",9724],"xfmg_media-9723":["xfmg_media",9723],"xfmg_media-9722":["xfmg_media",9722],"xfmg_media-9721":["xfmg_media",9721],"xfmg_media-9720":["xfmg_media",9720],"xfmg_media-9719":["xfmg_media",9719],"xfmg_media-9718":["xfmg_media",9718],"xfmg_media-9717":["xfmg_media",9717],"xfmg_media-9716":["xfmg_media",9716],"xfmg_media-9715":["xfmg_media",9715],"xfmg_media-9711":["xfmg_media",9711],"xfmg_media-9710":["xfmg_media",9710],"xfmg_media-9709":["xfmg_media",9709],"xfmg_media-9708":["xfmg_media",9708],"xfmg_media-9707":["xfmg_media",9707],"xfmg_media-9706":["xfmg_media",9706],"xfmg_media-9705":["xfmg_media",9705],"xfmg_media-9704":["xfmg_media",9704],"xfmg_media-9703":["xfmg_media",9703],"xfmg_media-9702":["xfmg_media",9702],"xfmg_media-9701":["xfmg_media",9701],"xfmg_media-9700":["xfmg_media",9700],"xfmg_media-9699":["xfmg_media",9699],"xfmg_media-9698":["xfmg_media",9698],"xfmg_media-9697":["xfmg_media",9697],"xfmg_media-9696":["xfmg_media",9696],"xfmg_media-9695":["xfmg_media",9695],"xfmg_media-9694":["xfmg_media",9694],"xfmg_media-9693":["xfmg_media",9693],"xfmg_media-9692":["xfmg_media",9692],"xfmg_media-9691":["xfmg_media",9691],"xfmg_media-9690":["xfmg_media",9690],"xfmg_media-9689":["xfmg_media",9689],"xfmg_media-9688":["xfmg_media",9688],"xfmg_media-9687":["xfmg_media",9687],"xfmg_media-9686":["xfmg_media",9686],"xfmg_media-9685":["xfmg_media",9685],"xfmg_media-9684":["xfmg_media",9684],"xfmg_media-9683":["xfmg_media",9683],"xfmg_media-9682":["xfmg_media",9682],"xfmg_media-9681":["xfmg_media",9681],"xfmg_media-9680":["xfmg_media",9680],"xfmg_media-9679":["xfmg_media",9679],"xfmg_media-9678":["xfmg_media",9678],"xfmg_media-9677":["xfmg_media",9677],"xfmg_media-9676":["xfmg_media",9676],"xfmg_media-9675":["xfmg_media",9675],"xfmg_media-9658":["xfmg_media",9658],"xfmg_media-9657":["xfmg_media",9657],"xfmg_media-9656":["xfmg_media",9656],"xfmg_media-9655":["xfmg_media",9655],"xfmg_media-9614":["xfmg_media",9614],"xfmg_media-9610":["xfmg_media",9610],"xfmg_media-9609":["xfmg_media",9609],"xfmg_media-9608":["xfmg_media",9608],"xfmg_media-9606":["xfmg_media",9606],"xfmg_media-9605":["xfmg_media",9605],"xfmg_media-9604":["xfmg_media",9604],"xfmg_media-9603":["xfmg_media",9603],"xfmg_media-9602":["xfmg_media",9602],"xfmg_media-9601":["xfmg_media",9601],"xfmg_media-9600":["xfmg_media",9600],"xfmg_media-9599":["xfmg_media",9599],"xfmg_media-9598":["xfmg_media",9598],"xfmg_media-9597":["xfmg_media",9597],"xfmg_media-9595":["xfmg_media",9595],"xfmg_media-9594":["xfmg_media",9594],"xfmg_media-9593":["xfmg_media",9593],"xfmg_media-9592":["xfmg_media",9592],"xfmg_media-9591":["xfmg_media",9591],"xfmg_media-9590":["xfmg_media",9590],"xfmg_media-9589":["xfmg_media",9589],"xfmg_media-9587":["xfmg_media",9587],"xfmg_media-9586":["xfmg_media",9586],"xfmg_media-9585":["xfmg_media",9585],"xfmg_media-9583":["xfmg_media",9583],"xfmg_media-9582":["xfmg_media",9582],"xfmg_media-9581":["xfmg_media",9581],"xfmg_media-9563":["xfmg_media",9563],"xfmg_media-9562":["xfmg_media",9562],"xfmg_media-9561":["xfmg_media",9561],"xfmg_media-9560":["xfmg_media",9560],"xfmg_media-9559":["xfmg_media",9559],"xfmg_media-9558":["xfmg_media",9558],"xfmg_media-9557":["xfmg_media",9557],"xfmg_media-9556":["xfmg_media",9556],"xfmg_media-9548":["xfmg_media",9548],"xfmg_media-9528":["xfmg_media",9528],"xfmg_media-9527":["xfmg_media",9527],"xfmg_media-9526":["xfmg_media",9526],"xfmg_media-9525":["xfmg_media",9525],"xfmg_media-9524":["xfmg_media",9524],"xfmg_media-9523":["xfmg_media",9523],"xfmg_media-9522":["xfmg_media",9522],"xfmg_media-9521":["xfmg_media",9521],"xfmg_media-9520":["xfmg_media",9520],"xfmg_media-9519":["xfmg_media",9519],"xfmg_media-9518":["xfmg_media",9518],"xfmg_media-9517":["xfmg_media",9517],"xfmg_media-9516":["xfmg_media",9516],"xfmg_media-9515":["xfmg_media",9515],"xfmg_media-9514":["xfmg_media",9514],"xfmg_media-9513":["xfmg_media",9513],"xfmg_media-9512":["xfmg_media",9512],"xfmg_media-9511":["xfmg_media",9511],"xfmg_media-9510":["xfmg_media",9510],"xfmg_media-9509":["xfmg_media",9509],"xfmg_media-9508":["xfmg_media",9508],"xfmg_media-9507":["xfmg_media",9507],"xfmg_media-9506":["xfmg_media",9506],"xfmg_media-9491":["xfmg_media",9491],"xfmg_media-9490":["xfmg_media",9490],"xfmg_media-9489":["xfmg_media",9489],"xfmg_media-9488":["xfmg_media",9488],"xfmg_media-9487":["xfmg_media",9487],"xfmg_media-9486":["xfmg_media",9486],"xfmg_media-9485":["xfmg_media",9485],"xfmg_media-9484":["xfmg_media",9484],"xfmg_media-9483":["xfmg_media",9483]}, , 1715501105
Run Time: 0.000219
- 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