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 (184081, 183701, 183108, 182963, 182502, 182265, 181982, 181237, 180673, 179267, 178969, 178705, 177660, 177659, 177426, 176309, 176232, 175742, 175429, 175225, 175169, 175112, 175109, 175086, 174614, 174303, 173884, 173766, 173699, 172973, 172074, 171956, 171942, 170537, 170289, 169406, 168715, 168675, 168509, 168156, 167923, 166954, 164864, 164764, 164742, 163732, 163503, 163311, 162511, 161743, 161213, 160490, 160328, 160260, 159615, 159396, 159235, 159227, 158641, 158016, 155647, 155081, 154533, 152536, 152529, 151964, 146152, 143090, 133648, 122965, 122452, 118484, 118258, 114226, 105929, 105926, 105036, 103981, 103783, 96559, 94030, 93968, 93379, 92841, 77687, 75130, 72211, 53199, 52898, 52120, 34883, 11032, 8904, 2408))
Run Time: 0.043745
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 94 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 1387
- 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 2729
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
UPDATE `xf_tag_result_cache` SET `expiry_date` = ?, `results` = ? WHERE `result_cache_id` = 825660
Params: 1717267691, {"thread-184081":["thread",184081],"thread-183701":["thread",183701],"thread-183108":["thread",183108],"thread-182963":["thread",182963],"thread-182502":["thread",182502],"thread-182265":["thread",182265],"thread-181982":["thread",181982],"thread-181237":["thread",181237],"thread-180673":["thread",180673],"thread-179267":["thread",179267],"thread-178969":["thread",178969],"thread-178705":["thread",178705],"thread-177660":["thread",177660],"thread-177659":["thread",177659],"thread-177426":["thread",177426],"thread-176309":["thread",176309],"thread-176232":["thread",176232],"thread-175742":["thread",175742],"thread-175429":["thread",175429],"thread-175225":["thread",175225],"thread-175169":["thread",175169],"thread-175112":["thread",175112],"thread-175109":["thread",175109],"thread-175086":["thread",175086],"thread-174614":["thread",174614],"thread-174303":["thread",174303],"thread-173884":["thread",173884],"thread-173766":["thread",173766],"thread-173699":["thread",173699],"thread-172973":["thread",172973],"thread-172074":["thread",172074],"thread-171956":["thread",171956],"thread-171942":["thread",171942],"thread-170537":["thread",170537],"thread-170289":["thread",170289],"thread-169406":["thread",169406],"thread-168715":["thread",168715],"thread-168675":["thread",168675],"thread-168509":["thread",168509],"thread-168156":["thread",168156],"thread-167923":["thread",167923],"thread-166954":["thread",166954],"thread-164864":["thread",164864],"thread-164764":["thread",164764],"thread-164742":["thread",164742],"thread-163732":["thread",163732],"thread-163503":["thread",163503],"thread-163311":["thread",163311],"thread-162511":["thread",162511],"thread-161743":["thread",161743],"thread-161213":["thread",161213],"thread-160490":["thread",160490],"thread-160328":["thread",160328],"thread-160260":["thread",160260],"thread-159615":["thread",159615],"thread-159396":["thread",159396],"thread-159235":["thread",159235],"thread-159227":["thread",159227],"thread-158641":["thread",158641],"thread-158016":["thread",158016],"thread-155647":["thread",155647],"thread-155081":["thread",155081],"thread-154533":["thread",154533],"thread-152536":["thread",152536],"thread-152529":["thread",152529],"thread-151964":["thread",151964],"thread-146152":["thread",146152],"thread-143090":["thread",143090],"thread-133648":["thread",133648],"thread-122965":["thread",122965],"thread-122452":["thread",122452],"thread-118484":["thread",118484],"thread-118258":["thread",118258],"thread-114226":["thread",114226],"thread-105929":["thread",105929],"thread-105926":["thread",105926],"thread-105036":["thread",105036],"thread-103981":["thread",103981],"thread-103783":["thread",103783],"thread-96559":["thread",96559],"thread-94030":["thread",94030],"thread-93968":["thread",93968],"thread-93379":["thread",93379],"thread-92841":["thread",92841],"thread-77687":["thread",77687],"thread-75130":["thread",75130],"thread-72211":["thread",72211],"thread-53199":["thread",53199],"thread-52898":["thread",52898],"thread-52120":["thread",52120],"thread-34883":["thread",34883],"thread-11032":["thread",11032],"thread-8904":["thread",8904],"thread-2408":["thread",2408]}
Run Time: 0.000291
- 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 324
- XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1519
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20