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 (7215661, 7215177, 7215027, 7214420, 7213250, 7212413, 7211610, 7209273, 7207527, 7206044, 7205507, 7204617, 7203758, 7202798, 7200677, 7200549, 7199925, 7199923, 7198806, 7198412, 7198230, 7197726, 7196225, 7196189, 7195473, 7194546, 7194017, 7192736, 7191909, 7189583, 7188848, 7187223, 7185267, 7184529, 7184094, 7182903, 7180486, 7180196, 7179937, 7178919, 7178596, 7178369, 7177435, 7176689, 7175008, 7174645, 7174311, 7174148, 7172936, 7171615, 7169864, 7169174, 7168052, 7167426, 7167356, 7159497, 7152692, 7150778, 7150322, 7149390, 7149121, 7149119, 7149097, 7146176, 7146174, 7144692, 7142521, 7142232, 7141580, 7141575, 7138661, 7138222, 7133382, 7132760, 7131418, 7131397, 7131334, 7129892, 7126116, 7122711, 7122709, 7114523, 7113861, 7113736, 7113459, 7113190, 7108752, 7104014, 7103820, 7100589, 7100052, 7099969, 7099376, 7098304, 7097539, 7097000, 7095851, 7095213, 7092385, 7089944, 7087564, 7086900, 7086774, 7083347, 7081951, 7079722, 7074544, 7072620, 7071360, 7071276, 7070719, 7069733, 7066964, 7066785, 7066208, 7065660, 7065195, 7064617, 7063875, 7061727, 7061634, 7057857, 7057302, 7056449, 7051798, 7050522, 7050411, 7047920, 7047876, 7046542, 7043072, 7042548, 7041542, 7036431, 7032915, 7031229, 7029740, 7026979, 7025656, 7022821, 7022814, 7020269, 7015177, 7009764, 7008432, 7007407, 7002856, 6994281, 6993637, 6993566, 6991143, 6989469, 6989451, 6988165, 6985721, 6984015, 6982099, 6981795, 6981555, 6980944, 6980848, 6978633, 6977283, 6975817, 6975239, 6974513, 6972034, 6971460, 6970507, 6968450, 6964104, 6956066, 6868184, 6852936, 6849152, 6787583, 6763846, 6744300, 6732690, 6656267, 6649247, 6561893, 6507244, 6384557, 6360968, 6305335, 6295579, 241638, 236040, 233040, 229082, 228393, 228004, 219908, 216837, 210001, 203020, 201209, 199577))
Run Time: 0.009499
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 199 | 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: 123, 0, 1714643585, {"thread-7215661":["thread",7215661],"thread-7215177":["thread",7215177],"thread-7215027":["thread",7215027],"thread-7214420":["thread",7214420],"thread-7213250":["thread",7213250],"thread-7212413":["thread",7212413],"thread-7211610":["thread",7211610],"thread-7209273":["thread",7209273],"thread-7207527":["thread",7207527],"thread-7206044":["thread",7206044],"thread-7205507":["thread",7205507],"thread-7204617":["thread",7204617],"thread-7203758":["thread",7203758],"thread-7202798":["thread",7202798],"thread-7200677":["thread",7200677],"thread-7200549":["thread",7200549],"thread-7199925":["thread",7199925],"thread-7199923":["thread",7199923],"thread-7198806":["thread",7198806],"thread-7198412":["thread",7198412],"thread-7198230":["thread",7198230],"thread-7197726":["thread",7197726],"thread-7196225":["thread",7196225],"thread-7196189":["thread",7196189],"thread-7195473":["thread",7195473],"thread-7194546":["thread",7194546],"thread-7194017":["thread",7194017],"thread-7192736":["thread",7192736],"thread-7191909":["thread",7191909],"thread-7189583":["thread",7189583],"thread-7188848":["thread",7188848],"thread-7187223":["thread",7187223],"thread-7185267":["thread",7185267],"thread-7184529":["thread",7184529],"thread-7184094":["thread",7184094],"thread-7182903":["thread",7182903],"thread-7180486":["thread",7180486],"thread-7180196":["thread",7180196],"thread-7179937":["thread",7179937],"thread-7178919":["thread",7178919],"thread-7178596":["thread",7178596],"thread-7178369":["thread",7178369],"thread-7177435":["thread",7177435],"thread-7176689":["thread",7176689],"thread-7175008":["thread",7175008],"thread-7174645":["thread",7174645],"thread-7174311":["thread",7174311],"thread-7174148":["thread",7174148],"thread-7172936":["thread",7172936],"thread-7171615":["thread",7171615],"thread-7169864":["thread",7169864],"thread-7169174":["thread",7169174],"thread-7168052":["thread",7168052],"thread-7167426":["thread",7167426],"thread-7167356":["thread",7167356],"thread-7159497":["thread",7159497],"thread-7152692":["thread",7152692],"thread-7150778":["thread",7150778],"thread-7150322":["thread",7150322],"thread-7149390":["thread",7149390],"thread-7149121":["thread",7149121],"thread-7149119":["thread",7149119],"thread-7149097":["thread",7149097],"thread-7146176":["thread",7146176],"thread-7146174":["thread",7146174],"thread-7144692":["thread",7144692],"thread-7142521":["thread",7142521],"thread-7142232":["thread",7142232],"thread-7141580":["thread",7141580],"thread-7141575":["thread",7141575],"thread-7138661":["thread",7138661],"thread-7138222":["thread",7138222],"thread-7133382":["thread",7133382],"thread-7132760":["thread",7132760],"thread-7131418":["thread",7131418],"thread-7131397":["thread",7131397],"thread-7131334":["thread",7131334],"thread-7129892":["thread",7129892],"thread-7126116":["thread",7126116],"thread-7122711":["thread",7122711],"thread-7122709":["thread",7122709],"thread-7114523":["thread",7114523],"thread-7113861":["thread",7113861],"thread-7113736":["thread",7113736],"thread-7113459":["thread",7113459],"thread-7113190":["thread",7113190],"thread-7108752":["thread",7108752],"thread-7104014":["thread",7104014],"thread-7103820":["thread",7103820],"thread-7100589":["thread",7100589],"thread-7100052":["thread",7100052],"thread-7099969":["thread",7099969],"thread-7099376":["thread",7099376],"thread-7098304":["thread",7098304],"thread-7097539":["thread",7097539],"thread-7097000":["thread",7097000],"thread-7095851":["thread",7095851],"thread-7095213":["thread",7095213],"thread-7092385":["thread",7092385],"thread-7089944":["thread",7089944],"thread-7087564":["thread",7087564],"thread-7086900":["thread",7086900],"thread-7086774":["thread",7086774],"thread-7083347":["thread",7083347],"thread-7081951":["thread",7081951],"thread-7079722":["thread",7079722],"xfmg_media-3796":["xfmg_media",3796],"thread-7074544":["thread",7074544],"thread-7072620":["thread",7072620],"thread-7071360":["thread",7071360],"thread-7071276":["thread",7071276],"thread-7070719":["thread",7070719],"thread-7069733":["thread",7069733],"thread-7066964":["thread",7066964],"thread-7066785":["thread",7066785],"thread-7066208":["thread",7066208],"thread-7065660":["thread",7065660],"thread-7065195":["thread",7065195],"thread-7064617":["thread",7064617],"thread-7063875":["thread",7063875],"thread-7061727":["thread",7061727],"thread-7061634":["thread",7061634],"thread-7057857":["thread",7057857],"thread-7057302":["thread",7057302],"thread-7056449":["thread",7056449],"thread-7051798":["thread",7051798],"thread-7050522":["thread",7050522],"thread-7050411":["thread",7050411],"thread-7047920":["thread",7047920],"thread-7047876":["thread",7047876],"thread-7046542":["thread",7046542],"thread-7043072":["thread",7043072],"thread-7042548":["thread",7042548],"thread-7041542":["thread",7041542],"thread-7036431":["thread",7036431],"thread-7032915":["thread",7032915],"thread-7031229":["thread",7031229],"thread-7029740":["thread",7029740],"thread-7026979":["thread",7026979],"thread-7025656":["thread",7025656],"thread-7022821":["thread",7022821],"thread-7022814":["thread",7022814],"thread-7020269":["thread",7020269],"thread-7015177":["thread",7015177],"thread-7009764":["thread",7009764],"thread-7008432":["thread",7008432],"thread-7007407":["thread",7007407],"thread-7002856":["thread",7002856],"thread-6994281":["thread",6994281],"thread-6993637":["thread",6993637],"thread-6993566":["thread",6993566],"thread-6991143":["thread",6991143],"thread-6989469":["thread",6989469],"thread-6989451":["thread",6989451],"thread-6988165":["thread",6988165],"thread-6985721":["thread",6985721],"thread-6984015":["thread",6984015],"thread-6982099":["thread",6982099],"thread-6981795":["thread",6981795],"thread-6981555":["thread",6981555],"thread-6980944":["thread",6980944],"thread-6980848":["thread",6980848],"thread-6978633":["thread",6978633],"thread-6977283":["thread",6977283],"thread-6975817":["thread",6975817],"thread-6975239":["thread",6975239],"thread-6974513":["thread",6974513],"thread-6972034":["thread",6972034],"thread-6971460":["thread",6971460],"thread-6970507":["thread",6970507],"thread-6968450":["thread",6968450],"thread-6964104":["thread",6964104],"thread-6956066":["thread",6956066],"thread-6868184":["thread",6868184],"thread-6852936":["thread",6852936],"thread-6849152":["thread",6849152],"thread-6787583":["thread",6787583],"thread-6744300":["thread",6744300],"thread-6732690":["thread",6732690],"thread-6656267":["thread",6656267],"thread-6649247":["thread",6649247],"thread-6561893":["thread",6561893],"thread-6507244":["thread",6507244],"thread-6384557":["thread",6384557],"thread-6360968":["thread",6360968],"thread-6305335":["thread",6305335],"thread-6295579":["thread",6295579],"thread-241638":["thread",241638],"thread-236040":["thread",236040],"thread-233040":["thread",233040],"thread-229082":["thread",229082],"thread-228393":["thread",228393],"thread-228004":["thread",228004],"thread-219908":["thread",219908],"thread-216837":["thread",216837],"thread-210001":["thread",210001],"thread-203020":["thread",203020],"thread-201209":["thread",201209],"thread-199577":["thread",199577]}, NULL, 1714639985
Run Time: 0.000834
- 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