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 (182760, 182382, 182238, 182200, 181908, 181816, 181808, 181621, 181602, 181466, 181264, 181220, 181054, 181053, 180989, 180910, 180829, 180821, 180572, 180510, 180068, 179957, 179812, 179722, 179601, 179295, 179194, 179193, 178542, 178310, 177359, 177028, 177024, 176737, 176361, 176274, 175904, 175257, 175254, 173921, 173826, 173805, 173023, 172990, 172500, 171951, 171752, 171527, 171463, 171318, 171259, 171222, 171133, 169827, 169742, 169720, 169713, 169624, 169135, 169067, 168906, 168884, 168803, 168697, 168618, 168514, 168142, 167936, 167747, 167676, 167101, 166865, 166598, 166483, 166477, 166201, 166182, 166008, 165986, 165944, 165744, 165705, 165074, 164447, 164345, 164202, 164140, 164081, 163936, 163884, 163843, 162969, 162962, 162639, 162499, 162485, 162255, 161960, 161321, 161080, 160881, 160850, 160847, 160843, 160838, 160837, 160329, 160327, 160326, 160325, 160324, 160322, 160321, 160209, 160177, 160146, 160068, 160065, 160023, 160021, 159793, 158890, 158759, 158722, 158720, 158506, 158497, 158240, 158040, 157950, 157836, 157774, 157666, 157283, 157173, 157110, 156756, 156715, 156097, 156024, 155899, 155616, 155514, 155246, 155192, 155097, 155078, 154769, 154743, 154728, 154610, 154507, 154466, 154362, 153986, 153635, 153244, 153206, 152767, 152763, 152665, 152551, 152416, 152388, 152378, 152228, 152191, 151959, 137518, 132038, 131898, 126969, 124291, 123669, 122602, 121029, 119146, 119116, 113654, 112208, 109667, 107871, 74792, 70075, 61813, 40495, 32972, 26172, 21318))
Run Time: 0.094050
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 189 | 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: 2797, 0, 1714798823, {"thread-182760":["thread",182760],"thread-182382":["thread",182382],"thread-182238":["thread",182238],"thread-182200":["thread",182200],"thread-181908":["thread",181908],"thread-181816":["thread",181816],"thread-181808":["thread",181808],"thread-181621":["thread",181621],"thread-181602":["thread",181602],"thread-181466":["thread",181466],"thread-181264":["thread",181264],"thread-181220":["thread",181220],"thread-181054":["thread",181054],"thread-181053":["thread",181053],"thread-180989":["thread",180989],"thread-180910":["thread",180910],"thread-180829":["thread",180829],"thread-180821":["thread",180821],"thread-180572":["thread",180572],"thread-180510":["thread",180510],"thread-180068":["thread",180068],"thread-179957":["thread",179957],"thread-179812":["thread",179812],"thread-179722":["thread",179722],"thread-179601":["thread",179601],"thread-179295":["thread",179295],"thread-179194":["thread",179194],"thread-179193":["thread",179193],"thread-178542":["thread",178542],"thread-178310":["thread",178310],"thread-177359":["thread",177359],"thread-177028":["thread",177028],"thread-177024":["thread",177024],"thread-176737":["thread",176737],"thread-176361":["thread",176361],"thread-176274":["thread",176274],"thread-175904":["thread",175904],"thread-175257":["thread",175257],"thread-175254":["thread",175254],"thread-173921":["thread",173921],"thread-173826":["thread",173826],"thread-173805":["thread",173805],"thread-173023":["thread",173023],"thread-172990":["thread",172990],"thread-172500":["thread",172500],"tl_group-283":["tl_group",283],"thread-171951":["thread",171951],"thread-171752":["thread",171752],"thread-171527":["thread",171527],"thread-171463":["thread",171463],"thread-171318":["thread",171318],"thread-171259":["thread",171259],"thread-171222":["thread",171222],"thread-171133":["thread",171133],"thread-169827":["thread",169827],"thread-169742":["thread",169742],"thread-169720":["thread",169720],"thread-169713":["thread",169713],"thread-169624":["thread",169624],"thread-169135":["thread",169135],"thread-169067":["thread",169067],"thread-168906":["thread",168906],"thread-168884":["thread",168884],"thread-168803":["thread",168803],"thread-168697":["thread",168697],"thread-168618":["thread",168618],"thread-168514":["thread",168514],"thread-168142":["thread",168142],"thread-167936":["thread",167936],"thread-167747":["thread",167747],"thread-167676":["thread",167676],"thread-167101":["thread",167101],"thread-166865":["thread",166865],"thread-166598":["thread",166598],"thread-166483":["thread",166483],"thread-166477":["thread",166477],"thread-166201":["thread",166201],"thread-166182":["thread",166182],"thread-166008":["thread",166008],"thread-165986":["thread",165986],"thread-165944":["thread",165944],"thread-165744":["thread",165744],"thread-165705":["thread",165705],"thread-165074":["thread",165074],"thread-164447":["thread",164447],"thread-164345":["thread",164345],"thread-164202":["thread",164202],"thread-164140":["thread",164140],"thread-164081":["thread",164081],"thread-163936":["thread",163936],"thread-163884":["thread",163884],"thread-163843":["thread",163843],"thread-162969":["thread",162969],"thread-162962":["thread",162962],"thread-162639":["thread",162639],"thread-162499":["thread",162499],"thread-162485":["thread",162485],"thread-162255":["thread",162255],"thread-161960":["thread",161960],"thread-161321":["thread",161321],"thread-161080":["thread",161080],"thread-160881":["thread",160881],"thread-160850":["thread",160850],"thread-160847":["thread",160847],"thread-160843":["thread",160843],"thread-160838":["thread",160838],"thread-160837":["thread",160837],"thread-160329":["thread",160329],"thread-160327":["thread",160327],"thread-160326":["thread",160326],"thread-160325":["thread",160325],"thread-160324":["thread",160324],"thread-160322":["thread",160322],"thread-160321":["thread",160321],"thread-160209":["thread",160209],"thread-160177":["thread",160177],"thread-160146":["thread",160146],"thread-160068":["thread",160068],"thread-160065":["thread",160065],"thread-160023":["thread",160023],"thread-160021":["thread",160021],"thread-159793":["thread",159793],"thread-158890":["thread",158890],"thread-158759":["thread",158759],"thread-158722":["thread",158722],"thread-158720":["thread",158720],"thread-158506":["thread",158506],"thread-158497":["thread",158497],"thread-158240":["thread",158240],"thread-158040":["thread",158040],"thread-157950":["thread",157950],"thread-157836":["thread",157836],"thread-157774":["thread",157774],"thread-157666":["thread",157666],"thread-157283":["thread",157283],"thread-157173":["thread",157173],"thread-157110":["thread",157110],"thread-156756":["thread",156756],"thread-156715":["thread",156715],"thread-156097":["thread",156097],"thread-156024":["thread",156024],"thread-155899":["thread",155899],"thread-155616":["thread",155616],"thread-155514":["thread",155514],"thread-155246":["thread",155246],"thread-155192":["thread",155192],"thread-155097":["thread",155097],"thread-155078":["thread",155078],"thread-154769":["thread",154769],"thread-154743":["thread",154743],"thread-154728":["thread",154728],"thread-154610":["thread",154610],"thread-154507":["thread",154507],"thread-154466":["thread",154466],"thread-154362":["thread",154362],"thread-153986":["thread",153986],"thread-153635":["thread",153635],"thread-153244":["thread",153244],"thread-153206":["thread",153206],"thread-152767":["thread",152767],"thread-152763":["thread",152763],"thread-152665":["thread",152665],"thread-152551":["thread",152551],"thread-152416":["thread",152416],"thread-152388":["thread",152388],"thread-152378":["thread",152378],"thread-152228":["thread",152228],"thread-152191":["thread",152191],"thread-151959":["thread",151959],"thread-137518":["thread",137518],"thread-132038":["thread",132038],"thread-131898":["thread",131898],"thread-126969":["thread",126969],"thread-124291":["thread",124291],"thread-123669":["thread",123669],"thread-122602":["thread",122602],"thread-121029":["thread",121029],"thread-119146":["thread",119146],"thread-119116":["thread",119116],"thread-113654":["thread",113654],"thread-112208":["thread",112208],"thread-109667":["thread",109667],"thread-107871":["thread",107871],"thread-74792":["thread",74792],"thread-70075":["thread",70075],"thread-61813":["thread",61813],"thread-40495":["thread",40495],"thread-32972":["thread",32972],"thread-26172":["thread",26172],"thread-21318":["thread",21318]}, , 1714795223
Run Time: 0.000501
- 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