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 (7216933, 7216417, 7215005, 7214679, 7214596, 7214498, 7214334, 7214274, 7213752, 7212957, 7212400, 7212024, 7210914, 7209610, 7206583, 7204189, 7203758, 7203709, 7201944, 7201907, 7200373, 7200214, 7200206, 7199304, 7199301, 7199298, 7199295, 7198369, 7197833, 7197041, 7195591, 7194856, 7194391, 7194130, 7193822, 7193601, 7192736, 7192035, 7191089, 7189849, 7187921, 7186814, 7185927, 7184947, 7182073, 7180338, 7180104, 7179604, 7178712, 7177554, 7177435, 7177430, 7177308, 7176983, 7176956, 7176952, 7176789, 7176751, 7176689, 7176306, 7176276, 7175609, 7175338, 7174933, 7174454, 7174453, 7174317, 7174310, 7174309, 7174308, 7174307, 7174306, 7174266, 7174265, 7173025, 7171660, 7170727, 7170060, 7162311, 7160399, 7159563, 7159498, 7158486, 7158384, 7156177, 7155749, 7155701, 7155137, 7155095, 7154225, 7154186, 7153852, 7153768, 7152179, 7147788, 7147213, 7147173, 7145090, 7144278, 7144258, 7143944, 7143162, 7142372, 7140965, 7140423, 7140397, 7139735, 7138988, 7138903, 7138631, 7138588, 7138345, 7138203, 7137753, 7137599, 7137322, 7136932, 7134286, 7132787, 7131942, 7131665, 7131515, 7130847, 7130580, 7129520, 7124673, 7122752, 7122456, 7122295, 7121399, 7120149, 7119528, 7118026, 7117211, 7113274, 7113133, 7112557, 7111377, 7110588, 7107445, 7104754, 7103338, 7097199, 7095354, 7093170, 7092537, 7089552, 7087023, 7084588, 7082745, 7080127, 7078958, 7078538, 7077509, 7077184, 7075138, 7072332, 7071526, 7066677, 7065018, 7053825, 7048118, 7046408, 7044704, 7036107, 7032285, 7027214, 7025914, 7022821, 7022814, 7017618, 7010302, 7007651, 7006399, 7004761, 7003826, 7001559, 6994151, 6984357, 6983649, 6980614, 6980346, 6979971, 6978037, 6978030, 6974663, 6972308, 6972205, 6963714, 6962288, 6961302, 6960787, 6725295, 6592076, 6583128, 6389243, 6296934, 236535, 200629, 12785))
Run Time: 0.008885
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 | 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: 4301, 0, 1714759186, {"thread-7216933":["thread",7216933],"thread-7216417":["thread",7216417],"thread-7215005":["thread",7215005],"thread-7214679":["thread",7214679],"thread-7214596":["thread",7214596],"thread-7214498":["thread",7214498],"thread-7214334":["thread",7214334],"thread-7214274":["thread",7214274],"thread-7213752":["thread",7213752],"thread-7212957":["thread",7212957],"thread-7212400":["thread",7212400],"thread-7212024":["thread",7212024],"thread-7210914":["thread",7210914],"thread-7209610":["thread",7209610],"thread-7206583":["thread",7206583],"thread-7204189":["thread",7204189],"thread-7203758":["thread",7203758],"thread-7203709":["thread",7203709],"thread-7201944":["thread",7201944],"thread-7201907":["thread",7201907],"thread-7200373":["thread",7200373],"thread-7200214":["thread",7200214],"thread-7200206":["thread",7200206],"thread-7199304":["thread",7199304],"thread-7199301":["thread",7199301],"thread-7199298":["thread",7199298],"thread-7199295":["thread",7199295],"thread-7198369":["thread",7198369],"thread-7197833":["thread",7197833],"thread-7197041":["thread",7197041],"thread-7195591":["thread",7195591],"thread-7194856":["thread",7194856],"thread-7194391":["thread",7194391],"thread-7194130":["thread",7194130],"thread-7193822":["thread",7193822],"thread-7193601":["thread",7193601],"thread-7192736":["thread",7192736],"thread-7192035":["thread",7192035],"thread-7191089":["thread",7191089],"thread-7189849":["thread",7189849],"thread-7187921":["thread",7187921],"thread-7186814":["thread",7186814],"thread-7185927":["thread",7185927],"thread-7184947":["thread",7184947],"thread-7182073":["thread",7182073],"thread-7180338":["thread",7180338],"thread-7180104":["thread",7180104],"thread-7179604":["thread",7179604],"thread-7178712":["thread",7178712],"thread-7177554":["thread",7177554],"thread-7177435":["thread",7177435],"thread-7177430":["thread",7177430],"thread-7177308":["thread",7177308],"thread-7176983":["thread",7176983],"thread-7176956":["thread",7176956],"thread-7176952":["thread",7176952],"thread-7176789":["thread",7176789],"thread-7176751":["thread",7176751],"thread-7176689":["thread",7176689],"thread-7176306":["thread",7176306],"thread-7176276":["thread",7176276],"thread-7175609":["thread",7175609],"thread-7175338":["thread",7175338],"thread-7174933":["thread",7174933],"thread-7174454":["thread",7174454],"thread-7174453":["thread",7174453],"thread-7174317":["thread",7174317],"thread-7174310":["thread",7174310],"thread-7174309":["thread",7174309],"thread-7174308":["thread",7174308],"thread-7174307":["thread",7174307],"thread-7174306":["thread",7174306],"thread-7174266":["thread",7174266],"thread-7174265":["thread",7174265],"thread-7173025":["thread",7173025],"thread-7171660":["thread",7171660],"thread-7170727":["thread",7170727],"thread-7170060":["thread",7170060],"thread-7162311":["thread",7162311],"thread-7160399":["thread",7160399],"thread-7159563":["thread",7159563],"thread-7159498":["thread",7159498],"thread-7158486":["thread",7158486],"thread-7158384":["thread",7158384],"thread-7156177":["thread",7156177],"thread-7155749":["thread",7155749],"thread-7155701":["thread",7155701],"thread-7155137":["thread",7155137],"thread-7155095":["thread",7155095],"thread-7154225":["thread",7154225],"thread-7154186":["thread",7154186],"thread-7153852":["thread",7153852],"thread-7153768":["thread",7153768],"thread-7152179":["thread",7152179],"thread-7147788":["thread",7147788],"thread-7147213":["thread",7147213],"thread-7147173":["thread",7147173],"thread-7145090":["thread",7145090],"thread-7144278":["thread",7144278],"thread-7144258":["thread",7144258],"thread-7143944":["thread",7143944],"thread-7143162":["thread",7143162],"thread-7142372":["thread",7142372],"thread-7140965":["thread",7140965],"thread-7140423":["thread",7140423],"thread-7140397":["thread",7140397],"thread-7139735":["thread",7139735],"thread-7138988":["thread",7138988],"thread-7138903":["thread",7138903],"thread-7138631":["thread",7138631],"thread-7138588":["thread",7138588],"thread-7138345":["thread",7138345],"thread-7138203":["thread",7138203],"thread-7137753":["thread",7137753],"thread-7137599":["thread",7137599],"thread-7137322":["thread",7137322],"thread-7136932":["thread",7136932],"thread-7134286":["thread",7134286],"thread-7132787":["thread",7132787],"thread-7131942":["thread",7131942],"thread-7131665":["thread",7131665],"thread-7131515":["thread",7131515],"thread-7130847":["thread",7130847],"thread-7130580":["thread",7130580],"thread-7129520":["thread",7129520],"thread-7124673":["thread",7124673],"thread-7122752":["thread",7122752],"thread-7122456":["thread",7122456],"thread-7122295":["thread",7122295],"thread-7121399":["thread",7121399],"thread-7120149":["thread",7120149],"thread-7119528":["thread",7119528],"thread-7118026":["thread",7118026],"thread-7117211":["thread",7117211],"thread-7113274":["thread",7113274],"thread-7113133":["thread",7113133],"thread-7112557":["thread",7112557],"thread-7111377":["thread",7111377],"thread-7110588":["thread",7110588],"thread-7107445":["thread",7107445],"thread-7104754":["thread",7104754],"thread-7103338":["thread",7103338],"thread-7097199":["thread",7097199],"thread-7095354":["thread",7095354],"thread-7093170":["thread",7093170],"thread-7092537":["thread",7092537],"thread-7089552":["thread",7089552],"thread-7087023":["thread",7087023],"thread-7084588":["thread",7084588],"thread-7082745":["thread",7082745],"thread-7080127":["thread",7080127],"thread-7078958":["thread",7078958],"thread-7078538":["thread",7078538],"thread-7077509":["thread",7077509],"thread-7077184":["thread",7077184],"thread-7075138":["thread",7075138],"thread-7072332":["thread",7072332],"thread-7071526":["thread",7071526],"thread-7066677":["thread",7066677],"thread-7065018":["thread",7065018],"thread-7053825":["thread",7053825],"thread-7048118":["thread",7048118],"thread-7046408":["thread",7046408],"thread-7044704":["thread",7044704],"thread-7036107":["thread",7036107],"thread-7032285":["thread",7032285],"thread-7027214":["thread",7027214],"thread-7025914":["thread",7025914],"thread-7022821":["thread",7022821],"thread-7022814":["thread",7022814],"thread-7017618":["thread",7017618],"thread-7010302":["thread",7010302],"thread-7007651":["thread",7007651],"thread-7006399":["thread",7006399],"thread-7004761":["thread",7004761],"thread-7003826":["thread",7003826],"thread-7001559":["thread",7001559],"thread-6994151":["thread",6994151],"thread-6984357":["thread",6984357],"thread-6983649":["thread",6983649],"thread-6980614":["thread",6980614],"thread-6980346":["thread",6980346],"thread-6979971":["thread",6979971],"thread-6978037":["thread",6978037],"thread-6978030":["thread",6978030],"thread-6974663":["thread",6974663],"thread-6972308":["thread",6972308],"thread-6972205":["thread",6972205],"thread-6963714":["thread",6963714],"thread-6962288":["thread",6962288],"thread-6961302":["thread",6961302],"thread-6960787":["thread",6960787],"thread-6725295":["thread",6725295],"thread-6592076":["thread",6592076],"thread-6583128":["thread",6583128],"thread-6389243":["thread",6389243],"thread-6296934":["thread",6296934],"thread-236535":["thread",236535],"thread-200629":["thread",200629],"thread-12785":["thread",12785]}, NULL, 1714755586
Run Time: 0.000589
- 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