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 (183545, 182541, 182440, 181779, 181467, 181140, 181087, 180865, 180684, 180117, 180063, 180062, 180058, 179877, 179875, 179843, 179194, 179193, 179047, 178934, 178549, 178204, 177065, 177022, 175618, 174935, 174924, 174871, 173907, 173903, 173814, 173170, 172582, 172581, 172484, 172379, 170127, 168896, 168723, 168716, 168650, 168256, 168171, 167947, 167641, 166924, 166903, 166816, 165897, 164284, 164081, 163116, 162927, 162014, 161990, 161353, 161216, 161021, 161019, 161015, 160917, 160914, 160888, 160798, 160796, 160794, 160792, 160185, 159588, 159475, 159474, 159472, 159470, 159415, 159305, 159199, 159166, 159067, 158929, 158866, 158680, 158369, 158269, 157884, 157657, 157036, 157012, 156709, 156656, 156539, 155845, 155841, 155681, 155645, 155406, 155400, 154841, 154692, 154440, 154437, 154435, 154339, 154134, 154058, 153669, 153668, 153666, 153664, 153586, 153504, 153059, 152918, 152557, 152224, 152189, 152188, 152090, 138072, 133175, 130676, 130665, 127431, 123466, 117058, 112019, 111968, 109880, 91255, 90700, 89080, 79192, 75948, 64843, 64394, 61294, 51388, 48043, 45923, 29637, 19160, 8384, 8379))
Run Time: 0.116991
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 142 | 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: 2592, 0, 1715935445, {"thread-183545":["thread",183545],"thread-182541":["thread",182541],"thread-182440":["thread",182440],"thread-181779":["thread",181779],"thread-181467":["thread",181467],"thread-181140":["thread",181140],"thread-181087":["thread",181087],"thread-180865":["thread",180865],"thread-180684":["thread",180684],"thread-180117":["thread",180117],"thread-180063":["thread",180063],"thread-180062":["thread",180062],"thread-180058":["thread",180058],"thread-179877":["thread",179877],"thread-179875":["thread",179875],"thread-179843":["thread",179843],"thread-179194":["thread",179194],"thread-179193":["thread",179193],"thread-179047":["thread",179047],"thread-178934":["thread",178934],"thread-178549":["thread",178549],"thread-178204":["thread",178204],"thread-177065":["thread",177065],"thread-177022":["thread",177022],"thread-175618":["thread",175618],"thread-174935":["thread",174935],"thread-174924":["thread",174924],"thread-174871":["thread",174871],"thread-173907":["thread",173907],"thread-173903":["thread",173903],"thread-173814":["thread",173814],"thread-173170":["thread",173170],"thread-172582":["thread",172582],"thread-172581":["thread",172581],"thread-172484":["thread",172484],"thread-172379":["thread",172379],"thread-170127":["thread",170127],"thread-168896":["thread",168896],"thread-168723":["thread",168723],"thread-168716":["thread",168716],"thread-168650":["thread",168650],"thread-168256":["thread",168256],"thread-168171":["thread",168171],"thread-167947":["thread",167947],"thread-167641":["thread",167641],"thread-166924":["thread",166924],"thread-166903":["thread",166903],"thread-166816":["thread",166816],"thread-165897":["thread",165897],"thread-164284":["thread",164284],"thread-164081":["thread",164081],"thread-163116":["thread",163116],"thread-162927":["thread",162927],"thread-162014":["thread",162014],"thread-161990":["thread",161990],"thread-161353":["thread",161353],"thread-161216":["thread",161216],"thread-161021":["thread",161021],"thread-161019":["thread",161019],"thread-161015":["thread",161015],"thread-160917":["thread",160917],"thread-160914":["thread",160914],"thread-160888":["thread",160888],"thread-160798":["thread",160798],"thread-160796":["thread",160796],"thread-160794":["thread",160794],"thread-160792":["thread",160792],"thread-160185":["thread",160185],"thread-159588":["thread",159588],"thread-159475":["thread",159475],"thread-159474":["thread",159474],"thread-159472":["thread",159472],"thread-159470":["thread",159470],"thread-159415":["thread",159415],"thread-159305":["thread",159305],"thread-159199":["thread",159199],"thread-159166":["thread",159166],"thread-159067":["thread",159067],"thread-158929":["thread",158929],"thread-158866":["thread",158866],"thread-158680":["thread",158680],"thread-158369":["thread",158369],"thread-158269":["thread",158269],"thread-157884":["thread",157884],"thread-157657":["thread",157657],"thread-157036":["thread",157036],"thread-157012":["thread",157012],"thread-156709":["thread",156709],"thread-156656":["thread",156656],"thread-156539":["thread",156539],"thread-155845":["thread",155845],"thread-155841":["thread",155841],"thread-155681":["thread",155681],"thread-155645":["thread",155645],"thread-155406":["thread",155406],"thread-155400":["thread",155400],"thread-154841":["thread",154841],"thread-154692":["thread",154692],"thread-154440":["thread",154440],"thread-154437":["thread",154437],"thread-154435":["thread",154435],"thread-154339":["thread",154339],"thread-154134":["thread",154134],"thread-154058":["thread",154058],"thread-153669":["thread",153669],"thread-153668":["thread",153668],"thread-153666":["thread",153666],"thread-153664":["thread",153664],"thread-153586":["thread",153586],"thread-153504":["thread",153504],"thread-153059":["thread",153059],"thread-152918":["thread",152918],"thread-152557":["thread",152557],"thread-152224":["thread",152224],"thread-152189":["thread",152189],"thread-152188":["thread",152188],"thread-152090":["thread",152090],"thread-138072":["thread",138072],"thread-133175":["thread",133175],"thread-130676":["thread",130676],"thread-130665":["thread",130665],"thread-127431":["thread",127431],"thread-123466":["thread",123466],"thread-117058":["thread",117058],"thread-112019":["thread",112019],"thread-111968":["thread",111968],"thread-109880":["thread",109880],"thread-91255":["thread",91255],"thread-90700":["thread",90700],"thread-89080":["thread",89080],"thread-79192":["thread",79192],"thread-75948":["thread",75948],"thread-64843":["thread",64843],"thread-64394":["thread",64394],"thread-61294":["thread",61294],"thread-51388":["thread",51388],"thread-48043":["thread",48043],"thread-45923":["thread",45923],"thread-29637":["thread",29637],"thread-19160":["thread",19160],"thread-8384":["thread",8384],"thread-8379":["thread",8379]}, , 1715931845
Run Time: 0.000230
- 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