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 (1698234, 1669948, 1654450, 1653882, 1636933, 1635753, 1633941, 1633001, 1630989, 1629296, 1627662, 1625510, 1622159, 1616497, 1611960, 1605739, 1603591, 1598387, 1597128, 1596651, 1596494, 1594344, 1592497, 1591826, 1591398, 1591009, 1590320, 1589863, 1589608, 1588210, 1587730, 1586809, 1586117, 1585216, 1582523, 1581852, 1580616, 1572763, 1571010, 1569671, 1569180, 1569062, 1568646, 1568309, 1568288, 1567508, 1567012, 1566148, 1565935, 1565862, 1565534, 1564557, 1564295, 1564218, 1563591, 1563504, 1563132, 1563123, 1562792, 1562334, 1562140, 1561865, 1561626, 1561137, 1560540, 1560532, 1559855, 1559812, 1558711, 1551871, 1551870, 1551868, 1549926, 1549850, 1549297, 1547523, 1546058, 1545974, 1545004, 1544806, 1541378, 1540583, 1537537, 1537510, 1536937, 1535751, 1535342, 1534107, 1533849, 1530834, 1528891, 1527783, 1526707, 1525631, 1524690, 1524687, 1524242, 1520274, 1518854, 1518600, 1515345, 1515344, 1515341, 1512459, 1511093, 1510838, 1510485, 1510331, 1509802, 1509787, 1509569, 1509561, 1507783, 1507422, 1507192, 1506840, 1506839, 1506145, 1506144, 1505855, 1505746, 1505392, 1504805, 1504482, 1504100, 1504076, 1503450, 1503296, 1502708, 1500367, 1498643, 1498625, 1497876, 1495920, 1495823, 1492967, 1491094, 1489678, 1489391, 1489107, 1488493, 1488481, 1483437, 1482863, 1482593, 1480728, 1480279, 1477967, 1477204, 1476938, 1476746, 1476710, 1476039, 1474703, 1474208, 1473856, 1473129, 1472785, 1472758, 1472305, 1472108, 1471809, 1471798, 1471731, 1471226, 1471222, 1471166, 1471154, 1470674, 1469927, 1469925, 1469369, 1469062, 1469060, 1469048, 1468866, 1468625, 1466973, 1466842, 1466473, 1466134, 1465333, 1464608, 1464096, 1463102, 1462710, 1462537, 1462082, 1461892, 1461797, 1461639, 1461501, 1461379, 1461200, 1461064, 1460731, 1460610, 1460154, 1459961, 1459501))
Run Time: 0.260276
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: 80, 0, 1714674980, {"thread-1698234":["thread",1698234],"thread-1669948":["thread",1669948],"thread-1654450":["thread",1654450],"thread-1653882":["thread",1653882],"thread-1636933":["thread",1636933],"thread-1635753":["thread",1635753],"thread-1633941":["thread",1633941],"thread-1633001":["thread",1633001],"thread-1630989":["thread",1630989],"thread-1629296":["thread",1629296],"thread-1627662":["thread",1627662],"thread-1625510":["thread",1625510],"thread-1622159":["thread",1622159],"thread-1616497":["thread",1616497],"thread-1611960":["thread",1611960],"thread-1605739":["thread",1605739],"thread-1603591":["thread",1603591],"thread-1598387":["thread",1598387],"thread-1597128":["thread",1597128],"thread-1596651":["thread",1596651],"thread-1596494":["thread",1596494],"thread-1594344":["thread",1594344],"thread-1592497":["thread",1592497],"thread-1591826":["thread",1591826],"thread-1591398":["thread",1591398],"thread-1591009":["thread",1591009],"thread-1590320":["thread",1590320],"thread-1589863":["thread",1589863],"thread-1589608":["thread",1589608],"thread-1588210":["thread",1588210],"thread-1587730":["thread",1587730],"thread-1586809":["thread",1586809],"thread-1586117":["thread",1586117],"thread-1585216":["thread",1585216],"thread-1582523":["thread",1582523],"thread-1581852":["thread",1581852],"thread-1580616":["thread",1580616],"thread-1572763":["thread",1572763],"thread-1571010":["thread",1571010],"thread-1569671":["thread",1569671],"thread-1569180":["thread",1569180],"thread-1569062":["thread",1569062],"thread-1568646":["thread",1568646],"thread-1568309":["thread",1568309],"thread-1568288":["thread",1568288],"thread-1567508":["thread",1567508],"thread-1567012":["thread",1567012],"thread-1566148":["thread",1566148],"thread-1565935":["thread",1565935],"thread-1565862":["thread",1565862],"thread-1565534":["thread",1565534],"thread-1564557":["thread",1564557],"thread-1564295":["thread",1564295],"thread-1564218":["thread",1564218],"thread-1563591":["thread",1563591],"thread-1563504":["thread",1563504],"thread-1563132":["thread",1563132],"thread-1563123":["thread",1563123],"thread-1562792":["thread",1562792],"thread-1562334":["thread",1562334],"thread-1562140":["thread",1562140],"thread-1561865":["thread",1561865],"thread-1561626":["thread",1561626],"thread-1561137":["thread",1561137],"thread-1560540":["thread",1560540],"thread-1560532":["thread",1560532],"thread-1559855":["thread",1559855],"thread-1559812":["thread",1559812],"thread-1558711":["thread",1558711],"thread-1551871":["thread",1551871],"thread-1551870":["thread",1551870],"thread-1551868":["thread",1551868],"thread-1549926":["thread",1549926],"thread-1549850":["thread",1549850],"thread-1549297":["thread",1549297],"thread-1547523":["thread",1547523],"thread-1546058":["thread",1546058],"thread-1545974":["thread",1545974],"thread-1545004":["thread",1545004],"thread-1544806":["thread",1544806],"thread-1541378":["thread",1541378],"thread-1540583":["thread",1540583],"thread-1537537":["thread",1537537],"thread-1537510":["thread",1537510],"thread-1536937":["thread",1536937],"thread-1535751":["thread",1535751],"thread-1535342":["thread",1535342],"thread-1534107":["thread",1534107],"thread-1533849":["thread",1533849],"thread-1530834":["thread",1530834],"thread-1528891":["thread",1528891],"thread-1527783":["thread",1527783],"thread-1526707":["thread",1526707],"thread-1525631":["thread",1525631],"thread-1524690":["thread",1524690],"thread-1524687":["thread",1524687],"thread-1524242":["thread",1524242],"thread-1520274":["thread",1520274],"thread-1518854":["thread",1518854],"thread-1518600":["thread",1518600],"thread-1515345":["thread",1515345],"thread-1515344":["thread",1515344],"thread-1515341":["thread",1515341],"thread-1512459":["thread",1512459],"thread-1511093":["thread",1511093],"thread-1510838":["thread",1510838],"thread-1510485":["thread",1510485],"thread-1510331":["thread",1510331],"thread-1509802":["thread",1509802],"thread-1509787":["thread",1509787],"thread-1509569":["thread",1509569],"thread-1509561":["thread",1509561],"thread-1507783":["thread",1507783],"thread-1507422":["thread",1507422],"thread-1507192":["thread",1507192],"thread-1506840":["thread",1506840],"thread-1506839":["thread",1506839],"thread-1506145":["thread",1506145],"thread-1506144":["thread",1506144],"thread-1505855":["thread",1505855],"thread-1505746":["thread",1505746],"thread-1505392":["thread",1505392],"thread-1504805":["thread",1504805],"thread-1504482":["thread",1504482],"thread-1504100":["thread",1504100],"thread-1504076":["thread",1504076],"thread-1503450":["thread",1503450],"thread-1503296":["thread",1503296],"thread-1502708":["thread",1502708],"thread-1500367":["thread",1500367],"thread-1498643":["thread",1498643],"thread-1498625":["thread",1498625],"thread-1497876":["thread",1497876],"thread-1495920":["thread",1495920],"thread-1495823":["thread",1495823],"thread-1492967":["thread",1492967],"thread-1491094":["thread",1491094],"thread-1489678":["thread",1489678],"thread-1489391":["thread",1489391],"thread-1489107":["thread",1489107],"thread-1488493":["thread",1488493],"thread-1488481":["thread",1488481],"thread-1483437":["thread",1483437],"thread-1482863":["thread",1482863],"thread-1482593":["thread",1482593],"thread-1480728":["thread",1480728],"thread-1480279":["thread",1480279],"thread-1477967":["thread",1477967],"thread-1477204":["thread",1477204],"thread-1476938":["thread",1476938],"thread-1476746":["thread",1476746],"thread-1476710":["thread",1476710],"thread-1476039":["thread",1476039],"thread-1474703":["thread",1474703],"thread-1474208":["thread",1474208],"thread-1473856":["thread",1473856],"thread-1473129":["thread",1473129],"thread-1472785":["thread",1472785],"thread-1472758":["thread",1472758],"thread-1472305":["thread",1472305],"thread-1472108":["thread",1472108],"thread-1471809":["thread",1471809],"thread-1471798":["thread",1471798],"thread-1471731":["thread",1471731],"thread-1471226":["thread",1471226],"thread-1471222":["thread",1471222],"thread-1471166":["thread",1471166],"thread-1471154":["thread",1471154],"thread-1470674":["thread",1470674],"thread-1469927":["thread",1469927],"thread-1469925":["thread",1469925],"thread-1469369":["thread",1469369],"thread-1469062":["thread",1469062],"thread-1469060":["thread",1469060],"thread-1469048":["thread",1469048],"thread-1468866":["thread",1468866],"thread-1468625":["thread",1468625],"thread-1466973":["thread",1466973],"thread-1466842":["thread",1466842],"thread-1466473":["thread",1466473],"thread-1466134":["thread",1466134],"thread-1465333":["thread",1465333],"thread-1464608":["thread",1464608],"thread-1464096":["thread",1464096],"thread-1463102":["thread",1463102],"thread-1462710":["thread",1462710],"thread-1462537":["thread",1462537],"thread-1462082":["thread",1462082],"thread-1461892":["thread",1461892],"thread-1461797":["thread",1461797],"thread-1461639":["thread",1461639],"thread-1461501":["thread",1461501],"thread-1461379":["thread",1461379],"thread-1461200":["thread",1461200],"thread-1461064":["thread",1461064],"thread-1460731":["thread",1460731],"thread-1460610":["thread",1460610],"thread-1460154":["thread",1460154],"thread-1459961":["thread",1459961],"thread-1459501":["thread",1459501]}, , 1714671380
Run Time: 0.004503
- 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