SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'paymentProvider', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')
Run Time: 0.000198
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 39 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 136
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/App.php at line 2040
- XF\App->preLoadData() in src/XF/App.php at line 2028
- XF\App->setup() in src/XF/Pub/App.php at line 94
- XF\Pub\App->setup() in src/XF.php at line 497
- XF::setupApp() in src/XF.php at line 520
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000064
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 1219
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 245
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 23
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 126
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- 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`.*, `xf_permission_cache_content_Permissions_5`.*
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')
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '2')
WHERE (`xf_thread`.`thread_id` = '124993')
LIMIT 1
Run Time: 0.000325
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 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | 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 1395
- 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 1635
- XF\Pub\Controller\Thread->assertViewableThread() in src/XF/Pub/Controller/Thread.php at line 17
- 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 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- 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` = 124993) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 64) AND (`xf_post`.`position` < 80)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Run Time: 0.004818
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | range | thread_id_post_date,thread_id_position,thread_id_score_date | thread_id_position | 8 | | 16 | Using index condition; Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_permission_combination_PermissionCombination_5 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_user_User_1.permission_combination_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_6 | eq_ref | PRIMARY | PRIMARY | 22 | gezenbilir_xen_foro.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 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Thread.php at line 65
- 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 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` IN (1533376, 1533403, 1533442, 1533489, 1533493))
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000988
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | range | content_type_id_date | content_type_id_date | 31 | | 16 | Using index condition; Using filesort |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_attachment.data_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 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/Attachment.php at line 241
- XF\Repository\Attachment->addAttachmentsToContent() in src/XF/ControllerPlugin/Thread.php at line 46
- XF\ControllerPlugin\Thread->fetchExtraContentForPostsFullView() in src/XF/Pub/Controller/Thread.php at line 110
- 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 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
INSERT INTO xf_thread_view
(thread_id, total)
VALUES
(? , 1)
ON DUPLICATE KEY UPDATE
total = total + 1
Params: 124993
Run Time: 0.000058
- 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 186
- XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 141
- 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 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, ���
Run Time: 0.000090
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 130
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: ���, XF\Pub\Controller\Thread, Index, valid, thread_id=124993&page=5, 1714051853, , 0, ���
Run Time: 0.000130
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 218
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 82
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 258
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- 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.000120
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 | 7 | Using where |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 557
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 392
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 383
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT *
FROM xf_siropu_ads_manager_click_fraud
WHERE ip = ?
AND ip_blocked > ?
Params: ���, 1714051853
Run Time: 0.000123
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_click_fraud | range | ip_ip_blocked | ip_ip_blocked | 22 | | 1 | Using index condition |
- 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/addons/Siropu/AdsManager/Repository/ClickFraud.php at line 71
- Siropu\AdsManager\Repository\ClickFraud->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 511
- Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 459
- Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 560
- Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 558
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 392
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 383
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_ads_manager_click_fraud`.*
FROM `xf_siropu_ads_manager_click_fraud`
WHERE (`xf_siropu_ads_manager_click_fraud`.`ad_id` = 9 AND `xf_siropu_ads_manager_click_fraud`.`ip` = '���')
LIMIT 1
Run Time: 0.000095
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1395
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 170
- XF\Mvc\Entity\Manager->findOne() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 516
- Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 459
- Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 560
- Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 558
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 392
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 383
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT *
FROM xf_siropu_ads_manager_click_fraud
WHERE ip = ?
AND ip_blocked > ?
Params: ���, 1714051853
Run Time: 0.000055
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_click_fraud | range | ip_ip_blocked | ip_ip_blocked | 22 | | 1 | Using index condition |
- 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/addons/Siropu/AdsManager/Repository/ClickFraud.php at line 71
- Siropu\AdsManager\Repository\ClickFraud->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 511
- Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 459
- Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 560
- Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 558
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 392
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 383
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_ads_manager_click_fraud`.*
FROM `xf_siropu_ads_manager_click_fraud`
WHERE (`xf_siropu_ads_manager_click_fraud`.`ad_id` = 10 AND `xf_siropu_ads_manager_click_fraud`.`ip` = '���')
LIMIT 1
Run Time: 0.000085
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1395
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 170
- XF\Mvc\Entity\Manager->findOne() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 516
- Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 459
- Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 560
- Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 558
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 392
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 383
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT *
FROM xf_siropu_ads_manager_click_fraud
WHERE ip = ?
AND ip_blocked > ?
Params: ���, 1714051853
Run Time: 0.000052
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_click_fraud | range | ip_ip_blocked | ip_ip_blocked | 22 | | 1 | Using index condition |
- 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/addons/Siropu/AdsManager/Repository/ClickFraud.php at line 71
- Siropu\AdsManager\Repository\ClickFraud->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 511
- Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 459
- Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 560
- Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 558
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 392
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 383
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_ads_manager_click_fraud`.*
FROM `xf_siropu_ads_manager_click_fraud`
WHERE (`xf_siropu_ads_manager_click_fraud`.`ad_id` = 11 AND `xf_siropu_ads_manager_click_fraud`.`ip` = '���')
LIMIT 1
Run Time: 0.000085
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1395
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 170
- XF\Mvc\Entity\Manager->findOne() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 516
- Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 459
- Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 560
- Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 558
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 392
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 383
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT *
FROM xf_siropu_ads_manager_click_fraud
WHERE ip = ?
AND ip_blocked > ?
Params: ���, 1714051853
Run Time: 0.000051
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_click_fraud | range | ip_ip_blocked | ip_ip_blocked | 22 | | 1 | Using index condition |
- 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/addons/Siropu/AdsManager/Repository/ClickFraud.php at line 71
- Siropu\AdsManager\Repository\ClickFraud->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 511
- Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 459
- Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 560
- Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 558
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 392
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 383
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_ads_manager_click_fraud`.*
FROM `xf_siropu_ads_manager_click_fraud`
WHERE (`xf_siropu_ads_manager_click_fraud`.`ad_id` = 12 AND `xf_siropu_ads_manager_click_fraud`.`ip` = '���')
LIMIT 1
Run Time: 0.000080
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1395
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 170
- XF\Mvc\Entity\Manager->findOne() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 516
- Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 459
- Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 560
- Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 558
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 392
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 383
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT *
FROM xf_siropu_ads_manager_click_fraud
WHERE ip = ?
AND ip_blocked > ?
Params: ���, 1714051853
Run Time: 0.000051
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_click_fraud | range | ip_ip_blocked | ip_ip_blocked | 22 | | 1 | Using index condition |
- 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/addons/Siropu/AdsManager/Repository/ClickFraud.php at line 71
- Siropu\AdsManager\Repository\ClickFraud->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 511
- Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 459
- Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 560
- Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 558
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 392
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 383
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_ads_manager_click_fraud`.*
FROM `xf_siropu_ads_manager_click_fraud`
WHERE (`xf_siropu_ads_manager_click_fraud`.`ad_id` = 17 AND `xf_siropu_ads_manager_click_fraud`.`ip` = '���')
LIMIT 1
Run Time: 0.000086
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1395
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 170
- XF\Mvc\Entity\Manager->findOne() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 516
- Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 459
- Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 560
- Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 558
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 392
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 383
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT *
FROM xf_siropu_ads_manager_click_fraud
WHERE ip = ?
AND ip_blocked > ?
Params: ���, 1714051853
Run Time: 0.000056
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_click_fraud | range | ip_ip_blocked | ip_ip_blocked | 22 | | 1 | Using index condition |
- 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/addons/Siropu/AdsManager/Repository/ClickFraud.php at line 71
- Siropu\AdsManager\Repository\ClickFraud->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 511
- Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 459
- Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 560
- Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 558
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 392
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 383
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_ads_manager_click_fraud`.*
FROM `xf_siropu_ads_manager_click_fraud`
WHERE (`xf_siropu_ads_manager_click_fraud`.`ad_id` = 41 AND `xf_siropu_ads_manager_click_fraud`.`ip` = '���')
LIMIT 1
Run Time: 0.000083
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1395
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 170
- XF\Mvc\Entity\Manager->findOne() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 516
- Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 459
- Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 560
- Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 558
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 392
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 383
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT *
FROM xf_siropu_ads_manager_click_fraud
WHERE ip = ?
AND ip_blocked > ?
Params: ���, 1714051853
Run Time: 0.000050
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_click_fraud | range | ip_ip_blocked | ip_ip_blocked | 22 | | 1 | Using index condition |
- 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/addons/Siropu/AdsManager/Repository/ClickFraud.php at line 71
- Siropu\AdsManager\Repository\ClickFraud->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 511
- Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 459
- Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 560
- Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 558
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 392
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 383
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_siropu_ads_manager_click_fraud`.*
FROM `xf_siropu_ads_manager_click_fraud`
WHERE (`xf_siropu_ads_manager_click_fraud`.`ad_id` = 42 AND `xf_siropu_ads_manager_click_fraud`.`ip` = '���')
LIMIT 1
Run Time: 0.000088
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1395
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 170
- XF\Mvc\Entity\Manager->findOne() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 516
- Siropu\AdsManager\Entity\Ad->isIpBlocked() in src/addons/Siropu/AdsManager/Entity/Ad.php at line 459
- Siropu\AdsManager\Entity\Ad->canDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 560
- Siropu\AdsManager\Template\Ad->Siropu\AdsManager\Template\{closure}()
- array_filter() in src/XF/Mvc/Entity/AbstractCollection.php at line 197
- XF\Mvc\Entity\AbstractCollection->filter() in src/addons/Siropu/AdsManager/Template/Ad.php at line 558
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 392
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 383
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- 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')
Run Time: 0.000101
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ad | range|filter | type,status,status_display_order | type|status | 102|102 | | 5 (37%) | Using index condition; Using where; Using rowid filter |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_siropu_ads_manager_ad.package_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 1428
- XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 662
- Siropu\AdsManager\Template\Ad->loadFilterAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 396
- Siropu\AdsManager\Template\Ad->setFilterAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 387
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 62
- Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/App.php at line 2212
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2081
- XF\App->preRender() in src/XF/Pub/App.php at line 451
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_session_activity`.*
FROM `xf_session_activity`
WHERE (`xf_session_activity`.`user_id` = 177714) AND (`xf_session_activity`.`unique_key` = '177714')
LIMIT 1
Run Time: 0.000101
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1395
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 359
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 404
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 196
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 119
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 313
- XF\Entity\User->getLastActivity() in src/XF/Mvc/Entity/Entity.php at line 167
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 119
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 522
- XF\Entity\User->canViewOnlineStatus() in src/XF/Entity/User.php at line 241
- XF\Entity\User->isOnline() in src/XF/Template/Templater.php at line 1195
- XF\Template\Templater->method() in internal_data/code_cache/templates/l11/s2/public/message_macros.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l11/s2/public/post_macros.php at line 25
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 991
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 927
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l11/s2/public/post_macros.php at line 154
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 991
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 927
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l11/s2/public/post_macros.php at line 198
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l11/s2/public/thread_view.php at line 826
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_thread_reply_ban`.*
FROM `xf_thread_reply_ban`
WHERE (`xf_thread_reply_ban`.`thread_id` = 124993) AND (`xf_thread_reply_ban`.`user_id` = 4294967295)
LIMIT 1
Run Time: 0.000104
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1395
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/FinderCollection.php at line 61
- XF\Mvc\Entity\FinderCollection->offsetGet() in src/XF/Mvc/Entity/FinderCollection.php at line 111
- XF\Mvc\Entity\FinderCollection->offsetExists() in src/XF/Entity/Thread.php at line 319
- XF\Entity\Thread->canReply() in src/XF/Entity/Thread.php at line 344
- XF\Entity\Thread->XF\Entity\{closure}() in src/XF.php at line 625
- XF::asVisitor() in src/XF.php at line 702
- XF::canPerformPreRegAction() in src/XF/Entity/Thread.php at line 343
- XF\Entity\Thread->canReplyPreReg() in src/XF/Template/Templater.php at line 1195
- XF\Template\Templater->method() in internal_data/code_cache/templates/l11/s2/public/post_macros.php at line 636
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l11/s2/public/post_macros.php at line 593
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l11/s2/public/post_macros.php at line 114
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 991
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 927
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l11/s2/public/post_macros.php at line 133
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 991
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 927
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l11/s2/public/post_macros.php at line 144
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 991
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 927
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l11/s2/public/post_macros.php at line 156
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 991
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 927
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l11/s2/public/post_macros.php at line 198
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l11/s2/public/thread_view.php at line 826
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('following_words_were_not_included_in_your_search_x')
Params: 11
Run Time: 0.000062
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 369
- XF\Language->loadPhrases() in src/XF/Language.php at line 261
- XF\Language->getPhraseText() in src/XF/Language.php at line 132
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 54
- XF\Phrase->render() in src/XF/Search/Source/AbstractSource.php at line 166
- XF\Search\Source\AbstractSource->parseKeywords() in src/XF/Search/Search.php at line 159
- XF\Search\Search->getParsedKeywords() in src/addons/BS/SimilarThreads/Repository/SimilarThreads.php at line 50
- BS\SimilarThreads\Repository\SimilarThreads->prepareQuery() in src/addons/BS/SimilarThreads/Repository/SimilarThreads.php at line 18
- BS\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/BS/SimilarThreads/Widget/SimilarThreads.php at line 26
- BS\SimilarThreads\Widget\SimilarThreads->render() in internal_data/code_cache/widgets/_20_similar_threads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l11/s2/public/thread_view.php at line 990
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT search_index.content_type, search_index.content_id
FROM xf_search_index AS search_index
WHERE MATCH(search_index.title, search_index.message, search_index.metadata) AGAINST ('Bu Gün Kalan Ömrümün Ilk Günü -_md_thread_124993 +_md_node_760 -_md_node_389 -_md_node_535 -_md_node_261 -_md_node_246 -_md_node_285 -_md_node_310 -_md_node_361 -_md_node_247 -_md_node_324 -_md_node_221 -_md_node_258 -_md_node_358 -_md_node_356 -_md_node_357 -_md_node_355 -_md_node_384 -_md_node_386 -_md_node_387 -_md_node_388 -_md_node_405 -_md_node_543 -_md_node_553 -_md_node_417 -_md_node_418 -_md_node_490 -_md_node_544 -_md_node_551 -_md_node_399 -_md_node_536 -_md_node_530 -_md_node_30 -_md_node_341 -_md_node_372 -_md_node_373 -_md_node_406 -_md_node_537 -_md_node_516 -_md_node_493 -_md_node_504 -_md_node_498 -_md_node_513 -_md_node_499 -_md_node_496 -_md_node_500 -_md_node_507 -_md_node_510 -_md_node_495 -_md_node_501 -_md_node_497 -_md_node_514 -_md_node_505 -_md_node_511 -_md_node_508 -_md_node_512 -_md_node_515 -_md_node_509 -_md_node_502 -_md_node_506 -_md_node_494 -_md_node_503 -_md_node_517 -_md_node_524 -_md_node_525 -_md_node_523 -_md_node_526 -_md_node_521 -_md_node_518 -_md_node_520 -_md_node_519 -_md_node_522 -_md_node_257 -_md_node_552 -_md_node_540 -_md_node_533 -_md_node_534 -_md_node_419 -_md_node_354 -_md_node_404 -_md_node_313 -_md_node_353 -_md_node_307 -_md_node_212 -_md_node_287 -_md_node_253 -_md_node_527 -_md_node_364 -_md_node_365 -_md_node_415 -_md_node_492 -_md_node_36 -_md_hidden_1' IN BOOLEAN MODE) AND search_index.content_type = 'thread'
ORDER BY search_index.item_date DESC
LIMIT 200
Run Time: 0.015728
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | search_index | fulltext | PRIMARY,title_message_metadata | title_message_metadata | 0 | | 1 | 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/Db/AbstractAdapter.php at line 162
- XF\Db\AbstractAdapter->fetchAllNum() in src/XF/Search/Source/MySqlFt.php at line 286
- XF\Search\Source\MySqlFt->search() in src/XF/Search/Search.php at line 185
- XF\Search\Search->XF\Search\{closure}() in src/XF/Search/Search.php at line 214
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 180
- XF\Search\Search->search() in src/XF/Repository/Search.php at line 33
- XF\Repository\Search->runSearch() in src/addons/BS/SimilarThreads/Repository/SimilarThreads.php at line 21
- BS\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/BS/SimilarThreads/Widget/SimilarThreads.php at line 26
- BS\SimilarThreads\Widget\SimilarThreads->render() in internal_data/code_cache/widgets/_20_similar_threads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l11/s2/public/thread_view.php at line 990
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (128529, 128493, 128480, 128472, 128432, 128411, 128404, 128398, 128325, 128319, 128275, 128260, 128236, 128229, 128223, 128201, 128200, 128199, 128198, 128183, 128181, 128174, 128134, 128108, 128098, 127887, 127878, 127835, 127827, 127764, 127736, 127726, 127694, 127665, 127548, 127409, 127341, 127338, 127188, 127130, 127128, 127090, 127087, 127083, 127007, 126995, 126928, 126887, 126880, 126874, 126866, 126863, 126862, 126837, 126717, 126710, 126701, 126686, 126682, 126672, 126665, 126641, 126599, 126596, 126584, 126581, 126577, 126571, 126541, 126519, 126484, 126479, 126449, 126432, 126424, 126414, 126399, 126369, 126346, 126316, 126304, 126252, 126237, 126216, 126215, 126210, 126184, 126183, 126161, 126115, 126068, 126064, 126063, 126042, 126041, 126022, 126001, 126000, 125979, 125971, 125968, 125967, 125905, 125896, 125893, 125842, 125834, 125824, 125801, 125800, 125799, 125796, 125786, 125775, 125772, 125767, 125755, 125749, 125732, 125726, 125721, 125715, 125709, 125696, 125683, 125677, 125670, 125668, 125663, 125653, 125630, 125609, 125606, 125571, 125564, 125553, 125550, 125536, 125531, 125529, 125526, 125525, 125524, 125522, 125447, 125429, 125418, 125375, 125369, 125305, 125297, 125222, 125208, 125202, 125197, 125195, 125187, 125185, 125172, 125170, 125169, 125139, 125128, 125119, 125084, 125071, 125054, 125051, 125041, 125024, 125012, 125011, 124992, 124990, 124944, 124943, 124935, 124911, 124910, 124907, 124906, 124902, 124889, 124873, 124861, 124797, 124767, 124762, 124758, 124755, 124713, 124691, 124644, 124634, 124607, 124601, 124599, 124594, 124570, 124569))
Run Time: 0.036880
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,gezenbilir_xen_foro.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/XF/Search/Search.php at line 216
- XF\Search\Search->executeSearch() in src/XF/Search/Search.php at line 180
- XF\Search\Search->search() in src/XF/Repository/Search.php at line 33
- XF\Repository\Search->runSearch() in src/addons/BS/SimilarThreads/Repository/SimilarThreads.php at line 21
- BS\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/BS/SimilarThreads/Widget/SimilarThreads.php at line 26
- BS\SimilarThreads\Widget\SimilarThreads->render() in internal_data/code_cache/widgets/_20_similar_threads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l11/s2/public/thread_view.php at line 990
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
BEGIN
Run Time: 0.000076
- XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 383
- XF\Db\AbstractAdapter->beginTransaction() in src/XF/Mvc/Entity/Entity.php at line 1251
- XF\Mvc\Entity\Entity->save() in src/XF/Repository/Search.php at line 40
- XF\Repository\Search->runSearch() in src/addons/BS/SimilarThreads/Repository/SimilarThreads.php at line 21
- BS\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/BS/SimilarThreads/Widget/SimilarThreads.php at line 26
- BS\SimilarThreads\Widget\SimilarThreads->render() in internal_data/code_cache/widgets/_20_similar_threads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l11/s2/public/thread_view.php at line 990
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
INSERT INTO `xf_search` (`search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `warnings`, `query_hash`, `user_id`, `result_count`, `search_results`, `search_id`, `user_results`, `search_date`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: thread, | Bu | Gün | Kalan | Ömrümün | Ilk | Günü, [], date, 0, {"keywords":"A\u015fa\u011f\u0131daki kelimeler \u00e7ok k\u0131sa, \u00e7ok uzun veya \u00e7ok yayg\u0131n olduklar\u0131 i\u00e7in araman\u0131za dahil edilmemi\u015ftir: Bu"}, 985e97619b0c74ad417021567e24c2f8, 0, 200, {"thread-128529":["thread",128529],"thread-128493":["thread",128493],"thread-128480":["thread",128480],"thread-128472":["thread",128472],"thread-128432":["thread",128432],"thread-128411":["thread",128411],"thread-128404":["thread",128404],"thread-128398":["thread",128398],"thread-128325":["thread",128325],"thread-128319":["thread",128319],"thread-128275":["thread",128275],"thread-128260":["thread",128260],"thread-128236":["thread",128236],"thread-128229":["thread",128229],"thread-128223":["thread",128223],"thread-128201":["thread",128201],"thread-128200":["thread",128200],"thread-128199":["thread",128199],"thread-128198":["thread",128198],"thread-128183":["thread",128183],"thread-128181":["thread",128181],"thread-128174":["thread",128174],"thread-128134":["thread",128134],"thread-128108":["thread",128108],"thread-128098":["thread",128098],"thread-127887":["thread",127887],"thread-127878":["thread",127878],"thread-127835":["thread",127835],"thread-127827":["thread",127827],"thread-127764":["thread",127764],"thread-127736":["thread",127736],"thread-127726":["thread",127726],"thread-127694":["thread",127694],"thread-127665":["thread",127665],"thread-127548":["thread",127548],"thread-127409":["thread",127409],"thread-127341":["thread",127341],"thread-127338":["thread",127338],"thread-127188":["thread",127188],"thread-127130":["thread",127130],"thread-127128":["thread",127128],"thread-127090":["thread",127090],"thread-127087":["thread",127087],"thread-127083":["thread",127083],"thread-127007":["thread",127007],"thread-126995":["thread",126995],"thread-126928":["thread",126928],"thread-126887":["thread",126887],"thread-126880":["thread",126880],"thread-126874":["thread",126874],"thread-126866":["thread",126866],"thread-126863":["thread",126863],"thread-126862":["thread",126862],"thread-126837":["thread",126837],"thread-126717":["thread",126717],"thread-126710":["thread",126710],"thread-126701":["thread",126701],"thread-126686":["thread",126686],"thread-126682":["thread",126682],"thread-126672":["thread",126672],"thread-126665":["thread",126665],"thread-126641":["thread",126641],"thread-126599":["thread",126599],"thread-126596":["thread",126596],"thread-126584":["thread",126584],"thread-126581":["thread",126581],"thread-126577":["thread",126577],"thread-126571":["thread",126571],"thread-126541":["thread",126541],"thread-126519":["thread",126519],"thread-126484":["thread",126484],"thread-126479":["thread",126479],"thread-126449":["thread",126449],"thread-126432":["thread",126432],"thread-126424":["thread",126424],"thread-126414":["thread",126414],"thread-126399":["thread",126399],"thread-126369":["thread",126369],"thread-126346":["thread",126346],"thread-126316":["thread",126316],"thread-126304":["thread",126304],"thread-126252":["thread",126252],"thread-126237":["thread",126237],"thread-126216":["thread",126216],"thread-126215":["thread",126215],"thread-126210":["thread",126210],"thread-126184":["thread",126184],"thread-126183":["thread",126183],"thread-126161":["thread",126161],"thread-126115":["thread",126115],"thread-126068":["thread",126068],"thread-126064":["thread",126064],"thread-126063":["thread",126063],"thread-126042":["thread",126042],"thread-126041":["thread",126041],"thread-126022":["thread",126022],"thread-126001":["thread",126001],"thread-126000":["thread",126000],"thread-125979":["thread",125979],"thread-125971":["thread",125971],"thread-125968":["thread",125968],"thread-125967":["thread",125967],"thread-125905":["thread",125905],"thread-125896":["thread",125896],"thread-125893":["thread",125893],"thread-125842":["thread",125842],"thread-125834":["thread",125834],"thread-125824":["thread",125824],"thread-125801":["thread",125801],"thread-125800":["thread",125800],"thread-125799":["thread",125799],"thread-125796":["thread",125796],"thread-125786":["thread",125786],"thread-125775":["thread",125775],"thread-125772":["thread",125772],"thread-125767":["thread",125767],"thread-125755":["thread",125755],"thread-125749":["thread",125749],"thread-125732":["thread",125732],"thread-125726":["thread",125726],"thread-125721":["thread",125721],"thread-125715":["thread",125715],"thread-125709":["thread",125709],"thread-125696":["thread",125696],"thread-125683":["thread",125683],"thread-125677":["thread",125677],"thread-125670":["thread",125670],"thread-125668":["thread",125668],"thread-125663":["thread",125663],"thread-125653":["thread",125653],"thread-125630":["thread",125630],"thread-125609":["thread",125609],"thread-125606":["thread",125606],"thread-125571":["thread",125571],"thread-125564":["thread",125564],"thread-125553":["thread",125553],"thread-125550":["thread",125550],"thread-125536":["thread",125536],"thread-125531":["thread",125531],"thread-125529":["thread",125529],"thread-125526":["thread",125526],"thread-125525":["thread",125525],"thread-125524":["thread",125524],"thread-125522":["thread",125522],"thread-125447":["thread",125447],"thread-125429":["thread",125429],"thread-125418":["thread",125418],"thread-125375":["thread",125375],"thread-125369":["thread",125369],"thread-125305":["thread",125305],"thread-125297":["thread",125297],"thread-125222":["thread",125222],"thread-125208":["thread",125208],"thread-125202":["thread",125202],"thread-125197":["thread",125197],"thread-125195":["thread",125195],"thread-125187":["thread",125187],"thread-125185":["thread",125185],"thread-125172":["thread",125172],"thread-125170":["thread",125170],"thread-125169":["thread",125169],"thread-125139":["thread",125139],"thread-125128":["thread",125128],"thread-125119":["thread",125119],"thread-125084":["thread",125084],"thread-125071":["thread",125071],"thread-125054":["thread",125054],"thread-125051":["thread",125051],"thread-125041":["thread",125041],"thread-125024":["thread",125024],"thread-125012":["thread",125012],"thread-125011":["thread",125011],"thread-124992":["thread",124992],"thread-124990":["thread",124990],"thread-124944":["thread",124944],"thread-124943":["thread",124943],"thread-124935":["thread",124935],"thread-124911":["thread",124911],"thread-124910":["thread",124910],"thread-124907":["thread",124907],"thread-124906":["thread",124906],"thread-124902":["thread",124902],"thread-124889":["thread",124889],"thread-124873":["thread",124873],"thread-124861":["thread",124861],"thread-124797":["thread",124797],"thread-124767":["thread",124767],"thread-124762":["thread",124762],"thread-124758":["thread",124758],"thread-124755":["thread",124755],"thread-124713":["thread",124713],"thread-124691":["thread",124691],"thread-124644":["thread",124644],"thread-124634":["thread",124634],"thread-124607":["thread",124607],"thread-124601":["thread",124601],"thread-124599":["thread",124599],"thread-124594":["thread",124594],"thread-124570":["thread",124570],"thread-124569":["thread",124569]}, NULL, [], 1714051853
Run Time: 0.000172
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 219
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1526
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1258
- XF\Mvc\Entity\Entity->save() in src/XF/Repository/Search.php at line 40
- XF\Repository\Search->runSearch() in src/addons/BS/SimilarThreads/Repository/SimilarThreads.php at line 21
- BS\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/BS/SimilarThreads/Widget/SimilarThreads.php at line 26
- BS\SimilarThreads\Widget\SimilarThreads->render() in internal_data/code_cache/widgets/_20_similar_threads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l11/s2/public/thread_view.php at line 990
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
COMMIT
Run Time: 0.000209
- XF\Db\AbstractAdapter->rawQuery() in src/XF/Db/AbstractAdapter.php at line 405
- XF\Db\AbstractAdapter->commit() in src/XF/Mvc/Entity/Entity.php at line 1302
- XF\Mvc\Entity\Entity->save() in src/XF/Repository/Search.php at line 40
- XF\Repository\Search->runSearch() in src/addons/BS/SimilarThreads/Repository/SimilarThreads.php at line 21
- BS\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/BS/SimilarThreads/Widget/SimilarThreads.php at line 26
- BS\SimilarThreads\Widget\SimilarThreads->render() in internal_data/code_cache/widgets/_20_similar_threads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l11/s2/public/thread_view.php at line 990
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_post_FirstPost_3`.*, `xf_user_User_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_3` ON (`xf_post_FirstPost_3`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (128529, 128493, 128480, 128472, 128432, 128411, 128404, 128398, 128325, 128319, 128275, 128260, 128236, 128229, 128223, 128201, 128200, 128199, 128198, 128183, 128181, 128174, 128134, 128108, 128098, 127887, 127878, 127835, 127827, 127764, 127736, 127726, 127694, 127665, 127548, 127409, 127341, 127338, 127188, 127130, 127128, 127090, 127087, 127083, 127007, 126995, 126928, 126887, 126880, 126874, 126866, 126863, 126862, 126837, 126717, 126710, 126701, 126686, 126682, 126672, 126665, 126641, 126599, 126596, 126584, 126581, 126577, 126571, 126541, 126519, 126484, 126479, 126449, 126432, 126424, 126414, 126399, 126369, 126346, 126316, 126304, 126252, 126237, 126216, 126215, 126210, 126184, 126183, 126161, 126115, 126068, 126064, 126063, 126042, 126041, 126022, 126001, 126000, 125979, 125971, 125968, 125967, 125905, 125896, 125893, 125842, 125834, 125824, 125801, 125800, 125799, 125796, 125786, 125775, 125772, 125767, 125755, 125749, 125732, 125726, 125721, 125715, 125709, 125696, 125683, 125677, 125670, 125668, 125663, 125653, 125630, 125609, 125606, 125571, 125564, 125553, 125550, 125536, 125531, 125529, 125526, 125525, 125524, 125522, 125447, 125429, 125418, 125375, 125369, 125305, 125297, 125222, 125208, 125202, 125197, 125195, 125187, 125185, 125172, 125170, 125169, 125139, 125128, 125119, 125084, 125071, 125054, 125051, 125041, 125024, 125012, 125011, 124992, 124990, 124944, 124943, 124935, 124911, 124910, 124907, 124906, 124902, 124889, 124873, 124861, 124797, 124767, 124762, 124758, 124755, 124713, 124691, 124644, 124634, 124607, 124601, 124599, 124594, 124570, 124569))
Run Time: 0.000332
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_post_FirstPost_3 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,gezenbilir_xen_foro.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/Search/Data/AbstractData.php at line 137
- XF\Search\Data\AbstractData->getContent() in src/XF/Search/Search.php at line 266
- XF\Search\Search->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/ResultSet.php at line 183
- XF\ResultSet->sliceResults() in src/XF/ResultSet.php at line 193
- XF\ResultSet->limitResults() in src/addons/BS/SimilarThreads/Repository/SimilarThreads.php at line 28
- BS\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/BS/SimilarThreads/Widget/SimilarThreads.php at line 26
- BS\SimilarThreads\Widget\SimilarThreads->render() in internal_data/code_cache/widgets/_20_similar_threads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l11/s2/public/thread_view.php at line 990
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 169384)
LIMIT 1
Run Time: 0.000091
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1395
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 359
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 404
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 196
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l11/s2/public/thread_list_macros.php at line 460
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 991
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 927
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l11/s2/public/thread_list_macros.php at line 516
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l11/s2/public/widget_similar_threads.php at line 78
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1940
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l11/s2/public/thread_view.php at line 990
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 170658)
LIMIT 1
Run Time: 0.000090
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1395
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 359
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 404
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 196
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l11/s2/public/thread_list_macros.php at line 460
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 991
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 927
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l11/s2/public/thread_list_macros.php at line 516
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l11/s2/public/widget_similar_threads.php at line 78
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1940
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l11/s2/public/thread_view.php at line 990
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 143304)
LIMIT 1
Run Time: 0.000390
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1395
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 359
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 404
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 196
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 125
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l11/s2/public/thread_list_macros.php at line 460
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 991
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 927
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l11/s2/public/thread_list_macros.php at line 516
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l11/s2/public/widget_similar_threads.php at line 78
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 1940
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l11/s2/public/thread_view.php at line 990
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (27, 1, 23, 5, 262))
Run Time: 0.000083
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | range | PRIMARY | PRIMARY | 4 | | 5 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,gezenbilir_xen_foro.xf_node.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 215
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 330
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7702
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE ((`xf_node`.`lft` > 149 AND `xf_node`.`rgt` < 450) OR (`xf_node`.`lft` > 451 AND `xf_node`.`rgt` < 546) OR (`xf_node`.`lft` > 603 AND `xf_node`.`rgt` < 904) OR (`xf_node`.`lft` > 5 AND `xf_node`.`rgt` < 148) OR (`xf_node`.`lft` > 606 AND `xf_node`.`rgt` < 645)) AND (`xf_node`.`display_in_list` = 1)
ORDER BY `xf_node`.`lft` ASC
Run Time: 0.000362
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list,lft | | | | 581 | Using where; Using filesort |
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,gezenbilir_xen_foro.xf_node.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Navigation/NodeType.php at line 250
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 330
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7702
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- 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, 23, 27))
Run Time: 0.000071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_category | index | PRIMARY | PRIMARY | 4 | | 12 | Using where; Using index |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.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 1428
- 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/Navigation/NodeType.php at line 254
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 330
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7702
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- 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 (262, 51, 338, 554, 555, 556, 557, 558, 559, 560, 561, 339, 588, 562, 563, 564, 565, 566, 578, 758, 760, 761, 401, 567, 569, 570, 571, 572, 573, 574, 568, 575, 576, 577, 579, 336, 335, 763, 582, 581, 586, 583, 580, 585, 334, 390, 391, 392, 528, 393, 394, 395, 396, 397, 398, 400, 773, 337, 340, 598, 589, 591, 592, 593, 590, 594, 595, 596, 597, 764, 765, 612, 610, 611, 613, 614, 615, 616, 617, 618, 619, 620, 629, 630, 631, 632, 633, 634, 635, 683, 684, 685, 686, 687, 688, 689, 690, 636, 637, 638, 691, 692, 639, 693, 694, 695, 696, 697, 640, 641, 698, 699, 700, 701, 702, 642, 643, 704, 739, 705, 706, 644, 645, 707, 708, 709, 646, 710, 711, 712, 647, 648, 713, 649, 714, 715, 650, 716, 717, 718, 719, 720, 721, 722, 723, 651, 652, 724, 725, 653, 654, 655, 656, 726, 727, 728, 729, 730, 657, 658, 659, 660, 661, 731, 732, 733, 734, 663, 737, 735, 736, 662, 664, 738, 740, 741, 742, 743, 744, 665, 666, 667, 668, 669, 670, 671, 672, 673, 745, 746, 747, 748, 749, 674, 675, 703, 750, 771, 751, 676, 677, 678, 752, 753, 754, 755, 756, 679, 680, 681, 682, 621, 624, 627, 628, 625, 626, 622, 772, 623, 10, 77, 57, 66, 67, 58, 60, 72, 46, 327, 328, 329, 330, 331, 332, 333, 326, 17, 78, 11, 240, 242, 244, 239, 375, 374, 241, 377, 376, 56, 168, 169, 170, 48, 55, 259, 308, 47, 383, 378, 379, 380, 381, 382, 370, 292, 32, 269, 273, 270, 272, 274, 271, 275, 276, 33, 277, 278, 279, 280, 281, 282, 283, 284, 31, 41, 266, 267, 268, 311, 312, 286, 61, 34, 176, 172, 211, 178, 363, 362, 288, 289, 290, 291, 63, 223, 293, 360, 238, 371, 167, 40, 414, 413, 412, 411, 410, 314, 265, 175, 294, 295, 296, 297, 315, 298, 210, 263, 264, 62, 19, 171, 83, 84, 85, 87, 88, 89, 90, 91, 94, 93, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166))
Run Time: 0.000300
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | PRIMARY | | | | 573 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.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 1428
- 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/Navigation/NodeType.php at line 254
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 133
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 330
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 7702
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 578
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 529
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- 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.000071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 136
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 228
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1931
- XF\App->XF\{closure}() in src/XF/Container.php at line 31
- XF\Container->offsetGet() in src/XF/App.php at line 2564
- XF\App->__get() in src/XF/Widget/ForumStatistics.php at line 10
- XF\Widget\ForumStatistics->render() in internal_data/code_cache/widgets/_7_forum_overview_forum_statistics.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in src/XF/Pub/App.php at line 555
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT
SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
SUM(IF(user_id > 0, 1, 0)) AS members,
SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
FROM xf_session_activity
WHERE view_date >= ?
Params: 1714048253
Run Time: 0.000751
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 901 | 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 147
- XF\Db\AbstractAdapter->fetchRow() in src/XF/Repository/SessionActivity.php at line 18
- XF\Repository\SessionActivity->getOnlineCounts() in src/XF/Repository/SessionActivity.php at line 62
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in src/XF/Pub/App.php at line 555
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_session_activity`.*, `xf_user_User_1`.*
FROM `xf_session_activity`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`)
WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1714048253)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000349
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | PRIMARY | 4 | | 25 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | gezenbilir_xen_foro.xf_session_activity.user_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/SessionActivity.php at line 43
- XF\Repository\SessionActivity->getOnlineUsersList() in src/XF/Repository/SessionActivity.php at line 63
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in src/XF/Pub/App.php at line 555
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_session_activity`.*, `xf_user_User_1`.*
FROM `xf_session_activity`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`)
WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1714048253) AND (`xf_user_User_1`.`is_staff` = 1)
ORDER BY `xf_session_activity`.`view_date` DESC
Run Time: 0.000302
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_User_1 | ref | PRIMARY,user_state,staff_username | staff_username | 1 | const | 1 | Using index condition; Using where; Using temporary; Using filesort |
SIMPLE | xf_session_activity | ref | PRIMARY,view_date | PRIMARY | 4 | gezenbilir_xen_foro.xf_user_User_1.user_id | 13 | 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 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/SessionActivity.php at line 57
- XF\Repository\SessionActivity->getOnlineStaffList() in src/XF/Repository/SessionActivity.php at line 79
- XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 25
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in src/XF/Pub/App.php at line 555
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_member_stat`.*
FROM `xf_member_stat`
WHERE (`xf_member_stat`.`member_stat_key` = 'todays_birthdays')
LIMIT 1
Run Time: 0.000070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_member_stat | const | member_stat_key | member_stat_key | 52 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1395
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 170
- XF\Mvc\Entity\Manager->findOne() in src/XF/Widget/AbstractWidget.php at line 191
- XF\Widget\AbstractWidget->findOne() in src/XF/Widget/MemberStat.php at line 36
- XF\Widget\MemberStat->render() in internal_data/code_cache/widgets/_39_uye.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in src/XF/Pub/App.php at line 555
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*, `xf_user_profile_Profile_1`.*, `xf_user_option_Option_2`.*
FROM `xf_user`
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_1` ON (`xf_user_profile_Profile_1`.`user_id` = `xf_user`.`user_id`)
INNER JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid') AND (`xf_user_profile_Profile_1`.`dob_day` = 25) AND (`xf_user_profile_Profile_1`.`dob_month` = 4) AND (`xf_user_option_Option_2`.`show_dob_date` = 1) AND (`xf_user`.`last_activity` > 1682515853) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
ORDER BY `xf_user`.`username` ASC
LIMIT 60
Run Time: 0.001174
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_profile_Profile_1 | ref | PRIMARY,dob | dob | 2 | const,const | 57 | Using temporary; Using filesort |
SIMPLE | xf_user | eq_ref | PRIMARY,user_state,last_activity | PRIMARY | 4 | gezenbilir_xen_foro.xf_user_profile_Profile_1.user_id | 1 | Using where |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_user_profile_Profile_1.user_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/MemberStat/Birthdays.php at line 14
- XF\MemberStat\Birthdays::getBirthdayUsers() in src/XF/Service/MemberStat/Preparer.php at line 145
- XF\Service\MemberStat\Preparer->applyCallback() in src/XF/Service/MemberStat/Preparer.php at line 208
- XF\Service\MemberStat\Preparer->getResultsData() in src/XF/Service/MemberStat/Preparer.php at line 102
- XF\Service\MemberStat\Preparer->getResults() in src/XF/Entity/MemberStat.php at line 124
- XF\Entity\MemberStat->getResults() in src/XF/Widget/MemberStat.php at line 44
- XF\Widget\MemberStat->render() in internal_data/code_cache/widgets/_39_uye.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in src/XF/Pub/App.php at line 555
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*, `xf_user_option_Option_1`.*, `xf_user_profile_Profile_2`.*
FROM `xf_user`
INNER JOIN `xf_user_option` AS `xf_user_option_Option_1` ON (`xf_user_option_Option_1`.`user_id` = `xf_user`.`user_id`)
INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_2` ON (`xf_user_profile_Profile_2`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` IN (152306, 7382, 163528, 163296)) AND (`xf_user`.`is_banned` = 0) AND (`xf_user`.`user_state` = 'valid')
Run Time: 0.000132
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | range | PRIMARY,user_state | user_state | 5 | | 4 | Using index condition; Using where |
SIMPLE | xf_user_profile_Profile_2 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_user.user_id | 1 | |
SIMPLE | xf_user_option_Option_1 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_user.user_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 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/MemberStat.php at line 55
- XF\Widget\MemberStat->render() in internal_data/code_cache/widgets/_39_uye.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in src/XF/Pub/App.php at line 555
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- 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` > 1698499853)
ORDER BY `xf_thread`.`last_post_date` DESC
LIMIT 20
Run Time: 0.000934
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | last_post_date | last_post_date | 4 | | 492 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_thread.node_id | 1 | Using where |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_thread.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,gezenbilir_xen_foro.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_thread.last_post_user_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 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewPosts.php at line 89
- XF\Widget\NewPosts->render() in internal_data/code_cache/widgets/_13_yeni_mesajlar.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in src/XF/Pub/App.php at line 555
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- 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`.`post_date` >= 1708867853)
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 40
Run Time: 0.000801
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | post_date | post_date | 4 | | 75 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | gezenbilir_xen_foro.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,gezenbilir_xen_foro.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewThreads.php at line 71
- XF\Widget\NewThreads->render() in internal_data/code_cache/widgets/_14_yeni_konular.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in src/XF/Pub/App.php at line 555
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT tag_id
FROM xf_tag
WHERE use_count >= ?
ORDER BY use_count DESC
LIMIT 50
Params: 20
Run Time: 0.000064
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag | range | use_count | use_count | 4 | | 70 | Using where; Using index |
- 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 172
- XF\Db\AbstractAdapter->fetchAllColumn() in src/XF/Repository/Tag.php at line 267
- XF\Repository\Tag->getTagsForCloud() in src/addons/DL6/WTC/Widget/TagCloud.php at line 24
- DL6\WTC\Widget\TagCloud->render() in internal_data/code_cache/widgets/_23_POPULER_TAGS.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in src/XF/Pub/App.php at line 555
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_tag`.*
FROM `xf_tag`
WHERE (`xf_tag`.`tag_id` IN (109, 9, 2, 19, 25, 281, 6846, 127, 154, 161, 41, 91, 520, 210, 156, 304, 5, 5003, 763, 2515, 663, 6829, 157, 101, 100, 57, 27, 836, 4, 615, 805, 311, 344, 1, 878, 798, 6896, 518, 436, 93, 1082, 319, 440, 6834, 816, 730, 613, 538, 162, 384))
ORDER BY `xf_tag`.`tag` ASC
Run Time: 0.000081
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag | range | PRIMARY | PRIMARY | 4 | | 50 | 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 1428
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/Tag.php at line 278
- XF\Repository\Tag->getTagsForCloud() in src/addons/DL6/WTC/Widget/TagCloud.php at line 24
- DL6\WTC\Widget\TagCloud->render() in internal_data/code_cache/widgets/_23_POPULER_TAGS.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
- 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 1940
- XF\Template\Templater->widgetPosition() in src/XF/Pub/App.php at line 555
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_addon`.*
FROM `xf_addon`
WHERE (`xf_addon`.`addon_id` = 'Tapatalk')
LIMIT 1
Run Time: 0.000058
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_addon | const | PRIMARY | PRIMARY | 52 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1395
- XF\Mvc\Entity\Finder->fetchOne() in src/addons/Tapatalk/Listener/Hook.php at line 22
- Tapatalk\Listener\Hook::templateHook() in src/XF/Extension.php at line 49
- XF\Extension->fire() in src/XF/App.php at line 2994
- XF\App->fire() in src/XF/Template/Templater.php at line 1614
- XF\Template\Templater->renderTemplate() in src/addons/MaZ/AUN/XF/Template/Templater.php at line 39
- MaZ\AUN\XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2285
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20