SELECT `xf_rm_resource`.*, `xf_user_User_1`.*, `xf_permission_combination_PermissionCombination_2`.*, `xf_rm_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_rm_resource_update_Description_5`.*, `xf_rm_resource_version_CurrentVersion_6`.*, `xf_thread_Discussion_7`.*, `xf_forum_Forum_8`.*, `xf_node_Node_9`.*, `xf_permission_cache_content_Permissions_10`.*
FROM `xf_rm_resource`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_rm_resource`.`user_id`)
LEFT JOIN `xf_permission_combination` AS `xf_permission_combination_PermissionCombination_2` ON (`xf_permission_combination_PermissionCombination_2`.`permission_combination_id` = `xf_user_User_1`.`permission_combination_id`)
LEFT JOIN `xf_rm_category` AS `xf_rm_category_Category_3` ON (`xf_rm_category_Category_3`.`resource_category_id` = `xf_rm_resource`.`resource_category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_rm_category_Category_3`.`resource_category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
LEFT JOIN `xf_rm_resource_update` AS `xf_rm_resource_update_Description_5` ON (`xf_rm_resource_update_Description_5`.`resource_update_id` = `xf_rm_resource`.`description_update_id`)
LEFT JOIN `xf_rm_resource_version` AS `xf_rm_resource_version_CurrentVersion_6` ON (`xf_rm_resource_version_CurrentVersion_6`.`resource_version_id` = `xf_rm_resource`.`current_version_id`)
LEFT JOIN `xf_thread` AS `xf_thread_Discussion_7` ON (`xf_thread_Discussion_7`.`thread_id` = `xf_rm_resource`.`discussion_thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_8` ON (`xf_forum_Forum_8`.`node_id` = `xf_thread_Discussion_7`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_9` ON (`xf_node_Node_9`.`node_id` = `xf_forum_Forum_8`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_10` ON (`xf_permission_cache_content_Permissions_10`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_10`.`content_id` = `xf_node_Node_9`.`node_id` AND `xf_permission_cache_content_Permissions_10`.`permission_combination_id` = '1')
WHERE (`xf_rm_resource`.`resource_id` = '724')
LIMIT 1
Run Time: 0.001560
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_combination_PermissionCombination_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_category_Category_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SIMPLE | xf_rm_resource_update_Description_5 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_resource_version_CurrentVersion_6 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_Discussion_7 | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_forum_Forum_8 | const | PRIMARY | | | | 1 | Impossible ON condition |
SIMPLE | xf_node_Node_9 | const | PRIMARY | | | | 1 | Impossible ON condition |
SIMPLE | xf_permission_cache_content_Permissions_10 | const | PRIMARY | | | | 1 | Impossible ON condition |
- 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 1346
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/addons/XFRM/Pub/Controller/ResourceItem.php at line 1788
- XFRM\Pub\Controller\ResourceItem->assertViewableResource() in src/addons/XFRM/Pub/Controller/ResourceItem.php at line 271
- XFRM\Pub\Controller\ResourceItem->actionField() 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, "