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 (44973, 44951, 44933, 44906, 44900, 44873, 44860, 43162, 43052, 43042, 43037, 43032, 42897, 42874, 42764, 42728, 42654, 42628, 42600, 42594, 42335, 42282, 42176, 42160, 42049, 42013, 41994, 41899, 41898, 41835, 41810, 41700, 41624, 41596, 41532, 41456, 41369, 41356, 41338, 41288, 41284, 41283, 41167, 41041, 41026, 40984, 40949, 40945, 40791, 40784, 40773, 40763, 40727, 40702, 40685, 40629, 40560, 40536, 40436, 40405, 40318, 40268, 40029, 39947, 39809, 39777, 39717, 39564, 39532, 39528, 39514, 39476, 39471, 39464, 39461, 39404, 39397, 39256, 39177, 39130, 39070, 39068, 39061, 39007, 38961, 38886, 38868, 38650, 38630, 38619, 38571, 38524, 38487, 38410, 38362, 38252, 38181, 38054, 37972, 37969, 37914, 37893, 37844, 37828, 37708, 37634, 37501, 37385, 37307, 37158, 37097, 37093, 37062, 36991, 36926, 36881, 36860, 36816, 36723, 36531, 36368, 36235, 36195, 36163, 36114, 36109, 36101, 36053, 35983, 35778, 35775, 35773, 35740, 35667, 35658, 35612, 35611, 35595, 35512, 35486, 35292, 35290, 35196, 35099, 35004, 34990, 34971, 34856, 34711, 34603, 34487, 34466, 34454, 34372, 34321, 34133, 34053, 33965, 33933, 33900, 33894, 33765, 33648, 33609, 33561, 33335, 33272, 33225, 33153, 33139, 33091, 33041, 32963, 32735, 32694, 32677, 32625, 32623, 32579, 32571, 32521, 32508, 32474, 32427, 32423, 32351, 32288, 32253, 32181, 32120, 32110, 32062, 31960, 31938, 31924, 31815, 31811, 31768, 31622, 31611, 31505, 31342, 31274, 31071, 30899, 30872, 30857, 30842, 30768, 30758, 30724, 30719, 30717, 30543, 30475, 30453, 30287, 30169, 30147, 30142, 30122, 30093, 30065, 30037, 29947, 29902, 29864, 29860, 29599, 29379, 29373, 29315, 29250, 29174, 29150, 29108, 29066, 29017, 28862, 28859, 28857, 28568, 28534, 28533, 28445, 28425, 28424, 28245, 28209, 28124))
Run Time: 0.098476
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: 10, 0, 1716170440, {"thread-44973":["thread",44973],"thread-44951":["thread",44951],"thread-44933":["thread",44933],"thread-44906":["thread",44906],"thread-44873":["thread",44873],"thread-43162":["thread",43162],"thread-43042":["thread",43042],"thread-43037":["thread",43037],"thread-42897":["thread",42897],"thread-42728":["thread",42728],"thread-42594":["thread",42594],"thread-42160":["thread",42160],"thread-42013":["thread",42013],"thread-41532":["thread",41532],"thread-41456":["thread",41456],"thread-41369":["thread",41369],"thread-41283":["thread",41283],"thread-41167":["thread",41167],"thread-41041":["thread",41041],"thread-40763":["thread",40763],"thread-39777":["thread",39777],"thread-39564":["thread",39564],"thread-39514":["thread",39514],"thread-39476":["thread",39476],"thread-39397":["thread",39397],"thread-38961":["thread",38961],"thread-38619":["thread",38619],"thread-38362":["thread",38362],"thread-38252":["thread",38252],"thread-38181":["thread",38181],"thread-37385":["thread",37385],"thread-37093":["thread",37093],"thread-36816":["thread",36816],"thread-36531":["thread",36531],"thread-36195":["thread",36195],"thread-35983":["thread",35983],"thread-35611":["thread",35611],"thread-34711":["thread",34711],"thread-32110":["thread",32110],"thread-32062":["thread",32062],"thread-31938":["thread",31938],"thread-31815":["thread",31815],"thread-31768":["thread",31768],"thread-31505":["thread",31505],"thread-31342":["thread",31342],"thread-31071":["thread",31071],"thread-30768":["thread",30768],"thread-30724":["thread",30724],"thread-30719":["thread",30719],"thread-30717":["thread",30717],"thread-30475":["thread",30475],"thread-30287":["thread",30287],"thread-29315":["thread",29315],"thread-28424":["thread",28424],"thread-28245":["thread",28245],"thread-28209":["thread",28209]}, NULL, 1716166840
Run Time: 0.000509
- 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