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 (44999, 44991, 44975, 44971, 44926, 44921, 44834, 44819, 44815, 44413, 43821, 43545, 43513, 43479, 43425, 43340, 43310, 43248, 43233, 43191, 43172, 43168, 43167, 43163, 43138, 43100, 43085, 43084, 43083, 43082, 43075, 43020, 42959, 42944, 42930, 42917, 42892, 42830, 42780, 42744, 42711, 42626, 42592, 42561, 42548, 42430, 42410, 42392, 42383, 42322, 42145, 42089, 42088, 42035, 42005, 41954, 41908, 41563, 41509, 41398, 41183, 41030, 41029, 41000, 40976, 40973, 40972, 40901, 40899, 40892, 40858, 40830, 40828, 40822, 40748, 40550, 40505, 40428, 40400, 40089, 40065, 39954, 39945, 39812, 39762, 39761, 39743, 39718, 39695, 39694, 39624, 39569, 39561, 39465, 39462, 39344, 39279, 39265, 39254, 39133, 39124, 39054, 39033, 38759, 38714, 38696, 38568, 38562, 38502, 38409, 38332, 38273, 38222, 38166, 38111, 38059, 37967, 37962, 37898, 37815, 37814, 37763, 37761, 37176, 37038, 36997, 36856, 36834, 36807, 36780, 36687, 36642, 36485, 36451, 36447, 36442, 36407, 36361, 36217, 36028, 35963, 35754, 35738, 35725, 35668, 35620, 35597, 35510, 35500, 35087, 34949, 34897, 34878, 34876, 34816, 34813, 34808, 34767, 34732, 34675, 34562, 34481, 34478, 34374, 34202, 34157, 34126, 34081, 33994, 33990, 33920, 33643, 33641, 33616, 33581, 33577, 33530, 33519, 33435, 33415, 33372, 33312, 33218, 33212, 33057, 33038, 33035, 33015, 32975, 32882, 32814, 32666, 32622, 32617, 32585, 32495, 32265, 32172, 32169, 32156, 32132, 32117, 32057, 32056, 32040, 31949, 31681, 31653, 31634, 31599, 31574, 31566, 31563, 31557, 31550, 31534, 31520, 31503, 31485, 31401, 31398, 31387, 31385, 31370, 31321, 31301, 31060, 31047, 31046, 31028, 30901, 30895, 30861, 30826, 30729, 30574, 30541, 30533, 30466, 30375, 30373, 30368, 30326, 30324, 30250, 30223, 30191, 30104, 30073, 30051))
Run Time: 0.066620
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 250 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,squattheplanet.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 1430
- 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 2866
- 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 2483
- XF\App->run() in src/XF.php at line 524
- 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: 48, 0, 1711697363, {"thread-44999":["thread",44999],"thread-44991":["thread",44991],"thread-44975":["thread",44975],"thread-44971":["thread",44971],"thread-44926":["thread",44926],"thread-44921":["thread",44921],"thread-44834":["thread",44834],"thread-44819":["thread",44819],"thread-44815":["thread",44815],"thread-44413":["thread",44413],"thread-43821":["thread",43821],"thread-43545":["thread",43545],"thread-43479":["thread",43479],"thread-43425":["thread",43425],"thread-43310":["thread",43310],"thread-43248":["thread",43248],"thread-43233":["thread",43233],"thread-43191":["thread",43191],"thread-43172":["thread",43172],"thread-43168":["thread",43168],"thread-43167":["thread",43167],"thread-43163":["thread",43163],"thread-43138":["thread",43138],"thread-43100":["thread",43100],"thread-43085":["thread",43085],"thread-43084":["thread",43084],"thread-43083":["thread",43083],"thread-43082":["thread",43082],"thread-43075":["thread",43075],"thread-43020":["thread",43020],"thread-42959":["thread",42959],"thread-42944":["thread",42944],"thread-42930":["thread",42930],"thread-42917":["thread",42917],"thread-42892":["thread",42892],"thread-42830":["thread",42830],"thread-42780":["thread",42780],"thread-42744":["thread",42744],"thread-42711":["thread",42711],"thread-42626":["thread",42626],"thread-42592":["thread",42592],"thread-42561":["thread",42561],"thread-42548":["thread",42548],"thread-42430":["thread",42430],"thread-42410":["thread",42410],"thread-42392":["thread",42392],"thread-42383":["thread",42383],"thread-42322":["thread",42322],"thread-42145":["thread",42145],"thread-42089":["thread",42089],"thread-42088":["thread",42088],"thread-42035":["thread",42035],"thread-42005":["thread",42005],"thread-41954":["thread",41954],"thread-41908":["thread",41908],"thread-41563":["thread",41563],"thread-41509":["thread",41509],"thread-41398":["thread",41398],"thread-41183":["thread",41183],"thread-41030":["thread",41030],"thread-41029":["thread",41029],"thread-41000":["thread",41000],"thread-40976":["thread",40976],"thread-40973":["thread",40973],"thread-40972":["thread",40972],"thread-40901":["thread",40901],"thread-40899":["thread",40899],"thread-40892":["thread",40892],"thread-40858":["thread",40858],"thread-40830":["thread",40830],"thread-40828":["thread",40828],"thread-40822":["thread",40822],"thread-40748":["thread",40748],"thread-40550":["thread",40550],"thread-40505":["thread",40505],"thread-40428":["thread",40428],"thread-40400":["thread",40400],"thread-40089":["thread",40089],"thread-40065":["thread",40065],"thread-39954":["thread",39954],"thread-39945":["thread",39945],"thread-39812":["thread",39812],"thread-39762":["thread",39762],"thread-39761":["thread",39761],"thread-39743":["thread",39743],"thread-39718":["thread",39718],"thread-39695":["thread",39695],"thread-39694":["thread",39694],"thread-39624":["thread",39624],"thread-39569":["thread",39569],"thread-39561":["thread",39561],"thread-39465":["thread",39465],"thread-39462":["thread",39462],"thread-39344":["thread",39344],"thread-39279":["thread",39279],"thread-39265":["thread",39265],"thread-39254":["thread",39254],"thread-39133":["thread",39133],"thread-39124":["thread",39124],"thread-39054":["thread",39054],"thread-39033":["thread",39033],"thread-38759":["thread",38759],"thread-38714":["thread",38714],"thread-38696":["thread",38696],"thread-38568":["thread",38568],"thread-38562":["thread",38562],"thread-38502":["thread",38502],"thread-38409":["thread",38409],"thread-38332":["thread",38332],"thread-38273":["thread",38273],"thread-38222":["thread",38222],"thread-38166":["thread",38166],"thread-38111":["thread",38111],"thread-38059":["thread",38059],"thread-37967":["thread",37967],"thread-37962":["thread",37962],"thread-37898":["thread",37898],"thread-37815":["thread",37815],"thread-37814":["thread",37814],"thread-37763":["thread",37763],"thread-37761":["thread",37761],"thread-37176":["thread",37176],"thread-37038":["thread",37038],"thread-36997":["thread",36997],"thread-36856":["thread",36856],"thread-36834":["thread",36834],"thread-36807":["thread",36807],"thread-36780":["thread",36780],"thread-36687":["thread",36687],"thread-36642":["thread",36642],"thread-36485":["thread",36485],"thread-36451":["thread",36451],"thread-36447":["thread",36447],"thread-36442":["thread",36442],"thread-36407":["thread",36407],"thread-36361":["thread",36361],"thread-36217":["thread",36217],"thread-36028":["thread",36028],"thread-35963":["thread",35963],"thread-35754":["thread",35754],"thread-35738":["thread",35738],"thread-35725":["thread",35725],"thread-35668":["thread",35668],"thread-35620":["thread",35620],"thread-35597":["thread",35597],"thread-35510":["thread",35510],"thread-35500":["thread",35500],"thread-35087":["thread",35087],"thread-34949":["thread",34949],"thread-34897":["thread",34897],"thread-34878":["thread",34878],"thread-34876":["thread",34876],"thread-34813":["thread",34813],"thread-34808":["thread",34808],"thread-34767":["thread",34767],"thread-34732":["thread",34732],"thread-34675":["thread",34675],"thread-34562":["thread",34562],"thread-34481":["thread",34481],"thread-34478":["thread",34478],"thread-34374":["thread",34374],"thread-34202":["thread",34202],"thread-34157":["thread",34157],"thread-34126":["thread",34126],"thread-34081":["thread",34081],"thread-33994":["thread",33994],"thread-33990":["thread",33990],"thread-33920":["thread",33920],"thread-33643":["thread",33643],"thread-33641":["thread",33641],"thread-33616":["thread",33616],"thread-33581":["thread",33581],"thread-33577":["thread",33577],"thread-33530":["thread",33530],"thread-33519":["thread",33519],"thread-33435":["thread",33435],"thread-33415":["thread",33415],"thread-33372":["thread",33372],"thread-33312":["thread",33312],"thread-33218":["thread",33218],"thread-33212":["thread",33212],"thread-33057":["thread",33057],"thread-33038":["thread",33038],"thread-33035":["thread",33035],"thread-33015":["thread",33015],"thread-32975":["thread",32975],"thread-32882":["thread",32882],"thread-32814":["thread",32814],"thread-32666":["thread",32666],"thread-32622":["thread",32622],"thread-32617":["thread",32617],"thread-32585":["thread",32585],"thread-32495":["thread",32495],"thread-32265":["thread",32265],"thread-32172":["thread",32172],"thread-32169":["thread",32169],"thread-32156":["thread",32156],"thread-32132":["thread",32132],"thread-32117":["thread",32117],"thread-32057":["thread",32057],"thread-32056":["thread",32056],"thread-32040":["thread",32040],"thread-31949":["thread",31949],"thread-31681":["thread",31681],"thread-31653":["thread",31653],"thread-31634":["thread",31634],"thread-31599":["thread",31599],"thread-31574":["thread",31574],"thread-31566":["thread",31566],"thread-31563":["thread",31563],"thread-31557":["thread",31557],"thread-31550":["thread",31550],"thread-31534":["thread",31534],"thread-31520":["thread",31520],"thread-31503":["thread",31503],"thread-31485":["thread",31485],"thread-31401":["thread",31401],"thread-31398":["thread",31398],"thread-31387":["thread",31387],"thread-31385":["thread",31385],"thread-31370":["thread",31370],"thread-31321":["thread",31321],"thread-31301":["thread",31301],"thread-31060":["thread",31060],"thread-31047":["thread",31047],"thread-31046":["thread",31046],"thread-31028":["thread",31028],"thread-30901":["thread",30901],"thread-30895":["thread",30895],"thread-30861":["thread",30861],"thread-30826":["thread",30826],"thread-30729":["thread",30729],"thread-30574":["thread",30574],"thread-30541":["thread",30541],"thread-30533":["thread",30533],"thread-30466":["thread",30466],"thread-30375":["thread",30375],"thread-30373":["thread",30373],"thread-30368":["thread",30368],"thread-30326":["thread",30326],"thread-30324":["thread",30324],"thread-30250":["thread",30250],"thread-30223":["thread",30223],"thread-30191":["thread",30191],"thread-30104":["thread",30104],"thread-30073":["thread",30073],"thread-30051":["thread",30051]}, NULL, 1711693763
Run Time: 0.001034
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- 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 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20