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 (182854, 182618, 182207, 182042, 181469, 181362, 180796, 180770, 180362, 180317, 180145, 179914, 179156, 179050, 178864, 178772, 178647, 178448, 178136, 178056, 177914, 177888, 177763, 177679, 177491, 177480, 177440, 177002, 176583, 176046, 175842, 175162, 174932, 174905, 174269, 174074, 173885, 173854, 173195, 172429, 172274, 172228, 171749, 171341, 171131, 171086, 171081, 170486, 170362, 170351, 170220, 170211, 169585, 169519, 169518, 169460, 169357, 168949, 168152, 168140, 167308, 167295, 167248, 166972, 166114, 166093, 165956, 165511, 164667, 164470, 164468, 164353, 164331, 164052, 164024, 163878, 163700, 163585, 163145, 162970, 161994, 161935, 161876, 161822, 161729, 161726, 161324, 161294, 161199, 161154, 161149, 161132, 160867, 160783, 160503, 160335, 160256, 160255, 160246, 160141, 160044, 159988, 159653, 159440, 158781, 158371, 158370, 157826, 157677, 157459, 157019, 156795, 156255, 156025, 155949, 155914, 155590, 155511, 155315, 154988, 154737, 153733, 153252, 152847, 105009, 97825, 53601))
Run Time: 0.064498
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 127 | 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: 8751, 0, 1714888787, {"thread-182854":["thread",182854],"thread-182618":["thread",182618],"thread-182207":["thread",182207],"thread-182042":["thread",182042],"thread-181469":["thread",181469],"thread-181362":["thread",181362],"thread-180796":["thread",180796],"thread-180770":["thread",180770],"thread-180362":["thread",180362],"thread-180317":["thread",180317],"thread-180145":["thread",180145],"thread-179914":["thread",179914],"thread-179156":["thread",179156],"thread-179050":["thread",179050],"thread-178864":["thread",178864],"thread-178772":["thread",178772],"thread-178647":["thread",178647],"thread-178448":["thread",178448],"thread-178136":["thread",178136],"thread-178056":["thread",178056],"thread-177914":["thread",177914],"thread-177888":["thread",177888],"thread-177763":["thread",177763],"thread-177679":["thread",177679],"thread-177491":["thread",177491],"thread-177480":["thread",177480],"thread-177440":["thread",177440],"thread-177002":["thread",177002],"thread-176583":["thread",176583],"thread-176046":["thread",176046],"thread-175842":["thread",175842],"thread-175162":["thread",175162],"thread-174932":["thread",174932],"thread-174905":["thread",174905],"thread-174269":["thread",174269],"thread-174074":["thread",174074],"thread-173885":["thread",173885],"thread-173854":["thread",173854],"thread-173195":["thread",173195],"thread-172429":["thread",172429],"thread-172274":["thread",172274],"thread-172228":["thread",172228],"thread-171749":["thread",171749],"thread-171341":["thread",171341],"thread-171131":["thread",171131],"thread-171086":["thread",171086],"thread-171081":["thread",171081],"thread-170486":["thread",170486],"thread-170362":["thread",170362],"thread-170351":["thread",170351],"thread-170220":["thread",170220],"thread-170211":["thread",170211],"thread-169585":["thread",169585],"thread-169519":["thread",169519],"thread-169357":["thread",169357],"thread-168949":["thread",168949],"thread-168152":["thread",168152],"thread-168140":["thread",168140],"thread-167308":["thread",167308],"thread-167295":["thread",167295],"thread-167248":["thread",167248],"thread-166972":["thread",166972],"thread-166114":["thread",166114],"thread-166093":["thread",166093],"thread-165956":["thread",165956],"thread-165511":["thread",165511],"thread-164667":["thread",164667],"thread-164470":["thread",164470],"thread-164468":["thread",164468],"thread-164353":["thread",164353],"thread-164331":["thread",164331],"thread-164052":["thread",164052],"thread-164024":["thread",164024],"thread-163878":["thread",163878],"thread-163700":["thread",163700],"thread-163585":["thread",163585],"thread-163145":["thread",163145],"thread-162970":["thread",162970],"thread-161994":["thread",161994],"thread-161935":["thread",161935],"thread-161876":["thread",161876],"thread-161822":["thread",161822],"thread-161729":["thread",161729],"thread-161726":["thread",161726],"thread-161324":["thread",161324],"thread-161294":["thread",161294],"thread-161199":["thread",161199],"thread-161154":["thread",161154],"thread-161149":["thread",161149],"thread-161132":["thread",161132],"thread-160867":["thread",160867],"thread-160783":["thread",160783],"thread-160503":["thread",160503],"thread-160335":["thread",160335],"thread-160256":["thread",160256],"thread-160246":["thread",160246],"thread-160141":["thread",160141],"thread-160044":["thread",160044],"thread-159988":["thread",159988],"thread-159653":["thread",159653],"thread-159440":["thread",159440],"thread-158781":["thread",158781],"thread-158371":["thread",158371],"thread-158370":["thread",158370],"thread-157826":["thread",157826],"thread-157677":["thread",157677],"thread-157459":["thread",157459],"thread-157019":["thread",157019],"thread-156795":["thread",156795],"thread-156255":["thread",156255],"thread-156025":["thread",156025],"thread-155949":["thread",155949],"thread-155914":["thread",155914],"thread-155590":["thread",155590],"thread-155511":["thread",155511],"thread-155315":["thread",155315],"thread-154988":["thread",154988],"thread-154737":["thread",154737],"thread-153733":["thread",153733],"thread-153252":["thread",153252],"thread-152847":["thread",152847],"thread-105009":["thread",105009],"thread-97825":["thread",97825],"thread-53601":["thread",53601]}, , 1714885187
Run Time: 0.000224
- 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