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 (182675, 182166, 182160, 181731, 181146, 179894, 179306, 179296, 178548, 176588, 175898, 175262, 172514, 170864, 168453, 165306, 163837, 163786, 162171, 161922, 159846, 158292, 157923, 156255, 154060, 153793, 153732, 153507, 153398, 153344, 151940, 149320, 149263, 147900, 141526, 141499, 141449, 140097, 138086, 132540, 132193, 132187, 132181, 132178, 132176, 132175, 132173, 132163, 132162, 132161, 132160, 132157, 132156, 132152, 132150, 132148, 132145, 132144, 132140, 132135, 132131, 132129, 132123, 132122, 132121, 132118, 132116, 132115, 132113, 132111, 132108, 132107, 132101, 132098, 132095, 132092, 132088, 132082, 132080, 132077, 132076, 132068, 132067, 132065, 132057, 132043, 132040, 132038, 132033, 132032, 132023, 132021, 132020, 132019, 132014, 132009, 132007, 132004, 132002, 131994, 131983, 131982, 131980, 131975, 131969, 131962, 131950, 131945, 131933, 131927, 131913, 131910, 131892, 131885, 131883, 131879, 131868, 131867, 131866, 131852, 131848, 131845, 131830, 131807, 131803, 131799, 131798, 131796, 131770, 131766, 131762, 131760, 131753, 131748, 131747, 131741, 131737, 131735, 131729, 131726, 131725, 131723, 131709, 131707, 131664, 131656, 131654, 131650, 131645, 131639, 131638, 131632, 131629, 131621, 131611, 131610, 131607, 131589, 131588, 131582, 131579, 131578, 131569, 131564, 131556, 131555, 131553, 131547, 131538, 131532, 131528, 131523, 131512, 131504, 131491, 131485, 131461, 131453, 131443, 131442, 131435, 131415, 131403, 131402, 131399, 131394, 131380, 131370, 131361, 131354, 131349, 131346, 131344, 131343, 131339, 131332, 131328, 131325, 131323))
Run Time: 0.072979
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 199 | 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: 43, 0, 1715002961, {"thread-182675":["thread",182675],"thread-182166":["thread",182166],"thread-182160":["thread",182160],"thread-181731":["thread",181731],"thread-181146":["thread",181146],"thread-179894":["thread",179894],"thread-179306":["thread",179306],"thread-179296":["thread",179296],"thread-178548":["thread",178548],"thread-176588":["thread",176588],"thread-175898":["thread",175898],"thread-175262":["thread",175262],"thread-172514":["thread",172514],"thread-170864":["thread",170864],"thread-168453":["thread",168453],"thread-165306":["thread",165306],"thread-163837":["thread",163837],"thread-163786":["thread",163786],"thread-162171":["thread",162171],"thread-161922":["thread",161922],"tl_group-175":["tl_group",175],"thread-159846":["thread",159846],"thread-158292":["thread",158292],"thread-157923":["thread",157923],"thread-156255":["thread",156255],"thread-154060":["thread",154060],"thread-153793":["thread",153793],"thread-153732":["thread",153732],"thread-153507":["thread",153507],"thread-153398":["thread",153398],"thread-153344":["thread",153344],"thread-151940":["thread",151940],"thread-149320":["thread",149320],"thread-149263":["thread",149263],"thread-147900":["thread",147900],"thread-141526":["thread",141526],"thread-141499":["thread",141499],"thread-141449":["thread",141449],"thread-140097":["thread",140097],"thread-138086":["thread",138086],"thread-132540":["thread",132540],"thread-132193":["thread",132193],"thread-132187":["thread",132187],"thread-132181":["thread",132181],"thread-132178":["thread",132178],"thread-132176":["thread",132176],"thread-132175":["thread",132175],"thread-132173":["thread",132173],"thread-132163":["thread",132163],"thread-132162":["thread",132162],"thread-132161":["thread",132161],"thread-132160":["thread",132160],"thread-132157":["thread",132157],"thread-132156":["thread",132156],"thread-132152":["thread",132152],"thread-132150":["thread",132150],"thread-132148":["thread",132148],"thread-132145":["thread",132145],"thread-132144":["thread",132144],"thread-132140":["thread",132140],"thread-132135":["thread",132135],"thread-132131":["thread",132131],"thread-132129":["thread",132129],"thread-132123":["thread",132123],"thread-132122":["thread",132122],"thread-132121":["thread",132121],"thread-132118":["thread",132118],"thread-132116":["thread",132116],"thread-132115":["thread",132115],"thread-132113":["thread",132113],"thread-132111":["thread",132111],"thread-132108":["thread",132108],"thread-132107":["thread",132107],"thread-132101":["thread",132101],"thread-132098":["thread",132098],"thread-132095":["thread",132095],"thread-132092":["thread",132092],"thread-132088":["thread",132088],"thread-132082":["thread",132082],"thread-132080":["thread",132080],"thread-132077":["thread",132077],"thread-132076":["thread",132076],"thread-132068":["thread",132068],"thread-132067":["thread",132067],"thread-132065":["thread",132065],"thread-132057":["thread",132057],"thread-132043":["thread",132043],"thread-132040":["thread",132040],"thread-132038":["thread",132038],"thread-132033":["thread",132033],"thread-132032":["thread",132032],"thread-132023":["thread",132023],"thread-132021":["thread",132021],"thread-132020":["thread",132020],"thread-132019":["thread",132019],"thread-132014":["thread",132014],"thread-132009":["thread",132009],"thread-132007":["thread",132007],"thread-132004":["thread",132004],"thread-132002":["thread",132002],"thread-131994":["thread",131994],"thread-131983":["thread",131983],"thread-131982":["thread",131982],"thread-131980":["thread",131980],"thread-131975":["thread",131975],"thread-131969":["thread",131969],"thread-131962":["thread",131962],"thread-131950":["thread",131950],"thread-131945":["thread",131945],"thread-131933":["thread",131933],"thread-131927":["thread",131927],"thread-131913":["thread",131913],"thread-131910":["thread",131910],"thread-131892":["thread",131892],"thread-131885":["thread",131885],"thread-131883":["thread",131883],"thread-131879":["thread",131879],"thread-131868":["thread",131868],"thread-131867":["thread",131867],"thread-131866":["thread",131866],"thread-131852":["thread",131852],"thread-131848":["thread",131848],"thread-131845":["thread",131845],"thread-131830":["thread",131830],"thread-131807":["thread",131807],"thread-131803":["thread",131803],"thread-131799":["thread",131799],"thread-131798":["thread",131798],"thread-131796":["thread",131796],"thread-131770":["thread",131770],"thread-131766":["thread",131766],"thread-131762":["thread",131762],"thread-131760":["thread",131760],"thread-131753":["thread",131753],"thread-131748":["thread",131748],"thread-131747":["thread",131747],"thread-131741":["thread",131741],"thread-131737":["thread",131737],"thread-131735":["thread",131735],"thread-131729":["thread",131729],"thread-131726":["thread",131726],"thread-131725":["thread",131725],"thread-131723":["thread",131723],"thread-131709":["thread",131709],"thread-131707":["thread",131707],"thread-131664":["thread",131664],"thread-131656":["thread",131656],"thread-131654":["thread",131654],"thread-131650":["thread",131650],"thread-131645":["thread",131645],"thread-131639":["thread",131639],"thread-131638":["thread",131638],"thread-131632":["thread",131632],"thread-131629":["thread",131629],"thread-131621":["thread",131621],"thread-131611":["thread",131611],"thread-131610":["thread",131610],"thread-131607":["thread",131607],"thread-131589":["thread",131589],"thread-131588":["thread",131588],"thread-131582":["thread",131582],"thread-131579":["thread",131579],"thread-131578":["thread",131578],"thread-131569":["thread",131569],"thread-131564":["thread",131564],"thread-131556":["thread",131556],"thread-131555":["thread",131555],"thread-131553":["thread",131553],"thread-131547":["thread",131547],"thread-131538":["thread",131538],"thread-131532":["thread",131532],"thread-131528":["thread",131528],"thread-131523":["thread",131523],"thread-131512":["thread",131512],"thread-131504":["thread",131504],"thread-131491":["thread",131491],"thread-131485":["thread",131485],"thread-131461":["thread",131461],"thread-131453":["thread",131453],"thread-131443":["thread",131443],"thread-131442":["thread",131442],"thread-131435":["thread",131435],"thread-131415":["thread",131415],"thread-131403":["thread",131403],"thread-131402":["thread",131402],"thread-131399":["thread",131399],"thread-131394":["thread",131394],"thread-131380":["thread",131380],"thread-131370":["thread",131370],"thread-131361":["thread",131361],"thread-131354":["thread",131354],"thread-131349":["thread",131349],"thread-131346":["thread",131346],"thread-131344":["thread",131344],"thread-131343":["thread",131343],"thread-131339":["thread",131339],"thread-131332":["thread",131332],"thread-131328":["thread",131328],"thread-131325":["thread",131325],"thread-131323":["thread",131323]}, , 1714999361
Run Time: 0.000704
- 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