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 (181254, 165005, 158760, 153642, 150903, 150708, 147424, 144027, 137690, 137012, 132853, 131752, 130622, 130577, 130345, 130084, 130081, 129888, 129357, 129141, 129132, 129024, 129016, 128944, 128891, 128889, 128338, 127871, 127696, 127639, 127619, 127565, 127535, 127518, 127286, 127081, 126646, 126064, 125890, 124891, 124348, 124335, 124110, 123634, 123529, 123203, 123153, 122947, 122903, 122680, 122633, 122116, 121400, 121377, 121339, 121321, 121059, 121007, 120844, 120619, 119879, 119870, 119797, 119585, 119432, 119192, 119141, 118262, 117735, 117731, 117730, 117040, 117022, 116989, 116452, 116089, 115219, 114240, 113716, 113114, 112350, 112196, 111953, 111898, 111737, 111722, 111666, 111331, 110974, 110946, 110396, 110243, 109704, 109520, 109365, 109234, 109227, 109225, 109210, 109152, 108998, 108963, 108853, 108140, 107881, 107629, 107323, 106867, 106525, 105439, 105321, 105266, 105178, 105118, 104581, 104027, 103485, 103403, 103342, 102957, 102956, 102934, 102817, 102736, 102197, 101922, 101915, 101856, 101846, 101812, 101137, 100990, 100955, 100317, 99972, 99624, 99420, 98623, 98042, 98036, 97977, 97263, 97114, 96833, 96323, 95969, 95875, 95801, 95398, 94836, 94065, 93331, 93098, 92720, 92078, 91910, 91652, 91589, 91396, 91301, 91300, 91223, 90535, 90512, 90155, 90037, 89976, 89717, 89501, 89416, 89388, 88958, 88796, 87809, 87716, 87696, 87271, 86954, 86060, 84500, 84235, 84194, 84150, 84148, 83480, 79544, 79520, 79456, 79298, 78439, 78050, 77270, 77017, 76978, 76889, 76813, 76806, 76523, 76051, 75874))
Run Time: 0.091907
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 | 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: 2394, 0, 1714710997, {"thread-181254":["thread",181254],"thread-165005":["thread",165005],"thread-158760":["thread",158760],"thread-153642":["thread",153642],"thread-150903":["thread",150903],"thread-150708":["thread",150708],"thread-147424":["thread",147424],"thread-144027":["thread",144027],"thread-137690":["thread",137690],"thread-137012":["thread",137012],"thread-132853":["thread",132853],"thread-131752":["thread",131752],"thread-130622":["thread",130622],"thread-130577":["thread",130577],"thread-130345":["thread",130345],"thread-130084":["thread",130084],"thread-130081":["thread",130081],"thread-129888":["thread",129888],"thread-129357":["thread",129357],"thread-129141":["thread",129141],"thread-129132":["thread",129132],"thread-129024":["thread",129024],"thread-129016":["thread",129016],"thread-128944":["thread",128944],"thread-128891":["thread",128891],"thread-128889":["thread",128889],"thread-128338":["thread",128338],"thread-127871":["thread",127871],"thread-127696":["thread",127696],"thread-127639":["thread",127639],"thread-127619":["thread",127619],"thread-127565":["thread",127565],"thread-127535":["thread",127535],"thread-127518":["thread",127518],"thread-127286":["thread",127286],"thread-127081":["thread",127081],"thread-126646":["thread",126646],"thread-126064":["thread",126064],"thread-125890":["thread",125890],"thread-124891":["thread",124891],"thread-124348":["thread",124348],"thread-124335":["thread",124335],"thread-124110":["thread",124110],"thread-123634":["thread",123634],"thread-123529":["thread",123529],"thread-123203":["thread",123203],"thread-123153":["thread",123153],"thread-122947":["thread",122947],"thread-122903":["thread",122903],"thread-122680":["thread",122680],"thread-122633":["thread",122633],"thread-122116":["thread",122116],"thread-121400":["thread",121400],"thread-121377":["thread",121377],"thread-121339":["thread",121339],"thread-121321":["thread",121321],"thread-121059":["thread",121059],"thread-121007":["thread",121007],"thread-120844":["thread",120844],"thread-120619":["thread",120619],"thread-119879":["thread",119879],"thread-119870":["thread",119870],"thread-119797":["thread",119797],"thread-119585":["thread",119585],"thread-119432":["thread",119432],"thread-119192":["thread",119192],"thread-119141":["thread",119141],"thread-118262":["thread",118262],"thread-117735":["thread",117735],"thread-117731":["thread",117731],"thread-117730":["thread",117730],"thread-117040":["thread",117040],"thread-117022":["thread",117022],"thread-116989":["thread",116989],"thread-116452":["thread",116452],"thread-116089":["thread",116089],"thread-115219":["thread",115219],"thread-114240":["thread",114240],"thread-113716":["thread",113716],"thread-113114":["thread",113114],"thread-112350":["thread",112350],"thread-112196":["thread",112196],"thread-111953":["thread",111953],"thread-111898":["thread",111898],"thread-111737":["thread",111737],"thread-111722":["thread",111722],"thread-111666":["thread",111666],"thread-111331":["thread",111331],"thread-110974":["thread",110974],"thread-110946":["thread",110946],"thread-110396":["thread",110396],"thread-110243":["thread",110243],"thread-109704":["thread",109704],"thread-109520":["thread",109520],"thread-109365":["thread",109365],"thread-109234":["thread",109234],"thread-109227":["thread",109227],"thread-109225":["thread",109225],"thread-109210":["thread",109210],"thread-109152":["thread",109152],"thread-108998":["thread",108998],"thread-108963":["thread",108963],"thread-108853":["thread",108853],"thread-108140":["thread",108140],"thread-107881":["thread",107881],"thread-107629":["thread",107629],"thread-107323":["thread",107323],"thread-106867":["thread",106867],"thread-106525":["thread",106525],"thread-105439":["thread",105439],"thread-105321":["thread",105321],"thread-105266":["thread",105266],"thread-105178":["thread",105178],"thread-105118":["thread",105118],"thread-104581":["thread",104581],"thread-104027":["thread",104027],"thread-103485":["thread",103485],"thread-103403":["thread",103403],"thread-103342":["thread",103342],"thread-102957":["thread",102957],"thread-102956":["thread",102956],"thread-102934":["thread",102934],"thread-102817":["thread",102817],"thread-102736":["thread",102736],"thread-102197":["thread",102197],"thread-101922":["thread",101922],"thread-101915":["thread",101915],"thread-101846":["thread",101846],"thread-101812":["thread",101812],"thread-101137":["thread",101137],"thread-100990":["thread",100990],"thread-100955":["thread",100955],"thread-100317":["thread",100317],"thread-99972":["thread",99972],"thread-99624":["thread",99624],"thread-99420":["thread",99420],"thread-98623":["thread",98623],"thread-98042":["thread",98042],"thread-98036":["thread",98036],"thread-97977":["thread",97977],"thread-97263":["thread",97263],"thread-97114":["thread",97114],"thread-96833":["thread",96833],"thread-96323":["thread",96323],"thread-95969":["thread",95969],"thread-95875":["thread",95875],"thread-95801":["thread",95801],"thread-95398":["thread",95398],"thread-94836":["thread",94836],"thread-94065":["thread",94065],"thread-93331":["thread",93331],"thread-93098":["thread",93098],"thread-92720":["thread",92720],"thread-92078":["thread",92078],"thread-91910":["thread",91910],"thread-91652":["thread",91652],"thread-91589":["thread",91589],"thread-91396":["thread",91396],"thread-91301":["thread",91301],"thread-91300":["thread",91300],"thread-91223":["thread",91223],"thread-90512":["thread",90512],"thread-90155":["thread",90155],"thread-90037":["thread",90037],"thread-89976":["thread",89976],"thread-89717":["thread",89717],"thread-89501":["thread",89501],"thread-89416":["thread",89416],"thread-89388":["thread",89388],"thread-88958":["thread",88958],"thread-88796":["thread",88796],"thread-87809":["thread",87809],"thread-87716":["thread",87716],"thread-87696":["thread",87696],"thread-87271":["thread",87271],"thread-86954":["thread",86954],"thread-86060":["thread",86060],"thread-84500":["thread",84500],"thread-84235":["thread",84235],"thread-84194":["thread",84194],"thread-84150":["thread",84150],"thread-84148":["thread",84148],"thread-83480":["thread",83480],"thread-79544":["thread",79544],"thread-79520":["thread",79520],"thread-79456":["thread",79456],"thread-79298":["thread",79298],"thread-78439":["thread",78439],"thread-78050":["thread",78050],"thread-77270":["thread",77270],"thread-77017":["thread",77017],"thread-76978":["thread",76978],"thread-76889":["thread",76889],"thread-76813":["thread",76813],"thread-76806":["thread",76806],"thread-76523":["thread",76523],"thread-76051":["thread",76051],"thread-75874":["thread",75874]}, , 1714707397
Run Time: 0.000363
- 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