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 (20807, 20750, 20749, 20690, 20689, 20688, 20648, 20639, 20638, 20637, 20636, 20635, 20634, 20633, 20628, 20567, 20566, 20552, 20523, 20499, 20467, 20466, 20465, 20464, 20463, 20343, 20333, 20332, 20193, 20192, 20183, 20182, 20181, 20125, 20124, 20123, 20122, 20121, 20120, 20119, 20118, 20108, 19968, 19962, 19963, 19965, 19964, 19961, 19960, 19959, 19957, 19956, 19955, 19930, 19929, 19928, 19927, 19926, 19925, 19924, 19923, 19922, 19920, 19919, 19918, 19917, 19916, 19915, 19914, 19913, 19912, 19911, 19910, 19908, 19907, 19904, 19903, 19902, 19901, 19900, 19899, 19898, 19897, 19896, 19895, 19894, 19893, 19892, 19891, 19890, 19889, 19888, 19887, 19886, 19885, 19884, 19883, 19882, 19881, 19880, 19879, 19878, 19877, 19876, 19875, 19874, 19873, 19872, 19871, 19870, 19869, 19868, 19867, 19866, 19865, 19864, 19863, 19862, 19861, 19860, 19859, 19858, 19857, 19856, 19855, 19854, 19853, 19852, 19851, 19850, 19849, 19848, 19847, 19846, 19845, 19844, 19843, 19842, 19841, 19840, 19839, 19838, 19837, 19836, 19835, 19834, 19833, 19832, 19831, 19830, 19829, 19828, 19827, 19826, 19825, 19824, 19823, 19822, 19821, 19820, 19819, 19818, 19817, 19816, 19815, 19814, 19813, 19812, 19811, 19810, 19809, 19808, 19807, 19806, 19805, 19804, 19803, 19802, 19801, 19800, 19799, 19798, 19797, 19796, 19795, 19794, 19793, 19792, 19791, 19790, 19789, 19788, 19787, 19786, 19785, 19784, 19783, 19782, 19781, 19780))
Run Time: 0.005519
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: 28, 0, 1715362320, {"xfmg_media-20807":["xfmg_media",20807],"xfmg_media-20750":["xfmg_media",20750],"xfmg_media-20749":["xfmg_media",20749],"xfmg_media-20690":["xfmg_media",20690],"xfmg_media-20689":["xfmg_media",20689],"xfmg_media-20688":["xfmg_media",20688],"xfmg_media-20648":["xfmg_media",20648],"xfmg_media-20639":["xfmg_media",20639],"xfmg_media-20638":["xfmg_media",20638],"xfmg_media-20637":["xfmg_media",20637],"xfmg_media-20636":["xfmg_media",20636],"xfmg_media-20635":["xfmg_media",20635],"xfmg_media-20634":["xfmg_media",20634],"xfmg_media-20633":["xfmg_media",20633],"xfmg_media-20567":["xfmg_media",20567],"xfmg_media-20566":["xfmg_media",20566],"xfmg_media-20552":["xfmg_media",20552],"xfmg_media-20523":["xfmg_media",20523],"xfmg_media-20499":["xfmg_media",20499],"xfmg_media-20467":["xfmg_media",20467],"xfmg_media-20466":["xfmg_media",20466],"xfmg_media-20465":["xfmg_media",20465],"xfmg_media-20464":["xfmg_media",20464],"xfmg_media-20463":["xfmg_media",20463],"xfmg_media-20343":["xfmg_media",20343],"xfmg_media-20333":["xfmg_media",20333],"xfmg_media-20332":["xfmg_media",20332],"xfmg_media-20193":["xfmg_media",20193],"xfmg_media-20192":["xfmg_media",20192],"xfmg_media-20183":["xfmg_media",20183],"xfmg_media-20182":["xfmg_media",20182],"xfmg_media-20181":["xfmg_media",20181],"xfmg_media-20125":["xfmg_media",20125],"xfmg_media-20124":["xfmg_media",20124],"xfmg_media-20123":["xfmg_media",20123],"xfmg_media-20122":["xfmg_media",20122],"xfmg_media-20121":["xfmg_media",20121],"xfmg_media-20120":["xfmg_media",20120],"xfmg_media-20119":["xfmg_media",20119],"xfmg_media-20118":["xfmg_media",20118],"xfmg_media-20108":["xfmg_media",20108],"xfmg_media-19968":["xfmg_media",19968],"xfmg_media-19962":["xfmg_media",19962],"xfmg_media-19963":["xfmg_media",19963],"xfmg_media-19965":["xfmg_media",19965],"xfmg_media-19964":["xfmg_media",19964],"xfmg_media-19961":["xfmg_media",19961],"xfmg_media-19960":["xfmg_media",19960],"xfmg_media-19959":["xfmg_media",19959],"xfmg_media-19957":["xfmg_media",19957],"xfmg_media-19956":["xfmg_media",19956],"xfmg_media-19955":["xfmg_media",19955],"xfmg_media-19930":["xfmg_media",19930],"xfmg_media-19929":["xfmg_media",19929],"xfmg_media-19928":["xfmg_media",19928],"xfmg_media-19927":["xfmg_media",19927],"xfmg_media-19926":["xfmg_media",19926],"xfmg_media-19925":["xfmg_media",19925],"xfmg_media-19924":["xfmg_media",19924],"xfmg_media-19923":["xfmg_media",19923],"xfmg_media-19922":["xfmg_media",19922],"xfmg_media-19920":["xfmg_media",19920],"xfmg_media-19919":["xfmg_media",19919],"xfmg_media-19918":["xfmg_media",19918],"xfmg_media-19917":["xfmg_media",19917],"xfmg_media-19916":["xfmg_media",19916],"xfmg_media-19915":["xfmg_media",19915],"xfmg_media-19914":["xfmg_media",19914],"xfmg_media-19913":["xfmg_media",19913],"xfmg_media-19912":["xfmg_media",19912],"xfmg_media-19911":["xfmg_media",19911],"xfmg_media-19910":["xfmg_media",19910],"xfmg_media-19908":["xfmg_media",19908],"xfmg_media-19907":["xfmg_media",19907],"xfmg_media-19904":["xfmg_media",19904],"xfmg_media-19903":["xfmg_media",19903],"xfmg_media-19902":["xfmg_media",19902],"xfmg_media-19901":["xfmg_media",19901],"xfmg_media-19900":["xfmg_media",19900],"xfmg_media-19899":["xfmg_media",19899],"xfmg_media-19898":["xfmg_media",19898],"xfmg_media-19897":["xfmg_media",19897],"xfmg_media-19896":["xfmg_media",19896],"xfmg_media-19895":["xfmg_media",19895],"xfmg_media-19894":["xfmg_media",19894],"xfmg_media-19893":["xfmg_media",19893],"xfmg_media-19892":["xfmg_media",19892],"xfmg_media-19891":["xfmg_media",19891],"xfmg_media-19890":["xfmg_media",19890],"xfmg_media-19889":["xfmg_media",19889],"xfmg_media-19888":["xfmg_media",19888],"xfmg_media-19887":["xfmg_media",19887],"xfmg_media-19886":["xfmg_media",19886],"xfmg_media-19885":["xfmg_media",19885],"xfmg_media-19884":["xfmg_media",19884],"xfmg_media-19883":["xfmg_media",19883],"xfmg_media-19882":["xfmg_media",19882],"xfmg_media-19881":["xfmg_media",19881],"xfmg_media-19880":["xfmg_media",19880],"xfmg_media-19879":["xfmg_media",19879],"xfmg_media-19878":["xfmg_media",19878],"xfmg_media-19877":["xfmg_media",19877],"xfmg_media-19876":["xfmg_media",19876],"xfmg_media-19875":["xfmg_media",19875],"xfmg_media-19874":["xfmg_media",19874],"xfmg_media-19873":["xfmg_media",19873],"xfmg_media-19872":["xfmg_media",19872],"xfmg_media-19871":["xfmg_media",19871],"xfmg_media-19870":["xfmg_media",19870],"xfmg_media-19869":["xfmg_media",19869],"xfmg_media-19868":["xfmg_media",19868],"xfmg_media-19867":["xfmg_media",19867],"xfmg_media-19866":["xfmg_media",19866],"xfmg_media-19865":["xfmg_media",19865],"xfmg_media-19864":["xfmg_media",19864],"xfmg_media-19863":["xfmg_media",19863],"xfmg_media-19862":["xfmg_media",19862],"xfmg_media-19861":["xfmg_media",19861],"xfmg_media-19860":["xfmg_media",19860],"xfmg_media-19859":["xfmg_media",19859],"xfmg_media-19858":["xfmg_media",19858],"xfmg_media-19857":["xfmg_media",19857],"xfmg_media-19856":["xfmg_media",19856],"xfmg_media-19855":["xfmg_media",19855],"xfmg_media-19854":["xfmg_media",19854],"xfmg_media-19853":["xfmg_media",19853],"xfmg_media-19852":["xfmg_media",19852],"xfmg_media-19851":["xfmg_media",19851],"xfmg_media-19850":["xfmg_media",19850],"xfmg_media-19849":["xfmg_media",19849],"xfmg_media-19848":["xfmg_media",19848],"xfmg_media-19847":["xfmg_media",19847],"xfmg_media-19846":["xfmg_media",19846],"xfmg_media-19845":["xfmg_media",19845],"xfmg_media-19844":["xfmg_media",19844],"xfmg_media-19843":["xfmg_media",19843],"xfmg_media-19842":["xfmg_media",19842],"xfmg_media-19841":["xfmg_media",19841],"xfmg_media-19840":["xfmg_media",19840],"xfmg_media-19839":["xfmg_media",19839],"xfmg_media-19838":["xfmg_media",19838],"xfmg_media-19837":["xfmg_media",19837],"xfmg_media-19836":["xfmg_media",19836],"xfmg_media-19835":["xfmg_media",19835],"xfmg_media-19834":["xfmg_media",19834],"xfmg_media-19833":["xfmg_media",19833],"xfmg_media-19832":["xfmg_media",19832],"xfmg_media-19831":["xfmg_media",19831],"xfmg_media-19830":["xfmg_media",19830],"xfmg_media-19829":["xfmg_media",19829],"xfmg_media-19828":["xfmg_media",19828],"xfmg_media-19827":["xfmg_media",19827],"xfmg_media-19826":["xfmg_media",19826],"xfmg_media-19825":["xfmg_media",19825],"xfmg_media-19824":["xfmg_media",19824],"xfmg_media-19823":["xfmg_media",19823],"xfmg_media-19822":["xfmg_media",19822],"xfmg_media-19821":["xfmg_media",19821],"xfmg_media-19820":["xfmg_media",19820],"xfmg_media-19819":["xfmg_media",19819],"xfmg_media-19818":["xfmg_media",19818],"xfmg_media-19817":["xfmg_media",19817],"xfmg_media-19816":["xfmg_media",19816],"xfmg_media-19815":["xfmg_media",19815],"xfmg_media-19814":["xfmg_media",19814],"xfmg_media-19813":["xfmg_media",19813],"xfmg_media-19812":["xfmg_media",19812],"xfmg_media-19811":["xfmg_media",19811],"xfmg_media-19810":["xfmg_media",19810],"xfmg_media-19809":["xfmg_media",19809],"xfmg_media-19808":["xfmg_media",19808],"xfmg_media-19807":["xfmg_media",19807],"xfmg_media-19806":["xfmg_media",19806],"xfmg_media-19805":["xfmg_media",19805],"xfmg_media-19804":["xfmg_media",19804],"xfmg_media-19803":["xfmg_media",19803],"xfmg_media-19802":["xfmg_media",19802],"xfmg_media-19801":["xfmg_media",19801],"xfmg_media-19800":["xfmg_media",19800],"xfmg_media-19799":["xfmg_media",19799],"xfmg_media-19798":["xfmg_media",19798],"xfmg_media-19797":["xfmg_media",19797],"xfmg_media-19796":["xfmg_media",19796],"xfmg_media-19795":["xfmg_media",19795],"xfmg_media-19794":["xfmg_media",19794],"xfmg_media-19793":["xfmg_media",19793],"xfmg_media-19792":["xfmg_media",19792],"xfmg_media-19791":["xfmg_media",19791],"xfmg_media-19790":["xfmg_media",19790],"xfmg_media-19789":["xfmg_media",19789],"xfmg_media-19788":["xfmg_media",19788],"xfmg_media-19787":["xfmg_media",19787],"xfmg_media-19786":["xfmg_media",19786],"xfmg_media-19785":["xfmg_media",19785],"xfmg_media-19784":["xfmg_media",19784],"xfmg_media-19783":["xfmg_media",19783],"xfmg_media-19782":["xfmg_media",19782],"xfmg_media-19781":["xfmg_media",19781],"xfmg_media-19780":["xfmg_media",19780]}, , 1715358720
Run Time: 0.000249
- 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