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 (108847, 108589, 108493, 108111, 108055, 107995, 107895, 107805, 107431, 107393, 107134, 107003, 106596, 106074, 106059, 106000, 105655, 105355, 105044, 104838, 104823, 104488, 104480, 104437, 102847, 102807, 102658, 102337, 102185, 102136, 102096, 102001, 101004, 100308, 100041, 99973, 99972, 99942, 99670, 99567, 98980, 98801, 98775, 98583, 98461, 98356, 98279, 98254, 98084, 97831, 97781, 97326, 97317, 96926, 96797, 96492, 96404, 96177, 95462, 95117, 94796, 94699, 94659, 94124, 93859, 93811, 93768, 93656, 93614, 93535, 93113, 92953, 92933, 92892, 92798, 92781, 92759, 92748, 92747, 92583, 92547, 92385, 92200, 91891, 91759, 91665, 91570, 91395, 91330, 91086, 90788, 90678, 90661, 90597, 90591, 90555, 90421, 90226, 90003, 89966, 89839, 89711, 89686, 89676, 89645, 89507, 89239, 88854, 88615, 88580, 88323, 87914, 87242, 87233, 87135, 87045, 87014, 86440, 86293, 86125, 86066, 86033, 85948, 85589, 85538, 85530, 85424, 85396, 85394, 85216, 85001, 84892, 84738, 84690, 84679, 84672, 84668, 84564, 84553, 84512, 84239, 83988, 83884, 83874, 83711, 83419, 83264, 83241, 83045, 82990, 82843, 82754, 82326, 82224, 82166, 82080, 82030, 81817, 81497, 81340, 81022, 80946, 80887, 80688, 80535, 80418, 80369, 80341, 80152, 79806, 79735, 79678, 79433, 79400, 79274, 79133, 79098, 79020, 78731, 78516, 78495, 78394, 78355, 78350, 78302, 78269, 78166, 77708, 77700, 77487, 77446, 77387, 77314, 77122, 77032, 77024, 76844, 76571, 76447, 76414))
Run Time: 0.009013
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,terrylove_forums.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: 98, 0, 1715228846, {"thread-108847":["thread",108847],"thread-108589":["thread",108589],"thread-108493":["thread",108493],"thread-108111":["thread",108111],"thread-108055":["thread",108055],"thread-107995":["thread",107995],"thread-107895":["thread",107895],"thread-107805":["thread",107805],"thread-107431":["thread",107431],"thread-107393":["thread",107393],"thread-107134":["thread",107134],"thread-107003":["thread",107003],"thread-106596":["thread",106596],"thread-106074":["thread",106074],"thread-106059":["thread",106059],"thread-106000":["thread",106000],"thread-105655":["thread",105655],"thread-105355":["thread",105355],"thread-105044":["thread",105044],"thread-104838":["thread",104838],"thread-104823":["thread",104823],"thread-104488":["thread",104488],"thread-104480":["thread",104480],"thread-104437":["thread",104437],"thread-102847":["thread",102847],"thread-102807":["thread",102807],"thread-102658":["thread",102658],"thread-102337":["thread",102337],"thread-102185":["thread",102185],"thread-102136":["thread",102136],"thread-102096":["thread",102096],"thread-102001":["thread",102001],"thread-101004":["thread",101004],"thread-100308":["thread",100308],"thread-100041":["thread",100041],"thread-99973":["thread",99973],"thread-99972":["thread",99972],"thread-99942":["thread",99942],"thread-99670":["thread",99670],"thread-99567":["thread",99567],"thread-98980":["thread",98980],"thread-98801":["thread",98801],"thread-98775":["thread",98775],"thread-98583":["thread",98583],"thread-98461":["thread",98461],"thread-98356":["thread",98356],"thread-98279":["thread",98279],"thread-98254":["thread",98254],"thread-98084":["thread",98084],"thread-97831":["thread",97831],"thread-97781":["thread",97781],"thread-97326":["thread",97326],"thread-97317":["thread",97317],"thread-96926":["thread",96926],"thread-96797":["thread",96797],"thread-96492":["thread",96492],"thread-96404":["thread",96404],"thread-96177":["thread",96177],"thread-95462":["thread",95462],"thread-95117":["thread",95117],"thread-94796":["thread",94796],"thread-94699":["thread",94699],"thread-94659":["thread",94659],"thread-94124":["thread",94124],"thread-93859":["thread",93859],"thread-93811":["thread",93811],"thread-93768":["thread",93768],"thread-93656":["thread",93656],"thread-93614":["thread",93614],"thread-93535":["thread",93535],"thread-93113":["thread",93113],"thread-92953":["thread",92953],"thread-92933":["thread",92933],"thread-92892":["thread",92892],"thread-92798":["thread",92798],"thread-92781":["thread",92781],"thread-92759":["thread",92759],"thread-92748":["thread",92748],"thread-92747":["thread",92747],"thread-92583":["thread",92583],"thread-92547":["thread",92547],"thread-92385":["thread",92385],"thread-92200":["thread",92200],"thread-91891":["thread",91891],"thread-91759":["thread",91759],"thread-91665":["thread",91665],"thread-91570":["thread",91570],"thread-91395":["thread",91395],"thread-91330":["thread",91330],"thread-91086":["thread",91086],"thread-90788":["thread",90788],"thread-90678":["thread",90678],"thread-90661":["thread",90661],"thread-90597":["thread",90597],"thread-90591":["thread",90591],"thread-90555":["thread",90555],"thread-90421":["thread",90421],"thread-90226":["thread",90226],"thread-90003":["thread",90003],"thread-89966":["thread",89966],"thread-89839":["thread",89839],"thread-89711":["thread",89711],"thread-89686":["thread",89686],"thread-89676":["thread",89676],"thread-89645":["thread",89645],"thread-89507":["thread",89507],"thread-89239":["thread",89239],"thread-88854":["thread",88854],"thread-88615":["thread",88615],"thread-88580":["thread",88580],"thread-88323":["thread",88323],"thread-87914":["thread",87914],"thread-87242":["thread",87242],"thread-87233":["thread",87233],"thread-87135":["thread",87135],"thread-87045":["thread",87045],"thread-87014":["thread",87014],"thread-86440":["thread",86440],"thread-86293":["thread",86293],"thread-86125":["thread",86125],"thread-86066":["thread",86066],"thread-86033":["thread",86033],"thread-85948":["thread",85948],"thread-85589":["thread",85589],"thread-85538":["thread",85538],"thread-85530":["thread",85530],"thread-85424":["thread",85424],"thread-85396":["thread",85396],"thread-85394":["thread",85394],"thread-85216":["thread",85216],"thread-85001":["thread",85001],"thread-84892":["thread",84892],"thread-84738":["thread",84738],"thread-84690":["thread",84690],"thread-84679":["thread",84679],"thread-84672":["thread",84672],"thread-84668":["thread",84668],"thread-84564":["thread",84564],"thread-84553":["thread",84553],"thread-84512":["thread",84512],"thread-84239":["thread",84239],"thread-83988":["thread",83988],"thread-83884":["thread",83884],"thread-83874":["thread",83874],"thread-83711":["thread",83711],"thread-83419":["thread",83419],"thread-83264":["thread",83264],"thread-83241":["thread",83241],"thread-83045":["thread",83045],"thread-82990":["thread",82990],"thread-82843":["thread",82843],"thread-82754":["thread",82754],"thread-82326":["thread",82326],"thread-82224":["thread",82224],"thread-82166":["thread",82166],"thread-82080":["thread",82080],"thread-82030":["thread",82030],"thread-81817":["thread",81817],"thread-81497":["thread",81497],"thread-81340":["thread",81340],"thread-81022":["thread",81022],"thread-80946":["thread",80946],"thread-80887":["thread",80887],"thread-80688":["thread",80688],"thread-80535":["thread",80535],"thread-80418":["thread",80418],"thread-80369":["thread",80369],"thread-80341":["thread",80341],"thread-80152":["thread",80152],"thread-79806":["thread",79806],"thread-79735":["thread",79735],"thread-79678":["thread",79678],"thread-79433":["thread",79433],"thread-79400":["thread",79400],"thread-79274":["thread",79274],"thread-79133":["thread",79133],"thread-79098":["thread",79098],"thread-79020":["thread",79020],"thread-78731":["thread",78731],"thread-78516":["thread",78516],"thread-78495":["thread",78495],"thread-78394":["thread",78394],"thread-78355":["thread",78355],"thread-78350":["thread",78350],"thread-78302":["thread",78302],"thread-78269":["thread",78269],"thread-78166":["thread",78166],"thread-77708":["thread",77708],"thread-77700":["thread",77700],"thread-77487":["thread",77487],"thread-77446":["thread",77446],"thread-77387":["thread",77387],"thread-77314":["thread",77314],"thread-77122":["thread",77122],"thread-77032":["thread",77032],"thread-77024":["thread",77024],"thread-76844":["thread",76844],"thread-76571":["thread",76571],"thread-76447":["thread",76447],"thread-76414":["thread",76414]}, NULL, 1715225246
Run Time: 0.000253
- 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