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 (43554, 43181, 42981, 42681, 42214, 41912, 41856, 41803, 41359, 41270, 41018, 40820, 40816, 40807, 40725, 40360, 40027, 39914, 39723, 39440, 39439, 39167, 39137, 39096, 39079, 38835, 38667, 38600, 37716, 37613, 37427, 37403, 37355, 36996, 36951, 36745, 36728, 36673, 36657, 36052, 36036, 36002, 35964, 35778, 35383, 34831, 34329, 34214, 34113, 33992, 33918, 33901, 33891, 33884, 33874, 33744, 33586, 33538, 33490, 33472, 33365, 33231, 32893, 32567, 32536, 32329, 32198, 32062, 31964, 31946, 31936, 31747, 31665, 31604, 31477, 31450, 31443, 31360, 31310, 31261, 31175, 31045, 31003, 30986, 30966, 30807, 30511, 30495, 30442, 30214, 30180, 30177, 30064, 30050, 29516, 29205, 29024, 29023, 28937, 28191, 28129, 28047, 28023, 27737, 27727, 27440, 27290, 27136, 26870, 26736, 26494, 26477, 26164, 26110, 26067, 25495, 25122, 24761, 24213, 24118, 24028, 23968, 23655, 23647, 23237, 22927, 22288, 21785, 21588, 21587, 21521, 21407, 21384, 21356, 21139, 21111, 21079, 20919, 20764, 20044, 19873, 19853, 19729, 19494, 19410, 19164, 18882, 18638, 18608, 18337, 18224, 17780, 17373, 17368, 17180, 17083, 16722, 16469, 16035, 15995, 15830, 15811, 15699, 15647, 15454, 15406, 15401, 15073, 15057, 14960, 14930, 14773, 14747, 14636, 14466, 14357, 14289, 14260, 11936, 11919, 11894, 11722, 11691, 11558, 11520, 11500, 10361, 10211, 10045, 8493, 8203, 8164, 7645, 7159, 6606, 6466, 6175, 6112, 5986, 5597, 5574, 4908, 4810, 4785, 4219, 4141, 4136, 3869, 3852, 3755, 3709, 3651, 3428, 3291, 3191, 3162, 3116, 3084, 2893, 2842, 2459, 2356, 2216, 2186, 2143, 2025, 2004, 1953, 1937, 1633, 1625, 1299, 899, 628, 451, 388, 286, 279, 267, 94, 60, 58, 3182))
Run Time: 0.097686
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 243 | 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: 179, 0, 1715938328, {"thread-43554":["thread",43554],"thread-43181":["thread",43181],"thread-42981":["thread",42981],"thread-42681":["thread",42681],"thread-41912":["thread",41912],"thread-41856":["thread",41856],"thread-41803":["thread",41803],"thread-41359":["thread",41359],"thread-41270":["thread",41270],"thread-41018":["thread",41018],"thread-40816":["thread",40816],"thread-40807":["thread",40807],"thread-40725":["thread",40725],"thread-40360":["thread",40360],"thread-39914":["thread",39914],"thread-39723":["thread",39723],"thread-39440":["thread",39440],"thread-39439":["thread",39439],"thread-39137":["thread",39137],"thread-39096":["thread",39096],"thread-39079":["thread",39079],"thread-38667":["thread",38667],"thread-38600":["thread",38600],"thread-37613":["thread",37613],"thread-37427":["thread",37427],"thread-37403":["thread",37403],"thread-37355":["thread",37355],"thread-36996":["thread",36996],"thread-36951":["thread",36951],"thread-36745":["thread",36745],"thread-36728":["thread",36728],"thread-36673":["thread",36673],"thread-36657":["thread",36657],"thread-36052":["thread",36052],"thread-36036":["thread",36036],"thread-36002":["thread",36002],"thread-35964":["thread",35964],"thread-35383":["thread",35383],"thread-34831":["thread",34831],"thread-34329":["thread",34329],"thread-34214":["thread",34214],"thread-34113":["thread",34113],"thread-33992":["thread",33992],"thread-33891":["thread",33891],"thread-33874":["thread",33874],"thread-33586":["thread",33586],"thread-33538":["thread",33538],"thread-33490":["thread",33490],"thread-33472":["thread",33472],"thread-33365":["thread",33365],"thread-33231":["thread",33231],"thread-32893":["thread",32893],"thread-32567":["thread",32567],"thread-32536":["thread",32536],"thread-32329":["thread",32329],"thread-32198":["thread",32198],"thread-32062":["thread",32062],"thread-31964":["thread",31964],"thread-31946":["thread",31946],"thread-31936":["thread",31936],"thread-31747":["thread",31747],"thread-31665":["thread",31665],"thread-31604":["thread",31604],"thread-31450":["thread",31450],"thread-31443":["thread",31443],"thread-31360":["thread",31360],"thread-31310":["thread",31310],"thread-31261":["thread",31261],"thread-31175":["thread",31175],"thread-31045":["thread",31045],"thread-31003":["thread",31003],"thread-30986":["thread",30986],"thread-30966":["thread",30966],"thread-30807":["thread",30807],"thread-30511":["thread",30511],"thread-30495":["thread",30495],"thread-30442":["thread",30442],"thread-30214":["thread",30214],"thread-30180":["thread",30180],"thread-30177":["thread",30177],"thread-30064":["thread",30064],"thread-30050":["thread",30050],"thread-29205":["thread",29205],"thread-29024":["thread",29024],"thread-29023":["thread",29023],"thread-28937":["thread",28937],"thread-28191":["thread",28191],"thread-28129":["thread",28129],"thread-28047":["thread",28047],"thread-28023":["thread",28023],"thread-27737":["thread",27737],"thread-27440":["thread",27440],"thread-27290":["thread",27290],"thread-27136":["thread",27136],"thread-26870":["thread",26870],"thread-26736":["thread",26736],"thread-26494":["thread",26494],"thread-26164":["thread",26164],"thread-26110":["thread",26110],"thread-26067":["thread",26067],"thread-25122":["thread",25122],"thread-24761":["thread",24761],"thread-24213":["thread",24213],"thread-24028":["thread",24028],"thread-23968":["thread",23968],"thread-23655":["thread",23655],"thread-23647":["thread",23647],"thread-23237":["thread",23237],"thread-22927":["thread",22927],"thread-22288":["thread",22288],"thread-21785":["thread",21785],"thread-21588":["thread",21588],"thread-21587":["thread",21587],"thread-21521":["thread",21521],"thread-21407":["thread",21407],"thread-21384":["thread",21384],"thread-21356":["thread",21356],"thread-21139":["thread",21139],"thread-21111":["thread",21111],"thread-21079":["thread",21079],"thread-20919":["thread",20919],"thread-20764":["thread",20764],"thread-20044":["thread",20044],"thread-19873":["thread",19873],"thread-19853":["thread",19853],"thread-19729":["thread",19729],"thread-19494":["thread",19494],"thread-19410":["thread",19410],"thread-19164":["thread",19164],"thread-18882":["thread",18882],"thread-18638":["thread",18638],"thread-18608":["thread",18608],"thread-18337":["thread",18337],"thread-18224":["thread",18224],"thread-17780":["thread",17780],"thread-17373":["thread",17373],"thread-17368":["thread",17368],"thread-16722":["thread",16722],"thread-16469":["thread",16469],"thread-16035":["thread",16035],"thread-15830":["thread",15830],"thread-15811":["thread",15811],"thread-15699":["thread",15699],"thread-15647":["thread",15647],"thread-15454":["thread",15454],"thread-15406":["thread",15406],"thread-15401":["thread",15401],"thread-15073":["thread",15073],"thread-15057":["thread",15057],"thread-14960":["thread",14960],"thread-14930":["thread",14930],"thread-14773":["thread",14773],"thread-14747":["thread",14747],"thread-14636":["thread",14636],"thread-14466":["thread",14466],"thread-14357":["thread",14357],"thread-14289":["thread",14289],"thread-14260":["thread",14260],"thread-11936":["thread",11936],"thread-11919":["thread",11919],"thread-11894":["thread",11894],"thread-11722":["thread",11722],"thread-11691":["thread",11691],"thread-11558":["thread",11558],"thread-11520":["thread",11520],"thread-11500":["thread",11500],"thread-10361":["thread",10361],"thread-10211":["thread",10211],"thread-10045":["thread",10045],"thread-8493":["thread",8493],"thread-8203":["thread",8203],"thread-8164":["thread",8164],"thread-7645":["thread",7645],"thread-7159":["thread",7159],"thread-6606":["thread",6606],"thread-6466":["thread",6466],"thread-6175":["thread",6175],"thread-6112":["thread",6112],"thread-5986":["thread",5986],"thread-5597":["thread",5597],"thread-5574":["thread",5574],"thread-4908":["thread",4908],"thread-4810":["thread",4810],"thread-4785":["thread",4785],"thread-4219":["thread",4219],"thread-4141":["thread",4141],"thread-4136":["thread",4136],"thread-3869":["thread",3869],"thread-3852":["thread",3852],"thread-3755":["thread",3755],"thread-3709":["thread",3709],"thread-3651":["thread",3651],"thread-3428":["thread",3428],"thread-3291":["thread",3291],"thread-3191":["thread",3191],"thread-3162":["thread",3162],"thread-3116":["thread",3116],"thread-3084":["thread",3084],"thread-2893":["thread",2893],"thread-2842":["thread",2842],"thread-2459":["thread",2459],"thread-2356":["thread",2356],"thread-2216":["thread",2216],"thread-2143":["thread",2143],"thread-2025":["thread",2025],"thread-2004":["thread",2004],"thread-1953":["thread",1953],"thread-1937":["thread",1937],"thread-1633":["thread",1633],"thread-1625":["thread",1625],"thread-1299":["thread",1299],"thread-899":["thread",899],"thread-628":["thread",628],"thread-451":["thread",451],"thread-388":["thread",388],"thread-286":["thread",286],"thread-279":["thread",279],"thread-267":["thread",267],"thread-94":["thread",94],"thread-60":["thread",60],"thread-58":["thread",58],"thread-3182":["thread",3182]}, NULL, 1715934728
Run Time: 0.001056
- 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