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 (45084, 45029, 45021, 45005, 44991, 44877, 43390, 42846, 42833, 42801, 42795, 42631, 42527, 42345, 41937, 41908, 41612, 41542, 41420, 40991, 40710, 40234, 39113, 38347, 37563, 37024, 36965, 34981, 34854, 34571, 34069, 33852, 33638, 33276, 32889, 32621, 32574, 32419, 32274, 31911, 31172, 30050, 29928, 29797, 29559, 29265, 29231, 29132, 28955, 28767, 28484, 28119, 28044, 28043, 27933, 27567, 27496, 27448, 27358, 27152, 26897, 26799, 25880, 25620, 25602, 25527, 24647, 24129, 24025, 23835, 23578, 22949, 22270, 22116, 21435, 20948, 20313, 19983, 19775, 19317, 19163, 19018, 18894, 18762, 18180, 17420, 17157, 17141, 17029, 16396, 16331, 15612, 15298, 15192, 14729, 14219, 14102, 11489, 11105, 10948, 10905, 7853, 7840, 7380, 7077, 6937, 8659, 5821, 8632, 8630, 3721, 3706, 3173, 3094, 2184, 2061, 1484, 1000, 821, 395, 95, 25))
Run Time: 0.057448
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 122 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,squattheplanet.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 2866
- 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 137
- 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 2483
- 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: 65, 0, 1714531998, {"thread-45084":["thread",45084],"thread-45029":["thread",45029],"thread-45021":["thread",45021],"thread-45005":["thread",45005],"thread-44991":["thread",44991],"thread-44877":["thread",44877],"thread-43390":["thread",43390],"thread-42846":["thread",42846],"thread-42833":["thread",42833],"thread-42801":["thread",42801],"thread-42795":["thread",42795],"thread-42631":["thread",42631],"thread-42527":["thread",42527],"thread-42345":["thread",42345],"thread-41937":["thread",41937],"thread-41908":["thread",41908],"thread-41612":["thread",41612],"thread-41542":["thread",41542],"thread-41420":["thread",41420],"thread-40991":["thread",40991],"thread-40710":["thread",40710],"thread-40234":["thread",40234],"thread-39113":["thread",39113],"thread-38347":["thread",38347],"thread-37563":["thread",37563],"thread-37024":["thread",37024],"thread-34981":["thread",34981],"thread-34854":["thread",34854],"thread-34571":["thread",34571],"thread-34069":["thread",34069],"thread-33852":["thread",33852],"thread-33638":["thread",33638],"thread-33276":["thread",33276],"thread-32889":["thread",32889],"thread-32621":["thread",32621],"thread-32574":["thread",32574],"thread-32419":["thread",32419],"thread-32274":["thread",32274],"thread-31911":["thread",31911],"thread-31172":["thread",31172],"thread-30050":["thread",30050],"thread-29928":["thread",29928],"thread-29797":["thread",29797],"thread-29559":["thread",29559],"thread-29265":["thread",29265],"thread-29231":["thread",29231],"thread-29132":["thread",29132],"thread-28955":["thread",28955],"thread-28767":["thread",28767],"thread-28484":["thread",28484],"thread-28119":["thread",28119],"thread-28044":["thread",28044],"thread-28043":["thread",28043],"thread-27933":["thread",27933],"thread-27567":["thread",27567],"thread-27358":["thread",27358],"thread-27152":["thread",27152],"thread-26897":["thread",26897],"thread-26799":["thread",26799],"thread-25880":["thread",25880],"thread-25620":["thread",25620],"thread-25602":["thread",25602],"thread-25527":["thread",25527],"thread-24647":["thread",24647],"thread-24129":["thread",24129],"thread-24025":["thread",24025],"thread-23835":["thread",23835],"thread-23578":["thread",23578],"thread-22949":["thread",22949],"thread-22270":["thread",22270],"thread-22116":["thread",22116],"thread-21435":["thread",21435],"thread-20948":["thread",20948],"thread-20313":["thread",20313],"thread-19983":["thread",19983],"thread-19775":["thread",19775],"thread-19317":["thread",19317],"thread-19163":["thread",19163],"thread-19018":["thread",19018],"thread-18894":["thread",18894],"thread-18762":["thread",18762],"thread-18180":["thread",18180],"thread-17420":["thread",17420],"thread-17157":["thread",17157],"thread-17141":["thread",17141],"thread-17029":["thread",17029],"thread-16396":["thread",16396],"thread-16331":["thread",16331],"thread-15612":["thread",15612],"thread-15298":["thread",15298],"thread-15192":["thread",15192],"thread-14729":["thread",14729],"thread-14219":["thread",14219],"thread-14102":["thread",14102],"thread-11489":["thread",11489],"thread-11105":["thread",11105],"thread-10948":["thread",10948],"thread-10905":["thread",10905],"thread-7853":["thread",7853],"thread-7840":["thread",7840],"thread-7380":["thread",7380],"thread-7077":["thread",7077],"thread-6937":["thread",6937],"thread-8659":["thread",8659],"thread-5821":["thread",5821],"thread-8632":["thread",8632],"thread-8630":["thread",8630],"thread-3721":["thread",3721],"thread-3706":["thread",3706],"thread-3173":["thread",3173],"thread-3094":["thread",3094],"thread-2184":["thread",2184],"thread-2061":["thread",2061],"thread-1484":["thread",1484],"thread-821":["thread",821],"thread-395":["thread",395],"thread-95":["thread",95],"thread-25":["thread",25]}, NULL, 1714528398
Run Time: 0.002148
- 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 150
- 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 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20