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 (44946, 44942, 43577, 43565, 43502, 43498, 43383, 43353, 43197, 43119, 42928, 42873, 42833, 42651, 42531, 42393, 42371, 42345, 42339, 42011, 41996, 41800, 41489, 41479, 41389, 41183, 41067, 41062, 40947, 40768, 40710, 40650, 40484, 40345, 40259, 39937, 39928, 39844, 39841, 39765, 39564, 39545, 39487, 39130, 38898, 38890, 38632, 38428, 38384, 38069, 38010, 37762, 37470, 37334, 36979, 36810, 36708, 36599, 36551, 36511, 36476, 36135, 36078, 36021, 35867, 35735, 35732, 35656, 35513, 35333, 35324, 35000, 34738, 34711, 34488, 34476, 34288, 34147, 34061, 33926, 33709, 33444, 33426, 33358, 33152, 33115, 32998, 32837, 32790, 32679, 32348, 32287, 31990, 31746, 31711, 31701, 31671, 31643, 31610, 31575, 31444, 31237, 31156, 31050, 30915, 30625, 30350, 30330, 30300, 30286, 30261, 30258, 30240, 30217, 30051, 20467, 29936, 29726, 29654, 29620, 29568, 28983, 28933, 28771, 28665, 28593, 28384, 28322, 28207, 28206, 27945, 27879, 27878, 27820, 27794, 27787, 27705, 27704, 27420, 27405, 27149, 27128, 26931, 26873, 26526, 26387, 26208, 25994, 25921, 25913, 25908, 25559, 25532, 25450, 25387, 25367, 25353, 25340, 24517, 24406, 24315, 24254, 24173, 24023, 23797, 23486, 23362, 23325, 23158, 23068, 22933, 22927, 21588, 21127, 20945, 20933, 20854, 20249, 20002, 19987, 19775, 19694, 19585, 19573, 19508, 19507, 19479, 19317, 19280, 19188, 19132, 19060, 18946, 18880, 18815, 18080, 17872, 17781, 17780, 17590, 16930, 16656, 16638, 16503, 16357, 16305, 15894, 15890, 15806, 15797, 15484, 15470, 15399, 14804, 14660, 14581, 14464, 14132, 14062, 14048, 13647, 13643, 12619, 12479, 12295, 12272, 12264, 11128, 11094, 11085, 10906, 10881, 10627, 8378, 8344, 8343, 8112, 8021, 7774, 7770, 7584, 7349, 7307, 7014, 6621, 6546, 6363, 6188, 5966, 5708))
Run Time: 0.091557
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: 21, 0, 1714764709, {"thread-43565":["thread",43565],"thread-43498":["thread",43498],"thread-43383":["thread",43383],"thread-43353":["thread",43353],"thread-43197":["thread",43197],"thread-43119":["thread",43119],"thread-42928":["thread",42928],"thread-42833":["thread",42833],"thread-42345":["thread",42345],"thread-41996":["thread",41996],"thread-41183":["thread",41183],"thread-41067":["thread",41067],"thread-41062":["thread",41062],"thread-40768":["thread",40768],"thread-40710":["thread",40710],"thread-40484":["thread",40484],"thread-40345":["thread",40345],"thread-39928":["thread",39928],"thread-39844":["thread",39844],"thread-39564":["thread",39564],"thread-39487":["thread",39487],"thread-38898":["thread",38898],"thread-38890":["thread",38890],"thread-38632":["thread",38632],"thread-38428":["thread",38428],"thread-38384":["thread",38384],"thread-38010":["thread",38010],"thread-37334":["thread",37334],"thread-36979":["thread",36979],"thread-36810":["thread",36810],"thread-36708":["thread",36708],"thread-36551":["thread",36551],"thread-36511":["thread",36511],"thread-36476":["thread",36476],"thread-36021":["thread",36021],"thread-35867":["thread",35867],"thread-35732":["thread",35732],"thread-35656":["thread",35656],"thread-35513":["thread",35513],"thread-35333":["thread",35333],"thread-35324":["thread",35324],"thread-35000":["thread",35000],"thread-34711":["thread",34711],"thread-34488":["thread",34488],"thread-34476":["thread",34476],"thread-34288":["thread",34288],"thread-34147":["thread",34147],"thread-34061":["thread",34061],"thread-33926":["thread",33926],"thread-33709":["thread",33709],"thread-33358":["thread",33358],"thread-33152":["thread",33152],"thread-32998":["thread",32998],"thread-32837":["thread",32837],"thread-32348":["thread",32348],"thread-32287":["thread",32287],"thread-31701":["thread",31701],"thread-31610":["thread",31610],"thread-31575":["thread",31575],"thread-31444":["thread",31444],"thread-31237":["thread",31237],"thread-31156":["thread",31156],"thread-31050":["thread",31050],"thread-30350":["thread",30350],"thread-30330":["thread",30330],"thread-30261":["thread",30261],"thread-30240":["thread",30240],"thread-30217":["thread",30217],"thread-30051":["thread",30051],"thread-29936":["thread",29936],"thread-29726":["thread",29726],"thread-29654":["thread",29654],"thread-29620":["thread",29620],"thread-29568":["thread",29568],"thread-28983":["thread",28983],"thread-28771":["thread",28771],"thread-28665":["thread",28665],"thread-28593":["thread",28593],"thread-28384":["thread",28384],"thread-28322":["thread",28322],"thread-28206":["thread",28206],"thread-27945":["thread",27945],"thread-27879":["thread",27879],"thread-27878":["thread",27878],"thread-27787":["thread",27787],"thread-27704":["thread",27704],"thread-27420":["thread",27420],"thread-27405":["thread",27405],"thread-27149":["thread",27149],"thread-27128":["thread",27128],"thread-26931":["thread",26931],"thread-26526":["thread",26526],"thread-26387":["thread",26387],"thread-25921":["thread",25921],"thread-25913":["thread",25913],"thread-25908":["thread",25908],"thread-25450":["thread",25450],"thread-25387":["thread",25387],"thread-25367":["thread",25367],"thread-25353":["thread",25353],"thread-25340":["thread",25340],"thread-24517":["thread",24517],"thread-24406":["thread",24406],"thread-24315":["thread",24315],"thread-24254":["thread",24254],"thread-24173":["thread",24173],"thread-24023":["thread",24023],"thread-23797":["thread",23797],"thread-23486":["thread",23486],"thread-23362":["thread",23362],"thread-23325":["thread",23325],"thread-23158":["thread",23158],"thread-23068":["thread",23068],"thread-22933":["thread",22933],"thread-22927":["thread",22927],"thread-21588":["thread",21588],"thread-21127":["thread",21127],"thread-20933":["thread",20933],"thread-20249":["thread",20249],"thread-20002":["thread",20002],"thread-19775":["thread",19775],"thread-19694":["thread",19694],"thread-19585":["thread",19585],"thread-19573":["thread",19573],"thread-19508":["thread",19508],"thread-19507":["thread",19507],"thread-19479":["thread",19479],"thread-19317":["thread",19317],"thread-19280":["thread",19280],"thread-19188":["thread",19188],"thread-19132":["thread",19132],"thread-19060":["thread",19060],"thread-18946":["thread",18946],"thread-18880":["thread",18880],"thread-18815":["thread",18815],"thread-17872":["thread",17872],"thread-17781":["thread",17781],"thread-17780":["thread",17780],"thread-17590":["thread",17590],"thread-16930":["thread",16930],"thread-16656":["thread",16656],"thread-16638":["thread",16638],"thread-16503":["thread",16503],"thread-16357":["thread",16357],"thread-16305":["thread",16305],"thread-15894":["thread",15894],"thread-15806":["thread",15806],"thread-15797":["thread",15797],"thread-15484":["thread",15484],"thread-15399":["thread",15399],"thread-14804":["thread",14804],"thread-14660":["thread",14660],"thread-14581":["thread",14581],"thread-14464":["thread",14464],"thread-14132":["thread",14132],"thread-14062":["thread",14062],"thread-14048":["thread",14048],"thread-13647":["thread",13647],"thread-12619":["thread",12619],"thread-12479":["thread",12479],"thread-12295":["thread",12295],"thread-12272":["thread",12272],"thread-11094":["thread",11094],"thread-11085":["thread",11085],"thread-10906":["thread",10906],"thread-10881":["thread",10881],"thread-10627":["thread",10627],"thread-8378":["thread",8378],"thread-8344":["thread",8344],"thread-8343":["thread",8343],"thread-8112":["thread",8112],"thread-8021":["thread",8021],"thread-7774":["thread",7774],"thread-7770":["thread",7770],"thread-7584":["thread",7584],"thread-7349":["thread",7349],"thread-7307":["thread",7307],"thread-7014":["thread",7014],"thread-6621":["thread",6621],"thread-6363":["thread",6363],"thread-5966":["thread",5966],"thread-5708":["thread",5708]}, NULL, 1714761109
Run Time: 0.001925
- 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