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', 'paymentProvider', '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.005561
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 39 | 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 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 166
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 99
- XF\DataRegistry->get() in src/XF/App.php at line 2092
- XF\App->preLoadData() in src/XF/App.php at line 2077
- XF\App->setup() in src/XF/Pub/App.php at line 95
- XF\Pub\App->setup() in src/XF.php at line 505
- XF::setupApp() in src/XF.php at line 528
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000107
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 1244
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 245
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 23
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 129
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_liamw_accountdelete_account_deletions`.*, `xf_user_User_1`.*
FROM `xf_liamw_accountdelete_account_deletions`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_liamw_accountdelete_account_deletions`.`user_id`)
WHERE (`xf_liamw_accountdelete_account_deletions`.`user_id` = 0) AND (`xf_liamw_accountdelete_account_deletions`.`status` = 'pending')
LIMIT 1
Run Time: 0.000257
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_liamw_accountdelete_account_deletions | ref | user_id | user_id | 4 | const | 1 | Using where |
SIMPLE | xf_user_User_1 | 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 1404
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 390
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 415
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 207
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 130
- XF\Mvc\Entity\Entity->__get() in src/addons/LiamW/AccountDelete/Listener.php at line 43
- LiamW\AccountDelete\Listener::controllerPreDispatch() in src/XF/Extension.php at line 49
- XF\Extension->fire() in src/XF/App.php at line 3138
- XF\App->fire() in src/XF/Mvc/Controller.php at line 131
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_tag`.*
FROM `xf_tag`
WHERE (`xf_tag`.`tag_url` = 'xenforo-150')
LIMIT 1
Run Time: 0.000093
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag | const | tag_url | tag_url | 402 | 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 1404
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Pub/Controller/Tag.php at line 117
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_tag_result_cache`.*
FROM `xf_tag_result_cache`
WHERE (`xf_tag_result_cache`.`tag_id` = 5 AND `xf_tag_result_cache`.`user_id` = 0)
LIMIT 1
Run Time: 0.002928
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag_result_cache | const | tag_id_user_id | tag_id_user_id | 8 | const,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 1404
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Repository/Tag.php at line 697
- XF\Repository\Tag->getTagResultCache() in src/XF/Pub/Controller/Tag.php at line 133
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT content_type, content_id
FROM xf_tag_content
WHERE tag_id = ?
AND visible = 1
ORDER BY content_date DESC
LIMIT 200
Params: 5
Run Time: 0.000127
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag_content | ref | tag_id_content_date | tag_id_content_date | 4 | const | 95 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/Tag.php at line 662
- XF\Repository\Tag->getTagSearchResults() in src/XF/Pub/Controller/Tag.php at line 137
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_post_FirstPost_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (53018, 52929, 52106, 52085, 52084, 48058, 47235, 47233, 47218, 47217, 47216, 47215, 47211, 47194, 47193, 47189, 47187, 47179, 47178, 47174, 47167, 47165, 47164, 47161, 47153, 47135, 47134, 47119, 47117, 47113, 47088, 47072, 47067, 47056, 47054, 46899, 46815, 46777, 46687, 46673, 46668, 46617, 46616, 46601, 46566, 46563, 46549, 46547, 46515, 46513, 46508, 46505, 46489, 46487, 46486, 46455, 46452, 46451, 46443, 46436, 46429, 46425, 46424, 46423, 46420, 46419, 46418, 46416, 46409, 46405, 46401, 46390, 46388, 46386, 46383, 46380, 46378, 46375, 46372, 46371, 46370, 46369, 46363, 46362, 46360, 46358, 46356, 46344, 46342, 46341, 46337))
Run Time: 0.097819
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 91 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thxforg_thxf.xf_node_Node_2.node_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 1437
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 224
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 3010
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 77
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 731
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 138
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_rm_resource`.*, `xf_rm_category_Category_1`.*, `xf_user_User_2`.*, `xf_rm_resource_update_Description_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_rm_resource`
LEFT JOIN `xf_rm_category` AS `xf_rm_category_Category_1` ON (`xf_rm_category_Category_1`.`resource_category_id` = `xf_rm_resource`.`resource_category_id`)
LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_rm_resource`.`user_id`)
LEFT JOIN `xf_rm_resource_update` AS `xf_rm_resource_update_Description_3` ON (`xf_rm_resource_update_Description_3`.`resource_update_id` = `xf_rm_resource`.`description_update_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_rm_category_Category_1`.`resource_category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_rm_resource`.`resource_id` IN (61, 57, 30, 28))
Run Time: 0.029472
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 4 | Using where |
SIMPLE | xf_rm_category_Category_1 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_rm_resource.resource_category_id | 1 | |
SIMPLE | xf_user_User_2 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_rm_resource.user_id | 1 | |
SIMPLE | xf_rm_resource_update_Description_3 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_rm_resource.description_update_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thxforg_thxf.xf_rm_category_Category_1.resource_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 1437
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 224
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 3010
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 77
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 731
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 138
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
BEGIN
Run Time: 0.000132
- XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 383
- XF\Db\AbstractAdapter->beginTransaction() in src/XF/Mvc/Entity/Entity.php at line 1283
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 5, 0, 1711699703, {"thread-53018":["thread",53018],"thread-52929":["thread",52929],"thread-52106":["thread",52106],"thread-52085":["thread",52085],"thread-52084":["thread",52084],"thread-48058":["thread",48058],"resource-61":["resource",61],"resource-57":["resource",57],"resource-30":["resource",30],"thread-47235":["thread",47235],"thread-47233":["thread",47233],"thread-47218":["thread",47218],"thread-47217":["thread",47217],"thread-47216":["thread",47216],"thread-47215":["thread",47215],"thread-47211":["thread",47211],"thread-47194":["thread",47194],"thread-47193":["thread",47193],"thread-47189":["thread",47189],"thread-47187":["thread",47187],"thread-47179":["thread",47179],"thread-47178":["thread",47178],"thread-47174":["thread",47174],"thread-47167":["thread",47167],"thread-47165":["thread",47165],"thread-47164":["thread",47164],"thread-47161":["thread",47161],"thread-47135":["thread",47135],"thread-47134":["thread",47134],"thread-47119":["thread",47119],"thread-47117":["thread",47117],"thread-47113":["thread",47113],"thread-47088":["thread",47088],"thread-47072":["thread",47072],"thread-47067":["thread",47067],"thread-47056":["thread",47056],"thread-47054":["thread",47054],"thread-46899":["thread",46899],"thread-46815":["thread",46815],"thread-46777":["thread",46777],"thread-46687":["thread",46687],"thread-46673":["thread",46673],"thread-46668":["thread",46668],"thread-46617":["thread",46617],"thread-46616":["thread",46616],"thread-46601":["thread",46601],"thread-46566":["thread",46566],"thread-46563":["thread",46563],"thread-46549":["thread",46549],"thread-46547":["thread",46547],"thread-46515":["thread",46515],"thread-46513":["thread",46513],"thread-46508":["thread",46508],"thread-46505":["thread",46505],"thread-46489":["thread",46489],"thread-46487":["thread",46487],"thread-46486":["thread",46486],"thread-46455":["thread",46455],"thread-46452":["thread",46452],"thread-46451":["thread",46451],"thread-46443":["thread",46443],"thread-46436":["thread",46436],"thread-46429":["thread",46429],"thread-46425":["thread",46425],"thread-46424":["thread",46424],"thread-46423":["thread",46423],"thread-46420":["thread",46420],"thread-46419":["thread",46419],"thread-46418":["thread",46418],"thread-46416":["thread",46416],"thread-46409":["thread",46409],"thread-46405":["thread",46405],"thread-46401":["thread",46401],"thread-46390":["thread",46390],"thread-46388":["thread",46388],"thread-46386":["thread",46386],"thread-46383":["thread",46383],"thread-46380":["thread",46380],"thread-46378":["thread",46378],"thread-46375":["thread",46375],"thread-46372":["thread",46372],"thread-46371":["thread",46371],"thread-46370":["thread",46370],"thread-46369":["thread",46369],"thread-46363":["thread",46363],"thread-46362":["thread",46362],"thread-46360":["thread",46360],"thread-46358":["thread",46358],"thread-46356":["thread",46356],"thread-46344":["thread",46344],"thread-46342":["thread",46342],"thread-46341":["thread",46341],"thread-46337":["thread",46337]}, NULL, 1711696103
Run Time: 0.007732
- 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 219
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1558
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1290
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
COMMIT
Run Time: 0.000147
- XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 405
- XF\Db\AbstractAdapter->commit() in src/XF/Mvc/Entity/Entity.php at line 1334
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, "ɭ�
Run Time: 0.004778
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,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/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/XenConcept/LoginAsUser/XF/Repository/SessionActivity.php at line 48
- XenConcept\LoginAsUser\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 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 363
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
INSERT IGNORE INTO xf_session_activity (
ip,
controller_name,
controller_action,
view_state,
params,
view_date,
robot_key,
user_id,
unique_key
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: "ɭ�, XF\Pub\Controller\Tag, Tag, valid, tag_url=xenforo-150, 1711696103, , 0, "ɭ�
Run Time: 0.001907
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 218
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/XenConcept/LoginAsUser/XF/Repository/SessionActivity.php at line 48
- XenConcept\LoginAsUser\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 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 363
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, "ɭ�
Run Time: 0.005791
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,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/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/XenConcept/LoginAsUser/XF/Repository/SessionActivity.php at line 53
- XenConcept\LoginAsUser\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 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 363
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- 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 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('xfrmPrefixes')
Run Time: 0.000208
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 166
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 99
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 268
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1980
- XF\App->XF\{closure}() in src/XF/Container.php at line 31
- XF\Container->offsetGet() in src/XF/App.php at line 3653
- XF\App->container() in src/addons/SV/MultiPrefix/XF/Template/Templater.php at line 216
- SV\MultiPrefix\XF\Template\Templater->fnSvPrefix() in src/XF/Template/Templater.php at line 1189
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/search_result_resource.php at line 16
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1753
- XF\Template\Templater->renderTemplate() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->renderResult() in src/XF/Tag/RenderWrapper.php at line 30
- XF\Tag\RenderWrapper->render() in src/XF/Template/Templater.php at line 1252
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s1/public/tag_view.php at line 91
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1753
- 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 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 461
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 443
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_rm_resource_version`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_version`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_version`.`resource_id`)
WHERE (`xf_rm_resource_version`.`resource_version_id` = 72)
LIMIT 1
Run Time: 0.003828
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_version | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_resource_Resource_1 | 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 1404
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 157
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 383
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 415
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 207
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 136
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l2/s1/public/search_result_resource.php at line 20
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1753
- XF\Template\Templater->renderTemplate() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->renderResult() in src/XF/Tag/RenderWrapper.php at line 30
- XF\Tag\RenderWrapper->render() in src/XF/Template/Templater.php at line 1252
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s1/public/tag_view.php at line 91
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1753
- 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 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 461
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 443
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_rm_resource_version`.*, `xf_rm_resource_Resource_1`.*
FROM `xf_rm_resource_version`
LEFT JOIN `xf_rm_resource` AS `xf_rm_resource_Resource_1` ON (`xf_rm_resource_Resource_1`.`resource_id` = `xf_rm_resource_version`.`resource_id`)
WHERE (`xf_rm_resource_version`.`resource_version_id` = 75)
LIMIT 1
Run Time: 0.000439
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource_version | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_rm_resource_Resource_1 | 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 1404
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 157
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 383
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 415
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 207
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 136
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l2/s1/public/search_result_resource.php at line 20
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1753
- XF\Template\Templater->renderTemplate() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->renderResult() in src/XF/Tag/RenderWrapper.php at line 30
- XF\Tag\RenderWrapper->render() in src/XF/Template/Templater.php at line 1252
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s1/public/tag_view.php at line 91
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1753
- 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 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 461
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 443
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_addon`.*
FROM `xf_addon`
WHERE (`xf_addon`.`addon_id` = 'Tapatalk')
LIMIT 1
Run Time: 0.000077
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_addon | const | PRIMARY | PRIMARY | 52 | 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 1404
- XF\Mvc\Entity\Finder->fetchOne() in src/addons/Tapatalk/Listener/Hook.php at line 22
- Tapatalk\Listener\Hook::templateHook() in src/XF/Extension.php at line 49
- XF\Extension->fire() in src/XF/App.php at line 3138
- XF\App->fire() in src/XF/Template/Templater.php at line 1712
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 590
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2363
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
bytes_sent | 16382 |
bytes_received | 2601001 |
packets_sent | 188 |
packets_received | 1719 |
protocol_overhead_in | 6876 |
protocol_overhead_out | 752 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 594 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 208 |
bytes_received_prepare_response_packet | 103347 |
bytes_received_change_user_packet | 2496128 |
packets_sent_command | 93 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 66 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 34 |
packets_received_prepare_response | 1297 |
packets_received_change_user | 290 |
result_set_queries | 28 |
non_result_set_queries | 6 |
no_index_used | 0 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 28 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 29 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 262 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 262 |
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 | 0 |
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 | 27 |
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 | 431 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 2094 |
proto_binary_fetched_int24 | 762 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 7235 |
proto_binary_fetched_decimal | 26 |
proto_binary_fetched_float | 6 |
proto_binary_fetched_double | 297 |
proto_binary_fetched_date | 0 |
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 | 3238 |
proto_binary_fetched_blob | 1876 |
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 | 4 |
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 | 30 |
com_stmt_execute | 30 |
com_stmt_send_long_data | 0 |
com_stmt_close | 29 |
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 | 2486917 |