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 (182826, 180306, 179275, 178744, 178568, 178562, 178395, 177354, 176177, 175120, 173639, 172398, 165699, 165642, 164034, 163961, 163702, 163566, 161634, 161291, 160518, 160290, 156821, 156820, 156338, 155560, 155319, 153297, 153034, 148787, 148581, 147396, 147363, 147327, 146152, 128463, 128373, 121866, 119191, 118806, 115445, 108090, 103853, 98946, 98366, 98333, 96984, 93968, 90529, 90105, 89852, 89211, 88818, 88315, 88288, 87515, 86988, 86175, 85898, 82852, 80252, 80183, 80104, 80012, 80011, 79996, 79914, 79893, 79877, 79671, 78493, 70273, 67166, 66184, 66083, 65473, 64902, 54725, 52716, 49977, 49425, 48103, 47519, 47431, 45784, 39961, 38680, 920))
Run Time: 0.043391
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 88 | 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: 226, 0, 1714718499, {"thread-182826":["thread",182826],"thread-180306":["thread",180306],"thread-179275":["thread",179275],"thread-178744":["thread",178744],"thread-178568":["thread",178568],"thread-178562":["thread",178562],"thread-178395":["thread",178395],"thread-177354":["thread",177354],"thread-176177":["thread",176177],"thread-175120":["thread",175120],"thread-173639":["thread",173639],"thread-172398":["thread",172398],"thread-165699":["thread",165699],"thread-165642":["thread",165642],"thread-164034":["thread",164034],"thread-163961":["thread",163961],"thread-163702":["thread",163702],"thread-163566":["thread",163566],"ams_article-4485":["ams_article",4485],"thread-161634":["thread",161634],"thread-161291":["thread",161291],"thread-160518":["thread",160518],"thread-160290":["thread",160290],"ams_article-4347":["ams_article",4347],"thread-156821":["thread",156821],"thread-156820":["thread",156820],"thread-156338":["thread",156338],"thread-155560":["thread",155560],"thread-155319":["thread",155319],"thread-153297":["thread",153297],"thread-153034":["thread",153034],"thread-148787":["thread",148787],"thread-148581":["thread",148581],"ams_article-3668":["ams_article",3668],"thread-147396":["thread",147396],"thread-147363":["thread",147363],"thread-147327":["thread",147327],"thread-146152":["thread",146152],"thread-128463":["thread",128463],"thread-128373":["thread",128373],"thread-121866":["thread",121866],"thread-119191":["thread",119191],"thread-118806":["thread",118806],"thread-115445":["thread",115445],"thread-108090":["thread",108090],"thread-103853":["thread",103853],"thread-98946":["thread",98946],"thread-98366":["thread",98366],"thread-98333":["thread",98333],"thread-96984":["thread",96984],"thread-93968":["thread",93968],"thread-90529":["thread",90529],"thread-90105":["thread",90105],"thread-89852":["thread",89852],"thread-89211":["thread",89211],"thread-88818":["thread",88818],"thread-88315":["thread",88315],"thread-88288":["thread",88288],"thread-87515":["thread",87515],"thread-86988":["thread",86988],"thread-86175":["thread",86175],"thread-85898":["thread",85898],"thread-82852":["thread",82852],"thread-80252":["thread",80252],"thread-80183":["thread",80183],"thread-80104":["thread",80104],"thread-80012":["thread",80012],"thread-80011":["thread",80011],"thread-79996":["thread",79996],"thread-79914":["thread",79914],"thread-79893":["thread",79893],"thread-79877":["thread",79877],"thread-79671":["thread",79671],"thread-78493":["thread",78493],"thread-70273":["thread",70273],"thread-67166":["thread",67166],"thread-66184":["thread",66184],"thread-66083":["thread",66083],"thread-65473":["thread",65473],"thread-64902":["thread",64902],"thread-54725":["thread",54725],"thread-52716":["thread",52716],"thread-49977":["thread",49977],"thread-49425":["thread",49425],"thread-48103":["thread",48103],"thread-47519":["thread",47519],"thread-47431":["thread",47431],"thread-45784":["thread",45784],"thread-39961":["thread",39961],"thread-38680":["thread",38680],"thread-920":["thread",920]}, , 1714714899
Run Time: 0.000287
- 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