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.000598
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 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 1509
- XF\App->preLoadData() in src/XF/App.php at line 1499
- XF\App->setup() in src/XF/Pub/App.php at line 45
- XF\Pub\App->setup() in src/XF.php at line 312
- XF::setupApp() in src/XF.php at line 324
- XF::runApp() in index.php at line 13
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('mjcCurrencies')
Run Time: 0.000094
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 1402
- XF\App->XF\{closure}() in src/XF/Container.php at line 28
- XF\Container->offsetGet() in src/XF/App.php at line 2716
- XF\App->container() in src/addons/MJ/Credits/Listener.php at line 67
- MJ\Credits\Listener::userEntityStructure()
- call_user_func_array() in src/XF/Extension.php at line 50
- XF\Extension->fire() in src/XF/Mvc/Entity/Manager.php at line 76
- XF\Mvc\Entity\Manager->getEntityStructure() in src/XF/Repository/User.php at line 57
- XF\Repository\User->getGuestUser() in src/XF/Repository/User.php at line 31
- XF\Repository\User->getVisitor() in src/XF/App.php at line 1523
- XF\App->getVisitorFromSession() in src/XF/Pub/App.php at line 97
- XF\Pub\App->start() in src/XF/App.php at line 1885
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000089
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 915
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 224
- 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 1889
- XF\App->run() in src/XF.php at line 328
- 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` = '13216')
LIMIT 1
Run Time: 0.000939
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 1116
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Post.php at line 413
- XF\Pub\Controller\Post->assertViewablePost() in src/XF/Pub/Controller/Post.php at line 362
- XF\Pub\Controller\Post->actionLikes() 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 1889
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_liked_content`.*, `xf_user_Liker_1`.*
FROM `xf_liked_content`
LEFT JOIN `xf_user` AS `xf_user_Liker_1` ON (`xf_user_Liker_1`.`user_id` = `xf_liked_content`.`like_user_id`)
WHERE (`xf_liked_content`.`content_type` = 'post' AND `xf_liked_content`.`content_id` = 13216)
ORDER BY `xf_liked_content`.`like_date` DESC
LIMIT 51
Run Time: 0.001352
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_liked_content | ref | content_type_id_like_user_id | content_type_id_like_user_id | 31 | const,const | 1 | Using index condition; Using where; Using filesort |
SIMPLE | xf_user_Liker_1 | eq_ref | PRIMARY | PRIMARY | 4 | intmokwrhosting_thaoluanxoso.xf_liked_content.like_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 1149
- XF\Mvc\Entity\Finder->fetch() in src/XF/ControllerPlugin/Like.php at line 78
- XF\ControllerPlugin\Like->actionLikes() in src/XF/Pub/Controller/Post.php at line 372
- XF\Pub\Controller\Post->actionLikes() 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 1889
- XF\App->run() in src/XF.php at line 328
- 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\Post, Likes, valid, post_id=13216, 1715585992,
Run Time: 0.000125
- 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 65
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 40
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 270
- 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 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 1889
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('members_who_liked_message_x')
Params: 2
Run Time: 0.000281
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,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/Language.php at line 351
- XF\Language->loadPhrases() in src/XF/Language.php at line 249
- XF\Language->getPhraseText() in src/XF/Language.php at line 167
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 52
- XF\Phrase->render() in src/XF/Phrase.php at line 59
- XF\Phrase->__toString() in src/XF.php at line 771
- XF::escapeString() in src/XF/Template/Templater.php at line 945
- XF\Template\Templater->escape() in internal_data/code_cache/templates/l2/s1/public/like_list.php at line 9
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1246
- 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 1889
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_user_profile`.*
FROM `xf_user_profile`
WHERE (`xf_user_profile`.`user_id` = 170)
LIMIT 1
Run Time: 0.000266
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_profile | 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/Mvc/Entity/Finder.php at line 1116
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 352
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 373
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 171
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 95
- XF\Mvc\Entity\Entity->__get() in src/XF/Template/Templater.php at line 3060
- XF\Template\Templater->fnUserBlurb()
- call_user_func_array() in src/XF/Template/Templater.php at line 877
- XF\Template\Templater->fn() in internal_data/code_cache/templates/l2/s1/public/member_list_macros.php at line 31
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 659
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/like_list.php at line 46
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1246
- 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 1889
- XF\App->run() in src/XF.php at line 328
- 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: 2RmV1YApLDiAuvqXiO6LZecGrNpsaWt3, , 1715600392
Run Time: 0.000248
- 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 360
- XF\Pub\App->complete() in src/XF/App.php at line 1892
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13