SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')
Run Time: 0.000417
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 36 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 116
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 82
- XF\DataRegistry->get() in src/XF/App.php at line 1549
- XF\App->preLoadData() in src/XF/App.php at line 1539
- XF\App->setup() in src/XF/Pub/App.php at line 45
- XF\Pub\App->setup() in src/XF.php at line 317
- XF::setupApp() in src/XF.php at line 329
- XF::runApp() in index.php at line 13
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000204
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 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 36
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 908
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 225
- 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 117
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_draft_DraftThreads_2`.*, `xf_permission_cache_content_Permissions_3`.*
FROM `xf_forum`
INNER JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_draft` AS `xf_draft_DraftThreads_2` ON (`xf_draft_DraftThreads_2`.`draft_key` = CONCAT('forum-', `xf_forum`.`node_id`) AND `xf_draft_DraftThreads_2`.`user_id` = '0')
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_3` ON (`xf_permission_cache_content_Permissions_3`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_3`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_3`.`permission_combination_id` = '1')
WHERE (`xf_forum`.`node_id` = '294')
LIMIT 1
Run Time: 0.001772
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_draft_DraftThreads_2 | const | draft_key_user | draft_key_user | 81 | const,const | 0 | unique row not found |
SIMPLE | xf_permission_cache_content_Permissions_3 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1131
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Pub/Controller/Forum.php at line 1033
- XF\Pub\Controller\Forum->assertViewableForum() in src/XF/Pub/Controller/Forum.php at line 704
- XF\Pub\Controller\Forum->actionPostThread() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
-- 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\Forum, PostThread, valid, node_id=294, 1614701623,
Run Time: 0.000175
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- 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 67
- 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 278
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 271
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 89
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_captcha_question`.*
FROM `xf_captcha_question`
WHERE (`xf_captcha_question`.`active` = 1)
ORDER BY RAND() ASC
LIMIT 1
Run Time: 0.000506
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_captcha_question | ref | active | active | 1 | const | 2 | Using temporary; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1131
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Captcha/Question.php at line 15
- XF\Captcha\Question->renderInternal() in src/XF/Captcha/AbstractCaptcha.php at line 34
- XF\Captcha\AbstractCaptcha->render() in src/XF/Template/Templater.php at line 1911
- XF\Template\Templater->fnCaptcha()
- call_user_func_array() in src/XF/Template/Templater.php at line 881
- XF\Template\Templater->fn() in internal_data/code_cache/templates/l1/s8/public/forum_post_thread.php at line 93
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- 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 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
SELECT `xf_captcha_log`.*
FROM `xf_captcha_log`
WHERE (`xf_captcha_log`.`hash` = 'f9befc8c69489090f41982876f0bde2bb50e0ad2')
LIMIT 1
Run Time: 0.000185
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_captcha_log | const | PRIMARY | PRIMARY | 42 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1131
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Entity.php at line 744
- XF\Mvc\Entity\Entity->_verifyUniqueValue() in src/XF/Mvc/Entity/Entity.php at line 600
- XF\Mvc\Entity\Entity->set() in src/XF/Mvc/Entity/Entity.php at line 677
- XF\Mvc\Entity\Entity->bulkSet() in src/XF/Entity/CaptchaQuestion.php at line 40
- XF\Entity\CaptchaQuestion->insertHash() in src/XF/Entity/CaptchaQuestion.php at line 51
- XF\Entity\CaptchaQuestion->getHash() in src/XF/Mvc/Entity/Entity.php at line 142
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 100
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s8/public/captcha_question.php at line 30
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- XF\Template\Templater->renderTemplate() in src/XF/Captcha/Question.php at line 19
- XF\Captcha\Question->renderInternal() in src/XF/Captcha/AbstractCaptcha.php at line 34
- XF\Captcha\AbstractCaptcha->render() in src/XF/Template/Templater.php at line 1911
- XF\Template\Templater->fnCaptcha()
- call_user_func_array() in src/XF/Template/Templater.php at line 881
- XF\Template\Templater->fn() in internal_data/code_cache/templates/l1/s8/public/forum_post_thread.php at line 93
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- 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 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
BEGIN
Run Time: 0.000047
- XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 275
- XF\Db\AbstractAdapter->beginTransaction() in src/XF/Mvc/Entity/Entity.php at line 1134
- XF\Mvc\Entity\Entity->save() in src/XF/Entity/CaptchaQuestion.php at line 41
- XF\Entity\CaptchaQuestion->insertHash() in src/XF/Entity/CaptchaQuestion.php at line 51
- XF\Entity\CaptchaQuestion->getHash() in src/XF/Mvc/Entity/Entity.php at line 142
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 100
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s8/public/captcha_question.php at line 30
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- XF\Template\Templater->renderTemplate() in src/XF/Captcha/Question.php at line 19
- XF\Captcha\Question->renderInternal() in src/XF/Captcha/AbstractCaptcha.php at line 34
- XF\Captcha\AbstractCaptcha->render() in src/XF/Template/Templater.php at line 1911
- XF\Template\Templater->fnCaptcha()
- call_user_func_array() in src/XF/Template/Templater.php at line 881
- XF\Template\Templater->fn() in internal_data/code_cache/templates/l1/s8/public/forum_post_thread.php at line 93
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- 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 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
INSERT INTO `xf_captcha_log` (`hash`, `captcha_type`, `captcha_data`, `captcha_date`) VALUES (?, ?, ?, ?)
Params: f9befc8c69489090f41982876f0bde2bb50e0ad2, Question, 2, 1614701623
Run Time: 0.000214
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 161
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1409
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1141
- XF\Mvc\Entity\Entity->save() in src/XF/Entity/CaptchaQuestion.php at line 41
- XF\Entity\CaptchaQuestion->insertHash() in src/XF/Entity/CaptchaQuestion.php at line 51
- XF\Entity\CaptchaQuestion->getHash() in src/XF/Mvc/Entity/Entity.php at line 142
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 100
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s8/public/captcha_question.php at line 30
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- XF\Template\Templater->renderTemplate() in src/XF/Captcha/Question.php at line 19
- XF\Captcha\Question->renderInternal() in src/XF/Captcha/AbstractCaptcha.php at line 34
- XF\Captcha\AbstractCaptcha->render() in src/XF/Template/Templater.php at line 1911
- XF\Template\Templater->fnCaptcha()
- call_user_func_array() in src/XF/Template/Templater.php at line 881
- XF\Template\Templater->fn() in internal_data/code_cache/templates/l1/s8/public/forum_post_thread.php at line 93
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- 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 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
COMMIT
Run Time: 0.009227
- XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 297
- XF\Db\AbstractAdapter->commit() in src/XF/Mvc/Entity/Entity.php at line 1185
- XF\Mvc\Entity\Entity->save() in src/XF/Entity/CaptchaQuestion.php at line 41
- XF\Entity\CaptchaQuestion->insertHash() in src/XF/Entity/CaptchaQuestion.php at line 51
- XF\Entity\CaptchaQuestion->getHash() in src/XF/Mvc/Entity/Entity.php at line 142
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 100
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l1/s8/public/captcha_question.php at line 30
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- XF\Template\Templater->renderTemplate() in src/XF/Captcha/Question.php at line 19
- XF\Captcha\Question->renderInternal() in src/XF/Captcha/AbstractCaptcha.php at line 34
- XF\Captcha\AbstractCaptcha->render() in src/XF/Template/Templater.php at line 1911
- XF\Template\Templater->fnCaptcha()
- call_user_func_array() in src/XF/Template/Templater.php at line 881
- XF\Template\Templater->fn() in internal_data/code_cache/templates/l1/s8/public/forum_post_thread.php at line 93
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1250
- 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 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1934
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13
-- XFDB=noForceAllWrite
INSERT INTO xf_session
(session_id, session_data, expiry_date)
VALUES
(?, ?, ?)
ON DUPLICATE KEY UPDATE
session_data = VALUES(session_data),
expiry_date = VALUES(expiry_date)
Params: L86JkYc1latiZEoQ8-cGgelTTG_p5mRO, , 1614716023
Run Time: 0.000155
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Session/DbStorage.php at line 57
- XF\Session\DbStorage->writeSession() in src/XF/Session/Session.php at line 215
- XF\Session\Session->save() in src/XF/Pub/App.php at line 373
- XF\Pub\App->complete() in src/XF/App.php at line 1937
- XF\App->run() in src/XF.php at line 333
- XF::runApp() in index.php at line 13