SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_post_FirstPost_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (179826, 179425, 179347, 179346, 179345, 178983, 178971, 178970, 178958, 178563, 178562, 177701, 177554, 177436, 176712, 175636, 175243, 174570, 173791, 172416, 171115, 170676, 169517, 169391, 167767, 167161, 165672, 164440, 163796, 162118, 147415, 127522, 87746, 87677, 87264, 87179, 86346, 85801, 85795, 85585, 85519, 85427, 85327, 85319, 85281, 85064, 84905, 84242, 84120, 84095, 83774, 83676, 83455, 83190, 83153, 82806, 81537, 80837, 80788, 80504, 80278, 80270, 80269, 80183, 80134, 80133, 80124, 80095))
Run Time: 0.031181
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 68 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1387
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2729
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 731
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 137
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 16522, 0, 1715522396, {"thread-179826":["thread",179826],"thread-179425":["thread",179425],"thread-179347":["thread",179347],"thread-179346":["thread",179346],"thread-179345":["thread",179345],"thread-178983":["thread",178983],"thread-178971":["thread",178971],"thread-178970":["thread",178970],"thread-178958":["thread",178958],"thread-178563":["thread",178563],"thread-178562":["thread",178562],"thread-177701":["thread",177701],"tl_group-328":["tl_group",328],"thread-177554":["thread",177554],"thread-177436":["thread",177436],"thread-176712":["thread",176712],"thread-175636":["thread",175636],"thread-175243":["thread",175243],"thread-174570":["thread",174570],"thread-173791":["thread",173791],"thread-172416":["thread",172416],"thread-171115":["thread",171115],"thread-170676":["thread",170676],"thread-169517":["thread",169517],"thread-169391":["thread",169391],"thread-167767":["thread",167767],"thread-167161":["thread",167161],"thread-165672":["thread",165672],"thread-164440":["thread",164440],"thread-163796":["thread",163796],"thread-162118":["thread",162118],"thread-147415":["thread",147415],"thread-127522":["thread",127522],"thread-87746":["thread",87746],"thread-87677":["thread",87677],"thread-87264":["thread",87264],"thread-87179":["thread",87179],"thread-86346":["thread",86346],"thread-85801":["thread",85801],"thread-85795":["thread",85795],"thread-85585":["thread",85585],"thread-85519":["thread",85519],"thread-85427":["thread",85427],"thread-85327":["thread",85327],"thread-85319":["thread",85319],"thread-85281":["thread",85281],"thread-85064":["thread",85064],"thread-84905":["thread",84905],"thread-84242":["thread",84242],"thread-84120":["thread",84120],"thread-84095":["thread",84095],"thread-83774":["thread",83774],"thread-83676":["thread",83676],"thread-83455":["thread",83455],"thread-83190":["thread",83190],"thread-83153":["thread",83153],"thread-82806":["thread",82806],"thread-81537":["thread",81537],"thread-80837":["thread",80837],"thread-80788":["thread",80788],"thread-80504":["thread",80504],"thread-80278":["thread",80278],"thread-80270":["thread",80270],"thread-80269":["thread",80269],"thread-80183":["thread",80183],"thread-80134":["thread",80134],"thread-80133":["thread",80133],"thread-80124":["thread",80124],"thread-80095":["thread",80095]}, , 1715518796
Run Time: 0.000313
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 220
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20