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 (183869, 173460, 165272, 162835, 159580, 158778, 158124, 158104, 154987, 152057, 147411, 131888, 131831, 131245, 131135, 130632, 130191, 130047, 129894, 128075, 128063, 127901, 127638, 127609, 127077, 125479, 125458, 124209, 124143, 124019, 123687, 123521, 123444, 122789, 122729, 122345, 122140, 121880, 121607, 119910, 119474, 119473, 118971, 118786, 118276, 117727, 117562, 117481, 117477, 117304, 116008, 115682, 115425, 115390, 114972, 114694, 114317, 112666, 112147, 112088, 111847, 110181, 109789, 109774, 108450, 106398, 105956, 105898, 105334, 104902, 104134, 102937, 102833, 102515, 100597, 98322, 98164, 97176, 96099, 95694, 95443, 95420, 95295, 95099, 94520, 94045, 93763, 92375, 92356, 92332, 92049, 92024, 91982, 91280, 90965, 90551, 90158, 89924, 89832, 89737, 89653, 89468, 89190, 88966, 88686, 88615, 88587, 87671, 87600, 87362, 86893, 86620, 86381, 86235, 86186, 86151, 86084, 85998, 85733, 85492, 85485, 85293, 85011, 84501, 84213, 84180, 84094, 84019, 83944, 83023, 82878, 82848, 82446, 81622, 81160, 81075, 79795, 79615, 79162, 79064, 79054, 78670, 78644, 78484, 77890, 77171, 77035, 76677, 76215, 76081, 75656, 75544, 75248, 74957, 74511, 74476, 74441, 74406, 74360, 74300, 74243, 73768, 73689, 73503, 73418, 73417, 73164, 73156, 72848, 72676, 72674, 72514, 72344, 72325, 72163, 72153, 72139, 72092, 72071, 71946, 71938, 71908, 71842, 71816, 71809, 71527, 71458, 71273, 71018, 70997, 70655, 70541, 70498, 70407, 70339))
Run Time: 0.085277
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 195 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 2729
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 467, 0, 1716984416, {"thread-183869":["thread",183869],"thread-173460":["thread",173460],"ams_article-4944":["ams_article",4944],"ams_article-4727":["ams_article",4727],"thread-165272":["thread",165272],"ams_article-4610":["ams_article",4610],"thread-162835":["thread",162835],"thread-159580":["thread",159580],"thread-158778":["thread",158778],"thread-158124":["thread",158124],"thread-158104":["thread",158104],"thread-154987":["thread",154987],"thread-152057":["thread",152057],"thread-147411":["thread",147411],"ams_article-3590":["ams_article",3590],"ams_article-3013":["ams_article",3013],"thread-131888":["thread",131888],"thread-131831":["thread",131831],"thread-131245":["thread",131245],"thread-131135":["thread",131135],"thread-130632":["thread",130632],"thread-130191":["thread",130191],"thread-130047":["thread",130047],"thread-129894":["thread",129894],"thread-128075":["thread",128075],"thread-128063":["thread",128063],"thread-127901":["thread",127901],"thread-127638":["thread",127638],"thread-127609":["thread",127609],"thread-127077":["thread",127077],"thread-125479":["thread",125479],"thread-125458":["thread",125458],"thread-124209":["thread",124209],"thread-124143":["thread",124143],"thread-124019":["thread",124019],"thread-123687":["thread",123687],"thread-123521":["thread",123521],"thread-123444":["thread",123444],"thread-122789":["thread",122789],"thread-122729":["thread",122729],"thread-122345":["thread",122345],"thread-122140":["thread",122140],"thread-121880":["thread",121880],"thread-121607":["thread",121607],"thread-119910":["thread",119910],"thread-119474":["thread",119474],"thread-119473":["thread",119473],"thread-118971":["thread",118971],"thread-118786":["thread",118786],"thread-118276":["thread",118276],"thread-117727":["thread",117727],"thread-117562":["thread",117562],"thread-117481":["thread",117481],"thread-117477":["thread",117477],"thread-117304":["thread",117304],"thread-116008":["thread",116008],"thread-115682":["thread",115682],"thread-115425":["thread",115425],"thread-115390":["thread",115390],"thread-114972":["thread",114972],"thread-114694":["thread",114694],"thread-114317":["thread",114317],"thread-112666":["thread",112666],"thread-112147":["thread",112147],"thread-112088":["thread",112088],"thread-111847":["thread",111847],"thread-110181":["thread",110181],"thread-109789":["thread",109789],"thread-109774":["thread",109774],"thread-108450":["thread",108450],"thread-106398":["thread",106398],"thread-105956":["thread",105956],"thread-105898":["thread",105898],"thread-105334":["thread",105334],"thread-104902":["thread",104902],"thread-104134":["thread",104134],"thread-102937":["thread",102937],"thread-102833":["thread",102833],"thread-102515":["thread",102515],"thread-100597":["thread",100597],"thread-98322":["thread",98322],"thread-98164":["thread",98164],"thread-97176":["thread",97176],"thread-96099":["thread",96099],"thread-95694":["thread",95694],"thread-95443":["thread",95443],"thread-95420":["thread",95420],"thread-95295":["thread",95295],"thread-95099":["thread",95099],"thread-94520":["thread",94520],"thread-94045":["thread",94045],"thread-93763":["thread",93763],"thread-92375":["thread",92375],"thread-92356":["thread",92356],"thread-92332":["thread",92332],"thread-92049":["thread",92049],"thread-92024":["thread",92024],"thread-91982":["thread",91982],"thread-91280":["thread",91280],"thread-90965":["thread",90965],"thread-90551":["thread",90551],"thread-90158":["thread",90158],"thread-89924":["thread",89924],"thread-89832":["thread",89832],"thread-89737":["thread",89737],"thread-89653":["thread",89653],"thread-89468":["thread",89468],"thread-89190":["thread",89190],"thread-88966":["thread",88966],"thread-88686":["thread",88686],"thread-88615":["thread",88615],"thread-88587":["thread",88587],"thread-87671":["thread",87671],"thread-87600":["thread",87600],"thread-87362":["thread",87362],"thread-86893":["thread",86893],"thread-86620":["thread",86620],"thread-86381":["thread",86381],"thread-86235":["thread",86235],"thread-86186":["thread",86186],"thread-86151":["thread",86151],"thread-86084":["thread",86084],"thread-85998":["thread",85998],"thread-85733":["thread",85733],"thread-85492":["thread",85492],"thread-85485":["thread",85485],"thread-85293":["thread",85293],"thread-85011":["thread",85011],"thread-84501":["thread",84501],"thread-84213":["thread",84213],"thread-84180":["thread",84180],"thread-84094":["thread",84094],"thread-84019":["thread",84019],"thread-83944":["thread",83944],"thread-83023":["thread",83023],"thread-82878":["thread",82878],"thread-82848":["thread",82848],"thread-82446":["thread",82446],"thread-81622":["thread",81622],"thread-81160":["thread",81160],"thread-81075":["thread",81075],"thread-79795":["thread",79795],"thread-79615":["thread",79615],"thread-79162":["thread",79162],"thread-79064":["thread",79064],"thread-79054":["thread",79054],"thread-78670":["thread",78670],"thread-78644":["thread",78644],"thread-78484":["thread",78484],"thread-77890":["thread",77890],"thread-77171":["thread",77171],"thread-77035":["thread",77035],"thread-76677":["thread",76677],"thread-76215":["thread",76215],"thread-76081":["thread",76081],"thread-75656":["thread",75656],"thread-75544":["thread",75544],"thread-75248":["thread",75248],"thread-74957":["thread",74957],"thread-74511":["thread",74511],"thread-74476":["thread",74476],"thread-74441":["thread",74441],"thread-74406":["thread",74406],"thread-74360":["thread",74360],"thread-74300":["thread",74300],"thread-74243":["thread",74243],"thread-73768":["thread",73768],"thread-73689":["thread",73689],"thread-73503":["thread",73503],"thread-73418":["thread",73418],"thread-73417":["thread",73417],"thread-73164":["thread",73164],"thread-73156":["thread",73156],"thread-72848":["thread",72848],"thread-72676":["thread",72676],"thread-72674":["thread",72674],"thread-72514":["thread",72514],"thread-72344":["thread",72344],"thread-72325":["thread",72325],"thread-72163":["thread",72163],"thread-72153":["thread",72153],"thread-72139":["thread",72139],"thread-72092":["thread",72092],"thread-72071":["thread",72071],"thread-71946":["thread",71946],"thread-71938":["thread",71938],"thread-71908":["thread",71908],"thread-71842":["thread",71842],"thread-71816":["thread",71816],"thread-71809":["thread",71809],"thread-71527":["thread",71527],"thread-71458":["thread",71458],"thread-71273":["thread",71273],"thread-71018":["thread",71018],"thread-70997":["thread",70997],"thread-70655":["thread",70655],"thread-70541":["thread",70541],"thread-70498":["thread",70498],"thread-70407":["thread",70407],"thread-70339":["thread",70339]}, , 1716980816
Run Time: 0.000685
- 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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20