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 (1797442, 1793046, 1781265, 1781259, 1775251, 1709854, 1659158, 1657155, 1651403, 1651367, 1640037, 1639967, 1638746, 1637176, 1633212, 1631955, 1631917, 1619541, 1614337, 1609373, 1606889, 1601521, 1601222, 1599990, 1588443, 1583608, 1579318, 1578103, 1578038, 1576748, 1575766, 1574410, 1573712, 1573612, 1570716, 1563974, 1558429, 1557922, 1557505, 1556765, 1556549, 1556085, 1549601, 1549000, 1548486, 1547990, 1544388, 1543065, 1542149, 1541922, 1540236, 1537945, 1534257, 1534136, 1533433, 1532332, 1531826, 1530909, 1530669, 1529445, 1528068, 1526645, 1526639, 1524592, 1523115, 1523112, 1523095, 1522544, 1519569, 1519384, 1519379, 1518643, 1516386, 1515714, 1515433, 1515408, 1515337, 1515132, 1515128, 1514240, 1513972, 1513926, 1513854, 1513850, 1513846, 1513382, 1512898, 1512052, 1511839, 1511345, 1510179, 1509912, 1509355, 1507546, 1505391, 1504806, 1504469, 1504463, 1503867, 1501448, 1501367, 1500482, 1499469, 1499289, 1498576, 1498572, 1496544, 1496451, 1496279, 1496159, 1496096, 1495626, 1494967, 1494886, 1494143, 1493820, 1492455, 1492106, 1489350, 1489208, 1488630, 1488627, 1488573, 1487237, 1487047, 1486926, 1486736, 1486561, 1485822, 1485105, 1484980, 1484644, 1484276, 1484264, 1484241, 1484156, 1484034, 1483874, 1483360, 1483348, 1482860, 1482724, 1482495, 1482490, 1481918, 1481822, 1481405, 1480569, 1480135, 1479775, 1478687, 1478338, 1477972, 1477281, 1477261, 1476859, 1476853, 1476608, 1476598, 1475761, 1475507, 1475417, 1474325, 1474282, 1473767, 1473764, 1473687, 1473684, 1473384, 1473070, 1472687, 1472644, 1472096, 1471911, 1471905, 1471800, 1471742, 1471726, 1471227, 1470308, 1470306, 1470303, 1469810, 1469597, 1468907, 1468706, 1467326, 1466711, 1466327, 1465976, 1465972, 1465958, 1465407, 1465273, 1464928, 1464876, 1464672, 1464382, 1464379, 1463814))
Run Time: 0.183138
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: 81, 0, 1714683318, {"thread-1797442":["thread",1797442],"thread-1793046":["thread",1793046],"thread-1781265":["thread",1781265],"thread-1781259":["thread",1781259],"thread-1775251":["thread",1775251],"thread-1709854":["thread",1709854],"thread-1659158":["thread",1659158],"thread-1657155":["thread",1657155],"thread-1651403":["thread",1651403],"thread-1651367":["thread",1651367],"thread-1640037":["thread",1640037],"thread-1639967":["thread",1639967],"thread-1638746":["thread",1638746],"thread-1637176":["thread",1637176],"thread-1633212":["thread",1633212],"thread-1631955":["thread",1631955],"thread-1631917":["thread",1631917],"thread-1619541":["thread",1619541],"thread-1614337":["thread",1614337],"thread-1609373":["thread",1609373],"thread-1606889":["thread",1606889],"thread-1601521":["thread",1601521],"thread-1601222":["thread",1601222],"thread-1599990":["thread",1599990],"thread-1588443":["thread",1588443],"thread-1583608":["thread",1583608],"thread-1579318":["thread",1579318],"thread-1578103":["thread",1578103],"thread-1578038":["thread",1578038],"thread-1576748":["thread",1576748],"thread-1575766":["thread",1575766],"thread-1574410":["thread",1574410],"thread-1573712":["thread",1573712],"thread-1573612":["thread",1573612],"thread-1570716":["thread",1570716],"thread-1563974":["thread",1563974],"thread-1558429":["thread",1558429],"thread-1557922":["thread",1557922],"thread-1557505":["thread",1557505],"thread-1556765":["thread",1556765],"thread-1556549":["thread",1556549],"thread-1556085":["thread",1556085],"thread-1549601":["thread",1549601],"thread-1549000":["thread",1549000],"thread-1548486":["thread",1548486],"thread-1547990":["thread",1547990],"thread-1544388":["thread",1544388],"thread-1543065":["thread",1543065],"thread-1542149":["thread",1542149],"thread-1541922":["thread",1541922],"thread-1540236":["thread",1540236],"thread-1537945":["thread",1537945],"thread-1534257":["thread",1534257],"thread-1534136":["thread",1534136],"thread-1533433":["thread",1533433],"thread-1532332":["thread",1532332],"thread-1531826":["thread",1531826],"thread-1530909":["thread",1530909],"thread-1530669":["thread",1530669],"thread-1529445":["thread",1529445],"thread-1528068":["thread",1528068],"thread-1526645":["thread",1526645],"thread-1526639":["thread",1526639],"thread-1524592":["thread",1524592],"thread-1523115":["thread",1523115],"thread-1523112":["thread",1523112],"thread-1523095":["thread",1523095],"thread-1522544":["thread",1522544],"thread-1519569":["thread",1519569],"thread-1519384":["thread",1519384],"thread-1519379":["thread",1519379],"thread-1518643":["thread",1518643],"thread-1516386":["thread",1516386],"thread-1515714":["thread",1515714],"thread-1515433":["thread",1515433],"thread-1515408":["thread",1515408],"thread-1515337":["thread",1515337],"thread-1515132":["thread",1515132],"thread-1515128":["thread",1515128],"thread-1514240":["thread",1514240],"thread-1513972":["thread",1513972],"thread-1513926":["thread",1513926],"thread-1513854":["thread",1513854],"thread-1513850":["thread",1513850],"thread-1513846":["thread",1513846],"thread-1513382":["thread",1513382],"thread-1512898":["thread",1512898],"thread-1512052":["thread",1512052],"thread-1511839":["thread",1511839],"thread-1511345":["thread",1511345],"thread-1510179":["thread",1510179],"thread-1509912":["thread",1509912],"thread-1509355":["thread",1509355],"thread-1507546":["thread",1507546],"thread-1505391":["thread",1505391],"thread-1504806":["thread",1504806],"thread-1504469":["thread",1504469],"thread-1504463":["thread",1504463],"thread-1503867":["thread",1503867],"thread-1501448":["thread",1501448],"thread-1501367":["thread",1501367],"thread-1500482":["thread",1500482],"thread-1499469":["thread",1499469],"thread-1499289":["thread",1499289],"thread-1498576":["thread",1498576],"thread-1498572":["thread",1498572],"thread-1496544":["thread",1496544],"thread-1496451":["thread",1496451],"thread-1496279":["thread",1496279],"thread-1496159":["thread",1496159],"thread-1496096":["thread",1496096],"thread-1495626":["thread",1495626],"thread-1494967":["thread",1494967],"thread-1494886":["thread",1494886],"thread-1494143":["thread",1494143],"thread-1493820":["thread",1493820],"thread-1492455":["thread",1492455],"thread-1492106":["thread",1492106],"thread-1489350":["thread",1489350],"thread-1488630":["thread",1488630],"thread-1488627":["thread",1488627],"thread-1488573":["thread",1488573],"thread-1487237":["thread",1487237],"thread-1487047":["thread",1487047],"thread-1486926":["thread",1486926],"thread-1486736":["thread",1486736],"thread-1486561":["thread",1486561],"thread-1485822":["thread",1485822],"thread-1485105":["thread",1485105],"thread-1484980":["thread",1484980],"thread-1484644":["thread",1484644],"thread-1484276":["thread",1484276],"thread-1484264":["thread",1484264],"thread-1484241":["thread",1484241],"thread-1484156":["thread",1484156],"thread-1484034":["thread",1484034],"thread-1483874":["thread",1483874],"thread-1483360":["thread",1483360],"thread-1483348":["thread",1483348],"thread-1482860":["thread",1482860],"thread-1482724":["thread",1482724],"thread-1482495":["thread",1482495],"thread-1482490":["thread",1482490],"thread-1481918":["thread",1481918],"thread-1481822":["thread",1481822],"thread-1481405":["thread",1481405],"thread-1480569":["thread",1480569],"thread-1480135":["thread",1480135],"thread-1479775":["thread",1479775],"thread-1478687":["thread",1478687],"thread-1478338":["thread",1478338],"thread-1477972":["thread",1477972],"thread-1477281":["thread",1477281],"thread-1477261":["thread",1477261],"thread-1476859":["thread",1476859],"thread-1476853":["thread",1476853],"thread-1476608":["thread",1476608],"thread-1476598":["thread",1476598],"thread-1475761":["thread",1475761],"thread-1475507":["thread",1475507],"thread-1475417":["thread",1475417],"thread-1474325":["thread",1474325],"thread-1474282":["thread",1474282],"thread-1473767":["thread",1473767],"thread-1473764":["thread",1473764],"thread-1473687":["thread",1473687],"thread-1473684":["thread",1473684],"thread-1473384":["thread",1473384],"thread-1473070":["thread",1473070],"thread-1472687":["thread",1472687],"thread-1472644":["thread",1472644],"thread-1472096":["thread",1472096],"thread-1471911":["thread",1471911],"thread-1471905":["thread",1471905],"thread-1471800":["thread",1471800],"thread-1471742":["thread",1471742],"thread-1471726":["thread",1471726],"thread-1471227":["thread",1471227],"thread-1470308":["thread",1470308],"thread-1470306":["thread",1470306],"thread-1470303":["thread",1470303],"thread-1469810":["thread",1469810],"thread-1469597":["thread",1469597],"thread-1468907":["thread",1468907],"thread-1468706":["thread",1468706],"thread-1467326":["thread",1467326],"thread-1466711":["thread",1466711],"thread-1466327":["thread",1466327],"thread-1465976":["thread",1465976],"thread-1465972":["thread",1465972],"thread-1465958":["thread",1465958],"thread-1465407":["thread",1465407],"thread-1465273":["thread",1465273],"thread-1464928":["thread",1464928],"thread-1464876":["thread",1464876],"thread-1464672":["thread",1464672],"thread-1464382":["thread",1464382],"thread-1464379":["thread",1464379],"thread-1463814":["thread",1463814]}, , 1714679718
Run Time: 0.003450
- 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