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 (44990, 43334, 43134, 42945, 42854, 42171, 42125, 41998, 41646, 41404, 40856, 40179, 39532, 38780, 38728, 38634, 38581, 38035, 37680, 37609, 37286, 37133, 36539, 36505, 36329, 36316, 36227, 35385, 33070, 32386, 32178, 31543, 30870, 29337, 29192, 28855, 28336, 28246, 28171, 27146, 26918, 26175, 26145, 26044, 25469, 23644, 23429, 21153, 20040, 18659, 18099, 17837, 17562, 17303, 16167, 11590, 11589, 11588, 11586, 11585, 11584, 11583, 11582, 11581, 11580, 11579, 11578, 11577, 11576, 11575, 11574, 11530, 11529, 11526, 11525, 11524, 11369, 11368, 11367, 11354, 11353, 11352, 11351, 11350, 11348, 11347, 11346, 11345, 11344, 11343, 11342, 11340, 11246, 11245, 11244, 11237, 10382, 9875, 6423, 4513, 4500, 3879, 2953, 1176, 1009, 100, 5))
Run Time: 0.047391
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 107 | 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: 61, 0, 1716214514, {"thread-44990":["thread",44990],"thread-43334":["thread",43334],"thread-42945":["thread",42945],"thread-42854":["thread",42854],"thread-42171":["thread",42171],"thread-42125":["thread",42125],"thread-41646":["thread",41646],"thread-41404":["thread",41404],"thread-40856":["thread",40856],"thread-38780":["thread",38780],"thread-38634":["thread",38634],"thread-38581":["thread",38581],"thread-38035":["thread",38035],"thread-37680":["thread",37680],"thread-37609":["thread",37609],"thread-37133":["thread",37133],"thread-36539":["thread",36539],"thread-36505":["thread",36505],"thread-36329":["thread",36329],"thread-36316":["thread",36316],"thread-36227":["thread",36227],"thread-35385":["thread",35385],"thread-33070":["thread",33070],"thread-32178":["thread",32178],"thread-31543":["thread",31543],"thread-30870":["thread",30870],"thread-29337":["thread",29337],"thread-29192":["thread",29192],"thread-28855":["thread",28855],"thread-28336":["thread",28336],"thread-28246":["thread",28246],"thread-28171":["thread",28171],"thread-27146":["thread",27146],"thread-26918":["thread",26918],"thread-26175":["thread",26175],"thread-26145":["thread",26145],"thread-25469":["thread",25469],"thread-23429":["thread",23429],"thread-21153":["thread",21153],"thread-20040":["thread",20040],"thread-18099":["thread",18099],"thread-17837":["thread",17837],"thread-17303":["thread",17303],"thread-16167":["thread",16167],"thread-11590":["thread",11590],"thread-11589":["thread",11589],"thread-11588":["thread",11588],"thread-11586":["thread",11586],"thread-11585":["thread",11585],"thread-11584":["thread",11584],"thread-11583":["thread",11583],"thread-11582":["thread",11582],"thread-11581":["thread",11581],"thread-11580":["thread",11580],"thread-11579":["thread",11579],"thread-11578":["thread",11578],"thread-11577":["thread",11577],"thread-11576":["thread",11576],"thread-11575":["thread",11575],"thread-11574":["thread",11574],"thread-11530":["thread",11530],"thread-11529":["thread",11529],"thread-11526":["thread",11526],"thread-11525":["thread",11525],"thread-11524":["thread",11524],"thread-11369":["thread",11369],"thread-11368":["thread",11368],"thread-11367":["thread",11367],"thread-11354":["thread",11354],"thread-11353":["thread",11353],"thread-11352":["thread",11352],"thread-11351":["thread",11351],"thread-11350":["thread",11350],"thread-11348":["thread",11348],"thread-11347":["thread",11347],"thread-11346":["thread",11346],"thread-11345":["thread",11345],"thread-11344":["thread",11344],"thread-11343":["thread",11343],"thread-11342":["thread",11342],"thread-11340":["thread",11340],"thread-11246":["thread",11246],"thread-11245":["thread",11245],"thread-11244":["thread",11244],"thread-11237":["thread",11237],"thread-10382":["thread",10382],"thread-9875":["thread",9875],"thread-6423":["thread",6423],"thread-4513":["thread",4513],"thread-4500":["thread",4500],"thread-3879":["thread",3879],"thread-2953":["thread",2953],"thread-1009":["thread",1009],"thread-100":["thread",100],"thread-5":["thread",5]}, NULL, 1716210914
Run Time: 0.001483
- 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