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 (183882, 183814, 183758, 183720, 183314, 183209, 183087, 182938, 182914, 182820, 182734, 182682, 182518, 182418, 182158, 182069, 182027, 181927, 181671, 181644, 181629, 181434, 181432, 181272, 181202, 181055, 180968, 180728, 180536, 180332, 179913, 179891, 179850, 179710, 179543, 179148, 179061, 178940, 178798, 178609, 177984, 177877, 177684, 177681, 177665, 177660, 177619, 177177, 177115, 176955, 176944, 176526, 176387, 176375, 176138, 176119, 175887, 175857, 175819, 175597, 175473, 175370, 175196, 175191, 175190, 175084, 174664, 174661, 174648, 174642, 174587, 174351, 174273, 174271, 174246, 174213, 173855, 173854, 173827, 173667, 173623, 173227, 173138, 172864, 172178, 171856, 171762, 171490, 171440, 171431, 171326, 171304, 169969, 169868, 169793, 169792, 169621, 169315, 169287, 169242, 169189, 169178, 169153, 169074, 168970, 168902, 168785, 168322, 168229, 168166, 167979, 167935, 167878, 167671, 167642, 167506, 167379, 167246, 166707, 166606, 166343, 166328, 165724, 165194, 164770, 164171, 164120, 163503, 163311, 162950, 162727, 162218, 161759, 161663, 161091, 160467, 160353, 159861, 159545, 159191, 159084, 159031, 158903, 157908, 157800, 157582, 157090, 156617, 156591, 155813, 155800, 154915, 154694, 154291, 153760, 153715, 153217, 153021, 152756, 152647, 152622, 152458, 150578, 150169, 149364, 148378, 147999, 147939, 147865, 147313, 145891, 145776, 145494, 142891, 141786))
Run Time: 0.085135
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 175 | 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: 5296, 0, 1716972419, {"thread-183882":["thread",183882],"thread-183814":["thread",183814],"thread-183758":["thread",183758],"thread-183720":["thread",183720],"thread-183314":["thread",183314],"thread-183209":["thread",183209],"thread-183087":["thread",183087],"thread-182938":["thread",182938],"thread-182914":["thread",182914],"thread-182820":["thread",182820],"thread-182734":["thread",182734],"thread-182682":["thread",182682],"thread-182518":["thread",182518],"thread-182418":["thread",182418],"thread-182158":["thread",182158],"thread-182069":["thread",182069],"thread-182027":["thread",182027],"thread-181927":["thread",181927],"thread-181671":["thread",181671],"thread-181644":["thread",181644],"thread-181629":["thread",181629],"thread-181434":["thread",181434],"thread-181432":["thread",181432],"thread-181272":["thread",181272],"thread-181202":["thread",181202],"thread-181055":["thread",181055],"thread-180968":["thread",180968],"thread-180728":["thread",180728],"thread-180536":["thread",180536],"thread-180332":["thread",180332],"thread-179913":["thread",179913],"thread-179891":["thread",179891],"thread-179850":["thread",179850],"thread-179710":["thread",179710],"thread-179543":["thread",179543],"thread-179148":["thread",179148],"thread-179061":["thread",179061],"thread-178940":["thread",178940],"thread-178798":["thread",178798],"thread-178609":["thread",178609],"thread-177984":["thread",177984],"thread-177877":["thread",177877],"thread-177684":["thread",177684],"thread-177681":["thread",177681],"thread-177665":["thread",177665],"thread-177660":["thread",177660],"thread-177619":["thread",177619],"thread-177177":["thread",177177],"thread-177115":["thread",177115],"thread-176955":["thread",176955],"thread-176944":["thread",176944],"thread-176526":["thread",176526],"thread-176387":["thread",176387],"thread-176375":["thread",176375],"thread-176138":["thread",176138],"thread-176119":["thread",176119],"thread-175887":["thread",175887],"thread-175857":["thread",175857],"thread-175819":["thread",175819],"thread-175597":["thread",175597],"thread-175473":["thread",175473],"thread-175370":["thread",175370],"thread-175196":["thread",175196],"thread-175191":["thread",175191],"thread-175190":["thread",175190],"thread-175084":["thread",175084],"thread-174664":["thread",174664],"thread-174661":["thread",174661],"thread-174648":["thread",174648],"thread-174642":["thread",174642],"thread-174587":["thread",174587],"thread-174351":["thread",174351],"thread-174273":["thread",174273],"thread-174271":["thread",174271],"thread-174246":["thread",174246],"thread-174213":["thread",174213],"thread-173855":["thread",173855],"thread-173854":["thread",173854],"thread-173827":["thread",173827],"thread-173667":["thread",173667],"thread-173623":["thread",173623],"thread-173227":["thread",173227],"thread-173138":["thread",173138],"thread-172864":["thread",172864],"ams_article-4900":["ams_article",4900],"thread-172178":["thread",172178],"ams_article-4893":["ams_article",4893],"thread-171856":["thread",171856],"thread-171762":["thread",171762],"thread-171490":["thread",171490],"thread-171440":["thread",171440],"thread-171431":["thread",171431],"thread-171326":["thread",171326],"ams_article-4862":["ams_article",4862],"thread-171304":["thread",171304],"ams_article-4830":["ams_article",4830],"thread-169969":["thread",169969],"thread-169868":["thread",169868],"thread-169793":["thread",169793],"thread-169792":["thread",169792],"thread-169621":["thread",169621],"thread-169315":["thread",169315],"thread-169287":["thread",169287],"thread-169242":["thread",169242],"thread-169189":["thread",169189],"thread-169178":["thread",169178],"thread-169153":["thread",169153],"thread-169074":["thread",169074],"thread-168970":["thread",168970],"thread-168902":["thread",168902],"thread-168785":["thread",168785],"thread-168322":["thread",168322],"thread-168229":["thread",168229],"thread-168166":["thread",168166],"thread-167979":["thread",167979],"ams_article-4753":["ams_article",4753],"thread-167935":["thread",167935],"thread-167878":["thread",167878],"thread-167671":["thread",167671],"thread-167642":["thread",167642],"thread-167506":["thread",167506],"thread-167379":["thread",167379],"thread-167246":["thread",167246],"ams_article-4737":["ams_article",4737],"ams_article-4728":["ams_article",4728],"ams_article-4725":["ams_article",4725],"ams_article-4723":["ams_article",4723],"thread-166707":["thread",166707],"thread-166606":["thread",166606],"thread-166343":["thread",166343],"thread-166328":["thread",166328],"thread-165724":["thread",165724],"thread-165194":["thread",165194],"thread-164770":["thread",164770],"ams_article-4606":["ams_article",4606],"ams_article-4603":["ams_article",4603],"ams_article-4597":["ams_article",4597],"thread-164171":["thread",164171],"thread-164120":["thread",164120],"ams_article-4544":["ams_article",4544],"thread-163503":["thread",163503],"thread-163311":["thread",163311],"thread-162950":["thread",162950],"thread-162727":["thread",162727],"thread-162218":["thread",162218],"thread-161759":["thread",161759],"thread-161663":["thread",161663],"tl_group_event-18":["tl_group_event",18],"thread-161091":["thread",161091],"ams_article-4425":["ams_article",4425],"thread-160467":["thread",160467],"ams_article-4423":["ams_article",4423],"thread-160353":["thread",160353],"thread-159861":["thread",159861],"thread-159545":["thread",159545],"thread-159191":["thread",159191],"thread-159084":["thread",159084],"thread-159031":["thread",159031],"thread-158903":["thread",158903],"ams_article-4331":["ams_article",4331],"thread-157908":["thread",157908],"thread-157800":["thread",157800],"thread-157582":["thread",157582],"ams_article-4274":["ams_article",4274],"thread-157090":["thread",157090],"thread-156617":["thread",156617],"thread-156591":["thread",156591],"thread-155813":["thread",155813],"thread-155800":["thread",155800],"thread-154915":["thread",154915],"thread-154694":["thread",154694],"ams_article-4095":["ams_article",4095],"thread-154291":["thread",154291],"thread-153760":["thread",153760],"thread-153715":["thread",153715],"thread-153217":["thread",153217],"thread-153021":["thread",153021],"thread-152756":["thread",152756],"thread-152647":["thread",152647],"thread-152622":["thread",152622],"thread-152458":["thread",152458],"thread-150578":["thread",150578],"thread-150169":["thread",150169],"ams_article-3771":["ams_article",3771],"thread-149364":["thread",149364],"thread-148378":["thread",148378],"thread-147999":["thread",147999],"thread-147939":["thread",147939],"thread-147865":["thread",147865],"thread-147313":["thread",147313],"ams_article-3559":["ams_article",3559],"ams_article-3496":["ams_article",3496],"ams_article-3489":["ams_article",3489],"thread-145891":["thread",145891],"thread-145776":["thread",145776],"thread-145494":["thread",145494],"thread-142891":["thread",142891],"thread-141786":["thread",141786]}, , 1716968819
Run Time: 0.000412
- 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