SQL Query #2

SELECT * FROM datastore
WHERE `title` IN ('options','bitfields','attachmentcache','usergroupcache','stylecache','languagecache','products','cron','profilefield','loadcache','miscoptions','noticecache','hooks','publicoptions','vBUgChannelAccess','vBUgChannelPermissionsFrom','vBChannelTypes')

SQL Query #6

SELECT * FROM routenew
WHERE `prefix` IN ('forum/handwerk/kreatives-schreiben/162611-mittwochsfrage-158-alles-hat-ein-ende-nur-die-wurst-hat-zwei','forum/handwerk/kreatives-schreiben','forum/handwerk','forum')

SQL Query #11

SELECT * FROM channel
WHERE `guid` IN ('vbulletin-4ecbdf567f2773.55528984','vbulletin-4ecbdf567f3341.44450667','vbulletin-4ecbdf567f3341.44451100','vbulletin-4ecbdf567f2c35.70389590','vbulletin-4ecbdf567f3a38.99555305','vbulletin-4ecbdf567f3a38.99555306','vbulletin-4ecbdf567f3a38.99555307','vbulletin-c-cmshome5229fa38b251e2.92227401','vbulletin-4ecbdf567f3da8.31769341','vbulletin-4ecbdf567f36c3.90966558','vbulletin-4ecbdf567f3a38.99555303','vbulletin-4ecbdf567f3a38.99555304','vbulletin-4ecbdf567f3a38.99555308')

SQL Query #32

SELECT cl.parent AS nodeid, count(child.nodeid) AS count
FROM closure AS cl
INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
WHERE cl.parent in (163828) AND child.contenttypeid = 16
GROUP BY cl.parent
/**getDescendantPhotoCount**/

SQL Query #35

SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('infraction_for_x_y','infraction_for_x_y_in_topic_z','warning_for_x_y','warning_for_x_y_in_topic_z','infraction_topic_post','infraction_topic_profile','infraction_received_ginfraction','warning_received_ginfraction','infraction_received_post','infraction_received_profile','warning_received_post','warning_received_profile','x_days','x_weeks','x_months','x_years','permanent') AND `languageid` IN (2,0,-1)

SQL Query #48

SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('widget_conversationdisplay_widgettitle','system_widgetcat','widget_announcement_widgettitle','display_widgetcat','widget_pagetitle_widgettitle','generic_widgetcat') AND `languageid` IN (2,0,-1)

SQL Query #70

SELECT * FROM searchlog
WHERE `searchhash` IN ('6c8eb66d87c1c0fb3c9f82c51ed247bf') AND `userid` = 0 AND `dateline` >= 1591521235 AND `sortby` = 'created' AND `sortorder` = 'asc'
ORDER BY `dateline` ASC

SQL Query #79

SELECT * FROM cache
WHERE `cacheid` IN ('node_162613_lvl1data','node_162621_lvl1data','node_162622_lvl1data','node_162624_lvl1data','node_162625_lvl1data','node_162641_lvl1data','node_162645_lvl1data','node_162649_lvl1data','node_162652_lvl1data','node_162662_lvl1data','node_162682_lvl1data','node_162716_lvl1data','node_162768_lvl1data','node_163842_lvl1data')

SQL Query #80

SELECT * FROM cache
WHERE `cacheid` IN ('vb_UserWPerms_133_2','vb_UserWPerms_478_2','vb_UserWPerms_11_2','vb_UserWPerms_476_2','vb_UserWPerms_62_2','vb_UserWPerms_42_2','vb_UserWPerms_80_2','vb_UserWPerms_39_2','vb_UserWPerms_87_2','vb_UserWPerms_1_2','vb_UserWPerms_51_2','vb_UserWPerms_681_2')

SQL Query #103

SELECT * FROM cache
WHERE `cacheid` IN ('vBAtchmnts_162613','vBAtchmnts_162621','vBAtchmnts_162622','vBAtchmnts_162624','vBAtchmnts_162625','vBAtchmnts_162641','vBAtchmnts_162645','vBAtchmnts_162649','vBAtchmnts_162652','vBAtchmnts_162662','vBAtchmnts_162682','vBAtchmnts_162716','vBAtchmnts_162768','vBAtchmnts_163842')

SQL Query #104

