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 (178467, 173989, 173974, 173059, 172096, 171632, 171631, 170993, 170926, 170878, 170806, 170799, 170770, 170658, 170642, 170599, 170441, 170438, 167509, 167415, 167331, 167320, 167314, 167303, 167296, 167291, 167290, 167178, 167175, 167171, 167143, 167109, 167105, 167085, 167050, 166994, 166910, 166893, 166869, 166868, 166816, 166812, 166810, 166773, 166771, 166769, 166734, 166732, 166712, 166708, 166697, 166686, 166684, 166673, 166631, 166628, 166609, 166540, 166302, 166281, 166033, 165940, 165844, 165703, 165471, 165413, 165361, 165354, 165339, 165236, 165205, 165203, 165199, 165157, 165130, 165109, 165081, 165053, 165022, 165014, 165000, 164984, 164945, 164903, 164868, 164848, 164812, 164610, 164602, 164595, 164576, 164387, 164318, 164244, 164160, 164125, 163912, 163765, 163627, 162864, 162344, 162092, 162006, 157930, 157891, 156754, 156658, 155762, 154364, 154207, 153866, 153794, 153652, 153446, 153276, 152736, 152247, 152187, 152154, 152044, 152031, 152008, 151960, 151935, 151225, 151013, 150904, 150770, 150729, 150650, 150355, 146368, 145280, 145279, 145024, 144861, 144064, 144029, 143571, 143303, 143170, 143119, 142964, 142875, 142848, 142800, 142743, 142684, 142602, 142593, 142408, 142227, 142009, 141767, 141529, 141511, 141156, 141141, 141026, 140659, 140613, 140070, 140002, 139791, 139634, 139396, 139065, 138449, 138360, 138259, 138092, 138024, 137929, 137824, 137773, 137698, 137674, 137507, 137477, 137366, 137330, 137235, 137193, 137161, 137128, 137090, 137007, 136953, 136917, 136872, 136850, 136840, 136819, 136728, 136657, 136597, 136513, 136456, 136402, 136179))
Run Time: 0.161238
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | 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: 11603, 0, 1716172459, {"thread-178467":["thread",178467],"thread-173989":["thread",173989],"thread-173974":["thread",173974],"thread-173059":["thread",173059],"thread-172096":["thread",172096],"thread-171632":["thread",171632],"thread-171631":["thread",171631],"thread-170993":["thread",170993],"thread-170926":["thread",170926],"thread-170878":["thread",170878],"thread-170806":["thread",170806],"thread-170799":["thread",170799],"thread-170770":["thread",170770],"thread-170658":["thread",170658],"thread-170642":["thread",170642],"thread-170599":["thread",170599],"thread-170441":["thread",170441],"thread-170438":["thread",170438],"thread-167509":["thread",167509],"thread-167415":["thread",167415],"thread-167331":["thread",167331],"thread-167320":["thread",167320],"thread-167314":["thread",167314],"thread-167303":["thread",167303],"thread-167296":["thread",167296],"thread-167291":["thread",167291],"thread-167290":["thread",167290],"thread-167178":["thread",167178],"thread-167175":["thread",167175],"thread-167171":["thread",167171],"thread-167143":["thread",167143],"thread-167109":["thread",167109],"thread-167105":["thread",167105],"thread-167085":["thread",167085],"thread-167050":["thread",167050],"thread-166994":["thread",166994],"thread-166910":["thread",166910],"thread-166893":["thread",166893],"thread-166869":["thread",166869],"thread-166868":["thread",166868],"thread-166816":["thread",166816],"thread-166812":["thread",166812],"thread-166810":["thread",166810],"thread-166773":["thread",166773],"thread-166771":["thread",166771],"thread-166769":["thread",166769],"thread-166734":["thread",166734],"thread-166732":["thread",166732],"thread-166712":["thread",166712],"thread-166708":["thread",166708],"thread-166697":["thread",166697],"thread-166686":["thread",166686],"thread-166684":["thread",166684],"thread-166673":["thread",166673],"thread-166631":["thread",166631],"thread-166628":["thread",166628],"thread-166609":["thread",166609],"thread-166540":["thread",166540],"thread-166302":["thread",166302],"thread-166281":["thread",166281],"thread-166033":["thread",166033],"thread-165940":["thread",165940],"thread-165844":["thread",165844],"thread-165703":["thread",165703],"thread-165471":["thread",165471],"thread-165413":["thread",165413],"thread-165361":["thread",165361],"thread-165354":["thread",165354],"thread-165339":["thread",165339],"thread-165236":["thread",165236],"thread-165205":["thread",165205],"thread-165203":["thread",165203],"thread-165199":["thread",165199],"thread-165157":["thread",165157],"thread-165130":["thread",165130],"thread-165109":["thread",165109],"thread-165081":["thread",165081],"thread-165053":["thread",165053],"thread-165022":["thread",165022],"thread-165014":["thread",165014],"thread-165000":["thread",165000],"thread-164984":["thread",164984],"thread-164945":["thread",164945],"thread-164903":["thread",164903],"thread-164868":["thread",164868],"thread-164848":["thread",164848],"thread-164812":["thread",164812],"thread-164610":["thread",164610],"thread-164602":["thread",164602],"thread-164595":["thread",164595],"thread-164576":["thread",164576],"thread-164387":["thread",164387],"thread-164318":["thread",164318],"thread-164244":["thread",164244],"thread-164160":["thread",164160],"thread-164125":["thread",164125],"thread-163912":["thread",163912],"thread-163765":["thread",163765],"thread-163627":["thread",163627],"thread-162864":["thread",162864],"thread-162344":["thread",162344],"thread-162092":["thread",162092],"thread-162006":["thread",162006],"thread-157930":["thread",157930],"thread-157891":["thread",157891],"thread-156754":["thread",156754],"thread-156658":["thread",156658],"thread-155762":["thread",155762],"thread-154364":["thread",154364],"thread-154207":["thread",154207],"thread-153866":["thread",153866],"thread-153794":["thread",153794],"thread-153652":["thread",153652],"thread-153446":["thread",153446],"thread-153276":["thread",153276],"thread-152736":["thread",152736],"thread-152247":["thread",152247],"thread-152154":["thread",152154],"thread-152044":["thread",152044],"thread-152031":["thread",152031],"thread-152008":["thread",152008],"thread-151960":["thread",151960],"thread-151935":["thread",151935],"thread-151225":["thread",151225],"thread-151013":["thread",151013],"thread-150904":["thread",150904],"thread-150770":["thread",150770],"thread-150729":["thread",150729],"thread-150650":["thread",150650],"thread-150355":["thread",150355],"thread-146368":["thread",146368],"thread-145280":["thread",145280],"thread-145279":["thread",145279],"thread-145024":["thread",145024],"thread-144861":["thread",144861],"thread-144064":["thread",144064],"thread-144029":["thread",144029],"thread-143571":["thread",143571],"thread-143303":["thread",143303],"thread-143170":["thread",143170],"thread-143119":["thread",143119],"thread-142964":["thread",142964],"thread-142875":["thread",142875],"thread-142848":["thread",142848],"thread-142800":["thread",142800],"thread-142743":["thread",142743],"thread-142684":["thread",142684],"thread-142602":["thread",142602],"thread-142593":["thread",142593],"thread-142408":["thread",142408],"thread-142227":["thread",142227],"thread-142009":["thread",142009],"thread-141767":["thread",141767],"thread-141529":["thread",141529],"thread-141511":["thread",141511],"thread-141156":["thread",141156],"thread-141141":["thread",141141],"thread-141026":["thread",141026],"thread-140659":["thread",140659],"thread-140613":["thread",140613],"thread-140070":["thread",140070],"thread-140002":["thread",140002],"thread-139791":["thread",139791],"thread-139634":["thread",139634],"thread-139396":["thread",139396],"thread-139065":["thread",139065],"thread-138449":["thread",138449],"thread-138360":["thread",138360],"thread-138259":["thread",138259],"thread-138092":["thread",138092],"thread-138024":["thread",138024],"thread-137929":["thread",137929],"thread-137824":["thread",137824],"thread-137773":["thread",137773],"thread-137698":["thread",137698],"thread-137674":["thread",137674],"thread-137507":["thread",137507],"thread-137477":["thread",137477],"thread-137366":["thread",137366],"thread-137330":["thread",137330],"thread-137235":["thread",137235],"thread-137193":["thread",137193],"thread-137161":["thread",137161],"thread-137128":["thread",137128],"thread-137090":["thread",137090],"thread-137007":["thread",137007],"thread-136953":["thread",136953],"thread-136917":["thread",136917],"thread-136872":["thread",136872],"thread-136850":["thread",136850],"thread-136840":["thread",136840],"thread-136819":["thread",136819],"thread-136728":["thread",136728],"thread-136657":["thread",136657],"thread-136597":["thread",136597],"thread-136513":["thread",136513],"thread-136456":["thread",136456],"thread-136402":["thread",136402],"thread-136179":["thread",136179]}, , 1716168859
Run Time: 0.000517
- 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