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 (1800265, 1790345, 1790166, 1789577, 1781259, 1765212, 1738148, 1724669, 1699325, 1696323, 1695913, 1694822, 1685553, 1684348, 1672514, 1670271, 1668540, 1641097, 1600187, 1587177, 1585659, 1574062, 1574056, 1573628, 1573612, 1572493, 1570995, 1568652, 1529090, 1518198, 1516590, 1515433, 1514191, 1513850, 1513547, 1511049, 1509448, 1508091, 1508086, 1507791, 1503300, 1503070, 1502799, 1502082, 1501772, 1500142, 1498069, 1497845, 1497412, 1496548, 1496451, 1496290, 1495972, 1495810, 1495754, 1495734, 1495626, 1494391, 1493943, 1493024, 1492831, 1492805, 1492582, 1492433, 1491802, 1490348, 1489974, 1489309, 1488950, 1488064, 1487846, 1486980, 1486703, 1486565, 1485828, 1485491, 1484898, 1483106, 1481921, 1481743, 1480566, 1478332, 1478289, 1477978, 1476608, 1475578, 1475347, 1475055, 1475054, 1475052, 1473765, 1473014, 1471905, 1471227, 1471040, 1469597, 1464836, 1463382, 1462192, 1461541, 1461336, 1447403, 1446354, 1442629, 1437320, 1435059, 1359514, 1356662, 1332897, 1329774, 1324924, 1322154, 1316034, 1309838, 1305943, 1302408, 1301889, 1290675, 1288853, 1281090, 1280340, 1273927, 1273926, 1270458, 1270225, 1265169, 1244567))
Run Time: 0.147278
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 127 | 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: 1160, 0, 1714755951, {"thread-1800265":["thread",1800265],"thread-1790345":["thread",1790345],"thread-1790166":["thread",1790166],"thread-1789577":["thread",1789577],"thread-1781259":["thread",1781259],"thread-1765212":["thread",1765212],"thread-1738148":["thread",1738148],"thread-1724669":["thread",1724669],"thread-1699325":["thread",1699325],"thread-1696323":["thread",1696323],"thread-1695913":["thread",1695913],"thread-1694822":["thread",1694822],"thread-1685553":["thread",1685553],"thread-1684348":["thread",1684348],"thread-1672514":["thread",1672514],"thread-1670271":["thread",1670271],"thread-1668540":["thread",1668540],"thread-1641097":["thread",1641097],"thread-1600187":["thread",1600187],"thread-1587177":["thread",1587177],"thread-1585659":["thread",1585659],"thread-1574062":["thread",1574062],"thread-1574056":["thread",1574056],"thread-1573628":["thread",1573628],"thread-1573612":["thread",1573612],"thread-1572493":["thread",1572493],"thread-1570995":["thread",1570995],"thread-1568652":["thread",1568652],"thread-1529090":["thread",1529090],"thread-1518198":["thread",1518198],"thread-1516590":["thread",1516590],"thread-1515433":["thread",1515433],"thread-1514191":["thread",1514191],"thread-1513850":["thread",1513850],"thread-1513547":["thread",1513547],"thread-1511049":["thread",1511049],"thread-1509448":["thread",1509448],"thread-1508091":["thread",1508091],"thread-1508086":["thread",1508086],"thread-1507791":["thread",1507791],"thread-1503300":["thread",1503300],"thread-1503070":["thread",1503070],"thread-1502799":["thread",1502799],"thread-1502082":["thread",1502082],"thread-1501772":["thread",1501772],"thread-1500142":["thread",1500142],"thread-1498069":["thread",1498069],"thread-1497845":["thread",1497845],"thread-1497412":["thread",1497412],"thread-1496548":["thread",1496548],"thread-1496451":["thread",1496451],"thread-1496290":["thread",1496290],"thread-1495972":["thread",1495972],"thread-1495810":["thread",1495810],"thread-1495754":["thread",1495754],"thread-1495734":["thread",1495734],"thread-1495626":["thread",1495626],"thread-1494391":["thread",1494391],"thread-1493943":["thread",1493943],"thread-1493024":["thread",1493024],"thread-1492831":["thread",1492831],"thread-1492805":["thread",1492805],"thread-1492582":["thread",1492582],"thread-1492433":["thread",1492433],"thread-1491802":["thread",1491802],"thread-1490348":["thread",1490348],"thread-1489974":["thread",1489974],"thread-1489309":["thread",1489309],"thread-1488950":["thread",1488950],"thread-1488064":["thread",1488064],"thread-1487846":["thread",1487846],"thread-1486980":["thread",1486980],"thread-1486703":["thread",1486703],"thread-1486565":["thread",1486565],"thread-1485828":["thread",1485828],"thread-1485491":["thread",1485491],"thread-1484898":["thread",1484898],"thread-1483106":["thread",1483106],"thread-1481921":["thread",1481921],"thread-1481743":["thread",1481743],"thread-1480566":["thread",1480566],"thread-1478332":["thread",1478332],"thread-1478289":["thread",1478289],"thread-1477978":["thread",1477978],"thread-1476608":["thread",1476608],"thread-1475578":["thread",1475578],"thread-1475347":["thread",1475347],"thread-1475055":["thread",1475055],"thread-1475054":["thread",1475054],"thread-1475052":["thread",1475052],"thread-1473765":["thread",1473765],"thread-1473014":["thread",1473014],"thread-1471905":["thread",1471905],"thread-1471227":["thread",1471227],"thread-1471040":["thread",1471040],"thread-1469597":["thread",1469597],"thread-1464836":["thread",1464836],"thread-1463382":["thread",1463382],"thread-1462192":["thread",1462192],"thread-1461541":["thread",1461541],"thread-1461336":["thread",1461336],"thread-1447403":["thread",1447403],"thread-1446354":["thread",1446354],"thread-1442629":["thread",1442629],"thread-1437320":["thread",1437320],"thread-1435059":["thread",1435059],"thread-1359514":["thread",1359514],"thread-1356662":["thread",1356662],"thread-1332897":["thread",1332897],"thread-1329774":["thread",1329774],"thread-1324924":["thread",1324924],"thread-1322154":["thread",1322154],"thread-1309838":["thread",1309838],"thread-1305943":["thread",1305943],"thread-1302408":["thread",1302408],"thread-1301889":["thread",1301889],"thread-1290675":["thread",1290675],"thread-1288853":["thread",1288853],"thread-1281090":["thread",1281090],"thread-1280340":["thread",1280340],"thread-1273927":["thread",1273927],"thread-1273926":["thread",1273926],"thread-1270458":["thread",1270458],"thread-1270225":["thread",1270225],"thread-1265169":["thread",1265169],"thread-1244567":["thread",1244567]}, , 1714752351
Run Time: 0.005339
- 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