SELECT cl.parent AS nodeid, count(a.nodeid) AS count
FROM closure AS cl
INNER JOIN attach AS a ON (a.nodeid = cl.child)
WHERE cl.parent in (162611,162613,162621,162622,162624,162625,162641,162645,162649,162652,162662,162682,162716,162768,163828,163842)
GROUP BY cl.parent
/**getDescendantAttachCount**/

SQL Query #105

SELECT cl.parent AS nodeid, count(child.nodeid) AS count
FROM closure AS cl
INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
WHERE cl.parent in (162611,162613,162621,162622,162624,162625,162641,162645,162649,162652,162662,162682,162716,162768,163828,163842) AND child.contenttypeid = 16
GROUP BY cl.parent
/**getDescendantPhotoCount**/

SQL Query #107

SELECT * FROM cache
WHERE `cacheid` IN ('node_162613_lvl3data','node_162621_lvl3data','node_162622_lvl3data','node_162624_lvl3data','node_162625_lvl3data','node_162641_lvl3data','node_162645_lvl3data','node_162649_lvl3data','node_162652_lvl3data','node_162662_lvl3data','node_162682_lvl3data','node_162716_lvl3data','node_162768_lvl3data','node_163842_lvl3data')

SQL Query #111

SELECT * FROM cache
WHERE `cacheid` IN ('vBUserRep_133','vBUserRep_478','vBUserRep_11','vBUserRep_476','vBUserRep_62','vBUserRep_42','vBUserRep_80','vBUserRep_39','vBUserRep_87','vBUserRep_1','vBUserRep_51','vBUserRep_681')

SQL Query #136

SELECT cl.parent AS nodeid, count(a.nodeid) AS count
FROM closure AS cl
INNER JOIN attach AS a ON (a.nodeid = cl.child)
WHERE cl.parent in (162687,162677)
GROUP BY cl.parent
/**getDescendantAttachCount**/

SQL Query #137

SELECT cl.parent AS nodeid, count(child.nodeid) AS count
FROM closure AS cl
INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
WHERE cl.parent in (162687,162677) AND child.contenttypeid = 16
GROUP BY cl.parent
/**getDescendantPhotoCount**/

SQL Query #153

SELECT cl.parent AS nodeid, count(a.nodeid) AS count
FROM closure AS cl
INNER JOIN attach AS a ON (a.nodeid = cl.child)
WHERE cl.parent in (164030,163965,163938)
GROUP BY cl.parent
/**getDescendantAttachCount**/

SQL Query #154

SELECT cl.parent AS nodeid, count(child.nodeid) AS count
FROM closure AS cl
INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
WHERE cl.parent in (164030,163965,163938) AND child.contenttypeid = 16
GROUP BY cl.parent
/**getDescendantPhotoCount**/

SQL Query #170

SELECT cl.parent AS nodeid, count(a.nodeid) AS count
FROM closure AS cl
INNER JOIN attach AS a ON (a.nodeid = cl.child)
WHERE cl.parent in (162902,162901,162773)
GROUP BY cl.parent
/**getDescendantAttachCount**/

SQL Query #171

SELECT cl.parent AS nodeid, count(child.nodeid) AS count
FROM closure AS cl
INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
WHERE cl.parent in (162902,162901,162773) AND child.contenttypeid = 16
GROUP BY cl.parent
/**getDescendantPhotoCount**/

SQL Query #185

SELECT cl.parent AS nodeid, count(child.nodeid) AS count
FROM closure AS cl
INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
WHERE cl.parent in (162651) AND child.contenttypeid = 16
GROUP BY cl.parent
/**getDescendantPhotoCount**/

SQL Query #199

SELECT cl.parent AS nodeid, count(child.nodeid) AS count
FROM closure AS cl
INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
WHERE cl.parent in (162656) AND child.contenttypeid = 16
GROUP BY cl.parent
/**getDescendantPhotoCount**/

SQL Query #212

SELECT cl.parent AS nodeid, count(a.nodeid) AS count
FROM closure AS cl
INNER JOIN attach AS a ON (a.nodeid = cl.child)
WHERE cl.parent in (162730,162729)
GROUP BY cl.parent
/**getDescendantAttachCount**/

SQL Query #213

SELECT cl.parent AS nodeid, count(child.nodeid) AS count
FROM closure AS cl
INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
WHERE cl.parent in (162730,162729) AND child.contenttypeid = 16
GROUP BY cl.parent
/**getDescendantPhotoCount**/

SQL Query #228

