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 (183080, 183014, 182945, 182919, 181946, 181155, 181007, 180977, 180819, 180661, 180650, 180165, 180164, 180137, 179484, 179476, 179415, 178874, 178634, 178347, 178160, 175950, 175922, 175304, 175072, 174531, 174207, 173758, 173755, 173450, 172678, 172630, 171960, 171680, 171403, 170969, 170686, 170294, 169756, 169558, 169513, 168966, 168704, 168685, 168294, 168198, 168066, 167874, 167856, 167397, 167384, 167198, 166837, 166641, 166563, 166394, 166067, 165880, 165838, 165305, 164022, 163902, 163840, 163839, 163747, 163384, 163244, 162639, 162597, 162169, 161791, 161531, 161374, 161351, 160809, 160786, 160613, 160534, 159467, 159380, 159146, 159140, 158959, 158141, 157766, 157722, 157641, 157440, 157386, 157191, 156665, 156592, 156358, 156073, 156027, 155456, 154838, 153115, 153106, 152243, 151953, 151813, 151697, 148299, 146642, 141651, 139681, 136267, 132995, 132607, 130563, 130116, 129964, 129003, 126989, 126525, 125051, 124472, 124455, 124391, 122488, 122410, 121859, 121209, 120947, 120165, 117450, 115188, 113374, 112721, 112288, 111683, 111281, 110713, 108577, 105564, 103170, 101447, 101333, 101276, 95661, 93600, 91641, 91261, 90359, 85847, 85520, 84740, 74917, 73214, 70035, 68653, 67780, 61187, 59108, 57867, 56611, 55988, 54104, 53743, 52011, 51540, 50239, 45264, 41448, 23078, 4359))
Run Time: 0.112445
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 167 | 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: 1282, 0, 1715185520, {"thread-183080":["thread",183080],"thread-183014":["thread",183014],"thread-182945":["thread",182945],"thread-182919":["thread",182919],"thread-181946":["thread",181946],"thread-181155":["thread",181155],"thread-181007":["thread",181007],"thread-180977":["thread",180977],"thread-180819":["thread",180819],"thread-180661":["thread",180661],"thread-180650":["thread",180650],"thread-180165":["thread",180165],"thread-180164":["thread",180164],"thread-180137":["thread",180137],"thread-179484":["thread",179484],"thread-179476":["thread",179476],"thread-179415":["thread",179415],"thread-178874":["thread",178874],"thread-178634":["thread",178634],"thread-178347":["thread",178347],"thread-178160":["thread",178160],"thread-175950":["thread",175950],"thread-175922":["thread",175922],"thread-175304":["thread",175304],"thread-175072":["thread",175072],"thread-174531":["thread",174531],"thread-174207":["thread",174207],"thread-173758":["thread",173758],"thread-173755":["thread",173755],"thread-173450":["thread",173450],"thread-172678":["thread",172678],"thread-172630":["thread",172630],"thread-171960":["thread",171960],"thread-171680":["thread",171680],"thread-171403":["thread",171403],"thread-170969":["thread",170969],"thread-170686":["thread",170686],"thread-170294":["thread",170294],"thread-169756":["thread",169756],"thread-169558":["thread",169558],"thread-169513":["thread",169513],"thread-168966":["thread",168966],"thread-168704":["thread",168704],"thread-168685":["thread",168685],"thread-168294":["thread",168294],"thread-168198":["thread",168198],"thread-168066":["thread",168066],"thread-167874":["thread",167874],"thread-167856":["thread",167856],"thread-167397":["thread",167397],"thread-167384":["thread",167384],"thread-167198":["thread",167198],"thread-166837":["thread",166837],"thread-166641":["thread",166641],"thread-166563":["thread",166563],"thread-166394":["thread",166394],"thread-166067":["thread",166067],"thread-165880":["thread",165880],"thread-165838":["thread",165838],"thread-165305":["thread",165305],"thread-164022":["thread",164022],"thread-163902":["thread",163902],"thread-163840":["thread",163840],"thread-163839":["thread",163839],"thread-163747":["thread",163747],"thread-163384":["thread",163384],"thread-163244":["thread",163244],"thread-162639":["thread",162639],"thread-162597":["thread",162597],"thread-162169":["thread",162169],"thread-161791":["thread",161791],"thread-161531":["thread",161531],"thread-161374":["thread",161374],"thread-161351":["thread",161351],"thread-160809":["thread",160809],"thread-160786":["thread",160786],"thread-160613":["thread",160613],"thread-160534":["thread",160534],"thread-159467":["thread",159467],"thread-159380":["thread",159380],"thread-159146":["thread",159146],"thread-159140":["thread",159140],"thread-158959":["thread",158959],"thread-158141":["thread",158141],"thread-157766":["thread",157766],"thread-157722":["thread",157722],"thread-157641":["thread",157641],"thread-157440":["thread",157440],"thread-157386":["thread",157386],"thread-157191":["thread",157191],"thread-156665":["thread",156665],"thread-156592":["thread",156592],"thread-156358":["thread",156358],"thread-156073":["thread",156073],"thread-156027":["thread",156027],"thread-155456":["thread",155456],"thread-154838":["thread",154838],"thread-153115":["thread",153115],"thread-153106":["thread",153106],"thread-152243":["thread",152243],"thread-151953":["thread",151953],"thread-151813":["thread",151813],"thread-151697":["thread",151697],"thread-148299":["thread",148299],"thread-146642":["thread",146642],"thread-141651":["thread",141651],"thread-139681":["thread",139681],"thread-136267":["thread",136267],"thread-132995":["thread",132995],"thread-132607":["thread",132607],"thread-130563":["thread",130563],"thread-130116":["thread",130116],"thread-129964":["thread",129964],"thread-129003":["thread",129003],"thread-126989":["thread",126989],"thread-126525":["thread",126525],"thread-125051":["thread",125051],"thread-124472":["thread",124472],"thread-124455":["thread",124455],"thread-124391":["thread",124391],"thread-122488":["thread",122488],"thread-122410":["thread",122410],"thread-121859":["thread",121859],"thread-121209":["thread",121209],"thread-120947":["thread",120947],"thread-120165":["thread",120165],"thread-117450":["thread",117450],"thread-115188":["thread",115188],"thread-113374":["thread",113374],"thread-112721":["thread",112721],"thread-112288":["thread",112288],"thread-111683":["thread",111683],"thread-111281":["thread",111281],"thread-110713":["thread",110713],"thread-108577":["thread",108577],"thread-105564":["thread",105564],"thread-103170":["thread",103170],"thread-101447":["thread",101447],"thread-101333":["thread",101333],"thread-101276":["thread",101276],"thread-95661":["thread",95661],"thread-93600":["thread",93600],"thread-91641":["thread",91641],"thread-91261":["thread",91261],"thread-90359":["thread",90359],"thread-85847":["thread",85847],"thread-85520":["thread",85520],"thread-84740":["thread",84740],"thread-74917":["thread",74917],"thread-73214":["thread",73214],"thread-70035":["thread",70035],"thread-68653":["thread",68653],"thread-67780":["thread",67780],"thread-61187":["thread",61187],"thread-59108":["thread",59108],"thread-57867":["thread",57867],"thread-56611":["thread",56611],"thread-55988":["thread",55988],"thread-54104":["thread",54104],"thread-53743":["thread",53743],"thread-52011":["thread",52011],"thread-51540":["thread",51540],"thread-50239":["thread",50239],"thread-45264":["thread",45264],"thread-41448":["thread",41448],"thread-23078":["thread",23078],"thread-4359":["thread",4359]}, , 1715181920
Run Time: 0.000706
- 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