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 (44920, 41981, 34374, 34373, 34372, 34371, 34370, 34369, 34368, 34367, 34366, 34365, 34364, 34363, 34362, 34361, 34360, 34359, 34358, 34357, 34356, 34355, 34354, 34353, 34352, 34351, 34350, 34349, 34348, 34347, 34346, 34345, 34344, 34343, 34342, 34341, 34340, 34339, 34338, 34337, 34336, 34335, 34334, 34333, 34332, 34331, 34330, 34329, 34328, 34327, 34326, 34325, 34324, 34323, 34322, 34321, 34320, 34319, 34318, 34317, 34316, 34315, 34314, 34313, 34312, 34311, 34310, 34309, 34308, 34307, 34306, 34305, 34304, 34303, 34302, 34301, 34300, 34299, 34298, 34297, 34296, 34295, 34294, 34293, 34292, 34291, 34290, 34289, 34288, 34287, 34286, 34285, 34284, 34283, 34282, 34281, 34280, 34279, 34278, 34277, 34275, 34274, 34273, 34272, 34271, 34270, 34269, 34268, 34267, 34266, 34265, 34264, 34263, 34262, 34261, 34260, 34259, 34258, 34257, 34256, 34255, 34254, 34253, 34252, 34251, 34250, 34249, 34248, 34247, 34246, 34245, 34244, 34243, 34242, 34241, 34240, 34239, 34238, 34237, 34236, 34235, 34234, 34233, 34232, 34231, 34230, 34229, 34228, 34227, 34226, 34225, 34224, 34223, 34222, 34221, 34220, 34219, 34218, 34217, 34216, 34215, 34214, 34213, 34212, 34211, 34210, 34209, 34208, 34207, 34206, 34205, 34204, 34203, 34202, 34201, 34200, 34199, 34198, 34196, 34195, 34194, 34193, 34192, 34191, 34190, 34189, 34188, 34187, 34186, 34185, 34184, 34183, 34182, 34181, 34180, 34179, 34178, 34177, 34176, 34175))
Run Time: 0.018110
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: 5840, 0, 1715743849, {"thread-44920":["thread",44920],"thread-41981":["thread",41981],"thread-34374":["thread",34374],"thread-34373":["thread",34373],"thread-34372":["thread",34372],"thread-34371":["thread",34371],"thread-34370":["thread",34370],"thread-34369":["thread",34369],"thread-34368":["thread",34368],"thread-34367":["thread",34367],"thread-34366":["thread",34366],"thread-34365":["thread",34365],"thread-34364":["thread",34364],"thread-34363":["thread",34363],"thread-34362":["thread",34362],"thread-34361":["thread",34361],"thread-34360":["thread",34360],"thread-34359":["thread",34359],"thread-34358":["thread",34358],"thread-34357":["thread",34357],"thread-34356":["thread",34356],"thread-34355":["thread",34355],"thread-34354":["thread",34354],"thread-34353":["thread",34353],"thread-34352":["thread",34352],"thread-34351":["thread",34351],"thread-34350":["thread",34350],"thread-34349":["thread",34349],"thread-34348":["thread",34348],"thread-34347":["thread",34347],"thread-34346":["thread",34346],"thread-34345":["thread",34345],"thread-34344":["thread",34344],"thread-34343":["thread",34343],"thread-34342":["thread",34342],"thread-34341":["thread",34341],"thread-34340":["thread",34340],"thread-34339":["thread",34339],"thread-34338":["thread",34338],"thread-34337":["thread",34337],"thread-34336":["thread",34336],"thread-34335":["thread",34335],"thread-34334":["thread",34334],"thread-34333":["thread",34333],"thread-34332":["thread",34332],"thread-34331":["thread",34331],"thread-34330":["thread",34330],"thread-34329":["thread",34329],"thread-34328":["thread",34328],"thread-34327":["thread",34327],"thread-34326":["thread",34326],"thread-34325":["thread",34325],"thread-34324":["thread",34324],"thread-34323":["thread",34323],"thread-34322":["thread",34322],"thread-34321":["thread",34321],"thread-34320":["thread",34320],"thread-34319":["thread",34319],"thread-34318":["thread",34318],"thread-34317":["thread",34317],"thread-34316":["thread",34316],"thread-34315":["thread",34315],"thread-34314":["thread",34314],"thread-34313":["thread",34313],"thread-34312":["thread",34312],"thread-34311":["thread",34311],"thread-34310":["thread",34310],"thread-34309":["thread",34309],"thread-34308":["thread",34308],"thread-34307":["thread",34307],"thread-34306":["thread",34306],"thread-34305":["thread",34305],"thread-34304":["thread",34304],"thread-34303":["thread",34303],"thread-34302":["thread",34302],"thread-34301":["thread",34301],"thread-34300":["thread",34300],"thread-34299":["thread",34299],"thread-34298":["thread",34298],"thread-34297":["thread",34297],"thread-34296":["thread",34296],"thread-34295":["thread",34295],"thread-34294":["thread",34294],"thread-34293":["thread",34293],"thread-34292":["thread",34292],"thread-34291":["thread",34291],"thread-34290":["thread",34290],"thread-34289":["thread",34289],"thread-34288":["thread",34288],"thread-34287":["thread",34287],"thread-34286":["thread",34286],"thread-34285":["thread",34285],"thread-34284":["thread",34284],"thread-34283":["thread",34283],"thread-34282":["thread",34282],"thread-34281":["thread",34281],"thread-34280":["thread",34280],"thread-34279":["thread",34279],"thread-34278":["thread",34278],"thread-34277":["thread",34277],"thread-34275":["thread",34275],"thread-34274":["thread",34274],"thread-34273":["thread",34273],"thread-34272":["thread",34272],"thread-34271":["thread",34271],"thread-34270":["thread",34270],"thread-34269":["thread",34269],"thread-34268":["thread",34268],"thread-34267":["thread",34267],"thread-34266":["thread",34266],"thread-34265":["thread",34265],"thread-34264":["thread",34264],"thread-34263":["thread",34263],"thread-34262":["thread",34262],"thread-34261":["thread",34261],"thread-34260":["thread",34260],"thread-34259":["thread",34259],"thread-34258":["thread",34258],"thread-34257":["thread",34257],"thread-34256":["thread",34256],"thread-34255":["thread",34255],"thread-34254":["thread",34254],"thread-34253":["thread",34253],"thread-34252":["thread",34252],"thread-34251":["thread",34251],"thread-34250":["thread",34250],"thread-34249":["thread",34249],"thread-34248":["thread",34248],"thread-34247":["thread",34247],"thread-34246":["thread",34246],"thread-34245":["thread",34245],"thread-34244":["thread",34244],"thread-34243":["thread",34243],"thread-34242":["thread",34242],"thread-34241":["thread",34241],"thread-34240":["thread",34240],"thread-34239":["thread",34239],"thread-34238":["thread",34238],"thread-34237":["thread",34237],"thread-34236":["thread",34236],"thread-34235":["thread",34235],"thread-34234":["thread",34234],"thread-34233":["thread",34233],"thread-34232":["thread",34232],"thread-34231":["thread",34231],"thread-34230":["thread",34230],"thread-34229":["thread",34229],"thread-34228":["thread",34228],"thread-34227":["thread",34227],"thread-34226":["thread",34226],"thread-34225":["thread",34225],"thread-34224":["thread",34224],"thread-34223":["thread",34223],"thread-34222":["thread",34222],"thread-34221":["thread",34221],"thread-34220":["thread",34220],"thread-34219":["thread",34219],"thread-34218":["thread",34218],"thread-34217":["thread",34217],"thread-34216":["thread",34216],"thread-34215":["thread",34215],"thread-34214":["thread",34214],"thread-34213":["thread",34213],"thread-34212":["thread",34212],"thread-34211":["thread",34211],"thread-34210":["thread",34210],"thread-34209":["thread",34209],"thread-34208":["thread",34208],"thread-34207":["thread",34207],"thread-34206":["thread",34206],"thread-34205":["thread",34205],"thread-34204":["thread",34204],"thread-34203":["thread",34203],"thread-34202":["thread",34202],"thread-34201":["thread",34201],"thread-34200":["thread",34200],"thread-34199":["thread",34199],"thread-34198":["thread",34198],"thread-34196":["thread",34196],"thread-34195":["thread",34195],"thread-34194":["thread",34194],"thread-34193":["thread",34193],"thread-34192":["thread",34192],"thread-34191":["thread",34191],"thread-34190":["thread",34190],"thread-34189":["thread",34189],"thread-34188":["thread",34188],"thread-34187":["thread",34187],"thread-34186":["thread",34186],"thread-34185":["thread",34185],"thread-34184":["thread",34184],"thread-34183":["thread",34183],"thread-34182":["thread",34182],"thread-34181":["thread",34181],"thread-34180":["thread",34180],"thread-34179":["thread",34179],"thread-34178":["thread",34178],"thread-34177":["thread",34177],"thread-34176":["thread",34176],"thread-34175":["thread",34175]}, , 1715740249
Run Time: 0.000604
- 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