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 (108713, 108559, 108389, 108088, 107995, 107993, 107358, 105700, 105412, 104480, 103258, 103196, 102553, 101934, 101769, 101578, 101525, 101189, 101179, 100876, 100823, 100813, 100694, 100255, 100192, 100129, 100080, 99471, 99367, 99121, 98775, 98327, 98156, 97622, 97199, 96952, 96438, 96292, 96281, 96148, 96002, 95643, 95371, 94669, 94577, 93879, 93864, 93614, 93392, 92880, 92749, 92709, 92635, 91789, 90520, 90411, 90198, 90040, 89645, 89489, 89359, 89288, 89125, 88769, 88619, 88473, 88124, 88094, 87873, 87869, 87425, 87285, 87097, 86725, 86528, 86441, 86197, 86110, 86037, 85642, 85399, 85325, 85064, 84773, 84605, 83949, 83785, 83666, 83587, 83551, 83230, 83116, 83048, 82987, 82950, 82626, 81946, 81622, 81161, 80879, 80683, 80190, 80046, 80012, 79847, 79806, 79779, 79669, 79075, 79020, 78567, 78542, 78445, 78400, 78228, 77860, 77772, 77557, 77387, 77329, 77104, 76857, 76837, 76813, 76749, 76522, 76424, 76417, 76414, 76165, 76091, 75779, 75655, 75552, 75222, 75049, 74824, 74375, 73816, 73786, 73649, 73099, 72828, 72666, 72338, 71915, 71866, 71818, 71748, 71533, 71463, 71222, 70701, 70660, 70655, 70575, 70236, 69784, 69775, 69556, 69011, 68746, 68540, 68340, 67631, 67542, 67130, 67044, 66780, 66628, 66598, 66356, 66320, 66174, 66089))
Run Time: 0.007760
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 175 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,terrylove_forums.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 2866
- 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 2483
- 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: 751, 0, 1714107106, {"thread-108713":["thread",108713],"thread-108559":["thread",108559],"thread-108389":["thread",108389],"thread-108088":["thread",108088],"thread-107995":["thread",107995],"thread-107993":["thread",107993],"thread-107358":["thread",107358],"thread-105700":["thread",105700],"thread-105412":["thread",105412],"thread-104480":["thread",104480],"thread-103258":["thread",103258],"thread-103196":["thread",103196],"thread-102553":["thread",102553],"thread-101934":["thread",101934],"thread-101769":["thread",101769],"thread-101578":["thread",101578],"thread-101525":["thread",101525],"thread-101189":["thread",101189],"thread-101179":["thread",101179],"thread-100876":["thread",100876],"thread-100823":["thread",100823],"thread-100813":["thread",100813],"thread-100694":["thread",100694],"thread-100255":["thread",100255],"thread-100192":["thread",100192],"thread-100129":["thread",100129],"thread-100080":["thread",100080],"thread-99471":["thread",99471],"thread-99367":["thread",99367],"thread-99121":["thread",99121],"thread-98775":["thread",98775],"thread-98327":["thread",98327],"thread-98156":["thread",98156],"thread-97622":["thread",97622],"thread-97199":["thread",97199],"thread-96952":["thread",96952],"thread-96438":["thread",96438],"thread-96292":["thread",96292],"thread-96281":["thread",96281],"thread-96148":["thread",96148],"thread-96002":["thread",96002],"thread-95643":["thread",95643],"thread-95371":["thread",95371],"thread-94669":["thread",94669],"thread-94577":["thread",94577],"thread-93879":["thread",93879],"thread-93864":["thread",93864],"thread-93614":["thread",93614],"thread-93392":["thread",93392],"thread-92880":["thread",92880],"thread-92749":["thread",92749],"thread-92709":["thread",92709],"thread-92635":["thread",92635],"thread-91789":["thread",91789],"thread-90520":["thread",90520],"thread-90411":["thread",90411],"thread-90198":["thread",90198],"thread-90040":["thread",90040],"thread-89645":["thread",89645],"thread-89489":["thread",89489],"thread-89359":["thread",89359],"thread-89288":["thread",89288],"thread-89125":["thread",89125],"thread-88769":["thread",88769],"thread-88619":["thread",88619],"thread-88473":["thread",88473],"thread-88124":["thread",88124],"thread-88094":["thread",88094],"thread-87873":["thread",87873],"thread-87869":["thread",87869],"thread-87425":["thread",87425],"thread-87285":["thread",87285],"thread-87097":["thread",87097],"thread-86725":["thread",86725],"thread-86528":["thread",86528],"thread-86441":["thread",86441],"thread-86197":["thread",86197],"thread-86110":["thread",86110],"thread-86037":["thread",86037],"thread-85642":["thread",85642],"thread-85399":["thread",85399],"thread-85325":["thread",85325],"thread-85064":["thread",85064],"thread-84773":["thread",84773],"thread-84605":["thread",84605],"thread-83949":["thread",83949],"thread-83785":["thread",83785],"thread-83666":["thread",83666],"thread-83587":["thread",83587],"thread-83551":["thread",83551],"thread-83230":["thread",83230],"thread-83116":["thread",83116],"thread-83048":["thread",83048],"thread-82987":["thread",82987],"thread-82950":["thread",82950],"thread-82626":["thread",82626],"thread-81946":["thread",81946],"thread-81622":["thread",81622],"thread-81161":["thread",81161],"thread-80879":["thread",80879],"thread-80683":["thread",80683],"thread-80190":["thread",80190],"thread-80046":["thread",80046],"thread-80012":["thread",80012],"thread-79847":["thread",79847],"thread-79806":["thread",79806],"thread-79779":["thread",79779],"thread-79669":["thread",79669],"thread-79075":["thread",79075],"thread-79020":["thread",79020],"thread-78567":["thread",78567],"thread-78542":["thread",78542],"thread-78445":["thread",78445],"thread-78400":["thread",78400],"thread-78228":["thread",78228],"thread-77860":["thread",77860],"thread-77772":["thread",77772],"thread-77557":["thread",77557],"thread-77387":["thread",77387],"thread-77329":["thread",77329],"thread-77104":["thread",77104],"thread-76857":["thread",76857],"thread-76837":["thread",76837],"thread-76813":["thread",76813],"thread-76749":["thread",76749],"thread-76522":["thread",76522],"thread-76424":["thread",76424],"thread-76417":["thread",76417],"thread-76414":["thread",76414],"thread-76165":["thread",76165],"thread-76091":["thread",76091],"thread-75779":["thread",75779],"thread-75655":["thread",75655],"thread-75552":["thread",75552],"thread-75222":["thread",75222],"thread-75049":["thread",75049],"thread-74824":["thread",74824],"thread-74375":["thread",74375],"thread-73816":["thread",73816],"thread-73786":["thread",73786],"thread-73649":["thread",73649],"thread-73099":["thread",73099],"thread-72828":["thread",72828],"thread-72666":["thread",72666],"thread-72338":["thread",72338],"thread-71915":["thread",71915],"thread-71866":["thread",71866],"thread-71818":["thread",71818],"thread-71748":["thread",71748],"thread-71533":["thread",71533],"thread-71463":["thread",71463],"thread-71222":["thread",71222],"thread-70701":["thread",70701],"thread-70660":["thread",70660],"thread-70655":["thread",70655],"thread-70575":["thread",70575],"thread-70236":["thread",70236],"thread-69784":["thread",69784],"thread-69775":["thread",69775],"thread-69556":["thread",69556],"thread-69011":["thread",69011],"thread-68746":["thread",68746],"thread-68540":["thread",68540],"thread-68340":["thread",68340],"thread-67631":["thread",67631],"thread-67542":["thread",67542],"thread-67130":["thread",67130],"thread-67044":["thread",67044],"thread-66780":["thread",66780],"thread-66628":["thread",66628],"thread-66598":["thread",66598],"thread-66356":["thread",66356],"thread-66320":["thread",66320],"thread-66174":["thread",66174],"thread-66089":["thread",66089]}, NULL, 1714103506
Run Time: 0.000375
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- 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 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20