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 (1748445, 1645491, 1595841, 1595226, 1594125, 1573800, 1573612, 1573595, 1529090, 1528244, 1521518, 1520768, 1520128, 1517901, 1517891, 1517436, 1516590, 1516574, 1515714, 1515433, 1515429, 1515428, 1515422, 1515133, 1514393, 1514383, 1514189, 1513974, 1513946, 1513846, 1512890, 1512884, 1512735, 1511052, 1508090, 1508080, 1506597, 1506594, 1501865, 1501467, 1501450, 1500831, 1500144, 1499295, 1499294, 1498587, 1498241, 1498149, 1497751, 1496463, 1496451, 1496160, 1496159, 1496155, 1495972, 1495734, 1495626, 1495625, 1495291, 1494602, 1494597, 1494398, 1494393, 1494146, 1494140, 1493935, 1493930, 1493925, 1493620, 1493515, 1493357, 1493109, 1492794, 1492580, 1492467, 1492459, 1492456, 1491802, 1491609, 1491607, 1491443, 1491068, 1490756, 1490609, 1490604, 1488952, 1488737, 1488616, 1488410, 1487995, 1487860, 1486987, 1486629, 1486568, 1486566, 1486327, 1486247, 1485824, 1485240, 1485239, 1485105, 1484980, 1484688, 1484676, 1484159, 1484154, 1483874, 1483356, 1483348, 1483344, 1483106, 1482930, 1482926, 1482925, 1482792, 1482778, 1482776, 1482772, 1480138, 1479977, 1479378, 1479257, 1478900, 1478342, 1478338, 1478013, 1477419, 1477416, 1476921, 1476600, 1476356, 1476347, 1475903, 1475873, 1475707, 1475573, 1475077, 1475072, 1474432, 1474431, 1473962, 1473950, 1473941, 1473758, 1473741, 1473381, 1473017, 1472684, 1472618, 1472611, 1472608, 1472600, 1472328, 1471728, 1471720, 1471484, 1471482, 1471476, 1471223, 1470704, 1470310, 1470165, 1469597, 1468943, 1468904, 1468696, 1468692, 1468684, 1467339, 1466846, 1466713, 1466708, 1466476, 1466324, 1466320, 1466317, 1465973, 1465959, 1465956, 1465955, 1465953, 1465556, 1465192, 1465185, 1464682, 1464670, 1464669, 1464668, 1464665, 1464664, 1464499, 1464379, 1464054, 1464043, 1464027, 1463814, 1463810, 1463381, 1463084, 1463082))
Run Time: 0.186210
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | 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: 12, 0, 1714827196, {"thread-1748445":["thread",1748445],"thread-1645491":["thread",1645491],"thread-1595841":["thread",1595841],"thread-1595226":["thread",1595226],"thread-1594125":["thread",1594125],"thread-1573800":["thread",1573800],"thread-1573612":["thread",1573612],"thread-1573595":["thread",1573595],"thread-1529090":["thread",1529090],"thread-1528244":["thread",1528244],"thread-1521518":["thread",1521518],"thread-1520768":["thread",1520768],"thread-1520128":["thread",1520128],"thread-1517901":["thread",1517901],"thread-1517891":["thread",1517891],"thread-1517436":["thread",1517436],"thread-1516590":["thread",1516590],"thread-1516574":["thread",1516574],"thread-1515714":["thread",1515714],"thread-1515433":["thread",1515433],"thread-1515429":["thread",1515429],"thread-1515428":["thread",1515428],"thread-1515422":["thread",1515422],"thread-1515133":["thread",1515133],"thread-1514393":["thread",1514393],"thread-1514383":["thread",1514383],"thread-1514189":["thread",1514189],"thread-1513974":["thread",1513974],"thread-1513946":["thread",1513946],"thread-1513846":["thread",1513846],"thread-1512890":["thread",1512890],"thread-1512884":["thread",1512884],"thread-1512735":["thread",1512735],"thread-1511052":["thread",1511052],"thread-1508090":["thread",1508090],"thread-1508080":["thread",1508080],"thread-1506597":["thread",1506597],"thread-1506594":["thread",1506594],"thread-1501865":["thread",1501865],"thread-1501467":["thread",1501467],"thread-1501450":["thread",1501450],"thread-1500831":["thread",1500831],"thread-1500144":["thread",1500144],"thread-1499295":["thread",1499295],"thread-1499294":["thread",1499294],"thread-1498587":["thread",1498587],"thread-1498241":["thread",1498241],"thread-1498149":["thread",1498149],"thread-1497751":["thread",1497751],"thread-1496463":["thread",1496463],"thread-1496451":["thread",1496451],"thread-1496160":["thread",1496160],"thread-1496159":["thread",1496159],"thread-1496155":["thread",1496155],"thread-1495972":["thread",1495972],"thread-1495734":["thread",1495734],"thread-1495626":["thread",1495626],"thread-1495625":["thread",1495625],"thread-1495291":["thread",1495291],"thread-1494602":["thread",1494602],"thread-1494597":["thread",1494597],"thread-1494398":["thread",1494398],"thread-1494393":["thread",1494393],"thread-1494146":["thread",1494146],"thread-1494140":["thread",1494140],"thread-1493935":["thread",1493935],"thread-1493930":["thread",1493930],"thread-1493925":["thread",1493925],"thread-1493620":["thread",1493620],"thread-1493515":["thread",1493515],"thread-1493357":["thread",1493357],"thread-1493109":["thread",1493109],"thread-1492794":["thread",1492794],"thread-1492580":["thread",1492580],"thread-1492467":["thread",1492467],"thread-1492459":["thread",1492459],"thread-1492456":["thread",1492456],"thread-1491802":["thread",1491802],"thread-1491609":["thread",1491609],"thread-1491607":["thread",1491607],"thread-1491443":["thread",1491443],"thread-1491068":["thread",1491068],"thread-1490756":["thread",1490756],"thread-1490609":["thread",1490609],"thread-1490604":["thread",1490604],"thread-1488952":["thread",1488952],"thread-1488737":["thread",1488737],"thread-1488616":["thread",1488616],"thread-1488410":["thread",1488410],"thread-1487995":["thread",1487995],"thread-1487860":["thread",1487860],"thread-1486987":["thread",1486987],"thread-1486629":["thread",1486629],"thread-1486568":["thread",1486568],"thread-1486566":["thread",1486566],"thread-1486327":["thread",1486327],"thread-1486247":["thread",1486247],"thread-1485824":["thread",1485824],"thread-1485240":["thread",1485240],"thread-1485239":["thread",1485239],"thread-1485105":["thread",1485105],"thread-1484980":["thread",1484980],"thread-1484688":["thread",1484688],"thread-1484676":["thread",1484676],"thread-1484159":["thread",1484159],"thread-1484154":["thread",1484154],"thread-1483874":["thread",1483874],"thread-1483356":["thread",1483356],"thread-1483348":["thread",1483348],"thread-1483344":["thread",1483344],"thread-1483106":["thread",1483106],"thread-1482930":["thread",1482930],"thread-1482926":["thread",1482926],"thread-1482925":["thread",1482925],"thread-1482792":["thread",1482792],"thread-1482778":["thread",1482778],"thread-1482776":["thread",1482776],"thread-1482772":["thread",1482772],"thread-1480138":["thread",1480138],"thread-1479977":["thread",1479977],"thread-1479378":["thread",1479378],"thread-1479257":["thread",1479257],"thread-1478900":["thread",1478900],"thread-1478342":["thread",1478342],"thread-1478338":["thread",1478338],"thread-1478013":["thread",1478013],"thread-1477419":["thread",1477419],"thread-1477416":["thread",1477416],"thread-1476921":["thread",1476921],"thread-1476600":["thread",1476600],"thread-1476356":["thread",1476356],"thread-1476347":["thread",1476347],"thread-1475903":["thread",1475903],"thread-1475873":["thread",1475873],"thread-1475707":["thread",1475707],"thread-1475573":["thread",1475573],"thread-1475077":["thread",1475077],"thread-1475072":["thread",1475072],"thread-1474432":["thread",1474432],"thread-1474431":["thread",1474431],"thread-1473962":["thread",1473962],"thread-1473950":["thread",1473950],"thread-1473941":["thread",1473941],"thread-1473758":["thread",1473758],"thread-1473741":["thread",1473741],"thread-1473381":["thread",1473381],"thread-1473017":["thread",1473017],"thread-1472684":["thread",1472684],"thread-1472618":["thread",1472618],"thread-1472611":["thread",1472611],"thread-1472608":["thread",1472608],"thread-1472600":["thread",1472600],"thread-1472328":["thread",1472328],"thread-1471728":["thread",1471728],"thread-1471720":["thread",1471720],"thread-1471484":["thread",1471484],"thread-1471482":["thread",1471482],"thread-1471476":["thread",1471476],"thread-1471223":["thread",1471223],"thread-1470704":["thread",1470704],"thread-1470310":["thread",1470310],"thread-1470165":["thread",1470165],"thread-1469597":["thread",1469597],"thread-1468943":["thread",1468943],"thread-1468904":["thread",1468904],"thread-1468696":["thread",1468696],"thread-1468692":["thread",1468692],"thread-1468684":["thread",1468684],"thread-1467339":["thread",1467339],"thread-1466846":["thread",1466846],"thread-1466713":["thread",1466713],"thread-1466708":["thread",1466708],"thread-1466476":["thread",1466476],"thread-1466324":["thread",1466324],"thread-1466320":["thread",1466320],"thread-1466317":["thread",1466317],"thread-1465973":["thread",1465973],"thread-1465959":["thread",1465959],"thread-1465956":["thread",1465956],"thread-1465955":["thread",1465955],"thread-1465953":["thread",1465953],"thread-1465556":["thread",1465556],"thread-1465192":["thread",1465192],"thread-1465185":["thread",1465185],"thread-1464682":["thread",1464682],"thread-1464670":["thread",1464670],"thread-1464669":["thread",1464669],"thread-1464668":["thread",1464668],"thread-1464665":["thread",1464665],"thread-1464664":["thread",1464664],"thread-1464499":["thread",1464499],"thread-1464379":["thread",1464379],"thread-1464054":["thread",1464054],"thread-1464043":["thread",1464043],"thread-1464027":["thread",1464027],"thread-1463814":["thread",1463814],"thread-1463810":["thread",1463810],"thread-1463381":["thread",1463381],"thread-1463084":["thread",1463084],"thread-1463082":["thread",1463082]}, , 1714823596
Run Time: 0.003625
- 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