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 (183518, 178639, 176815, 173352, 172166, 171137, 171088, 170246, 170093, 166843, 163150, 162359, 162012, 161784, 161667, 161063, 160994, 160992, 160716, 158312, 158146, 157476, 157402, 155744, 155734, 155403, 155386, 155364, 155250, 155247, 155195, 155180, 155153, 155140, 155136, 155130, 155079, 155018, 154995, 154991, 154982, 154968, 154936, 154930, 154927, 154926, 154923, 154922, 154918, 154889, 154833, 154832, 154831, 154770, 154760, 154722, 154661, 154659, 154459, 154457, 154453, 154344, 154284, 154281, 154280, 154264, 154258, 154257, 154253, 154249, 154206, 154160, 154159, 154106, 153298, 153068, 152989, 151404, 151284, 150446, 140977, 137801, 137800, 134952, 134338, 130504, 126463, 125556, 125497, 125319, 125203, 125186, 125183, 125177, 125174, 125171, 125170, 125168, 125164, 125163, 125149, 123754, 123086, 116500, 114505, 109262, 103573, 84864, 75994, 75796, 75792, 75772, 75758, 75588, 75388, 74226, 59039, 39812, 38763, 38762, 38727, 38439, 38419, 38380, 38364, 38347, 38077, 38072, 37943, 37909, 37908, 37866, 37691, 37675, 37635, 37634, 37622, 37603, 37584, 37479, 37082, 36645, 36564, 36015, 35505, 35418, 35347, 35194, 35061, 35052, 35042, 35022, 34891, 34874, 34842, 34840, 34837, 34836, 34810, 34806, 34803, 34798, 34797, 34792, 34781, 34778, 34775, 34771, 34770, 34766, 34760, 34658, 34513, 34496, 34494, 34468, 34431, 34408, 34402, 34401, 34368, 34365, 34363, 34362, 34360, 34354, 34353, 34344, 34328, 34326, 34323, 34320, 34304, 34295, 34281, 34276, 34274, 34272))
Run Time: 0.384282
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 198 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 2729
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 69, 0, 1716178388, {"thread-183518":["thread",183518],"thread-178639":["thread",178639],"thread-176815":["thread",176815],"thread-173352":["thread",173352],"thread-172166":["thread",172166],"thread-171137":["thread",171137],"thread-171088":["thread",171088],"thread-170246":["thread",170246],"thread-170093":["thread",170093],"thread-166843":["thread",166843],"thread-163150":["thread",163150],"thread-162359":["thread",162359],"thread-162012":["thread",162012],"thread-161784":["thread",161784],"thread-161667":["thread",161667],"thread-161063":["thread",161063],"thread-160994":["thread",160994],"thread-160992":["thread",160992],"thread-160716":["thread",160716],"thread-158312":["thread",158312],"thread-158146":["thread",158146],"thread-157476":["thread",157476],"thread-157402":["thread",157402],"thread-155744":["thread",155744],"thread-155734":["thread",155734],"thread-155403":["thread",155403],"thread-155386":["thread",155386],"thread-155364":["thread",155364],"thread-155250":["thread",155250],"thread-155247":["thread",155247],"thread-155195":["thread",155195],"thread-155180":["thread",155180],"thread-155153":["thread",155153],"ams_article-4140":["ams_article",4140],"thread-155140":["thread",155140],"thread-155136":["thread",155136],"thread-155130":["thread",155130],"thread-155079":["thread",155079],"thread-155018":["thread",155018],"thread-154995":["thread",154995],"thread-154991":["thread",154991],"thread-154982":["thread",154982],"thread-154968":["thread",154968],"thread-154936":["thread",154936],"thread-154930":["thread",154930],"thread-154927":["thread",154927],"thread-154926":["thread",154926],"thread-154923":["thread",154923],"thread-154922":["thread",154922],"thread-154918":["thread",154918],"thread-154889":["thread",154889],"thread-154833":["thread",154833],"thread-154832":["thread",154832],"thread-154831":["thread",154831],"thread-154770":["thread",154770],"thread-154760":["thread",154760],"thread-154722":["thread",154722],"thread-154661":["thread",154661],"thread-154659":["thread",154659],"thread-154459":["thread",154459],"thread-154457":["thread",154457],"thread-154453":["thread",154453],"thread-154344":["thread",154344],"thread-154284":["thread",154284],"thread-154281":["thread",154281],"thread-154280":["thread",154280],"thread-154264":["thread",154264],"thread-154258":["thread",154258],"thread-154257":["thread",154257],"thread-154253":["thread",154253],"thread-154249":["thread",154249],"thread-154160":["thread",154160],"thread-154159":["thread",154159],"thread-154106":["thread",154106],"thread-153298":["thread",153298],"thread-153068":["thread",153068],"thread-152989":["thread",152989],"thread-151404":["thread",151404],"thread-151284":["thread",151284],"thread-150446":["thread",150446],"ams_article-3266":["ams_article",3266],"thread-140977":["thread",140977],"thread-137801":["thread",137801],"thread-137800":["thread",137800],"thread-134952":["thread",134952],"thread-134338":["thread",134338],"thread-130504":["thread",130504],"thread-126463":["thread",126463],"thread-125556":["thread",125556],"thread-125497":["thread",125497],"thread-125319":["thread",125319],"thread-125203":["thread",125203],"thread-125186":["thread",125186],"thread-125183":["thread",125183],"thread-125177":["thread",125177],"thread-125174":["thread",125174],"thread-125171":["thread",125171],"thread-125170":["thread",125170],"thread-125168":["thread",125168],"thread-125164":["thread",125164],"thread-125163":["thread",125163],"thread-125149":["thread",125149],"thread-123754":["thread",123754],"thread-123086":["thread",123086],"thread-116500":["thread",116500],"thread-114505":["thread",114505],"thread-109262":["thread",109262],"thread-103573":["thread",103573],"thread-84864":["thread",84864],"thread-75994":["thread",75994],"thread-75796":["thread",75796],"thread-75792":["thread",75792],"thread-75772":["thread",75772],"thread-75758":["thread",75758],"thread-75588":["thread",75588],"thread-75388":["thread",75388],"thread-74226":["thread",74226],"thread-59039":["thread",59039],"thread-39812":["thread",39812],"thread-38763":["thread",38763],"thread-38762":["thread",38762],"thread-38727":["thread",38727],"thread-38439":["thread",38439],"thread-38419":["thread",38419],"thread-38380":["thread",38380],"thread-38364":["thread",38364],"thread-38347":["thread",38347],"thread-38077":["thread",38077],"thread-38072":["thread",38072],"thread-37943":["thread",37943],"thread-37909":["thread",37909],"thread-37908":["thread",37908],"thread-37866":["thread",37866],"thread-37691":["thread",37691],"thread-37675":["thread",37675],"thread-37635":["thread",37635],"thread-37634":["thread",37634],"thread-37622":["thread",37622],"thread-37603":["thread",37603],"thread-37584":["thread",37584],"thread-37479":["thread",37479],"thread-37082":["thread",37082],"thread-36645":["thread",36645],"thread-36564":["thread",36564],"thread-36015":["thread",36015],"thread-35505":["thread",35505],"thread-35418":["thread",35418],"thread-35347":["thread",35347],"thread-35194":["thread",35194],"thread-35061":["thread",35061],"thread-35052":["thread",35052],"thread-35042":["thread",35042],"thread-35022":["thread",35022],"thread-34891":["thread",34891],"thread-34874":["thread",34874],"thread-34842":["thread",34842],"thread-34840":["thread",34840],"thread-34837":["thread",34837],"thread-34836":["thread",34836],"thread-34810":["thread",34810],"thread-34806":["thread",34806],"thread-34803":["thread",34803],"thread-34798":["thread",34798],"thread-34797":["thread",34797],"thread-34792":["thread",34792],"thread-34781":["thread",34781],"thread-34778":["thread",34778],"thread-34775":["thread",34775],"thread-34771":["thread",34771],"thread-34770":["thread",34770],"thread-34766":["thread",34766],"thread-34760":["thread",34760],"thread-34658":["thread",34658],"thread-34513":["thread",34513],"thread-34496":["thread",34496],"thread-34494":["thread",34494],"thread-34468":["thread",34468],"thread-34431":["thread",34431],"thread-34408":["thread",34408],"thread-34402":["thread",34402],"thread-34401":["thread",34401],"thread-34368":["thread",34368],"thread-34365":["thread",34365],"thread-34363":["thread",34363],"thread-34362":["thread",34362],"thread-34360":["thread",34360],"thread-34354":["thread",34354],"thread-34353":["thread",34353],"thread-34344":["thread",34344],"thread-34328":["thread",34328],"thread-34326":["thread",34326],"thread-34323":["thread",34323],"thread-34320":["thread",34320],"thread-34304":["thread",34304],"thread-34295":["thread",34295],"thread-34281":["thread",34281],"thread-34276":["thread",34276],"thread-34274":["thread",34274],"thread-34272":["thread",34272]}, , 1716174788
Run Time: 0.000543
- 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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20