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 (183160, 182335, 178170, 175736, 175198, 174735, 174606, 170645, 170503, 169295, 168661, 168659, 168607, 168367, 168004, 167895, 167890, 167888, 167847, 167844, 167092, 167089, 167088, 166790, 165340, 162009, 160974, 160710, 158624, 157193, 157147, 156796, 156533, 154103, 154035, 153688, 152473, 152458, 140826, 140745, 140672, 138462, 134597, 133927, 133445, 132670, 126765, 125305, 125028, 120707, 120296, 118755, 117826, 116789, 116578, 116476, 116175, 116007, 115977, 115740, 114063, 113824, 113796, 112796, 112067, 107256, 106685, 106684, 105516, 105139, 103424, 103389, 96007, 95610, 88107, 87997, 87985, 87907, 83625, 83294, 81717, 81670, 80487, 78816, 78705, 75360, 74524, 74400, 74002, 73486, 72572, 72534, 72391, 72305, 72300, 71524, 71489, 70977, 70952, 70903, 70897, 70670, 70668, 70660, 70628, 70126, 70102, 69362, 69317, 69258, 69135, 68995, 68813, 68798, 68106, 68067, 68057, 67661, 66224, 65913, 65910, 65856, 65824, 65709, 65636, 65356, 64689, 63955, 63225, 63185, 62762, 62495, 62442, 62013, 61943, 60006, 59871, 59837, 59829, 59687, 58726, 57094, 57050, 57044, 56748, 56270, 56188, 55067, 53767, 53289, 52669, 52187, 51244, 51105, 50871, 49711, 48393, 48183, 45038, 44764, 44212, 42194, 42152, 42072, 41975, 41084, 39933, 39646, 39275, 39266, 39260, 39158, 38674, 38346, 38291, 38086, 37861, 37837, 37810, 37657, 37297, 37280, 37200, 37174, 36775, 36579, 36420, 36411, 36405, 36403, 36268, 36142, 35626, 34972))
Run Time: 0.106866
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 194 | 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: 1426, 0, 1714896997, {"thread-183160":["thread",183160],"thread-182335":["thread",182335],"thread-178170":["thread",178170],"thread-175736":["thread",175736],"thread-175198":["thread",175198],"thread-174735":["thread",174735],"thread-174606":["thread",174606],"thread-170645":["thread",170645],"thread-170503":["thread",170503],"thread-169295":["thread",169295],"thread-168661":["thread",168661],"thread-168659":["thread",168659],"thread-168607":["thread",168607],"thread-168367":["thread",168367],"thread-168004":["thread",168004],"thread-167895":["thread",167895],"thread-167890":["thread",167890],"thread-167888":["thread",167888],"thread-167847":["thread",167847],"thread-167844":["thread",167844],"thread-167092":["thread",167092],"thread-167089":["thread",167089],"thread-167088":["thread",167088],"thread-166790":["thread",166790],"tl_group-231":["tl_group",231],"thread-165340":["thread",165340],"thread-162009":["thread",162009],"thread-160974":["thread",160974],"thread-160710":["thread",160710],"thread-158624":["thread",158624],"thread-157193":["thread",157193],"thread-157147":["thread",157147],"thread-156796":["thread",156796],"thread-156533":["thread",156533],"tl_group-120":["tl_group",120],"thread-154103":["thread",154103],"thread-154035":["thread",154035],"thread-153688":["thread",153688],"thread-152473":["thread",152473],"thread-152458":["thread",152458],"thread-140826":["thread",140826],"thread-140745":["thread",140745],"thread-140672":["thread",140672],"thread-138462":["thread",138462],"thread-134597":["thread",134597],"thread-133927":["thread",133927],"thread-133445":["thread",133445],"thread-132670":["thread",132670],"thread-126765":["thread",126765],"thread-125305":["thread",125305],"thread-125028":["thread",125028],"thread-120707":["thread",120707],"thread-120296":["thread",120296],"thread-118755":["thread",118755],"thread-117826":["thread",117826],"thread-116789":["thread",116789],"thread-116578":["thread",116578],"thread-116476":["thread",116476],"thread-116175":["thread",116175],"thread-116007":["thread",116007],"thread-115977":["thread",115977],"thread-115740":["thread",115740],"thread-114063":["thread",114063],"thread-113824":["thread",113824],"thread-113796":["thread",113796],"thread-112796":["thread",112796],"thread-112067":["thread",112067],"thread-107256":["thread",107256],"thread-106685":["thread",106685],"thread-106684":["thread",106684],"thread-105516":["thread",105516],"thread-105139":["thread",105139],"thread-103424":["thread",103424],"thread-103389":["thread",103389],"thread-96007":["thread",96007],"thread-95610":["thread",95610],"thread-88107":["thread",88107],"thread-87997":["thread",87997],"thread-87985":["thread",87985],"thread-87907":["thread",87907],"thread-83625":["thread",83625],"thread-83294":["thread",83294],"thread-81717":["thread",81717],"thread-81670":["thread",81670],"thread-80487":["thread",80487],"thread-78816":["thread",78816],"thread-78705":["thread",78705],"thread-75360":["thread",75360],"thread-74524":["thread",74524],"thread-74400":["thread",74400],"thread-74002":["thread",74002],"thread-73486":["thread",73486],"thread-72572":["thread",72572],"thread-72534":["thread",72534],"thread-72391":["thread",72391],"thread-72305":["thread",72305],"thread-72300":["thread",72300],"thread-71524":["thread",71524],"thread-71489":["thread",71489],"thread-70977":["thread",70977],"thread-70952":["thread",70952],"thread-70903":["thread",70903],"thread-70897":["thread",70897],"thread-70670":["thread",70670],"thread-70668":["thread",70668],"thread-70660":["thread",70660],"thread-70628":["thread",70628],"thread-70126":["thread",70126],"thread-70102":["thread",70102],"thread-69362":["thread",69362],"thread-69317":["thread",69317],"thread-69258":["thread",69258],"thread-69135":["thread",69135],"thread-68995":["thread",68995],"thread-68813":["thread",68813],"thread-68798":["thread",68798],"thread-68106":["thread",68106],"thread-68067":["thread",68067],"thread-68057":["thread",68057],"thread-67661":["thread",67661],"thread-66224":["thread",66224],"thread-65913":["thread",65913],"thread-65910":["thread",65910],"thread-65856":["thread",65856],"thread-65824":["thread",65824],"thread-65709":["thread",65709],"thread-65636":["thread",65636],"thread-65356":["thread",65356],"thread-64689":["thread",64689],"thread-63955":["thread",63955],"thread-63225":["thread",63225],"thread-63185":["thread",63185],"thread-62762":["thread",62762],"thread-62495":["thread",62495],"thread-62442":["thread",62442],"thread-62013":["thread",62013],"thread-61943":["thread",61943],"thread-60006":["thread",60006],"thread-59871":["thread",59871],"thread-59837":["thread",59837],"thread-59829":["thread",59829],"thread-59687":["thread",59687],"thread-58726":["thread",58726],"thread-57094":["thread",57094],"thread-57044":["thread",57044],"thread-56748":["thread",56748],"thread-56270":["thread",56270],"thread-56188":["thread",56188],"thread-55067":["thread",55067],"thread-53767":["thread",53767],"thread-53289":["thread",53289],"thread-52669":["thread",52669],"thread-52187":["thread",52187],"thread-51244":["thread",51244],"thread-51105":["thread",51105],"thread-50871":["thread",50871],"thread-49711":["thread",49711],"thread-48393":["thread",48393],"thread-48183":["thread",48183],"thread-45038":["thread",45038],"thread-44764":["thread",44764],"thread-44212":["thread",44212],"thread-42194":["thread",42194],"thread-42152":["thread",42152],"thread-42072":["thread",42072],"thread-41975":["thread",41975],"thread-41084":["thread",41084],"thread-39933":["thread",39933],"thread-39646":["thread",39646],"thread-39275":["thread",39275],"thread-39266":["thread",39266],"thread-39260":["thread",39260],"thread-39158":["thread",39158],"thread-38674":["thread",38674],"thread-38346":["thread",38346],"thread-38291":["thread",38291],"thread-38086":["thread",38086],"thread-37861":["thread",37861],"thread-37837":["thread",37837],"thread-37810":["thread",37810],"thread-37657":["thread",37657],"thread-37297":["thread",37297],"thread-37280":["thread",37280],"thread-37200":["thread",37200],"thread-37174":["thread",37174],"thread-36775":["thread",36775],"thread-36579":["thread",36579],"thread-36420":["thread",36420],"thread-36411":["thread",36411],"thread-36405":["thread",36405],"thread-36403":["thread",36403],"thread-36268":["thread",36268],"thread-36142":["thread",36142],"thread-35626":["thread",35626],"thread-34972":["thread",34972]}, , 1714893397
Run Time: 0.000413
- 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