SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')
Run Time: 0.002413
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 43 | Using where |
- 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 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
- XF\DataRegistry->get() in src/XF/App.php at line 1765
- XF\App->preLoadData() in src/XF/App.php at line 1753
- XF\App->setup() in src/XF/Pub/App.php at line 89
- XF\Pub\App->setup() in src/XF.php at line 364
- XF::setupApp() in src/XF.php at line 387
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000280
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 926
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 241
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 123
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 349
- 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 2190
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_xa_ams_article`.*, `xf_user_User_1`.*, `xf_attachment_CoverImage_2`.*, `xf_attachment_data_Data_3`.*, `xf_xa_ams_article_feature_Featured_4`.*, `xf_xa_ams_series_part_SeriesPart_5`.*, `xf_xa_ams_series_Series_6`.*, `xf_xa_ams_category_Category_7`.*, `xf_permission_cache_content_Permissions_8`.*, `xf_thread_Discussion_9`.*, `xf_forum_Forum_10`.*, `xf_node_Node_11`.*, `xf_permission_cache_content_Permissions_12`.*
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_attachment` AS `xf_attachment_CoverImage_2` ON (`xf_attachment_CoverImage_2`.`content_type` = 'ams_article' AND `xf_attachment_CoverImage_2`.`content_id` = `xf_xa_ams_article`.`article_id` AND `xf_attachment_CoverImage_2`.`attachment_id` = `xf_xa_ams_article`.`cover_image_id`)
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_3` ON (`xf_attachment_data_Data_3`.`data_id` = `xf_attachment_CoverImage_2`.`data_id`)
LEFT JOIN `xf_xa_ams_article_feature` AS `xf_xa_ams_article_feature_Featured_4` ON (`xf_xa_ams_article_feature_Featured_4`.`article_id` = `xf_xa_ams_article`.`article_id`)
LEFT JOIN `xf_xa_ams_series_part` AS `xf_xa_ams_series_part_SeriesPart_5` ON (`xf_xa_ams_series_part_SeriesPart_5`.`part_id` = `xf_xa_ams_article`.`series_part_id`)
LEFT JOIN `xf_xa_ams_series` AS `xf_xa_ams_series_Series_6` ON (`xf_xa_ams_series_Series_6`.`series_id` = `xf_xa_ams_series_part_SeriesPart_5`.`series_id`)
LEFT JOIN `xf_xa_ams_category` AS `xf_xa_ams_category_Category_7` ON (`xf_xa_ams_category_Category_7`.`category_id` = `xf_xa_ams_article`.`category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_8` ON (`xf_permission_cache_content_Permissions_8`.`content_type` = 'ams_category' AND `xf_permission_cache_content_Permissions_8`.`content_id` = `xf_xa_ams_category_Category_7`.`category_id` AND `xf_permission_cache_content_Permissions_8`.`permission_combination_id` = '1')
LEFT JOIN `xf_thread` AS `xf_thread_Discussion_9` ON (`xf_thread_Discussion_9`.`thread_id` = `xf_xa_ams_article`.`discussion_thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_10` ON (`xf_forum_Forum_10`.`node_id` = `xf_thread_Discussion_9`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_11` ON (`xf_node_Node_11`.`node_id` = `xf_forum_Forum_10`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_12` ON (`xf_permission_cache_content_Permissions_12`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_12`.`content_id` = `xf_node_Node_11`.`node_id` AND `xf_permission_cache_content_Permissions_12`.`permission_combination_id` = '1')
WHERE (`xf_xa_ams_article`.`article_id` = '9')
LIMIT 1
Run Time: 0.001298
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xa_ams_article | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_attachment_CoverImage_2 | const | PRIMARY,content_type_id_date | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_attachment_data_Data_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_xa_ams_article_feature_Featured_4 | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_xa_ams_series_part_SeriesPart_5 | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_xa_ams_series_Series_6 | const | PRIMARY | | | | 1 | Impossible ON condition |
SIMPLE | xf_xa_ams_category_Category_7 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_8 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SIMPLE | xf_thread_Discussion_9 | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | xf_forum_Forum_10 | const | PRIMARY | | | | 1 | Impossible ON condition |
SIMPLE | xf_node_Node_11 | const | PRIMARY | | | | 1 | Impossible ON condition |
SIMPLE | xf_permission_cache_content_Permissions_12 | 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 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/addons/XenAddons/AMS/Pub/Controller/AbstractController.php at line 70
- XenAddons\AMS\Pub\Controller\AbstractController->assertViewableArticle() in src/addons/XenAddons/AMS/Pub/Controller/ArticleItem.php at line 167
- XenAddons\AMS\Pub\Controller\ArticleItem->actionView() 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 2190
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_xa_ams_comment`.*, `xf_xa_ams_article_Article_1`.*, `xf_user_User_2`.*, `xf_user_profile_Profile_3`.*, `xf_session_activity_Activity_4`.*
FROM `xf_xa_ams_comment`
LEFT JOIN `xf_xa_ams_article` AS `xf_xa_ams_article_Article_1` ON (`xf_xa_ams_article_Article_1`.`article_id` = `xf_xa_ams_comment`.`article_id`)
LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_xa_ams_comment`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user_User_2`.`user_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_4` ON (`xf_session_activity_Activity_4`.`user_id` = `xf_user_User_2`.`user_id` AND `xf_session_activity_Activity_4`.`unique_key` = CONCAT(`xf_user_User_2`.`user_id`, ''))
WHERE (`xf_xa_ams_comment`.`article_id` = 9) AND ((`xf_xa_ams_comment`.`comment_state` IN ('visible')))
ORDER BY `xf_xa_ams_comment`.`comment_date` ASC, `xf_xa_ams_comment`.`comment_id` ASC
LIMIT 20
Run Time: 0.000660
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xa_ams_comment | ALL | | | | | 1 | Using where; Using filesort |
SIMPLE | xf_xa_ams_article_Article_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_2 | eq_ref | PRIMARY | PRIMARY | 4 | u1068708_gipergidroz_info.xf_xa_ams_comment.user_id | 1 | |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | u1068708_gipergidroz_info.xf_user_User_2.user_id | 1 | |
SIMPLE | xf_session_activity_Activity_4 | eq_ref | PRIMARY | PRIMARY | 22 | u1068708_gipergidroz_info.xf_user_User_2.user_id,func | 1 | Using where |
- 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 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/XenAddons/AMS/Pub/Controller/ArticleItem.php at line 243
- XenAddons\AMS\Pub\Controller\ArticleItem->actionView() 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 2190
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT COUNT(*)
FROM `xf_xa_ams_comment`
WHERE (`xf_xa_ams_comment`.`article_id` = 9) AND ((`xf_xa_ams_comment`.`comment_state` IN ('visible')))
Run Time: 0.000188
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xa_ams_comment | ALL | | | | | 1 | Using where |
- 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 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1249
- XF\Mvc\Entity\Finder->total() in src/addons/XenAddons/AMS/Pub/Controller/ArticleItem.php at line 244
- XenAddons\AMS\Pub\Controller\ArticleItem->actionView() 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 2190
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
INSERT INTO xf_xa_ams_article_view
(article_id, total)
VALUES
(? , 1)
ON DUPLICATE KEY UPDATE
total = total + 1
Params: 9
Run Time: 0.000070
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/addons/XenAddons/AMS/Repository/Article.php at line 265
- XenAddons\AMS\Repository\Article->logArticleView() in src/addons/XenAddons/AMS/Pub/Controller/ArticleItem.php at line 247
- XenAddons\AMS\Pub\Controller\ArticleItem->actionView() 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 2190
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_xa_ams_article`.*, `xf_user_User_1`.*, `xf_xa_ams_category_Category_2`.*, `xf_permission_cache_content_Permissions_3`.*
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_category` AS `xf_xa_ams_category_Category_2` ON (`xf_xa_ams_category_Category_2`.`category_id` = `xf_xa_ams_article`.`category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_3` ON (`xf_permission_cache_content_Permissions_3`.`content_type` = 'ams_category' AND `xf_permission_cache_content_Permissions_3`.`content_id` = `xf_xa_ams_category_Category_2`.`category_id` AND `xf_permission_cache_content_Permissions_3`.`permission_combination_id` = '1')
WHERE (`xf_xa_ams_article`.`article_state` = 'visible') AND (`xf_xa_ams_article`.`category_id` = 2) AND (`xf_xa_ams_article`.`article_id` <> 9)
ORDER BY `xf_xa_ams_article`.`last_update` DESC
LIMIT 5
Run Time: 0.001922
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xa_ams_article | ref | PRIMARY,category_publish_date,category_last_update,category_rating_weighted | category_last_update | 4 | const | 33 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | u1068708_gipergidroz_info.xf_xa_ams_article.user_id | 1 | |
SIMPLE | xf_xa_ams_category_Category_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_3 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,u1068708_gipergidroz_info.xf_xa_ams_category_Category_2.category_id | 1 | Using where |
- 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 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/XenAddons/AMS/Pub/Controller/ArticleItem.php at line 305
- XenAddons\AMS\Pub\Controller\ArticleItem->actionView() 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 2190
- XF\App->run() in src/XF.php at line 391
- 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, , , XenAddons\AMS\Pub\Controller\ArticleItem, View, valid, article_id=9, 1713525904,
Run Time: 0.000109
- 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 81
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 41
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 284
- 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 2190
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'ams_article') AND (`xf_attachment`.`content_id` = 9)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000516
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 24 | Using index condition |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | u1068708_gipergidroz_info.xf_attachment.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 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/XenAddons/AMS/Entity/ArticleItem.php at line 855
- XenAddons\AMS\Entity\ArticleItem->hasImageAttachments() in src/addons/XenAddons/AMS/Entity/ArticleItem.php at line 384
- XenAddons\AMS\Entity\ArticleItem->canSetCoverImage()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s4/public/xa_ams_article_wrapper_macros.php at line 466
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s4/public/xa_ams_article_view.php at line 1196
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('xa_amsArticleFields')
Run Time: 0.000166
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
- 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 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 226
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1656
- XF\App->XF\{closure}() in src/XF/Container.php at line 28
- XF\Container->offsetGet() in src/XF/App.php at line 3040
- XF\App->container() in src/addons/XenAddons/AMS/Entity/ArticleItem.php at line 837
- XenAddons\AMS\Entity\ArticleItem->getCustomFields() in src/XF/Mvc/Entity/Entity.php at line 148
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l2/s4/public/xa_ams_article_view.php at line 1261
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_user_profile`.*
FROM `xf_user_profile`
WHERE (`xf_user_profile`.`user_id` = 1)
LIMIT 1
Run Time: 0.000191
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_profile | const | PRIMARY | PRIMARY | 4 | const | 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 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l2/s4/public/xa_ams_article_view.php at line 1709
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT title
FROM xf_xa_ams_article
WHERE article_id = 9
Run Time: 0.000243
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xa_ams_article | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- 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 150
- XF\Db\AbstractAdapter->fetchOne() in src/addons/XenAddons/AMS/XF/Entity/User.php at line 22
- XenAddons\AMS\XF\Entity\User->getBreadcrumbs2()
- call_user_func_array() in src/XF/Template/Templater.php at line 999
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s4/public/PAGE_CONTAINER.php at line 452
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s4/public/PAGE_CONTAINER.php at line 2289
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1315
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 547
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2001
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2190
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
bytes_sent | 15069 |
bytes_received | 615931 |
packets_sent | 136 |
packets_received | 1443 |
protocol_overhead_in | 5772 |
protocol_overhead_out | 544 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 306 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 144 |
bytes_received_prepare_response_packet | 127106 |
bytes_received_change_user_packet | 487831 |
packets_sent_command | 67 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 34 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 24 |
packets_received_prepare_response | 1240 |
packets_received_change_user | 121 |
result_set_queries | 20 |
non_result_set_queries | 4 |
no_index_used | 6 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 20 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 21 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 101 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 101 |
rows_fetched_from_client_normal_buffered | 0 |
rows_fetched_from_client_normal_unbuffered | 0 |
rows_fetched_from_client_ps_buffered | 0 |
rows_fetched_from_client_ps_unbuffered | 0 |
rows_fetched_from_client_ps_cursor | 0 |
rows_affected_normal | 0 |
rows_affected_ps | 0 |
rows_skipped_normal | 0 |
rows_skipped_ps | 101 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 0 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 1 |
active_connections | 1 |
active_persistent_connections | 1 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 0 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_estrdup_count | 0 |
mem_strdup_count | 0 |
mem_edupl_count | 0 |
mem_dupl_count | 0 |
proto_text_fetched_null | 0 |
proto_text_fetched_bit | 0 |
proto_text_fetched_tinyint | 0 |
proto_text_fetched_short | 0 |
proto_text_fetched_int24 | 0 |
proto_text_fetched_int | 0 |
proto_text_fetched_bigint | 0 |
proto_text_fetched_decimal | 0 |
proto_text_fetched_float | 0 |
proto_text_fetched_double | 0 |
proto_text_fetched_date | 0 |
proto_text_fetched_year | 0 |
proto_text_fetched_time | 0 |
proto_text_fetched_datetime | 0 |
proto_text_fetched_timestamp | 0 |
proto_text_fetched_string | 0 |
proto_text_fetched_blob | 0 |
proto_text_fetched_enum | 0 |
proto_text_fetched_set | 0 |
proto_text_fetched_geometry | 0 |
proto_text_fetched_other | 0 |
proto_binary_fetched_null | 0 |
proto_binary_fetched_bit | 160 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 177 |
proto_binary_fetched_int24 | 49 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 702 |
proto_binary_fetched_decimal | 61 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 18 |
proto_binary_fetched_date | 30 |
proto_binary_fetched_year | 0 |
proto_binary_fetched_time | 0 |
proto_binary_fetched_datetime | 0 |
proto_binary_fetched_timestamp | 0 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 521 |
proto_binary_fetched_blob | 130 |
proto_binary_fetched_enum | 0 |
proto_binary_fetched_set | 0 |
proto_binary_fetched_geometry | 0 |
proto_binary_fetched_other | 0 |
init_command_executed_count | 0 |
init_command_failed_count | 0 |
com_quit | 0 |
com_init_db | 0 |
com_query | 2 |
com_field_list | 0 |
com_create_db | 0 |
com_drop_db | 0 |
com_refresh | 0 |
com_shutdown | 0 |
com_statistics | 0 |
com_process_info | 0 |
com_connect | 0 |
com_process_kill | 0 |
com_debug | 0 |
com_ping | 0 |
com_time | 0 |
com_delayed_insert | 0 |
com_change_user | 0 |
com_binlog_dump | 0 |
com_table_dump | 0 |
com_connect_out | 0 |
com_register_slave | 0 |
com_stmt_prepare | 22 |
com_stmt_execute | 22 |
com_stmt_send_long_data | 0 |
com_stmt_close | 21 |
com_stmt_reset | 0 |
com_stmt_set_option | 0 |
com_stmt_fetch | 0 |
com_deamon | 0 |
bytes_received_real_data_normal | 0 |
bytes_received_real_data_ps | 486225 |