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 (101657, 100834, 99501, 96188, 94681, 94039, 91997, 87978, 86420, 83753, 81363, 80610, 80583, 80003, 79375, 78520, 77403, 77081, 76866, 76235, 73875, 72794, 72785, 72530, 72518, 72471, 70221, 72386, 68036, 67687, 67682, 67681, 66666, 66533, 66084, 58135, 50678, 42930, 41134, 40881, 38708, 35749, 31290, 30974, 30973, 30723, 29160, 27412, 27135, 26551, 25113, 21991, 21826, 20038, 17887, 16977, 16807, 14143, 13462, 12769, 12566, 12509, 12101, 11953, 11387, 11079, 11013, 10956, 10805, 10359, 9483, 9444, 9212, 9273, 9090, 8971, 8678, 8512, 8324, 8284, 8055, 7849, 7757, 7550, 7153, 7147, 6703, 6582, 6361, 6178, 6135, 5676, 5649, 5128, 4940, 4912, 4901, 4791, 4747, 4635, 3240, 3220, 3020, 2840, 2794, 2725, 2721, 2633, 2428, 2385, 2304, 1941, 1891, 1890, 1852, 1845, 1773, 1772, 1771, 1769, 1758, 1752, 1750, 1661, 1657, 1649, 1639, 1606, 1605, 1603, 1602, 1598, 1596, 1595, 1594, 1593, 1592, 1591, 1590, 1589, 1588, 1587, 1586, 1585, 1584, 1583, 1582, 1550, 1526, 1522, 1401, 1336, 1229, 1187, 1183, 766, 486, 313, 312, 255, 195, 178, 151, 145))
Run Time: 0.002394
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 164 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,blutschwerter_forum.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 2870
- 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 138
- 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 2487
- 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: 1407, 0, 1714900394, {"thread-101657":["thread",101657],"thread-100834":["thread",100834],"thread-99501":["thread",99501],"thread-96188":["thread",96188],"thread-94681":["thread",94681],"thread-94039":["thread",94039],"thread-91997":["thread",91997],"thread-87978":["thread",87978],"thread-86420":["thread",86420],"thread-83753":["thread",83753],"thread-81363":["thread",81363],"thread-80610":["thread",80610],"thread-80583":["thread",80583],"thread-80003":["thread",80003],"thread-79375":["thread",79375],"thread-78520":["thread",78520],"thread-77403":["thread",77403],"thread-77081":["thread",77081],"thread-76866":["thread",76866],"thread-76235":["thread",76235],"thread-73875":["thread",73875],"thread-72794":["thread",72794],"thread-72785":["thread",72785],"thread-72530":["thread",72530],"thread-72518":["thread",72518],"thread-72471":["thread",72471],"thread-70221":["thread",70221],"thread-72386":["thread",72386],"thread-68036":["thread",68036],"thread-67687":["thread",67687],"thread-67682":["thread",67682],"thread-67681":["thread",67681],"thread-66666":["thread",66666],"thread-66533":["thread",66533],"thread-66084":["thread",66084],"thread-58135":["thread",58135],"thread-50678":["thread",50678],"thread-42930":["thread",42930],"thread-41134":["thread",41134],"thread-40881":["thread",40881],"thread-38708":["thread",38708],"thread-35749":["thread",35749],"thread-31290":["thread",31290],"thread-30974":["thread",30974],"thread-30973":["thread",30973],"thread-30723":["thread",30723],"thread-29160":["thread",29160],"thread-27412":["thread",27412],"thread-27135":["thread",27135],"thread-26551":["thread",26551],"thread-25113":["thread",25113],"thread-21991":["thread",21991],"thread-21826":["thread",21826],"thread-20038":["thread",20038],"thread-17887":["thread",17887],"thread-16977":["thread",16977],"thread-16807":["thread",16807],"thread-14143":["thread",14143],"thread-13462":["thread",13462],"thread-12769":["thread",12769],"thread-12566":["thread",12566],"thread-12509":["thread",12509],"thread-12101":["thread",12101],"thread-11953":["thread",11953],"thread-11387":["thread",11387],"thread-11079":["thread",11079],"thread-11013":["thread",11013],"thread-10956":["thread",10956],"thread-10805":["thread",10805],"thread-10359":["thread",10359],"thread-9483":["thread",9483],"thread-9444":["thread",9444],"thread-9212":["thread",9212],"thread-9273":["thread",9273],"thread-9090":["thread",9090],"thread-8971":["thread",8971],"thread-8678":["thread",8678],"thread-8512":["thread",8512],"thread-8324":["thread",8324],"thread-8284":["thread",8284],"thread-8055":["thread",8055],"thread-7849":["thread",7849],"thread-7757":["thread",7757],"thread-7550":["thread",7550],"thread-7153":["thread",7153],"thread-7147":["thread",7147],"thread-6703":["thread",6703],"thread-6582":["thread",6582],"thread-6361":["thread",6361],"thread-6178":["thread",6178],"thread-6135":["thread",6135],"thread-5676":["thread",5676],"thread-5649":["thread",5649],"thread-5128":["thread",5128],"thread-4940":["thread",4940],"thread-4912":["thread",4912],"thread-4901":["thread",4901],"thread-4791":["thread",4791],"thread-4747":["thread",4747],"thread-4635":["thread",4635],"thread-3240":["thread",3240],"thread-3220":["thread",3220],"thread-3020":["thread",3020],"thread-2840":["thread",2840],"thread-2794":["thread",2794],"thread-2725":["thread",2725],"thread-2721":["thread",2721],"thread-2633":["thread",2633],"thread-2428":["thread",2428],"thread-2385":["thread",2385],"thread-2304":["thread",2304],"thread-1941":["thread",1941],"thread-1891":["thread",1891],"thread-1890":["thread",1890],"thread-1852":["thread",1852],"thread-1845":["thread",1845],"thread-1773":["thread",1773],"thread-1772":["thread",1772],"thread-1771":["thread",1771],"thread-1769":["thread",1769],"thread-1758":["thread",1758],"thread-1752":["thread",1752],"thread-1750":["thread",1750],"thread-1661":["thread",1661],"thread-1657":["thread",1657],"thread-1649":["thread",1649],"thread-1639":["thread",1639],"thread-1606":["thread",1606],"thread-1605":["thread",1605],"thread-1603":["thread",1603],"thread-1602":["thread",1602],"thread-1598":["thread",1598],"thread-1596":["thread",1596],"thread-1595":["thread",1595],"thread-1594":["thread",1594],"thread-1593":["thread",1593],"thread-1592":["thread",1592],"thread-1591":["thread",1591],"thread-1590":["thread",1590],"thread-1589":["thread",1589],"thread-1588":["thread",1588],"thread-1587":["thread",1587],"thread-1586":["thread",1586],"thread-1585":["thread",1585],"thread-1584":["thread",1584],"thread-1583":["thread",1583],"thread-1582":["thread",1582],"thread-1550":["thread",1550],"thread-1526":["thread",1526],"thread-1522":["thread",1522],"thread-1401":["thread",1401],"thread-1336":["thread",1336],"thread-1229":["thread",1229],"thread-1187":["thread",1187],"thread-1183":["thread",1183],"thread-766":["thread",766],"thread-486":["thread",486],"thread-313":["thread",313],"thread-312":["thread",312],"thread-255":["thread",255],"thread-195":["thread",195],"thread-178":["thread",178],"thread-151":["thread",151],"thread-145":["thread",145]}, NULL, 1714896794
Run Time: 0.000126
- 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 1526
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1258
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20