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 (161074, 160428, 160123, 159841, 159240, 158971, 158913, 158402, 158256, 158193, 158064, 158016, 157699, 157166, 157153, 157072, 157000, 156627, 156621, 156585, 155701, 155170, 154737, 154404, 154263, 153886, 153828, 153733, 153526, 153493, 153381, 152595, 152222, 152168, 152115, 152034, 151972, 151963, 151862, 151852, 151788, 151764, 151113, 150802, 150191, 149867, 149835, 149796, 149748, 148614, 148229, 148228, 148221, 148122, 147960, 146911, 146780, 146502, 146341, 146312, 146216, 146152, 146035, 146029, 145979, 145969, 145872, 145834, 145657, 145384, 145316, 145261, 145201, 145184, 145142, 145040, 145006, 144992, 144902, 143815, 143800, 143776, 143773, 143744, 143704, 143586, 143569, 143568, 143567, 142291, 142163, 142128, 142011, 141785, 141728, 141673, 141599, 141073, 140985, 140951, 140670, 140625, 140208, 140131, 140082, 139932, 139837, 139700, 139667, 139649, 139409, 139408, 139294, 139254, 139126, 138950, 138865, 138406, 138279, 138194, 138125, 137839, 137619, 137563, 137548, 137510, 137382, 136981, 136852, 136848, 136808, 136804, 136734, 136687, 136384, 136283, 136282, 136088, 135989, 135951, 135910, 135851, 135513, 135503, 135271, 135219, 135099, 134994, 134843, 134686, 134515, 134323, 134181, 134050, 133818, 133701, 133659, 133602, 133453, 133398, 133329, 133258, 133244, 133130, 132552, 132534, 132454, 132453, 132189, 132020, 131925, 131881))
Run Time: 0.124174
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 172 | 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: 590, 0, 1714450360, {"thread-161074":["thread",161074],"thread-160428":["thread",160428],"thread-160123":["thread",160123],"thread-159841":["thread",159841],"thread-159240":["thread",159240],"thread-158971":["thread",158971],"thread-158913":["thread",158913],"thread-158402":["thread",158402],"thread-158256":["thread",158256],"thread-158193":["thread",158193],"thread-158064":["thread",158064],"thread-158016":["thread",158016],"thread-157699":["thread",157699],"ams_article-4290":["ams_article",4290],"thread-157166":["thread",157166],"thread-157153":["thread",157153],"thread-157072":["thread",157072],"thread-157000":["thread",157000],"thread-156627":["thread",156627],"thread-156621":["thread",156621],"thread-156585":["thread",156585],"thread-155701":["thread",155701],"ams_article-4178":["ams_article",4178],"ams_article-4169":["ams_article",4169],"ams_article-4164":["ams_article",4164],"ams_article-4156":["ams_article",4156],"ams_article-4149":["ams_article",4149],"ams_article-4146":["ams_article",4146],"thread-155170":["thread",155170],"tl_group-108":["tl_group",108],"thread-154737":["thread",154737],"ams_article-4108":["ams_article",4108],"ams_article-4103":["ams_article",4103],"thread-154404":["thread",154404],"thread-154263":["thread",154263],"ams_article-4077":["ams_article",4077],"thread-153886":["thread",153886],"ams_article-4062":["ams_article",4062],"thread-153828":["thread",153828],"thread-153733":["thread",153733],"ams_article-4044":["ams_article",4044],"thread-153526":["thread",153526],"thread-153493":["thread",153493],"thread-153381":["thread",153381],"ams_article-3994":["ams_article",3994],"ams_article-3992":["ams_article",3992],"thread-152595":["thread",152595],"thread-152222":["thread",152222],"ams_article-3957":["ams_article",3957],"thread-152168":["thread",152168],"thread-152115":["thread",152115],"thread-152034":["thread",152034],"thread-151972":["thread",151972],"thread-151963":["thread",151963],"ams_article-3939":["ams_article",3939],"thread-151862":["thread",151862],"thread-151852":["thread",151852],"thread-151788":["thread",151788],"thread-151764":["thread",151764],"tl_group-12":["tl_group",12],"ams_article-3880":["ams_article",3880],"thread-151113":["thread",151113],"ams_article-3869":["ams_article",3869],"thread-150802":["thread",150802],"ams_article-3807":["ams_article",3807],"thread-150191":["thread",150191],"thread-149867":["thread",149867],"ams_article-3782":["ams_article",3782],"thread-149835":["thread",149835],"thread-149796":["thread",149796],"thread-149748":["thread",149748],"thread-148614":["thread",148614],"thread-148229":["thread",148229],"thread-148228":["thread",148228],"thread-148221":["thread",148221],"thread-148122":["thread",148122],"thread-147960":["thread",147960],"thread-146911":["thread",146911],"ams_article-3545":["ams_article",3545],"thread-146780":["thread",146780],"thread-146502":["thread",146502],"thread-146341":["thread",146341],"thread-146312":["thread",146312],"thread-146216":["thread",146216],"thread-146152":["thread",146152],"thread-146035":["thread",146035],"thread-146029":["thread",146029],"thread-145979":["thread",145979],"thread-145969":["thread",145969],"thread-145872":["thread",145872],"thread-145834":["thread",145834],"thread-145657":["thread",145657],"thread-145384":["thread",145384],"thread-145316":["thread",145316],"thread-145261":["thread",145261],"thread-145201":["thread",145201],"thread-145184":["thread",145184],"thread-145142":["thread",145142],"thread-145040":["thread",145040],"thread-145006":["thread",145006],"thread-144992":["thread",144992],"thread-144902":["thread",144902],"thread-143815":["thread",143815],"thread-143800":["thread",143800],"thread-143776":["thread",143776],"thread-143773":["thread",143773],"thread-143744":["thread",143744],"thread-143704":["thread",143704],"thread-143586":["thread",143586],"thread-143569":["thread",143569],"thread-143568":["thread",143568],"thread-143567":["thread",143567],"ams_article-3296":["ams_article",3296],"ams_article-3287":["ams_article",3287],"thread-142291":["thread",142291],"thread-142163":["thread",142163],"thread-142128":["thread",142128],"thread-142011":["thread",142011],"thread-141785":["thread",141785],"thread-141728":["thread",141728],"thread-141673":["thread",141673],"thread-141599":["thread",141599],"thread-141073":["thread",141073],"thread-140985":["thread",140985],"thread-140951":["thread",140951],"thread-140670":["thread",140670],"thread-140625":["thread",140625],"thread-140208":["thread",140208],"thread-140131":["thread",140131],"thread-140082":["thread",140082],"thread-139932":["thread",139932],"thread-139837":["thread",139837],"thread-139700":["thread",139700],"thread-139667":["thread",139667],"thread-139649":["thread",139649],"thread-139409":["thread",139409],"thread-139408":["thread",139408],"thread-139294":["thread",139294],"thread-139254":["thread",139254],"thread-139126":["thread",139126],"thread-138950":["thread",138950],"thread-138865":["thread",138865],"ams_article-3068":["ams_article",3068],"thread-138406":["thread",138406],"thread-138279":["thread",138279],"thread-138194":["thread",138194],"thread-138125":["thread",138125],"thread-137839":["thread",137839],"thread-137619":["thread",137619],"thread-137563":["thread",137563],"thread-137548":["thread",137548],"thread-137510":["thread",137510],"thread-137382":["thread",137382],"thread-136981":["thread",136981],"thread-136852":["thread",136852],"thread-136848":["thread",136848],"thread-136808":["thread",136808],"thread-136804":["thread",136804],"thread-136734":["thread",136734],"thread-136687":["thread",136687],"thread-136384":["thread",136384],"thread-136283":["thread",136283],"thread-136282":["thread",136282],"thread-136088":["thread",136088],"thread-135989":["thread",135989],"thread-135951":["thread",135951],"thread-135910":["thread",135910],"thread-135851":["thread",135851],"thread-135513":["thread",135513],"thread-135503":["thread",135503],"thread-135271":["thread",135271],"thread-135219":["thread",135219],"thread-135099":["thread",135099],"thread-134994":["thread",134994],"thread-134843":["thread",134843],"thread-134686":["thread",134686],"thread-134515":["thread",134515],"thread-134323":["thread",134323],"thread-134181":["thread",134181],"thread-134050":["thread",134050],"thread-133818":["thread",133818],"thread-133701":["thread",133701],"thread-133659":["thread",133659],"thread-133602":["thread",133602],"thread-133453":["thread",133453],"thread-133398":["thread",133398],"thread-133329":["thread",133329],"thread-133258":["thread",133258],"thread-133244":["thread",133244],"thread-133130":["thread",133130],"thread-132552":["thread",132552],"thread-132534":["thread",132534],"thread-132454":["thread",132454],"thread-132453":["thread",132453],"thread-132189":["thread",132189],"thread-132020":["thread",132020],"thread-131925":["thread",131925],"thread-131881":["thread",131881]}, , 1714446760
Run Time: 0.000723
- 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