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.000204
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 36 | Using index condition |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 126
- 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.000056
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 89
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 101
- 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` = '72373')
LIMIT 1
Run Time: 0.000916
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 | 0 | Unique row not found |
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 89
- 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/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\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` = 72373) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 20)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Run Time: 0.001388
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 | kmfctfnshosting_thanhhoaonline.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_5 | eq_ref | PRIMARY | PRIMARY | 22 | kmfctfnshosting_thanhhoaonline.xf_user_User_1.user_id,func | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- 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/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\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: 72373
Run Time: 0.000083
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- 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/Andy/SimilarThreads/XF/Pub/Controller/Thread.php at line 16
- Andy\SimilarThreads\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_node`.*
FROM `xf_node`
WHERE (`xf_node`.`display_in_list` = 1)
ORDER BY `xf_node`.`lft` ASC
Run Time: 0.000128
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list | | | | 127 | Using where; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/Node.php at line 17
- XF\Repository\Node->getNodeList() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 170
- 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/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_category`.*, `xf_node_Node_1`.*
FROM `xf_category`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_category`.`node_id`)
WHERE (`xf_category`.`node_id` IN (143, 6, 1, 164))
Run Time: 0.000059
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_category | index | PRIMARY | PRIMARY | 4 | | 4 | Using where; Using index |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_category.node_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- 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 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 129
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 18
- XF\Repository\Node->getNodeList() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 170
- 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/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_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
WHERE (`xf_forum`.`node_id` IN (175, 11, 176, 177, 174, 23, 21, 178, 35, 179, 180, 181, 182, 187, 173, 183, 184, 185, 186, 36, 188, 155, 168, 28, 154, 170, 153, 156, 190, 193, 191, 192, 39, 141, 189, 12, 167, 30, 65, 127, 138, 113, 66, 122, 137, 117, 119, 121, 68, 132, 134, 136, 159, 67, 139, 140, 160, 166, 69, 120, 2, 9, 10, 40, 14, 33, 102, 25, 37, 16, 94, 58, 45, 46, 49, 52, 51, 50, 142, 59, 47, 165, 53, 4, 24, 74, 125, 64, 72, 106, 144, 118, 61, 158, 145, 146, 147, 157, 54, 95, 96, 97, 98, 99, 100, 48, 104, 44, 56, 93, 62, 81, 101, 60, 79, 114, 82, 135, 162, 5, 8, 151, 152))
Run Time: 0.000307
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | PRIMARY | | | | 123 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_forum.last_thread_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- 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 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 129
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Repository/Node.php at line 18
- XF\Repository\Node->getNodeList() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 170
- 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/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 content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
Params: 1, node
Run Time: 0.000104
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 125 | Using index condition |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 126
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/PermissionCache.php at line 102
- XF\PermissionCache->cacheAllContentPerms() in src/XF/Entity/User.php at line 947
- XF\Entity\User->cacheNodePermissions() in src/XF/Repository/Node.php at line 143
- XF\Repository\Node->filterViewable() in src/XF/Repository/Node.php at line 20
- XF\Repository\Node->getNodeList() in src/addons/Andy/SimilarThreads/Repository/SimilarThreads.php at line 170
- 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/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 '%Hướng%') AND (`xf_thread`.`title` LIKE '%Dẫn%') AND (`xf_thread`.`title` LIKE '%Kỹ%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_state` <> 'redirect') AND (`xf_thread`.`post_date` >= 1703935886) AND (`xf_thread`.`thread_id` <> 72373) AND ((`xf_thread`.`node_id` = 143) OR (`xf_thread`.`node_id` = 175) OR (`xf_thread`.`node_id` = 11) OR (`xf_thread`.`node_id` = 176) OR (`xf_thread`.`node_id` = 177) OR (`xf_thread`.`node_id` = 174) OR (`xf_thread`.`node_id` = 23) OR (`xf_thread`.`node_id` = 21) OR (`xf_thread`.`node_id` = 178) OR (`xf_thread`.`node_id` = 35) OR (`xf_thread`.`node_id` = 179) OR (`xf_thread`.`node_id` = 180) OR (`xf_thread`.`node_id` = 181) OR (`xf_thread`.`node_id` = 182) OR (`xf_thread`.`node_id` = 187) OR (`xf_thread`.`node_id` = 173) OR (`xf_thread`.`node_id` = 183) OR (`xf_thread`.`node_id` = 184) OR (`xf_thread`.`node_id` = 185) OR (`xf_thread`.`node_id` = 186) OR (`xf_thread`.`node_id` = 36) OR (`xf_thread`.`node_id` = 188) OR (`xf_thread`.`node_id` = 155) OR (`xf_thread`.`node_id` = 168) OR (`xf_thread`.`node_id` = 28) OR (`xf_thread`.`node_id` = 154) OR (`xf_thread`.`node_id` = 170) OR (`xf_thread`.`node_id` = 153) OR (`xf_thread`.`node_id` = 156) OR (`xf_thread`.`node_id` = 190) OR (`xf_thread`.`node_id` = 193) OR (`xf_thread`.`node_id` = 191) OR (`xf_thread`.`node_id` = 192) OR (`xf_thread`.`node_id` = 39) OR (`xf_thread`.`node_id` = 141) OR (`xf_thread`.`node_id` = 189) OR (`xf_thread`.`node_id` = 12) OR (`xf_thread`.`node_id` = 167) OR (`xf_thread`.`node_id` = 30) OR (`xf_thread`.`node_id` = 6) OR (`xf_thread`.`node_id` = 65) OR (`xf_thread`.`node_id` = 127) OR (`xf_thread`.`node_id` = 138) OR (`xf_thread`.`node_id` = 113) OR (`xf_thread`.`node_id` = 66) OR (`xf_thread`.`node_id` = 122) OR (`xf_thread`.`node_id` = 137) OR (`xf_thread`.`node_id` = 117) OR (`xf_thread`.`node_id` = 119) OR (`xf_thread`.`node_id` = 121) OR (`xf_thread`.`node_id` = 68) OR (`xf_thread`.`node_id` = 132) OR (`xf_thread`.`node_id` = 134) OR (`xf_thread`.`node_id` = 136) OR (`xf_thread`.`node_id` = 159) OR (`xf_thread`.`node_id` = 67) OR (`xf_thread`.`node_id` = 139) OR (`xf_thread`.`node_id` = 69) OR (`xf_thread`.`node_id` = 1) OR (`xf_thread`.`node_id` = 2) OR (`xf_thread`.`node_id` = 9) OR (`xf_thread`.`node_id` = 10) OR (`xf_thread`.`node_id` = 40) OR (`xf_thread`.`node_id` = 14) OR (`xf_thread`.`node_id` = 33) OR (`xf_thread`.`node_id` = 102) OR (`xf_thread`.`node_id` = 25) OR (`xf_thread`.`node_id` = 37) OR (`xf_thread`.`node_id` = 16) OR (`xf_thread`.`node_id` = 94) OR (`xf_thread`.`node_id` = 58) OR (`xf_thread`.`node_id` = 45) OR (`xf_thread`.`node_id` = 46) OR (`xf_thread`.`node_id` = 49) OR (`xf_thread`.`node_id` = 52) OR (`xf_thread`.`node_id` = 51) OR (`xf_thread`.`node_id` = 50) OR (`xf_thread`.`node_id` = 142) OR (`xf_thread`.`node_id` = 59) OR (`xf_thread`.`node_id` = 47) OR (`xf_thread`.`node_id` = 165) OR (`xf_thread`.`node_id` = 53) OR (`xf_thread`.`node_id` = 4) OR (`xf_thread`.`node_id` = 24) OR (`xf_thread`.`node_id` = 74) OR (`xf_thread`.`node_id` = 125) OR (`xf_thread`.`node_id` = 64) OR (`xf_thread`.`node_id` = 72) OR (`xf_thread`.`node_id` = 106) OR (`xf_thread`.`node_id` = 144) OR (`xf_thread`.`node_id` = 118) OR (`xf_thread`.`node_id` = 61) OR (`xf_thread`.`node_id` = 158) OR (`xf_thread`.`node_id` = 145) OR (`xf_thread`.`node_id` = 146) OR (`xf_thread`.`node_id` = 147) OR (`xf_thread`.`node_id` = 157) OR (`xf_thread`.`node_id` = 54) OR (`xf_thread`.`node_id` = 95) OR (`xf_thread`.`node_id` = 96) OR (`xf_thread`.`node_id` = 97) OR (`xf_thread`.`node_id` = 98) OR (`xf_thread`.`node_id` = 99) OR (`xf_thread`.`node_id` = 100) OR (`xf_thread`.`node_id` = 48) OR (`xf_thread`.`node_id` = 104) OR (`xf_thread`.`node_id` = 44) OR (`xf_thread`.`node_id` = 56) OR (`xf_thread`.`node_id` = 93) OR (`xf_thread`.`node_id` = 62) OR (`xf_thread`.`node_id` = 81) OR (`xf_thread`.`node_id` = 101) OR (`xf_thread`.`node_id` = 60) OR (`xf_thread`.`node_id` = 79) OR (`xf_thread`.`node_id` = 114) OR (`xf_thread`.`node_id` = 82) OR (`xf_thread`.`node_id` = 135) OR (`xf_thread`.`node_id` = 162) OR (`xf_thread`.`node_id` = 5) OR (`xf_thread`.`node_id` = 164) OR (`xf_thread`.`node_id` = 151) OR (`xf_thread`.`node_id` = 152))
LIMIT 5
Run Time: 0.006209
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 | | 1241 | Using index condition; Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- 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 209
- 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/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 '%Hướng%') AND (`xf_thread`.`title` LIKE '%Dẫn%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_state` <> 'redirect') AND (`xf_thread`.`post_date` >= 1703935886) AND (`xf_thread`.`thread_id` <> 72373) AND (`xf_thread`.`thread_id` <> 99574) AND ((`xf_thread`.`node_id` = 143) OR (`xf_thread`.`node_id` = 175) OR (`xf_thread`.`node_id` = 11) OR (`xf_thread`.`node_id` = 176) OR (`xf_thread`.`node_id` = 177) OR (`xf_thread`.`node_id` = 174) OR (`xf_thread`.`node_id` = 23) OR (`xf_thread`.`node_id` = 21) OR (`xf_thread`.`node_id` = 178) OR (`xf_thread`.`node_id` = 35) OR (`xf_thread`.`node_id` = 179) OR (`xf_thread`.`node_id` = 180) OR (`xf_thread`.`node_id` = 181) OR (`xf_thread`.`node_id` = 182) OR (`xf_thread`.`node_id` = 187) OR (`xf_thread`.`node_id` = 173) OR (`xf_thread`.`node_id` = 183) OR (`xf_thread`.`node_id` = 184) OR (`xf_thread`.`node_id` = 185) OR (`xf_thread`.`node_id` = 186) OR (`xf_thread`.`node_id` = 36) OR (`xf_thread`.`node_id` = 188) OR (`xf_thread`.`node_id` = 155) OR (`xf_thread`.`node_id` = 168) OR (`xf_thread`.`node_id` = 28) OR (`xf_thread`.`node_id` = 154) OR (`xf_thread`.`node_id` = 170) OR (`xf_thread`.`node_id` = 153) OR (`xf_thread`.`node_id` = 156) OR (`xf_thread`.`node_id` = 190) OR (`xf_thread`.`node_id` = 193) OR (`xf_thread`.`node_id` = 191) OR (`xf_thread`.`node_id` = 192) OR (`xf_thread`.`node_id` = 39) OR (`xf_thread`.`node_id` = 141) OR (`xf_thread`.`node_id` = 189) OR (`xf_thread`.`node_id` = 12) OR (`xf_thread`.`node_id` = 167) OR (`xf_thread`.`node_id` = 30) OR (`xf_thread`.`node_id` = 6) OR (`xf_thread`.`node_id` = 65) OR (`xf_thread`.`node_id` = 127) OR (`xf_thread`.`node_id` = 138) OR (`xf_thread`.`node_id` = 113) OR (`xf_thread`.`node_id` = 66) OR (`xf_thread`.`node_id` = 122) OR (`xf_thread`.`node_id` = 137) OR (`xf_thread`.`node_id` = 117) OR (`xf_thread`.`node_id` = 119) OR (`xf_thread`.`node_id` = 121) OR (`xf_thread`.`node_id` = 68) OR (`xf_thread`.`node_id` = 132) OR (`xf_thread`.`node_id` = 134) OR (`xf_thread`.`node_id` = 136) OR (`xf_thread`.`node_id` = 159) OR (`xf_thread`.`node_id` = 67) OR (`xf_thread`.`node_id` = 139) OR (`xf_thread`.`node_id` = 69) OR (`xf_thread`.`node_id` = 1) OR (`xf_thread`.`node_id` = 2) OR (`xf_thread`.`node_id` = 9) OR (`xf_thread`.`node_id` = 10) OR (`xf_thread`.`node_id` = 40) OR (`xf_thread`.`node_id` = 14) OR (`xf_thread`.`node_id` = 33) OR (`xf_thread`.`node_id` = 102) OR (`xf_thread`.`node_id` = 25) OR (`xf_thread`.`node_id` = 37) OR (`xf_thread`.`node_id` = 16) OR (`xf_thread`.`node_id` = 94) OR (`xf_thread`.`node_id` = 58) OR (`xf_thread`.`node_id` = 45) OR (`xf_thread`.`node_id` = 46) OR (`xf_thread`.`node_id` = 49) OR (`xf_thread`.`node_id` = 52) OR (`xf_thread`.`node_id` = 51) OR (`xf_thread`.`node_id` = 50) OR (`xf_thread`.`node_id` = 142) OR (`xf_thread`.`node_id` = 59) OR (`xf_thread`.`node_id` = 47) OR (`xf_thread`.`node_id` = 165) OR (`xf_thread`.`node_id` = 53) OR (`xf_thread`.`node_id` = 4) OR (`xf_thread`.`node_id` = 24) OR (`xf_thread`.`node_id` = 74) OR (`xf_thread`.`node_id` = 125) OR (`xf_thread`.`node_id` = 64) OR (`xf_thread`.`node_id` = 72) OR (`xf_thread`.`node_id` = 106) OR (`xf_thread`.`node_id` = 144) OR (`xf_thread`.`node_id` = 118) OR (`xf_thread`.`node_id` = 61) OR (`xf_thread`.`node_id` = 158) OR (`xf_thread`.`node_id` = 145) OR (`xf_thread`.`node_id` = 146) OR (`xf_thread`.`node_id` = 147) OR (`xf_thread`.`node_id` = 157) OR (`xf_thread`.`node_id` = 54) OR (`xf_thread`.`node_id` = 95) OR (`xf_thread`.`node_id` = 96) OR (`xf_thread`.`node_id` = 97) OR (`xf_thread`.`node_id` = 98) OR (`xf_thread`.`node_id` = 99) OR (`xf_thread`.`node_id` = 100) OR (`xf_thread`.`node_id` = 48) OR (`xf_thread`.`node_id` = 104) OR (`xf_thread`.`node_id` = 44) OR (`xf_thread`.`node_id` = 56) OR (`xf_thread`.`node_id` = 93) OR (`xf_thread`.`node_id` = 62) OR (`xf_thread`.`node_id` = 81) OR (`xf_thread`.`node_id` = 101) OR (`xf_thread`.`node_id` = 60) OR (`xf_thread`.`node_id` = 79) OR (`xf_thread`.`node_id` = 114) OR (`xf_thread`.`node_id` = 82) OR (`xf_thread`.`node_id` = 135) OR (`xf_thread`.`node_id` = 162) OR (`xf_thread`.`node_id` = 5) OR (`xf_thread`.`node_id` = 164) OR (`xf_thread`.`node_id` = 151) OR (`xf_thread`.`node_id` = 152))
ORDER BY `xf_thread`.`post_date` DESC
LIMIT 4
Run Time: 0.005993
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 | | 1241 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- 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 258
- 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/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 '%Hướng%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_state` <> 'redirect') AND (`xf_thread`.`post_date` >= 1703935886) AND (`xf_thread`.`thread_id` <> 72373) AND (`xf_thread`.`thread_id` <> 99574) AND ((`xf_thread`.`node_id` = 143) OR (`xf_thread`.`node_id` = 175) OR (`xf_thread`.`node_id` = 11) OR (`xf_thread`.`node_id` = 176) OR (`xf_thread`.`node_id` = 177) OR (`xf_thread`.`node_id` = 174) OR (`xf_thread`.`node_id` = 23) OR (`xf_thread`.`node_id` = 21) OR (`xf_thread`.`node_id` = 178) OR (`xf_thread`.`node_id` = 35) OR (`xf_thread`.`node_id` = 179) OR (`xf_thread`.`node_id` = 180) OR (`xf_thread`.`node_id` = 181) OR (`xf_thread`.`node_id` = 182) OR (`xf_thread`.`node_id` = 187) OR (`xf_thread`.`node_id` = 173) OR (`xf_thread`.`node_id` = 183) OR (`xf_thread`.`node_id` = 184) OR (`xf_thread`.`node_id` = 185) OR (`xf_thread`.`node_id` = 186) OR (`xf_thread`.`node_id` = 36) OR (`xf_thread`.`node_id` = 188) OR (`xf_thread`.`node_id` = 155) OR (`xf_thread`.`node_id` = 168) OR (`xf_thread`.`node_id` = 28) OR (`xf_thread`.`node_id` = 154) OR (`xf_thread`.`node_id` = 170) OR (`xf_thread`.`node_id` = 153) OR (`xf_thread`.`node_id` = 156) OR (`xf_thread`.`node_id` = 190) OR (`xf_thread`.`node_id` = 193) OR (`xf_thread`.`node_id` = 191) OR (`xf_thread`.`node_id` = 192) OR (`xf_thread`.`node_id` = 39) OR (`xf_thread`.`node_id` = 141) OR (`xf_thread`.`node_id` = 189) OR (`xf_thread`.`node_id` = 12) OR (`xf_thread`.`node_id` = 167) OR (`xf_thread`.`node_id` = 30) OR (`xf_thread`.`node_id` = 6) OR (`xf_thread`.`node_id` = 65) OR (`xf_thread`.`node_id` = 127) OR (`xf_thread`.`node_id` = 138) OR (`xf_thread`.`node_id` = 113) OR (`xf_thread`.`node_id` = 66) OR (`xf_thread`.`node_id` = 122) OR (`xf_thread`.`node_id` = 137) OR (`xf_thread`.`node_id` = 117) OR (`xf_thread`.`node_id` = 119) OR (`xf_thread`.`node_id` = 121) OR (`xf_thread`.`node_id` = 68) OR (`xf_thread`.`node_id` = 132) OR (`xf_thread`.`node_id` = 134) OR (`xf_thread`.`node_id` = 136) OR (`xf_thread`.`node_id` = 159) OR (`xf_thread`.`node_id` = 67) OR (`xf_thread`.`node_id` = 139) OR (`xf_thread`.`node_id` = 69) OR (`xf_thread`.`node_id` = 1) OR (`xf_thread`.`node_id` = 2) OR (`xf_thread`.`node_id` = 9) OR (`xf_thread`.`node_id` = 10) OR (`xf_thread`.`node_id` = 40) OR (`xf_thread`.`node_id` = 14) OR (`xf_thread`.`node_id` = 33) OR (`xf_thread`.`node_id` = 102) OR (`xf_thread`.`node_id` = 25) OR (`xf_thread`.`node_id` = 37) OR (`xf_thread`.`node_id` = 16) OR (`xf_thread`.`node_id` = 94) OR (`xf_thread`.`node_id` = 58) OR (`xf_thread`.`node_id` = 45) OR (`xf_thread`.`node_id` = 46) OR (`xf_thread`.`node_id` = 49) OR (`xf_thread`.`node_id` = 52) OR (`xf_thread`.`node_id` = 51) OR (`xf_thread`.`node_id` = 50) OR (`xf_thread`.`node_id` = 142) OR (`xf_thread`.`node_id` = 59) OR (`xf_thread`.`node_id` = 47) OR (`xf_thread`.`node_id` = 165) OR (`xf_thread`.`node_id` = 53) OR (`xf_thread`.`node_id` = 4) OR (`xf_thread`.`node_id` = 24) OR (`xf_thread`.`node_id` = 74) OR (`xf_thread`.`node_id` = 125) OR (`xf_thread`.`node_id` = 64) OR (`xf_thread`.`node_id` = 72) OR (`xf_thread`.`node_id` = 106) OR (`xf_thread`.`node_id` = 144) OR (`xf_thread`.`node_id` = 118) OR (`xf_thread`.`node_id` = 61) OR (`xf_thread`.`node_id` = 158) OR (`xf_thread`.`node_id` = 145) OR (`xf_thread`.`node_id` = 146) OR (`xf_thread`.`node_id` = 147) OR (`xf_thread`.`node_id` = 157) OR (`xf_thread`.`node_id` = 54) OR (`xf_thread`.`node_id` = 95) OR (`xf_thread`.`node_id` = 96) OR (`xf_thread`.`node_id` = 97) OR (`xf_thread`.`node_id` = 98) OR (`xf_thread`.`node_id` = 99) OR (`xf_thread`.`node_id` = 100) OR (`xf_thread`.`node_id` = 48) OR (`xf_thread`.`node_id` = 104) OR (`xf_thread`.`node_id` = 44) OR (`xf_thread`.`node_id` = 56) OR (`xf_thread`.`node_id` = 93) OR (`xf_thread`.`node_id` = 62) OR (`xf_thread`.`node_id` = 81) OR (`xf_thread`.`node_id` = 101) OR (`xf_thread`.`node_id` = 60) OR (`xf_thread`.`node_id` = 79) OR (`xf_thread`.`node_id` = 114) OR (`xf_thread`.`node_id` = 82) OR (`xf_thread`.`node_id` = 135) OR (`xf_thread`.`node_id` = 162) OR (`xf_thread`.`node_id` = 5) OR (`xf_thread`.`node_id` = 164) OR (`xf_thread`.`node_id` = 151) OR (`xf_thread`.`node_id` = 152))
LIMIT 4
Run Time: 0.005810
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 | | 1241 | Using index condition; Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- 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 306
- 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/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 '%Dẫn%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_state` <> 'redirect') AND (`xf_thread`.`post_date` >= 1703935886) AND (`xf_thread`.`thread_id` <> 72373) AND (`xf_thread`.`thread_id` <> 99574) AND ((`xf_thread`.`node_id` = 143) OR (`xf_thread`.`node_id` = 175) OR (`xf_thread`.`node_id` = 11) OR (`xf_thread`.`node_id` = 176) OR (`xf_thread`.`node_id` = 177) OR (`xf_thread`.`node_id` = 174) OR (`xf_thread`.`node_id` = 23) OR (`xf_thread`.`node_id` = 21) OR (`xf_thread`.`node_id` = 178) OR (`xf_thread`.`node_id` = 35) OR (`xf_thread`.`node_id` = 179) OR (`xf_thread`.`node_id` = 180) OR (`xf_thread`.`node_id` = 181) OR (`xf_thread`.`node_id` = 182) OR (`xf_thread`.`node_id` = 187) OR (`xf_thread`.`node_id` = 173) OR (`xf_thread`.`node_id` = 183) OR (`xf_thread`.`node_id` = 184) OR (`xf_thread`.`node_id` = 185) OR (`xf_thread`.`node_id` = 186) OR (`xf_thread`.`node_id` = 36) OR (`xf_thread`.`node_id` = 188) OR (`xf_thread`.`node_id` = 155) OR (`xf_thread`.`node_id` = 168) OR (`xf_thread`.`node_id` = 28) OR (`xf_thread`.`node_id` = 154) OR (`xf_thread`.`node_id` = 170) OR (`xf_thread`.`node_id` = 153) OR (`xf_thread`.`node_id` = 156) OR (`xf_thread`.`node_id` = 190) OR (`xf_thread`.`node_id` = 193) OR (`xf_thread`.`node_id` = 191) OR (`xf_thread`.`node_id` = 192) OR (`xf_thread`.`node_id` = 39) OR (`xf_thread`.`node_id` = 141) OR (`xf_thread`.`node_id` = 189) OR (`xf_thread`.`node_id` = 12) OR (`xf_thread`.`node_id` = 167) OR (`xf_thread`.`node_id` = 30) OR (`xf_thread`.`node_id` = 6) OR (`xf_thread`.`node_id` = 65) OR (`xf_thread`.`node_id` = 127) OR (`xf_thread`.`node_id` = 138) OR (`xf_thread`.`node_id` = 113) OR (`xf_thread`.`node_id` = 66) OR (`xf_thread`.`node_id` = 122) OR (`xf_thread`.`node_id` = 137) OR (`xf_thread`.`node_id` = 117) OR (`xf_thread`.`node_id` = 119) OR (`xf_thread`.`node_id` = 121) OR (`xf_thread`.`node_id` = 68) OR (`xf_thread`.`node_id` = 132) OR (`xf_thread`.`node_id` = 134) OR (`xf_thread`.`node_id` = 136) OR (`xf_thread`.`node_id` = 159) OR (`xf_thread`.`node_id` = 67) OR (`xf_thread`.`node_id` = 139) OR (`xf_thread`.`node_id` = 69) OR (`xf_thread`.`node_id` = 1) OR (`xf_thread`.`node_id` = 2) OR (`xf_thread`.`node_id` = 9) OR (`xf_thread`.`node_id` = 10) OR (`xf_thread`.`node_id` = 40) OR (`xf_thread`.`node_id` = 14) OR (`xf_thread`.`node_id` = 33) OR (`xf_thread`.`node_id` = 102) OR (`xf_thread`.`node_id` = 25) OR (`xf_thread`.`node_id` = 37) OR (`xf_thread`.`node_id` = 16) OR (`xf_thread`.`node_id` = 94) OR (`xf_thread`.`node_id` = 58) OR (`xf_thread`.`node_id` = 45) OR (`xf_thread`.`node_id` = 46) OR (`xf_thread`.`node_id` = 49) OR (`xf_thread`.`node_id` = 52) OR (`xf_thread`.`node_id` = 51) OR (`xf_thread`.`node_id` = 50) OR (`xf_thread`.`node_id` = 142) OR (`xf_thread`.`node_id` = 59) OR (`xf_thread`.`node_id` = 47) OR (`xf_thread`.`node_id` = 165) OR (`xf_thread`.`node_id` = 53) OR (`xf_thread`.`node_id` = 4) OR (`xf_thread`.`node_id` = 24) OR (`xf_thread`.`node_id` = 74) OR (`xf_thread`.`node_id` = 125) OR (`xf_thread`.`node_id` = 64) OR (`xf_thread`.`node_id` = 72) OR (`xf_thread`.`node_id` = 106) OR (`xf_thread`.`node_id` = 144) OR (`xf_thread`.`node_id` = 118) OR (`xf_thread`.`node_id` = 61) OR (`xf_thread`.`node_id` = 158) OR (`xf_thread`.`node_id` = 145) OR (`xf_thread`.`node_id` = 146) OR (`xf_thread`.`node_id` = 147) OR (`xf_thread`.`node_id` = 157) OR (`xf_thread`.`node_id` = 54) OR (`xf_thread`.`node_id` = 95) OR (`xf_thread`.`node_id` = 96) OR (`xf_thread`.`node_id` = 97) OR (`xf_thread`.`node_id` = 98) OR (`xf_thread`.`node_id` = 99) OR (`xf_thread`.`node_id` = 100) OR (`xf_thread`.`node_id` = 48) OR (`xf_thread`.`node_id` = 104) OR (`xf_thread`.`node_id` = 44) OR (`xf_thread`.`node_id` = 56) OR (`xf_thread`.`node_id` = 93) OR (`xf_thread`.`node_id` = 62) OR (`xf_thread`.`node_id` = 81) OR (`xf_thread`.`node_id` = 101) OR (`xf_thread`.`node_id` = 60) OR (`xf_thread`.`node_id` = 79) OR (`xf_thread`.`node_id` = 114) OR (`xf_thread`.`node_id` = 82) OR (`xf_thread`.`node_id` = 135) OR (`xf_thread`.`node_id` = 162) OR (`xf_thread`.`node_id` = 5) OR (`xf_thread`.`node_id` = 164) OR (`xf_thread`.`node_id` = 151) OR (`xf_thread`.`node_id` = 152))
LIMIT 4
Run Time: 0.005849
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 | | 1241 | Using index condition; Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- 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 354
- 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/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 '%Dẫn%') AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_state` <> 'redirect') AND (`xf_thread`.`post_date` >= 1703935886) AND (`xf_thread`.`thread_id` <> 72373) AND (`xf_thread`.`thread_id` <> 99574 AND `xf_thread`.`thread_id` <> 99188) AND ((`xf_thread`.`node_id` = 143) OR (`xf_thread`.`node_id` = 175) OR (`xf_thread`.`node_id` = 11) OR (`xf_thread`.`node_id` = 176) OR (`xf_thread`.`node_id` = 177) OR (`xf_thread`.`node_id` = 174) OR (`xf_thread`.`node_id` = 23) OR (`xf_thread`.`node_id` = 21) OR (`xf_thread`.`node_id` = 178) OR (`xf_thread`.`node_id` = 35) OR (`xf_thread`.`node_id` = 179) OR (`xf_thread`.`node_id` = 180) OR (`xf_thread`.`node_id` = 181) OR (`xf_thread`.`node_id` = 182) OR (`xf_thread`.`node_id` = 187) OR (`xf_thread`.`node_id` = 173) OR (`xf_thread`.`node_id` = 183) OR (`xf_thread`.`node_id` = 184) OR (`xf_thread`.`node_id` = 185) OR (`xf_thread`.`node_id` = 186) OR (`xf_thread`.`node_id` = 36) OR (`xf_thread`.`node_id` = 188) OR (`xf_thread`.`node_id` = 155) OR (`xf_thread`.`node_id` = 168) OR (`xf_thread`.`node_id` = 28) OR (`xf_thread`.`node_id` = 154) OR (`xf_thread`.`node_id` = 170) OR (`xf_thread`.`node_id` = 153) OR (`xf_thread`.`node_id` = 156) OR (`xf_thread`.`node_id` = 190) OR (`xf_thread`.`node_id` = 193) OR (`xf_thread`.`node_id` = 191) OR (`xf_thread`.`node_id` = 192) OR (`xf_thread`.`node_id` = 39) OR (`xf_thread`.`node_id` = 141) OR (`xf_thread`.`node_id` = 189) OR (`xf_thread`.`node_id` = 12) OR (`xf_thread`.`node_id` = 167) OR (`xf_thread`.`node_id` = 30) OR (`xf_thread`.`node_id` = 6) OR (`xf_thread`.`node_id` = 65) OR (`xf_thread`.`node_id` = 127) OR (`xf_thread`.`node_id` = 138) OR (`xf_thread`.`node_id` = 113) OR (`xf_thread`.`node_id` = 66) OR (`xf_thread`.`node_id` = 122) OR (`xf_thread`.`node_id` = 137) OR (`xf_thread`.`node_id` = 117) OR (`xf_thread`.`node_id` = 119) OR (`xf_thread`.`node_id` = 121) OR (`xf_thread`.`node_id` = 68) OR (`xf_thread`.`node_id` = 132) OR (`xf_thread`.`node_id` = 134) OR (`xf_thread`.`node_id` = 136) OR (`xf_thread`.`node_id` = 159) OR (`xf_thread`.`node_id` = 67) OR (`xf_thread`.`node_id` = 139) OR (`xf_thread`.`node_id` = 69) OR (`xf_thread`.`node_id` = 1) OR (`xf_thread`.`node_id` = 2) OR (`xf_thread`.`node_id` = 9) OR (`xf_thread`.`node_id` = 10) OR (`xf_thread`.`node_id` = 40) OR (`xf_thread`.`node_id` = 14) OR (`xf_thread`.`node_id` = 33) OR (`xf_thread`.`node_id` = 102) OR (`xf_thread`.`node_id` = 25) OR (`xf_thread`.`node_id` = 37) OR (`xf_thread`.`node_id` = 16) OR (`xf_thread`.`node_id` = 94) OR (`xf_thread`.`node_id` = 58) OR (`xf_thread`.`node_id` = 45) OR (`xf_thread`.`node_id` = 46) OR (`xf_thread`.`node_id` = 49) OR (`xf_thread`.`node_id` = 52) OR (`xf_thread`.`node_id` = 51) OR (`xf_thread`.`node_id` = 50) OR (`xf_thread`.`node_id` = 142) OR (`xf_thread`.`node_id` = 59) OR (`xf_thread`.`node_id` = 47) OR (`xf_thread`.`node_id` = 165) OR (`xf_thread`.`node_id` = 53) OR (`xf_thread`.`node_id` = 4) OR (`xf_thread`.`node_id` = 24) OR (`xf_thread`.`node_id` = 74) OR (`xf_thread`.`node_id` = 125) OR (`xf_thread`.`node_id` = 64) OR (`xf_thread`.`node_id` = 72) OR (`xf_thread`.`node_id` = 106) OR (`xf_thread`.`node_id` = 144) OR (`xf_thread`.`node_id` = 118) OR (`xf_thread`.`node_id` = 61) OR (`xf_thread`.`node_id` = 158) OR (`xf_thread`.`node_id` = 145) OR (`xf_thread`.`node_id` = 146) OR (`xf_thread`.`node_id` = 147) OR (`xf_thread`.`node_id` = 157) OR (`xf_thread`.`node_id` = 54) OR (`xf_thread`.`node_id` = 95) OR (`xf_thread`.`node_id` = 96) OR (`xf_thread`.`node_id` = 97) OR (`xf_thread`.`node_id` = 98) OR (`xf_thread`.`node_id` = 99) OR (`xf_thread`.`node_id` = 100) OR (`xf_thread`.`node_id` = 48) OR (`xf_thread`.`node_id` = 104) OR (`xf_thread`.`node_id` = 44) OR (`xf_thread`.`node_id` = 56) OR (`xf_thread`.`node_id` = 93) OR (`xf_thread`.`node_id` = 62) OR (`xf_thread`.`node_id` = 81) OR (`xf_thread`.`node_id` = 101) OR (`xf_thread`.`node_id` = 60) OR (`xf_thread`.`node_id` = 79) OR (`xf_thread`.`node_id` = 114) OR (`xf_thread`.`node_id` = 82) OR (`xf_thread`.`node_id` = 135) OR (`xf_thread`.`node_id` = 162) OR (`xf_thread`.`node_id` = 5) OR (`xf_thread`.`node_id` = 164) OR (`xf_thread`.`node_id` = 151) OR (`xf_thread`.`node_id` = 152))
LIMIT 3
Run Time: 0.005781
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 | | 1241 | Using index condition; Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- 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 402
- 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/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` = 99574) OR (`xf_thread`.`thread_id` = 99188))
ORDER BY `xf_thread`.`post_date` DESC
Run Time: 0.000183
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 2 | Using index condition; Using filesort |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- 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 445
- 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/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=72373, 1711711886,
Run Time: 0.000176
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- 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 `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*, `xf_template_MasterTemplate_2`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
LEFT JOIN `xf_template` AS `xf_template_MasterTemplate_2` ON (`xf_template_MasterTemplate_2`.`style_id` = 0 AND `xf_template_MasterTemplate_2`.`type` = 'public' AND `xf_template_MasterTemplate_2`.`title` = CONCAT('_siropu_ads_manager_ad_code.', `xf_siropu_ads_manager_ad`.`ad_id`))
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('code', 'banner', 'text', 'link', 'popup', 'background')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY `xf_siropu_ads_manager_ad`.`display_order` ASC
Run Time: 0.000210
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ad | ALL | type,status,status_display_order | | | | 6 | Using where; Using filesort |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_siropu_ads_manager_ad.package_id | 1 | |
SIMPLE | xf_template_MasterTemplate_2 | eq_ref | type_title_style_id | type_title_style_id | 128 | const,func,const | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 395
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 254
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 27
- Siropu\AdsManager\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2647
- XF\App->fire() in src/XF/App.php at line 1915
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1793
- XF\App->preRender() in src/XF/Pub/App.php at line 435
- 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 `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('keyword', 'affiliate')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY RAND() ASC
Run Time: 0.000597
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ad | range|filter | type,status,status_display_order | type|status | 77|77 | | 2 (83%) | Using index condition; Using where; Using temporary; Using filesort; Using rowid filter |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_siropu_ads_manager_ad.package_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 505
- Siropu\AdsManager\Template\Ad->loadFilterAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 258
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 27
- Siropu\AdsManager\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2647
- XF\App->fire() in src/XF/App.php at line 1915
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1793
- XF\App->preRender() in src/XF/Pub/App.php at line 435
- 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 data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brmsModernStatistics')
Run Time: 0.000041
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 89
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 126
- 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 3027
- XF\App->container() in src/addons/BR/ModernStatistic/Service/ModernStatistic/Render.php at line 29
- BR\ModernStatistic\Service\ModernStatistic\Render->__construct() in src/XF/Container.php at line 274
- XF\Container->createObject() in src/XF/App.php at line 1563
- XF\App->XF\{closure}() in src/XF/Container.php at line 228
- XF\Container->create() in src/XF/App.php at line 2769
- XF\App->service() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 10
- BR\ModernStatistic\XF\Template\Templater->callAdsMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 220
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1294
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\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` = 41159)
LIMIT 1
Run Time: 0.000203
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 89
- 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/l2/s1/public/andy_similarthreads.php at line 27
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1294
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1367
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 812
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1294
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\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` > 1709119886) AND (`xf_thread`.`node_id` IN (11, 23, 35, 21, 154, 153, 155, 156, 168, 39, 141, 36, 28, 12, 30, 167, 65, 127, 138, 113, 66, 122, 137, 117, 119, 121, 68, 132, 134, 136, 159, 67, 139, 69, 120, 2, 9, 10, 40, 14, 33, 102, 25, 37, 16, 94, 58, 45, 46, 49, 52, 51, 50, 142, 59, 47, 165, 53, 4, 24, 74, 125, 64, 72, 106, 144, 118, 61, 158, 145, 146, 147, 157, 54, 95, 96, 97, 98, 99, 100, 48, 104, 44, 56, 93, 62, 81, 101, 60, 79, 114, 82, 135, 162, 5, 151, 152))
ORDER BY `xf_thread`.`last_post_date` DESC
LIMIT 20
Run Time: 0.001206
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | last_post_date | last_post_date | 4 | | 948 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_thread.node_id | 1 | Using where |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_thread.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kmfctfnshosting_thanhhoaonline.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_thread.last_post_user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- 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/_16_newposts.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6569
- 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 1613
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 820
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1294
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\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`
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`.`reply_count` > 0)
ORDER BY `xf_thread`.`reply_count` DESC
LIMIT 20
Run Time: 0.000241
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ALL | | | | | 26971 | Using where; Using filesort |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kmfctfnshosting_thanhhoaonline.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/DL6/MLTP/XF/Widget/MostRepliedThreads.php at line 157
- DL6\MLTP\XF\Widget\MostRepliedThreads->render() in internal_data/code_cache/widgets/_18_threads_with_more_replies.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6569
- 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 1613
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 820
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1294
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\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_profile_post`.*, `xf_user_ProfileUser_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_User_3`.*
FROM `xf_profile_post`
LEFT JOIN `xf_user` AS `xf_user_ProfileUser_1` ON (`xf_user_ProfileUser_1`.`user_id` = `xf_profile_post`.`profile_user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user_ProfileUser_1`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_profile_post`.`user_id`)
WHERE (`xf_profile_post`.`message_state` = 'visible')
ORDER BY `xf_profile_post`.`post_date` DESC
LIMIT 10
Run Time: 0.000209
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_profile_post | index | | post_date | 4 | | 10 | Using where |
SIMPLE | xf_user_ProfileUser_1 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_profile_post.profile_user_id | 1 | |
SIMPLE | xf_user_privacy_Privacy_2 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_user_ProfileUser_1.user_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_profile_post.user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewProfilePosts.php at line 66
- XF\Widget\NewProfilePosts->render() in internal_data/code_cache/widgets/_47_profile_post.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6569
- 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 1613
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 820
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1294
- XF\Template\Templater->renderTemplate() in src/addons/BR/ModernStatistic/XF/Template/Templater.php at line 27
- BR\ModernStatistic\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_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (143, 6, 1, 164))
Run Time: 0.000060
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | range | PRIMARY | PRIMARY | 4 | | 4 | Using index condition |
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kmfctfnshosting_thanhhoaonline.xf_node.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- 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 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 193
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 115
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 127
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 6545
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 560
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 513
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1988
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- 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_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE ((`xf_node`.`lft` > 125 AND `xf_node`.`rgt` < 248) OR (`xf_node`.`lft` > 79 AND `xf_node`.`rgt` < 124) OR (`xf_node`.`lft` > 1 AND `xf_node`.`rgt` < 78) OR (`xf_node`.`lft` > 249 AND `xf_node`.`rgt` < 254)) AND (`xf_node`.`display_in_list` = 1)
ORDER BY `xf_node`.`lft` ASC
Run Time: 0.000203
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list,lft | | | | 127 | Using where; Using filesort |
SIMPLE | xf_permission_cache_content_Permissions_1 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kmfctfnshosting_thanhhoaonline.xf_node.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Navigation/NodeType.php at line 223
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 115
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 127
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 6545
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 560
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 513
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1988
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- 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_category`.*, `xf_node_Node_1`.*
FROM `xf_category`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_category`.`node_id`)
WHERE (`xf_category`.`node_id` IN (1, 6, 143, 164))
Run Time: 0.000057
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_category | index | PRIMARY | PRIMARY | 4 | | 4 | Using where; Using index |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_category.node_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- 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 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 129
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 227
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 115
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 127
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 6545
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 560
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 513
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1988
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- 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_forum`.*, `xf_node_Node_1`.*, `xf_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
WHERE (`xf_forum`.`node_id` IN (175, 11, 176, 177, 174, 23, 21, 178, 35, 179, 180, 181, 182, 187, 173, 183, 184, 185, 186, 36, 188, 155, 168, 28, 154, 170, 153, 156, 190, 193, 191, 192, 39, 141, 189, 12, 167, 30, 65, 127, 138, 113, 66, 122, 137, 117, 119, 121, 68, 132, 134, 136, 159, 67, 139, 140, 160, 166, 69, 120, 2, 9, 10, 40, 14, 33, 102, 25, 37, 16, 94, 58, 45, 46, 49, 52, 51, 50, 142, 59, 47, 165, 53, 4, 24, 74, 125, 64, 72, 106, 144, 118, 61, 158, 145, 146, 147, 157, 54, 95, 96, 97, 98, 99, 100, 48, 104, 44, 56, 93, 62, 81, 101, 60, 79, 114, 82, 135, 162, 5, 8, 151, 152))
Run Time: 0.000416
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | PRIMARY | | | | 123 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | kmfctfnshosting_thanhhoaonline.xf_forum.last_thread_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 89
- 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 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/Node.php at line 129
- XF\Repository\Node->loadNodeTypeDataForNodes() in src/XF/Navigation/NodeType.php at line 227
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 115
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 127
- XF\Pub\App->{closure}() in src/XF/Template/Templater.php at line 6545
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 560
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 513
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1988
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 362
- 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 | 70920 |
bytes_received | 1414530 |
packets_sent | 316 |
packets_received | 4068 |
protocol_overhead_in | 16272 |
protocol_overhead_out | 1264 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 954 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 294 |
bytes_received_prepare_response_packet | 286820 |
bytes_received_change_user_packet | 1125264 |
packets_sent_command | 157 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 106 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 54 |
packets_received_prepare_response | 3010 |
packets_received_change_user | 844 |
result_set_queries | 50 |
non_result_set_queries | 4 |
no_index_used | 9 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 50 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 51 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 794 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 794 |
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 | 794 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 10 |
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 | 3364 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 5371 |
proto_binary_fetched_int24 | 1693 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 16711 |
proto_binary_fetched_decimal | 59 |
proto_binary_fetched_float | 5 |
proto_binary_fetched_double | 0 |
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 | 8395 |
proto_binary_fetched_blob | 4211 |
proto_binary_fetched_enum | 0 |
proto_binary_fetched_set | 0 |
proto_binary_fetched_geometry | 0 |
proto_binary_fetched_other | 0 |
init_command_executed_count | 0 |
init_command_failed_count | 0 |
com_quit | 0 |
com_init_db | 0 |
com_query | 2 |
com_field_list | 0 |
com_create_db | 0 |
com_drop_db | 0 |
com_refresh | 0 |
com_shutdown | 0 |
com_statistics | 0 |
com_process_info | 0 |
com_connect | 0 |
com_process_kill | 0 |
com_debug | 0 |
com_ping | 0 |
com_time | 0 |
com_delayed_insert | 0 |
com_change_user | 0 |
com_binlog_dump | 0 |
com_table_dump | 0 |
com_connect_out | 0 |
com_register_slave | 0 |
com_stmt_prepare | 52 |
com_stmt_execute | 52 |
com_stmt_send_long_data | 0 |
com_stmt_close | 51 |
com_stmt_reset | 0 |
com_stmt_set_option | 0 |
com_stmt_fetch | 0 |
com_deamon | 0 |
bytes_received_real_data_normal | 0 |
bytes_received_real_data_ps | 1101495 |