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 (7216889, 7215720, 7212985, 7210977, 7210558, 7203842, 7201711, 7200087, 7197092, 7191838, 7190248, 7188151, 7188032, 7187368, 7184723, 7183812, 7180876, 7180875, 7180486, 7179516, 7177666, 7177010, 7175838, 7173551, 7173138, 7171871, 7164162, 7163308, 7161870, 7160743, 7150860, 7144367, 7143224, 7138661, 7130069, 7128672, 7128560, 7125299, 7121377, 7121045, 7120665, 7120382, 7120066, 7118392, 7117390, 7111490, 7109718, 7107159, 7106214, 7105618, 7104601, 7104477, 7104446, 7100340, 7100139, 7097034, 7094764, 7092479, 7091714, 7089944, 7088617, 7078062, 7075270, 7074544, 7070034, 7060243, 7060168, 7049777, 7049740, 7047876, 7047869, 7047550, 7044011, 7042594, 7039539, 7035944, 7033415, 7033317, 7033185, 7031820, 7031614, 7026348, 7024949, 7024946, 7013307, 7013262, 7013136, 7013056, 7009490, 7008676, 7008432, 7005703, 7005475, 7005308, 7005024, 6999775, 6999655, 6999536, 6995309, 6990246, 6988165, 6987644, 6987465, 6987396, 6986845, 6984374, 6983830, 6983564, 6983540, 6983152, 6972798, 6970432, 6969602, 6968450, 6958152, 6674308, 240054, 239426, 234724, 228887, 228396, 227349, 227057, 217196, 215108, 214569, 213277, 201487, 201132, 200162, 200161, 200160, 199538, 199223, 193619, 184321, 183281, 179217, 177033, 164674, 162492, 160905))
Run Time: 0.009012
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 142 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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 1430
- 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 2870
- 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 138
- 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 2487
- XF\App->run() in src/XF.php at line 524
- 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: 8372, 0, 1714968491, {"thread-7216889":["thread",7216889],"thread-7215720":["thread",7215720],"thread-7212985":["thread",7212985],"thread-7210977":["thread",7210977],"thread-7210558":["thread",7210558],"thread-7203842":["thread",7203842],"thread-7201711":["thread",7201711],"thread-7200087":["thread",7200087],"thread-7197092":["thread",7197092],"thread-7191838":["thread",7191838],"thread-7190248":["thread",7190248],"thread-7188151":["thread",7188151],"thread-7188032":["thread",7188032],"thread-7187368":["thread",7187368],"thread-7184723":["thread",7184723],"thread-7183812":["thread",7183812],"thread-7180876":["thread",7180876],"thread-7180875":["thread",7180875],"thread-7180486":["thread",7180486],"thread-7179516":["thread",7179516],"thread-7177666":["thread",7177666],"thread-7177010":["thread",7177010],"thread-7175838":["thread",7175838],"thread-7173551":["thread",7173551],"thread-7173138":["thread",7173138],"thread-7171871":["thread",7171871],"thread-7164162":["thread",7164162],"thread-7163308":["thread",7163308],"thread-7161870":["thread",7161870],"thread-7160743":["thread",7160743],"thread-7150860":["thread",7150860],"thread-7144367":["thread",7144367],"thread-7143224":["thread",7143224],"thread-7138661":["thread",7138661],"thread-7130069":["thread",7130069],"thread-7128672":["thread",7128672],"thread-7128560":["thread",7128560],"thread-7125299":["thread",7125299],"thread-7121377":["thread",7121377],"thread-7121045":["thread",7121045],"thread-7120665":["thread",7120665],"thread-7120382":["thread",7120382],"thread-7120066":["thread",7120066],"thread-7118392":["thread",7118392],"thread-7117390":["thread",7117390],"thread-7111490":["thread",7111490],"thread-7109718":["thread",7109718],"thread-7107159":["thread",7107159],"thread-7106214":["thread",7106214],"thread-7105618":["thread",7105618],"thread-7104601":["thread",7104601],"thread-7104477":["thread",7104477],"thread-7104446":["thread",7104446],"thread-7100340":["thread",7100340],"thread-7100139":["thread",7100139],"thread-7097034":["thread",7097034],"thread-7094764":["thread",7094764],"thread-7092479":["thread",7092479],"thread-7091714":["thread",7091714],"thread-7089944":["thread",7089944],"thread-7088617":["thread",7088617],"thread-7078062":["thread",7078062],"thread-7075270":["thread",7075270],"thread-7074544":["thread",7074544],"thread-7070034":["thread",7070034],"thread-7060243":["thread",7060243],"thread-7060168":["thread",7060168],"thread-7049777":["thread",7049777],"thread-7049740":["thread",7049740],"thread-7047876":["thread",7047876],"thread-7047869":["thread",7047869],"thread-7047550":["thread",7047550],"thread-7044011":["thread",7044011],"thread-7042594":["thread",7042594],"thread-7039539":["thread",7039539],"thread-7035944":["thread",7035944],"thread-7033415":["thread",7033415],"thread-7033317":["thread",7033317],"thread-7033185":["thread",7033185],"thread-7031820":["thread",7031820],"thread-7031614":["thread",7031614],"thread-7026348":["thread",7026348],"thread-7024949":["thread",7024949],"thread-7024946":["thread",7024946],"thread-7013307":["thread",7013307],"thread-7013262":["thread",7013262],"thread-7013136":["thread",7013136],"thread-7013056":["thread",7013056],"thread-7009490":["thread",7009490],"thread-7008676":["thread",7008676],"thread-7008432":["thread",7008432],"thread-7005703":["thread",7005703],"thread-7005475":["thread",7005475],"thread-7005308":["thread",7005308],"thread-7005024":["thread",7005024],"thread-6999775":["thread",6999775],"thread-6999655":["thread",6999655],"thread-6999536":["thread",6999536],"thread-6995309":["thread",6995309],"thread-6990246":["thread",6990246],"thread-6988165":["thread",6988165],"thread-6987644":["thread",6987644],"thread-6987465":["thread",6987465],"thread-6987396":["thread",6987396],"thread-6986845":["thread",6986845],"thread-6984374":["thread",6984374],"thread-6983830":["thread",6983830],"thread-6983564":["thread",6983564],"thread-6983540":["thread",6983540],"thread-6983152":["thread",6983152],"thread-6972798":["thread",6972798],"thread-6970432":["thread",6970432],"thread-6969602":["thread",6969602],"thread-6968450":["thread",6968450],"thread-6958152":["thread",6958152],"thread-6674308":["thread",6674308],"thread-240054":["thread",240054],"thread-234724":["thread",234724],"thread-228396":["thread",228396],"thread-227349":["thread",227349],"thread-227057":["thread",227057],"thread-217196":["thread",217196],"thread-215108":["thread",215108],"thread-214569":["thread",214569],"thread-201487":["thread",201487],"thread-201132":["thread",201132],"thread-200162":["thread",200162],"thread-200161":["thread",200161],"thread-200160":["thread",200160],"thread-199538":["thread",199538],"thread-199223":["thread",199223],"thread-193619":["thread",193619],"thread-184321":["thread",184321],"thread-183281":["thread",183281],"thread-177033":["thread",177033],"thread-164674":["thread",164674],"thread-162492":["thread",162492]}, NULL, 1714964891
Run Time: 0.000535
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20