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 (7216895, 7216474, 7215751, 7215561, 7214584, 7214202, 7212914, 7212841, 7212756, 7212129, 7210924, 7209508, 7208819, 7207071, 7205251, 7205198, 7204040, 7202607, 7201658, 7201540, 7200595, 7198812, 7197403, 7197229, 7196224, 7194349, 7192908, 7192014, 7187921, 7187368, 7187346, 7187345, 7185217, 7184883, 7183863, 7183853, 7183838, 7183596, 7183015, 7182897, 7182396, 7182151, 7180976, 7177895, 7177398, 7176983, 7176496, 7175890, 7175838, 7174933, 7174399, 7174266, 7174201, 7173851, 7172177, 7171853, 7171808, 7171660, 7170124, 7169936, 7169710, 7168732, 7167117, 7166138, 7163978, 7162311, 7161418, 7160788, 7159919, 7159915, 7159838, 7159168, 7157125, 7156330, 7155912, 7155095, 7154958, 7153262, 7152833, 7152582, 7151764, 7151398, 7151249, 7150200, 7150107, 7149775, 7149679, 7149555, 7148903, 7147262, 7146020, 7144549, 7144015, 7144000, 7143162, 7142224, 7141637, 7139695, 7137753, 7137606, 7137599, 7137381, 7137379, 7136620, 7135177, 7132573, 7131942, 7129255, 7128252, 7127041, 7126116, 7125514, 7125055, 7124100, 7120063, 7119940, 7117211, 7114735, 7114595, 7114571, 7112557, 7111834, 7111136, 7109586, 7108942, 7108667, 7107385, 7104288, 7103808, 7103655, 7103223, 7103005, 7102978, 7102971, 7099549, 7098247, 7097918, 7096561, 7096203, 7095529, 7093441, 7091231, 7089447, 7089059, 7089035, 7088162, 7087090, 7086437, 7086424, 7086174, 7085072, 7084503, 7083526, 7081051, 7078538, 7061135, 7059072, 7058195, 7058007, 7057154, 7056451, 7055658, 7054824, 7054499, 7054056, 7053571, 7052749, 7050495, 7050209, 7048862, 7047696, 7047550, 7046907, 7046065, 7045961, 7045584, 7043578, 7040469, 7037715, 7036002, 7034952, 7032890, 7029353, 7021743, 7021579, 7021425, 7020055, 7016671, 7016479, 7013575, 7010727, 7006909, 7005747, 6999819, 6999592, 6994634, 6994276, 6993347, 6990977, 6989062))
Run Time: 0.009937
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: 1744, 0, 1714805138, {"thread-7216895":["thread",7216895],"thread-7216474":["thread",7216474],"thread-7215751":["thread",7215751],"thread-7215561":["thread",7215561],"thread-7214584":["thread",7214584],"thread-7214202":["thread",7214202],"thread-7212914":["thread",7212914],"thread-7212841":["thread",7212841],"thread-7212756":["thread",7212756],"thread-7212129":["thread",7212129],"thread-7210924":["thread",7210924],"thread-7209508":["thread",7209508],"thread-7208819":["thread",7208819],"thread-7207071":["thread",7207071],"thread-7205251":["thread",7205251],"thread-7205198":["thread",7205198],"thread-7204040":["thread",7204040],"thread-7202607":["thread",7202607],"thread-7201658":["thread",7201658],"thread-7201540":["thread",7201540],"thread-7200595":["thread",7200595],"thread-7198812":["thread",7198812],"thread-7197403":["thread",7197403],"thread-7197229":["thread",7197229],"thread-7196224":["thread",7196224],"thread-7194349":["thread",7194349],"thread-7192908":["thread",7192908],"thread-7192014":["thread",7192014],"thread-7187921":["thread",7187921],"thread-7187368":["thread",7187368],"thread-7187346":["thread",7187346],"thread-7187345":["thread",7187345],"thread-7185217":["thread",7185217],"thread-7184883":["thread",7184883],"thread-7183863":["thread",7183863],"thread-7183853":["thread",7183853],"thread-7183838":["thread",7183838],"thread-7183596":["thread",7183596],"thread-7183015":["thread",7183015],"thread-7182897":["thread",7182897],"thread-7182396":["thread",7182396],"thread-7182151":["thread",7182151],"thread-7180976":["thread",7180976],"thread-7177895":["thread",7177895],"thread-7177398":["thread",7177398],"thread-7176983":["thread",7176983],"thread-7176496":["thread",7176496],"thread-7175890":["thread",7175890],"thread-7175838":["thread",7175838],"thread-7174933":["thread",7174933],"thread-7174399":["thread",7174399],"thread-7174266":["thread",7174266],"thread-7174201":["thread",7174201],"thread-7173851":["thread",7173851],"thread-7172177":["thread",7172177],"thread-7171853":["thread",7171853],"thread-7171808":["thread",7171808],"thread-7171660":["thread",7171660],"thread-7170124":["thread",7170124],"thread-7169936":["thread",7169936],"thread-7169710":["thread",7169710],"thread-7168732":["thread",7168732],"thread-7167117":["thread",7167117],"thread-7166138":["thread",7166138],"thread-7163978":["thread",7163978],"thread-7162311":["thread",7162311],"thread-7161418":["thread",7161418],"thread-7160788":["thread",7160788],"thread-7159919":["thread",7159919],"thread-7159915":["thread",7159915],"thread-7159838":["thread",7159838],"thread-7159168":["thread",7159168],"thread-7157125":["thread",7157125],"thread-7156330":["thread",7156330],"thread-7155912":["thread",7155912],"thread-7155095":["thread",7155095],"thread-7154958":["thread",7154958],"thread-7153262":["thread",7153262],"thread-7152833":["thread",7152833],"thread-7152582":["thread",7152582],"thread-7151764":["thread",7151764],"thread-7151398":["thread",7151398],"thread-7151249":["thread",7151249],"thread-7150200":["thread",7150200],"thread-7150107":["thread",7150107],"thread-7149775":["thread",7149775],"thread-7149679":["thread",7149679],"thread-7149555":["thread",7149555],"thread-7148903":["thread",7148903],"thread-7147262":["thread",7147262],"thread-7146020":["thread",7146020],"thread-7144549":["thread",7144549],"thread-7144015":["thread",7144015],"thread-7144000":["thread",7144000],"thread-7143162":["thread",7143162],"thread-7142224":["thread",7142224],"thread-7141637":["thread",7141637],"thread-7139695":["thread",7139695],"thread-7137753":["thread",7137753],"thread-7137606":["thread",7137606],"thread-7137599":["thread",7137599],"thread-7137381":["thread",7137381],"thread-7137379":["thread",7137379],"thread-7136620":["thread",7136620],"thread-7135177":["thread",7135177],"thread-7132573":["thread",7132573],"thread-7131942":["thread",7131942],"thread-7129255":["thread",7129255],"thread-7128252":["thread",7128252],"thread-7127041":["thread",7127041],"thread-7126116":["thread",7126116],"thread-7125514":["thread",7125514],"thread-7125055":["thread",7125055],"thread-7124100":["thread",7124100],"thread-7120063":["thread",7120063],"thread-7119940":["thread",7119940],"thread-7117211":["thread",7117211],"thread-7114735":["thread",7114735],"thread-7114595":["thread",7114595],"thread-7114571":["thread",7114571],"thread-7112557":["thread",7112557],"thread-7111834":["thread",7111834],"thread-7111136":["thread",7111136],"thread-7109586":["thread",7109586],"thread-7108942":["thread",7108942],"thread-7108667":["thread",7108667],"thread-7107385":["thread",7107385],"thread-7104288":["thread",7104288],"thread-7103808":["thread",7103808],"thread-7103655":["thread",7103655],"thread-7103223":["thread",7103223],"thread-7103005":["thread",7103005],"thread-7102978":["thread",7102978],"thread-7102971":["thread",7102971],"thread-7099549":["thread",7099549],"thread-7098247":["thread",7098247],"thread-7097918":["thread",7097918],"thread-7096561":["thread",7096561],"thread-7096203":["thread",7096203],"thread-7095529":["thread",7095529],"thread-7093441":["thread",7093441],"thread-7091231":["thread",7091231],"thread-7089447":["thread",7089447],"thread-7089059":["thread",7089059],"thread-7089035":["thread",7089035],"thread-7088162":["thread",7088162],"thread-7087090":["thread",7087090],"thread-7086437":["thread",7086437],"thread-7086424":["thread",7086424],"thread-7086174":["thread",7086174],"thread-7085072":["thread",7085072],"thread-7084503":["thread",7084503],"thread-7083526":["thread",7083526],"thread-7081051":["thread",7081051],"thread-7078538":["thread",7078538],"thread-7061135":["thread",7061135],"thread-7059072":["thread",7059072],"thread-7058195":["thread",7058195],"thread-7058007":["thread",7058007],"thread-7057154":["thread",7057154],"thread-7056451":["thread",7056451],"thread-7055658":["thread",7055658],"thread-7054824":["thread",7054824],"thread-7054499":["thread",7054499],"thread-7054056":["thread",7054056],"thread-7053571":["thread",7053571],"thread-7052749":["thread",7052749],"thread-7050495":["thread",7050495],"thread-7050209":["thread",7050209],"thread-7048862":["thread",7048862],"thread-7047696":["thread",7047696],"thread-7047550":["thread",7047550],"thread-7046907":["thread",7046907],"thread-7046065":["thread",7046065],"thread-7045961":["thread",7045961],"thread-7045584":["thread",7045584],"thread-7043578":["thread",7043578],"thread-7040469":["thread",7040469],"thread-7037715":["thread",7037715],"thread-7036002":["thread",7036002],"thread-7034952":["thread",7034952],"thread-7032890":["thread",7032890],"thread-7029353":["thread",7029353],"thread-7021743":["thread",7021743],"thread-7021579":["thread",7021579],"thread-7021425":["thread",7021425],"thread-7020055":["thread",7020055],"thread-7016671":["thread",7016671],"thread-7016479":["thread",7016479],"thread-7013575":["thread",7013575],"thread-7010727":["thread",7010727],"thread-7006909":["thread",7006909],"thread-7005747":["thread",7005747],"thread-6999819":["thread",6999819],"thread-6999592":["thread",6999592],"thread-6994634":["thread",6994634],"thread-6994276":["thread",6994276],"thread-6993347":["thread",6993347],"thread-6990977":["thread",6990977],"thread-6989062":["thread",6989062]}, NULL, 1714801538
Run Time: 0.000712
- 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