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.000514
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 38 | 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 139
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/App.php at line 1906
- XF\App->preLoadData() in src/XF/App.php at line 1894
- XF\App->setup() in src/XF/Pub/App.php at line 93
- XF\Pub\App->setup() in src/XF.php at line 497
- XF::setupApp() in src/XF.php at line 520
- 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 (35349, 35203, 34734, 34733, 34709, 34681, 34667, 34659, 34657, 34656, 34655, 34654, 34653, 34652, 34651, 34650, 34649, 34647, 34646, 34645, 34644, 34643, 34642, 34641, 34640, 34635, 34632, 34631, 34628, 34627, 34626, 34625, 34624, 34623, 34622, 34621, 34620, 34619, 34618, 34613, 34612, 34611, 34610, 34609, 34608, 34607, 34606, 34605, 34603, 34602, 34601, 34600, 34599, 34598, 34597, 34596, 34593, 34592, 34591, 34590, 34589, 34588, 34587, 34586, 34584, 34583, 34582, 34581, 34580, 34579, 34578, 34576, 34558, 34557, 34528, 34526, 34517, 34516, 34506, 34505, 34504, 34503, 34501, 14309))
Run Time: 0.001742
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 84 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | nailclub_xfdb.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,nailclub_xfdb.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 1392
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2730
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- 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 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 259
- 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 2352
- XF\App->run() in src/XF.php at line 524
- 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: 240, 0, 1716304998, {"thread-35349":["thread",35349],"thread-35203":["thread",35203],"thread-34734":["thread",34734],"thread-34733":["thread",34733],"thread-34709":["thread",34709],"thread-34681":["thread",34681],"thread-34667":["thread",34667],"thread-34659":["thread",34659],"thread-34657":["thread",34657],"thread-34656":["thread",34656],"thread-34655":["thread",34655],"thread-34654":["thread",34654],"thread-34653":["thread",34653],"thread-34652":["thread",34652],"thread-34651":["thread",34651],"thread-34650":["thread",34650],"thread-34649":["thread",34649],"thread-34647":["thread",34647],"thread-34646":["thread",34646],"thread-34645":["thread",34645],"thread-34644":["thread",34644],"thread-34643":["thread",34643],"thread-34642":["thread",34642],"thread-34641":["thread",34641],"thread-34640":["thread",34640],"thread-34635":["thread",34635],"thread-34632":["thread",34632],"thread-34631":["thread",34631],"thread-34628":["thread",34628],"thread-34627":["thread",34627],"thread-34626":["thread",34626],"thread-34625":["thread",34625],"thread-34624":["thread",34624],"thread-34623":["thread",34623],"thread-34622":["thread",34622],"thread-34621":["thread",34621],"thread-34620":["thread",34620],"thread-34619":["thread",34619],"thread-34618":["thread",34618],"thread-34613":["thread",34613],"thread-34612":["thread",34612],"thread-34611":["thread",34611],"thread-34610":["thread",34610],"thread-34609":["thread",34609],"thread-34608":["thread",34608],"thread-34607":["thread",34607],"thread-34606":["thread",34606],"thread-34605":["thread",34605],"thread-34603":["thread",34603],"thread-34602":["thread",34602],"thread-34601":["thread",34601],"thread-34600":["thread",34600],"thread-34599":["thread",34599],"thread-34598":["thread",34598],"thread-34597":["thread",34597],"thread-34596":["thread",34596],"thread-34593":["thread",34593],"thread-34592":["thread",34592],"thread-34591":["thread",34591],"thread-34590":["thread",34590],"thread-34589":["thread",34589],"thread-34588":["thread",34588],"thread-34587":["thread",34587],"thread-34586":["thread",34586],"thread-34584":["thread",34584],"thread-34583":["thread",34583],"thread-34582":["thread",34582],"thread-34581":["thread",34581],"thread-34580":["thread",34580],"thread-34579":["thread",34579],"thread-34578":["thread",34578],"thread-34576":["thread",34576],"thread-34558":["thread",34558],"thread-34557":["thread",34557],"thread-34528":["thread",34528],"thread-34526":["thread",34526],"thread-34517":["thread",34517],"thread-34516":["thread",34516],"thread-34506":["thread",34506],"thread-34505":["thread",34505],"thread-34504":["thread",34504],"thread-34503":["thread",34503],"thread-34501":["thread",34501],"thread-14309":["thread",14309]}, NULL, 1716301398
Run Time: 0.000127
- 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 220
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- 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 259
- 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 2352
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20