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 (183222, 183002, 182878, 182521, 182468, 182463, 182435, 182428, 182387, 182253, 182252, 182218, 182071, 181996, 181734, 181625, 181497, 181330, 181278, 181058, 181026, 180995, 180970, 180862, 180814, 180526, 180521, 180473, 180428, 180398, 180375, 180213, 179625, 179609, 179608, 179569, 179389, 179242, 178938, 178568, 178418, 178287, 177921, 177746, 177411, 177391, 177374, 177346, 177345, 177305, 177199, 177077, 177049, 176929, 176908, 176836, 176537, 176534, 176238, 176161, 176151, 176049, 176035, 175947, 175939, 175900, 175756, 175621, 175552, 175459, 175244, 175175, 175141, 175050, 174964, 174706, 174685, 174650, 174531, 174243, 174173, 174172, 174051, 173572, 173523, 173500, 173447, 173445, 173368, 173273, 173236, 173042, 172819, 172759, 172491, 172443, 172190, 171761, 171758, 171493, 171303, 171278, 170790, 170787, 170759, 170563, 170388, 170070, 169783, 169753, 169736, 169712, 169701, 169450, 169414, 169412, 169392, 169385, 169362, 169261, 168959, 168572, 168385, 168248, 167911, 167900, 167640, 167563, 167448, 167297, 167269, 167219, 167148, 167145, 167094, 167021, 167016, 166849, 166731, 166658, 166584, 166359, 166346, 166267, 166142, 166126, 166108, 166106, 166011, 165869, 165846, 165624, 165601, 165561, 165473, 165425, 165306, 165280, 165221, 164994, 164946, 164881, 164631, 164502, 164448, 164156, 164097, 164031, 164028, 163993, 163987, 163616, 163483, 163225, 163212, 162963, 162833, 162801, 162426, 162226, 162196, 161741, 161694, 161649, 161612, 161456, 161399, 161369, 161224, 161183, 161066, 160973, 160950, 160862, 160707, 160649, 160537, 160468, 160336, 160332))
Run Time: 0.184108
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: 624, 0, 1716009380, {"thread-183222":["thread",183222],"thread-183002":["thread",183002],"thread-182878":["thread",182878],"thread-182521":["thread",182521],"thread-182468":["thread",182468],"thread-182463":["thread",182463],"thread-182435":["thread",182435],"thread-182428":["thread",182428],"thread-182387":["thread",182387],"thread-182253":["thread",182253],"thread-182252":["thread",182252],"thread-182218":["thread",182218],"thread-182071":["thread",182071],"thread-181996":["thread",181996],"thread-181734":["thread",181734],"thread-181625":["thread",181625],"thread-181497":["thread",181497],"thread-181330":["thread",181330],"thread-181278":["thread",181278],"thread-181058":["thread",181058],"thread-181026":["thread",181026],"thread-180995":["thread",180995],"thread-180970":["thread",180970],"thread-180862":["thread",180862],"thread-180814":["thread",180814],"thread-180526":["thread",180526],"thread-180521":["thread",180521],"thread-180473":["thread",180473],"thread-180428":["thread",180428],"thread-180398":["thread",180398],"thread-180375":["thread",180375],"thread-180213":["thread",180213],"thread-179625":["thread",179625],"thread-179609":["thread",179609],"thread-179608":["thread",179608],"thread-179569":["thread",179569],"thread-179389":["thread",179389],"thread-179242":["thread",179242],"thread-178938":["thread",178938],"thread-178568":["thread",178568],"thread-178418":["thread",178418],"thread-178287":["thread",178287],"thread-177921":["thread",177921],"thread-177746":["thread",177746],"thread-177411":["thread",177411],"thread-177391":["thread",177391],"thread-177374":["thread",177374],"thread-177346":["thread",177346],"thread-177345":["thread",177345],"thread-177305":["thread",177305],"thread-177199":["thread",177199],"thread-177077":["thread",177077],"thread-177049":["thread",177049],"thread-176929":["thread",176929],"thread-176908":["thread",176908],"thread-176836":["thread",176836],"thread-176537":["thread",176537],"thread-176534":["thread",176534],"thread-176238":["thread",176238],"thread-176161":["thread",176161],"thread-176151":["thread",176151],"thread-176049":["thread",176049],"thread-176035":["thread",176035],"thread-175947":["thread",175947],"thread-175939":["thread",175939],"thread-175900":["thread",175900],"thread-175756":["thread",175756],"thread-175621":["thread",175621],"thread-175552":["thread",175552],"thread-175459":["thread",175459],"thread-175244":["thread",175244],"thread-175175":["thread",175175],"thread-175141":["thread",175141],"thread-175050":["thread",175050],"thread-174964":["thread",174964],"thread-174706":["thread",174706],"thread-174685":["thread",174685],"thread-174650":["thread",174650],"thread-174531":["thread",174531],"thread-174243":["thread",174243],"thread-174173":["thread",174173],"thread-174172":["thread",174172],"thread-174051":["thread",174051],"thread-173572":["thread",173572],"thread-173523":["thread",173523],"thread-173500":["thread",173500],"thread-173447":["thread",173447],"thread-173445":["thread",173445],"thread-173368":["thread",173368],"thread-173273":["thread",173273],"thread-173236":["thread",173236],"thread-173042":["thread",173042],"thread-172819":["thread",172819],"thread-172759":["thread",172759],"thread-172491":["thread",172491],"thread-172443":["thread",172443],"thread-172190":["thread",172190],"thread-171761":["thread",171761],"thread-171758":["thread",171758],"thread-171493":["thread",171493],"thread-171303":["thread",171303],"thread-171278":["thread",171278],"thread-170790":["thread",170790],"thread-170787":["thread",170787],"thread-170759":["thread",170759],"thread-170563":["thread",170563],"thread-170388":["thread",170388],"thread-170070":["thread",170070],"thread-169783":["thread",169783],"thread-169753":["thread",169753],"thread-169736":["thread",169736],"thread-169712":["thread",169712],"thread-169701":["thread",169701],"thread-169450":["thread",169450],"thread-169414":["thread",169414],"thread-169412":["thread",169412],"thread-169392":["thread",169392],"thread-169385":["thread",169385],"thread-169362":["thread",169362],"thread-169261":["thread",169261],"thread-168959":["thread",168959],"thread-168572":["thread",168572],"thread-168385":["thread",168385],"thread-168248":["thread",168248],"thread-167911":["thread",167911],"thread-167900":["thread",167900],"thread-167640":["thread",167640],"thread-167563":["thread",167563],"thread-167448":["thread",167448],"thread-167297":["thread",167297],"thread-167269":["thread",167269],"thread-167219":["thread",167219],"thread-167148":["thread",167148],"thread-167145":["thread",167145],"thread-167094":["thread",167094],"thread-167021":["thread",167021],"thread-167016":["thread",167016],"thread-166849":["thread",166849],"thread-166731":["thread",166731],"thread-166658":["thread",166658],"thread-166584":["thread",166584],"thread-166359":["thread",166359],"thread-166346":["thread",166346],"thread-166267":["thread",166267],"thread-166142":["thread",166142],"thread-166126":["thread",166126],"thread-166108":["thread",166108],"thread-166106":["thread",166106],"thread-166011":["thread",166011],"thread-165869":["thread",165869],"thread-165846":["thread",165846],"thread-165624":["thread",165624],"thread-165601":["thread",165601],"thread-165561":["thread",165561],"thread-165473":["thread",165473],"thread-165425":["thread",165425],"thread-165306":["thread",165306],"thread-165280":["thread",165280],"thread-165221":["thread",165221],"thread-164994":["thread",164994],"thread-164946":["thread",164946],"thread-164881":["thread",164881],"thread-164631":["thread",164631],"thread-164502":["thread",164502],"thread-164448":["thread",164448],"thread-164156":["thread",164156],"thread-164097":["thread",164097],"thread-164031":["thread",164031],"thread-164028":["thread",164028],"thread-163993":["thread",163993],"thread-163987":["thread",163987],"thread-163616":["thread",163616],"thread-163483":["thread",163483],"thread-163225":["thread",163225],"thread-163212":["thread",163212],"thread-162963":["thread",162963],"thread-162833":["thread",162833],"thread-162801":["thread",162801],"thread-162426":["thread",162426],"thread-162226":["thread",162226],"thread-162196":["thread",162196],"thread-161741":["thread",161741],"thread-161694":["thread",161694],"thread-161649":["thread",161649],"thread-161612":["thread",161612],"thread-161456":["thread",161456],"thread-161399":["thread",161399],"thread-161369":["thread",161369],"thread-161224":["thread",161224],"thread-161183":["thread",161183],"thread-161066":["thread",161066],"thread-160973":["thread",160973],"thread-160950":["thread",160950],"thread-160862":["thread",160862],"thread-160707":["thread",160707],"thread-160649":["thread",160649],"thread-160537":["thread",160537],"thread-160468":["thread",160468],"thread-160336":["thread",160336],"thread-160332":["thread",160332]}, , 1716005780
Run Time: 0.000458
- 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