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 (43479, 43185, 43044, 43038, 42527, 42450, 42336, 41316, 40787, 40748, 40226, 39771, 39628, 39221, 38916, 38504, 38269, 38079, 37895, 37695, 37563, 37360, 36871, 36710, 36583, 36491, 36423, 36328, 36055, 35840, 35682, 35112, 34772, 34744, 34620, 34336, 34068, 34029, 33823, 33604, 33559, 33343, 33271, 33199, 33148, 33071, 32956, 32660, 32419, 32370, 31873, 31867, 31709, 31339, 31174, 30683, 30637, 30553, 30136, 29797, 29711, 29709, 29567, 29410, 29403, 29384, 29371, 29361, 29323, 29265, 29132, 29099, 28919, 28711, 28664, 28525, 28419, 28409, 28186, 28029, 28016, 27999, 27942, 27839, 27787, 27692, 27615, 27599, 27568, 27317, 27256, 27163, 27152, 27014, 26930, 26914, 26812, 26481, 26413, 26142, 25620, 25577, 25574, 25449, 25403, 25316, 25223, 25134, 25117, 25095, 25094, 24955, 24903, 24651, 24596, 24489, 24481, 24359, 24205, 24188, 24103, 23813, 23781, 23573, 23509, 23362, 23360, 23307, 23204, 22626, 22477, 22311, 22233, 22115, 22084, 22064, 22060, 21856, 21755, 21544, 21325, 21253, 21252, 20849, 20678, 20637, 20273, 20237, 19998, 19709, 19586, 19441, 19402, 19400, 19397, 19363, 19283, 19173, 19072, 18880, 18568, 18539, 18457, 18307, 17651, 17561, 17546, 17403, 17348, 16674, 16589, 16396, 16313, 16159, 15873, 15836, 15733, 15654, 15610, 15531, 15120, 14732, 14567, 14547, 14397, 13975, 12947, 12938, 12921, 12898, 12897, 12224, 12129, 12126, 12007, 11751, 11737, 11648, 11640, 11090, 10070, 10043, 9937, 9916, 9802, 8463, 8253, 8029, 7584, 7564, 6799, 6765, 6268, 2999, 2724, 2507, 1906, 1195, 1104, 585, 577, 450))
Run Time: 0.093856
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 222 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,squattheplanet.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 1430
- 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 2866
- 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 2483
- XF\App->run() in src/XF.php at line 524
- 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: 718, 0, 1717432295, {"thread-43479":["thread",43479],"thread-43185":["thread",43185],"thread-43044":["thread",43044],"thread-43038":["thread",43038],"thread-42527":["thread",42527],"thread-42450":["thread",42450],"thread-42336":["thread",42336],"thread-41316":["thread",41316],"thread-40787":["thread",40787],"thread-40748":["thread",40748],"thread-40226":["thread",40226],"thread-39771":["thread",39771],"thread-39628":["thread",39628],"thread-39221":["thread",39221],"thread-38916":["thread",38916],"thread-38504":["thread",38504],"thread-38269":["thread",38269],"thread-38079":["thread",38079],"thread-37895":["thread",37895],"thread-37695":["thread",37695],"thread-37563":["thread",37563],"thread-37360":["thread",37360],"thread-36871":["thread",36871],"thread-36710":["thread",36710],"thread-36583":["thread",36583],"thread-36491":["thread",36491],"thread-36423":["thread",36423],"thread-36328":["thread",36328],"thread-36055":["thread",36055],"thread-35840":["thread",35840],"thread-35682":["thread",35682],"thread-35112":["thread",35112],"thread-34772":["thread",34772],"thread-34744":["thread",34744],"thread-34620":["thread",34620],"thread-34336":["thread",34336],"thread-34068":["thread",34068],"thread-34029":["thread",34029],"thread-33823":["thread",33823],"thread-33604":["thread",33604],"thread-33559":["thread",33559],"thread-33343":["thread",33343],"thread-33271":["thread",33271],"thread-33199":["thread",33199],"thread-33148":["thread",33148],"thread-33071":["thread",33071],"thread-32956":["thread",32956],"thread-32660":["thread",32660],"thread-32419":["thread",32419],"thread-32370":["thread",32370],"thread-31873":["thread",31873],"thread-31867":["thread",31867],"thread-31709":["thread",31709],"thread-31339":["thread",31339],"thread-31174":["thread",31174],"thread-30683":["thread",30683],"thread-30637":["thread",30637],"thread-30553":["thread",30553],"thread-30136":["thread",30136],"thread-29797":["thread",29797],"thread-29711":["thread",29711],"thread-29709":["thread",29709],"thread-29567":["thread",29567],"thread-29410":["thread",29410],"thread-29403":["thread",29403],"thread-29384":["thread",29384],"thread-29371":["thread",29371],"thread-29361":["thread",29361],"thread-29323":["thread",29323],"thread-29265":["thread",29265],"thread-29132":["thread",29132],"thread-29099":["thread",29099],"thread-28919":["thread",28919],"thread-28711":["thread",28711],"thread-28664":["thread",28664],"thread-28525":["thread",28525],"thread-28419":["thread",28419],"thread-28409":["thread",28409],"thread-28186":["thread",28186],"thread-28029":["thread",28029],"thread-28016":["thread",28016],"thread-27999":["thread",27999],"thread-27942":["thread",27942],"thread-27839":["thread",27839],"thread-27787":["thread",27787],"thread-27692":["thread",27692],"thread-27615":["thread",27615],"thread-27599":["thread",27599],"thread-27568":["thread",27568],"thread-27317":["thread",27317],"thread-27256":["thread",27256],"thread-27163":["thread",27163],"thread-27152":["thread",27152],"thread-27014":["thread",27014],"thread-26930":["thread",26930],"thread-26914":["thread",26914],"thread-26812":["thread",26812],"thread-26481":["thread",26481],"thread-26413":["thread",26413],"thread-26142":["thread",26142],"thread-25620":["thread",25620],"thread-25577":["thread",25577],"thread-25574":["thread",25574],"thread-25449":["thread",25449],"thread-25403":["thread",25403],"thread-25316":["thread",25316],"thread-25223":["thread",25223],"thread-25134":["thread",25134],"thread-25117":["thread",25117],"thread-25095":["thread",25095],"thread-25094":["thread",25094],"thread-24955":["thread",24955],"thread-24903":["thread",24903],"thread-24651":["thread",24651],"thread-24596":["thread",24596],"thread-24489":["thread",24489],"thread-24481":["thread",24481],"thread-24359":["thread",24359],"thread-24205":["thread",24205],"thread-24188":["thread",24188],"thread-24103":["thread",24103],"thread-23813":["thread",23813],"thread-23781":["thread",23781],"thread-23573":["thread",23573],"thread-23509":["thread",23509],"thread-23362":["thread",23362],"thread-23360":["thread",23360],"thread-23307":["thread",23307],"thread-23204":["thread",23204],"thread-22626":["thread",22626],"thread-22477":["thread",22477],"thread-22311":["thread",22311],"thread-22233":["thread",22233],"thread-22115":["thread",22115],"thread-22084":["thread",22084],"thread-22064":["thread",22064],"thread-22060":["thread",22060],"thread-21856":["thread",21856],"thread-21755":["thread",21755],"thread-21544":["thread",21544],"thread-21325":["thread",21325],"thread-21253":["thread",21253],"thread-21252":["thread",21252],"thread-20849":["thread",20849],"thread-20678":["thread",20678],"thread-20637":["thread",20637],"thread-20273":["thread",20273],"thread-20237":["thread",20237],"thread-19998":["thread",19998],"thread-19709":["thread",19709],"thread-19586":["thread",19586],"thread-19441":["thread",19441],"thread-19402":["thread",19402],"thread-19400":["thread",19400],"thread-19397":["thread",19397],"thread-19363":["thread",19363],"thread-19283":["thread",19283],"thread-19173":["thread",19173],"thread-19072":["thread",19072],"thread-18880":["thread",18880],"thread-18568":["thread",18568],"thread-18539":["thread",18539],"thread-18457":["thread",18457],"thread-18307":["thread",18307],"thread-17651":["thread",17651],"thread-17561":["thread",17561],"thread-17546":["thread",17546],"thread-17403":["thread",17403],"thread-17348":["thread",17348],"thread-16674":["thread",16674],"thread-16589":["thread",16589],"thread-16396":["thread",16396],"thread-16313":["thread",16313],"thread-16159":["thread",16159],"thread-15873":["thread",15873],"thread-15836":["thread",15836],"thread-15733":["thread",15733],"thread-15654":["thread",15654],"thread-15610":["thread",15610],"thread-15531":["thread",15531],"thread-15120":["thread",15120],"thread-14732":["thread",14732],"thread-14567":["thread",14567],"thread-14547":["thread",14547],"thread-14397":["thread",14397],"thread-13975":["thread",13975],"thread-12947":["thread",12947],"thread-12938":["thread",12938],"thread-12921":["thread",12921],"thread-12898":["thread",12898],"thread-12897":["thread",12897],"thread-12224":["thread",12224],"thread-12129":["thread",12129],"thread-12126":["thread",12126],"thread-12007":["thread",12007],"thread-11751":["thread",11751],"thread-11737":["thread",11737],"thread-11648":["thread",11648],"thread-11640":["thread",11640],"thread-11090":["thread",11090],"thread-10070":["thread",10070],"thread-10043":["thread",10043],"thread-9937":["thread",9937],"thread-9916":["thread",9916],"thread-9802":["thread",9802],"thread-8463":["thread",8463],"thread-8253":["thread",8253],"thread-8029":["thread",8029],"thread-7584":["thread",7584],"thread-7564":["thread",7564],"thread-6799":["thread",6799],"thread-6765":["thread",6765],"thread-6268":["thread",6268],"thread-2999":["thread",2999],"thread-2724":["thread",2724],"thread-2507":["thread",2507],"thread-1906":["thread",1906],"thread-1195":["thread",1195],"thread-1104":["thread",1104],"thread-585":["thread",585],"thread-577":["thread",577],"thread-450":["thread",450]}, NULL, 1717428695
Run Time: 0.001079
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- 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 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20