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 (1685553, 1574061, 1573808, 1564944, 1543757, 1524298, 1520768, 1520760, 1520542, 1517461, 1515433, 1513230, 1512735, 1508090, 1507460, 1505262, 1500831, 1499573, 1497738, 1496961, 1496470, 1494840, 1494138, 1493657, 1493513, 1492809, 1492437, 1491610, 1489732, 1489354, 1487847, 1485823, 1485583, 1482928, 1478291, 1476860, 1476350, 1476349, 1474435, 1473765, 1473758, 1472616, 1472307, 1471045, 1471044, 1470304, 1469227, 1468690, 1466703, 1465228, 1465186, 1464319, 1463661, 1463379, 1463079, 1463076, 1462547, 1462100, 1461544, 1461024, 1460962, 1460570, 1459546, 1459328, 1458666, 1457404, 1457400, 1457399, 1456125, 1455733, 1455336, 1455319, 1454842, 1454089, 1453442, 1453441, 1452795, 1452447, 1451914, 1451909, 1451243, 1450634, 1449481, 1448427, 1448420, 1447972, 1447673, 1447010, 1446727, 1446658, 1446649, 1446316, 1446313, 1446312, 1445809, 1445384, 1445379, 1444749, 1443568, 1443560, 1442231, 1440771, 1440377, 1439905, 1439678, 1438145, 1438139, 1437803, 1437778, 1436553, 1436374, 1436291, 1435668, 1434699, 1401174, 1400559, 1389123, 1388694, 1385456, 1385062, 1371324, 1368464, 1358355, 1356288, 1347488, 1344757, 1338077, 1337016, 1336473, 1334224, 1332784, 1329360, 1328024, 1323618, 1323426, 1323169, 1322817, 1322531, 1322237, 1321739, 1313020, 1312331, 1311848, 1305943, 1302955, 1301798, 1301633, 1301351, 1301003, 1297325, 1296423, 1296296, 1295356, 1290792, 1288988, 1282942, 1274466, 1270852, 1255457, 1255333, 1252955, 1252426, 1252186, 1251300, 1250181, 1247926, 1244567, 1239783, 1239550))
Run Time: 0.229511
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 169 | 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: 387, 0, 1714332427, {"thread-1685553":["thread",1685553],"thread-1574061":["thread",1574061],"thread-1573808":["thread",1573808],"thread-1564944":["thread",1564944],"thread-1543757":["thread",1543757],"thread-1524298":["thread",1524298],"thread-1520768":["thread",1520768],"thread-1520760":["thread",1520760],"thread-1520542":["thread",1520542],"thread-1517461":["thread",1517461],"thread-1515433":["thread",1515433],"thread-1513230":["thread",1513230],"thread-1512735":["thread",1512735],"thread-1508090":["thread",1508090],"thread-1507460":["thread",1507460],"thread-1505262":["thread",1505262],"thread-1500831":["thread",1500831],"thread-1499573":["thread",1499573],"thread-1497738":["thread",1497738],"thread-1496961":["thread",1496961],"thread-1496470":["thread",1496470],"thread-1494840":["thread",1494840],"thread-1494138":["thread",1494138],"thread-1493657":["thread",1493657],"thread-1493513":["thread",1493513],"thread-1492809":["thread",1492809],"thread-1492437":["thread",1492437],"thread-1491610":["thread",1491610],"thread-1489732":["thread",1489732],"thread-1489354":["thread",1489354],"thread-1487847":["thread",1487847],"thread-1485823":["thread",1485823],"thread-1485583":["thread",1485583],"thread-1482928":["thread",1482928],"thread-1478291":["thread",1478291],"thread-1476860":["thread",1476860],"thread-1476350":["thread",1476350],"thread-1476349":["thread",1476349],"thread-1474435":["thread",1474435],"thread-1473765":["thread",1473765],"thread-1473758":["thread",1473758],"thread-1472616":["thread",1472616],"thread-1472307":["thread",1472307],"thread-1471045":["thread",1471045],"thread-1471044":["thread",1471044],"thread-1470304":["thread",1470304],"thread-1469227":["thread",1469227],"thread-1468690":["thread",1468690],"thread-1466703":["thread",1466703],"thread-1465228":["thread",1465228],"thread-1465186":["thread",1465186],"thread-1464319":["thread",1464319],"thread-1463661":["thread",1463661],"thread-1463379":["thread",1463379],"thread-1463079":["thread",1463079],"thread-1463076":["thread",1463076],"thread-1462547":["thread",1462547],"thread-1462100":["thread",1462100],"thread-1461544":["thread",1461544],"thread-1461024":["thread",1461024],"thread-1460962":["thread",1460962],"thread-1460570":["thread",1460570],"thread-1459546":["thread",1459546],"thread-1459328":["thread",1459328],"thread-1458666":["thread",1458666],"thread-1457404":["thread",1457404],"thread-1457400":["thread",1457400],"thread-1457399":["thread",1457399],"thread-1456125":["thread",1456125],"thread-1455733":["thread",1455733],"thread-1455336":["thread",1455336],"thread-1455319":["thread",1455319],"thread-1454842":["thread",1454842],"thread-1454089":["thread",1454089],"thread-1453442":["thread",1453442],"thread-1453441":["thread",1453441],"thread-1452795":["thread",1452795],"thread-1452447":["thread",1452447],"thread-1451914":["thread",1451914],"thread-1451909":["thread",1451909],"thread-1451243":["thread",1451243],"thread-1450634":["thread",1450634],"thread-1449481":["thread",1449481],"thread-1448427":["thread",1448427],"thread-1448420":["thread",1448420],"thread-1447972":["thread",1447972],"thread-1447673":["thread",1447673],"thread-1447010":["thread",1447010],"thread-1446727":["thread",1446727],"thread-1446658":["thread",1446658],"thread-1446649":["thread",1446649],"thread-1446316":["thread",1446316],"thread-1446313":["thread",1446313],"thread-1446312":["thread",1446312],"thread-1445809":["thread",1445809],"thread-1445384":["thread",1445384],"thread-1445379":["thread",1445379],"thread-1444749":["thread",1444749],"thread-1443568":["thread",1443568],"thread-1443560":["thread",1443560],"thread-1442231":["thread",1442231],"thread-1440771":["thread",1440771],"thread-1440377":["thread",1440377],"thread-1439905":["thread",1439905],"thread-1439678":["thread",1439678],"thread-1438145":["thread",1438145],"thread-1438139":["thread",1438139],"thread-1437803":["thread",1437803],"thread-1437778":["thread",1437778],"thread-1436553":["thread",1436553],"thread-1436374":["thread",1436374],"thread-1436291":["thread",1436291],"thread-1435668":["thread",1435668],"thread-1434699":["thread",1434699],"thread-1401174":["thread",1401174],"thread-1400559":["thread",1400559],"thread-1389123":["thread",1389123],"thread-1388694":["thread",1388694],"thread-1385456":["thread",1385456],"thread-1385062":["thread",1385062],"thread-1371324":["thread",1371324],"thread-1368464":["thread",1368464],"thread-1358355":["thread",1358355],"thread-1356288":["thread",1356288],"thread-1347488":["thread",1347488],"thread-1344757":["thread",1344757],"thread-1338077":["thread",1338077],"thread-1337016":["thread",1337016],"thread-1336473":["thread",1336473],"thread-1334224":["thread",1334224],"thread-1332784":["thread",1332784],"thread-1329360":["thread",1329360],"thread-1328024":["thread",1328024],"thread-1323618":["thread",1323618],"thread-1323426":["thread",1323426],"thread-1323169":["thread",1323169],"thread-1322817":["thread",1322817],"thread-1322531":["thread",1322531],"thread-1322237":["thread",1322237],"thread-1321739":["thread",1321739],"thread-1313020":["thread",1313020],"thread-1312331":["thread",1312331],"thread-1311848":["thread",1311848],"thread-1305943":["thread",1305943],"thread-1302955":["thread",1302955],"thread-1301798":["thread",1301798],"thread-1301633":["thread",1301633],"thread-1301351":["thread",1301351],"thread-1301003":["thread",1301003],"thread-1297325":["thread",1297325],"thread-1296423":["thread",1296423],"thread-1296296":["thread",1296296],"thread-1295356":["thread",1295356],"thread-1290792":["thread",1290792],"thread-1288988":["thread",1288988],"thread-1282942":["thread",1282942],"thread-1274466":["thread",1274466],"thread-1270852":["thread",1270852],"thread-1255457":["thread",1255457],"thread-1255333":["thread",1255333],"thread-1252955":["thread",1252955],"thread-1252426":["thread",1252426],"thread-1252186":["thread",1252186],"thread-1251300":["thread",1251300],"thread-1250181":["thread",1250181],"thread-1247926":["thread",1247926],"thread-1244567":["thread",1244567],"thread-1239783":["thread",1239783],"thread-1239550":["thread",1239550]}, , 1714328827
Run Time: 0.006654
- 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