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, 910, 909, 908, 907, 887, 886, 885, 884, 883, 869, 868, 858, 857, 830, 821, 783, 782, 781, 780, 779, 778, 777, 776, 775, 774, 773, 772, 771, 770, 769, 768, 767, 766, 653, 652, 623, 618, 617, 616, 593, 592, 518, 517, 459, 458, 457, 449, 432, 425, 424, 416, 186, 185, 184, 183, 182, 181, 180, 179, 178, 177, 176, 175, 174, 170))
Run Time: 0.003503
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: 522, 0, 1714620076, {"xfmg_media-948":["xfmg_media",948],"xfmg_media-910":["xfmg_media",910],"xfmg_media-909":["xfmg_media",909],"xfmg_media-908":["xfmg_media",908],"xfmg_media-907":["xfmg_media",907],"xfmg_media-887":["xfmg_media",887],"xfmg_media-886":["xfmg_media",886],"xfmg_media-885":["xfmg_media",885],"xfmg_media-884":["xfmg_media",884],"xfmg_media-883":["xfmg_media",883],"xfmg_media-869":["xfmg_media",869],"xfmg_media-868":["xfmg_media",868],"xfmg_media-858":["xfmg_media",858],"xfmg_media-857":["xfmg_media",857],"xfmg_media-830":["xfmg_media",830],"xfmg_media-821":["xfmg_media",821],"xfmg_media-783":["xfmg_media",783],"xfmg_media-782":["xfmg_media",782],"xfmg_media-781":["xfmg_media",781],"xfmg_media-780":["xfmg_media",780],"xfmg_media-779":["xfmg_media",779],"xfmg_media-778":["xfmg_media",778],"xfmg_media-777":["xfmg_media",777],"xfmg_media-776":["xfmg_media",776],"xfmg_media-775":["xfmg_media",775],"xfmg_media-774":["xfmg_media",774],"xfmg_media-773":["xfmg_media",773],"xfmg_media-772":["xfmg_media",772],"xfmg_media-771":["xfmg_media",771],"xfmg_media-770":["xfmg_media",770],"xfmg_media-769":["xfmg_media",769],"xfmg_media-768":["xfmg_media",768],"xfmg_media-767":["xfmg_media",767],"xfmg_media-766":["xfmg_media",766],"xfmg_media-653":["xfmg_media",653],"xfmg_media-652":["xfmg_media",652],"xfmg_media-623":["xfmg_media",623],"xfmg_media-618":["xfmg_media",618],"xfmg_media-617":["xfmg_media",617],"xfmg_media-616":["xfmg_media",616],"xfmg_media-593":["xfmg_media",593],"xfmg_media-592":["xfmg_media",592],"xfmg_media-518":["xfmg_media",518],"xfmg_media-517":["xfmg_media",517],"xfmg_media-459":["xfmg_media",459],"xfmg_media-458":["xfmg_media",458],"xfmg_media-457":["xfmg_media",457],"xfmg_media-449":["xfmg_media",449],"xfmg_media-432":["xfmg_media",432],"xfmg_media-425":["xfmg_media",425],"xfmg_media-424":["xfmg_media",424],"xfmg_media-416":["xfmg_media",416],"xfmg_media-186":["xfmg_media",186],"xfmg_media-185":["xfmg_media",185],"xfmg_media-184":["xfmg_media",184],"xfmg_media-183":["xfmg_media",183],"xfmg_media-182":["xfmg_media",182],"xfmg_media-181":["xfmg_media",181],"xfmg_media-180":["xfmg_media",180],"xfmg_media-179":["xfmg_media",179],"xfmg_media-178":["xfmg_media",178],"xfmg_media-177":["xfmg_media",177],"xfmg_media-176":["xfmg_media",176],"xfmg_media-175":["xfmg_media",175],"xfmg_media-174":["xfmg_media",174],"xfmg_media-170":["xfmg_media",170]}, , 1714616476
Run Time: 0.000204
- 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=pejzazh&page=2, 1714616476,
Run Time: 0.002335
- 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