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.001331
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 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 1898
- XF\App->preLoadData() in src/XF/App.php at line 1886
- XF\App->setup() in src/XF/Pub/App.php at line 91
- XF\Pub\App->setup() in src/XF.php at line 461
- XF::setupApp() in src/XF.php at line 484
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('dbtCreditsCurrencies')
Run Time: 0.000182
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 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/DataRegistry.php at line 226
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1789
- XF\App->XF\{closure}() in src/XF/Container.php at line 28
- XF\Container->offsetGet() in src/addons/DBTech/Credits/XF/Entity/User.php at line 179
- DBTech\Credits\XF\Entity\User::getStructure() in src/addons/XFRM/XF/Entity/User.php at line 38
- XFRM\XF\Entity\User::getStructure() in src/XF/Mvc/Entity/Manager.php at line 70
- XF\Mvc\Entity\Manager->getEntityStructure() in src/XF/Repository/User.php at line 85
- XF\Repository\User->getGuestUser() in src/XF/Repository/User.php at line 31
- XF\Repository\User->getVisitor() in src/XF/App.php at line 1912
- XF\App->getVisitorFromSession() in src/XF/Pub/App.php at line 156
- XF\Pub\App->start() in src/XF/App.php at line 2333
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000199
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1176
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 242
- 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 123
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 349
- 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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_thread`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`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_thread`.`thread_id` = '651')
LIMIT 1
Run Time: 0.000804
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_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 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1346
- 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/Thread.php at line 1704
- XF\Pub\Controller\Thread->assertViewableThread() in src/XF/Pub/Controller/Thread.php at line 15
- XF\Pub\Controller\Thread->actionIndex() in src/addons/TB/BenzerKonular/XF/Pub/Controller/Thread.php at line 11
- TB\BenzerKonular\XF\Pub\Controller\Thread->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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_user_User_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*, `xf_user_privacy_Privacy_4`.*, `xf_permission_combination_PermissionCombination_5`.*, `xf_session_activity_Activity_6`.*
FROM `xf_post`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_4` ON (`xf_user_privacy_Privacy_4`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_permission_combination` AS `xf_permission_combination_PermissionCombination_5` ON (`xf_permission_combination_PermissionCombination_5`.`permission_combination_id` = `xf_user_User_1`.`permission_combination_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_6` ON (`xf_session_activity_Activity_6`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_6`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, ''))
WHERE (`xf_post`.`thread_id` = 651) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 20)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Run Time: 0.001075
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | ref | thread_id_post_date,thread_id_position,thread_id_score_date | thread_id_post_date | 4 | const | 1 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_permission_combination_PermissionCombination_5 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_user_User_1.permission_combination_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_6 | eq_ref | PRIMARY | PRIMARY | 22 | muhen_fmrnd.xf_user_User_1.user_id,func | 1 | Using where |
- 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/Thread.php at line 63
- XF\Pub\Controller\Thread->actionIndex() in src/addons/TB/BenzerKonular/XF/Pub/Controller/Thread.php at line 11
- TB\BenzerKonular\XF\Pub\Controller\Thread->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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_dbtech_credits_event`.*
FROM `xf_dbtech_credits_event`
WHERE (`xf_dbtech_credits_event`.`event_trigger_id` = 'read')
Run Time: 0.000259
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_dbtech_credits_event | ALL | | | | | 14 | Using where |
- 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/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 174
- DBTech\Credits\EventTrigger\AbstractHandler->getEvents() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 204
- DBTech\Credits\EventTrigger\AbstractHandler->getApplicableEvents() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 503
- DBTech\Credits\EventTrigger\AbstractHandler->trigger() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 431
- DBTech\Credits\EventTrigger\AbstractHandler->apply() in src/addons/DBTech/Credits/XF/Repository/Thread.php at line 21
- DBTech\Credits\XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 139
- XF\Pub\Controller\Thread->actionIndex() in src/addons/TB/BenzerKonular/XF/Pub/Controller/Thread.php at line 11
- TB\BenzerKonular\XF\Pub\Controller\Thread->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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_dbtech_credits_event`.*
FROM `xf_dbtech_credits_event`
WHERE (`xf_dbtech_credits_event`.`event_trigger_id` = 'view')
Run Time: 0.000228
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_dbtech_credits_event | ALL | | | | | 14 | Using where |
- 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/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 174
- DBTech\Credits\EventTrigger\AbstractHandler->getEvents() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 204
- DBTech\Credits\EventTrigger\AbstractHandler->getApplicableEvents() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 503
- DBTech\Credits\EventTrigger\AbstractHandler->trigger() in src/addons/DBTech/Credits/EventTrigger/View.php at line 34
- DBTech\Credits\EventTrigger\View->trigger() in src/addons/DBTech/Credits/EventTrigger/AbstractHandler.php at line 431
- DBTech\Credits\EventTrigger\AbstractHandler->apply() in src/addons/DBTech/Credits/XF/Repository/Thread.php at line 37
- DBTech\Credits\XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 139
- XF\Pub\Controller\Thread->actionIndex() in src/addons/TB/BenzerKonular/XF/Pub/Controller/Thread.php at line 11
- TB\BenzerKonular\XF\Pub\Controller\Thread->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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
INSERT INTO xf_thread_view
(thread_id, total)
VALUES
(? , 1)
ON DUPLICATE KEY UPDATE
total = total + 1
Params: 651
Run Time: 0.000090
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Repository/Thread.php at line 193
- XF\Repository\Thread->logThreadView() in src/addons/DBTech/Credits/XF/Repository/Thread.php at line 41
- DBTech\Credits\XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 139
- XF\Pub\Controller\Thread->actionIndex() in src/addons/TB/BenzerKonular/XF/Pub/Controller/Thread.php at line 11
- TB\BenzerKonular\XF\Pub\Controller\Thread->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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*
FROM `xf_node`
WHERE (`xf_node`.`display_in_list` = 1)
ORDER BY `xf_node`.`lft` ASC
Run Time: 0.000680
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list | | | | 91 | Using where; Using filesort |
- 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/Repository/Node.php at line 17
- XF\Repository\Node->getNodeList() in src/addons/TB/BenzerKonular/Repository/BenzerKonular.php at line 72
- TB\BenzerKonular\Repository\BenzerKonular->getBenzerKonular() in src/addons/TB/BenzerKonular/XF/Pub/Controller/Thread.php at line 35
- TB\BenzerKonular\XF\Pub\Controller\Thread->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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_category`.*, `xf_node_Node_1`.*
FROM `xf_category`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_category`.`node_id`)
WHERE (`xf_category`.`node_id` IN (3, 19, 60, 54))
Run Time: 0.000347
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_category | index | PRIMARY | PRIMARY | 4 | | 4 | Using where; Using index |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_category.node_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/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 144
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 18
- XF\Repository\Node->getNodeList() in src/addons/TB/BenzerKonular/Repository/BenzerKonular.php at line 72
- TB\BenzerKonular\Repository\BenzerKonular->getBenzerKonular() in src/addons/TB/BenzerKonular/XF/Pub/Controller/Thread.php at line 35
- TB\BenzerKonular\XF\Pub\Controller\Thread->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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
WHERE (`xf_forum`.`node_id` IN (4, 5, 6, 7, 114, 16, 17, 18, 115, 57, 40, 47, 116, 41, 94, 45, 46, 44, 43, 42, 95, 96, 97, 26, 30, 27, 28, 29, 98, 99, 100, 101, 102, 103, 37, 39, 38, 104, 105, 106, 31, 48, 107, 108, 23, 109, 110, 111, 112, 51, 34, 61, 66, 62, 63, 64, 65, 67, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 55, 58, 59, 56, 113))
Run Time: 0.002632
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | PRIMARY | | | | 87 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_forum.last_thread_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/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 144
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 18
- XF\Repository\Node->getNodeList() in src/addons/TB/BenzerKonular/Repository/BenzerKonular.php at line 72
- TB\BenzerKonular\Repository\BenzerKonular->getBenzerKonular() in src/addons/TB/BenzerKonular/XF/Pub/Controller/Thread.php at line 35
- TB\BenzerKonular\XF\Pub\Controller\Thread->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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
Params: 1, node
Run Time: 0.000595
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 164 | 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/PermissionCache.php at line 102
- XF\PermissionCache->cacheAllContentPerms() in src/XF/Entity/User.php at line 1197
- XF\Entity\User->cacheNodePermissions() in src/XF/Repository/Node.php at line 158
- XF\Repository\Node->filterViewable() in src/XF/Repository/Node.php at line 20
- XF\Repository\Node->getNodeList() in src/addons/TB/BenzerKonular/Repository/BenzerKonular.php at line 72
- TB\BenzerKonular\Repository\BenzerKonular->getBenzerKonular() in src/addons/TB/BenzerKonular/XF/Pub/Controller/Thread.php at line 35
- TB\BenzerKonular\XF\Pub\Controller\Thread->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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE (`xf_thread`.`title` LIKE '%Endüstriyel%') AND (`xf_thread`.`title` LIKE '%Otomasyon%') AND (`xf_thread`.`title` LIKE '%Nedir?%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 651) AND ((`xf_thread`.`node_id` = 3) OR (`xf_thread`.`node_id` = 4) OR (`xf_thread`.`node_id` = 5) OR (`xf_thread`.`node_id` = 6) OR (`xf_thread`.`node_id` = 7) OR (`xf_thread`.`node_id` = 114) OR (`xf_thread`.`node_id` = 16) OR (`xf_thread`.`node_id` = 17) OR (`xf_thread`.`node_id` = 18) OR (`xf_thread`.`node_id` = 115) OR (`xf_thread`.`node_id` = 57) OR (`xf_thread`.`node_id` = 19) OR (`xf_thread`.`node_id` = 40) OR (`xf_thread`.`node_id` = 47) OR (`xf_thread`.`node_id` = 116) OR (`xf_thread`.`node_id` = 41) OR (`xf_thread`.`node_id` = 94) OR (`xf_thread`.`node_id` = 45) OR (`xf_thread`.`node_id` = 46) OR (`xf_thread`.`node_id` = 44) OR (`xf_thread`.`node_id` = 43) OR (`xf_thread`.`node_id` = 42) OR (`xf_thread`.`node_id` = 95) OR (`xf_thread`.`node_id` = 96) OR (`xf_thread`.`node_id` = 97) OR (`xf_thread`.`node_id` = 26) OR (`xf_thread`.`node_id` = 30) OR (`xf_thread`.`node_id` = 27) OR (`xf_thread`.`node_id` = 28) OR (`xf_thread`.`node_id` = 29) OR (`xf_thread`.`node_id` = 98) OR (`xf_thread`.`node_id` = 99) OR (`xf_thread`.`node_id` = 100) OR (`xf_thread`.`node_id` = 101) OR (`xf_thread`.`node_id` = 102) OR (`xf_thread`.`node_id` = 103) OR (`xf_thread`.`node_id` = 37) OR (`xf_thread`.`node_id` = 39) OR (`xf_thread`.`node_id` = 38) OR (`xf_thread`.`node_id` = 104) OR (`xf_thread`.`node_id` = 105) OR (`xf_thread`.`node_id` = 106) OR (`xf_thread`.`node_id` = 31) OR (`xf_thread`.`node_id` = 48) OR (`xf_thread`.`node_id` = 107) OR (`xf_thread`.`node_id` = 108) OR (`xf_thread`.`node_id` = 23) OR (`xf_thread`.`node_id` = 109) OR (`xf_thread`.`node_id` = 110) OR (`xf_thread`.`node_id` = 111) OR (`xf_thread`.`node_id` = 112) OR (`xf_thread`.`node_id` = 51) OR (`xf_thread`.`node_id` = 34) OR (`xf_thread`.`node_id` = 60) OR (`xf_thread`.`node_id` = 61) OR (`xf_thread`.`node_id` = 66) OR (`xf_thread`.`node_id` = 62) OR (`xf_thread`.`node_id` = 63) OR (`xf_thread`.`node_id` = 64) OR (`xf_thread`.`node_id` = 65) OR (`xf_thread`.`node_id` = 67) OR (`xf_thread`.`node_id` = 70) OR (`xf_thread`.`node_id` = 71) OR (`xf_thread`.`node_id` = 72) OR (`xf_thread`.`node_id` = 73) OR (`xf_thread`.`node_id` = 74) OR (`xf_thread`.`node_id` = 75) OR (`xf_thread`.`node_id` = 76) OR (`xf_thread`.`node_id` = 77) OR (`xf_thread`.`node_id` = 78) OR (`xf_thread`.`node_id` = 79) OR (`xf_thread`.`node_id` = 80) OR (`xf_thread`.`node_id` = 81) OR (`xf_thread`.`node_id` = 82) OR (`xf_thread`.`node_id` = 83) OR (`xf_thread`.`node_id` = 84) OR (`xf_thread`.`node_id` = 85) OR (`xf_thread`.`node_id` = 86) OR (`xf_thread`.`node_id` = 87) OR (`xf_thread`.`node_id` = 88) OR (`xf_thread`.`node_id` = 89) OR (`xf_thread`.`node_id` = 90) OR (`xf_thread`.`node_id` = 91) OR (`xf_thread`.`node_id` = 92) OR (`xf_thread`.`node_id` = 93) OR (`xf_thread`.`node_id` = 54) OR (`xf_thread`.`node_id` = 55) OR (`xf_thread`.`node_id` = 58) OR (`xf_thread`.`node_id` = 59) OR (`xf_thread`.`node_id` = 56) OR (`xf_thread`.`node_id` = 113))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 4
Run Time: 0.006935
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date,node_id_sticky_state_vote_score | post_date | 4 | | 1364 | Using where |
- 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/addons/TB/BenzerKonular/Repository/BenzerKonular.php at line 107
- TB\BenzerKonular\Repository\BenzerKonular->getBenzerKonular() in src/addons/TB/BenzerKonular/XF/Pub/Controller/Thread.php at line 35
- TB\BenzerKonular\XF\Pub\Controller\Thread->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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE (`xf_thread`.`title` LIKE '%Endüstriyel%') AND (`xf_thread`.`title` LIKE '%Otomasyon%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 651) AND (1) AND ((`xf_thread`.`node_id` = 3) OR (`xf_thread`.`node_id` = 4) OR (`xf_thread`.`node_id` = 5) OR (`xf_thread`.`node_id` = 6) OR (`xf_thread`.`node_id` = 7) OR (`xf_thread`.`node_id` = 114) OR (`xf_thread`.`node_id` = 16) OR (`xf_thread`.`node_id` = 17) OR (`xf_thread`.`node_id` = 18) OR (`xf_thread`.`node_id` = 115) OR (`xf_thread`.`node_id` = 57) OR (`xf_thread`.`node_id` = 19) OR (`xf_thread`.`node_id` = 40) OR (`xf_thread`.`node_id` = 47) OR (`xf_thread`.`node_id` = 116) OR (`xf_thread`.`node_id` = 41) OR (`xf_thread`.`node_id` = 94) OR (`xf_thread`.`node_id` = 45) OR (`xf_thread`.`node_id` = 46) OR (`xf_thread`.`node_id` = 44) OR (`xf_thread`.`node_id` = 43) OR (`xf_thread`.`node_id` = 42) OR (`xf_thread`.`node_id` = 95) OR (`xf_thread`.`node_id` = 96) OR (`xf_thread`.`node_id` = 97) OR (`xf_thread`.`node_id` = 26) OR (`xf_thread`.`node_id` = 30) OR (`xf_thread`.`node_id` = 27) OR (`xf_thread`.`node_id` = 28) OR (`xf_thread`.`node_id` = 29) OR (`xf_thread`.`node_id` = 98) OR (`xf_thread`.`node_id` = 99) OR (`xf_thread`.`node_id` = 100) OR (`xf_thread`.`node_id` = 101) OR (`xf_thread`.`node_id` = 102) OR (`xf_thread`.`node_id` = 103) OR (`xf_thread`.`node_id` = 37) OR (`xf_thread`.`node_id` = 39) OR (`xf_thread`.`node_id` = 38) OR (`xf_thread`.`node_id` = 104) OR (`xf_thread`.`node_id` = 105) OR (`xf_thread`.`node_id` = 106) OR (`xf_thread`.`node_id` = 31) OR (`xf_thread`.`node_id` = 48) OR (`xf_thread`.`node_id` = 107) OR (`xf_thread`.`node_id` = 108) OR (`xf_thread`.`node_id` = 23) OR (`xf_thread`.`node_id` = 109) OR (`xf_thread`.`node_id` = 110) OR (`xf_thread`.`node_id` = 111) OR (`xf_thread`.`node_id` = 112) OR (`xf_thread`.`node_id` = 51) OR (`xf_thread`.`node_id` = 34) OR (`xf_thread`.`node_id` = 60) OR (`xf_thread`.`node_id` = 61) OR (`xf_thread`.`node_id` = 66) OR (`xf_thread`.`node_id` = 62) OR (`xf_thread`.`node_id` = 63) OR (`xf_thread`.`node_id` = 64) OR (`xf_thread`.`node_id` = 65) OR (`xf_thread`.`node_id` = 67) OR (`xf_thread`.`node_id` = 70) OR (`xf_thread`.`node_id` = 71) OR (`xf_thread`.`node_id` = 72) OR (`xf_thread`.`node_id` = 73) OR (`xf_thread`.`node_id` = 74) OR (`xf_thread`.`node_id` = 75) OR (`xf_thread`.`node_id` = 76) OR (`xf_thread`.`node_id` = 77) OR (`xf_thread`.`node_id` = 78) OR (`xf_thread`.`node_id` = 79) OR (`xf_thread`.`node_id` = 80) OR (`xf_thread`.`node_id` = 81) OR (`xf_thread`.`node_id` = 82) OR (`xf_thread`.`node_id` = 83) OR (`xf_thread`.`node_id` = 84) OR (`xf_thread`.`node_id` = 85) OR (`xf_thread`.`node_id` = 86) OR (`xf_thread`.`node_id` = 87) OR (`xf_thread`.`node_id` = 88) OR (`xf_thread`.`node_id` = 89) OR (`xf_thread`.`node_id` = 90) OR (`xf_thread`.`node_id` = 91) OR (`xf_thread`.`node_id` = 92) OR (`xf_thread`.`node_id` = 93) OR (`xf_thread`.`node_id` = 54) OR (`xf_thread`.`node_id` = 55) OR (`xf_thread`.`node_id` = 58) OR (`xf_thread`.`node_id` = 59) OR (`xf_thread`.`node_id` = 56) OR (`xf_thread`.`node_id` = 113))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 4
Run Time: 0.007457
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date,node_id_sticky_state_vote_score | post_date | 4 | | 1364 | Using where |
- 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/addons/TB/BenzerKonular/Repository/BenzerKonular.php at line 150
- TB\BenzerKonular\Repository\BenzerKonular->getBenzerKonular() in src/addons/TB/BenzerKonular/XF/Pub/Controller/Thread.php at line 35
- TB\BenzerKonular\XF\Pub\Controller\Thread->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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE (`xf_thread`.`title` LIKE '%Endüstriyel%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 651) AND (1) AND ((`xf_thread`.`node_id` = 3) OR (`xf_thread`.`node_id` = 4) OR (`xf_thread`.`node_id` = 5) OR (`xf_thread`.`node_id` = 6) OR (`xf_thread`.`node_id` = 7) OR (`xf_thread`.`node_id` = 114) OR (`xf_thread`.`node_id` = 16) OR (`xf_thread`.`node_id` = 17) OR (`xf_thread`.`node_id` = 18) OR (`xf_thread`.`node_id` = 115) OR (`xf_thread`.`node_id` = 57) OR (`xf_thread`.`node_id` = 19) OR (`xf_thread`.`node_id` = 40) OR (`xf_thread`.`node_id` = 47) OR (`xf_thread`.`node_id` = 116) OR (`xf_thread`.`node_id` = 41) OR (`xf_thread`.`node_id` = 94) OR (`xf_thread`.`node_id` = 45) OR (`xf_thread`.`node_id` = 46) OR (`xf_thread`.`node_id` = 44) OR (`xf_thread`.`node_id` = 43) OR (`xf_thread`.`node_id` = 42) OR (`xf_thread`.`node_id` = 95) OR (`xf_thread`.`node_id` = 96) OR (`xf_thread`.`node_id` = 97) OR (`xf_thread`.`node_id` = 26) OR (`xf_thread`.`node_id` = 30) OR (`xf_thread`.`node_id` = 27) OR (`xf_thread`.`node_id` = 28) OR (`xf_thread`.`node_id` = 29) OR (`xf_thread`.`node_id` = 98) OR (`xf_thread`.`node_id` = 99) OR (`xf_thread`.`node_id` = 100) OR (`xf_thread`.`node_id` = 101) OR (`xf_thread`.`node_id` = 102) OR (`xf_thread`.`node_id` = 103) OR (`xf_thread`.`node_id` = 37) OR (`xf_thread`.`node_id` = 39) OR (`xf_thread`.`node_id` = 38) OR (`xf_thread`.`node_id` = 104) OR (`xf_thread`.`node_id` = 105) OR (`xf_thread`.`node_id` = 106) OR (`xf_thread`.`node_id` = 31) OR (`xf_thread`.`node_id` = 48) OR (`xf_thread`.`node_id` = 107) OR (`xf_thread`.`node_id` = 108) OR (`xf_thread`.`node_id` = 23) OR (`xf_thread`.`node_id` = 109) OR (`xf_thread`.`node_id` = 110) OR (`xf_thread`.`node_id` = 111) OR (`xf_thread`.`node_id` = 112) OR (`xf_thread`.`node_id` = 51) OR (`xf_thread`.`node_id` = 34) OR (`xf_thread`.`node_id` = 60) OR (`xf_thread`.`node_id` = 61) OR (`xf_thread`.`node_id` = 66) OR (`xf_thread`.`node_id` = 62) OR (`xf_thread`.`node_id` = 63) OR (`xf_thread`.`node_id` = 64) OR (`xf_thread`.`node_id` = 65) OR (`xf_thread`.`node_id` = 67) OR (`xf_thread`.`node_id` = 70) OR (`xf_thread`.`node_id` = 71) OR (`xf_thread`.`node_id` = 72) OR (`xf_thread`.`node_id` = 73) OR (`xf_thread`.`node_id` = 74) OR (`xf_thread`.`node_id` = 75) OR (`xf_thread`.`node_id` = 76) OR (`xf_thread`.`node_id` = 77) OR (`xf_thread`.`node_id` = 78) OR (`xf_thread`.`node_id` = 79) OR (`xf_thread`.`node_id` = 80) OR (`xf_thread`.`node_id` = 81) OR (`xf_thread`.`node_id` = 82) OR (`xf_thread`.`node_id` = 83) OR (`xf_thread`.`node_id` = 84) OR (`xf_thread`.`node_id` = 85) OR (`xf_thread`.`node_id` = 86) OR (`xf_thread`.`node_id` = 87) OR (`xf_thread`.`node_id` = 88) OR (`xf_thread`.`node_id` = 89) OR (`xf_thread`.`node_id` = 90) OR (`xf_thread`.`node_id` = 91) OR (`xf_thread`.`node_id` = 92) OR (`xf_thread`.`node_id` = 93) OR (`xf_thread`.`node_id` = 54) OR (`xf_thread`.`node_id` = 55) OR (`xf_thread`.`node_id` = 58) OR (`xf_thread`.`node_id` = 59) OR (`xf_thread`.`node_id` = 56) OR (`xf_thread`.`node_id` = 113))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 4
Run Time: 0.004771
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date,node_id_sticky_state_vote_score | post_date | 4 | | 1364 | Using where |
- 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/addons/TB/BenzerKonular/Repository/BenzerKonular.php at line 193
- TB\BenzerKonular\Repository\BenzerKonular->getBenzerKonular() in src/addons/TB/BenzerKonular/XF/Pub/Controller/Thread.php at line 35
- TB\BenzerKonular\XF\Pub\Controller\Thread->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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE ((`xf_thread`.`thread_id` = 1235) OR (`xf_thread`.`thread_id` = 803) OR (`xf_thread`.`thread_id` = 656) OR (`xf_thread`.`thread_id` = 654))
ORDER BY `xf_thread`.`post_date` DESC
Run Time: 0.000310
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 4 | Using where; Using filesort |
- 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/addons/TB/BenzerKonular/Repository/BenzerKonular.php at line 311
- TB\BenzerKonular\Repository\BenzerKonular->getBenzerKonular() in src/addons/TB/BenzerKonular/XF/Pub/Controller/Thread.php at line 35
- TB\BenzerKonular\XF\Pub\Controller\Thread->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 2337
- XF\App->run() in src/XF.php at line 488
- 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, , , XF\Pub\Controller\Thread, Index, valid, thread_id=651, 1716131929,
Run Time: 0.000135
- 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 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*, `xf_template_MasterTemplate_2`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
LEFT JOIN `xf_template` AS `xf_template_MasterTemplate_2` ON (`xf_template_MasterTemplate_2`.`style_id` = 0 AND `xf_template_MasterTemplate_2`.`type` = 'public' AND `xf_template_MasterTemplate_2`.`title` = CONCAT('_siropu_ads_manager_ad_code.', `xf_siropu_ads_manager_ad`.`ad_id`))
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('code', 'banner', 'text', 'link', 'popup', 'background')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY `xf_siropu_ads_manager_ad`.`display_order` ASC
Run Time: 0.000635
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ad | ref | type,status,status_display_order | status_display_order | 102 | const | 1 | Using where |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_siropu_ads_manager_ad.package_id | 1 | |
SIMPLE | xf_template_MasterTemplate_2 | eq_ref | type_title_style_id | type_title_style_id | 128 | const,func,const | 1 | Using where |
- 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/addons/Siropu/AdsManager/Template/Ad.php at line 501
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 336
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 327
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 38
- Siropu\AdsManager\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2834
- XF\App->fire() in src/XF/App.php at line 2069
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1939
- XF\App->preRender() in src/XF/Pub/App.php at line 448
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('keyword', 'affiliate')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY RAND() ASC
Run Time: 0.001211
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ad | ref | type,status,status_display_order | status | 102 | const | 1 | Using index condition; Using where; Using temporary; Using filesort |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_siropu_ads_manager_ad.package_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/addons/Siropu/AdsManager/Template/Ad.php at line 606
- Siropu\AdsManager\Template\Ad->loadFilterAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 340
- Siropu\AdsManager\Template\Ad->setFilterAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 331
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 38
- Siropu\AdsManager\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2834
- XF\App->fire() in src/XF/App.php at line 2069
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1939
- XF\App->preRender() in src/XF/Pub/App.php at line 448
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_session_activity`.*
FROM `xf_session_activity`
WHERE (`xf_session_activity`.`user_id` = 1004) AND (`xf_session_activity`.`unique_key` = '1004')
LIMIT 1
Run Time: 0.000228
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- 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 1346
- 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 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 394
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 186
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 110
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 310
- XF\Entity\User->getLastActivity() in src/XF/Mvc/Entity/Entity.php at line 157
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 110
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 519
- XF\Entity\User->canViewOnlineStatus() in src/XF/Entity/User.php at line 238
- XF\Entity\User->isOnline()
- call_user_func_array() in src/XF/Template/Templater.php at line 1168
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s6/public/message_macros.php at line 15
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 801
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 25
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 964
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 900
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 152
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 964
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 900
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 196
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 801
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s6/public/thread_view.php at line 811
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1628
- 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 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_kl_em_bb_codes`.*
FROM `xf_kl_em_bb_codes`
Run Time: 0.000291
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_kl_em_bb_codes | ALL | | | | | 3 | |
- 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/addons/KL/EditorManager/EditorConfig.php at line 233
- KL\EditorManager\EditorConfig->bbCodeSettings() in src/addons/KL/EditorManager/Listener/BbCodeRules.php at line 77
- KL\EditorManager\Listener\BbCodeRules::extend()
- call_user_func_array() in src/XF/Extension.php at line 35
- XF\Extension->fire() in src/XF/App.php at line 2834
- XF\App->fire() in src/XF/SubContainer/BbCode.php at line 40
- XF\SubContainer\BbCode->XF\SubContainer\{closure}() in src/XF/Container.php at line 228
- XF\Container->create() in src/XF/SubContainer/BbCode.php at line 161
- XF\SubContainer\BbCode->rules() in src/XF/SubContainer/BbCode.php at line 207
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2346
- XF\Template\Templater->fnBbCode()
- call_user_func_array() in src/XF/Template/Templater.php at line 1105
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 453
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 801
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 59
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 964
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 900
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 99
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 964
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 900
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 128
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 964
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 900
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 142
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 964
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 900
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 154
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 964
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 900
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 196
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 801
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s6/public/thread_view.php at line 811
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1628
- 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 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('xc_hide_links_from_guests_guests_error_hide_links')
Params: 2
Run Time: 0.000236
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 361
- XF\Language->loadPhrases() in src/XF/Language.php at line 259
- XF\Language->getPhraseText() in src/XF/Language.php at line 130
- 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 1145
- XF::escapeString() in src/XF/Template/Templater.php at line 1178
- XF\Template\Templater->escape() in internal_data/code_cache/templates/l2/s6/public/xc_hide_links_medias_to_guests_bb_code_hide.php at line 11
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1628
- XF\Template\Templater->renderTemplate() in src/addons/XenConcept/HideLinkFromGuests/XF/BbCode/Renderer/Html.php at line 257
- XenConcept\HideLinkFromGuests\XF\BbCode\Renderer\Html->renderTagUrl()
- call_user_func() in src/XF/BbCode/Renderer/Html.php at line 308
- XF\BbCode\Renderer\Html->renderTag() in src/addons/KL/EditorManager/BbCode/EditorManagerTrait.php at line 144
- KL\EditorManager\XF\BbCode\Renderer\Html->renderTag() in src/XF/BbCode/Traverser.php at line 61
- XF\BbCode\Traverser->renderSubTree() in src/XF/BbCode/Traverser.php at line 37
- XF\BbCode\Traverser->renderAst() in src/XF/BbCode/Traverser.php at line 20
- XF\BbCode\Traverser->render() in src/XF/SubContainer/BbCode.php at line 220
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2346
- XF\Template\Templater->fnBbCode()
- call_user_func_array() in src/XF/Template/Templater.php at line 1105
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 453
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 801
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 59
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 964
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 900
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 99
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 964
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 900
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 128
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 964
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 900
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 142
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 964
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 900
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 154
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 964
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 900
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s6/public/post_macros.php at line 196
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 801
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s6/public/thread_view.php at line 811
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1628
- 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 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.*
FROM `xf_thread` FORCE INDEX (`last_post_date`)
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_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_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread`.`last_post_user_id`)
WHERE (`xf_forum_Forum_1`.`find_new` = 1) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`last_post_date` > 1713539929)
ORDER BY `xf_thread`.`last_post_date` DESC
LIMIT 10
Run Time: 0.001569
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | last_post_date | last_post_date | 4 | | 39 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_thread.node_id | 1 | Using where |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_thread.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,muhen_fmrnd.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_thread.last_post_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/Widget/NewPosts.php at line 87
- XF\Widget\NewPosts->render() in internal_data/code_cache/widgets/_7_forum_overview_new_posts.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7472
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1903
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s6/public/thread_view.php at line 998
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1628
- 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 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_rm_resource`.*, `xf_user_User_1`.*, `xf_rm_category_Category_2`.*, `xf_permission_cache_content_Permissions_3`.*
FROM `xf_rm_resource`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_rm_resource`.`user_id`)
LEFT JOIN `xf_rm_category` AS `xf_rm_category_Category_2` ON (`xf_rm_category_Category_2`.`resource_category_id` = `xf_rm_resource`.`resource_category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_3` ON (`xf_permission_cache_content_Permissions_3`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_3`.`content_id` = `xf_rm_category_Category_2`.`resource_category_id` AND `xf_permission_cache_content_Permissions_3`.`permission_combination_id` = '1')
WHERE (`xf_rm_resource`.`resource_state` = 'visible')
ORDER BY `xf_rm_resource`.`last_update` DESC
LIMIT 10
Run Time: 0.001063
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | ALL | | | | | 226 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_rm_resource.user_id | 1 | |
SIMPLE | xf_rm_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_rm_resource.resource_category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_3 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,muhen_fmrnd.xf_rm_category_Category_2.resource_category_id | 1 | Using where |
- 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/addons/XFRM/Widget/NewResources.php at line 57
- XFRM\Widget\NewResources->render() in internal_data/code_cache/widgets/_17_xfrm_forum_overview_new_resources.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7472
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1903
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s6/public/thread_view.php at line 998
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1628
- 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 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_kl_em_fonts`.*
FROM `xf_kl_em_fonts`
WHERE (`xf_kl_em_fonts`.`active` = 1)
ORDER BY `xf_kl_em_fonts`.`display_order` ASC
Run Time: 0.000236
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_kl_em_fonts | ALL | | | | | 8 | Using where; Using filesort |
- 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/addons/KL/EditorManager/EditorConfig.php at line 206
- KL\EditorManager\EditorConfig->fonts() in src/addons/KL/EditorManager/Listener/TemplaterTemplatePreRender.php at line 46
- KL\EditorManager\Listener\TemplaterTemplatePreRender::pageContainer()
- call_user_func_array() in src/XF/Extension.php at line 50
- XF\Extension->fire() in src/XF/App.php at line 2834
- XF\App->fire() in src/XF/Template/Templater.php at line 1587
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('forumStatistics')
Run Time: 0.000268
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 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/DataRegistry.php at line 226
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1789
- XF\App->XF\{closure}() in src/XF/Container.php at line 28
- XF\Container->offsetGet() in src/XF/App.php at line 2410
- XF\App->__get() in src/addons/XenGenTr/XGTStyleV5/Widget/XGTForum.php at line 12
- XenGenTr\XGTStyleV5\Widget\XGTForum->render() in internal_data/code_cache/widgets/_28_xgtsv5_footer_istatistik.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7472
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1932
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s6/public/XGTSv5_footer.php at line 21
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1628
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1657
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l2/s6/public/PAGE_CONTAINER.php at line 1228
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1628
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*
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_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_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`first_post_reaction_score` > 0)
ORDER BY `xf_thread`.`first_post_reaction_score` DESC
LIMIT 10
Run Time: 0.002040
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ALL | | | | | 1364 | Using where; Using filesort |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | muhen_fmrnd.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,muhen_fmrnd.xf_node_Node_2.node_id | 1 | Using where |
- 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/addons/XenGenTr/XGTStyleV5/Widget/LiderKonular.php at line 49
- XenGenTr\XGTStyleV5\Widget\LiderKonular->render() in internal_data/code_cache/widgets/_29_xgtsv5_footer_tepki_lideri_konular.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7472
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1932
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l2/s6/public/XGTSv5_footer.php at line 88
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1628
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1657
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l2/s6/public/PAGE_CONTAINER.php at line 1228
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1628
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 562
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2142
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20
bytes_sent | 44263 |
bytes_received | 947809 |
packets_sent | 316 |
packets_received | 3701 |
protocol_overhead_in | 14804 |
protocol_overhead_out | 1264 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 972 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 294 |
bytes_received_prepare_response_packet | 245908 |
bytes_received_change_user_packet | 699449 |
packets_sent_command | 157 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 108 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 54 |
packets_received_prepare_response | 3014 |
packets_received_change_user | 471 |
result_set_queries | 50 |
non_result_set_queries | 4 |
no_index_used | 9 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 50 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 51 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 421 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 421 |
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 | 421 |
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 | 0 |
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 | 2884 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 2260 |
proto_binary_fetched_int24 | 813 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 7819 |
proto_binary_fetched_decimal | 107 |
proto_binary_fetched_float | 124 |
proto_binary_fetched_double | 20 |
proto_binary_fetched_date | 8 |
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 | 4228 |
proto_binary_fetched_blob | 1704 |
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 | 2 |
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 | 52 |
com_stmt_execute | 52 |
com_stmt_send_long_data | 0 |
com_stmt_close | 51 |
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 | 687791 |