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 (44238, 39336, 39297, 37649, 28320, 28319, 28318, 28317, 28316, 28315, 28314, 28313, 28312, 28311, 28310, 28309, 28308, 28307, 28306, 28305, 28304, 28303, 28302, 28301, 28300, 28299, 28298, 28297, 28296, 28295, 28294, 28293, 28292, 28291, 28290, 28289, 28288, 28287, 28286, 28285, 28284, 28283, 28282, 28281, 28280, 28279, 28278, 28277, 28276, 28275, 28274, 28273, 28272, 28271, 28270, 28269, 28268, 28267, 28266, 28265, 28264, 28263, 28262, 28261, 28260, 28259, 28258, 28257, 28256, 28255, 28254, 28253, 28252, 28251, 28250, 28249, 28248, 28247, 28246, 28245, 28244, 28243, 28242, 28241, 28240, 28239, 28238, 28237, 28236, 28235, 28234, 28233, 28232, 28231, 28230, 28229, 28228, 28227, 28226, 28225, 28224, 28223, 28222, 28221, 28220, 28219, 28218, 28217, 28216, 28215, 28214, 28213, 28212, 28211, 28210, 28209, 28208, 28207, 28206, 28205, 28204, 28203, 28202, 28201, 28200, 28199, 28198, 28197, 28196, 28195, 28194, 28193, 28192, 28191, 28190, 28189, 28188, 28187, 28186, 28185, 28184, 28183, 28182, 28181, 28180, 28179, 28178, 28177, 28176, 28175, 28174, 28173, 28172, 28171, 28170, 28169, 28168, 28167, 28166, 28165, 28164, 28163, 28162, 28161, 28160, 28159, 28158, 28157, 28156, 28155, 28154, 28153, 28152, 28151, 28150, 28149, 28148, 28147, 28146, 28145, 28144, 28143, 28142, 28141, 28140, 28139, 28138, 28137, 28136, 28135, 28134, 28133, 28132, 28131, 28130, 28129, 28128, 28127, 28126, 28125))
Run Time: 0.010360
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: 5727, 0, 1715647147, {"thread-44238":["thread",44238],"thread-39336":["thread",39336],"thread-39297":["thread",39297],"thread-37649":["thread",37649],"thread-28320":["thread",28320],"thread-28319":["thread",28319],"thread-28318":["thread",28318],"thread-28317":["thread",28317],"thread-28316":["thread",28316],"thread-28315":["thread",28315],"thread-28314":["thread",28314],"thread-28313":["thread",28313],"thread-28312":["thread",28312],"thread-28311":["thread",28311],"thread-28310":["thread",28310],"thread-28309":["thread",28309],"thread-28308":["thread",28308],"thread-28307":["thread",28307],"thread-28306":["thread",28306],"thread-28305":["thread",28305],"thread-28304":["thread",28304],"thread-28303":["thread",28303],"thread-28302":["thread",28302],"thread-28301":["thread",28301],"thread-28300":["thread",28300],"thread-28299":["thread",28299],"thread-28298":["thread",28298],"thread-28297":["thread",28297],"thread-28296":["thread",28296],"thread-28295":["thread",28295],"thread-28294":["thread",28294],"thread-28293":["thread",28293],"thread-28292":["thread",28292],"thread-28291":["thread",28291],"thread-28290":["thread",28290],"thread-28289":["thread",28289],"thread-28288":["thread",28288],"thread-28287":["thread",28287],"thread-28286":["thread",28286],"thread-28285":["thread",28285],"thread-28284":["thread",28284],"thread-28283":["thread",28283],"thread-28282":["thread",28282],"thread-28281":["thread",28281],"thread-28280":["thread",28280],"thread-28279":["thread",28279],"thread-28278":["thread",28278],"thread-28277":["thread",28277],"thread-28276":["thread",28276],"thread-28275":["thread",28275],"thread-28274":["thread",28274],"thread-28273":["thread",28273],"thread-28272":["thread",28272],"thread-28271":["thread",28271],"thread-28270":["thread",28270],"thread-28269":["thread",28269],"thread-28268":["thread",28268],"thread-28267":["thread",28267],"thread-28266":["thread",28266],"thread-28265":["thread",28265],"thread-28264":["thread",28264],"thread-28263":["thread",28263],"thread-28262":["thread",28262],"thread-28261":["thread",28261],"thread-28260":["thread",28260],"thread-28259":["thread",28259],"thread-28258":["thread",28258],"thread-28257":["thread",28257],"thread-28256":["thread",28256],"thread-28255":["thread",28255],"thread-28254":["thread",28254],"thread-28253":["thread",28253],"thread-28252":["thread",28252],"thread-28251":["thread",28251],"thread-28250":["thread",28250],"thread-28249":["thread",28249],"thread-28248":["thread",28248],"thread-28247":["thread",28247],"thread-28246":["thread",28246],"thread-28245":["thread",28245],"thread-28244":["thread",28244],"thread-28243":["thread",28243],"thread-28242":["thread",28242],"thread-28241":["thread",28241],"thread-28240":["thread",28240],"thread-28239":["thread",28239],"thread-28238":["thread",28238],"thread-28237":["thread",28237],"thread-28236":["thread",28236],"thread-28235":["thread",28235],"thread-28234":["thread",28234],"thread-28233":["thread",28233],"thread-28232":["thread",28232],"thread-28231":["thread",28231],"thread-28230":["thread",28230],"thread-28229":["thread",28229],"thread-28228":["thread",28228],"thread-28227":["thread",28227],"thread-28226":["thread",28226],"thread-28225":["thread",28225],"thread-28224":["thread",28224],"thread-28223":["thread",28223],"thread-28222":["thread",28222],"thread-28221":["thread",28221],"thread-28220":["thread",28220],"thread-28219":["thread",28219],"thread-28218":["thread",28218],"thread-28217":["thread",28217],"thread-28216":["thread",28216],"thread-28215":["thread",28215],"thread-28214":["thread",28214],"thread-28213":["thread",28213],"thread-28212":["thread",28212],"thread-28211":["thread",28211],"thread-28210":["thread",28210],"thread-28209":["thread",28209],"thread-28208":["thread",28208],"thread-28207":["thread",28207],"thread-28206":["thread",28206],"thread-28205":["thread",28205],"thread-28204":["thread",28204],"thread-28203":["thread",28203],"thread-28202":["thread",28202],"thread-28201":["thread",28201],"thread-28200":["thread",28200],"thread-28199":["thread",28199],"thread-28198":["thread",28198],"thread-28197":["thread",28197],"thread-28196":["thread",28196],"thread-28195":["thread",28195],"thread-28194":["thread",28194],"thread-28193":["thread",28193],"thread-28192":["thread",28192],"thread-28191":["thread",28191],"thread-28190":["thread",28190],"thread-28189":["thread",28189],"thread-28188":["thread",28188],"thread-28187":["thread",28187],"thread-28186":["thread",28186],"thread-28185":["thread",28185],"thread-28184":["thread",28184],"thread-28183":["thread",28183],"thread-28182":["thread",28182],"thread-28181":["thread",28181],"thread-28180":["thread",28180],"thread-28179":["thread",28179],"thread-28178":["thread",28178],"thread-28177":["thread",28177],"thread-28176":["thread",28176],"thread-28175":["thread",28175],"thread-28174":["thread",28174],"thread-28173":["thread",28173],"thread-28172":["thread",28172],"thread-28171":["thread",28171],"thread-28170":["thread",28170],"thread-28169":["thread",28169],"thread-28168":["thread",28168],"thread-28167":["thread",28167],"thread-28166":["thread",28166],"thread-28165":["thread",28165],"thread-28164":["thread",28164],"thread-28163":["thread",28163],"thread-28162":["thread",28162],"thread-28161":["thread",28161],"thread-28160":["thread",28160],"thread-28159":["thread",28159],"thread-28158":["thread",28158],"thread-28157":["thread",28157],"thread-28156":["thread",28156],"thread-28155":["thread",28155],"thread-28154":["thread",28154],"thread-28153":["thread",28153],"thread-28152":["thread",28152],"thread-28151":["thread",28151],"thread-28150":["thread",28150],"thread-28149":["thread",28149],"thread-28148":["thread",28148],"thread-28147":["thread",28147],"thread-28146":["thread",28146],"thread-28145":["thread",28145],"thread-28144":["thread",28144],"thread-28143":["thread",28143],"thread-28142":["thread",28142],"thread-28141":["thread",28141],"thread-28140":["thread",28140],"thread-28139":["thread",28139],"thread-28138":["thread",28138],"thread-28137":["thread",28137],"thread-28136":["thread",28136],"thread-28135":["thread",28135],"thread-28134":["thread",28134],"thread-28133":["thread",28133],"thread-28132":["thread",28132],"thread-28131":["thread",28131],"thread-28130":["thread",28130],"thread-28129":["thread",28129],"thread-28128":["thread",28128],"thread-28127":["thread",28127],"thread-28126":["thread",28126],"thread-28125":["thread",28125]}, , 1715643547
Run Time: 0.000525
- 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