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 (1573809, 1523354, 1520134, 1516936, 1513978, 1513560, 1511691, 1510790, 1508094, 1507460, 1505366, 1503568, 1503302, 1501770, 1501453, 1500960, 1500333, 1500146, 1499925, 1498020, 1497739, 1496553, 1495366, 1493923, 1492807, 1492452, 1491804, 1491607, 1490346, 1489979, 1487999, 1487998, 1487842, 1483122, 1481652, 1479265, 1479264, 1478290, 1477518, 1476367, 1476366, 1476350, 1474437, 1473961, 1471906, 1470873, 1470841, 1470698, 1470090, 1469578, 1469575, 1469389, 1469233, 1468926, 1467323, 1466322, 1466095, 1465192, 1464893, 1464668, 1463665, 1463378, 1462851, 1462850, 1462849, 1462848, 1462546, 1459055, 1458070, 1458068, 1457391, 1456637, 1455737, 1455729, 1455728, 1454855, 1454633, 1454313, 1454089, 1453443, 1452797, 1452439, 1449881, 1448847, 1448727, 1448518, 1447971, 1446313, 1446312, 1445381, 1444647, 1443963, 1443570, 1443557, 1439905, 1436303, 1435802, 1434698, 1398614, 1398125, 1387102, 1357007, 1350291, 1342412, 1328101, 1327168, 1324305, 1324295, 1319618, 1315074, 1309926, 1308387, 1307953, 1305401, 1304642, 1301798, 1300641, 1298804, 1296347, 1295475, 1294740, 1288495, 1287209, 1285276, 1284753, 1283811, 1280015, 1270029, 1263697, 1263382, 1254055, 1244549))
Run Time: 0.151324
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 132 | 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: 1155, 0, 1714713018, {"thread-1573809":["thread",1573809],"thread-1523354":["thread",1523354],"thread-1520134":["thread",1520134],"thread-1516936":["thread",1516936],"thread-1513978":["thread",1513978],"thread-1513560":["thread",1513560],"thread-1511691":["thread",1511691],"thread-1510790":["thread",1510790],"thread-1508094":["thread",1508094],"thread-1507460":["thread",1507460],"thread-1505366":["thread",1505366],"thread-1503568":["thread",1503568],"thread-1503302":["thread",1503302],"thread-1501770":["thread",1501770],"thread-1501453":["thread",1501453],"thread-1500960":["thread",1500960],"thread-1500333":["thread",1500333],"thread-1500146":["thread",1500146],"thread-1499925":["thread",1499925],"thread-1498020":["thread",1498020],"thread-1497739":["thread",1497739],"thread-1496553":["thread",1496553],"thread-1495366":["thread",1495366],"thread-1493923":["thread",1493923],"thread-1492807":["thread",1492807],"thread-1492452":["thread",1492452],"thread-1491804":["thread",1491804],"thread-1491607":["thread",1491607],"thread-1490346":["thread",1490346],"thread-1489979":["thread",1489979],"thread-1487999":["thread",1487999],"thread-1487998":["thread",1487998],"thread-1487842":["thread",1487842],"thread-1483122":["thread",1483122],"thread-1481652":["thread",1481652],"thread-1479265":["thread",1479265],"thread-1479264":["thread",1479264],"thread-1478290":["thread",1478290],"thread-1477518":["thread",1477518],"thread-1476367":["thread",1476367],"thread-1476366":["thread",1476366],"thread-1476350":["thread",1476350],"thread-1474437":["thread",1474437],"thread-1473961":["thread",1473961],"thread-1471906":["thread",1471906],"thread-1470873":["thread",1470873],"thread-1470841":["thread",1470841],"thread-1470698":["thread",1470698],"thread-1470090":["thread",1470090],"thread-1469578":["thread",1469578],"thread-1469575":["thread",1469575],"thread-1469389":["thread",1469389],"thread-1469233":["thread",1469233],"thread-1468926":["thread",1468926],"thread-1467323":["thread",1467323],"thread-1466322":["thread",1466322],"thread-1466095":["thread",1466095],"thread-1465192":["thread",1465192],"thread-1464893":["thread",1464893],"thread-1464668":["thread",1464668],"thread-1463665":["thread",1463665],"thread-1463378":["thread",1463378],"thread-1462851":["thread",1462851],"thread-1462850":["thread",1462850],"thread-1462849":["thread",1462849],"thread-1462848":["thread",1462848],"thread-1462546":["thread",1462546],"thread-1459055":["thread",1459055],"thread-1458070":["thread",1458070],"thread-1458068":["thread",1458068],"thread-1457391":["thread",1457391],"thread-1456637":["thread",1456637],"thread-1455737":["thread",1455737],"thread-1455729":["thread",1455729],"thread-1455728":["thread",1455728],"thread-1454855":["thread",1454855],"thread-1454633":["thread",1454633],"thread-1454313":["thread",1454313],"thread-1454089":["thread",1454089],"thread-1453443":["thread",1453443],"thread-1452797":["thread",1452797],"thread-1452439":["thread",1452439],"thread-1449881":["thread",1449881],"thread-1448847":["thread",1448847],"thread-1448727":["thread",1448727],"thread-1448518":["thread",1448518],"thread-1447971":["thread",1447971],"thread-1446313":["thread",1446313],"thread-1446312":["thread",1446312],"thread-1445381":["thread",1445381],"thread-1444647":["thread",1444647],"thread-1443963":["thread",1443963],"thread-1443570":["thread",1443570],"thread-1443557":["thread",1443557],"thread-1439905":["thread",1439905],"thread-1436303":["thread",1436303],"thread-1435802":["thread",1435802],"thread-1434698":["thread",1434698],"thread-1398614":["thread",1398614],"thread-1398125":["thread",1398125],"thread-1387102":["thread",1387102],"thread-1357007":["thread",1357007],"thread-1350291":["thread",1350291],"thread-1342412":["thread",1342412],"thread-1328101":["thread",1328101],"thread-1327168":["thread",1327168],"thread-1324305":["thread",1324305],"thread-1324295":["thread",1324295],"thread-1319618":["thread",1319618],"thread-1315074":["thread",1315074],"thread-1309926":["thread",1309926],"thread-1308387":["thread",1308387],"thread-1307953":["thread",1307953],"thread-1305401":["thread",1305401],"thread-1304642":["thread",1304642],"thread-1301798":["thread",1301798],"thread-1300641":["thread",1300641],"thread-1298804":["thread",1298804],"thread-1296347":["thread",1296347],"thread-1295475":["thread",1295475],"thread-1294740":["thread",1294740],"thread-1288495":["thread",1288495],"thread-1287209":["thread",1287209],"thread-1285276":["thread",1285276],"thread-1284753":["thread",1284753],"thread-1283811":["thread",1283811],"thread-1280015":["thread",1280015],"thread-1270029":["thread",1270029],"thread-1263697":["thread",1263697],"thread-1263382":["thread",1263382],"thread-1254055":["thread",1254055],"thread-1244549":["thread",1244549]}, , 1714709418
Run Time: 0.003228
- 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