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 (183168, 182976, 182959, 182795, 182244, 182152, 181666, 181038, 180896, 180878, 180776, 180745, 180243, 179601, 179508, 179408, 178395, 178045, 177846, 177797, 177710, 176885, 176681, 176540, 176447, 176099, 175867, 175841, 175584, 175418, 174936, 174867, 174700, 174596, 174093, 173923, 173918, 173890, 172027, 170981, 170178, 168749, 168710, 166317, 166150, 164720, 164715, 164592, 163955, 162149, 161532, 160886, 160673, 160518, 159675, 159532, 159386, 158972, 158518, 157883, 157085, 156555, 156032, 155020, 154405, 154268, 152021, 151918, 130732, 130360, 117109, 117060, 116612, 102306, 41542, 33943, 33068, 27915, 25419))
Run Time: 0.042795
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 79 | 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: 3300, 0, 1715917496, {"thread-183168":["thread",183168],"thread-182976":["thread",182976],"thread-182959":["thread",182959],"thread-182795":["thread",182795],"thread-182244":["thread",182244],"thread-182152":["thread",182152],"thread-181666":["thread",181666],"thread-181038":["thread",181038],"thread-180896":["thread",180896],"thread-180878":["thread",180878],"thread-180776":["thread",180776],"thread-180745":["thread",180745],"thread-180243":["thread",180243],"thread-179601":["thread",179601],"thread-179508":["thread",179508],"thread-179408":["thread",179408],"thread-178395":["thread",178395],"thread-178045":["thread",178045],"thread-177846":["thread",177846],"thread-177797":["thread",177797],"thread-177710":["thread",177710],"thread-176885":["thread",176885],"thread-176681":["thread",176681],"thread-176540":["thread",176540],"thread-176447":["thread",176447],"thread-176099":["thread",176099],"thread-175867":["thread",175867],"thread-175841":["thread",175841],"thread-175584":["thread",175584],"thread-175418":["thread",175418],"thread-174936":["thread",174936],"thread-174867":["thread",174867],"thread-174700":["thread",174700],"thread-174596":["thread",174596],"thread-174093":["thread",174093],"thread-173923":["thread",173923],"thread-173918":["thread",173918],"thread-173890":["thread",173890],"thread-172027":["thread",172027],"thread-170981":["thread",170981],"thread-170178":["thread",170178],"thread-168749":["thread",168749],"thread-168710":["thread",168710],"thread-166317":["thread",166317],"thread-166150":["thread",166150],"thread-164720":["thread",164720],"thread-164715":["thread",164715],"thread-164592":["thread",164592],"thread-163955":["thread",163955],"thread-162149":["thread",162149],"thread-161532":["thread",161532],"thread-160886":["thread",160886],"thread-160673":["thread",160673],"thread-160518":["thread",160518],"thread-159675":["thread",159675],"thread-159532":["thread",159532],"thread-159386":["thread",159386],"thread-158972":["thread",158972],"thread-158518":["thread",158518],"thread-157883":["thread",157883],"thread-157085":["thread",157085],"thread-156555":["thread",156555],"thread-156032":["thread",156032],"thread-155020":["thread",155020],"thread-154405":["thread",154405],"thread-154268":["thread",154268],"thread-152021":["thread",152021],"thread-151918":["thread",151918],"thread-130732":["thread",130732],"thread-130360":["thread",130360],"thread-117109":["thread",117109],"thread-117060":["thread",117060],"thread-116612":["thread",116612],"thread-102306":["thread",102306],"thread-41542":["thread",41542],"thread-33943":["thread",33943],"thread-33068":["thread",33068],"thread-27915":["thread",27915],"thread-25419":["thread",25419]}, , 1715913896
Run Time: 0.000280
- 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