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', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')
Run Time: 0.000551
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 41 | 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 1862
- XF\App->preLoadData() in src/XF/App.php at line 1850
- XF\App->setup() in src/XF/Pub/App.php at line 91
- XF\Pub\App->setup() in src/XF.php at line 437
- XF::setupApp() in src/XF.php at line 460
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_profile_Profile_2`.*
FROM `xf_user`
INNER JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` IN (662487, 662510, 662502, 662637, 662588, 662486, 662509, 662522, 662499, 662504, 662528, 662498, 662490, 662491, 662500, 662508, 662986, 662548, 662488, 662483, 662481, 662506, 662552, 44024, 662523, 662525, 662943, 662501, 662511, 662484, 662520, 662493, 662492, 662517, 662538, 662497, 662507, 662683, 662559, 662485, 662494, 662495, 662526, 662503, 662505, 662567, 662482, 662968, 662634, 662512, 662515, 662539, 484318, 662685, 662518, 662527, 662565, 662496, 662536, 345054, 662535, 662489, 662513, 662682, 230775, 283418, 1, 141690, 43763, 498869, 487232, 487238, 487222, 530634, 499422, 509288, 487230, 505844, 545479, 501025, 503886, 522712, 498853, 527582, 501024, 530628, 498552, 498828, 569079, 539602, 536517, 539633, 505845, 587807, 531266, 501178, 486776, 543889, 569128, 498555, 548086, 512171, 515074, 501174, 498855, 594449, 499426, 501051, 498450, 528488, 498572, 514048, 502515, 486911, 558365, 507508, 545481, 569122, 584529, 501196, 662435, 662148, 577345, 650285, 569121, 501527, 507509, 578595, 583270)) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
Run Time: 0.002958
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | ref | PRIMARY,user_state | user_state | 1 | const | 286 | Using index condition; Using where |
SIMPLE | xf_user_option_Option_1 | eq_ref | PRIMARY | PRIMARY | 4 | labgame.xf_user.user_id | 1 | |
SIMPLE | xf_user_profile_Profile_2 | eq_ref | PRIMARY | PRIMARY | 4 | labgame.xf_user.user_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 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Member.php at line 132
- XF\Pub\Controller\Member->actionIndex() 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 2300
- XF\App->run() in src/XF.php at line 464
- 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, e<, e<, XF\Pub\Controller\Member, Index, valid, , 1714823417,
Run Time: 0.000099
- 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 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 42
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 287
- 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 2300
- XF\App->run() in src/XF.php at line 464
- XF::runApp() in index.php at line 20