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 (44776, 29368, 29367, 29366, 29365, 29364, 29363, 29362, 29361, 29360, 29359, 29358, 29357, 29356, 29355, 29354, 29353, 29352, 29351, 29350, 29349, 29348, 29347, 29346, 29345, 29344, 29343, 29342, 29341, 29340, 29339, 29338, 29337, 29336, 29335, 29334, 29333, 29332, 29331, 29330, 29329, 29328, 29327, 29326, 29325, 29324, 29323, 29322, 29321, 29320, 29319, 29318, 29317, 29316, 29315, 29314, 29313, 29312, 29311, 29310, 29309, 29308, 29307, 29306, 29305, 29304, 29303, 29302, 29301, 29300, 29299, 29298, 29297, 29296, 29295, 29294, 29293, 29292, 29291, 29290, 29289, 29288, 29287, 29286, 29285, 29284, 29283, 29282, 29281, 29280, 29279, 29278, 29277, 29276, 29275, 29274, 29273, 29272, 29271, 29270, 29269, 29268, 29267, 29266, 29265, 29264, 29263, 29262, 29261, 29260, 29259, 29258, 29257, 29256, 29255, 29254, 29253, 29252, 29251, 29250, 29249, 29248, 29247, 29246, 29245, 29244, 29243, 29242, 29241, 29240, 29239, 29238, 29237, 29236, 29235, 29234, 29233, 29232, 29231, 29230, 29229, 29228, 29227, 29226, 29225, 29224, 29223, 29222, 29221, 29220, 29219, 29218, 29217, 29216, 29215, 29214, 29213, 29212, 29211, 29210, 29209, 29208, 29207, 29206, 29205, 29204, 29203, 29202, 29201, 29200, 29199, 29198, 29197, 29196, 29195, 29194, 29193, 29192, 29191, 29190, 29189, 29188, 29187, 29186, 29185, 29184, 29183, 29182, 29181, 29180, 29179, 29178, 29177, 29176, 29175, 29174, 29173, 29172, 29171, 29170))
Run Time: 0.009266
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: 366, 0, 1715747181, {"thread-44776":["thread",44776],"thread-29368":["thread",29368],"thread-29367":["thread",29367],"thread-29366":["thread",29366],"thread-29365":["thread",29365],"thread-29364":["thread",29364],"thread-29363":["thread",29363],"thread-29362":["thread",29362],"thread-29361":["thread",29361],"thread-29360":["thread",29360],"thread-29359":["thread",29359],"thread-29358":["thread",29358],"thread-29357":["thread",29357],"thread-29356":["thread",29356],"thread-29355":["thread",29355],"thread-29354":["thread",29354],"thread-29353":["thread",29353],"thread-29352":["thread",29352],"thread-29351":["thread",29351],"thread-29350":["thread",29350],"thread-29349":["thread",29349],"thread-29348":["thread",29348],"thread-29347":["thread",29347],"thread-29346":["thread",29346],"thread-29345":["thread",29345],"thread-29344":["thread",29344],"thread-29343":["thread",29343],"thread-29342":["thread",29342],"thread-29341":["thread",29341],"thread-29340":["thread",29340],"thread-29339":["thread",29339],"thread-29338":["thread",29338],"thread-29337":["thread",29337],"thread-29336":["thread",29336],"thread-29335":["thread",29335],"thread-29334":["thread",29334],"thread-29333":["thread",29333],"thread-29332":["thread",29332],"thread-29331":["thread",29331],"thread-29330":["thread",29330],"thread-29329":["thread",29329],"thread-29328":["thread",29328],"thread-29327":["thread",29327],"thread-29326":["thread",29326],"thread-29325":["thread",29325],"thread-29324":["thread",29324],"thread-29323":["thread",29323],"thread-29322":["thread",29322],"thread-29321":["thread",29321],"thread-29320":["thread",29320],"thread-29319":["thread",29319],"thread-29318":["thread",29318],"thread-29317":["thread",29317],"thread-29316":["thread",29316],"thread-29315":["thread",29315],"thread-29314":["thread",29314],"thread-29313":["thread",29313],"thread-29312":["thread",29312],"thread-29311":["thread",29311],"thread-29310":["thread",29310],"thread-29309":["thread",29309],"thread-29308":["thread",29308],"thread-29307":["thread",29307],"thread-29306":["thread",29306],"thread-29305":["thread",29305],"thread-29304":["thread",29304],"thread-29303":["thread",29303],"thread-29302":["thread",29302],"thread-29301":["thread",29301],"thread-29300":["thread",29300],"thread-29299":["thread",29299],"thread-29298":["thread",29298],"thread-29297":["thread",29297],"thread-29296":["thread",29296],"thread-29295":["thread",29295],"thread-29294":["thread",29294],"thread-29293":["thread",29293],"thread-29292":["thread",29292],"thread-29291":["thread",29291],"thread-29290":["thread",29290],"thread-29289":["thread",29289],"thread-29288":["thread",29288],"thread-29287":["thread",29287],"thread-29286":["thread",29286],"thread-29285":["thread",29285],"thread-29284":["thread",29284],"thread-29283":["thread",29283],"thread-29282":["thread",29282],"thread-29281":["thread",29281],"thread-29280":["thread",29280],"thread-29279":["thread",29279],"thread-29278":["thread",29278],"thread-29277":["thread",29277],"thread-29276":["thread",29276],"thread-29275":["thread",29275],"thread-29274":["thread",29274],"thread-29273":["thread",29273],"thread-29272":["thread",29272],"thread-29271":["thread",29271],"thread-29270":["thread",29270],"thread-29269":["thread",29269],"thread-29268":["thread",29268],"thread-29267":["thread",29267],"thread-29266":["thread",29266],"thread-29265":["thread",29265],"thread-29264":["thread",29264],"thread-29263":["thread",29263],"thread-29262":["thread",29262],"thread-29261":["thread",29261],"thread-29260":["thread",29260],"thread-29259":["thread",29259],"thread-29258":["thread",29258],"thread-29257":["thread",29257],"thread-29256":["thread",29256],"thread-29255":["thread",29255],"thread-29254":["thread",29254],"thread-29253":["thread",29253],"thread-29252":["thread",29252],"thread-29251":["thread",29251],"thread-29250":["thread",29250],"thread-29249":["thread",29249],"thread-29248":["thread",29248],"thread-29247":["thread",29247],"thread-29246":["thread",29246],"thread-29245":["thread",29245],"thread-29244":["thread",29244],"thread-29243":["thread",29243],"thread-29242":["thread",29242],"thread-29241":["thread",29241],"thread-29240":["thread",29240],"thread-29239":["thread",29239],"thread-29238":["thread",29238],"thread-29237":["thread",29237],"thread-29236":["thread",29236],"thread-29235":["thread",29235],"thread-29234":["thread",29234],"thread-29233":["thread",29233],"thread-29232":["thread",29232],"thread-29231":["thread",29231],"thread-29230":["thread",29230],"thread-29229":["thread",29229],"thread-29228":["thread",29228],"thread-29227":["thread",29227],"thread-29226":["thread",29226],"thread-29225":["thread",29225],"thread-29224":["thread",29224],"thread-29223":["thread",29223],"thread-29222":["thread",29222],"thread-29221":["thread",29221],"thread-29220":["thread",29220],"thread-29219":["thread",29219],"thread-29218":["thread",29218],"thread-29217":["thread",29217],"thread-29216":["thread",29216],"thread-29215":["thread",29215],"thread-29214":["thread",29214],"thread-29213":["thread",29213],"thread-29212":["thread",29212],"thread-29211":["thread",29211],"thread-29210":["thread",29210],"thread-29209":["thread",29209],"thread-29208":["thread",29208],"thread-29207":["thread",29207],"thread-29206":["thread",29206],"thread-29205":["thread",29205],"thread-29204":["thread",29204],"thread-29203":["thread",29203],"thread-29202":["thread",29202],"thread-29201":["thread",29201],"thread-29200":["thread",29200],"thread-29199":["thread",29199],"thread-29198":["thread",29198],"thread-29197":["thread",29197],"thread-29196":["thread",29196],"thread-29195":["thread",29195],"thread-29194":["thread",29194],"thread-29193":["thread",29193],"thread-29192":["thread",29192],"thread-29191":["thread",29191],"thread-29190":["thread",29190],"thread-29189":["thread",29189],"thread-29188":["thread",29188],"thread-29187":["thread",29187],"thread-29186":["thread",29186],"thread-29185":["thread",29185],"thread-29184":["thread",29184],"thread-29183":["thread",29183],"thread-29182":["thread",29182],"thread-29181":["thread",29181],"thread-29180":["thread",29180],"thread-29179":["thread",29179],"thread-29178":["thread",29178],"thread-29177":["thread",29177],"thread-29176":["thread",29176],"thread-29175":["thread",29175],"thread-29174":["thread",29174],"thread-29173":["thread",29173],"thread-29172":["thread",29172],"thread-29171":["thread",29171],"thread-29170":["thread",29170]}, , 1715743581
Run Time: 0.000796
- 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