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 (154578, 131672, 131371, 130862, 130563, 128840, 128225, 128210, 128128, 128097, 127985, 127146, 125656, 122809, 118480, 118384, 117764, 117456, 117004, 116573, 116256, 115061, 114909, 114393, 113795, 113393, 113045, 112709, 112663, 112657, 112290, 111882, 111856, 111831, 111735, 111134, 111014, 110705, 109728, 109692, 108828, 108776, 108671, 108170, 107832, 107411, 107386, 106959, 106084, 105491, 105432, 105182, 104696, 104695, 104055, 103946, 102307, 102269, 101255, 100913, 100619, 97551, 97390, 97174, 97172, 97044, 97028, 96310, 95715, 94851, 94686, 93990, 93987, 93742, 93703, 93431, 93281, 92997, 92992, 92741, 92686, 92289, 92037, 92010, 91906, 91850, 91834, 91713, 91380, 91200, 91152, 91025, 91018, 90980, 90809, 90734, 90673, 90255, 90197, 90035, 89122, 88348, 86375, 86098, 85807, 85645, 85591, 85468, 85429, 85311, 84984, 84744, 84723, 83974, 83896, 83493, 83492, 82991, 82510, 82407, 82405, 82325, 82194, 82028, 82009, 81887, 81820, 81776, 81742, 81706, 81628, 81620, 81572, 81190, 81170, 81138, 80975, 80940, 80929, 80857, 80840, 80836, 80710, 80700, 80661, 80635, 80526, 80512, 80496, 80446, 80429, 80108, 80107, 80034, 80020, 79826, 79770, 79718, 79511, 78875, 78823, 78770, 78662, 78406, 78372, 78276, 78260, 78247, 77999, 77989, 77983, 77892, 77871, 77771, 77717, 77672, 77627, 77605, 77522, 77460, 77451, 77288, 77220, 77168, 76816, 76739, 76710, 76427, 76383, 76291, 76177, 76119, 76013, 75847, 75828, 75734, 75588, 75560, 75548, 75363))
Run Time: 0.143810
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 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 1387
- 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 2729
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 126, 0, 1714372445, {"thread-154578":["thread",154578],"thread-131672":["thread",131672],"thread-131371":["thread",131371],"thread-130862":["thread",130862],"thread-130563":["thread",130563],"thread-128840":["thread",128840],"thread-128225":["thread",128225],"thread-128210":["thread",128210],"thread-128128":["thread",128128],"thread-128097":["thread",128097],"thread-127985":["thread",127985],"thread-127146":["thread",127146],"thread-125656":["thread",125656],"thread-122809":["thread",122809],"thread-118480":["thread",118480],"thread-118384":["thread",118384],"thread-117764":["thread",117764],"thread-117456":["thread",117456],"thread-117004":["thread",117004],"thread-116573":["thread",116573],"thread-116256":["thread",116256],"thread-115061":["thread",115061],"thread-114909":["thread",114909],"thread-114393":["thread",114393],"thread-113795":["thread",113795],"thread-113393":["thread",113393],"thread-113045":["thread",113045],"thread-112709":["thread",112709],"thread-112663":["thread",112663],"thread-112657":["thread",112657],"thread-112290":["thread",112290],"thread-111882":["thread",111882],"thread-111856":["thread",111856],"thread-111831":["thread",111831],"thread-111735":["thread",111735],"thread-111134":["thread",111134],"thread-111014":["thread",111014],"thread-110705":["thread",110705],"thread-109728":["thread",109728],"thread-109692":["thread",109692],"thread-108828":["thread",108828],"thread-108776":["thread",108776],"thread-108671":["thread",108671],"thread-108170":["thread",108170],"thread-107832":["thread",107832],"thread-107411":["thread",107411],"thread-107386":["thread",107386],"thread-106959":["thread",106959],"thread-106084":["thread",106084],"thread-105491":["thread",105491],"thread-105432":["thread",105432],"thread-105182":["thread",105182],"thread-104696":["thread",104696],"thread-104695":["thread",104695],"thread-104055":["thread",104055],"thread-103946":["thread",103946],"thread-102307":["thread",102307],"thread-102269":["thread",102269],"thread-101255":["thread",101255],"thread-100913":["thread",100913],"thread-100619":["thread",100619],"thread-97551":["thread",97551],"thread-97390":["thread",97390],"thread-97174":["thread",97174],"thread-97172":["thread",97172],"thread-97044":["thread",97044],"thread-97028":["thread",97028],"thread-96310":["thread",96310],"thread-95715":["thread",95715],"thread-94851":["thread",94851],"thread-94686":["thread",94686],"thread-93990":["thread",93990],"thread-93987":["thread",93987],"thread-93742":["thread",93742],"thread-93703":["thread",93703],"thread-93431":["thread",93431],"thread-93281":["thread",93281],"thread-92997":["thread",92997],"thread-92992":["thread",92992],"thread-92741":["thread",92741],"thread-92686":["thread",92686],"thread-92289":["thread",92289],"thread-92037":["thread",92037],"thread-92010":["thread",92010],"thread-91906":["thread",91906],"thread-91850":["thread",91850],"thread-91834":["thread",91834],"thread-91713":["thread",91713],"thread-91380":["thread",91380],"thread-91200":["thread",91200],"thread-91152":["thread",91152],"thread-91025":["thread",91025],"thread-91018":["thread",91018],"thread-90980":["thread",90980],"thread-90809":["thread",90809],"thread-90734":["thread",90734],"thread-90673":["thread",90673],"thread-90255":["thread",90255],"thread-90197":["thread",90197],"thread-90035":["thread",90035],"thread-89122":["thread",89122],"thread-88348":["thread",88348],"thread-86375":["thread",86375],"thread-86098":["thread",86098],"thread-85807":["thread",85807],"thread-85645":["thread",85645],"thread-85591":["thread",85591],"thread-85468":["thread",85468],"thread-85429":["thread",85429],"thread-85311":["thread",85311],"thread-84984":["thread",84984],"thread-84744":["thread",84744],"thread-84723":["thread",84723],"thread-83974":["thread",83974],"thread-83896":["thread",83896],"thread-83493":["thread",83493],"thread-83492":["thread",83492],"thread-82991":["thread",82991],"thread-82510":["thread",82510],"thread-82407":["thread",82407],"thread-82405":["thread",82405],"thread-82325":["thread",82325],"thread-82194":["thread",82194],"thread-82028":["thread",82028],"thread-82009":["thread",82009],"thread-81887":["thread",81887],"thread-81820":["thread",81820],"thread-81776":["thread",81776],"thread-81742":["thread",81742],"thread-81706":["thread",81706],"thread-81628":["thread",81628],"thread-81620":["thread",81620],"thread-81572":["thread",81572],"thread-81190":["thread",81190],"thread-81170":["thread",81170],"thread-81138":["thread",81138],"thread-80975":["thread",80975],"thread-80940":["thread",80940],"thread-80929":["thread",80929],"thread-80857":["thread",80857],"thread-80840":["thread",80840],"thread-80836":["thread",80836],"thread-80710":["thread",80710],"thread-80700":["thread",80700],"thread-80661":["thread",80661],"thread-80635":["thread",80635],"thread-80526":["thread",80526],"thread-80512":["thread",80512],"thread-80496":["thread",80496],"thread-80446":["thread",80446],"thread-80429":["thread",80429],"thread-80108":["thread",80108],"thread-80107":["thread",80107],"thread-80034":["thread",80034],"thread-80020":["thread",80020],"thread-79826":["thread",79826],"thread-79770":["thread",79770],"thread-79718":["thread",79718],"thread-79511":["thread",79511],"thread-78875":["thread",78875],"thread-78823":["thread",78823],"thread-78770":["thread",78770],"thread-78662":["thread",78662],"thread-78406":["thread",78406],"thread-78372":["thread",78372],"thread-78276":["thread",78276],"thread-78260":["thread",78260],"thread-78247":["thread",78247],"thread-77999":["thread",77999],"thread-77989":["thread",77989],"thread-77983":["thread",77983],"thread-77892":["thread",77892],"thread-77871":["thread",77871],"thread-77771":["thread",77771],"thread-77717":["thread",77717],"thread-77672":["thread",77672],"thread-77627":["thread",77627],"thread-77605":["thread",77605],"thread-77522":["thread",77522],"thread-77460":["thread",77460],"thread-77451":["thread",77451],"thread-77288":["thread",77288],"thread-77220":["thread",77220],"thread-77168":["thread",77168],"thread-76816":["thread",76816],"thread-76739":["thread",76739],"thread-76710":["thread",76710],"thread-76427":["thread",76427],"thread-76383":["thread",76383],"thread-76291":["thread",76291],"thread-76177":["thread",76177],"thread-76119":["thread",76119],"thread-76013":["thread",76013],"thread-75847":["thread",75847],"thread-75828":["thread",75828],"thread-75734":["thread",75734],"thread-75588":["thread",75588],"thread-75560":["thread",75560],"thread-75548":["thread",75548],"thread-75363":["thread",75363]}, , 1714368845
Run Time: 0.000258
- 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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20