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 (6717, 6716, 6715, 6714, 6713, 6688, 6687, 6686, 6605, 6604, 6602, 6601, 6600, 6599, 6598, 6550, 6549, 6544, 6533, 6529, 6520, 6519, 6509, 6508, 6507, 6505, 6499, 6498, 6497, 6496, 6494, 6493, 6492, 6489, 6488, 6484, 6482, 6481, 6480, 6477, 6468, 6466, 6464, 6462, 6457, 6456, 6455, 6454, 6453, 6451, 6449, 6448, 6443, 6441, 6440, 6439, 6435, 6434, 6433, 6428, 6427, 6426, 6425, 6422, 6421, 6420, 6419, 6416, 6415, 6414, 6412, 6407, 6406, 6405, 6399, 6398, 6394, 6393, 6390, 6389, 6385, 6384, 6383, 6382, 6381, 6380, 6376, 6370, 6369, 6363, 6361, 6350, 6349, 6347, 6344, 6341, 6340, 6339, 6334, 6333, 6332, 6327, 6325, 6324, 6323, 6322, 6321, 6318, 6316, 6311, 6306, 6302, 6301, 6300, 6276, 6275, 6269, 6268, 6267, 6265, 6264, 6263, 6261, 6259, 6253, 6252, 6251, 6248, 6247, 6245, 6243, 6237, 6231, 6229, 6228, 6227, 6226, 6225, 6223, 6216, 6210, 6206, 6205, 6204, 6201, 6200, 6197, 6192, 6191, 6190, 6187, 6183, 6182, 6180, 6179, 6178, 6177, 6176, 6174, 6173, 6171, 6170, 6169, 6167, 6166, 6165, 6164, 6162, 6160, 6159, 6158, 6157, 6154, 6153, 6151, 6147, 6146, 6145, 6144, 6142, 6139, 6138, 6135, 6134, 6132, 6131, 6130, 6129, 6128, 6127, 6126, 6125, 6124, 6123, 6122, 6121, 6119, 6115, 6114, 6104))
Run Time: 0.005971
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 | extralem_dhbdjkvC5425M68.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | extralem_dhbdjkvC5425M68.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | extralem_dhbdjkvC5425M68.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | extralem_dhbdjkvC5425M68.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,extralem_dhbdjkvC5425M68.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2543
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 729
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- 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: 569, 0, 1714072001, {"thread-6717":["thread",6717],"thread-6716":["thread",6716],"thread-6715":["thread",6715],"thread-6714":["thread",6714],"thread-6713":["thread",6713],"thread-6688":["thread",6688],"thread-6687":["thread",6687],"thread-6686":["thread",6686],"thread-6605":["thread",6605],"thread-6604":["thread",6604],"thread-6601":["thread",6601],"thread-6600":["thread",6600],"thread-6599":["thread",6599],"thread-6529":["thread",6529],"thread-6497":["thread",6497],"thread-6488":["thread",6488],"thread-6428":["thread",6428],"thread-6416":["thread",6416],"thread-6327":["thread",6327],"thread-6216":["thread",6216],"thread-6173":["thread",6173]}, , 1714068401
Run Time: 0.000386
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1452
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1184
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 321
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 244
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2178
- XF\App->run() in src/XF.php at line 390
- XF::runApp() in index.php at line 20