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 (25787, 25786, 25739, 25738, 25733, 25732, 25731, 25728, 25727, 25726, 25723, 25722, 25721, 25720, 25718, 25714, 25688, 25672, 25645, 25644, 25630, 25568, 25566, 25537, 25529, 25528, 25526, 25525, 25505, 25504, 25493, 25478, 25475, 25443, 25442, 25250, 25069, 25047, 25031, 24986, 24864, 24760, 24723, 24681, 24676, 24634, 24632, 24592, 24582, 24576, 24547, 24485, 24474, 24464, 24463, 24406, 24405, 24379, 24309, 24306, 24305, 24303, 24258, 24183, 24176, 24166, 24144, 24137, 24136, 24135, 24134, 23799, 23798, 23749, 23748, 23747, 23744, 23718, 23680, 23675, 23674, 23672, 23671, 23662, 23660, 23659, 23653, 23630, 23578, 23538, 23534, 23533, 23532, 23531, 23529, 23526, 23520, 23514, 23510, 23509, 23508, 23507, 23502, 23472, 23382, 23377, 23373, 23351, 23350, 23311, 23258, 23253, 23233, 23226, 23208, 23207, 23199, 23160, 23084, 23068, 23066, 23064, 23062, 22974, 22973, 22959, 22811, 22793, 22792, 22700, 22699, 22641, 22603, 22579, 22578, 22568, 22566, 22565, 22462, 22424, 22411, 22410, 22399, 22395, 22394, 22393, 22389, 22376, 22373, 22372, 22249, 22239, 22002, 21945, 16692, 5454))
Run Time: 0.038807
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 156 | 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: 134, 0, 1713589721, {"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-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-25069":["thread",25069],"thread-25047":["thread",25047],"thread-25031":["thread",25031],"thread-24986":["thread",24986],"thread-24864":["thread",24864],"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-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-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-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-23680":["thread",23680],"thread-23675":["thread",23675],"thread-23674":["thread",23674],"thread-23672":["thread",23672],"thread-23671":["thread",23671],"thread-23662":["thread",23662],"thread-23660":["thread",23660],"thread-23659":["thread",23659],"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-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-23084":["thread",23084],"thread-23068":["thread",23068],"thread-23066":["thread",23066],"thread-23064":["thread",23064],"thread-23062":["thread",23062],"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-22700":["thread",22700],"thread-22699":["thread",22699],"thread-22641":["thread",22641],"thread-22603":["thread",22603],"thread-22579":["thread",22579],"thread-22578":["thread",22578],"thread-22568":["thread",22568],"thread-22566":["thread",22566],"thread-22565":["thread",22565],"thread-22462":["thread",22462],"thread-22424":["thread",22424],"thread-22411":["thread",22411],"thread-22410":["thread",22410],"thread-22399":["thread",22399],"thread-22395":["thread",22395],"thread-22394":["thread",22394],"thread-22393":["thread",22393],"thread-22389":["thread",22389],"thread-22376":["thread",22376],"thread-22373":["thread",22373],"thread-22372":["thread",22372],"thread-22249":["thread",22249],"thread-22239":["thread",22239],"thread-22002":["thread",22002],"thread-21945":["thread",21945],"thread-16692":["thread",16692],"thread-5454":["thread",5454]}, , 1713586121
Run Time: 0.003068
- 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