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 (40119, 40118, 40117, 40116, 40114, 21853, 21852, 21851, 21850, 21849, 21848, 21847, 21846, 21845, 21844, 21843, 21842, 21841, 21840, 21839, 21838, 21837, 21836, 21835, 21834, 21833, 21832, 21831, 21830, 21829, 21828, 21827, 21826, 21825, 21824, 21823, 21822, 21821, 21820, 21819, 21818, 21817, 21816, 21815, 21814, 21813, 21812, 21811, 21810, 21809, 21808, 21807, 21806, 21805, 21804, 21802, 21801, 21800, 21799, 21798, 21797, 21796, 21795, 21794, 21793, 21792, 21791, 21790, 21789, 21788, 21787, 21786, 21785, 21784, 21783, 21782, 21781, 21780, 21779, 21778, 21777, 21776, 21775, 21774, 21773, 21772, 21771, 21770, 21769, 21768, 21767, 21766, 21765, 21764, 21763, 21762, 21761, 21760, 21759, 21758, 21757, 21756, 21755, 21754, 21753, 21752, 21751, 21750, 21749, 21748, 21747, 21746, 21745, 21744, 21743, 21742, 21741, 21740, 21739, 21738, 21737, 21736, 21735, 21734, 21733, 21732, 21731, 21730, 21729, 21728, 21727, 21726, 21725, 21724, 21723, 21722, 21721, 21720, 21719, 21718, 21717, 21716, 21715, 21714, 21713, 21712, 21711, 21710, 21709, 21708, 21707, 21706, 21705, 21704, 21703, 21702, 21701, 21700, 21699, 21698, 21697, 21696, 21695, 21694, 21693, 21692, 21691, 21690, 21689, 21688, 21687, 21686, 21685, 21684, 21683, 21682, 21681, 21680, 21679, 21678, 21677, 21676, 21675, 21674, 21673, 21672, 21671, 21670, 21669, 21668, 21667, 21666, 21665, 21664, 21663, 21662, 21661, 21660, 21659, 21658))
Run Time: 0.010091
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 | import4.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,import4.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 2719
- 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 2345
- XF\App->run() in src/XF.php at line 512
- 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: 5719, 0, 1715417864, {"thread-40119":["thread",40119],"thread-40118":["thread",40118],"thread-40117":["thread",40117],"thread-40116":["thread",40116],"thread-40114":["thread",40114],"thread-21853":["thread",21853],"thread-21852":["thread",21852],"thread-21851":["thread",21851],"thread-21850":["thread",21850],"thread-21849":["thread",21849],"thread-21848":["thread",21848],"thread-21847":["thread",21847],"thread-21846":["thread",21846],"thread-21845":["thread",21845],"thread-21844":["thread",21844],"thread-21843":["thread",21843],"thread-21842":["thread",21842],"thread-21841":["thread",21841],"thread-21840":["thread",21840],"thread-21839":["thread",21839],"thread-21838":["thread",21838],"thread-21837":["thread",21837],"thread-21836":["thread",21836],"thread-21835":["thread",21835],"thread-21834":["thread",21834],"thread-21833":["thread",21833],"thread-21832":["thread",21832],"thread-21831":["thread",21831],"thread-21830":["thread",21830],"thread-21829":["thread",21829],"thread-21828":["thread",21828],"thread-21827":["thread",21827],"thread-21826":["thread",21826],"thread-21825":["thread",21825],"thread-21824":["thread",21824],"thread-21823":["thread",21823],"thread-21822":["thread",21822],"thread-21821":["thread",21821],"thread-21820":["thread",21820],"thread-21819":["thread",21819],"thread-21818":["thread",21818],"thread-21817":["thread",21817],"thread-21816":["thread",21816],"thread-21815":["thread",21815],"thread-21814":["thread",21814],"thread-21813":["thread",21813],"thread-21812":["thread",21812],"thread-21811":["thread",21811],"thread-21810":["thread",21810],"thread-21809":["thread",21809],"thread-21808":["thread",21808],"thread-21807":["thread",21807],"thread-21806":["thread",21806],"thread-21805":["thread",21805],"thread-21804":["thread",21804],"thread-21802":["thread",21802],"thread-21801":["thread",21801],"thread-21800":["thread",21800],"thread-21799":["thread",21799],"thread-21798":["thread",21798],"thread-21797":["thread",21797],"thread-21796":["thread",21796],"thread-21795":["thread",21795],"thread-21794":["thread",21794],"thread-21793":["thread",21793],"thread-21792":["thread",21792],"thread-21791":["thread",21791],"thread-21790":["thread",21790],"thread-21789":["thread",21789],"thread-21788":["thread",21788],"thread-21787":["thread",21787],"thread-21786":["thread",21786],"thread-21785":["thread",21785],"thread-21784":["thread",21784],"thread-21783":["thread",21783],"thread-21782":["thread",21782],"thread-21781":["thread",21781],"thread-21780":["thread",21780],"thread-21779":["thread",21779],"thread-21778":["thread",21778],"thread-21777":["thread",21777],"thread-21776":["thread",21776],"thread-21775":["thread",21775],"thread-21774":["thread",21774],"thread-21773":["thread",21773],"thread-21772":["thread",21772],"thread-21771":["thread",21771],"thread-21770":["thread",21770],"thread-21769":["thread",21769],"thread-21768":["thread",21768],"thread-21767":["thread",21767],"thread-21766":["thread",21766],"thread-21765":["thread",21765],"thread-21764":["thread",21764],"thread-21763":["thread",21763],"thread-21762":["thread",21762],"thread-21761":["thread",21761],"thread-21760":["thread",21760],"thread-21759":["thread",21759],"thread-21758":["thread",21758],"thread-21757":["thread",21757],"thread-21756":["thread",21756],"thread-21755":["thread",21755],"thread-21754":["thread",21754],"thread-21753":["thread",21753],"thread-21752":["thread",21752],"thread-21751":["thread",21751],"thread-21750":["thread",21750],"thread-21749":["thread",21749],"thread-21748":["thread",21748],"thread-21747":["thread",21747],"thread-21746":["thread",21746],"thread-21745":["thread",21745],"thread-21744":["thread",21744],"thread-21743":["thread",21743],"thread-21742":["thread",21742],"thread-21741":["thread",21741],"thread-21740":["thread",21740],"thread-21739":["thread",21739],"thread-21738":["thread",21738],"thread-21737":["thread",21737],"thread-21736":["thread",21736],"thread-21735":["thread",21735],"thread-21734":["thread",21734],"thread-21733":["thread",21733],"thread-21732":["thread",21732],"thread-21731":["thread",21731],"thread-21730":["thread",21730],"thread-21729":["thread",21729],"thread-21728":["thread",21728],"thread-21727":["thread",21727],"thread-21726":["thread",21726],"thread-21725":["thread",21725],"thread-21724":["thread",21724],"thread-21723":["thread",21723],"thread-21722":["thread",21722],"thread-21721":["thread",21721],"thread-21720":["thread",21720],"thread-21719":["thread",21719],"thread-21718":["thread",21718],"thread-21717":["thread",21717],"thread-21716":["thread",21716],"thread-21715":["thread",21715],"thread-21714":["thread",21714],"thread-21713":["thread",21713],"thread-21712":["thread",21712],"thread-21711":["thread",21711],"thread-21710":["thread",21710],"thread-21709":["thread",21709],"thread-21708":["thread",21708],"thread-21707":["thread",21707],"thread-21706":["thread",21706],"thread-21705":["thread",21705],"thread-21704":["thread",21704],"thread-21703":["thread",21703],"thread-21702":["thread",21702],"thread-21701":["thread",21701],"thread-21700":["thread",21700],"thread-21699":["thread",21699],"thread-21698":["thread",21698],"thread-21697":["thread",21697],"thread-21696":["thread",21696],"thread-21695":["thread",21695],"thread-21694":["thread",21694],"thread-21693":["thread",21693],"thread-21692":["thread",21692],"thread-21691":["thread",21691],"thread-21690":["thread",21690],"thread-21689":["thread",21689],"thread-21688":["thread",21688],"thread-21687":["thread",21687],"thread-21686":["thread",21686],"thread-21685":["thread",21685],"thread-21684":["thread",21684],"thread-21683":["thread",21683],"thread-21682":["thread",21682],"thread-21681":["thread",21681],"thread-21680":["thread",21680],"thread-21679":["thread",21679],"thread-21678":["thread",21678],"thread-21677":["thread",21677],"thread-21676":["thread",21676],"thread-21675":["thread",21675],"thread-21674":["thread",21674],"thread-21673":["thread",21673],"thread-21672":["thread",21672],"thread-21671":["thread",21671],"thread-21670":["thread",21670],"thread-21669":["thread",21669],"thread-21668":["thread",21668],"thread-21667":["thread",21667],"thread-21666":["thread",21666],"thread-21665":["thread",21665],"thread-21664":["thread",21664],"thread-21663":["thread",21663],"thread-21662":["thread",21662],"thread-21661":["thread",21661],"thread-21660":["thread",21660],"thread-21659":["thread",21659],"thread-21658":["thread",21658]}, , 1715414264
Run Time: 0.001553
- 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 1512
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1244
- 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 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20