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 (948, 927, 923, 916, 911, 862, 858, 857, 855, 844, 830, 828, 825, 821, 817, 759, 753, 752, 751, 711, 680, 679, 666, 656, 655, 651, 641, 640, 639, 638, 630, 629, 628, 627, 617, 616, 604, 603, 602, 601, 597, 594, 589, 586, 585, 569, 568, 567, 562, 559, 558, 557, 552, 551, 550, 531, 522, 521, 520, 519, 518, 517, 515, 508, 502, 492, 483, 482, 481, 480, 479, 478, 477, 476, 475, 474, 472, 471, 470, 460, 459, 458, 457, 425, 424, 423, 421, 418, 416, 415, 414, 413, 412, 411, 410, 409, 408, 406, 405, 404, 403, 402, 401, 400, 398, 391, 390, 389, 380, 379, 378, 377, 376, 375, 374, 373, 372, 371, 370, 369, 368, 367, 366, 365, 364, 363, 362, 361, 360, 359, 358, 357, 356, 355, 354, 353, 352, 351, 350, 349, 348, 347, 346, 345, 344, 343, 342, 341, 340, 339, 338, 337, 336, 335, 334, 333, 332, 331, 330, 329, 328, 327, 326, 325, 324, 323, 322, 321, 320, 319, 318, 317, 316, 315, 314, 313, 312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 297, 269, 268, 267, 266, 265, 264, 263, 262))
Run Time: 0.009239
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 | thesims.xf_mg_media_item.album_id | 1 | |
SIMPLE | xf_mg_category_Category_2 | ALL | PRIMARY | | | | 3 | Using where; Using join buffer (Block Nested Loop) |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | thesims.xf_mg_media_item.user_id | 1 | |
SIMPLE | xf_attachment_Attachment_4 | ref | content_type_id_date | content_type_id_date | 31 | const,thesims.xf_mg_media_item.media_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_5 | eq_ref | PRIMARY | PRIMARY | 4 | thesims.xf_attachment_Attachment_4.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2710
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 729
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- 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: 466, 0, 1714301077, {"xfmg_media-948":["xfmg_media",948],"xfmg_media-927":["xfmg_media",927],"xfmg_media-923":["xfmg_media",923],"xfmg_media-916":["xfmg_media",916],"xfmg_media-911":["xfmg_media",911],"xfmg_media-862":["xfmg_media",862],"xfmg_media-858":["xfmg_media",858],"xfmg_media-857":["xfmg_media",857],"xfmg_media-855":["xfmg_media",855],"xfmg_media-844":["xfmg_media",844],"xfmg_media-830":["xfmg_media",830],"xfmg_media-828":["xfmg_media",828],"xfmg_media-825":["xfmg_media",825],"xfmg_media-821":["xfmg_media",821],"xfmg_media-817":["xfmg_media",817],"xfmg_media-759":["xfmg_media",759],"xfmg_media-753":["xfmg_media",753],"xfmg_media-752":["xfmg_media",752],"xfmg_media-751":["xfmg_media",751],"xfmg_media-711":["xfmg_media",711],"xfmg_media-680":["xfmg_media",680],"xfmg_media-679":["xfmg_media",679],"xfmg_media-666":["xfmg_media",666],"xfmg_media-656":["xfmg_media",656],"xfmg_media-655":["xfmg_media",655],"xfmg_media-651":["xfmg_media",651],"xfmg_media-641":["xfmg_media",641],"xfmg_media-640":["xfmg_media",640],"xfmg_media-639":["xfmg_media",639],"xfmg_media-638":["xfmg_media",638],"xfmg_media-630":["xfmg_media",630],"xfmg_media-629":["xfmg_media",629],"xfmg_media-628":["xfmg_media",628],"xfmg_media-627":["xfmg_media",627],"xfmg_media-617":["xfmg_media",617],"xfmg_media-616":["xfmg_media",616],"xfmg_media-604":["xfmg_media",604],"xfmg_media-603":["xfmg_media",603],"xfmg_media-602":["xfmg_media",602],"xfmg_media-601":["xfmg_media",601],"xfmg_media-597":["xfmg_media",597],"xfmg_media-594":["xfmg_media",594],"xfmg_media-589":["xfmg_media",589],"xfmg_media-586":["xfmg_media",586],"xfmg_media-585":["xfmg_media",585],"xfmg_media-569":["xfmg_media",569],"xfmg_media-568":["xfmg_media",568],"xfmg_media-567":["xfmg_media",567],"xfmg_media-562":["xfmg_media",562],"xfmg_media-559":["xfmg_media",559],"xfmg_media-558":["xfmg_media",558],"xfmg_media-557":["xfmg_media",557],"xfmg_media-552":["xfmg_media",552],"xfmg_media-551":["xfmg_media",551],"xfmg_media-550":["xfmg_media",550],"xfmg_media-531":["xfmg_media",531],"xfmg_media-522":["xfmg_media",522],"xfmg_media-521":["xfmg_media",521],"xfmg_media-520":["xfmg_media",520],"xfmg_media-519":["xfmg_media",519],"xfmg_media-518":["xfmg_media",518],"xfmg_media-517":["xfmg_media",517],"xfmg_media-515":["xfmg_media",515],"xfmg_media-508":["xfmg_media",508],"xfmg_media-502":["xfmg_media",502],"xfmg_media-492":["xfmg_media",492],"xfmg_media-483":["xfmg_media",483],"xfmg_media-482":["xfmg_media",482],"xfmg_media-481":["xfmg_media",481],"xfmg_media-480":["xfmg_media",480],"xfmg_media-479":["xfmg_media",479],"xfmg_media-478":["xfmg_media",478],"xfmg_media-477":["xfmg_media",477],"xfmg_media-476":["xfmg_media",476],"xfmg_media-475":["xfmg_media",475],"xfmg_media-474":["xfmg_media",474],"xfmg_media-472":["xfmg_media",472],"xfmg_media-471":["xfmg_media",471],"xfmg_media-470":["xfmg_media",470],"xfmg_media-460":["xfmg_media",460],"xfmg_media-459":["xfmg_media",459],"xfmg_media-458":["xfmg_media",458],"xfmg_media-457":["xfmg_media",457],"xfmg_media-425":["xfmg_media",425],"xfmg_media-424":["xfmg_media",424],"xfmg_media-423":["xfmg_media",423],"xfmg_media-421":["xfmg_media",421],"xfmg_media-418":["xfmg_media",418],"xfmg_media-416":["xfmg_media",416],"xfmg_media-415":["xfmg_media",415],"xfmg_media-414":["xfmg_media",414],"xfmg_media-413":["xfmg_media",413],"xfmg_media-412":["xfmg_media",412],"xfmg_media-411":["xfmg_media",411],"xfmg_media-410":["xfmg_media",410],"xfmg_media-409":["xfmg_media",409],"xfmg_media-408":["xfmg_media",408],"xfmg_media-406":["xfmg_media",406],"xfmg_media-405":["xfmg_media",405],"xfmg_media-404":["xfmg_media",404],"xfmg_media-403":["xfmg_media",403],"xfmg_media-402":["xfmg_media",402],"xfmg_media-401":["xfmg_media",401],"xfmg_media-400":["xfmg_media",400],"xfmg_media-398":["xfmg_media",398],"xfmg_media-391":["xfmg_media",391],"xfmg_media-390":["xfmg_media",390],"xfmg_media-389":["xfmg_media",389],"xfmg_media-380":["xfmg_media",380],"xfmg_media-379":["xfmg_media",379],"xfmg_media-378":["xfmg_media",378],"xfmg_media-377":["xfmg_media",377],"xfmg_media-376":["xfmg_media",376],"xfmg_media-375":["xfmg_media",375],"xfmg_media-374":["xfmg_media",374],"xfmg_media-373":["xfmg_media",373],"xfmg_media-372":["xfmg_media",372],"xfmg_media-371":["xfmg_media",371],"xfmg_media-370":["xfmg_media",370],"xfmg_media-369":["xfmg_media",369],"xfmg_media-368":["xfmg_media",368],"xfmg_media-367":["xfmg_media",367],"xfmg_media-366":["xfmg_media",366],"xfmg_media-365":["xfmg_media",365],"xfmg_media-364":["xfmg_media",364],"xfmg_media-363":["xfmg_media",363],"xfmg_media-362":["xfmg_media",362],"xfmg_media-361":["xfmg_media",361],"xfmg_media-360":["xfmg_media",360],"xfmg_media-359":["xfmg_media",359],"xfmg_media-358":["xfmg_media",358],"xfmg_media-357":["xfmg_media",357],"xfmg_media-356":["xfmg_media",356],"xfmg_media-355":["xfmg_media",355],"xfmg_media-354":["xfmg_media",354],"xfmg_media-353":["xfmg_media",353],"xfmg_media-352":["xfmg_media",352],"xfmg_media-351":["xfmg_media",351],"xfmg_media-350":["xfmg_media",350],"xfmg_media-349":["xfmg_media",349],"xfmg_media-348":["xfmg_media",348],"xfmg_media-347":["xfmg_media",347],"xfmg_media-346":["xfmg_media",346],"xfmg_media-345":["xfmg_media",345],"xfmg_media-344":["xfmg_media",344],"xfmg_media-343":["xfmg_media",343],"xfmg_media-342":["xfmg_media",342],"xfmg_media-341":["xfmg_media",341],"xfmg_media-340":["xfmg_media",340],"xfmg_media-339":["xfmg_media",339],"xfmg_media-338":["xfmg_media",338],"xfmg_media-337":["xfmg_media",337],"xfmg_media-336":["xfmg_media",336],"xfmg_media-335":["xfmg_media",335],"xfmg_media-334":["xfmg_media",334],"xfmg_media-333":["xfmg_media",333],"xfmg_media-332":["xfmg_media",332],"xfmg_media-331":["xfmg_media",331],"xfmg_media-330":["xfmg_media",330],"xfmg_media-329":["xfmg_media",329],"xfmg_media-328":["xfmg_media",328],"xfmg_media-327":["xfmg_media",327],"xfmg_media-326":["xfmg_media",326],"xfmg_media-325":["xfmg_media",325],"xfmg_media-324":["xfmg_media",324],"xfmg_media-323":["xfmg_media",323],"xfmg_media-322":["xfmg_media",322],"xfmg_media-321":["xfmg_media",321],"xfmg_media-320":["xfmg_media",320],"xfmg_media-319":["xfmg_media",319],"xfmg_media-318":["xfmg_media",318],"xfmg_media-317":["xfmg_media",317],"xfmg_media-316":["xfmg_media",316],"xfmg_media-315":["xfmg_media",315],"xfmg_media-314":["xfmg_media",314],"xfmg_media-313":["xfmg_media",313],"xfmg_media-312":["xfmg_media",312],"xfmg_media-311":["xfmg_media",311],"xfmg_media-310":["xfmg_media",310],"xfmg_media-309":["xfmg_media",309],"xfmg_media-308":["xfmg_media",308],"xfmg_media-307":["xfmg_media",307],"xfmg_media-306":["xfmg_media",306],"xfmg_media-305":["xfmg_media",305],"xfmg_media-304":["xfmg_media",304],"xfmg_media-303":["xfmg_media",303],"xfmg_media-302":["xfmg_media",302],"xfmg_media-301":["xfmg_media",301],"xfmg_media-300":["xfmg_media",300],"xfmg_media-299":["xfmg_media",299],"xfmg_media-298":["xfmg_media",298],"xfmg_media-297":["xfmg_media",297],"xfmg_media-269":["xfmg_media",269],"xfmg_media-268":["xfmg_media",268],"xfmg_media-267":["xfmg_media",267],"xfmg_media-266":["xfmg_media",266],"xfmg_media-265":["xfmg_media",265],"xfmg_media-264":["xfmg_media",264],"xfmg_media-263":["xfmg_media",263],"xfmg_media-262":["xfmg_media",262]}, , 1714297477
Run Time: 0.000300
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1510
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20