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 (183076, 182585, 182181, 181378, 181335, 180112, 179239, 176520, 175999, 173466, 171103, 170924, 170443, 170219, 168169, 167489, 167461, 167013, 167001, 166927, 166695, 165083, 164191, 162774, 162770, 161739, 161680, 161416, 160229, 159317, 159316, 157973, 156892, 156669, 156621, 156603, 153836, 152529, 149218, 149139, 148963, 141780, 138875, 138594, 138406, 137552, 136800, 135896, 135271, 134760, 134373, 131220, 130664, 129863, 129426, 128356, 128188, 127592, 126259, 126248, 126232, 125906, 124141, 124012, 123906, 123628, 123171, 123164, 123162, 123066, 122693, 122546, 122277, 121424, 119751, 119729, 119556, 119168, 118255, 117831, 116797, 116278, 116100, 115858, 114659, 114410, 114402, 114009, 112884, 111760, 111400, 111188, 110788, 110764, 110748, 109972, 109626, 109411, 108477, 108029, 108018, 107310, 106460, 105182, 105128, 104938, 104120, 104001, 103755, 100491, 99776, 99241, 97134, 96595, 96422, 96334, 95874, 94940, 94814, 94381, 93627, 93138, 92978, 92925, 92636, 92600, 92148, 92145, 91407, 91365, 90049, 89979, 89233, 86983, 78055, 75955, 72152, 71829, 71721, 70621, 58806, 54683, 52671, 52670, 51970, 51969, 51968, 51965, 51963, 51573, 51508, 36436, 35310, 32667, 28387, 26414, 4047))
Run Time: 0.153199
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 157 | 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: 3462, 0, 1716009309, {"thread-183076":["thread",183076],"thread-182585":["thread",182585],"thread-182181":["thread",182181],"thread-181378":["thread",181378],"thread-181335":["thread",181335],"thread-180112":["thread",180112],"thread-179239":["thread",179239],"thread-176520":["thread",176520],"thread-175999":["thread",175999],"thread-173466":["thread",173466],"thread-171103":["thread",171103],"thread-170924":["thread",170924],"thread-170443":["thread",170443],"thread-170219":["thread",170219],"thread-168169":["thread",168169],"thread-167489":["thread",167489],"thread-167461":["thread",167461],"thread-167013":["thread",167013],"thread-167001":["thread",167001],"thread-166927":["thread",166927],"thread-166695":["thread",166695],"thread-165083":["thread",165083],"thread-164191":["thread",164191],"thread-162774":["thread",162774],"thread-162770":["thread",162770],"thread-161739":["thread",161739],"thread-161680":["thread",161680],"thread-161416":["thread",161416],"thread-160229":["thread",160229],"thread-159317":["thread",159317],"thread-159316":["thread",159316],"thread-157973":["thread",157973],"ams_article-4309":["ams_article",4309],"thread-156892":["thread",156892],"thread-156669":["thread",156669],"thread-156621":["thread",156621],"thread-156603":["thread",156603],"thread-153836":["thread",153836],"thread-152529":["thread",152529],"thread-149218":["thread",149218],"thread-149139":["thread",149139],"thread-148963":["thread",148963],"thread-141780":["thread",141780],"thread-138875":["thread",138875],"thread-138594":["thread",138594],"thread-138406":["thread",138406],"thread-137552":["thread",137552],"thread-136800":["thread",136800],"thread-135896":["thread",135896],"thread-135271":["thread",135271],"thread-134760":["thread",134760],"thread-134373":["thread",134373],"thread-131220":["thread",131220],"thread-130664":["thread",130664],"thread-129863":["thread",129863],"thread-129426":["thread",129426],"thread-128356":["thread",128356],"thread-128188":["thread",128188],"thread-127592":["thread",127592],"thread-126259":["thread",126259],"thread-126248":["thread",126248],"thread-126232":["thread",126232],"thread-125906":["thread",125906],"thread-124141":["thread",124141],"thread-124012":["thread",124012],"thread-123906":["thread",123906],"thread-123628":["thread",123628],"thread-123171":["thread",123171],"thread-123164":["thread",123164],"thread-123162":["thread",123162],"thread-123066":["thread",123066],"thread-122693":["thread",122693],"thread-122546":["thread",122546],"thread-122277":["thread",122277],"thread-121424":["thread",121424],"thread-119751":["thread",119751],"thread-119729":["thread",119729],"thread-119556":["thread",119556],"thread-119168":["thread",119168],"thread-118255":["thread",118255],"thread-117831":["thread",117831],"thread-116797":["thread",116797],"thread-116278":["thread",116278],"thread-116100":["thread",116100],"thread-115858":["thread",115858],"thread-114659":["thread",114659],"thread-114410":["thread",114410],"thread-114402":["thread",114402],"thread-114009":["thread",114009],"thread-112884":["thread",112884],"thread-111760":["thread",111760],"thread-111400":["thread",111400],"thread-111188":["thread",111188],"thread-110788":["thread",110788],"thread-110764":["thread",110764],"thread-110748":["thread",110748],"thread-109972":["thread",109972],"thread-109626":["thread",109626],"thread-109411":["thread",109411],"thread-108477":["thread",108477],"thread-108029":["thread",108029],"thread-108018":["thread",108018],"thread-107310":["thread",107310],"thread-106460":["thread",106460],"thread-105182":["thread",105182],"thread-105128":["thread",105128],"thread-104938":["thread",104938],"thread-104120":["thread",104120],"thread-104001":["thread",104001],"thread-103755":["thread",103755],"thread-100491":["thread",100491],"thread-99776":["thread",99776],"thread-99241":["thread",99241],"thread-97134":["thread",97134],"thread-96595":["thread",96595],"thread-96422":["thread",96422],"thread-96334":["thread",96334],"thread-95874":["thread",95874],"thread-94940":["thread",94940],"thread-94814":["thread",94814],"thread-94381":["thread",94381],"thread-93627":["thread",93627],"thread-93138":["thread",93138],"thread-92978":["thread",92978],"thread-92925":["thread",92925],"thread-92636":["thread",92636],"thread-92600":["thread",92600],"thread-92148":["thread",92148],"thread-92145":["thread",92145],"thread-91407":["thread",91407],"thread-91365":["thread",91365],"thread-90049":["thread",90049],"thread-89979":["thread",89979],"thread-89233":["thread",89233],"thread-86983":["thread",86983],"thread-78055":["thread",78055],"thread-75955":["thread",75955],"thread-72152":["thread",72152],"thread-71829":["thread",71829],"thread-71721":["thread",71721],"thread-70621":["thread",70621],"thread-58806":["thread",58806],"thread-54683":["thread",54683],"thread-52671":["thread",52671],"thread-52670":["thread",52670],"thread-51970":["thread",51970],"thread-51969":["thread",51969],"thread-51968":["thread",51968],"thread-51965":["thread",51965],"thread-51963":["thread",51963],"thread-51573":["thread",51573],"thread-51508":["thread",51508],"thread-36436":["thread",36436],"thread-35310":["thread",35310],"thread-32667":["thread",32667],"thread-28387":["thread",28387],"thread-26414":["thread",26414],"thread-4047":["thread",4047]}, , 1716005709
Run Time: 0.000336
- 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