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 (100750, 100558, 100323, 100070, 99483, 99161, 99017, 98932, 98651, 98634, 98069, 97935, 97796, 97690, 97181, 97042, 96875, 96786, 96587, 96363, 96259, 96257, 95685, 95453, 95033, 95028, 94936, 94934, 93463, 93419, 93140, 93002, 92812, 92733, 92696, 92553, 92497, 92196, 92171, 91951, 89815, 89677, 89434, 89172, 88946, 88554, 88502, 88469, 88412, 88334, 88282, 87905, 87806, 87804, 87761, 87748, 87466, 87456, 87200, 86699, 86518, 86409, 86380, 86352, 86349, 86125, 86018, 85457, 85456, 85453, 85311, 85190, 84586, 84585, 84584, 84357, 84324, 84233, 84192, 84161, 84151, 84081, 84080, 84006, 81995, 79558, 79294, 79201, 78810, 78604, 77724, 77401, 76717, 76655, 76338, 76239, 75375, 75234, 74937, 74598, 74423, 74110, 73939, 73658, 72855, 72841, 72762, 72511, 70267, 70206, 69845, 69598, 69221, 68948, 68926, 68493, 68438, 68334, 68101, 72304, 72283, 66932, 66377, 72241, 66052, 65579, 64070, 62125, 62027, 61609, 61552, 61453, 71520, 71522, 71521, 71542, 60191, 71872, 59553, 59539, 72032, 72025, 58822, 58798, 58551, 57867, 57498, 57085, 56553, 55927, 55888, 55677, 55623, 55021, 54882, 54771, 54577, 54116, 53501, 53203, 53095, 52970, 52892, 52881, 52584, 52477, 52006, 51866, 51770, 51624, 51559, 51540, 51509, 51474, 51248, 50368, 50327, 49409, 49105, 49020, 48846, 48754, 47681, 47077, 47055, 46393, 45965, 45795, 45638, 45378, 45062, 44918, 44710, 44641, 44638, 44563, 44345, 44344, 44337, 44335, 44332, 44331, 44279, 44082, 43986, 43872, 43781, 43773, 43670, 43669, 43451, 43418, 43237, 43166, 43027, 43003, 42747, 42666, 42665, 42565, 42432, 41868, 39807, 39784, 39638, 37987, 37343, 36459, 35570, 34791, 34624, 34143, 34139, 34005, 33535, 33973, 33128, 33099, 80258, 31961, 31871, 31758, 31111, 30637, 30623, 30546, 30208, 29981, 29900, 29812, 29618, 29588, 29525, 29467, 29414, 29114, 29054, 28897, 28819, 28794, 28787, 28767, 28763, 28762, 28725, 28724, 28698, 28660, 28646, 28642, 28623, 28611, 28580, 28562, 28550, 28544, 28543, 28542, 28541, 28536, 28534, 28333, 26980, 28012, 26814, 26494, 26421, 26373, 26327, 26132, 26055, 25585, 25096, 24542, 24508, 24347, 23881, 23760, 23714, 23706, 23603, 23493, 23285, 23255, 23145, 23103, 23045, 22947, 22946, 22938, 22788, 22429, 22261, 22253, 22195, 22193, 22103, 21741, 21703, 21696, 21435, 21275, 21100, 21072, 20619, 20610, 20554, 20243, 18925, 18543, 18412, 18384, 18188, 17985, 17867, 17812, 17782, 17762, 17639, 17450, 17349, 17203, 16985, 16842, 16792, 16324, 15994, 15448, 15288, 14902, 14801, 14765, 14680, 14046, 13750, 13701, 13512, 13075, 12880, 12563, 12203, 12140, 12054, 11897, 11873, 11867, 11865, 11864, 11825, 10264, 10126, 9901, 9393, 6558, 6273, 6127, 5536, 5475, 3745, 2490, 2472, 197))
Run Time: 0.005362
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 382 | 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: 698, 0, 1714135110, {"thread-100750":["thread",100750],"thread-100558":["thread",100558],"thread-100323":["thread",100323],"thread-100070":["thread",100070],"thread-99483":["thread",99483],"thread-99161":["thread",99161],"thread-99017":["thread",99017],"thread-98932":["thread",98932],"thread-98651":["thread",98651],"thread-98634":["thread",98634],"thread-98069":["thread",98069],"thread-97935":["thread",97935],"thread-97796":["thread",97796],"thread-97690":["thread",97690],"thread-97181":["thread",97181],"thread-97042":["thread",97042],"thread-96875":["thread",96875],"thread-96786":["thread",96786],"thread-96587":["thread",96587],"thread-96363":["thread",96363],"thread-96259":["thread",96259],"thread-96257":["thread",96257],"thread-95685":["thread",95685],"thread-95453":["thread",95453],"thread-95033":["thread",95033],"thread-95028":["thread",95028],"thread-94936":["thread",94936],"thread-94934":["thread",94934],"thread-93463":["thread",93463],"thread-93419":["thread",93419],"thread-93140":["thread",93140],"thread-93002":["thread",93002],"thread-92812":["thread",92812],"thread-92733":["thread",92733],"thread-92696":["thread",92696],"thread-92553":["thread",92553],"thread-92497":["thread",92497],"thread-92196":["thread",92196],"thread-92171":["thread",92171],"thread-91951":["thread",91951],"thread-89815":["thread",89815],"thread-89677":["thread",89677],"thread-89434":["thread",89434],"thread-89172":["thread",89172],"thread-88946":["thread",88946],"thread-88554":["thread",88554],"thread-88502":["thread",88502],"thread-88469":["thread",88469],"thread-88412":["thread",88412],"thread-88334":["thread",88334],"thread-88282":["thread",88282],"thread-87905":["thread",87905],"thread-87806":["thread",87806],"thread-87804":["thread",87804],"thread-87761":["thread",87761],"thread-87748":["thread",87748],"thread-87466":["thread",87466],"thread-87456":["thread",87456],"thread-87200":["thread",87200],"thread-86699":["thread",86699],"thread-86518":["thread",86518],"thread-86409":["thread",86409],"thread-86380":["thread",86380],"thread-86352":["thread",86352],"thread-86349":["thread",86349],"thread-86125":["thread",86125],"thread-86018":["thread",86018],"thread-85457":["thread",85457],"thread-85456":["thread",85456],"thread-85453":["thread",85453],"thread-85311":["thread",85311],"thread-85190":["thread",85190],"thread-84586":["thread",84586],"thread-84585":["thread",84585],"thread-84584":["thread",84584],"thread-84357":["thread",84357],"thread-84324":["thread",84324],"thread-84233":["thread",84233],"thread-84192":["thread",84192],"thread-84161":["thread",84161],"thread-84151":["thread",84151],"thread-84081":["thread",84081],"thread-84080":["thread",84080],"thread-84006":["thread",84006],"thread-81995":["thread",81995],"thread-79558":["thread",79558],"thread-79294":["thread",79294],"thread-79201":["thread",79201],"thread-78810":["thread",78810],"thread-78604":["thread",78604],"thread-77724":["thread",77724],"thread-77401":["thread",77401],"thread-76717":["thread",76717],"thread-76655":["thread",76655],"thread-76338":["thread",76338],"thread-76239":["thread",76239],"thread-75375":["thread",75375],"thread-75234":["thread",75234],"thread-74937":["thread",74937],"thread-74598":["thread",74598],"thread-74423":["thread",74423],"thread-74110":["thread",74110],"thread-73939":["thread",73939],"thread-73658":["thread",73658],"thread-72855":["thread",72855],"thread-72841":["thread",72841],"thread-72762":["thread",72762],"thread-72511":["thread",72511],"thread-70267":["thread",70267],"thread-70206":["thread",70206],"thread-69845":["thread",69845],"thread-69598":["thread",69598],"thread-69221":["thread",69221],"thread-68948":["thread",68948],"thread-68926":["thread",68926],"thread-68493":["thread",68493],"thread-68438":["thread",68438],"thread-68334":["thread",68334],"thread-68101":["thread",68101],"thread-72304":["thread",72304],"thread-72283":["thread",72283],"thread-66932":["thread",66932],"thread-66377":["thread",66377],"thread-72241":["thread",72241],"thread-66052":["thread",66052],"thread-65579":["thread",65579],"thread-64070":["thread",64070],"thread-62125":["thread",62125],"thread-62027":["thread",62027],"thread-61609":["thread",61609],"thread-61552":["thread",61552],"thread-61453":["thread",61453],"thread-71520":["thread",71520],"thread-71522":["thread",71522],"thread-71521":["thread",71521],"thread-71542":["thread",71542],"thread-60191":["thread",60191],"thread-71872":["thread",71872],"thread-59553":["thread",59553],"thread-59539":["thread",59539],"thread-72032":["thread",72032],"thread-72025":["thread",72025],"thread-58822":["thread",58822],"thread-58798":["thread",58798],"thread-58551":["thread",58551],"thread-57867":["thread",57867],"thread-57498":["thread",57498],"thread-57085":["thread",57085],"thread-56553":["thread",56553],"thread-55927":["thread",55927],"thread-55888":["thread",55888],"thread-55677":["thread",55677],"thread-55623":["thread",55623],"thread-55021":["thread",55021],"thread-54882":["thread",54882],"thread-54771":["thread",54771],"thread-54577":["thread",54577],"thread-54116":["thread",54116],"thread-53501":["thread",53501],"thread-53203":["thread",53203],"thread-53095":["thread",53095],"thread-52970":["thread",52970],"thread-52892":["thread",52892],"thread-52881":["thread",52881],"thread-52584":["thread",52584],"thread-52477":["thread",52477],"thread-52006":["thread",52006],"thread-51866":["thread",51866],"thread-51770":["thread",51770],"thread-51624":["thread",51624],"thread-51559":["thread",51559],"thread-51540":["thread",51540],"thread-51509":["thread",51509],"thread-51474":["thread",51474],"thread-51248":["thread",51248],"thread-50368":["thread",50368],"thread-50327":["thread",50327],"thread-49409":["thread",49409],"thread-49105":["thread",49105],"thread-49020":["thread",49020],"thread-48846":["thread",48846],"thread-48754":["thread",48754],"thread-47681":["thread",47681],"thread-47077":["thread",47077],"thread-47055":["thread",47055],"thread-46393":["thread",46393],"thread-45965":["thread",45965],"thread-45795":["thread",45795],"thread-45638":["thread",45638],"thread-45378":["thread",45378],"thread-45062":["thread",45062],"thread-44918":["thread",44918],"thread-44710":["thread",44710],"thread-44641":["thread",44641],"thread-44638":["thread",44638],"thread-44563":["thread",44563],"thread-44345":["thread",44345],"thread-44344":["thread",44344],"thread-44337":["thread",44337],"thread-44335":["thread",44335],"thread-44332":["thread",44332],"thread-44331":["thread",44331],"thread-44279":["thread",44279],"thread-44082":["thread",44082],"thread-43986":["thread",43986],"thread-43872":["thread",43872],"thread-43781":["thread",43781],"thread-43773":["thread",43773],"thread-43670":["thread",43670],"thread-43669":["thread",43669],"thread-43451":["thread",43451],"thread-43418":["thread",43418],"thread-43237":["thread",43237],"thread-43166":["thread",43166],"thread-43027":["thread",43027],"thread-43003":["thread",43003],"thread-42747":["thread",42747],"thread-42666":["thread",42666],"thread-42665":["thread",42665],"thread-42565":["thread",42565],"thread-42432":["thread",42432],"thread-41868":["thread",41868],"thread-39807":["thread",39807],"thread-39784":["thread",39784],"thread-39638":["thread",39638],"thread-37987":["thread",37987],"thread-37343":["thread",37343],"thread-36459":["thread",36459],"thread-35570":["thread",35570],"thread-34791":["thread",34791],"thread-34624":["thread",34624],"thread-34143":["thread",34143],"thread-34139":["thread",34139],"thread-34005":["thread",34005],"thread-33535":["thread",33535],"thread-33973":["thread",33973],"thread-33128":["thread",33128],"thread-33099":["thread",33099],"thread-80258":["thread",80258],"thread-31961":["thread",31961],"thread-31871":["thread",31871],"thread-31758":["thread",31758],"thread-31111":["thread",31111],"thread-30637":["thread",30637],"thread-30623":["thread",30623],"thread-30546":["thread",30546],"thread-30208":["thread",30208],"thread-29981":["thread",29981],"thread-29900":["thread",29900],"thread-29812":["thread",29812],"thread-29618":["thread",29618],"thread-29588":["thread",29588],"thread-29525":["thread",29525],"thread-29467":["thread",29467],"thread-29414":["thread",29414],"thread-29114":["thread",29114],"thread-29054":["thread",29054],"thread-28897":["thread",28897],"thread-28819":["thread",28819],"thread-28794":["thread",28794],"thread-28787":["thread",28787],"thread-28767":["thread",28767],"thread-28763":["thread",28763],"thread-28762":["thread",28762],"thread-28725":["thread",28725],"thread-28724":["thread",28724],"thread-28698":["thread",28698],"thread-28660":["thread",28660],"thread-28646":["thread",28646],"thread-28642":["thread",28642],"thread-28623":["thread",28623],"thread-28611":["thread",28611],"thread-28580":["thread",28580],"thread-28562":["thread",28562],"thread-28550":["thread",28550],"thread-28544":["thread",28544],"thread-28543":["thread",28543],"thread-28542":["thread",28542],"thread-28541":["thread",28541],"thread-28536":["thread",28536],"thread-28534":["thread",28534],"thread-28333":["thread",28333],"thread-26980":["thread",26980],"thread-28012":["thread",28012],"thread-26814":["thread",26814],"thread-26494":["thread",26494],"thread-26421":["thread",26421],"thread-26373":["thread",26373],"thread-26327":["thread",26327],"thread-26132":["thread",26132],"thread-26055":["thread",26055],"thread-25585":["thread",25585],"thread-25096":["thread",25096],"thread-24542":["thread",24542],"thread-24508":["thread",24508],"thread-24347":["thread",24347],"thread-23881":["thread",23881],"thread-23760":["thread",23760],"thread-23714":["thread",23714],"thread-23706":["thread",23706],"thread-23603":["thread",23603],"thread-23493":["thread",23493],"thread-23285":["thread",23285],"thread-23255":["thread",23255],"thread-23145":["thread",23145],"thread-23103":["thread",23103],"thread-23045":["thread",23045],"thread-22947":["thread",22947],"thread-22946":["thread",22946],"thread-22938":["thread",22938],"thread-22788":["thread",22788],"thread-22429":["thread",22429],"thread-22261":["thread",22261],"thread-22253":["thread",22253],"thread-22195":["thread",22195],"thread-22193":["thread",22193],"thread-22103":["thread",22103],"thread-21741":["thread",21741],"thread-21703":["thread",21703],"thread-21696":["thread",21696],"thread-21435":["thread",21435],"thread-21275":["thread",21275],"thread-21100":["thread",21100],"thread-21072":["thread",21072],"thread-20619":["thread",20619],"thread-20610":["thread",20610],"thread-20554":["thread",20554],"thread-20243":["thread",20243],"thread-18925":["thread",18925],"thread-18412":["thread",18412],"thread-18384":["thread",18384],"thread-18188":["thread",18188],"thread-17985":["thread",17985],"thread-17867":["thread",17867],"thread-17812":["thread",17812],"thread-17782":["thread",17782],"thread-17762":["thread",17762],"thread-17639":["thread",17639],"thread-17450":["thread",17450],"thread-17349":["thread",17349],"thread-17203":["thread",17203],"thread-16985":["thread",16985],"thread-16842":["thread",16842],"thread-16792":["thread",16792],"thread-16324":["thread",16324],"thread-15994":["thread",15994],"thread-15448":["thread",15448],"thread-15288":["thread",15288],"thread-14902":["thread",14902],"thread-14801":["thread",14801],"thread-14765":["thread",14765],"thread-14680":["thread",14680],"thread-14046":["thread",14046],"thread-13750":["thread",13750],"thread-13701":["thread",13701],"thread-13512":["thread",13512],"thread-13075":["thread",13075],"thread-12880":["thread",12880],"thread-12563":["thread",12563],"thread-12203":["thread",12203],"thread-12140":["thread",12140],"thread-12054":["thread",12054],"thread-11897":["thread",11897],"thread-11873":["thread",11873],"thread-11867":["thread",11867],"thread-11865":["thread",11865],"thread-11864":["thread",11864],"thread-11825":["thread",11825],"thread-10264":["thread",10264],"thread-10126":["thread",10126],"thread-9901":["thread",9901],"thread-9393":["thread",9393],"thread-6558":["thread",6558],"thread-6273":["thread",6273],"thread-6127":["thread",6127],"thread-5536":["thread",5536],"thread-5475":["thread",5475],"thread-3745":["thread",3745],"thread-2490":["thread",2490],"thread-2472":["thread",2472],"thread-197":["thread",197]}, NULL, 1714131510
Run Time: 0.000178
- 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