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 (43348, 43231, 43177, 43153, 43150, 43147, 43110, 43109, 43104, 43059, 43009, 42986, 42982, 42962, 42952, 42945, 42942, 42923, 42918, 42901, 42896, 42890, 42862, 42857, 42837, 42834, 42805, 42789, 42736, 42515, 42415, 42328, 42295, 42176, 42079, 42052, 42021, 41986, 41825, 41815, 41801, 41737, 41694, 41661, 41651, 41612, 41596, 41595, 41560, 41478, 41460, 41457, 41445, 41334, 41044, 41000, 40993, 40953, 40943, 40829, 40802, 40773, 40741, 40602, 40575, 40569, 40555, 40536, 40525, 40470, 40289, 40277, 40261, 40009, 39998, 39940, 39893, 39890, 39874, 39849, 39802, 39787, 39750, 39727, 39688, 39682, 39603, 39590, 39557, 39474, 39456, 39440, 39439, 39428, 39309, 39289, 39288, 39264, 39228, 39198, 39190, 39188, 39176, 39170, 39115, 39088, 39066, 39010, 39004, 38922, 38741, 38727, 38713, 38660, 38567, 38442, 38393, 38367, 38358, 38286, 38184, 38101, 38099, 38053, 38016, 37991, 37989, 37962, 37949, 37948, 37920, 37904, 37859, 37849, 37846, 37671, 37639, 37555, 37551, 37532, 37522, 37521, 37515, 37503, 37501, 37478, 37404, 37387, 37307, 37298, 37260, 37251, 37246, 37238, 37065, 37045, 37028, 37004, 36985, 36959, 36924, 36806, 36787, 36682, 36679, 36575, 36574, 36567, 36531, 36437, 36432, 36412, 36389, 36244, 36240, 36215, 36198, 36196, 36147, 36103, 36085, 36082, 36073, 36037, 35974, 35968, 35954, 35899, 35851, 35824, 35733, 35646, 35604, 35368, 35364, 35362, 35270, 35196, 35163, 35153, 35138, 35104, 35039, 34914, 34883, 34874, 34848, 34828, 34757, 34701, 34697, 34671, 34498, 34487, 34486, 34449, 34414, 34376, 34337, 34321, 34294, 34200, 34196, 34181, 34180, 34135, 34134, 34102, 34082, 34065, 34045, 34021, 33956, 33947, 33800, 33793, 33751, 33738, 33717, 33712, 33703, 33679, 33660, 33577, 33517, 33473, 33416, 33392, 33386, 33372))
Run Time: 0.078210
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: 158, 0, 1715716821, {"thread-43348":["thread",43348],"thread-43177":["thread",43177],"thread-43153":["thread",43153],"thread-43150":["thread",43150],"thread-43147":["thread",43147],"thread-43110":["thread",43110],"thread-43109":["thread",43109],"thread-43104":["thread",43104],"thread-43059":["thread",43059],"thread-43009":["thread",43009],"thread-42986":["thread",42986],"thread-42982":["thread",42982],"thread-42962":["thread",42962],"thread-42952":["thread",42952],"thread-42945":["thread",42945],"thread-42942":["thread",42942],"thread-42923":["thread",42923],"thread-42918":["thread",42918],"thread-42901":["thread",42901],"thread-42896":["thread",42896],"thread-42890":["thread",42890],"thread-42862":["thread",42862],"thread-42857":["thread",42857],"thread-42837":["thread",42837],"thread-42805":["thread",42805],"thread-42789":["thread",42789],"thread-42415":["thread",42415],"thread-42328":["thread",42328],"thread-42295":["thread",42295],"thread-42079":["thread",42079],"thread-42052":["thread",42052],"thread-42021":["thread",42021],"thread-41986":["thread",41986],"thread-41825":["thread",41825],"thread-41815":["thread",41815],"thread-41801":["thread",41801],"thread-41737":["thread",41737],"thread-41694":["thread",41694],"thread-41661":["thread",41661],"thread-41651":["thread",41651],"thread-41612":["thread",41612],"thread-41560":["thread",41560],"thread-41478":["thread",41478],"thread-41460":["thread",41460],"thread-41457":["thread",41457],"thread-41044":["thread",41044],"thread-41000":["thread",41000],"thread-40993":["thread",40993],"thread-40953":["thread",40953],"thread-40829":["thread",40829],"thread-40602":["thread",40602],"thread-40575":["thread",40575],"thread-40470":["thread",40470],"thread-40289":["thread",40289],"thread-40277":["thread",40277],"thread-40261":["thread",40261],"thread-39998":["thread",39998],"thread-39890":["thread",39890],"thread-39874":["thread",39874],"thread-39849":["thread",39849],"thread-39802":["thread",39802],"thread-39787":["thread",39787],"thread-39727":["thread",39727],"thread-39688":["thread",39688],"thread-39682":["thread",39682],"thread-39590":["thread",39590],"thread-39474":["thread",39474],"thread-39456":["thread",39456],"thread-39440":["thread",39440],"thread-39439":["thread",39439],"thread-39428":["thread",39428],"thread-39309":["thread",39309],"thread-39289":["thread",39289],"thread-39288":["thread",39288],"thread-39264":["thread",39264],"thread-39228":["thread",39228],"thread-39198":["thread",39198],"thread-39190":["thread",39190],"thread-39188":["thread",39188],"thread-39176":["thread",39176],"thread-39170":["thread",39170],"thread-39115":["thread",39115],"thread-39088":["thread",39088],"thread-39066":["thread",39066],"thread-39010":["thread",39010],"thread-39004":["thread",39004],"thread-38741":["thread",38741],"thread-38727":["thread",38727],"thread-38713":["thread",38713],"thread-38660":["thread",38660],"thread-38567":["thread",38567],"thread-38442":["thread",38442],"thread-38393":["thread",38393],"thread-38367":["thread",38367],"thread-38358":["thread",38358],"thread-38184":["thread",38184],"thread-38101":["thread",38101],"thread-38099":["thread",38099],"thread-38053":["thread",38053],"thread-38016":["thread",38016],"thread-37991":["thread",37991],"thread-37989":["thread",37989],"thread-37962":["thread",37962],"thread-37949":["thread",37949],"thread-37948":["thread",37948],"thread-37904":["thread",37904],"thread-37859":["thread",37859],"thread-37849":["thread",37849],"thread-37671":["thread",37671],"thread-37639":["thread",37639],"thread-37555":["thread",37555],"thread-37521":["thread",37521],"thread-37503":["thread",37503],"thread-37478":["thread",37478],"thread-37404":["thread",37404],"thread-37387":["thread",37387],"thread-37298":["thread",37298],"thread-37260":["thread",37260],"thread-37251":["thread",37251],"thread-37246":["thread",37246],"thread-37238":["thread",37238],"thread-37045":["thread",37045],"thread-37004":["thread",37004],"thread-36806":["thread",36806],"thread-36682":["thread",36682],"thread-36575":["thread",36575],"thread-36574":["thread",36574],"thread-36531":["thread",36531],"thread-36437":["thread",36437],"thread-36432":["thread",36432],"thread-36412":["thread",36412],"thread-36244":["thread",36244],"thread-36240":["thread",36240],"thread-36215":["thread",36215],"thread-36198":["thread",36198],"thread-36196":["thread",36196],"thread-36147":["thread",36147],"thread-36103":["thread",36103],"thread-36085":["thread",36085],"thread-36082":["thread",36082],"thread-36073":["thread",36073],"thread-36037":["thread",36037],"thread-35974":["thread",35974],"thread-35968":["thread",35968],"thread-35899":["thread",35899],"thread-35851":["thread",35851],"thread-35733":["thread",35733],"thread-35646":["thread",35646],"thread-35604":["thread",35604],"thread-35368":["thread",35368],"thread-35364":["thread",35364],"thread-35362":["thread",35362],"thread-35270":["thread",35270],"thread-35163":["thread",35163],"thread-35138":["thread",35138],"thread-35104":["thread",35104],"thread-34914":["thread",34914],"thread-34828":["thread",34828],"thread-34757":["thread",34757],"thread-34701":["thread",34701],"thread-34697":["thread",34697],"thread-34498":["thread",34498],"thread-34486":["thread",34486],"thread-34414":["thread",34414],"thread-34376":["thread",34376],"thread-34337":["thread",34337],"thread-34196":["thread",34196],"thread-34181":["thread",34181],"thread-34134":["thread",34134],"thread-34021":["thread",34021],"thread-33956":["thread",33956],"thread-33947":["thread",33947],"thread-33800":["thread",33800],"thread-33751":["thread",33751],"thread-33717":["thread",33717],"thread-33577":["thread",33577],"thread-33473":["thread",33473],"thread-33416":["thread",33416],"thread-33392":["thread",33392],"thread-33372":["thread",33372]}, NULL, 1715713221
Run Time: 0.001313
- 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