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 (103656, 103214, 101976, 101588, 101501, 101412, 101266, 100837, 100757, 100690, 100689, 100631, 100614, 100478, 100034, 99224, 98815, 98498, 98459, 98021, 97961, 97898, 97775, 97681, 96994, 96863, 96822, 96780, 96733, 96707, 96547, 96500, 96420, 96326, 96296, 96284, 96251, 94938, 94708, 94355, 93230, 92999, 92883, 92708, 92703, 92241, 91910, 91898, 91877, 91703, 91456, 91435, 89849, 89663, 89650, 89576, 89499, 89342, 89027, 88831, 87370, 87245, 87211, 86557, 85377, 83655, 82536, 81794, 80413, 79850, 79694, 79294, 76932, 76799, 76615, 76445, 74372, 74341, 74127, 73966, 73956, 73435, 73408, 92729, 91440, 72381, 69643, 69557, 69513, 72266, 72203, 63844, 63699, 63587, 62790, 62730, 72182, 61633, 71811, 71727, 71729, 71732, 71733, 71752, 71814, 71865, 71887, 59377, 72015, 72057, 71915, 72023, 71589, 57223, 55977, 53110, 52991, 52566, 50677, 49923, 49548, 49488, 42790, 41450, 41398, 40739, 40685, 40068, 38753, 38470, 38116, 37887, 37700, 37001, 36463, 36146, 35568, 35329, 34686, 34305, 34274, 33586, 33427, 33197, 31526, 31525, 31448, 31291, 31204, 30842, 30638, 30321, 26185, 28798, 27797, 27694, 25670, 24836, 24443, 24255, 23678, 23650, 23612, 23127, 22828, 21366, 20998, 18441, 18432, 17866, 17806, 15401, 15361, 15105, 15001, 14827, 13652, 12296, 11880, 11700, 10978, 9556, 9538, 7368, 7285, 6267, 3123, 2455, 2272, 2170, 254))
Run Time: 0.002599
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 191 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,blutschwerter_forum.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 2870
- 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 138
- 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 2487
- 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: 377, 0, 1713522202, {"thread-103656":["thread",103656],"thread-103214":["thread",103214],"thread-101976":["thread",101976],"thread-101588":["thread",101588],"thread-101501":["thread",101501],"thread-101412":["thread",101412],"thread-101266":["thread",101266],"thread-100837":["thread",100837],"thread-100757":["thread",100757],"thread-100690":["thread",100690],"thread-100689":["thread",100689],"thread-100631":["thread",100631],"thread-100614":["thread",100614],"thread-100478":["thread",100478],"thread-100034":["thread",100034],"thread-99224":["thread",99224],"thread-98815":["thread",98815],"thread-98498":["thread",98498],"thread-98459":["thread",98459],"thread-98021":["thread",98021],"thread-97961":["thread",97961],"thread-97898":["thread",97898],"thread-97775":["thread",97775],"thread-97681":["thread",97681],"thread-96994":["thread",96994],"thread-96863":["thread",96863],"thread-96822":["thread",96822],"thread-96780":["thread",96780],"thread-96733":["thread",96733],"thread-96707":["thread",96707],"thread-96547":["thread",96547],"thread-96500":["thread",96500],"thread-96420":["thread",96420],"thread-96326":["thread",96326],"thread-96296":["thread",96296],"thread-96284":["thread",96284],"thread-96251":["thread",96251],"thread-94938":["thread",94938],"thread-94708":["thread",94708],"thread-94355":["thread",94355],"thread-93230":["thread",93230],"thread-92999":["thread",92999],"thread-92883":["thread",92883],"thread-92708":["thread",92708],"thread-92703":["thread",92703],"thread-92241":["thread",92241],"thread-91910":["thread",91910],"thread-91898":["thread",91898],"thread-91877":["thread",91877],"thread-91703":["thread",91703],"thread-91456":["thread",91456],"thread-91435":["thread",91435],"thread-89849":["thread",89849],"thread-89663":["thread",89663],"thread-89650":["thread",89650],"thread-89576":["thread",89576],"thread-89499":["thread",89499],"thread-89342":["thread",89342],"thread-89027":["thread",89027],"thread-88831":["thread",88831],"thread-87370":["thread",87370],"thread-87245":["thread",87245],"thread-87211":["thread",87211],"thread-86557":["thread",86557],"thread-85377":["thread",85377],"thread-83655":["thread",83655],"thread-82536":["thread",82536],"thread-81794":["thread",81794],"thread-80413":["thread",80413],"thread-79850":["thread",79850],"thread-79694":["thread",79694],"thread-79294":["thread",79294],"thread-76932":["thread",76932],"thread-76799":["thread",76799],"thread-76615":["thread",76615],"thread-76445":["thread",76445],"thread-74372":["thread",74372],"thread-74341":["thread",74341],"thread-74127":["thread",74127],"thread-73966":["thread",73966],"thread-73956":["thread",73956],"thread-73435":["thread",73435],"thread-73408":["thread",73408],"thread-92729":["thread",92729],"thread-91440":["thread",91440],"thread-72381":["thread",72381],"thread-69643":["thread",69643],"thread-69557":["thread",69557],"thread-69513":["thread",69513],"thread-72266":["thread",72266],"thread-72203":["thread",72203],"thread-63844":["thread",63844],"thread-63699":["thread",63699],"thread-63587":["thread",63587],"thread-62790":["thread",62790],"thread-62730":["thread",62730],"thread-72182":["thread",72182],"thread-61633":["thread",61633],"thread-71811":["thread",71811],"thread-71727":["thread",71727],"thread-71729":["thread",71729],"thread-71732":["thread",71732],"thread-71733":["thread",71733],"thread-71752":["thread",71752],"thread-71814":["thread",71814],"thread-71865":["thread",71865],"thread-71887":["thread",71887],"thread-59377":["thread",59377],"thread-72015":["thread",72015],"thread-72057":["thread",72057],"thread-71915":["thread",71915],"thread-72023":["thread",72023],"thread-71589":["thread",71589],"thread-57223":["thread",57223],"thread-55977":["thread",55977],"thread-53110":["thread",53110],"thread-52991":["thread",52991],"thread-52566":["thread",52566],"thread-50677":["thread",50677],"thread-49923":["thread",49923],"thread-49548":["thread",49548],"thread-49488":["thread",49488],"thread-42790":["thread",42790],"thread-41450":["thread",41450],"thread-41398":["thread",41398],"thread-40739":["thread",40739],"thread-40685":["thread",40685],"thread-40068":["thread",40068],"thread-38753":["thread",38753],"thread-38470":["thread",38470],"thread-38116":["thread",38116],"thread-37887":["thread",37887],"thread-37700":["thread",37700],"thread-37001":["thread",37001],"thread-36463":["thread",36463],"thread-36146":["thread",36146],"thread-35568":["thread",35568],"thread-35329":["thread",35329],"thread-34686":["thread",34686],"thread-34305":["thread",34305],"thread-34274":["thread",34274],"thread-33586":["thread",33586],"thread-33427":["thread",33427],"thread-33197":["thread",33197],"thread-31526":["thread",31526],"thread-31525":["thread",31525],"thread-31448":["thread",31448],"thread-31291":["thread",31291],"thread-31204":["thread",31204],"thread-30842":["thread",30842],"thread-30638":["thread",30638],"thread-30321":["thread",30321],"thread-26185":["thread",26185],"thread-28798":["thread",28798],"thread-27797":["thread",27797],"thread-27694":["thread",27694],"thread-25670":["thread",25670],"thread-24836":["thread",24836],"thread-24443":["thread",24443],"thread-24255":["thread",24255],"thread-23678":["thread",23678],"thread-23650":["thread",23650],"thread-23612":["thread",23612],"thread-23127":["thread",23127],"thread-22828":["thread",22828],"thread-21366":["thread",21366],"thread-20998":["thread",20998],"thread-18441":["thread",18441],"thread-18432":["thread",18432],"thread-17866":["thread",17866],"thread-17806":["thread",17806],"thread-15401":["thread",15401],"thread-15361":["thread",15361],"thread-15105":["thread",15105],"thread-15001":["thread",15001],"thread-14827":["thread",14827],"thread-13652":["thread",13652],"thread-12296":["thread",12296],"thread-11880":["thread",11880],"thread-11700":["thread",11700],"thread-10978":["thread",10978],"thread-9556":["thread",9556],"thread-9538":["thread",9538],"thread-7368":["thread",7368],"thread-7285":["thread",7285],"thread-6267":["thread",6267],"thread-3123":["thread",3123],"thread-2455":["thread",2455],"thread-2272":["thread",2272],"thread-2170":["thread",2170],"thread-254":["thread",254]}, NULL, 1713518602
Run Time: 0.000105
- 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 1526
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1258
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20