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.000641
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 46 | 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 1905
- XF\App->preLoadData() in src/XF/App.php at line 1893
- XF\App->setup() in src/XF/Pub/App.php at line 93
- XF\Pub\App->setup() in src/XF.php at line 490
- XF::setupApp() in src/XF.php at line 513
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000191
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1197
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 244
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 22
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 125
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 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 2351
- XF\App->run() in src/XF.php at line 517
- 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` = '8191')
LIMIT 1
Run Time: 0.001256
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1354
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Thread.php at line 1717
- XF\Pub\Controller\Thread->assertViewableThread() in src/XF/Pub/Controller/Thread.php at line 17
- 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 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 2351
- XF\App->run() in src/XF.php at line 517
- 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` = 8191) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 10)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Run Time: 0.002147
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 | 10 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | gebelikt_xen.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | gebelikt_xen.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | gebelikt_xen.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | gebelikt_xen.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_permission_combination_PermissionCombination_5 | eq_ref | PRIMARY | PRIMARY | 4 | gebelikt_xen.xf_user_User_1.permission_combination_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_6 | eq_ref | PRIMARY | PRIMARY | 22 | gebelikt_xen.xf_user_User_1.user_id,func | 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 1387
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Thread.php at line 65
- 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 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 8191
Run Time: 0.000075
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/Thread.php at line 193
- XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 141
- 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 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 2351
- XF\App->run() in src/XF.php at line 517
- 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.001028
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list | | | | 59 | Using where; Using filesort |
- 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 1387
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/Node.php at line 19
- 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 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 2351
- XF\App->run() in src/XF.php at line 517
- 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 (1, 5, 51, 65, 58, 45, 34, 39))
Run Time: 0.000580
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_category | index | PRIMARY | PRIMARY | 4 | | 9 | Using where; Using index |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | gebelikt_xen.xf_category.node_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1387
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() 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 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 2351
- XF\App->run() in src/XF.php at line 517
- 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 (72, 73, 49, 38, 43, 44, 37, 2, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 63, 70, 53, 3, 66, 67, 68, 69, 59, 60, 80, 52, 50, 64, 46, 77, 35, 36, 19, 20, 21, 54, 47, 48, 40))
Run Time: 0.001910
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | PRIMARY | | | | 45 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | gebelikt_xen.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | gebelikt_xen.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | gebelikt_xen.xf_forum.last_thread_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1387
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() 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 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_page`.*, `xf_node_Node_1`.*
FROM `xf_page`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_page`.`node_id`)
WHERE (`xf_page`.`node_id` IN (42, 71, 81))
Run Time: 0.000362
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_page | range | PRIMARY | PRIMARY | 4 | | 3 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | gebelikt_xen.xf_page.node_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1387
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 146
- XF\Repository\Node->loadNodeTypeDataForNodes() 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 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 2351
- XF\App->run() in src/XF.php at line 517
- 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.000264
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 59 | 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/PermissionCache.php at line 112
- XF\PermissionCache->cacheAllContentPerms() in src/XF/Entity/User.php at line 1218
- XF\Entity\User->cacheNodePermissions() in src/XF/Repository/Node.php at line 160
- XF\Repository\Node->filterViewable() in src/XF/Repository/Node.php at line 22
- 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 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE (`xf_thread`.`title` LIKE '%35+1%') AND (`xf_thread`.`title` LIKE '%anişler%') AND (`xf_thread`.`title` LIKE '%hade%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 8191) AND ((`xf_thread`.`node_id` = 1) OR (`xf_thread`.`node_id` = 72) OR (`xf_thread`.`node_id` = 73) OR (`xf_thread`.`node_id` = 49) OR (`xf_thread`.`node_id` = 38) OR (`xf_thread`.`node_id` = 43) OR (`xf_thread`.`node_id` = 44) OR (`xf_thread`.`node_id` = 37) OR (`xf_thread`.`node_id` = 2) OR (`xf_thread`.`node_id` = 5) OR (`xf_thread`.`node_id` = 22) OR (`xf_thread`.`node_id` = 23) OR (`xf_thread`.`node_id` = 24) OR (`xf_thread`.`node_id` = 25) OR (`xf_thread`.`node_id` = 26) OR (`xf_thread`.`node_id` = 27) OR (`xf_thread`.`node_id` = 28) OR (`xf_thread`.`node_id` = 29) OR (`xf_thread`.`node_id` = 30) OR (`xf_thread`.`node_id` = 31) OR (`xf_thread`.`node_id` = 32) OR (`xf_thread`.`node_id` = 33) OR (`xf_thread`.`node_id` = 63) OR (`xf_thread`.`node_id` = 51) OR (`xf_thread`.`node_id` = 70) OR (`xf_thread`.`node_id` = 53) OR (`xf_thread`.`node_id` = 3) OR (`xf_thread`.`node_id` = 65) OR (`xf_thread`.`node_id` = 66) OR (`xf_thread`.`node_id` = 67) OR (`xf_thread`.`node_id` = 68) OR (`xf_thread`.`node_id` = 69) OR (`xf_thread`.`node_id` = 45) OR (`xf_thread`.`node_id` = 80) OR (`xf_thread`.`node_id` = 52) OR (`xf_thread`.`node_id` = 50) OR (`xf_thread`.`node_id` = 64) OR (`xf_thread`.`node_id` = 46) OR (`xf_thread`.`node_id` = 77) OR (`xf_thread`.`node_id` = 34) OR (`xf_thread`.`node_id` = 35) OR (`xf_thread`.`node_id` = 36) OR (`xf_thread`.`node_id` = 19) OR (`xf_thread`.`node_id` = 20) OR (`xf_thread`.`node_id` = 21) OR (`xf_thread`.`node_id` = 39) OR (`xf_thread`.`node_id` = 54) OR (`xf_thread`.`node_id` = 47) OR (`xf_thread`.`node_id` = 48) OR (`xf_thread`.`node_id` = 40) OR (`xf_thread`.`node_id` = 42) OR (`xf_thread`.`node_id` = 71) OR (`xf_thread`.`node_id` = 81))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 2
Run Time: 0.092984
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,node_id_sticky_state_vote_score,post_date | post_date | 4 | | 15088 | 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 1387
- 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 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE (`xf_thread`.`title` LIKE '%35+1%') AND (`xf_thread`.`title` LIKE '%anişler%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 8191) AND (1) AND ((`xf_thread`.`node_id` = 1) OR (`xf_thread`.`node_id` = 72) OR (`xf_thread`.`node_id` = 73) OR (`xf_thread`.`node_id` = 49) OR (`xf_thread`.`node_id` = 38) OR (`xf_thread`.`node_id` = 43) OR (`xf_thread`.`node_id` = 44) OR (`xf_thread`.`node_id` = 37) OR (`xf_thread`.`node_id` = 2) OR (`xf_thread`.`node_id` = 5) OR (`xf_thread`.`node_id` = 22) OR (`xf_thread`.`node_id` = 23) OR (`xf_thread`.`node_id` = 24) OR (`xf_thread`.`node_id` = 25) OR (`xf_thread`.`node_id` = 26) OR (`xf_thread`.`node_id` = 27) OR (`xf_thread`.`node_id` = 28) OR (`xf_thread`.`node_id` = 29) OR (`xf_thread`.`node_id` = 30) OR (`xf_thread`.`node_id` = 31) OR (`xf_thread`.`node_id` = 32) OR (`xf_thread`.`node_id` = 33) OR (`xf_thread`.`node_id` = 63) OR (`xf_thread`.`node_id` = 51) OR (`xf_thread`.`node_id` = 70) OR (`xf_thread`.`node_id` = 53) OR (`xf_thread`.`node_id` = 3) OR (`xf_thread`.`node_id` = 65) OR (`xf_thread`.`node_id` = 66) OR (`xf_thread`.`node_id` = 67) OR (`xf_thread`.`node_id` = 68) OR (`xf_thread`.`node_id` = 69) OR (`xf_thread`.`node_id` = 45) OR (`xf_thread`.`node_id` = 80) OR (`xf_thread`.`node_id` = 52) OR (`xf_thread`.`node_id` = 50) OR (`xf_thread`.`node_id` = 64) OR (`xf_thread`.`node_id` = 46) OR (`xf_thread`.`node_id` = 77) OR (`xf_thread`.`node_id` = 34) OR (`xf_thread`.`node_id` = 35) OR (`xf_thread`.`node_id` = 36) OR (`xf_thread`.`node_id` = 19) OR (`xf_thread`.`node_id` = 20) OR (`xf_thread`.`node_id` = 21) OR (`xf_thread`.`node_id` = 39) OR (`xf_thread`.`node_id` = 54) OR (`xf_thread`.`node_id` = 47) OR (`xf_thread`.`node_id` = 48) OR (`xf_thread`.`node_id` = 40) OR (`xf_thread`.`node_id` = 42) OR (`xf_thread`.`node_id` = 71) OR (`xf_thread`.`node_id` = 81))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 2
Run Time: 0.085528
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,node_id_sticky_state_vote_score,post_date | post_date | 4 | | 15088 | 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 1387
- 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 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE (`xf_thread`.`title` LIKE '%35+1%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 8191) AND (1) AND ((`xf_thread`.`node_id` = 1) OR (`xf_thread`.`node_id` = 72) OR (`xf_thread`.`node_id` = 73) OR (`xf_thread`.`node_id` = 49) OR (`xf_thread`.`node_id` = 38) OR (`xf_thread`.`node_id` = 43) OR (`xf_thread`.`node_id` = 44) OR (`xf_thread`.`node_id` = 37) OR (`xf_thread`.`node_id` = 2) OR (`xf_thread`.`node_id` = 5) OR (`xf_thread`.`node_id` = 22) OR (`xf_thread`.`node_id` = 23) OR (`xf_thread`.`node_id` = 24) OR (`xf_thread`.`node_id` = 25) OR (`xf_thread`.`node_id` = 26) OR (`xf_thread`.`node_id` = 27) OR (`xf_thread`.`node_id` = 28) OR (`xf_thread`.`node_id` = 29) OR (`xf_thread`.`node_id` = 30) OR (`xf_thread`.`node_id` = 31) OR (`xf_thread`.`node_id` = 32) OR (`xf_thread`.`node_id` = 33) OR (`xf_thread`.`node_id` = 63) OR (`xf_thread`.`node_id` = 51) OR (`xf_thread`.`node_id` = 70) OR (`xf_thread`.`node_id` = 53) OR (`xf_thread`.`node_id` = 3) OR (`xf_thread`.`node_id` = 65) OR (`xf_thread`.`node_id` = 66) OR (`xf_thread`.`node_id` = 67) OR (`xf_thread`.`node_id` = 68) OR (`xf_thread`.`node_id` = 69) OR (`xf_thread`.`node_id` = 45) OR (`xf_thread`.`node_id` = 80) OR (`xf_thread`.`node_id` = 52) OR (`xf_thread`.`node_id` = 50) OR (`xf_thread`.`node_id` = 64) OR (`xf_thread`.`node_id` = 46) OR (`xf_thread`.`node_id` = 77) OR (`xf_thread`.`node_id` = 34) OR (`xf_thread`.`node_id` = 35) OR (`xf_thread`.`node_id` = 36) OR (`xf_thread`.`node_id` = 19) OR (`xf_thread`.`node_id` = 20) OR (`xf_thread`.`node_id` = 21) OR (`xf_thread`.`node_id` = 39) OR (`xf_thread`.`node_id` = 54) OR (`xf_thread`.`node_id` = 47) OR (`xf_thread`.`node_id` = 48) OR (`xf_thread`.`node_id` = 40) OR (`xf_thread`.`node_id` = 42) OR (`xf_thread`.`node_id` = 71) OR (`xf_thread`.`node_id` = 81))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 2
Run Time: 0.067352
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,node_id_sticky_state_vote_score,post_date | post_date | 4 | | 15088 | 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 1387
- 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 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE ((`xf_thread`.`thread_id` = 21652) OR (`xf_thread`.`thread_id` = 7371))
ORDER BY `xf_thread`.`post_date` DESC
Run Time: 0.000321
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 2 | Using where; Using filesort |
- 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 1387
- 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 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, "