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 (38325, 38324, 38323, 38322, 38321, 38320, 38319, 38318, 38317, 38316, 38315, 38314, 38313, 38312, 38311, 38310, 38309, 38308, 38307, 38306, 38305, 38304, 38303, 38302, 38301, 38300, 38299, 38298, 38297, 38296, 38295, 38294, 38293, 38292, 38291, 38290, 38289, 38288, 38287, 38286, 38285, 38284, 38283, 38282, 38281, 38280, 38279, 38278, 38277, 38276, 38275, 38274, 38273, 38272, 38271, 38270, 38269, 38268, 38267, 38266, 38265, 38264, 38263, 38262, 38261, 38260, 38259, 38258, 38257, 38256, 38255, 38254, 38253, 38252, 38251, 38250, 38249, 38248, 38247, 38246, 38245, 38244, 38243, 38242, 38241, 38240, 38239, 38238, 38237, 38236, 38235, 38234, 38233, 38232, 38231, 38230, 38229, 38228, 38227, 38226, 38225, 38224, 38223, 38222, 38221, 38220, 38219, 38218, 38217, 38216, 38215, 38214, 38213, 38212, 38211, 38210, 38209, 38208, 38207, 38206, 38205, 38204, 38203, 38202, 38201, 38200, 38199, 38198, 38197, 38196, 38195, 38194, 38193, 38192, 38191, 38190, 38189, 38188, 38187, 38186, 38185, 38184, 38183, 38182, 38181, 38180, 38179, 38178, 38177, 38176, 38175, 38174, 38173, 38172, 38171, 38170, 38169, 38168, 38167, 38166, 38165, 38164, 38163, 38162, 38161, 38160, 38159, 38158, 38157, 38156, 38155, 38154, 38153, 38152, 38151, 38150, 38149, 38148, 38147, 38146, 38145, 38144, 38143, 38142, 38141, 38140, 38139, 38138, 38137, 38136, 38135, 38134, 38133, 38132, 38131, 38130, 38129, 38128, 38127, 38126))
Run Time: 0.016075
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: 5827, 0, 1715788702, {"thread-38325":["thread",38325],"thread-38324":["thread",38324],"thread-38323":["thread",38323],"thread-38322":["thread",38322],"thread-38321":["thread",38321],"thread-38320":["thread",38320],"thread-38319":["thread",38319],"thread-38318":["thread",38318],"thread-38317":["thread",38317],"thread-38316":["thread",38316],"thread-38315":["thread",38315],"thread-38314":["thread",38314],"thread-38313":["thread",38313],"thread-38312":["thread",38312],"thread-38311":["thread",38311],"thread-38310":["thread",38310],"thread-38309":["thread",38309],"thread-38308":["thread",38308],"thread-38307":["thread",38307],"thread-38306":["thread",38306],"thread-38305":["thread",38305],"thread-38304":["thread",38304],"thread-38303":["thread",38303],"thread-38302":["thread",38302],"thread-38301":["thread",38301],"thread-38300":["thread",38300],"thread-38299":["thread",38299],"thread-38298":["thread",38298],"thread-38297":["thread",38297],"thread-38296":["thread",38296],"thread-38295":["thread",38295],"thread-38294":["thread",38294],"thread-38293":["thread",38293],"thread-38292":["thread",38292],"thread-38291":["thread",38291],"thread-38290":["thread",38290],"thread-38289":["thread",38289],"thread-38288":["thread",38288],"thread-38287":["thread",38287],"thread-38286":["thread",38286],"thread-38285":["thread",38285],"thread-38284":["thread",38284],"thread-38283":["thread",38283],"thread-38282":["thread",38282],"thread-38281":["thread",38281],"thread-38280":["thread",38280],"thread-38279":["thread",38279],"thread-38278":["thread",38278],"thread-38277":["thread",38277],"thread-38276":["thread",38276],"thread-38275":["thread",38275],"thread-38274":["thread",38274],"thread-38273":["thread",38273],"thread-38272":["thread",38272],"thread-38271":["thread",38271],"thread-38270":["thread",38270],"thread-38269":["thread",38269],"thread-38268":["thread",38268],"thread-38267":["thread",38267],"thread-38266":["thread",38266],"thread-38265":["thread",38265],"thread-38264":["thread",38264],"thread-38263":["thread",38263],"thread-38262":["thread",38262],"thread-38261":["thread",38261],"thread-38260":["thread",38260],"thread-38259":["thread",38259],"thread-38258":["thread",38258],"thread-38257":["thread",38257],"thread-38256":["thread",38256],"thread-38255":["thread",38255],"thread-38254":["thread",38254],"thread-38253":["thread",38253],"thread-38252":["thread",38252],"thread-38251":["thread",38251],"thread-38250":["thread",38250],"thread-38249":["thread",38249],"thread-38248":["thread",38248],"thread-38247":["thread",38247],"thread-38246":["thread",38246],"thread-38245":["thread",38245],"thread-38244":["thread",38244],"thread-38243":["thread",38243],"thread-38242":["thread",38242],"thread-38241":["thread",38241],"thread-38240":["thread",38240],"thread-38239":["thread",38239],"thread-38238":["thread",38238],"thread-38237":["thread",38237],"thread-38236":["thread",38236],"thread-38235":["thread",38235],"thread-38234":["thread",38234],"thread-38233":["thread",38233],"thread-38232":["thread",38232],"thread-38231":["thread",38231],"thread-38230":["thread",38230],"thread-38229":["thread",38229],"thread-38228":["thread",38228],"thread-38227":["thread",38227],"thread-38226":["thread",38226],"thread-38225":["thread",38225],"thread-38224":["thread",38224],"thread-38223":["thread",38223],"thread-38222":["thread",38222],"thread-38221":["thread",38221],"thread-38220":["thread",38220],"thread-38219":["thread",38219],"thread-38218":["thread",38218],"thread-38217":["thread",38217],"thread-38216":["thread",38216],"thread-38215":["thread",38215],"thread-38214":["thread",38214],"thread-38213":["thread",38213],"thread-38212":["thread",38212],"thread-38211":["thread",38211],"thread-38210":["thread",38210],"thread-38209":["thread",38209],"thread-38208":["thread",38208],"thread-38207":["thread",38207],"thread-38206":["thread",38206],"thread-38205":["thread",38205],"thread-38204":["thread",38204],"thread-38203":["thread",38203],"thread-38202":["thread",38202],"thread-38201":["thread",38201],"thread-38200":["thread",38200],"thread-38199":["thread",38199],"thread-38198":["thread",38198],"thread-38197":["thread",38197],"thread-38196":["thread",38196],"thread-38195":["thread",38195],"thread-38194":["thread",38194],"thread-38193":["thread",38193],"thread-38192":["thread",38192],"thread-38191":["thread",38191],"thread-38190":["thread",38190],"thread-38189":["thread",38189],"thread-38188":["thread",38188],"thread-38187":["thread",38187],"thread-38186":["thread",38186],"thread-38185":["thread",38185],"thread-38184":["thread",38184],"thread-38183":["thread",38183],"thread-38182":["thread",38182],"thread-38181":["thread",38181],"thread-38180":["thread",38180],"thread-38179":["thread",38179],"thread-38178":["thread",38178],"thread-38177":["thread",38177],"thread-38176":["thread",38176],"thread-38175":["thread",38175],"thread-38174":["thread",38174],"thread-38173":["thread",38173],"thread-38172":["thread",38172],"thread-38171":["thread",38171],"thread-38170":["thread",38170],"thread-38169":["thread",38169],"thread-38168":["thread",38168],"thread-38167":["thread",38167],"thread-38166":["thread",38166],"thread-38165":["thread",38165],"thread-38164":["thread",38164],"thread-38163":["thread",38163],"thread-38162":["thread",38162],"thread-38161":["thread",38161],"thread-38160":["thread",38160],"thread-38159":["thread",38159],"thread-38158":["thread",38158],"thread-38157":["thread",38157],"thread-38156":["thread",38156],"thread-38155":["thread",38155],"thread-38154":["thread",38154],"thread-38153":["thread",38153],"thread-38152":["thread",38152],"thread-38151":["thread",38151],"thread-38150":["thread",38150],"thread-38149":["thread",38149],"thread-38148":["thread",38148],"thread-38147":["thread",38147],"thread-38146":["thread",38146],"thread-38145":["thread",38145],"thread-38144":["thread",38144],"thread-38143":["thread",38143],"thread-38142":["thread",38142],"thread-38141":["thread",38141],"thread-38140":["thread",38140],"thread-38139":["thread",38139],"thread-38138":["thread",38138],"thread-38137":["thread",38137],"thread-38136":["thread",38136],"thread-38135":["thread",38135],"thread-38134":["thread",38134],"thread-38133":["thread",38133],"thread-38132":["thread",38132],"thread-38131":["thread",38131],"thread-38130":["thread",38130],"thread-38129":["thread",38129],"thread-38128":["thread",38128],"thread-38127":["thread",38127],"thread-38126":["thread",38126]}, , 1715785102
Run Time: 0.000648
- 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