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 (1508709, 1478299, 1474976, 1474504, 1473496, 1471736, 1470154, 1469361, 1468479, 1448131, 1376099, 1372063, 1349601, 1326333, 1323828, 1322144, 1319619, 1319447, 1319389, 1319173, 1319169, 1319168, 1318592, 1318586, 1317097, 1316924, 1315926, 1315651, 1314625, 1314617, 1314614, 1314609, 1314607, 1314598, 1314459, 1301491, 1299982, 1297396, 1297302, 1296339, 1296293, 1295943, 1295913, 1295580, 1295114, 1295046, 1294271, 1293988, 1293336, 1293285, 1292203, 1291889, 1291879, 1291875, 1291872, 1291870, 1291832, 1291634, 1291630, 1291527, 1291191, 1291190, 1291155, 1290246, 1290131, 1290129, 1290096, 1289753, 1288187, 1288102, 1287494, 1287491, 1286799, 1286797, 1286790, 1286527, 1286525, 1286522, 1286521, 1286520, 1286308, 1285892, 1285256, 1285245, 1285244, 1285237, 1285228, 1285059, 1284056, 1284048, 1283785, 1283783, 1283780, 1283777, 1283626, 1282817, 1276969, 1262341, 1258670, 1257097, 1248733, 1248227, 1247434, 1246474, 1246471, 1246468, 1246095, 1245451, 1244138, 1242341, 1240404))
Run Time: 0.111132
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 111 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | f6kf_hdvietn116n.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | f6kf_hdvietn116n.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | f6kf_hdvietn116n.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | f6kf_hdvietn116n.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,f6kf_hdvietn116n.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 2719
- 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 2345
- XF\App->run() in src/XF.php at line 512
- 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: 36, 0, 1714661780, {"thread-1508709":["thread",1508709],"thread-1478299":["thread",1478299],"thread-1474976":["thread",1474976],"thread-1474504":["thread",1474504],"thread-1473496":["thread",1473496],"thread-1471736":["thread",1471736],"thread-1470154":["thread",1470154],"thread-1469361":["thread",1469361],"thread-1468479":["thread",1468479],"thread-1448131":["thread",1448131],"thread-1376099":["thread",1376099],"thread-1372063":["thread",1372063],"thread-1349601":["thread",1349601],"thread-1326333":["thread",1326333],"thread-1323828":["thread",1323828],"thread-1322144":["thread",1322144],"thread-1319619":["thread",1319619],"thread-1319447":["thread",1319447],"thread-1319389":["thread",1319389],"thread-1319173":["thread",1319173],"thread-1319169":["thread",1319169],"thread-1319168":["thread",1319168],"thread-1318592":["thread",1318592],"thread-1318586":["thread",1318586],"thread-1317097":["thread",1317097],"thread-1316924":["thread",1316924],"thread-1315926":["thread",1315926],"thread-1315651":["thread",1315651],"thread-1314625":["thread",1314625],"thread-1314617":["thread",1314617],"thread-1314614":["thread",1314614],"thread-1314609":["thread",1314609],"thread-1314607":["thread",1314607],"thread-1314598":["thread",1314598],"thread-1314459":["thread",1314459],"thread-1301491":["thread",1301491],"thread-1299982":["thread",1299982],"thread-1297396":["thread",1297396],"thread-1297302":["thread",1297302],"thread-1296339":["thread",1296339],"thread-1296293":["thread",1296293],"thread-1295943":["thread",1295943],"thread-1295913":["thread",1295913],"thread-1295580":["thread",1295580],"thread-1295114":["thread",1295114],"thread-1295046":["thread",1295046],"thread-1294271":["thread",1294271],"thread-1293988":["thread",1293988],"thread-1293336":["thread",1293336],"thread-1293285":["thread",1293285],"thread-1292203":["thread",1292203],"thread-1291889":["thread",1291889],"thread-1291879":["thread",1291879],"thread-1291875":["thread",1291875],"thread-1291872":["thread",1291872],"thread-1291870":["thread",1291870],"thread-1291832":["thread",1291832],"thread-1291634":["thread",1291634],"thread-1291630":["thread",1291630],"thread-1291527":["thread",1291527],"thread-1291191":["thread",1291191],"thread-1291190":["thread",1291190],"thread-1291155":["thread",1291155],"thread-1290246":["thread",1290246],"thread-1290131":["thread",1290131],"thread-1290129":["thread",1290129],"thread-1290096":["thread",1290096],"thread-1289753":["thread",1289753],"thread-1288187":["thread",1288187],"thread-1288102":["thread",1288102],"thread-1287494":["thread",1287494],"thread-1287491":["thread",1287491],"thread-1286799":["thread",1286799],"thread-1286797":["thread",1286797],"thread-1286790":["thread",1286790],"thread-1286527":["thread",1286527],"thread-1286525":["thread",1286525],"thread-1286522":["thread",1286522],"thread-1286521":["thread",1286521],"thread-1286520":["thread",1286520],"thread-1286308":["thread",1286308],"thread-1285892":["thread",1285892],"thread-1285256":["thread",1285256],"thread-1285245":["thread",1285245],"thread-1285244":["thread",1285244],"thread-1285237":["thread",1285237],"thread-1285228":["thread",1285228],"thread-1285059":["thread",1285059],"thread-1284056":["thread",1284056],"thread-1284048":["thread",1284048],"thread-1283785":["thread",1283785],"thread-1283783":["thread",1283783],"thread-1283780":["thread",1283780],"thread-1283777":["thread",1283777],"thread-1283626":["thread",1283626],"thread-1282817":["thread",1282817],"thread-1276969":["thread",1276969],"thread-1262341":["thread",1262341],"thread-1258670":["thread",1258670],"thread-1257097":["thread",1257097],"thread-1248733":["thread",1248733],"thread-1248227":["thread",1248227],"thread-1247434":["thread",1247434],"thread-1246474":["thread",1246474],"thread-1246471":["thread",1246471],"thread-1246468":["thread",1246468],"thread-1246095":["thread",1246095],"thread-1245451":["thread",1245451],"thread-1244138":["thread",1244138],"thread-1242341":["thread",1242341],"thread-1240404":["thread",1240404]}, , 1714658180
Run Time: 0.003283
- 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 1512
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1244
- 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 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20