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.001914
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 34 | 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 137
- 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.000162
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 88
- 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 data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('reactions')
Run Time: 0.000120
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 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 137
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 82
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 225
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1442
- XF\App->XF\{closure}() in src/XF/Container.php at line 28
- XF\Container->offsetGet() in src/XF/App.php at line 2761
- XF\App->container() in src/addons/ThemeHouse/Reactions/React/AbstractHandler.php at line 28
- ThemeHouse\Reactions\React\AbstractHandler->__construct() in src/addons/ThemeHouse/Reactions/Repository/ReactHandler.php at line 28
- ThemeHouse\Reactions\Repository\ReactHandler->getReactHandlers() in src/addons/ThemeHouse/Reactions/Repository/ReactHandler.php at line 100
- ThemeHouse\Reactions\Repository\ReactHandler->getReactHandlerByType() in src/addons/ThemeHouse/Reactions/Pub/Controller/React.php at line 212
- ThemeHouse\Reactions\Pub\Controller\React->buildContentEntity() in src/addons/ThemeHouse/Reactions/Pub/Controller/React.php at line 125
- ThemeHouse\Reactions\Pub\Controller\React->actionList() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- 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 reaction_id, COUNT(*) AS count
FROM xf_th_reacted_content
WHERE react_user_id = ?
AND react_date >= ?
GROUP BY reaction_id
Params: 0, 1715262441
Run Time: 0.000211
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_th_reacted_content | ref|filter | react_user_content_type_id,react_date | react_user_content_type_id|react_date | 4|4 | const | 1 (1%) | Using where; Using temporary; Using filesort; Using rowid filter |
- 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/addons/ThemeHouse/Reactions/Repository/ReactedContent.php at line 506
- ThemeHouse\Reactions\Repository\ReactedContent->getUserReactCountDaily() in src/addons/ThemeHouse/Reactions/React/AbstractHandler.php at line 56
- ThemeHouse\Reactions\React\AbstractHandler->buildGlobalData() in src/addons/ThemeHouse/Reactions/React/AbstractHandler.php at line 31
- ThemeHouse\Reactions\React\AbstractHandler->__construct() in src/addons/ThemeHouse/Reactions/Repository/ReactHandler.php at line 28
- ThemeHouse\Reactions\Repository\ReactHandler->getReactHandlers() in src/addons/ThemeHouse/Reactions/Repository/ReactHandler.php at line 100
- ThemeHouse\Reactions\Repository\ReactHandler->getReactHandlerByType() in src/addons/ThemeHouse/Reactions/Pub/Controller/React.php at line 212
- ThemeHouse\Reactions\Pub\Controller\React->buildContentEntity() in src/addons/ThemeHouse/Reactions/Pub/Controller/React.php at line 125
- ThemeHouse\Reactions\Pub\Controller\React->actionList() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- 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_post`.*, `xf_thread_Thread_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_post`
LEFT JOIN `xf_thread` AS `xf_thread_Thread_1` ON (`xf_thread_Thread_1`.`thread_id` = `xf_post`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread_Thread_1`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_post`.`post_id` = '7433')
LIMIT 1
Run Time: 0.000620
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_Thread_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | 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 1130
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/App.php at line 2294
- XF\App->findByContentType() in src/addons/ThemeHouse/Reactions/React/AbstractHandler.php at line 575
- ThemeHouse\Reactions\React\AbstractHandler->getContent() in src/addons/ThemeHouse/Reactions/Pub/Controller/React.php at line 214
- ThemeHouse\Reactions\Pub\Controller\React->buildContentEntity() in src/addons/ThemeHouse/Reactions/Pub/Controller/React.php at line 125
- ThemeHouse\Reactions\Pub\Controller\React->actionList() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- 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_th_reacted_content`.*, `xf_user_Owner_1`.*
FROM `xf_th_reacted_content`
LEFT JOIN `xf_user` AS `xf_user_Owner_1` ON (`xf_user_Owner_1`.`user_id` = `xf_th_reacted_content`.`content_user_id`)
WHERE (`xf_th_reacted_content`.`reaction_id` = 0 AND `xf_th_reacted_content`.`content_type` = 'post' AND `xf_th_reacted_content`.`content_id` = 7433 AND `xf_th_reacted_content`.`react_user_id` = 0)
LIMIT 1
Run Time: 0.000373
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_th_reacted_content | ref | content_type_id_react_user_id,react_user_content_type_id | content_type_id_react_user_id | 35 | const,const,const | 1 | Using index condition; Using where |
SIMPLE | xf_user_Owner_1 | eq_ref | PRIMARY | PRIMARY | 4 | runicp5_xenforo.xf_th_reacted_content.content_user_id | 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 1130
- XF\Mvc\Entity\Finder->fetchOne() in src/addons/ThemeHouse/Reactions/Repository/ReactedContent.php at line 45
- ThemeHouse\Reactions\Repository\ReactedContent->getReactByReactionContentReactor() in src/addons/ThemeHouse/Reactions/Repository/ReactedContent.php at line 214
- ThemeHouse\Reactions\Repository\ReactedContent->buildReactedContent() in src/addons/ThemeHouse/Reactions/Pub/Controller/React.php at line 127
- ThemeHouse\Reactions\Pub\Controller\React->actionList() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- 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_th_reacted_content`.*, `xf_user_Owner_1`.*, `xf_user_Reactor_2`.*, `xf_th_reaction_Reaction_3`.*
FROM `xf_th_reacted_content`
LEFT JOIN `xf_user` AS `xf_user_Owner_1` ON (`xf_user_Owner_1`.`user_id` = `xf_th_reacted_content`.`content_user_id`)
LEFT JOIN `xf_user` AS `xf_user_Reactor_2` ON (`xf_user_Reactor_2`.`user_id` = `xf_th_reacted_content`.`react_user_id`)
LEFT JOIN `xf_th_reaction` AS `xf_th_reaction_Reaction_3` ON (`xf_th_reaction_Reaction_3`.`reaction_id` = `xf_th_reacted_content`.`reaction_id`)
WHERE (`xf_th_reacted_content`.`content_type` = 'post' AND `xf_th_reacted_content`.`content_id` = 7433 AND `xf_th_reacted_content`.`is_counted` = 1)
ORDER BY `xf_th_reacted_content`.`react_date` DESC
LIMIT 51
Run Time: 0.000748
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_th_reacted_content | ref | content_type_id_react_user_id | content_type_id_react_user_id | 31 | const,const | 1 | Using index condition; Using where; Using filesort |
SIMPLE | xf_user_Owner_1 | eq_ref | PRIMARY | PRIMARY | 4 | runicp5_xenforo.xf_th_reacted_content.content_user_id | 1 | |
SIMPLE | xf_user_Reactor_2 | eq_ref | PRIMARY | PRIMARY | 4 | runicp5_xenforo.xf_th_reacted_content.react_user_id | 1 | |
SIMPLE | xf_th_reaction_Reaction_3 | eq_ref | PRIMARY | PRIMARY | 4 | runicp5_xenforo.xf_th_reacted_content.reaction_id | 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 1163
- XF\Mvc\Entity\Finder->fetch() in src/addons/ThemeHouse/Reactions/ControllerPlugin/React.php at line 91
- ThemeHouse\Reactions\ControllerPlugin\React->actionList() in src/addons/ThemeHouse/Reactions/Pub/Controller/React.php at line 134
- ThemeHouse\Reactions\Pub\Controller\React->actionList() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- 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 data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('reactionTypes')
Run Time: 0.000103
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 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 137
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 82
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 225
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1442
- XF\App->XF\{closure}() in src/XF/Container.php at line 28
- XF\Container->offsetGet() in src/XF/App.php at line 2761
- XF\App->container() in src/addons/ThemeHouse/Reactions/Repository/ReactedContent.php at line 521
- ThemeHouse\Reactions\Repository\ReactedContent->sortReactsByType() in src/addons/ThemeHouse/Reactions/ControllerPlugin/React.php at line 100
- ThemeHouse\Reactions\ControllerPlugin\React->actionList() in src/addons/ThemeHouse/Reactions/Pub/Controller/React.php at line 134
- ThemeHouse\Reactions\Pub\Controller\React->actionList() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- 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, "