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 (20793, 20720, 20719, 20718, 20717, 20527, 20504, 19619, 19076, 18473, 18472, 18471, 18470, 18196, 18053, 18052, 17659, 17428, 17427, 17426, 17425, 17423, 17422, 17421, 17420, 17419, 17418, 17417, 17416, 17056, 17055, 17054, 17053, 17052, 17051, 17050, 17049, 17048, 17047, 17046, 17045, 17044, 17043, 17042, 16998, 16501, 16500, 16499, 16498, 16216, 16215, 15866, 15865, 15864, 15863, 15026, 14957, 14644, 14643, 14642, 14445, 14444, 14247, 14246, 14245, 14215, 14056, 13933, 13826, 13825, 13813, 13808, 13761, 12823, 12822, 12821, 12787, 12528, 12318, 12071, 12070, 12069, 12068, 12067, 12066, 12065, 12064, 11828, 11827, 11791, 11790, 11789, 11788, 11787, 11786, 11785, 11784, 11783, 11782, 11723, 11722, 11721, 11701, 11523, 11522, 11521, 11520, 11519, 11518, 11497, 11369, 11359, 11358, 11357, 11323, 11247, 11216, 11215, 11200, 11199, 11198, 11197, 11196, 11178, 10516, 10515, 10514, 10504, 10503, 10501, 10489, 10488, 10422, 10421, 10420, 10419, 10417, 10416, 10393, 10392, 10391, 10390, 10363, 10362, 10361, 10360, 10359, 10358, 10357, 10356, 10355, 10354, 10347, 10346, 10345, 10340, 10234, 10233, 10232, 10188, 10183, 10182, 10181, 10180, 10179, 10009, 10008, 10007, 10006, 10005, 9983, 9982, 9961, 9960, 9959, 9931, 9930, 9915, 9914, 9901, 9850, 9807, 9712, 9538, 9537, 9536, 9535, 9534, 9472, 9449, 8601, 8385, 8384))
Run Time: 0.005689
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_media_item | range | PRIMARY | PRIMARY | 4 | | 193 | 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: 695, 0, 1716859332, {"xfmg_media-20793":["xfmg_media",20793],"xfmg_media-20720":["xfmg_media",20720],"xfmg_media-20719":["xfmg_media",20719],"xfmg_media-20718":["xfmg_media",20718],"xfmg_media-20717":["xfmg_media",20717],"xfmg_media-20527":["xfmg_media",20527],"xfmg_media-20504":["xfmg_media",20504],"xfmg_media-19619":["xfmg_media",19619],"xfmg_media-19076":["xfmg_media",19076],"xfmg_media-18473":["xfmg_media",18473],"xfmg_media-18472":["xfmg_media",18472],"xfmg_media-18471":["xfmg_media",18471],"xfmg_media-18470":["xfmg_media",18470],"xfmg_media-18196":["xfmg_media",18196],"xfmg_media-18053":["xfmg_media",18053],"xfmg_media-18052":["xfmg_media",18052],"xfmg_media-17659":["xfmg_media",17659],"xfmg_media-17428":["xfmg_media",17428],"xfmg_media-17427":["xfmg_media",17427],"xfmg_media-17426":["xfmg_media",17426],"xfmg_media-17425":["xfmg_media",17425],"xfmg_media-17423":["xfmg_media",17423],"xfmg_media-17422":["xfmg_media",17422],"xfmg_media-17421":["xfmg_media",17421],"xfmg_media-17420":["xfmg_media",17420],"xfmg_media-17419":["xfmg_media",17419],"xfmg_media-17418":["xfmg_media",17418],"xfmg_media-17417":["xfmg_media",17417],"xfmg_media-17416":["xfmg_media",17416],"xfmg_media-17056":["xfmg_media",17056],"xfmg_media-17055":["xfmg_media",17055],"xfmg_media-17054":["xfmg_media",17054],"xfmg_media-17053":["xfmg_media",17053],"xfmg_media-17052":["xfmg_media",17052],"xfmg_media-17051":["xfmg_media",17051],"xfmg_media-17050":["xfmg_media",17050],"xfmg_media-17049":["xfmg_media",17049],"xfmg_media-17048":["xfmg_media",17048],"xfmg_media-17047":["xfmg_media",17047],"xfmg_media-17046":["xfmg_media",17046],"xfmg_media-17045":["xfmg_media",17045],"xfmg_media-17044":["xfmg_media",17044],"xfmg_media-17043":["xfmg_media",17043],"xfmg_media-17042":["xfmg_media",17042],"xfmg_media-16998":["xfmg_media",16998],"thread-86021":["thread",86021],"xfmg_media-16501":["xfmg_media",16501],"xfmg_media-16500":["xfmg_media",16500],"xfmg_media-16499":["xfmg_media",16499],"xfmg_media-16498":["xfmg_media",16498],"xfmg_media-16216":["xfmg_media",16216],"xfmg_media-16215":["xfmg_media",16215],"xfmg_media-15866":["xfmg_media",15866],"xfmg_media-15865":["xfmg_media",15865],"xfmg_media-15864":["xfmg_media",15864],"xfmg_media-15863":["xfmg_media",15863],"thread-85861":["thread",85861],"xfmg_media-15026":["xfmg_media",15026],"xfmg_media-14957":["xfmg_media",14957],"xfmg_media-14644":["xfmg_media",14644],"xfmg_media-14643":["xfmg_media",14643],"xfmg_media-14642":["xfmg_media",14642],"xfmg_media-14445":["xfmg_media",14445],"xfmg_media-14444":["xfmg_media",14444],"xfmg_media-14247":["xfmg_media",14247],"xfmg_media-14246":["xfmg_media",14246],"xfmg_media-14245":["xfmg_media",14245],"xfmg_media-14215":["xfmg_media",14215],"xfmg_media-14056":["xfmg_media",14056],"thread-85687":["thread",85687],"xfmg_media-13933":["xfmg_media",13933],"xfmg_media-13826":["xfmg_media",13826],"xfmg_media-13825":["xfmg_media",13825],"xfmg_media-13813":["xfmg_media",13813],"xfmg_media-13808":["xfmg_media",13808],"xfmg_media-13761":["xfmg_media",13761],"thread-85581":["thread",85581],"xfmg_media-12823":["xfmg_media",12823],"xfmg_media-12822":["xfmg_media",12822],"xfmg_media-12821":["xfmg_media",12821],"xfmg_media-12787":["xfmg_media",12787],"xfmg_media-12528":["xfmg_media",12528],"xfmg_media-12318":["xfmg_media",12318],"xfmg_media-12071":["xfmg_media",12071],"xfmg_media-12070":["xfmg_media",12070],"xfmg_media-12069":["xfmg_media",12069],"xfmg_media-12068":["xfmg_media",12068],"xfmg_media-12067":["xfmg_media",12067],"xfmg_media-12066":["xfmg_media",12066],"xfmg_media-12065":["xfmg_media",12065],"xfmg_media-12064":["xfmg_media",12064],"xfmg_media-11828":["xfmg_media",11828],"xfmg_media-11827":["xfmg_media",11827],"xfmg_media-11791":["xfmg_media",11791],"xfmg_media-11790":["xfmg_media",11790],"xfmg_media-11789":["xfmg_media",11789],"xfmg_media-11788":["xfmg_media",11788],"xfmg_media-11787":["xfmg_media",11787],"xfmg_media-11786":["xfmg_media",11786],"xfmg_media-11785":["xfmg_media",11785],"xfmg_media-11784":["xfmg_media",11784],"xfmg_media-11783":["xfmg_media",11783],"xfmg_media-11782":["xfmg_media",11782],"xfmg_media-11723":["xfmg_media",11723],"xfmg_media-11722":["xfmg_media",11722],"xfmg_media-11721":["xfmg_media",11721],"xfmg_media-11701":["xfmg_media",11701],"xfmg_media-11523":["xfmg_media",11523],"xfmg_media-11522":["xfmg_media",11522],"xfmg_media-11521":["xfmg_media",11521],"xfmg_media-11520":["xfmg_media",11520],"xfmg_media-11519":["xfmg_media",11519],"xfmg_media-11518":["xfmg_media",11518],"xfmg_media-11497":["xfmg_media",11497],"xfmg_media-11369":["xfmg_media",11369],"xfmg_media-11359":["xfmg_media",11359],"xfmg_media-11358":["xfmg_media",11358],"xfmg_media-11357":["xfmg_media",11357],"xfmg_media-11323":["xfmg_media",11323],"xfmg_media-11247":["xfmg_media",11247],"xfmg_media-11216":["xfmg_media",11216],"xfmg_media-11215":["xfmg_media",11215],"xfmg_media-11200":["xfmg_media",11200],"xfmg_media-11199":["xfmg_media",11199],"xfmg_media-11198":["xfmg_media",11198],"xfmg_media-11197":["xfmg_media",11197],"xfmg_media-11196":["xfmg_media",11196],"xfmg_media-11178":["xfmg_media",11178],"xfmg_media-10516":["xfmg_media",10516],"xfmg_media-10515":["xfmg_media",10515],"xfmg_media-10514":["xfmg_media",10514],"xfmg_media-10504":["xfmg_media",10504],"xfmg_media-10503":["xfmg_media",10503],"xfmg_media-10501":["xfmg_media",10501],"xfmg_media-10489":["xfmg_media",10489],"xfmg_media-10488":["xfmg_media",10488],"xfmg_media-10422":["xfmg_media",10422],"xfmg_media-10421":["xfmg_media",10421],"xfmg_media-10420":["xfmg_media",10420],"xfmg_media-10419":["xfmg_media",10419],"xfmg_media-10417":["xfmg_media",10417],"xfmg_media-10416":["xfmg_media",10416],"xfmg_media-10393":["xfmg_media",10393],"xfmg_media-10392":["xfmg_media",10392],"xfmg_media-10391":["xfmg_media",10391],"xfmg_media-10390":["xfmg_media",10390],"xfmg_media-10363":["xfmg_media",10363],"xfmg_media-10362":["xfmg_media",10362],"xfmg_media-10361":["xfmg_media",10361],"xfmg_media-10360":["xfmg_media",10360],"xfmg_media-10359":["xfmg_media",10359],"xfmg_media-10358":["xfmg_media",10358],"xfmg_media-10357":["xfmg_media",10357],"xfmg_media-10356":["xfmg_media",10356],"xfmg_media-10355":["xfmg_media",10355],"xfmg_media-10354":["xfmg_media",10354],"xfmg_media-10347":["xfmg_media",10347],"xfmg_media-10346":["xfmg_media",10346],"xfmg_media-10345":["xfmg_media",10345],"xfmg_media-10340":["xfmg_media",10340],"xfmg_media-10234":["xfmg_media",10234],"xfmg_media-10233":["xfmg_media",10233],"xfmg_media-10232":["xfmg_media",10232],"xfmg_media-10188":["xfmg_media",10188],"xfmg_media-10183":["xfmg_media",10183],"xfmg_media-10182":["xfmg_media",10182],"xfmg_media-10181":["xfmg_media",10181],"xfmg_media-10180":["xfmg_media",10180],"xfmg_media-10179":["xfmg_media",10179],"xfmg_media-10009":["xfmg_media",10009],"xfmg_media-10008":["xfmg_media",10008],"xfmg_media-10007":["xfmg_media",10007],"xfmg_media-10006":["xfmg_media",10006],"xfmg_media-10005":["xfmg_media",10005],"xfmg_media-9983":["xfmg_media",9983],"xfmg_media-9982":["xfmg_media",9982],"xfmg_media-9961":["xfmg_media",9961],"xfmg_media-9960":["xfmg_media",9960],"xfmg_media-9959":["xfmg_media",9959],"xfmg_media-9931":["xfmg_media",9931],"xfmg_media-9930":["xfmg_media",9930],"xfmg_media-9915":["xfmg_media",9915],"xfmg_media-9914":["xfmg_media",9914],"xfmg_media-9901":["xfmg_media",9901],"xfmg_media-9850":["xfmg_media",9850],"xfmg_media-9807":["xfmg_media",9807],"xfmg_media-9712":["xfmg_media",9712],"xfmg_media-9538":["xfmg_media",9538],"xfmg_media-9537":["xfmg_media",9537],"xfmg_media-9536":["xfmg_media",9536],"xfmg_media-9535":["xfmg_media",9535],"xfmg_media-9534":["xfmg_media",9534],"xfmg_media-9472":["xfmg_media",9472],"thread-85106":["thread",85106],"xfmg_media-9449":["xfmg_media",9449],"xfmg_media-8601":["xfmg_media",8601],"xfmg_media-8385":["xfmg_media",8385],"xfmg_media-8384":["xfmg_media",8384],"thread-84956":["thread",84956]}, , 1716855732
Run Time: 0.000346
- 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