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 (183188, 181686, 181417, 181235, 179935, 179136, 178862, 178747, 178746, 177582, 177574, 176531, 176299, 176141, 175512, 175054, 174704, 173218, 172511, 171789, 171573, 169779, 167845, 167270, 165689, 165153, 164215, 163614, 161799, 161254, 158705, 158289, 157958, 156682, 156507, 156386, 155687, 155569, 155540, 155354, 154799, 152196, 138172, 134565, 131412, 131029, 130919, 128406, 127558, 126356, 121991, 121047, 117054, 110445, 105059, 105027, 104893, 104022, 103215, 102960, 102748, 102733, 102604, 102583, 101069, 97346, 95337, 90423, 85916, 85863, 85084, 84161, 83849, 83485, 79344, 79000, 77494, 77378, 77294, 77242, 76399, 76102, 75469, 74104, 73940, 72880, 71081, 70974, 70583, 70518, 70481, 70379, 69181, 69091, 68890, 68534, 68168, 67012, 66592, 64776, 62759, 61666, 58939, 57815, 54527, 54192, 54135, 51464, 50729, 49577, 49157, 47908, 47128, 45648, 45371, 42950, 41158, 40220, 33289, 28780, 19389, 19303, 14936, 3459))
Run Time: 0.036853
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 124 | 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: 842, 0, 1716141829, {"thread-183188":["thread",183188],"thread-181686":["thread",181686],"thread-181417":["thread",181417],"thread-181235":["thread",181235],"thread-179935":["thread",179935],"thread-179136":["thread",179136],"thread-178862":["thread",178862],"thread-178747":["thread",178747],"thread-178746":["thread",178746],"thread-177582":["thread",177582],"thread-177574":["thread",177574],"thread-176531":["thread",176531],"thread-176299":["thread",176299],"thread-176141":["thread",176141],"thread-175512":["thread",175512],"thread-175054":["thread",175054],"thread-174704":["thread",174704],"thread-173218":["thread",173218],"thread-172511":["thread",172511],"thread-171789":["thread",171789],"thread-171573":["thread",171573],"thread-169779":["thread",169779],"thread-167845":["thread",167845],"thread-167270":["thread",167270],"thread-165689":["thread",165689],"thread-165153":["thread",165153],"thread-164215":["thread",164215],"thread-163614":["thread",163614],"thread-161799":["thread",161799],"thread-161254":["thread",161254],"thread-158705":["thread",158705],"thread-158289":["thread",158289],"thread-157958":["thread",157958],"thread-156682":["thread",156682],"thread-156507":["thread",156507],"thread-156386":["thread",156386],"thread-155687":["thread",155687],"thread-155569":["thread",155569],"thread-155540":["thread",155540],"thread-155354":["thread",155354],"thread-154799":["thread",154799],"thread-152196":["thread",152196],"thread-138172":["thread",138172],"thread-134565":["thread",134565],"thread-131412":["thread",131412],"thread-131029":["thread",131029],"thread-130919":["thread",130919],"thread-128406":["thread",128406],"thread-127558":["thread",127558],"thread-126356":["thread",126356],"thread-121991":["thread",121991],"thread-121047":["thread",121047],"thread-117054":["thread",117054],"thread-110445":["thread",110445],"thread-105059":["thread",105059],"thread-105027":["thread",105027],"thread-104893":["thread",104893],"thread-104022":["thread",104022],"thread-103215":["thread",103215],"thread-102960":["thread",102960],"thread-102748":["thread",102748],"thread-102733":["thread",102733],"thread-102604":["thread",102604],"thread-102583":["thread",102583],"thread-101069":["thread",101069],"thread-97346":["thread",97346],"thread-95337":["thread",95337],"thread-90423":["thread",90423],"thread-85916":["thread",85916],"thread-85863":["thread",85863],"thread-85084":["thread",85084],"thread-84161":["thread",84161],"thread-83849":["thread",83849],"thread-83485":["thread",83485],"thread-79344":["thread",79344],"thread-79000":["thread",79000],"thread-77494":["thread",77494],"thread-77378":["thread",77378],"thread-77294":["thread",77294],"thread-77242":["thread",77242],"thread-76399":["thread",76399],"thread-76102":["thread",76102],"thread-75469":["thread",75469],"thread-74104":["thread",74104],"thread-73940":["thread",73940],"thread-72880":["thread",72880],"thread-71081":["thread",71081],"thread-70974":["thread",70974],"thread-70583":["thread",70583],"thread-70518":["thread",70518],"thread-70481":["thread",70481],"thread-70379":["thread",70379],"thread-69181":["thread",69181],"thread-69091":["thread",69091],"thread-68890":["thread",68890],"thread-68534":["thread",68534],"thread-68168":["thread",68168],"thread-67012":["thread",67012],"thread-66592":["thread",66592],"thread-64776":["thread",64776],"thread-62759":["thread",62759],"thread-61666":["thread",61666],"thread-58939":["thread",58939],"thread-57815":["thread",57815],"thread-54527":["thread",54527],"thread-54192":["thread",54192],"thread-54135":["thread",54135],"thread-51464":["thread",51464],"thread-50729":["thread",50729],"thread-49577":["thread",49577],"thread-49157":["thread",49157],"thread-47908":["thread",47908],"thread-47128":["thread",47128],"thread-45648":["thread",45648],"thread-45371":["thread",45371],"thread-42950":["thread",42950],"thread-41158":["thread",41158],"thread-40220":["thread",40220],"thread-33289":["thread",33289],"thread-28780":["thread",28780],"thread-19389":["thread",19389],"thread-19303":["thread",19303],"thread-14936":["thread",14936],"thread-3459":["thread",3459]}, , 1716138229
Run Time: 0.000369
- 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