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 (32639, 32638, 32637, 32636, 32635, 32634, 32633, 32632, 32631, 32630, 32629, 32628, 32627, 32626, 32625, 32624, 32623, 32622, 32621, 32620, 32619, 32618, 32617, 32616, 32615, 32614, 32613, 32612, 32611, 32610, 32609, 32608, 32607, 32606, 32605, 32604, 32603, 32602, 32601, 32600, 32599, 32598, 32597, 32596, 32595, 32594, 32593, 32592, 32591, 32590, 32589, 32588, 32587, 32586, 32585, 32584, 32583, 32582, 32581, 32580, 32579, 32578, 32577, 32576, 32575, 32574, 32573, 32572, 32571, 32570, 32569, 32568, 32567, 32566, 32565, 32564, 32563, 32562, 32561, 32560, 32559, 32558, 32557, 32556, 32555, 32554, 32553, 32552, 32551, 32550, 32549, 32548, 32547, 32546, 32545, 32544, 32543, 32542, 32541, 32540, 32539, 32538, 32537, 32536, 32535, 32534, 32533, 32532, 32531, 32530, 32529, 32528, 32527, 32526, 32525, 32524, 32523, 32522, 32521, 32520, 32519, 32518, 32517, 32516, 32515, 32514, 32513, 32512, 32511, 32510, 32509, 32508, 32507, 32506, 32505, 32504, 32503, 32502, 32501, 32500, 32499, 32498, 32497, 32496, 32495, 32494, 32493, 32492, 32491, 32490, 32489, 32488, 32487, 32486, 32485, 32484, 32483, 32482, 32481, 32480, 32479, 32478, 32477, 32476, 32475, 32474, 32473, 32472, 32471, 32470, 32469, 32468, 32467, 32466, 32465, 32464, 32463, 32462, 32461, 32460, 32459, 32458, 32457, 32456, 32455, 32454, 32453, 32452, 32451, 32450, 32449, 32448, 32447, 32446, 32445, 32444, 32443, 32442, 32441, 32440))
Run Time: 0.010797
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: 5813, 0, 1715646970, {"thread-32639":["thread",32639],"thread-32638":["thread",32638],"thread-32637":["thread",32637],"thread-32636":["thread",32636],"thread-32635":["thread",32635],"thread-32634":["thread",32634],"thread-32633":["thread",32633],"thread-32632":["thread",32632],"thread-32631":["thread",32631],"thread-32630":["thread",32630],"thread-32629":["thread",32629],"thread-32628":["thread",32628],"thread-32627":["thread",32627],"thread-32626":["thread",32626],"thread-32625":["thread",32625],"thread-32624":["thread",32624],"thread-32623":["thread",32623],"thread-32622":["thread",32622],"thread-32621":["thread",32621],"thread-32620":["thread",32620],"thread-32619":["thread",32619],"thread-32618":["thread",32618],"thread-32617":["thread",32617],"thread-32616":["thread",32616],"thread-32615":["thread",32615],"thread-32614":["thread",32614],"thread-32613":["thread",32613],"thread-32612":["thread",32612],"thread-32611":["thread",32611],"thread-32610":["thread",32610],"thread-32609":["thread",32609],"thread-32608":["thread",32608],"thread-32607":["thread",32607],"thread-32606":["thread",32606],"thread-32605":["thread",32605],"thread-32604":["thread",32604],"thread-32603":["thread",32603],"thread-32602":["thread",32602],"thread-32601":["thread",32601],"thread-32600":["thread",32600],"thread-32599":["thread",32599],"thread-32598":["thread",32598],"thread-32597":["thread",32597],"thread-32596":["thread",32596],"thread-32595":["thread",32595],"thread-32594":["thread",32594],"thread-32593":["thread",32593],"thread-32592":["thread",32592],"thread-32591":["thread",32591],"thread-32590":["thread",32590],"thread-32589":["thread",32589],"thread-32588":["thread",32588],"thread-32587":["thread",32587],"thread-32586":["thread",32586],"thread-32585":["thread",32585],"thread-32584":["thread",32584],"thread-32583":["thread",32583],"thread-32582":["thread",32582],"thread-32581":["thread",32581],"thread-32580":["thread",32580],"thread-32579":["thread",32579],"thread-32578":["thread",32578],"thread-32577":["thread",32577],"thread-32576":["thread",32576],"thread-32575":["thread",32575],"thread-32574":["thread",32574],"thread-32573":["thread",32573],"thread-32572":["thread",32572],"thread-32571":["thread",32571],"thread-32570":["thread",32570],"thread-32569":["thread",32569],"thread-32568":["thread",32568],"thread-32567":["thread",32567],"thread-32566":["thread",32566],"thread-32565":["thread",32565],"thread-32564":["thread",32564],"thread-32563":["thread",32563],"thread-32562":["thread",32562],"thread-32561":["thread",32561],"thread-32560":["thread",32560],"thread-32559":["thread",32559],"thread-32558":["thread",32558],"thread-32557":["thread",32557],"thread-32556":["thread",32556],"thread-32555":["thread",32555],"thread-32554":["thread",32554],"thread-32553":["thread",32553],"thread-32552":["thread",32552],"thread-32551":["thread",32551],"thread-32550":["thread",32550],"thread-32549":["thread",32549],"thread-32548":["thread",32548],"thread-32547":["thread",32547],"thread-32546":["thread",32546],"thread-32545":["thread",32545],"thread-32544":["thread",32544],"thread-32543":["thread",32543],"thread-32542":["thread",32542],"thread-32541":["thread",32541],"thread-32540":["thread",32540],"thread-32539":["thread",32539],"thread-32538":["thread",32538],"thread-32537":["thread",32537],"thread-32536":["thread",32536],"thread-32535":["thread",32535],"thread-32534":["thread",32534],"thread-32533":["thread",32533],"thread-32532":["thread",32532],"thread-32531":["thread",32531],"thread-32530":["thread",32530],"thread-32529":["thread",32529],"thread-32528":["thread",32528],"thread-32527":["thread",32527],"thread-32526":["thread",32526],"thread-32525":["thread",32525],"thread-32524":["thread",32524],"thread-32523":["thread",32523],"thread-32522":["thread",32522],"thread-32521":["thread",32521],"thread-32520":["thread",32520],"thread-32519":["thread",32519],"thread-32518":["thread",32518],"thread-32517":["thread",32517],"thread-32516":["thread",32516],"thread-32515":["thread",32515],"thread-32514":["thread",32514],"thread-32513":["thread",32513],"thread-32512":["thread",32512],"thread-32511":["thread",32511],"thread-32510":["thread",32510],"thread-32509":["thread",32509],"thread-32508":["thread",32508],"thread-32507":["thread",32507],"thread-32506":["thread",32506],"thread-32505":["thread",32505],"thread-32504":["thread",32504],"thread-32503":["thread",32503],"thread-32502":["thread",32502],"thread-32501":["thread",32501],"thread-32500":["thread",32500],"thread-32499":["thread",32499],"thread-32498":["thread",32498],"thread-32497":["thread",32497],"thread-32496":["thread",32496],"thread-32495":["thread",32495],"thread-32494":["thread",32494],"thread-32493":["thread",32493],"thread-32492":["thread",32492],"thread-32491":["thread",32491],"thread-32490":["thread",32490],"thread-32489":["thread",32489],"thread-32488":["thread",32488],"thread-32487":["thread",32487],"thread-32486":["thread",32486],"thread-32485":["thread",32485],"thread-32484":["thread",32484],"thread-32483":["thread",32483],"thread-32482":["thread",32482],"thread-32481":["thread",32481],"thread-32480":["thread",32480],"thread-32479":["thread",32479],"thread-32478":["thread",32478],"thread-32477":["thread",32477],"thread-32476":["thread",32476],"thread-32475":["thread",32475],"thread-32474":["thread",32474],"thread-32473":["thread",32473],"thread-32472":["thread",32472],"thread-32471":["thread",32471],"thread-32470":["thread",32470],"thread-32469":["thread",32469],"thread-32468":["thread",32468],"thread-32467":["thread",32467],"thread-32466":["thread",32466],"thread-32465":["thread",32465],"thread-32464":["thread",32464],"thread-32463":["thread",32463],"thread-32462":["thread",32462],"thread-32461":["thread",32461],"thread-32460":["thread",32460],"thread-32459":["thread",32459],"thread-32458":["thread",32458],"thread-32457":["thread",32457],"thread-32456":["thread",32456],"thread-32455":["thread",32455],"thread-32454":["thread",32454],"thread-32453":["thread",32453],"thread-32452":["thread",32452],"thread-32451":["thread",32451],"thread-32450":["thread",32450],"thread-32449":["thread",32449],"thread-32448":["thread",32448],"thread-32447":["thread",32447],"thread-32446":["thread",32446],"thread-32445":["thread",32445],"thread-32444":["thread",32444],"thread-32443":["thread",32443],"thread-32442":["thread",32442],"thread-32441":["thread",32441],"thread-32440":["thread",32440]}, , 1715643370
Run Time: 0.000762
- 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