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 (182230, 181921, 180787, 177407, 176633, 176099, 175566, 173348, 171852, 171637, 169144, 168088, 165967, 164475, 159885, 159744, 157273, 155590, 155552, 155369, 155368, 155366, 155365, 129915, 129902, 129662, 125175, 124896, 124351, 124222, 121261, 121041, 118329, 118328, 112687, 112503, 111949, 108307, 107417, 106767, 106714, 102413, 99334, 98305, 97701, 96357, 94176, 92701, 92001, 91339, 89839, 88772, 88771, 86408, 86407, 85630, 85500, 84792, 83604, 81711, 81436, 80612, 78829, 77883, 77702, 77701, 77068, 75036, 74870, 74426, 72704, 72404, 72301, 70579, 70160, 70149, 69993, 69409, 68690, 68688, 66977, 65412, 64821, 63512, 63273, 62888, 62477, 62288, 62261, 60567, 59900, 58462, 58421, 55403, 53604, 51433, 50336, 50101, 50088, 49716, 49517, 48781, 47880, 47852, 47584, 45579, 44218, 42502, 41117, 40592, 36466, 36329, 36327, 36239, 35714, 34443, 34375, 33901, 33165, 32943, 32841, 32550, 32536, 32372, 31907, 31296, 30788, 30684, 29358, 28878, 28798, 27940, 27906, 27663, 27639, 27051, 26366, 25134, 24895, 24867, 24790, 23540, 23331, 23245, 22942, 22713, 22262, 22241, 22104, 21654, 21512, 21210, 20939, 20805, 20286, 17259, 17249, 17198, 17120, 17099, 16602, 16537, 15087, 14792, 14556, 14038, 13856, 12874, 11681, 10489, 10051, 10049, 10048, 9942, 4656, 8582, 8501, 8048, 7845, 7498, 7470, 7296, 7133, 7116, 7115, 7114, 6727, 6614, 6581, 6415, 6333, 5985, 5661, 4134, 4956, 3920, 3742, 3824, 3634, 3608))
Run Time: 0.100036
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: 112, 0, 1716022592, {"thread-182230":["thread",182230],"thread-181921":["thread",181921],"thread-180787":["thread",180787],"thread-176633":["thread",176633],"thread-176099":["thread",176099],"thread-175566":["thread",175566],"thread-173348":["thread",173348],"thread-171852":["thread",171852],"thread-171637":["thread",171637],"thread-169144":["thread",169144],"thread-168088":["thread",168088],"thread-165967":["thread",165967],"thread-164475":["thread",164475],"thread-159885":["thread",159885],"thread-159744":["thread",159744],"thread-157273":["thread",157273],"thread-155590":["thread",155590],"thread-155552":["thread",155552],"thread-129915":["thread",129915],"thread-129902":["thread",129902],"thread-129662":["thread",129662],"thread-125175":["thread",125175],"thread-124896":["thread",124896],"thread-124351":["thread",124351],"thread-124222":["thread",124222],"thread-121261":["thread",121261],"thread-121041":["thread",121041],"thread-118329":["thread",118329],"thread-118328":["thread",118328],"thread-112687":["thread",112687],"thread-112503":["thread",112503],"thread-111949":["thread",111949],"thread-108307":["thread",108307],"thread-107417":["thread",107417],"thread-106767":["thread",106767],"thread-106714":["thread",106714],"thread-102413":["thread",102413],"thread-99334":["thread",99334],"thread-98305":["thread",98305],"thread-97701":["thread",97701],"thread-96357":["thread",96357],"thread-94176":["thread",94176],"thread-92701":["thread",92701],"thread-92001":["thread",92001],"thread-91339":["thread",91339],"thread-89839":["thread",89839],"thread-88772":["thread",88772],"thread-88771":["thread",88771],"thread-86408":["thread",86408],"thread-86407":["thread",86407],"thread-85630":["thread",85630],"thread-85500":["thread",85500],"thread-84792":["thread",84792],"thread-83604":["thread",83604],"thread-81711":["thread",81711],"thread-81436":["thread",81436],"thread-80612":["thread",80612],"thread-78829":["thread",78829],"thread-77883":["thread",77883],"thread-77702":["thread",77702],"thread-77701":["thread",77701],"thread-77068":["thread",77068],"thread-75036":["thread",75036],"thread-74870":["thread",74870],"thread-74426":["thread",74426],"thread-72704":["thread",72704],"thread-72404":["thread",72404],"thread-72301":["thread",72301],"thread-70579":["thread",70579],"thread-70160":["thread",70160],"thread-70149":["thread",70149],"thread-69993":["thread",69993],"thread-69409":["thread",69409],"thread-68690":["thread",68690],"thread-68688":["thread",68688],"thread-66977":["thread",66977],"thread-65412":["thread",65412],"thread-64821":["thread",64821],"thread-63512":["thread",63512],"thread-63273":["thread",63273],"thread-62888":["thread",62888],"thread-62477":["thread",62477],"thread-62288":["thread",62288],"thread-62261":["thread",62261],"thread-60567":["thread",60567],"thread-59900":["thread",59900],"thread-58462":["thread",58462],"thread-58421":["thread",58421],"thread-55403":["thread",55403],"thread-53604":["thread",53604],"thread-51433":["thread",51433],"thread-50336":["thread",50336],"thread-50101":["thread",50101],"thread-50088":["thread",50088],"thread-49716":["thread",49716],"thread-49517":["thread",49517],"thread-48781":["thread",48781],"thread-47880":["thread",47880],"thread-47852":["thread",47852],"thread-47584":["thread",47584],"thread-45579":["thread",45579],"thread-44218":["thread",44218],"thread-42502":["thread",42502],"thread-41117":["thread",41117],"thread-40592":["thread",40592],"thread-36466":["thread",36466],"thread-36329":["thread",36329],"thread-36327":["thread",36327],"thread-36239":["thread",36239],"thread-35714":["thread",35714],"thread-34443":["thread",34443],"thread-34375":["thread",34375],"thread-33901":["thread",33901],"thread-33165":["thread",33165],"thread-32943":["thread",32943],"thread-32841":["thread",32841],"thread-32550":["thread",32550],"thread-32536":["thread",32536],"thread-32372":["thread",32372],"thread-31907":["thread",31907],"thread-31296":["thread",31296],"thread-30788":["thread",30788],"thread-30684":["thread",30684],"thread-29358":["thread",29358],"thread-28878":["thread",28878],"thread-28798":["thread",28798],"thread-27940":["thread",27940],"thread-27906":["thread",27906],"thread-27663":["thread",27663],"thread-27639":["thread",27639],"thread-27051":["thread",27051],"thread-26366":["thread",26366],"thread-25134":["thread",25134],"thread-24895":["thread",24895],"thread-24867":["thread",24867],"thread-24790":["thread",24790],"thread-23540":["thread",23540],"thread-23331":["thread",23331],"thread-23245":["thread",23245],"thread-22942":["thread",22942],"thread-22713":["thread",22713],"thread-22262":["thread",22262],"thread-22241":["thread",22241],"thread-22104":["thread",22104],"thread-21654":["thread",21654],"thread-21512":["thread",21512],"thread-21210":["thread",21210],"thread-20939":["thread",20939],"thread-20805":["thread",20805],"thread-20286":["thread",20286],"thread-17259":["thread",17259],"thread-17249":["thread",17249],"thread-17198":["thread",17198],"thread-17120":["thread",17120],"thread-17099":["thread",17099],"thread-16602":["thread",16602],"thread-16537":["thread",16537],"thread-15087":["thread",15087],"thread-14792":["thread",14792],"thread-14556":["thread",14556],"thread-14038":["thread",14038],"thread-13856":["thread",13856],"thread-12874":["thread",12874],"thread-11681":["thread",11681],"thread-10489":["thread",10489],"thread-10051":["thread",10051],"thread-10049":["thread",10049],"thread-10048":["thread",10048],"thread-9942":["thread",9942],"thread-4656":["thread",4656],"thread-8582":["thread",8582],"thread-8501":["thread",8501],"thread-8048":["thread",8048],"thread-7845":["thread",7845],"thread-7498":["thread",7498],"thread-7470":["thread",7470],"thread-7296":["thread",7296],"thread-7133":["thread",7133],"thread-7116":["thread",7116],"thread-7115":["thread",7115],"thread-7114":["thread",7114],"thread-6727":["thread",6727],"thread-6614":["thread",6614],"thread-6581":["thread",6581],"thread-6415":["thread",6415],"thread-6333":["thread",6333],"thread-5985":["thread",5985],"thread-5661":["thread",5661],"thread-4134":["thread",4134],"thread-4956":["thread",4956],"thread-3920":["thread",3920],"thread-3742":["thread",3742],"thread-3824":["thread",3824],"thread-3634":["thread",3634],"thread-3608":["thread",3608]}, , 1716018992
Run Time: 0.000824
- 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