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 (7217131, 7216417, 7207652, 7205745, 7201899, 7197629, 7192035, 7189126, 7183540, 7180892, 7170529, 7156704, 7156148, 7155454, 7145576, 7144693, 7136932, 7132668, 7123913, 7119607, 7118412, 7111987, 7100286, 7090579, 7069316, 7064617, 7062892, 7061666, 7059984, 7055229, 7054510, 7050248, 7048871, 7024010, 7019271, 7014560, 7012837, 7010843, 7002890, 6993154, 6852912, 231101, 216837, 182842, 181461, 180709, 176461, 170568, 158497, 13644, 13582, 13459, 13304, 13183, 13166, 13062, 12976, 12933, 12898, 12804, 12724, 12672, 12376, 12340, 12202, 12058, 11917, 11859, 11856, 11721, 11660, 11571, 11463, 11462, 11106, 10827, 10754, 10676, 10605, 10598, 10412, 10370, 10305, 10226, 9839, 9786, 9640, 9619, 9381, 9348, 9306, 9252, 9084, 9074, 8715, 8652, 8480, 8458, 8386, 8304, 8248, 8197, 8096, 8094, 8021, 7914, 7793, 7771, 7727, 7717, 7629, 7595, 7551, 7513, 7248, 7205, 7186, 7067, 7029, 6976, 6932, 6761, 6678, 6450, 6377, 6095, 5991, 5935, 5861, 5652, 5635, 5560, 5549, 5548, 5544, 5480, 5409, 5373, 5328, 5320, 5287, 5270, 5002, 4934, 4882, 4838, 4826, 4813, 4760, 4759, 4724, 4493, 4468, 4457, 4393, 4358, 4257, 4174, 4106, 4083, 4027, 4012, 3987, 3786, 3782, 3749, 3727, 3722, 3685, 3640, 3586, 3477, 3454, 3436, 3412, 3237, 3129, 3127, 2944, 2859, 2843, 2801, 2624, 2370, 2267, 2261, 2203, 2147, 2077, 2034, 1854, 1820, 1765, 1659, 1629, 1502, 1485, 1450, 1288, 1201))
Run Time: 0.009891
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: 330, 0, 1715725241, {"thread-7217131":["thread",7217131],"thread-7216417":["thread",7216417],"thread-7207652":["thread",7207652],"thread-7205745":["thread",7205745],"thread-7201899":["thread",7201899],"thread-7197629":["thread",7197629],"thread-7192035":["thread",7192035],"thread-7189126":["thread",7189126],"thread-7183540":["thread",7183540],"thread-7180892":["thread",7180892],"thread-7170529":["thread",7170529],"thread-7156704":["thread",7156704],"thread-7156148":["thread",7156148],"thread-7155454":["thread",7155454],"thread-7145576":["thread",7145576],"thread-7144693":["thread",7144693],"thread-7136932":["thread",7136932],"thread-7132668":["thread",7132668],"thread-7123913":["thread",7123913],"thread-7119607":["thread",7119607],"thread-7118412":["thread",7118412],"thread-7111987":["thread",7111987],"thread-7100286":["thread",7100286],"thread-7090579":["thread",7090579],"thread-7069316":["thread",7069316],"thread-7064617":["thread",7064617],"thread-7062892":["thread",7062892],"thread-7061666":["thread",7061666],"thread-7059984":["thread",7059984],"thread-7055229":["thread",7055229],"thread-7054510":["thread",7054510],"thread-7050248":["thread",7050248],"thread-7048871":["thread",7048871],"thread-7024010":["thread",7024010],"thread-7019271":["thread",7019271],"thread-7014560":["thread",7014560],"thread-7012837":["thread",7012837],"thread-7010843":["thread",7010843],"thread-7002890":["thread",7002890],"thread-6993154":["thread",6993154],"thread-6852912":["thread",6852912],"thread-231101":["thread",231101],"thread-216837":["thread",216837],"thread-182842":["thread",182842],"thread-181461":["thread",181461],"thread-180709":["thread",180709],"thread-176461":["thread",176461],"thread-170568":["thread",170568],"thread-158497":["thread",158497],"thread-13644":["thread",13644],"thread-13582":["thread",13582],"thread-13459":["thread",13459],"thread-13304":["thread",13304],"thread-13183":["thread",13183],"thread-13166":["thread",13166],"thread-13062":["thread",13062],"thread-12976":["thread",12976],"thread-12933":["thread",12933],"thread-12898":["thread",12898],"thread-12804":["thread",12804],"thread-12724":["thread",12724],"thread-12672":["thread",12672],"thread-12376":["thread",12376],"thread-12340":["thread",12340],"thread-12202":["thread",12202],"thread-12058":["thread",12058],"thread-11917":["thread",11917],"thread-11859":["thread",11859],"thread-11856":["thread",11856],"thread-11721":["thread",11721],"thread-11660":["thread",11660],"thread-11571":["thread",11571],"thread-11463":["thread",11463],"thread-11462":["thread",11462],"thread-11106":["thread",11106],"thread-10827":["thread",10827],"thread-10754":["thread",10754],"thread-10676":["thread",10676],"thread-10605":["thread",10605],"thread-10598":["thread",10598],"thread-10412":["thread",10412],"thread-10370":["thread",10370],"thread-10305":["thread",10305],"thread-10226":["thread",10226],"thread-9839":["thread",9839],"thread-9786":["thread",9786],"thread-9640":["thread",9640],"thread-9619":["thread",9619],"thread-9381":["thread",9381],"thread-9348":["thread",9348],"thread-9306":["thread",9306],"thread-9252":["thread",9252],"thread-9084":["thread",9084],"thread-9074":["thread",9074],"thread-8715":["thread",8715],"thread-8652":["thread",8652],"thread-8480":["thread",8480],"thread-8458":["thread",8458],"thread-8386":["thread",8386],"thread-8304":["thread",8304],"thread-8248":["thread",8248],"thread-8197":["thread",8197],"thread-8096":["thread",8096],"thread-8094":["thread",8094],"thread-8021":["thread",8021],"thread-7914":["thread",7914],"thread-7793":["thread",7793],"thread-7771":["thread",7771],"thread-7727":["thread",7727],"thread-7717":["thread",7717],"thread-7629":["thread",7629],"thread-7595":["thread",7595],"thread-7551":["thread",7551],"thread-7513":["thread",7513],"thread-7248":["thread",7248],"thread-7205":["thread",7205],"thread-7186":["thread",7186],"thread-7067":["thread",7067],"thread-7029":["thread",7029],"thread-6976":["thread",6976],"thread-6932":["thread",6932],"thread-6761":["thread",6761],"thread-6678":["thread",6678],"thread-6450":["thread",6450],"thread-6377":["thread",6377],"thread-6095":["thread",6095],"thread-5991":["thread",5991],"thread-5935":["thread",5935],"thread-5861":["thread",5861],"thread-5652":["thread",5652],"thread-5635":["thread",5635],"thread-5560":["thread",5560],"thread-5549":["thread",5549],"thread-5548":["thread",5548],"thread-5544":["thread",5544],"thread-5480":["thread",5480],"thread-5409":["thread",5409],"thread-5373":["thread",5373],"thread-5328":["thread",5328],"thread-5320":["thread",5320],"thread-5287":["thread",5287],"thread-5270":["thread",5270],"thread-5002":["thread",5002],"thread-4934":["thread",4934],"thread-4882":["thread",4882],"thread-4838":["thread",4838],"thread-4826":["thread",4826],"thread-4813":["thread",4813],"thread-4760":["thread",4760],"thread-4759":["thread",4759],"thread-4724":["thread",4724],"thread-4493":["thread",4493],"thread-4468":["thread",4468],"thread-4457":["thread",4457],"thread-4393":["thread",4393],"thread-4358":["thread",4358],"thread-4257":["thread",4257],"thread-4174":["thread",4174],"thread-4106":["thread",4106],"thread-4083":["thread",4083],"thread-4027":["thread",4027],"thread-4012":["thread",4012],"thread-3987":["thread",3987],"thread-3786":["thread",3786],"thread-3782":["thread",3782],"thread-3749":["thread",3749],"thread-3727":["thread",3727],"thread-3722":["thread",3722],"thread-3685":["thread",3685],"thread-3640":["thread",3640],"thread-3586":["thread",3586],"thread-3477":["thread",3477],"thread-3454":["thread",3454],"thread-3436":["thread",3436],"thread-3412":["thread",3412],"thread-3237":["thread",3237],"thread-3129":["thread",3129],"thread-3127":["thread",3127],"thread-2944":["thread",2944],"thread-2859":["thread",2859],"thread-2843":["thread",2843],"thread-2801":["thread",2801],"thread-2624":["thread",2624],"thread-2370":["thread",2370],"thread-2267":["thread",2267],"thread-2261":["thread",2261],"thread-2203":["thread",2203],"thread-2147":["thread",2147],"thread-2077":["thread",2077],"thread-2034":["thread",2034],"thread-1854":["thread",1854],"thread-1820":["thread",1820],"thread-1765":["thread",1765],"thread-1659":["thread",1659],"thread-1629":["thread",1629],"thread-1502":["thread",1502],"thread-1485":["thread",1485],"thread-1450":["thread",1450],"thread-1288":["thread",1288],"thread-1201":["thread",1201]}, NULL, 1715721641
Run Time: 0.000565
- 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