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 (953, 952, 951, 949, 928, 914, 913, 912, 904, 895, 894, 893, 892, 891, 890, 889, 882, 881, 880, 871, 861, 860, 859, 853, 852, 851, 849, 848, 847, 846, 843, 842, 829, 824, 823, 819, 818, 763, 762, 757, 756, 755, 754, 712, 662, 661, 660, 659, 654, 650, 646, 645, 644, 643, 642, 638, 637, 636, 635, 634, 633, 632, 630, 629, 628, 627))
Run Time: 0.004666
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_media_item | range | PRIMARY | PRIMARY | 4 | | 66 | 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: 664, 0, 1711668045, {"xfmg_media-953":["xfmg_media",953],"xfmg_media-952":["xfmg_media",952],"xfmg_media-951":["xfmg_media",951],"xfmg_media-949":["xfmg_media",949],"xfmg_media-928":["xfmg_media",928],"xfmg_media-914":["xfmg_media",914],"xfmg_media-913":["xfmg_media",913],"xfmg_media-912":["xfmg_media",912],"xfmg_media-904":["xfmg_media",904],"xfmg_media-895":["xfmg_media",895],"xfmg_media-894":["xfmg_media",894],"xfmg_media-893":["xfmg_media",893],"xfmg_media-892":["xfmg_media",892],"xfmg_media-891":["xfmg_media",891],"xfmg_media-890":["xfmg_media",890],"xfmg_media-889":["xfmg_media",889],"xfmg_media-882":["xfmg_media",882],"xfmg_media-881":["xfmg_media",881],"xfmg_media-880":["xfmg_media",880],"xfmg_media-871":["xfmg_media",871],"xfmg_media-861":["xfmg_media",861],"xfmg_media-860":["xfmg_media",860],"xfmg_media-859":["xfmg_media",859],"xfmg_media-853":["xfmg_media",853],"xfmg_media-852":["xfmg_media",852],"xfmg_media-851":["xfmg_media",851],"xfmg_media-849":["xfmg_media",849],"xfmg_media-848":["xfmg_media",848],"xfmg_media-847":["xfmg_media",847],"xfmg_media-846":["xfmg_media",846],"xfmg_media-843":["xfmg_media",843],"xfmg_media-842":["xfmg_media",842],"xfmg_media-829":["xfmg_media",829],"xfmg_media-824":["xfmg_media",824],"xfmg_media-823":["xfmg_media",823],"xfmg_media-819":["xfmg_media",819],"xfmg_media-818":["xfmg_media",818],"xfmg_media-763":["xfmg_media",763],"xfmg_media-762":["xfmg_media",762],"xfmg_media-757":["xfmg_media",757],"xfmg_media-756":["xfmg_media",756],"xfmg_media-755":["xfmg_media",755],"xfmg_media-754":["xfmg_media",754],"xfmg_media-712":["xfmg_media",712],"xfmg_media-662":["xfmg_media",662],"xfmg_media-661":["xfmg_media",661],"xfmg_media-660":["xfmg_media",660],"xfmg_media-659":["xfmg_media",659],"xfmg_media-654":["xfmg_media",654],"xfmg_media-650":["xfmg_media",650],"xfmg_media-646":["xfmg_media",646],"xfmg_media-645":["xfmg_media",645],"xfmg_media-644":["xfmg_media",644],"xfmg_media-643":["xfmg_media",643],"xfmg_media-642":["xfmg_media",642],"xfmg_media-638":["xfmg_media",638],"xfmg_media-637":["xfmg_media",637],"xfmg_media-636":["xfmg_media",636],"xfmg_media-635":["xfmg_media",635],"xfmg_media-634":["xfmg_media",634],"xfmg_media-633":["xfmg_media",633],"xfmg_media-632":["xfmg_media",632],"xfmg_media-630":["xfmg_media",630],"xfmg_media-629":["xfmg_media",629],"xfmg_media-628":["xfmg_media",628],"xfmg_media-627":["xfmg_media",627]}, , 1711664445
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
-- XFDB=noForceAllWrite
INSERT INTO xf_session_activity
(`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , XF\Pub\Controller\Tag, Tag, valid, tag_url=ts4, 1711664445,
Run Time: 0.000687
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 42
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 287
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 383
- 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