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 (182972, 181445, 181038, 180645, 180234, 179403, 179402, 179237, 177147, 177097, 176896, 176655, 176568, 176297, 175927, 175902, 175882, 175881, 175846, 175664, 175663, 175498, 175369, 175072, 173795, 173229, 172980, 172697, 172597, 172351, 171725, 171704, 171698, 171697, 171615, 171096, 170960, 170552, 170102, 170101, 169105, 167443, 166206, 166162, 165538, 164692, 164665, 164153, 162681, 162552, 161710, 161282, 160801, 160734, 160670, 158877, 158806, 158373, 157486, 157207, 157201, 157073, 156765, 156698, 156696, 156494, 156487, 156313, 155347, 154636, 154053, 153973, 153923, 153489, 152925, 151733, 123961, 103175, 99992, 70404))
Run Time: 0.053024
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 80 | 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
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 13454, 0, 1714394060, {"thread-182972":["thread",182972],"thread-181445":["thread",181445],"thread-181038":["thread",181038],"thread-180645":["thread",180645],"thread-180234":["thread",180234],"thread-179403":["thread",179403],"thread-179402":["thread",179402],"thread-179237":["thread",179237],"thread-177147":["thread",177147],"thread-177097":["thread",177097],"thread-176896":["thread",176896],"thread-176655":["thread",176655],"thread-176568":["thread",176568],"thread-176297":["thread",176297],"thread-175927":["thread",175927],"thread-175902":["thread",175902],"thread-175882":["thread",175882],"thread-175881":["thread",175881],"thread-175846":["thread",175846],"thread-175664":["thread",175664],"thread-175663":["thread",175663],"thread-175498":["thread",175498],"thread-175369":["thread",175369],"thread-175072":["thread",175072],"thread-173795":["thread",173795],"thread-173229":["thread",173229],"thread-172980":["thread",172980],"thread-172697":["thread",172697],"thread-172597":["thread",172597],"thread-172351":["thread",172351],"thread-171725":["thread",171725],"thread-171704":["thread",171704],"thread-171698":["thread",171698],"thread-171697":["thread",171697],"thread-171615":["thread",171615],"thread-171096":["thread",171096],"thread-170960":["thread",170960],"thread-170552":["thread",170552],"thread-170102":["thread",170102],"thread-170101":["thread",170101],"thread-169105":["thread",169105],"thread-167443":["thread",167443],"thread-166206":["thread",166206],"thread-166162":["thread",166162],"thread-165538":["thread",165538],"thread-164692":["thread",164692],"thread-164665":["thread",164665],"thread-164153":["thread",164153],"thread-162681":["thread",162681],"thread-162552":["thread",162552],"thread-161710":["thread",161710],"thread-161282":["thread",161282],"thread-160801":["thread",160801],"thread-160734":["thread",160734],"thread-160670":["thread",160670],"thread-158877":["thread",158877],"thread-158806":["thread",158806],"thread-158373":["thread",158373],"thread-157486":["thread",157486],"thread-157207":["thread",157207],"thread-157201":["thread",157201],"thread-157073":["thread",157073],"thread-156765":["thread",156765],"thread-156698":["thread",156698],"thread-156696":["thread",156696],"thread-156494":["thread",156494],"thread-156487":["thread",156487],"thread-156313":["thread",156313],"thread-155347":["thread",155347],"thread-154636":["thread",154636],"thread-154053":["thread",154053],"thread-153973":["thread",153973],"thread-153923":["thread",153923],"thread-153489":["thread",153489],"thread-152925":["thread",152925],"thread-151733":["thread",151733],"thread-123961":["thread",123961],"thread-103175":["thread",103175],"thread-99992":["thread",99992],"thread-70404":["thread",70404]}, , 1714390460
Run Time: 0.000435
- 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 1514
- 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