SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000170
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1197
- XF\Entity\User->hasPermission() in src/addons/Snog/Forms/XF/Entity/User.php at line 16
- Snog\Forms\XF\Entity\User->canViewAdvancedForms() in src/addons/Snog/Forms/Listener.php at line 131
- Snog\Forms\Listener::appPubStartEnd() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 2853
- XF\App->fire() in src/XF/Pub/App.php at line 201
- XF\Pub\App->start() in src/XF/App.php at line 2347
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = '15515')
LIMIT 1
Run Time: 0.000393
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Controller.php at line 475
- XF\Mvc\Controller->assertRecordExistsByUnique() in src/XF/Mvc/Controller.php at line 458
- XF\Mvc\Controller->assertRecordExists() in src/addons/XenAddons/AMS/Pub/Controller/Author.php at line 36
- XenAddons\AMS\Pub\Controller\Author->actionAuthor() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_xa_ams_category`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_xa_ams_category`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'ams_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_xa_ams_category`.`category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
ORDER BY `xf_xa_ams_category`.`lft` ASC
Run Time: 0.000451
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xa_ams_category | ALL | | | | | 8 | Using filesort |
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.xf_xa_ams_category.category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1387
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/AbstractCategoryTree.php at line 67
- XF\Repository\AbstractCategoryTree->getViewableCategories() in src/addons/XenAddons/AMS/ControllerPlugin/AuthorArticleList.php at line 12
- XenAddons\AMS\ControllerPlugin\AuthorArticleList->getCategoryListData() in src/addons/XenAddons/AMS/Pub/Controller/Author.php at line 41
- XenAddons\AMS\Pub\Controller\Author->actionAuthor() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_xa_ams_article`.*, `xf_user_User_1`.*, `xf_xa_ams_article_feature_Featured_2`.*, `xf_attachment_CoverImage_3`.*, `xf_attachment_data_Data_4`.*, `xf_xa_ams_category_Category_5`.*
FROM `xf_xa_ams_article`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_xa_ams_article`.`user_id`)
LEFT JOIN `xf_xa_ams_article_feature` AS `xf_xa_ams_article_feature_Featured_2` ON (`xf_xa_ams_article_feature_Featured_2`.`article_id` = `xf_xa_ams_article`.`article_id`)
LEFT JOIN `xf_attachment` AS `xf_attachment_CoverImage_3` ON (`xf_attachment_CoverImage_3`.`content_type` = 'ams_article' AND `xf_attachment_CoverImage_3`.`content_id` = `xf_xa_ams_article`.`article_id` AND `xf_attachment_CoverImage_3`.`attachment_id` = `xf_xa_ams_article`.`cover_image_id`)
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_4` ON (`xf_attachment_data_Data_4`.`data_id` = `xf_attachment_CoverImage_3`.`data_id`)
LEFT JOIN `xf_xa_ams_category` AS `xf_xa_ams_category_Category_5` ON (`xf_xa_ams_category_Category_5`.`category_id` = `xf_xa_ams_article`.`category_id`)
WHERE (`xf_xa_ams_article`.`category_id` IN (3, 4, 7, 9, 8, 6, 1)) AND (`xf_xa_ams_article`.`user_id` = 15515) AND ((`xf_xa_ams_article`.`article_state` IN ('visible')))
ORDER BY `xf_xa_ams_article`.`publish_date` DESC
LIMIT 20 OFFSET 20
Run Time: 0.013154
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xa_ams_article | ref | category_publish_date,category_last_update,category_rating_weighted,user_id_last_update | user_id_last_update | 4 | const | 25 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_xa_ams_article_feature_Featured_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_xa_ams_article.article_id | 1 | |
SIMPLE | xf_attachment_CoverImage_3 | eq_ref | PRIMARY,content_type_id_date | PRIMARY | 4 | admin_xen.xf_xa_ams_article.cover_image_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_attachment_CoverImage_3.data_id | 1 | Using where |
SIMPLE | xf_xa_ams_category_Category_5 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_xa_ams_article.category_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1387
- XF\Mvc\Entity\Finder->fetch() in src/addons/XenAddons/AMS/ControllerPlugin/AuthorArticleList.php at line 54
- XenAddons\AMS\ControllerPlugin\AuthorArticleList->getAuthorArticleListData() in src/addons/XenAddons/AMS/Pub/Controller/Author.php at line 44
- XenAddons\AMS\Pub\Controller\Author->actionAuthor() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT COUNT(*)
FROM `xf_xa_ams_article`
WHERE (`xf_xa_ams_article`.`category_id` IN (3, 4, 7, 9, 8, 6, 1)) AND (`xf_xa_ams_article`.`user_id` = 15515) AND ((`xf_xa_ams_article`.`article_state` IN ('visible')))
Run Time: 0.000319
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xa_ams_article | ref | category_publish_date,category_last_update,category_rating_weighted,user_id_last_update | user_id_last_update | 4 | const | 25 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1342
- XF\Mvc\Entity\Finder->total() in src/addons/XenAddons/AMS/ControllerPlugin/AuthorArticleList.php at line 55
- XenAddons\AMS\ControllerPlugin\AuthorArticleList->getAuthorArticleListData() in src/addons/XenAddons/AMS/Pub/Controller/Author.php at line 44
- XenAddons\AMS\Pub\Controller\Author->actionAuthor() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, "