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 (182814, 181694, 180109, 173265, 172672, 172615, 167910, 167651, 166535, 162894, 162873, 161520, 161123, 161052, 159757, 159057, 158059, 155495, 154886, 154821, 154724, 154428, 153909, 153857, 153079, 149224, 133645, 133387, 131907, 131198, 131034, 130926, 130265, 130142, 130140, 130120, 130104, 130103, 130039, 129881, 129868, 129857, 129833, 129744, 129677, 129527, 129432, 129427, 129400, 129265, 129249, 129170, 129134, 129103, 129101, 128986, 128937, 128926, 128923, 128757, 128746, 128655, 128590, 128549, 128420, 128415, 128359, 128299, 128167, 128076, 127943, 127830, 127647, 127514, 127497, 127359, 127292, 127280, 126988, 126980, 126920, 126873, 126825, 126807, 126792, 126790, 126763, 126757, 126753, 126696, 126671, 126658, 126622, 126580, 126548, 126509, 126479, 126469, 126391, 126208, 126126, 126100, 126048, 125995, 125818, 125736, 125623, 125580, 125550, 125506, 125410, 125398, 125254, 125098, 125092, 124929, 124881, 124772, 124607, 124590, 123964, 123773, 123690, 123651, 123611, 123610, 123488, 123484, 123440, 123346, 123299, 123291, 123273, 123235, 123232, 123076, 122889, 122878, 122829, 122650, 122608, 122569, 122554, 122503, 122485, 122454, 122451, 122340, 122285, 122273, 122257, 122251, 122178, 122135, 122100, 121943, 121795, 121776, 121738, 121564, 121527, 121428, 121416, 121358, 121312, 121311, 121281, 121264, 121247, 121239, 118100, 117844, 117786, 116908, 116011, 116003, 115989, 114714, 114685, 114683, 114309, 113397, 113220, 113116, 112082, 111122, 108437, 107541, 106234, 104027, 103488, 100859, 94251, 92647, 92643, 92642, 92641, 90753, 90522, 90519))
Run Time: 0.137765
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: 5540, 0, 1714721939, {"thread-182814":["thread",182814],"thread-181694":["thread",181694],"thread-180109":["thread",180109],"thread-173265":["thread",173265],"thread-172672":["thread",172672],"thread-172615":["thread",172615],"thread-167910":["thread",167910],"thread-167651":["thread",167651],"thread-166535":["thread",166535],"thread-162894":["thread",162894],"thread-161520":["thread",161520],"thread-161123":["thread",161123],"thread-161052":["thread",161052],"thread-159757":["thread",159757],"thread-159057":["thread",159057],"thread-158059":["thread",158059],"thread-154886":["thread",154886],"thread-154724":["thread",154724],"thread-154428":["thread",154428],"thread-149224":["thread",149224],"thread-133645":["thread",133645],"thread-133387":["thread",133387],"thread-131907":["thread",131907],"thread-131198":["thread",131198],"thread-131034":["thread",131034],"thread-130926":["thread",130926],"thread-130265":["thread",130265],"thread-130142":["thread",130142],"thread-130140":["thread",130140],"thread-130120":["thread",130120],"thread-130104":["thread",130104],"thread-130103":["thread",130103],"thread-130039":["thread",130039],"thread-129881":["thread",129881],"thread-129868":["thread",129868],"thread-129857":["thread",129857],"thread-129833":["thread",129833],"thread-129744":["thread",129744],"thread-129677":["thread",129677],"thread-129527":["thread",129527],"thread-129432":["thread",129432],"thread-129427":["thread",129427],"thread-129400":["thread",129400],"thread-129265":["thread",129265],"thread-129249":["thread",129249],"thread-129170":["thread",129170],"thread-129134":["thread",129134],"thread-129103":["thread",129103],"thread-129101":["thread",129101],"thread-128986":["thread",128986],"thread-128937":["thread",128937],"thread-128926":["thread",128926],"thread-128923":["thread",128923],"thread-128757":["thread",128757],"thread-128746":["thread",128746],"thread-128655":["thread",128655],"thread-128590":["thread",128590],"thread-128549":["thread",128549],"thread-128420":["thread",128420],"thread-128415":["thread",128415],"thread-128359":["thread",128359],"thread-128299":["thread",128299],"thread-128167":["thread",128167],"thread-128076":["thread",128076],"thread-127943":["thread",127943],"thread-127830":["thread",127830],"thread-127647":["thread",127647],"thread-127514":["thread",127514],"thread-127497":["thread",127497],"thread-127359":["thread",127359],"thread-127292":["thread",127292],"thread-127280":["thread",127280],"thread-126988":["thread",126988],"thread-126980":["thread",126980],"thread-126920":["thread",126920],"thread-126873":["thread",126873],"thread-126825":["thread",126825],"thread-126807":["thread",126807],"thread-126792":["thread",126792],"thread-126790":["thread",126790],"thread-126763":["thread",126763],"thread-126757":["thread",126757],"thread-126753":["thread",126753],"thread-126696":["thread",126696],"thread-126671":["thread",126671],"thread-126658":["thread",126658],"thread-126622":["thread",126622],"thread-126580":["thread",126580],"thread-126548":["thread",126548],"thread-126509":["thread",126509],"thread-126479":["thread",126479],"thread-126469":["thread",126469],"thread-126391":["thread",126391],"thread-126208":["thread",126208],"thread-126126":["thread",126126],"thread-126100":["thread",126100],"thread-126048":["thread",126048],"thread-125995":["thread",125995],"thread-125818":["thread",125818],"thread-125736":["thread",125736],"thread-125623":["thread",125623],"thread-125580":["thread",125580],"thread-125550":["thread",125550],"thread-125506":["thread",125506],"thread-125410":["thread",125410],"thread-125398":["thread",125398],"thread-125254":["thread",125254],"thread-125098":["thread",125098],"thread-125092":["thread",125092],"thread-124929":["thread",124929],"thread-124881":["thread",124881],"thread-124772":["thread",124772],"thread-124607":["thread",124607],"thread-124590":["thread",124590],"thread-123964":["thread",123964],"thread-123773":["thread",123773],"thread-123690":["thread",123690],"thread-123651":["thread",123651],"thread-123611":["thread",123611],"thread-123610":["thread",123610],"thread-123488":["thread",123488],"thread-123484":["thread",123484],"thread-123440":["thread",123440],"thread-123346":["thread",123346],"thread-123299":["thread",123299],"thread-123291":["thread",123291],"thread-123273":["thread",123273],"thread-123235":["thread",123235],"thread-123232":["thread",123232],"thread-123076":["thread",123076],"thread-122889":["thread",122889],"thread-122878":["thread",122878],"thread-122829":["thread",122829],"thread-122650":["thread",122650],"thread-122608":["thread",122608],"thread-122569":["thread",122569],"thread-122554":["thread",122554],"thread-122503":["thread",122503],"thread-122485":["thread",122485],"thread-122454":["thread",122454],"thread-122451":["thread",122451],"thread-122340":["thread",122340],"thread-122285":["thread",122285],"thread-122273":["thread",122273],"thread-122257":["thread",122257],"thread-122251":["thread",122251],"thread-122178":["thread",122178],"thread-122135":["thread",122135],"thread-122100":["thread",122100],"thread-121943":["thread",121943],"thread-121795":["thread",121795],"thread-121776":["thread",121776],"thread-121738":["thread",121738],"thread-121564":["thread",121564],"thread-121527":["thread",121527],"thread-121428":["thread",121428],"thread-121416":["thread",121416],"thread-121358":["thread",121358],"thread-121312":["thread",121312],"thread-121311":["thread",121311],"thread-121281":["thread",121281],"thread-121264":["thread",121264],"thread-121247":["thread",121247],"thread-121239":["thread",121239],"thread-118100":["thread",118100],"thread-117844":["thread",117844],"thread-117786":["thread",117786],"thread-116908":["thread",116908],"thread-116011":["thread",116011],"thread-116003":["thread",116003],"thread-115989":["thread",115989],"thread-114714":["thread",114714],"thread-114685":["thread",114685],"thread-114683":["thread",114683],"thread-114309":["thread",114309],"thread-113397":["thread",113397],"thread-113220":["thread",113220],"thread-113116":["thread",113116],"thread-112082":["thread",112082],"thread-111122":["thread",111122],"thread-108437":["thread",108437],"thread-107541":["thread",107541],"thread-104027":["thread",104027],"thread-103488":["thread",103488],"thread-100859":["thread",100859],"thread-94251":["thread",94251],"thread-92647":["thread",92647],"thread-92643":["thread",92643],"thread-92642":["thread",92642],"thread-92641":["thread",92641],"thread-90753":["thread",90753],"thread-90522":["thread",90522],"thread-90519":["thread",90519]}, , 1714718339
Run Time: 0.000226
- 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