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 (147184, 146291, 146280, 138069, 137943, 135763, 135587, 134416, 134129, 134106, 133992, 133929, 133835, 133520, 129461, 129210, 128989, 128988, 127528, 125537, 121970, 121175, 120355, 120354, 120344, 120343, 120342, 120341, 120336, 117989, 115764, 115715, 115714, 115688, 114361, 109462, 109440, 105450, 106195, 101185, 100691, 98605, 95195, 92357, 92161, 90801, 90796, 90788, 90784, 90760, 90587, 88669, 88577, 88555, 88551, 88550, 88548, 88539, 88538, 88537, 88534, 88521, 88518, 88517, 88513, 88509, 88325, 80397, 80393, 75141, 73102, 72932, 71561, 45951, 33119, 33118, 28672, 28216, 24586, 21966, 19149, 11074, 6224, 5391, 3408, 512, 511, 510))
Run Time: 0.044346
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 88 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,carder_admin_bd.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 1392
- 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 2731
- 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 2353
- XF\App->run() in src/XF.php at line 524
- 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: 169, 0, 1716232846, {"thread-147184":["thread",147184],"thread-146291":["thread",146291],"thread-146280":["thread",146280],"thread-138069":["thread",138069],"thread-137943":["thread",137943],"thread-135763":["thread",135763],"thread-135587":["thread",135587],"thread-134416":["thread",134416],"thread-134129":["thread",134129],"thread-134106":["thread",134106],"thread-133992":["thread",133992],"thread-133929":["thread",133929],"thread-133835":["thread",133835],"thread-133520":["thread",133520],"thread-129461":["thread",129461],"thread-129210":["thread",129210],"thread-128989":["thread",128989],"thread-128988":["thread",128988],"thread-127528":["thread",127528],"thread-125537":["thread",125537],"thread-121970":["thread",121970],"thread-121175":["thread",121175],"thread-120355":["thread",120355],"thread-120354":["thread",120354],"thread-120344":["thread",120344],"thread-120343":["thread",120343],"thread-120342":["thread",120342],"thread-120341":["thread",120341],"thread-120336":["thread",120336],"thread-117989":["thread",117989],"thread-115764":["thread",115764],"thread-115715":["thread",115715],"thread-115714":["thread",115714],"thread-115688":["thread",115688],"thread-114361":["thread",114361],"thread-109462":["thread",109462],"thread-109440":["thread",109440],"thread-105450":["thread",105450],"thread-106195":["thread",106195],"thread-101185":["thread",101185],"thread-100691":["thread",100691],"thread-98605":["thread",98605],"resource-142":["resource",142],"thread-95195":["thread",95195],"thread-92357":["thread",92357],"xfmg_media-91":["xfmg_media",91],"xfmg_media-83":["xfmg_media",83],"xfmg_media-82":["xfmg_media",82],"thread-92161":["thread",92161],"xfmg_media-45":["xfmg_media",45],"thread-90801":["thread",90801],"thread-90796":["thread",90796],"thread-90788":["thread",90788],"thread-90784":["thread",90784],"thread-90760":["thread",90760],"thread-90587":["thread",90587],"thread-88669":["thread",88669],"thread-88577":["thread",88577],"thread-88555":["thread",88555],"thread-88551":["thread",88551],"thread-88550":["thread",88550],"thread-88548":["thread",88548],"thread-88539":["thread",88539],"thread-88538":["thread",88538],"thread-88537":["thread",88537],"thread-88534":["thread",88534],"thread-88521":["thread",88521],"thread-88518":["thread",88518],"thread-88517":["thread",88517],"thread-88513":["thread",88513],"thread-88509":["thread",88509],"thread-88325":["thread",88325],"thread-80397":["thread",80397],"thread-80393":["thread",80393],"thread-75141":["thread",75141],"thread-73102":["thread",73102],"thread-72932":["thread",72932],"thread-71561":["thread",71561],"thread-45951":["thread",45951],"thread-33119":["thread",33119],"thread-33118":["thread",33118],"thread-28672":["thread",28672],"thread-28216":["thread",28216],"thread-24586":["thread",24586],"thread-21966":["thread",21966],"thread-19149":["thread",19149],"thread-11074":["thread",11074],"thread-6224":["thread",6224],"thread-5391":["thread",5391],"thread-3408":["thread",3408],"thread-512":["thread",512],"thread-511":["thread",511],"thread-510":["thread",510]}, NULL, 1716229246
Run Time: 0.001529
- 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 1516
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1248
- 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 2353
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20