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 (7216686, 7214334, 7207319, 7204858, 7196616, 7188935, 7184094, 7182073, 7176849, 7174311, 7169509, 7159823, 7159310, 7152692, 7148794, 7143709, 7123066, 7106198, 7105214, 7086385, 7039296, 7039139, 7035180, 7029740, 7027507, 7015317, 7013930, 7010519, 7005157, 6998468, 6986113, 6976281, 6966383, 6958018, 6849152, 6841382, 6761793, 6656267, 6484137, 6383426, 6279873, 6266664, 6266315, 235624, 232551, 225360, 221844, 219781, 219768, 200631, 200535, 199500, 198697, 196840, 196481, 194188, 190600, 184564, 179294, 176759, 176546, 176107, 175646, 173644, 161854, 161853, 161770, 161397, 160917, 160432, 158044, 13377, 13241, 13190, 13143, 12932, 12674, 12531, 12192, 12109, 12078, 11561, 11455, 11298, 11150, 11014, 11007, 10824, 10798, 10770, 10617, 10613, 10573, 10505, 10368, 10091, 10046, 9966, 9930, 9878, 9794, 9623, 9439, 9367, 9354, 9342, 9145, 9033, 8960, 8918, 8904, 8640, 8634, 8479, 8369, 8367, 8201, 8151, 7945, 7715, 7696, 7605, 7558, 7488, 7294, 7264, 6949, 6931, 6871, 6842, 6822, 6803, 6760, 6632, 6574, 6525, 6488, 6402, 6309, 6051, 5814, 5782, 5732, 5626, 5587, 5547, 5436, 5396, 5367, 5365, 5139, 5011, 4567, 4509, 4475, 4420, 4248, 4215, 4155, 3910, 3837, 3733, 3716, 3711, 3609, 3602, 3516, 3435, 3372, 3112, 3078, 3069, 3008, 2989, 2982, 2972, 2964, 2830, 2827, 2791, 2773, 2687, 2658, 2609, 2605, 2466, 2311, 2070, 1864, 1771, 1524, 1487, 1467, 1405, 1334, 1294, 1019, 906, 882, 799))
Run Time: 0.009661
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: 117, 0, 1714642871, {"thread-7216686":["thread",7216686],"thread-7214334":["thread",7214334],"thread-7207319":["thread",7207319],"thread-7204858":["thread",7204858],"thread-7196616":["thread",7196616],"thread-7184094":["thread",7184094],"thread-7182073":["thread",7182073],"thread-7176849":["thread",7176849],"thread-7174311":["thread",7174311],"thread-7169509":["thread",7169509],"thread-7159823":["thread",7159823],"thread-7159310":["thread",7159310],"thread-7152692":["thread",7152692],"thread-7148794":["thread",7148794],"thread-7143709":["thread",7143709],"thread-7123066":["thread",7123066],"thread-7106198":["thread",7106198],"thread-7105214":["thread",7105214],"thread-7086385":["thread",7086385],"thread-7039296":["thread",7039296],"thread-7039139":["thread",7039139],"thread-7035180":["thread",7035180],"thread-7029740":["thread",7029740],"thread-7027507":["thread",7027507],"thread-7015317":["thread",7015317],"thread-7013930":["thread",7013930],"thread-7010519":["thread",7010519],"thread-7005157":["thread",7005157],"thread-6998468":["thread",6998468],"thread-6986113":["thread",6986113],"thread-6976281":["thread",6976281],"thread-6966383":["thread",6966383],"thread-6958018":["thread",6958018],"thread-6849152":["thread",6849152],"thread-6841382":["thread",6841382],"thread-6761793":["thread",6761793],"thread-6656267":["thread",6656267],"thread-6484137":["thread",6484137],"thread-6383426":["thread",6383426],"thread-6279873":["thread",6279873],"thread-6266664":["thread",6266664],"thread-6266315":["thread",6266315],"thread-235624":["thread",235624],"thread-232551":["thread",232551],"thread-225360":["thread",225360],"thread-221844":["thread",221844],"thread-219781":["thread",219781],"thread-200631":["thread",200631],"thread-200535":["thread",200535],"thread-199500":["thread",199500],"thread-198697":["thread",198697],"thread-196840":["thread",196840],"thread-196481":["thread",196481],"thread-194188":["thread",194188],"thread-190600":["thread",190600],"thread-184564":["thread",184564],"thread-179294":["thread",179294],"thread-176107":["thread",176107],"thread-175646":["thread",175646],"thread-173644":["thread",173644],"thread-161854":["thread",161854],"thread-161853":["thread",161853],"thread-161770":["thread",161770],"thread-161397":["thread",161397],"thread-160432":["thread",160432],"thread-158044":["thread",158044],"thread-13377":["thread",13377],"thread-13241":["thread",13241],"thread-13190":["thread",13190],"thread-13143":["thread",13143],"thread-12932":["thread",12932],"thread-12674":["thread",12674],"thread-12531":["thread",12531],"thread-12192":["thread",12192],"thread-12109":["thread",12109],"thread-12078":["thread",12078],"thread-11561":["thread",11561],"thread-11455":["thread",11455],"thread-11298":["thread",11298],"thread-11150":["thread",11150],"thread-11014":["thread",11014],"thread-11007":["thread",11007],"thread-10824":["thread",10824],"thread-10798":["thread",10798],"thread-10770":["thread",10770],"thread-10617":["thread",10617],"thread-10613":["thread",10613],"thread-10573":["thread",10573],"thread-10505":["thread",10505],"thread-10368":["thread",10368],"thread-10091":["thread",10091],"thread-10046":["thread",10046],"thread-9966":["thread",9966],"thread-9930":["thread",9930],"thread-9878":["thread",9878],"thread-9794":["thread",9794],"thread-9623":["thread",9623],"thread-9439":["thread",9439],"thread-9367":["thread",9367],"thread-9354":["thread",9354],"thread-9342":["thread",9342],"thread-9145":["thread",9145],"thread-9033":["thread",9033],"thread-8960":["thread",8960],"thread-8918":["thread",8918],"thread-8904":["thread",8904],"thread-8640":["thread",8640],"thread-8634":["thread",8634],"thread-8479":["thread",8479],"thread-8369":["thread",8369],"thread-8367":["thread",8367],"thread-8201":["thread",8201],"thread-8151":["thread",8151],"thread-7945":["thread",7945],"thread-7715":["thread",7715],"thread-7696":["thread",7696],"thread-7605":["thread",7605],"thread-7558":["thread",7558],"thread-7488":["thread",7488],"thread-7294":["thread",7294],"thread-7264":["thread",7264],"thread-6949":["thread",6949],"thread-6931":["thread",6931],"thread-6871":["thread",6871],"thread-6842":["thread",6842],"thread-6822":["thread",6822],"thread-6803":["thread",6803],"thread-6760":["thread",6760],"thread-6632":["thread",6632],"thread-6574":["thread",6574],"thread-6525":["thread",6525],"thread-6488":["thread",6488],"thread-6402":["thread",6402],"thread-6309":["thread",6309],"thread-6051":["thread",6051],"thread-5814":["thread",5814],"thread-5782":["thread",5782],"thread-5732":["thread",5732],"thread-5626":["thread",5626],"thread-5587":["thread",5587],"thread-5547":["thread",5547],"thread-5436":["thread",5436],"thread-5396":["thread",5396],"thread-5367":["thread",5367],"thread-5365":["thread",5365],"thread-5139":["thread",5139],"thread-5011":["thread",5011],"thread-4567":["thread",4567],"thread-4509":["thread",4509],"thread-4475":["thread",4475],"thread-4420":["thread",4420],"thread-4248":["thread",4248],"thread-4215":["thread",4215],"thread-4155":["thread",4155],"thread-3910":["thread",3910],"thread-3837":["thread",3837],"thread-3733":["thread",3733],"thread-3716":["thread",3716],"thread-3711":["thread",3711],"thread-3609":["thread",3609],"thread-3602":["thread",3602],"thread-3516":["thread",3516],"thread-3435":["thread",3435],"thread-3372":["thread",3372],"thread-3112":["thread",3112],"thread-3078":["thread",3078],"thread-3069":["thread",3069],"thread-3008":["thread",3008],"thread-2989":["thread",2989],"thread-2982":["thread",2982],"thread-2972":["thread",2972],"thread-2964":["thread",2964],"thread-2830":["thread",2830],"thread-2827":["thread",2827],"thread-2791":["thread",2791],"thread-2773":["thread",2773],"thread-2687":["thread",2687],"thread-2658":["thread",2658],"thread-2609":["thread",2609],"thread-2605":["thread",2605],"thread-2466":["thread",2466],"thread-2311":["thread",2311],"thread-2070":["thread",2070],"thread-1864":["thread",1864],"thread-1771":["thread",1771],"thread-1524":["thread",1524],"thread-1487":["thread",1487],"thread-1467":["thread",1467],"thread-1405":["thread",1405],"thread-1334":["thread",1334],"thread-1294":["thread",1294],"thread-1019":["thread",1019],"thread-906":["thread",906],"thread-882":["thread",882],"thread-799":["thread",799]}, NULL, 1714639271
Run Time: 0.000787
- 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