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 (181580, 180262, 179906, 179533, 179206, 178660, 177608, 177539, 176560, 176406, 176369, 175071, 173851, 173536, 173116, 172941, 172397, 172154, 171738, 170971, 170363, 170289, 168548, 168140, 167526, 167335, 166633, 166423, 165999, 165748, 165214, 164876, 164470, 162825, 161400, 161154, 160783, 160575, 159942, 159668, 158893, 158175, 158095, 157255, 153517, 151996, 151863, 151742, 131291, 129203, 126447, 125452, 121542, 119645, 107950, 101241, 100449, 95675, 94761, 90424, 85797, 85257, 79323, 65572, 63517, 57427, 57004, 56963, 56877, 56595, 55655, 39267, 34004, 26754, 25290, 2480, 1837))
Run Time: 0.031685
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 77 | 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: 529, 0, 1714773615, {"thread-181580":["thread",181580],"thread-180262":["thread",180262],"thread-179906":["thread",179906],"thread-179533":["thread",179533],"thread-179206":["thread",179206],"thread-178660":["thread",178660],"thread-177608":["thread",177608],"thread-177539":["thread",177539],"thread-176560":["thread",176560],"thread-176406":["thread",176406],"thread-176369":["thread",176369],"thread-175071":["thread",175071],"thread-173851":["thread",173851],"thread-173536":["thread",173536],"thread-173116":["thread",173116],"thread-172941":["thread",172941],"thread-172397":["thread",172397],"thread-172154":["thread",172154],"thread-171738":["thread",171738],"thread-170363":["thread",170363],"thread-170289":["thread",170289],"thread-168548":["thread",168548],"thread-168140":["thread",168140],"thread-167526":["thread",167526],"thread-167335":["thread",167335],"thread-166633":["thread",166633],"thread-166423":["thread",166423],"thread-165999":["thread",165999],"thread-165748":["thread",165748],"thread-165214":["thread",165214],"thread-164876":["thread",164876],"thread-164470":["thread",164470],"thread-162825":["thread",162825],"thread-161400":["thread",161400],"thread-161154":["thread",161154],"thread-160783":["thread",160783],"thread-160575":["thread",160575],"thread-159942":["thread",159942],"thread-159668":["thread",159668],"thread-158893":["thread",158893],"thread-158175":["thread",158175],"thread-158095":["thread",158095],"thread-157255":["thread",157255],"thread-153517":["thread",153517],"thread-151996":["thread",151996],"thread-151863":["thread",151863],"thread-131291":["thread",131291],"thread-129203":["thread",129203],"thread-126447":["thread",126447],"thread-125452":["thread",125452],"thread-121542":["thread",121542],"thread-119645":["thread",119645],"thread-107950":["thread",107950],"thread-101241":["thread",101241],"thread-100449":["thread",100449],"thread-95675":["thread",95675],"thread-94761":["thread",94761],"thread-90424":["thread",90424],"thread-85797":["thread",85797],"thread-85257":["thread",85257],"thread-79323":["thread",79323],"thread-65572":["thread",65572],"thread-63517":["thread",63517],"thread-57427":["thread",57427],"thread-57004":["thread",57004],"thread-56963":["thread",56963],"thread-56877":["thread",56877],"thread-56595":["thread",56595],"thread-55655":["thread",55655],"thread-39267":["thread",39267],"thread-34004":["thread",34004],"thread-26754":["thread",26754],"thread-25290":["thread",25290],"thread-2480":["thread",2480],"thread-1837":["thread",1837]}, , 1714770015
Run Time: 0.008038
- 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