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 (20120, 20119, 20118, 19618, 19320, 19319, 19318, 19317, 19316, 19315, 19314, 19313, 19312, 19311, 19310, 19309, 19308, 19307, 19306, 19305, 19304, 19303, 19302, 19301, 19300, 19299, 19298, 19297, 19296, 19295, 19294, 19293, 19292, 19291, 19290, 19289, 19288, 19287, 19286, 19285, 19284, 19283, 19282, 19281, 19280, 19279, 19278, 19277, 19276, 19275, 19274, 19273, 19272, 19271, 19270, 19269, 19268, 19267, 19266, 19265, 19264, 19263, 19262, 19261, 19260, 19259, 19258, 19257, 19256, 19255, 19254, 19253, 19252, 19251, 18933, 18709, 18708, 18707, 18706, 18705, 18704, 18703, 18702, 18701, 18700, 18699, 18698, 18697, 18696, 18695, 18694, 18693, 18692, 18691, 18690, 18689, 18688, 18687, 18686, 18685, 18684, 18683, 18682, 18681, 18680, 18679, 18678, 18677, 18676, 18675, 18674, 18673, 18672, 18671, 18670, 18669, 18668, 18667, 18666, 18665, 18664, 18663, 18662, 18661, 18660, 18659, 18658, 18657, 18656, 18655, 18654, 18653, 18652, 18651, 18650, 18649, 18648, 18647, 18646, 18645, 18644, 18643, 18642, 18641, 18640, 11857, 10165, 10044, 7862, 6343))
Run Time: 0.224857
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_media_item | range | PRIMARY | PRIMARY | 4 | | 150 | 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: 1921, 0, 1715407897, {"xfmg_media-20120":["xfmg_media",20120],"xfmg_media-20119":["xfmg_media",20119],"xfmg_media-20118":["xfmg_media",20118],"xfmg_media-19618":["xfmg_media",19618],"xfmg_media-19320":["xfmg_media",19320],"xfmg_media-19319":["xfmg_media",19319],"xfmg_media-19318":["xfmg_media",19318],"xfmg_media-19317":["xfmg_media",19317],"xfmg_media-19316":["xfmg_media",19316],"xfmg_media-19315":["xfmg_media",19315],"xfmg_media-19314":["xfmg_media",19314],"xfmg_media-19313":["xfmg_media",19313],"xfmg_media-19312":["xfmg_media",19312],"xfmg_media-19311":["xfmg_media",19311],"xfmg_media-19310":["xfmg_media",19310],"xfmg_media-19309":["xfmg_media",19309],"xfmg_media-19308":["xfmg_media",19308],"xfmg_media-19307":["xfmg_media",19307],"xfmg_media-19306":["xfmg_media",19306],"xfmg_media-19305":["xfmg_media",19305],"xfmg_media-19304":["xfmg_media",19304],"xfmg_media-19303":["xfmg_media",19303],"xfmg_media-19302":["xfmg_media",19302],"xfmg_media-19301":["xfmg_media",19301],"xfmg_media-19300":["xfmg_media",19300],"xfmg_media-19299":["xfmg_media",19299],"xfmg_media-19298":["xfmg_media",19298],"xfmg_media-19297":["xfmg_media",19297],"xfmg_media-19296":["xfmg_media",19296],"xfmg_media-19295":["xfmg_media",19295],"xfmg_media-19294":["xfmg_media",19294],"xfmg_media-19293":["xfmg_media",19293],"xfmg_media-19292":["xfmg_media",19292],"xfmg_media-19291":["xfmg_media",19291],"xfmg_media-19290":["xfmg_media",19290],"xfmg_media-19289":["xfmg_media",19289],"xfmg_media-19288":["xfmg_media",19288],"xfmg_media-19287":["xfmg_media",19287],"xfmg_media-19286":["xfmg_media",19286],"xfmg_media-19285":["xfmg_media",19285],"xfmg_media-19284":["xfmg_media",19284],"xfmg_media-19283":["xfmg_media",19283],"xfmg_media-19282":["xfmg_media",19282],"xfmg_media-19281":["xfmg_media",19281],"xfmg_media-19280":["xfmg_media",19280],"xfmg_media-19279":["xfmg_media",19279],"xfmg_media-19278":["xfmg_media",19278],"xfmg_media-19277":["xfmg_media",19277],"xfmg_media-19276":["xfmg_media",19276],"xfmg_media-19275":["xfmg_media",19275],"xfmg_media-19274":["xfmg_media",19274],"xfmg_media-19273":["xfmg_media",19273],"xfmg_media-19272":["xfmg_media",19272],"xfmg_media-19271":["xfmg_media",19271],"xfmg_media-19270":["xfmg_media",19270],"xfmg_media-19269":["xfmg_media",19269],"xfmg_media-19268":["xfmg_media",19268],"xfmg_media-19267":["xfmg_media",19267],"xfmg_media-19266":["xfmg_media",19266],"xfmg_media-19265":["xfmg_media",19265],"xfmg_media-19264":["xfmg_media",19264],"xfmg_media-19263":["xfmg_media",19263],"xfmg_media-19262":["xfmg_media",19262],"xfmg_media-19261":["xfmg_media",19261],"xfmg_media-19260":["xfmg_media",19260],"xfmg_media-19259":["xfmg_media",19259],"xfmg_media-19258":["xfmg_media",19258],"xfmg_media-19257":["xfmg_media",19257],"xfmg_media-19256":["xfmg_media",19256],"xfmg_media-19255":["xfmg_media",19255],"xfmg_media-19254":["xfmg_media",19254],"xfmg_media-19253":["xfmg_media",19253],"xfmg_media-19252":["xfmg_media",19252],"xfmg_media-19251":["xfmg_media",19251],"xfmg_media-18933":["xfmg_media",18933],"xfmg_media-18709":["xfmg_media",18709],"xfmg_media-18708":["xfmg_media",18708],"xfmg_media-18707":["xfmg_media",18707],"xfmg_media-18706":["xfmg_media",18706],"xfmg_media-18705":["xfmg_media",18705],"xfmg_media-18704":["xfmg_media",18704],"xfmg_media-18703":["xfmg_media",18703],"xfmg_media-18702":["xfmg_media",18702],"xfmg_media-18701":["xfmg_media",18701],"xfmg_media-18700":["xfmg_media",18700],"xfmg_media-18699":["xfmg_media",18699],"xfmg_media-18698":["xfmg_media",18698],"xfmg_media-18697":["xfmg_media",18697],"xfmg_media-18696":["xfmg_media",18696],"xfmg_media-18695":["xfmg_media",18695],"xfmg_media-18694":["xfmg_media",18694],"xfmg_media-18693":["xfmg_media",18693],"xfmg_media-18692":["xfmg_media",18692],"xfmg_media-18691":["xfmg_media",18691],"xfmg_media-18690":["xfmg_media",18690],"xfmg_media-18689":["xfmg_media",18689],"xfmg_media-18688":["xfmg_media",18688],"xfmg_media-18687":["xfmg_media",18687],"xfmg_media-18686":["xfmg_media",18686],"xfmg_media-18685":["xfmg_media",18685],"xfmg_media-18684":["xfmg_media",18684],"xfmg_media-18683":["xfmg_media",18683],"xfmg_media-18682":["xfmg_media",18682],"xfmg_media-18681":["xfmg_media",18681],"xfmg_media-18680":["xfmg_media",18680],"thread-86274":["thread",86274],"xfmg_media-18679":["xfmg_media",18679],"xfmg_media-18678":["xfmg_media",18678],"xfmg_media-18677":["xfmg_media",18677],"xfmg_media-18676":["xfmg_media",18676],"xfmg_media-18675":["xfmg_media",18675],"xfmg_media-18674":["xfmg_media",18674],"xfmg_media-18673":["xfmg_media",18673],"xfmg_media-18672":["xfmg_media",18672],"xfmg_media-18671":["xfmg_media",18671],"xfmg_media-18670":["xfmg_media",18670],"xfmg_media-18669":["xfmg_media",18669],"xfmg_media-18668":["xfmg_media",18668],"xfmg_media-18667":["xfmg_media",18667],"xfmg_media-18666":["xfmg_media",18666],"xfmg_media-18665":["xfmg_media",18665],"xfmg_media-18664":["xfmg_media",18664],"xfmg_media-18663":["xfmg_media",18663],"xfmg_media-18662":["xfmg_media",18662],"xfmg_media-18661":["xfmg_media",18661],"xfmg_media-18660":["xfmg_media",18660],"xfmg_media-18659":["xfmg_media",18659],"xfmg_media-18658":["xfmg_media",18658],"xfmg_media-18657":["xfmg_media",18657],"xfmg_media-18656":["xfmg_media",18656],"xfmg_media-18655":["xfmg_media",18655],"xfmg_media-18654":["xfmg_media",18654],"xfmg_media-18653":["xfmg_media",18653],"xfmg_media-18652":["xfmg_media",18652],"xfmg_media-18651":["xfmg_media",18651],"xfmg_media-18650":["xfmg_media",18650],"xfmg_media-18649":["xfmg_media",18649],"xfmg_media-18648":["xfmg_media",18648],"xfmg_media-18647":["xfmg_media",18647],"xfmg_media-18646":["xfmg_media",18646],"xfmg_media-18645":["xfmg_media",18645],"xfmg_media-18644":["xfmg_media",18644],"xfmg_media-18643":["xfmg_media",18643],"xfmg_media-18642":["xfmg_media",18642],"xfmg_media-18641":["xfmg_media",18641],"xfmg_media-18640":["xfmg_media",18640],"thread-86221":["thread",86221],"xfmg_media-11857":["xfmg_media",11857],"xfmg_media-10165":["xfmg_media",10165],"xfmg_media-10044":["xfmg_media",10044],"xfmg_media-7862":["xfmg_media",7862],"xfmg_media-6343":["xfmg_media",6343]}, , 1715404297
Run Time: 0.000174
- 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