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 (29883, 29882, 29865, 29668, 29590, 29461, 29432, 29412, 29404, 29398, 29361, 29360, 29331, 29307, 29072, 29070, 29069, 28828, 28808, 28785, 28764, 28729, 28590, 28524, 28363, 28334, 28067, 28054, 28006, 27982, 27871, 27781, 27733, 27647, 27514, 27322, 27198, 27197, 27196, 27142, 26934, 26549, 26518, 26375, 26239, 26092, 25868, 25787, 25786, 25739, 25738, 25733, 25732, 25731, 25728, 25727, 25726, 25723, 25722, 25721, 25720, 25718, 25714, 25688, 25679, 25672, 25645, 25644, 25630, 25568, 25566, 25537, 25529, 25528, 25526, 25525, 25505, 25504, 25493, 25478, 25475, 25443, 25442, 25250, 25222, 25069, 25047, 25031, 24986, 24904, 24864, 24839, 24760, 24723, 24681, 24676, 24634, 24632, 24592, 24582, 24576, 24555, 24547, 24485, 24474, 24464, 24463, 24406, 24405, 24379, 24322, 24309, 24306, 24305, 24303, 24258, 24183, 24176, 24166, 24144, 24137, 24136, 24135, 24134, 24114, 24007, 23799, 23798, 23749, 23748, 23747, 23744, 23718, 23712, 23707, 23680, 23675, 23674, 23672, 23671, 23662, 23661, 23660, 23659, 23656, 23653, 23630, 23578, 23538, 23534, 23533, 23532, 23531, 23529, 23526, 23520, 23514, 23510, 23509, 23508, 23507, 23502, 23472, 23382, 23377, 23373, 23351, 23350, 23311, 23265, 23258, 23253, 23233, 23226, 23208, 23207, 23199, 23160, 23132, 23084, 23079, 23078, 23077, 23069, 23068, 23066, 23065, 23064, 23063, 23062, 23057, 23052, 23019, 22974, 22973, 22959, 22811, 22793, 22792, 22714))
Run Time: 0.037509
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 | hcxf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | hcxf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | hcxf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | hcxf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,hcxf.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2543
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 729
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- 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: 135, 0, 1713625000, {"thread-29883":["thread",29883],"thread-29882":["thread",29882],"thread-29865":["thread",29865],"thread-29668":["thread",29668],"thread-29590":["thread",29590],"thread-29461":["thread",29461],"thread-29432":["thread",29432],"thread-29412":["thread",29412],"thread-29404":["thread",29404],"thread-29398":["thread",29398],"thread-29361":["thread",29361],"thread-29360":["thread",29360],"thread-29331":["thread",29331],"thread-29307":["thread",29307],"thread-29072":["thread",29072],"thread-29070":["thread",29070],"thread-29069":["thread",29069],"thread-28828":["thread",28828],"thread-28808":["thread",28808],"thread-28785":["thread",28785],"thread-28764":["thread",28764],"thread-28729":["thread",28729],"thread-28590":["thread",28590],"thread-28524":["thread",28524],"thread-28363":["thread",28363],"thread-28334":["thread",28334],"thread-28067":["thread",28067],"thread-28054":["thread",28054],"thread-28006":["thread",28006],"thread-27982":["thread",27982],"thread-27871":["thread",27871],"thread-27781":["thread",27781],"thread-27733":["thread",27733],"thread-27647":["thread",27647],"thread-27514":["thread",27514],"thread-27322":["thread",27322],"thread-27198":["thread",27198],"thread-27197":["thread",27197],"thread-27196":["thread",27196],"thread-27142":["thread",27142],"thread-26934":["thread",26934],"thread-26549":["thread",26549],"thread-26518":["thread",26518],"thread-26375":["thread",26375],"thread-26239":["thread",26239],"thread-26092":["thread",26092],"thread-25868":["thread",25868],"thread-25787":["thread",25787],"thread-25786":["thread",25786],"thread-25739":["thread",25739],"thread-25738":["thread",25738],"thread-25733":["thread",25733],"thread-25732":["thread",25732],"thread-25731":["thread",25731],"thread-25728":["thread",25728],"thread-25727":["thread",25727],"thread-25726":["thread",25726],"thread-25723":["thread",25723],"thread-25722":["thread",25722],"thread-25721":["thread",25721],"thread-25720":["thread",25720],"thread-25718":["thread",25718],"thread-25714":["thread",25714],"thread-25688":["thread",25688],"thread-25679":["thread",25679],"thread-25672":["thread",25672],"thread-25645":["thread",25645],"thread-25644":["thread",25644],"thread-25630":["thread",25630],"thread-25568":["thread",25568],"thread-25566":["thread",25566],"thread-25537":["thread",25537],"thread-25529":["thread",25529],"thread-25528":["thread",25528],"thread-25526":["thread",25526],"thread-25525":["thread",25525],"thread-25505":["thread",25505],"thread-25504":["thread",25504],"thread-25493":["thread",25493],"thread-25478":["thread",25478],"thread-25475":["thread",25475],"thread-25443":["thread",25443],"thread-25442":["thread",25442],"thread-25250":["thread",25250],"thread-25222":["thread",25222],"thread-25069":["thread",25069],"thread-25047":["thread",25047],"thread-25031":["thread",25031],"thread-24986":["thread",24986],"thread-24904":["thread",24904],"thread-24864":["thread",24864],"thread-24839":["thread",24839],"thread-24760":["thread",24760],"thread-24723":["thread",24723],"thread-24681":["thread",24681],"thread-24676":["thread",24676],"thread-24634":["thread",24634],"thread-24632":["thread",24632],"thread-24592":["thread",24592],"thread-24582":["thread",24582],"thread-24576":["thread",24576],"thread-24555":["thread",24555],"thread-24547":["thread",24547],"thread-24485":["thread",24485],"thread-24474":["thread",24474],"thread-24464":["thread",24464],"thread-24463":["thread",24463],"thread-24406":["thread",24406],"thread-24405":["thread",24405],"thread-24379":["thread",24379],"thread-24322":["thread",24322],"thread-24309":["thread",24309],"thread-24306":["thread",24306],"thread-24305":["thread",24305],"thread-24303":["thread",24303],"thread-24258":["thread",24258],"thread-24183":["thread",24183],"thread-24176":["thread",24176],"thread-24166":["thread",24166],"thread-24144":["thread",24144],"thread-24137":["thread",24137],"thread-24136":["thread",24136],"thread-24135":["thread",24135],"thread-24134":["thread",24134],"thread-24114":["thread",24114],"thread-24007":["thread",24007],"thread-23799":["thread",23799],"thread-23798":["thread",23798],"thread-23749":["thread",23749],"thread-23748":["thread",23748],"thread-23747":["thread",23747],"thread-23744":["thread",23744],"thread-23718":["thread",23718],"thread-23712":["thread",23712],"thread-23707":["thread",23707],"thread-23680":["thread",23680],"thread-23675":["thread",23675],"thread-23674":["thread",23674],"thread-23672":["thread",23672],"thread-23671":["thread",23671],"thread-23662":["thread",23662],"thread-23661":["thread",23661],"thread-23660":["thread",23660],"thread-23659":["thread",23659],"thread-23656":["thread",23656],"thread-23653":["thread",23653],"thread-23630":["thread",23630],"thread-23578":["thread",23578],"thread-23538":["thread",23538],"thread-23534":["thread",23534],"thread-23533":["thread",23533],"thread-23532":["thread",23532],"thread-23531":["thread",23531],"thread-23529":["thread",23529],"thread-23526":["thread",23526],"thread-23520":["thread",23520],"thread-23514":["thread",23514],"thread-23510":["thread",23510],"thread-23509":["thread",23509],"thread-23508":["thread",23508],"thread-23507":["thread",23507],"thread-23502":["thread",23502],"thread-23472":["thread",23472],"thread-23382":["thread",23382],"thread-23377":["thread",23377],"thread-23373":["thread",23373],"thread-23351":["thread",23351],"thread-23350":["thread",23350],"thread-23311":["thread",23311],"thread-23265":["thread",23265],"thread-23258":["thread",23258],"thread-23253":["thread",23253],"thread-23233":["thread",23233],"thread-23226":["thread",23226],"thread-23208":["thread",23208],"thread-23207":["thread",23207],"thread-23199":["thread",23199],"thread-23160":["thread",23160],"thread-23132":["thread",23132],"thread-23084":["thread",23084],"thread-23079":["thread",23079],"thread-23078":["thread",23078],"thread-23077":["thread",23077],"thread-23069":["thread",23069],"thread-23068":["thread",23068],"thread-23066":["thread",23066],"thread-23065":["thread",23065],"thread-23064":["thread",23064],"thread-23063":["thread",23063],"thread-23062":["thread",23062],"thread-23057":["thread",23057],"thread-23052":["thread",23052],"thread-23019":["thread",23019],"thread-22974":["thread",22974],"thread-22973":["thread",22973],"thread-22959":["thread",22959],"thread-22811":["thread",22811],"thread-22793":["thread",22793],"thread-22792":["thread",22792],"thread-22714":["thread",22714]}, , 1713621400
Run Time: 0.004754
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 221
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1452
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1184
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20