SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')
Run Time: 0.000865
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 36 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
- XF\DataRegistry->get() in src/XF/App.php at line 1752
- XF\App->preLoadData() in src/XF/App.php at line 1740
- XF\App->setup() in src/XF/Pub/App.php at line 89
- XF\Pub\App->setup() in src/XF.php at line 363
- XF::setupApp() in src/XF.php at line 386
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000177
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 926
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 241
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 123
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 320
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_thread`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` = '54275')
LIMIT 1
Run Time: 0.001671
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Thread.php at line 1372
- XF\Pub\Controller\Thread->assertViewableThread() in src/XF/Pub/Controller/Thread.php at line 12
- XF\Pub\Controller\Thread->actionIndex() in src/addons/xenMade/SEO/XF/Pub/Controller/Thread.php at line 11
- xenMade\SEO\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\XF\Pub\Controller\Thread->actionIndex() in src/addons/Bcat/Xencat/Pub/Controller/Thread.php at line 10
- Bcat\Xencat\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/PostComments/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\PostComments\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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_session_activity_Activity_5`.*
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_session_activity` AS `xf_session_activity_Activity_5` ON (`xf_session_activity_Activity_5`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_5`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, ''))
WHERE (`xf_post`.`thread_id` = 54275) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 20)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`thpostcomments_lft` ASC, `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Run Time: 0.001959
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | const | 1 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_5 | eq_ref | PRIMARY | PRIMARY | 22 | waytomarketing_c.xf_user_User_1.user_id,func | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Thread.php at line 35
- XF\Pub\Controller\Thread->actionIndex() in src/addons/xenMade/SEO/XF/Pub/Controller/Thread.php at line 11
- xenMade\SEO\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\XF\Pub\Controller\Thread->actionIndex() in src/addons/Bcat/Xencat/Pub/Controller/Thread.php at line 10
- Bcat\Xencat\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/PostComments/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\PostComments\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
INSERT INTO xf_thread_view
(thread_id, total)
VALUES
(? , 1)
ON DUPLICATE KEY UPDATE
total = total + 1
Params: 54275
Run Time: 0.000326
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Repository/Thread.php at line 194
- XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 90
- XF\Pub\Controller\Thread->actionIndex() in src/addons/xenMade/SEO/XF/Pub/Controller/Thread.php at line 11
- xenMade\SEO\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\XF\Pub\Controller\Thread->actionIndex() in src/addons/Bcat/Xencat/Pub/Controller/Thread.php at line 10
- Bcat\Xencat\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/PostComments/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\PostComments\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_thread_prefix`.*
FROM `xf_thread_prefix`
WHERE (`xf_thread_prefix`.`prefix_id` IN (1, 5, 6, 8, 7))
ORDER BY `xf_thread_prefix`.`materialized_order` ASC
Run Time: 0.000186
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread_prefix | range | PRIMARY | PRIMARY | 4 | | 5 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Entity/Forum.php at line 220
- XF\Entity\Forum->getPrefixes() in src/addons/xenMade/SEO/Repository/NoIndex.php at line 35
- xenMade\SEO\Repository\NoIndex->noIndex() in src/addons/xenMade/SEO/XF/Pub/Controller/Thread.php at line 368
- xenMade\SEO\XF\Pub\Controller\Thread->changeSeoData() in src/addons/xenMade/SEO/XF/Pub/Controller/Thread.php at line 599
- xenMade\SEO\XF\Pub\Controller\Thread->changeSeoFromRes() in src/addons/xenMade/SEO/XF/Pub/Controller/Thread.php at line 34
- xenMade\SEO\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\XF\Pub\Controller\Thread->actionIndex() in src/addons/Bcat/Xencat/Pub/Controller/Thread.php at line 10
- Bcat\Xencat\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/PostComments/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\PostComments\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE (`xf_thread`.`title` LIKE '%sánh%') AND (`xf_thread`.`title` LIKE '%cước%') AND (`xf_thread`.`title` LIKE '%phí%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 54275) AND ((`xf_thread`.`node_id` = 6))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 10
Run Time: 0.002063
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date | node_id_last_post_date | 4 | const | 269 | Using index condition; Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 210
- Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\XF\Pub\Controller\Thread->actionIndex() in src/addons/Bcat/Xencat/Pub/Controller/Thread.php at line 10
- Bcat\Xencat\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/PostComments/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\PostComments\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE (`xf_thread`.`title` LIKE '%sánh%') AND (`xf_thread`.`title` LIKE '%cước%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 54275) AND (1) AND ((`xf_thread`.`node_id` = 6))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 10
Run Time: 0.001707
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date | node_id_last_post_date | 4 | const | 269 | Using index condition; Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 259
- Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\XF\Pub\Controller\Thread->actionIndex() in src/addons/Bcat/Xencat/Pub/Controller/Thread.php at line 10
- Bcat\Xencat\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/PostComments/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\PostComments\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE (`xf_thread`.`title` LIKE '%sánh%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 54275) AND (1) AND ((`xf_thread`.`node_id` = 6))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 10
Run Time: 0.001663
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date | node_id_last_post_date | 4 | const | 269 | Using index condition; Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 308
- Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\XF\Pub\Controller\Thread->actionIndex() in src/addons/Bcat/Xencat/Pub/Controller/Thread.php at line 10
- Bcat\Xencat\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/PostComments/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\PostComments\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE (`xf_thread`.`title` LIKE '%cước%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 54275) AND (`xf_thread`.`thread_id` <> 559) AND ((`xf_thread`.`node_id` = 6))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 9
Run Time: 0.001717
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date | node_id_last_post_date | 4 | const | 269 | Using index condition; Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 357
- Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\XF\Pub\Controller\Thread->actionIndex() in src/addons/Bcat/Xencat/Pub/Controller/Thread.php at line 10
- Bcat\Xencat\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/PostComments/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\PostComments\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE (`xf_thread`.`title` LIKE '%cước%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`post_date` >= 0) AND (`xf_thread`.`thread_id` <> 54275) AND (`xf_thread`.`thread_id` <> 559 AND `xf_thread`.`thread_id` <> 20997) AND ((`xf_thread`.`node_id` = 6))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 8
Run Time: 0.028442
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,post_date | post_date | 4 | | 6310 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 406
- Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\XF\Pub\Controller\Thread->actionIndex() in src/addons/Bcat/Xencat/Pub/Controller/Thread.php at line 10
- Bcat\Xencat\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/PostComments/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\PostComments\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*
FROM `xf_thread`
WHERE ((`xf_thread`.`thread_id` = 559) OR (`xf_thread`.`thread_id` = 20997))
ORDER BY `xf_thread`.`post_date` DESC
Run Time: 0.000650
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 2 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 449
- Andy\SimilarThreads\Repository\SimilarThreads->getSimilarThreads() in src/addons/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 54
- Andy\SimilarThreads\XF\Pub\Controller\Thread->actionIndex() in src/addons/Andy/History/XF/Pub/Controller/Thread.php at line 12
- Andy\History\XF\Pub\Controller\Thread->actionIndex() in src/addons/Bcat/Xencat/Pub/Controller/Thread.php at line 10
- Bcat\Xencat\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/PostComments/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\PostComments\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `bc_xencat_articles`.*
FROM `bc_xencat_articles`
WHERE (`bc_xencat_articles`.`thread_id` = 54275)
LIMIT 1
Run Time: 0.000300
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 364
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/Bcat/Xencat/Pub/Controller/Thread.php at line 18
- Bcat\Xencat\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/PostComments/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\PostComments\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `bc_xencat_features`.*
FROM `bc_xencat_features`
WHERE (`bc_xencat_features`.`thread_id` = 54275)
LIMIT 1
Run Time: 0.000338
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/addons/Bcat/Xencat/Repository/Feature.php at line 22
- Bcat\Xencat\Repository\Feature->fetchFeatureByThread() in src/addons/Bcat/Xencat/Pub/Controller/Thread.php at line 22
- Bcat\Xencat\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/PostComments/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\PostComments\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
INSERT INTO xf_session_activity
(`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , XF\Pub\Controller\Thread, Index, valid, thread_id=54275, 1611670912,
Run Time: 0.000286
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 81
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 41
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 284
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 343
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('mjstStatusStyles')
Run Time: 0.000164
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 226
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1643
- XF\App->XF\{closure}() in src/XF/Container.php at line 28
- XF\Container->offsetGet() in src/addons/MJ/SupportTicket/Listener.php at line 73
- MJ\SupportTicket\Listener::templaterSetup()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2647
- XF\App->fire() in src/XF/App.php at line 1704
- XF\App->setupTemplaterObject() in src/XF/App.php at line 1296
- XF\App->XF\{closure}() in src/XF/Container.php at line 28
- XF\Container->offsetGet() in src/XF/App.php at line 2961
- XF\App->templater() in src/XF/Pub/App.php at line 424
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 355
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 2
Run Time: 0.000183
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 926
- XF\Entity\User->hasPermission() in src/addons/KL/UserImprovements/Template/Templater.php at line 32
- KL\UserImprovements\Template\Templater->fnUsernameClasses() in src/XF/Template/Templater.php at line 3876
- XF\Template\Templater->fnUsernameLink()
- call_user_func_array() in src/XF/Template/Templater.php at line 922
- XF\Template\Templater->fn() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 90
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 189218)
LIMIT 1
Run Time: 0.000856
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 51
- DC\ThreadThumbnail\XF\Entity\Thread->getThumbnail()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 147
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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` = 59836)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000532
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 57
- DC\ThreadThumbnail\XF\Entity\Thread->getThumbnail()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 147
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 189218)
LIMIT 1
Run Time: 0.000692
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 51
- DC\ThreadThumbnail\XF\Entity\Thread->getThumbnail()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 156
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 189218)
LIMIT 1
Run Time: 0.000663
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 51
- DC\ThreadThumbnail\XF\Entity\Thread->getThumbnail()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 159
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_session_activity`.*
FROM `xf_session_activity`
WHERE (`xf_session_activity`.`user_id` = 189218) AND (`xf_session_activity`.`unique_key` = '189218')
LIMIT 1
Run Time: 0.000365
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 300
- XF\Entity\User->getLastActivity() in src/XF/Mvc/Entity/Entity.php at line 148
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 467
- XF\Entity\User->canViewOnlineStatus() in src/XF/Entity/User.php at line 228
- XF\Entity\User->isOnline()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/message_macros.php at line 14
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/post_macros.php at line 48
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 639
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 184397)
LIMIT 1
Run Time: 0.001234
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l3/s8/public/andy_similarthreads.php at line 28
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 768
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`user_id` = 120)
LIMIT 1
Run Time: 0.001011
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 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 106
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l3/s8/public/andy_similarthreads.php at line 28
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 768
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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` FORCE INDEX (`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')
WHERE (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`node_id` IN (185, 181, 71, 162, 73, 29, 6, 7, 14, 58, 103, 12, 13, 67, 102, 77))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 40
Run Time: 0.001393
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | index | | post_date | 4 | | 40 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,waytomarketing_c.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewThreads.php at line 62
- XF\Widget\NewThreads->render() in internal_data/code_cache/widgets/_56_new_threads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6649
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*
FROM `xf_post`
WHERE (`xf_post`.`post_id` = 60401)
LIMIT 1
Run Time: 0.000267
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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` = 60401)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000241
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*
FROM `xf_post`
WHERE (`xf_post`.`post_id` = 60399)
LIMIT 1
Run Time: 0.000279
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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` = 60399)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000252
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*
FROM `xf_post`
WHERE (`xf_post`.`post_id` = 60396)
LIMIT 1
Run Time: 0.000283
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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` = 60396)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000273
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*
FROM `xf_post`
WHERE (`xf_post`.`post_id` = 60395)
LIMIT 1
Run Time: 0.000275
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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` = 60395)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000253
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*
FROM `xf_post`
WHERE (`xf_post`.`post_id` = 60394)
LIMIT 1
Run Time: 0.000270
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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` = 60394)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000263
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*
FROM `xf_post`
WHERE (`xf_post`.`post_id` = 60393)
LIMIT 1
Run Time: 0.000292
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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` = 60393)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000268
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*
FROM `xf_post`
WHERE (`xf_post`.`post_id` = 60392)
LIMIT 1
Run Time: 0.000289
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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` = 60392)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000295
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*
FROM `xf_post`
WHERE (`xf_post`.`post_id` = 60391)
LIMIT 1
Run Time: 0.000386
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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` = 60391)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000284
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*
FROM `xf_post`
WHERE (`xf_post`.`post_id` = 60390)
LIMIT 1
Run Time: 0.000294
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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` = 60390)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000277
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*
FROM `xf_post`
WHERE (`xf_post`.`post_id` = 60389)
LIMIT 1
Run Time: 0.000287
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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` = 60389)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000261
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 446
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_threads.php at line 47
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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` > 1609078912) AND (`xf_thread`.`node_id` IN (185, 181, 71, 162, 73, 29, 6, 7, 14, 58, 103, 12, 13, 67, 102, 2, 76, 4, 77))
ORDER BY `xf_thread`.`last_post_date` DESC
LIMIT 20
Run Time: 0.004923
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | last_post_date | last_post_date | 4 | | 418 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_thread.node_id | 1 | Using where |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_thread.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,waytomarketing_c.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_thread.last_post_user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewPosts.php at line 87
- XF\Widget\NewPosts->render() in internal_data/code_cache/widgets/_9_forum_overview_new_posts.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6649
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*
FROM `xf_post`
WHERE (`xf_post`.`post_id` = 60154)
LIMIT 1
Run Time: 0.000301
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 357
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 394
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_posts.php at line 80
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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` = 60154)
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000282
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | waytomarketing_c.xf_attachment.data_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 378
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/DC/ThreadThumbnail/XF/Entity/Thread.php at line 118
- DC\ThreadThumbnail\XF\Entity\Thread->getfirstPostAttach()
- call_user_func_array() in src/XF/Template/Templater.php at line 985
- XF\Template\Templater->method() in internal_data/code_cache/templates/l3/s8/public/DC_ThreadThumbnail_threadList.php at line 18
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1374
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l3/s8/public/thread_list_macros.php at line 394
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 701
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l3/s8/public/widget_new_posts.php at line 80
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_user`.*
FROM `xf_user`
WHERE (`xf_user`.`andy_most_reactions_count` > 0) AND (`xf_user`.`is_banned` != 1)
ORDER BY `xf_user`.`andy_most_reactions_count` DESC, `xf_user`.`username` ASC
LIMIT 25
Run Time: 0.000488
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | ALL | | | | | 100328 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/Andy/MostReactions/Widget/MostReactions.php at line 24
- Andy\MostReactions\Widget\MostReactions->render() in internal_data/code_cache/widgets/_62_most_reactions.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6649
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_option`.*
FROM `xf_option`
WHERE (`xf_option`.`option_id` = 'userTitleLadderField')
LIMIT 1
Run Time: 0.000177
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_option | const | PRIMARY | PRIMARY | 52 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/addons/KL/UserImprovements/Widget/UserTitleLadder.php at line 24
- KL\UserImprovements\Widget\UserTitleLadder->render() in internal_data/code_cache/widgets/_32_progress_to_next_level.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6649
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
SELECT `xf_user_title_ladder`.*
FROM `xf_user_title_ladder`
ORDER BY `xf_user_title_ladder`.`minimum_level` ASC
Run Time: 0.000139
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_title_ladder | index | | PRIMARY | 4 | | 18 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/KL/UserImprovements/Widget/UserTitleLadder.php at line 27
- KL\UserImprovements\Widget\UserTitleLadder->render() in internal_data/code_cache/widgets/_32_progress_to_next_level.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6649
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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.000133
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 226
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1643
- XF\App->XF\{closure}() in src/XF/Container.php at line 28
- XF\Container->offsetGet() in src/XF/App.php at line 2250
- 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 6649
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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: 1611667312
Run Time: 0.000486
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 88 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 145
- XF\Db\AbstractAdapter->fetchRow() in src/XF/Repository/SessionActivity.php at line 18
- XF\Repository\SessionActivity->getOnlineCounts() in src/addons/XenBulletins/FakeActivity/XF/Repository/SessionActivity.php at line 55
- XenBulletins\FakeActivity\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 6649
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- 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` >= 1611667312)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.001184
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | PRIMARY | 4 | | 2 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | waytomarketing_c.xf_session_activity.user_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/XenBulletins/FakeActivity/XF/Repository/SessionActivity.php at line 90
- XenBulletins\FakeActivity\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 6649
- 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 1620
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l3/s8/public/thread_view.php at line 776
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1301
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 418
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 360
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 53
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20
bytes_sent | 38605 |
bytes_received | 1012067 |
packets_sent | 640 |
packets_received | 5815 |
protocol_overhead_in | 23260 |
protocol_overhead_out | 2560 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 1944 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 564 |
bytes_received_prepare_response_packet | 402264 |
bytes_received_change_user_packet | 604971 |
packets_sent_command | 319 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 216 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 108 |
packets_received_prepare_response | 5048 |
packets_received_change_user | 335 |
result_set_queries | 104 |
non_result_set_queries | 4 |
no_index_used | 3 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 104 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 105 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 231 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 231 |
rows_fetched_from_client_normal_buffered | 0 |
rows_fetched_from_client_normal_unbuffered | 0 |
rows_fetched_from_client_ps_buffered | 0 |
rows_fetched_from_client_ps_unbuffered | 0 |
rows_fetched_from_client_ps_cursor | 0 |
rows_affected_normal | 0 |
rows_affected_ps | 0 |
rows_skipped_normal | 0 |
rows_skipped_ps | 231 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 0 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 1 |
active_connections | 1 |
active_persistent_connections | 1 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 0 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_estrdup_count | 0 |
mem_strdup_count | 0 |
mem_edupl_count | 0 |
mem_dupl_count | 0 |
proto_text_fetched_null | 0 |
proto_text_fetched_bit | 0 |
proto_text_fetched_tinyint | 0 |
proto_text_fetched_short | 0 |
proto_text_fetched_int24 | 0 |
proto_text_fetched_int | 0 |
proto_text_fetched_bigint | 0 |
proto_text_fetched_decimal | 0 |
proto_text_fetched_float | 0 |
proto_text_fetched_double | 0 |
proto_text_fetched_date | 0 |
proto_text_fetched_year | 0 |
proto_text_fetched_time | 0 |
proto_text_fetched_datetime | 0 |
proto_text_fetched_timestamp | 0 |
proto_text_fetched_string | 0 |
proto_text_fetched_blob | 0 |
proto_text_fetched_enum | 0 |
proto_text_fetched_set | 0 |
proto_text_fetched_geometry | 0 |
proto_text_fetched_other | 0 |
proto_binary_fetched_null | 0 |
proto_binary_fetched_bit | 603 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 1794 |
proto_binary_fetched_int24 | 499 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 5439 |
proto_binary_fetched_decimal | 83 |
proto_binary_fetched_float | 3 |
proto_binary_fetched_double | 65 |
proto_binary_fetched_date | 0 |
proto_binary_fetched_year | 0 |
proto_binary_fetched_time | 0 |
proto_binary_fetched_datetime | 0 |
proto_binary_fetched_timestamp | 0 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 3200 |
proto_binary_fetched_blob | 1050 |
proto_binary_fetched_enum | 0 |
proto_binary_fetched_set | 0 |
proto_binary_fetched_geometry | 0 |
proto_binary_fetched_other | 0 |
init_command_executed_count | 0 |
init_command_failed_count | 0 |
com_quit | 0 |
com_init_db | 0 |
com_query | 2 |
com_field_list | 0 |
com_create_db | 0 |
com_drop_db | 0 |
com_refresh | 0 |
com_shutdown | 0 |
com_statistics | 0 |
com_process_info | 0 |
com_connect | 0 |
com_process_kill | 0 |
com_debug | 0 |
com_ping | 0 |
com_time | 0 |
com_delayed_insert | 0 |
com_change_user | 0 |
com_binlog_dump | 0 |
com_table_dump | 0 |
com_connect_out | 0 |
com_register_slave | 0 |
com_stmt_prepare | 106 |
com_stmt_execute | 106 |
com_stmt_send_long_data | 0 |
com_stmt_close | 105 |
com_stmt_reset | 0 |
com_stmt_set_option | 0 |
com_stmt_fetch | 0 |
com_deamon | 0 |
bytes_received_real_data_normal | 0 |
bytes_received_real_data_ps | 597181 |