SELECT cl.parent AS nodeid, count(a.nodeid) AS count
FROM closure AS cl
INNER JOIN attach AS a ON (a.nodeid = cl.child)
WHERE cl.parent in (164053,162898,162781)
GROUP BY cl.parent
/**getDescendantAttachCount**/

SQL Query #229

SELECT cl.parent AS nodeid, count(child.nodeid) AS count
FROM closure AS cl
INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
WHERE cl.parent in (164053,162898,162781) AND child.contenttypeid = 16
GROUP BY cl.parent
/**getDescendantPhotoCount**/

SQL Query #245

SELECT cl.parent AS nodeid, count(a.nodeid) AS count
FROM closure AS cl
INNER JOIN attach AS a ON (a.nodeid = cl.child)
WHERE cl.parent in (164054,163841)
GROUP BY cl.parent
/**getDescendantAttachCount**/

SQL Query #246

SELECT cl.parent AS nodeid, count(child.nodeid) AS count
FROM closure AS cl
INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
WHERE cl.parent in (164054,163841) AND child.contenttypeid = 16
GROUP BY cl.parent
/**getDescendantPhotoCount**/

SQL Query #252

SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('login_or_sign_up','you_can_also_login_as','logo','powered_by_vbulletin_title','search','filter_search','sections','navbar_home','navbar_articles','navbar_absprachenmediation','navbar_themenfilter','navbar_aktive_themen','navbar_regeln','navbar_faq','home','search_in_titles_only','search_in_x_only','advanced_search','notice_1_html','announcement','see_more','see_less','collapse','expand','page_title','posts','latest_activity','filter','time','all_time','today','last_week','last_month','show','all','discussions_only','photos_only','videos_only','links_only','polls_only','filtered_by','clear_all','conversation_new_posts','page','of_pagination','previous_page','next_page','reputation14','join_date','x_is_online_now','last_edited_by_x_on_y_at_z','likes_lower','tags','none','comment','type_your_comment_here','post','cancel','see_previous_comments','see_next_comments','x_is_offline','x_comments_lower','commented','editing_a_comment','like_lower','x_comment','previous','next','navbar_contact_us','navbar_impressum','go_to_top','powered_by_vbulletin','footer_current_time','working_ellipsis','yes','no','ok') AND `languageid` IN (2,0,-1)

SQL Query #254

SELECT * FROM cache
WHERE `cacheid` IN ('vbnodetext162611_42_0:09f14d73cd828b8c283774e754116338','vbnodetext162613_42_0:09f14d73cd828b8c283774e754116338','vbnodetext162621_42_0:09f14d73cd828b8c283774e754116338','vbnodetext162677_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext162687_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext162622_42_0:09f14d73cd828b8c283774e754116338','vbnodetext162624_42_0:09f14d73cd828b8c283774e754116338','vbnodetext162625_42_0:09f14d73cd828b8c283774e754116338','vbnodetext163938_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext163965_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext164030_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext162641_42_0:09f14d73cd828b8c283774e754116338','vbnodetext162773_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext162901_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext162902_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext162645_42_0:09f14d73cd828b8c283774e754116338','vbnodetext162649_42_0:09f14d73cd828b8c283774e754116338','vbnodetext162651_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext162652_42_0:09f14d73cd828b8c283774e754116338','vbnodetext162656_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext162662_42_0:09f14d73cd828b8c283774e754116338','vbnodetext162682_42_0:09f14d73cd828b8c283774e754116338','vbnodetext162729_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext162730_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext162716_42_0:09f14d73cd828b8c283774e754116338','vbnodetext162781_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext162898_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext164053_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext162768_42_0:09f14d73cd828b8c283774e754116338','vbnodetext163828_42_0:09f14d73cd828b8c283774e754116338','vbnodetext163841_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext164054_42_0:5c59d03846355cc52bc59508e3f5bc30','vbnodetext163842_42_0:09f14d73cd828b8c283774e754116338')

SQL Query #259

SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('debug_information','page_id','page_parent_id','page_template_id','route_id','page_type','screen_layout_id','screen_layout_template','channel_id','node_id','database_asserts','ajax_requests','facebook_active','not_enabled_or_no_appid_secret_set','style_id','templates_renders','parent','css_templates','rollup','js_files','included_files','autoloaded_classes','not_loaded','current_time','page_time') AND `languageid` IN (2,0,-1)