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 (7216245, 7210473, 7205741, 7202798, 7201972, 7196949, 7196324, 7195150, 7189367, 7185632, 7184336, 7184322, 7184060, 7180703, 7178674, 7177412, 7177400, 7175257, 7174645, 7173364, 7170757, 7165918, 7162669, 7157879, 7155579, 7155175, 7154201, 7152439, 7151951, 7149128, 7148527, 7148525, 7142518, 7139877, 7139180, 7139174, 7138594, 7137598, 7136399, 7133703, 7132335, 7132252, 7126663, 7121357, 7120868, 7119872, 7117814, 7117021, 7115590, 7114302, 7113412, 7107983, 7106503, 7104116, 7098847, 7096459, 7093647, 7093591, 7093267, 7089803, 7089346, 7088404, 7086512, 7083167, 7082950, 7078570, 7073749, 7069594, 7047690, 7046289, 7039862, 7033751, 7032030, 7029376, 7001559, 6990658, 6990579, 6989434, 6979784, 6966312, 6958506, 181360, 13855, 13729, 13173, 13005, 12931, 12532, 12384, 10439, 10128, 8420, 8354, 8126, 7854, 7451, 7211, 5435, 5225, 5126, 4839, 4657, 4445, 3703, 3601, 3461, 2978, 2882, 2839, 2661, 2414, 2218, 2124, 1957, 1845, 1709, 1669, 1356, 1353, 666, 578))
Run Time: 0.007916
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 121 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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 2870
- 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 138
- 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 2487
- 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: 659, 0, 1716908730, {"thread-7216245":["thread",7216245],"thread-7210473":["thread",7210473],"thread-7205741":["thread",7205741],"thread-7202798":["thread",7202798],"thread-7201972":["thread",7201972],"thread-7196949":["thread",7196949],"thread-7196324":["thread",7196324],"thread-7195150":["thread",7195150],"thread-7189367":["thread",7189367],"thread-7185632":["thread",7185632],"thread-7184336":["thread",7184336],"thread-7184322":["thread",7184322],"thread-7184060":["thread",7184060],"thread-7180703":["thread",7180703],"thread-7178674":["thread",7178674],"thread-7177412":["thread",7177412],"thread-7177400":["thread",7177400],"thread-7175257":["thread",7175257],"thread-7174645":["thread",7174645],"thread-7173364":["thread",7173364],"thread-7170757":["thread",7170757],"thread-7165918":["thread",7165918],"thread-7162669":["thread",7162669],"thread-7157879":["thread",7157879],"thread-7155579":["thread",7155579],"thread-7155175":["thread",7155175],"thread-7154201":["thread",7154201],"thread-7152439":["thread",7152439],"thread-7151951":["thread",7151951],"thread-7149128":["thread",7149128],"thread-7148527":["thread",7148527],"thread-7148525":["thread",7148525],"thread-7142518":["thread",7142518],"thread-7139877":["thread",7139877],"thread-7139180":["thread",7139180],"thread-7139174":["thread",7139174],"thread-7138594":["thread",7138594],"thread-7137598":["thread",7137598],"thread-7136399":["thread",7136399],"thread-7133703":["thread",7133703],"thread-7132335":["thread",7132335],"thread-7132252":["thread",7132252],"thread-7126663":["thread",7126663],"thread-7121357":["thread",7121357],"thread-7120868":["thread",7120868],"thread-7119872":["thread",7119872],"thread-7117814":["thread",7117814],"thread-7117021":["thread",7117021],"thread-7115590":["thread",7115590],"thread-7114302":["thread",7114302],"thread-7113412":["thread",7113412],"thread-7107983":["thread",7107983],"thread-7106503":["thread",7106503],"thread-7104116":["thread",7104116],"thread-7098847":["thread",7098847],"thread-7096459":["thread",7096459],"thread-7093647":["thread",7093647],"thread-7093591":["thread",7093591],"thread-7093267":["thread",7093267],"thread-7089803":["thread",7089803],"thread-7089346":["thread",7089346],"thread-7088404":["thread",7088404],"thread-7086512":["thread",7086512],"thread-7083167":["thread",7083167],"thread-7082950":["thread",7082950],"thread-7078570":["thread",7078570],"thread-7073749":["thread",7073749],"thread-7069594":["thread",7069594],"thread-7047690":["thread",7047690],"thread-7046289":["thread",7046289],"thread-7039862":["thread",7039862],"thread-7033751":["thread",7033751],"thread-7032030":["thread",7032030],"thread-7029376":["thread",7029376],"thread-7001559":["thread",7001559],"thread-6990658":["thread",6990658],"thread-6990579":["thread",6990579],"thread-6989434":["thread",6989434],"thread-6979784":["thread",6979784],"thread-6966312":["thread",6966312],"thread-6958506":["thread",6958506],"thread-181360":["thread",181360],"thread-13855":["thread",13855],"thread-13729":["thread",13729],"thread-13173":["thread",13173],"thread-13005":["thread",13005],"thread-12931":["thread",12931],"thread-12532":["thread",12532],"thread-12384":["thread",12384],"thread-10439":["thread",10439],"thread-10128":["thread",10128],"thread-8420":["thread",8420],"thread-8354":["thread",8354],"thread-8126":["thread",8126],"thread-7854":["thread",7854],"thread-7451":["thread",7451],"thread-7211":["thread",7211],"thread-5435":["thread",5435],"thread-5225":["thread",5225],"thread-5126":["thread",5126],"thread-4839":["thread",4839],"thread-4657":["thread",4657],"thread-4445":["thread",4445],"thread-3703":["thread",3703],"thread-3601":["thread",3601],"thread-3461":["thread",3461],"thread-2978":["thread",2978],"thread-2882":["thread",2882],"thread-2839":["thread",2839],"thread-2661":["thread",2661],"thread-2414":["thread",2414],"thread-2218":["thread",2218],"thread-2124":["thread",2124],"thread-1957":["thread",1957],"thread-1845":["thread",1845],"thread-1709":["thread",1709],"thread-1669":["thread",1669],"thread-1356":["thread",1356],"thread-1353":["thread",1353],"thread-666":["thread",666],"thread-578":["thread",578]}, NULL, 1716905130
Run Time: 0.000601
- 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 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20