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 (856, 822, 820, 792, 788, 720, 719, 716, 715, 714, 713, 707, 706, 705, 704, 703, 702, 701, 700, 699, 696, 695, 694, 693, 692, 691, 690, 689, 688, 687, 686, 685, 684, 683, 682, 678, 677, 676, 675, 674, 673, 672, 671, 670, 631, 626, 622, 544, 540, 539, 538, 536, 535, 465, 296, 295, 294, 293, 292, 291, 290, 289, 288, 287, 286, 283, 280, 279, 277, 276, 274))
Run Time: 0.004341
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_mg_media_item | range | PRIMARY | PRIMARY | 4 | | 71 | 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: 550, 0, 1714676622, {"xfmg_media-856":["xfmg_media",856],"xfmg_media-822":["xfmg_media",822],"xfmg_media-820":["xfmg_media",820],"xfmg_media-792":["xfmg_media",792],"xfmg_media-788":["xfmg_media",788],"xfmg_media-720":["xfmg_media",720],"xfmg_media-719":["xfmg_media",719],"xfmg_media-716":["xfmg_media",716],"xfmg_media-715":["xfmg_media",715],"xfmg_media-714":["xfmg_media",714],"xfmg_media-713":["xfmg_media",713],"xfmg_media-707":["xfmg_media",707],"xfmg_media-706":["xfmg_media",706],"xfmg_media-705":["xfmg_media",705],"xfmg_media-704":["xfmg_media",704],"xfmg_media-703":["xfmg_media",703],"xfmg_media-702":["xfmg_media",702],"xfmg_media-701":["xfmg_media",701],"xfmg_media-700":["xfmg_media",700],"xfmg_media-699":["xfmg_media",699],"xfmg_media-696":["xfmg_media",696],"xfmg_media-695":["xfmg_media",695],"xfmg_media-694":["xfmg_media",694],"xfmg_media-693":["xfmg_media",693],"xfmg_media-692":["xfmg_media",692],"xfmg_media-691":["xfmg_media",691],"xfmg_media-690":["xfmg_media",690],"xfmg_media-689":["xfmg_media",689],"xfmg_media-688":["xfmg_media",688],"xfmg_media-687":["xfmg_media",687],"xfmg_media-686":["xfmg_media",686],"xfmg_media-685":["xfmg_media",685],"xfmg_media-684":["xfmg_media",684],"xfmg_media-683":["xfmg_media",683],"xfmg_media-682":["xfmg_media",682],"xfmg_media-678":["xfmg_media",678],"xfmg_media-677":["xfmg_media",677],"xfmg_media-676":["xfmg_media",676],"xfmg_media-675":["xfmg_media",675],"xfmg_media-674":["xfmg_media",674],"xfmg_media-673":["xfmg_media",673],"xfmg_media-672":["xfmg_media",672],"xfmg_media-671":["xfmg_media",671],"xfmg_media-670":["xfmg_media",670],"xfmg_media-631":["xfmg_media",631],"xfmg_media-626":["xfmg_media",626],"xfmg_media-622":["xfmg_media",622],"xfmg_media-544":["xfmg_media",544],"xfmg_media-540":["xfmg_media",540],"xfmg_media-539":["xfmg_media",539],"xfmg_media-538":["xfmg_media",538],"xfmg_media-536":["xfmg_media",536],"xfmg_media-535":["xfmg_media",535],"xfmg_media-465":["xfmg_media",465],"xfmg_media-296":["xfmg_media",296],"xfmg_media-295":["xfmg_media",295],"xfmg_media-294":["xfmg_media",294],"xfmg_media-293":["xfmg_media",293],"xfmg_media-292":["xfmg_media",292],"xfmg_media-291":["xfmg_media",291],"xfmg_media-290":["xfmg_media",290],"xfmg_media-289":["xfmg_media",289],"xfmg_media-288":["xfmg_media",288],"xfmg_media-287":["xfmg_media",287],"xfmg_media-286":["xfmg_media",286],"xfmg_media-283":["xfmg_media",283],"xfmg_media-280":["xfmg_media",280],"xfmg_media-279":["xfmg_media",279],"xfmg_media-277":["xfmg_media",277],"xfmg_media-276":["xfmg_media",276],"xfmg_media-274":["xfmg_media",274]}, , 1714673022
Run Time: 0.000372
- 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=labirint&page=2, 1714673022,
Run Time: 0.002297
- 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