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 (1637090, 1594125, 1529741, 1529739, 1524306, 1519371, 1515924, 1515133, 1513545, 1510788, 1508946, 1508092, 1508090, 1500831, 1497751, 1496470, 1493377, 1493106, 1491441, 1490605, 1487845, 1487545, 1486998, 1485583, 1480410, 1477968, 1477188, 1476864, 1475070, 1474431, 1474270, 1474056, 1474053, 1473741, 1473022, 1472600, 1471484, 1470849, 1469578, 1467361, 1467350, 1465261, 1464324, 1464032, 1463662, 1463182, 1462533, 1461650, 1461093, 1460229, 1459546, 1459540, 1459333, 1459051, 1458667, 1458399, 1457404, 1457394, 1457007, 1456945, 1456942, 1456374, 1455941, 1454337, 1454087, 1453440, 1453139, 1453126, 1451244, 1449629, 1449420, 1446315, 1445554, 1444338, 1441422, 1435631, 1424838, 1415337, 1401711, 1381119, 1371752, 1371739, 1350055, 1341056, 1337802, 1336578, 1330295, 1328988, 1325572, 1324035, 1316835, 1316729, 1315298, 1314444, 1312933, 1312886, 1311920, 1310069, 1309270, 1307975, 1307438, 1304388, 1301351, 1300654, 1300629, 1300521, 1297107, 1295189, 1293477, 1286820, 1284865, 1284350, 1281002, 1276340, 1270347, 1266897, 1265588, 1263697, 1252815, 1245770))
Run Time: 0.124635
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 120 | 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: 1296, 0, 1714792452, {"thread-1637090":["thread",1637090],"thread-1594125":["thread",1594125],"thread-1529741":["thread",1529741],"thread-1529739":["thread",1529739],"thread-1524306":["thread",1524306],"thread-1519371":["thread",1519371],"thread-1515924":["thread",1515924],"thread-1515133":["thread",1515133],"thread-1513545":["thread",1513545],"thread-1510788":["thread",1510788],"thread-1508946":["thread",1508946],"thread-1508092":["thread",1508092],"thread-1508090":["thread",1508090],"thread-1500831":["thread",1500831],"thread-1497751":["thread",1497751],"thread-1496470":["thread",1496470],"thread-1493377":["thread",1493377],"thread-1493106":["thread",1493106],"thread-1491441":["thread",1491441],"thread-1490605":["thread",1490605],"thread-1487845":["thread",1487845],"thread-1487545":["thread",1487545],"thread-1486998":["thread",1486998],"thread-1485583":["thread",1485583],"thread-1480410":["thread",1480410],"thread-1477968":["thread",1477968],"thread-1477188":["thread",1477188],"thread-1476864":["thread",1476864],"thread-1475070":["thread",1475070],"thread-1474431":["thread",1474431],"thread-1474270":["thread",1474270],"thread-1474056":["thread",1474056],"thread-1474053":["thread",1474053],"thread-1473741":["thread",1473741],"thread-1473022":["thread",1473022],"thread-1472600":["thread",1472600],"thread-1471484":["thread",1471484],"thread-1470849":["thread",1470849],"thread-1469578":["thread",1469578],"thread-1467361":["thread",1467361],"thread-1467350":["thread",1467350],"thread-1465261":["thread",1465261],"thread-1464324":["thread",1464324],"thread-1464032":["thread",1464032],"thread-1463662":["thread",1463662],"thread-1463182":["thread",1463182],"thread-1462533":["thread",1462533],"thread-1461650":["thread",1461650],"thread-1461093":["thread",1461093],"thread-1460229":["thread",1460229],"thread-1459546":["thread",1459546],"thread-1459540":["thread",1459540],"thread-1459333":["thread",1459333],"thread-1459051":["thread",1459051],"thread-1458667":["thread",1458667],"thread-1458399":["thread",1458399],"thread-1457404":["thread",1457404],"thread-1457394":["thread",1457394],"thread-1457007":["thread",1457007],"thread-1456945":["thread",1456945],"thread-1456942":["thread",1456942],"thread-1456374":["thread",1456374],"thread-1455941":["thread",1455941],"thread-1454337":["thread",1454337],"thread-1454087":["thread",1454087],"thread-1453440":["thread",1453440],"thread-1453139":["thread",1453139],"thread-1453126":["thread",1453126],"thread-1451244":["thread",1451244],"thread-1449629":["thread",1449629],"thread-1449420":["thread",1449420],"thread-1446315":["thread",1446315],"thread-1445554":["thread",1445554],"thread-1444338":["thread",1444338],"thread-1441422":["thread",1441422],"thread-1435631":["thread",1435631],"thread-1424838":["thread",1424838],"thread-1415337":["thread",1415337],"thread-1401711":["thread",1401711],"thread-1381119":["thread",1381119],"thread-1371752":["thread",1371752],"thread-1371739":["thread",1371739],"thread-1350055":["thread",1350055],"thread-1341056":["thread",1341056],"thread-1337802":["thread",1337802],"thread-1336578":["thread",1336578],"thread-1330295":["thread",1330295],"thread-1328988":["thread",1328988],"thread-1325572":["thread",1325572],"thread-1324035":["thread",1324035],"thread-1316835":["thread",1316835],"thread-1316729":["thread",1316729],"thread-1315298":["thread",1315298],"thread-1314444":["thread",1314444],"thread-1312933":["thread",1312933],"thread-1312886":["thread",1312886],"thread-1311920":["thread",1311920],"thread-1310069":["thread",1310069],"thread-1309270":["thread",1309270],"thread-1307975":["thread",1307975],"thread-1307438":["thread",1307438],"thread-1304388":["thread",1304388],"thread-1301351":["thread",1301351],"thread-1300654":["thread",1300654],"thread-1300629":["thread",1300629],"thread-1300521":["thread",1300521],"thread-1297107":["thread",1297107],"thread-1295189":["thread",1295189],"thread-1293477":["thread",1293477],"thread-1286820":["thread",1286820],"thread-1284865":["thread",1284865],"thread-1284350":["thread",1284350],"thread-1281002":["thread",1281002],"thread-1276340":["thread",1276340],"thread-1270347":["thread",1270347],"thread-1266897":["thread",1266897],"thread-1265588":["thread",1265588],"thread-1263697":["thread",1263697],"thread-1252815":["thread",1252815],"thread-1245770":["thread",1245770]}, , 1714788852
Run Time: 0.004246
- 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