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/draft-countdown-forums/pro-football/1109-randy-moss/page2','forum/draft-countdown-forums/pro-football/1109-randy-moss','forum/draft-countdown-forums/pro-football','forum/draft-countdown-forums','forum')

SQL Query #12

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 #35

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

SQL Query #38

SELECT node.*,text.nodeid AS text_nodeid,text.previewtext,text.previewimage,text.previewvideo,text.imageheight,text.imagewidth,text.rawtext,text.moderated,text.pagetextimages,text.pagetext,text.htmlstate,text.allowsmilie,text.showsignature,text.attach,text.infraction,text.reportnodeid, icon.iconpath, ch.routeid AS channelroute, ch.title AS channeltitle, ch.nodeid AS channelid,
starter.routeid AS starterroute, starter.title AS startertitle, starter.authorname as starterauthorname, starter.prefixid as starterprefixid,
starter.userid as starteruserid, starter.lastcontentid as starterlastcontentid, starter.totalcount+1 as startertotalcount, starter.urlident AS starterurlident,
deleteuser.username AS deleteusername, lastauthor.username AS lastauthorname, editlog.reason AS edit_reason, editlog.userid AS edit_userid, editlog.username AS edit_username,
editlog.dateline AS edit_dateline, editlog.hashistory, starter.nodeoptions as starternodeoptions, ch.nodeoptions as channelnodeoptions
FROM node AS node
LEFT JOIN text AS text
ON text.nodeid = node.nodeid
LEFT JOIN editlog AS editlog ON (editlog.nodeid = node.nodeid)
LEFT JOIN node AS starter ON (starter.nodeid = node.starter)
LEFT JOIN node AS ch ON (ch.nodeid = starter.parentid)
LEFT JOIN user AS deleteuser ON (node.deleteuserid > 0 AND node.deleteuserid = deleteuser.userid)
LEFT JOIN user AS lastauthor ON (node.lastauthorid = lastauthor.userid)
LEFT JOIN icon AS icon ON (node.iconid = icon.iconid)
WHERE node.nodeid IN (1109)
/** getFullContent**/

SQL Query #40

SELECT * 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 (1,0,-1)

SQL Query #48

SELECT
IFNULL(a.filedataid, IFNULL(p.filedataid, 0)) AS filedataid,
n.nodeid, n.parentid, n.contenttypeid,
a.visible, a.counter, a.posthash, a.filename, reportthreadid, a.settings,
p.height, p.width, p.style,
IFNULL(a.caption, IFNULL(p.caption, '')) AS caption
FROM node AS n
LEFT JOIN attach AS a ON (a.nodeid = n.nodeid)
LEFT JOIN photo AS p ON (p.nodeid = n.nodeid)
WHERE n.parentid IN (1109) AND
(a.nodeid IS NOT NULL OR p.nodeid IS NOT NULL)
ORDER BY n.displayorder
/**fetchNodeAttachments**/

SQL Query #60

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

SQL Query #69

SELECT * FROM cache
WHERE `cacheid` IN ('node_170547_lvl1data','node_170550_lvl1data','node_170555_lvl1data','node_170566_lvl1data','node_170568_lvl1data','node_170581_lvl1data','node_170591_lvl1data','node_170597_lvl1data','node_170598_lvl1data','node_170609_lvl1data','node_170630_lvl1data','node_170677_lvl1data','node_170684_lvl1data','node_170695_lvl1data','node_170697_lvl1data')

SQL Query #70

SELECT node.*, editlog.reason AS edit_reason, editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline, editlog.hashistory, 0 AS nodeVoted, 0 AS readtime
FROM node AS node
LEFT JOIN editlog AS editlog ON (editlog.nodeid = node.nodeid)
WHERE node.nodeid IN (170547,170550,170555,170566,170568,170581,170591,170597,170598,170609,170630,170677,170684,170695,170697)
/**fetchNodeWithContent**/

SQL Query #71

SELECT * FROM cache
WHERE `cacheid` IN ('vb_UserWPerms_155_1','vb_UserWPerms_820_1','vb_UserWPerms_151_1','vb_UserWPerms_685_1','vb_UserWPerms_187_1','vb_UserWPerms_665_1','vb_UserWPerms_698_1','vb_UserWPerms_1496_1','vb_UserWPerms_1955_1','vb_UserWPerms_626_1','vb_UserWPerms_0_1','vb_UserWPerms_583_1','vb_UserWPerms_224_1')

SQL Query #74

SELECT * FROM cache
WHERE `cacheid` IN ('vBAtchmnts_170547','vBAtchmnts_170550','vBAtchmnts_170555','vBAtchmnts_170566','vBAtchmnts_170568','vBAtchmnts_170581','vBAtchmnts_170591','vBAtchmnts_170597','vBAtchmnts_170598','vBAtchmnts_170609','vBAtchmnts_170630','vBAtchmnts_170677','vBAtchmnts_170684','vBAtchmnts_170695','vBAtchmnts_170697')

SQL Query #75

SELECT
IFNULL(a.filedataid, IFNULL(p.filedataid, 0)) AS filedataid,
n.nodeid, n.parentid, n.contenttypeid,
a.visible, a.counter, a.posthash, a.filename, reportthreadid, a.settings,
p.height, p.width, p.style,
IFNULL(a.caption, IFNULL(p.caption, '')) AS caption
FROM node AS n
LEFT JOIN attach AS a ON (a.nodeid = n.nodeid)
LEFT JOIN photo AS p ON (p.nodeid = n.nodeid)
WHERE n.parentid IN (170547,170550,170555,170566,170568,170581,170591,170597,170598,170609,170630,170677,170684,170695,170697) AND
(a.nodeid IS NOT NULL OR p.nodeid IS NOT NULL)
ORDER BY n.displayorder
/**fetchNodeAttachments**/

SQL Query #76

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 (170547,170550,170555,170566,170568,170581,170591,170597,170598,170609,170630,170677,170684,170695,170697)
GROUP BY cl.parent
/**getDescendantAttachCount**/

SQL Query #77

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 (170547,170550,170555,170566,170568,170581,170591,170597,170598,170609,170630,170677,170684,170695,170697) AND child.contenttypeid = 33
GROUP BY cl.parent
/**getDescendantPhotoCount**/

SQL Query #79

SELECT * FROM cache
WHERE `cacheid` IN ('node_170547_lvl3data','node_170550_lvl3data','node_170555_lvl3data','node_170566_lvl3data','node_170568_lvl3data','node_170581_lvl3data','node_170591_lvl3data','node_170597_lvl3data','node_170598_lvl3data','node_170609_lvl3data','node_170630_lvl3data','node_170677_lvl3data','node_170684_lvl3data','node_170695_lvl3data','node_170697_lvl3data')

SQL Query #80

SELECT node.*,text.nodeid AS text_nodeid,text.previewtext,text.previewimage,text.previewvideo,text.imageheight,text.imagewidth,text.rawtext,text.moderated,text.pagetextimages,text.pagetext,text.htmlstate,text.allowsmilie,text.showsignature,text.attach,text.infraction,text.reportnodeid, icon.iconpath, ch.routeid AS channelroute, ch.title AS channeltitle, ch.nodeid AS channelid,
starter.routeid AS starterroute, starter.title AS startertitle, starter.authorname as starterauthorname, starter.prefixid as starterprefixid,
starter.userid as starteruserid, starter.lastcontentid as starterlastcontentid, starter.totalcount+1 as startertotalcount, starter.urlident AS starterurlident,
deleteuser.username AS deleteusername, lastauthor.username AS lastauthorname, editlog.reason AS edit_reason, editlog.userid AS edit_userid, editlog.username AS edit_username,
editlog.dateline AS edit_dateline, editlog.hashistory, starter.nodeoptions as starternodeoptions, ch.nodeoptions as channelnodeoptions
FROM node AS node
LEFT JOIN text AS text
ON text.nodeid = node.nodeid
LEFT JOIN editlog AS editlog ON (editlog.nodeid = node.nodeid)
LEFT JOIN node AS starter ON (starter.nodeid = node.starter)
LEFT JOIN node AS ch ON (ch.nodeid = starter.parentid)
LEFT JOIN user AS deleteuser ON (node.deleteuserid > 0 AND node.deleteuserid = deleteuser.userid)
LEFT JOIN user AS lastauthor ON (node.lastauthorid = lastauthor.userid)
LEFT JOIN icon AS icon ON (node.iconid = icon.iconid)
WHERE node.nodeid IN (170547,170550,170555,170566,170568,170581,170591,170597,170598,170609,170630,170677,170684,170695,170697)
/** getFullContent**/

SQL Query #108

SELECT * FROM cache
WHERE `cacheid` IN ('vBUserRep_155','vBUserRep_820','vBUserRep_151','vBUserRep_685','vBUserRep_187','vBUserRep_665','vBUserRep_698','vBUserRep_1496','vBUserRep_1955','vBUserRep_626','vBUserRep_583','vBUserRep_224')

SQL Query #137

SELECT * FROM phrase
WHERE `varname` IN ('login_or_sign_up','you_can_also_login_as','logo','powered_by_vbulletin_title','sections','navbar_home','navbar_draft_countdown','navbar_mock_draft','navbar_player_rankings','navbar_dc_podcast','navbar_todays_posts','navbar_mark_channels_read','home','notice_1_html','announcement','no_announcement','collapse','expand','page_title','posts','latest_activity','search','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','reputation12','join_date','x_is_offline','comment','type_your_comment_here','cancel','post','see_previous_comments','see_next_comments','reputation6','reputation9','reputation4','guest_avatar','guest','','previous','next','navbar_help','navbar_contact_us','go_to_top','powered_by_vbulletin','footer_current_time','working_ellipsis','yes','no','ok') AND `languageid` IN (1,0,-1)

SQL Query #141

SELECT * FROM cache
WHERE `cacheid` IN ('vbnodetext170547_8_0:09f14d73cd828b8c283774e754116338','vbnodetext170550_8_0:09f14d73cd828b8c283774e754116338','vbnodetext170555_8_0:09f14d73cd828b8c283774e754116338','vbnodetext170566_8_0:09f14d73cd828b8c283774e754116338','vbnodetext170568_8_0:09f14d73cd828b8c283774e754116338','vbnodetext170581_8_0:09f14d73cd828b8c283774e754116338','vbnodetext170591_8_0:09f14d73cd828b8c283774e754116338','vbnodetext170597_8_0:09f14d73cd828b8c283774e754116338','vbnodetext170598_8_0:09f14d73cd828b8c283774e754116338','vbnodetext170609_8_0:09f14d73cd828b8c283774e754116338','vbnodetext170630_8_0:09f14d73cd828b8c283774e754116338','vbnodetext170677_8_0:09f14d73cd828b8c283774e754116338','vbnodetext170684_8_0:09f14d73cd828b8c283774e754116338','vbnodetext170695_8_0:09f14d73cd828b8c283774e754116338','vbnodetext170697_8_0:09f14d73cd828b8c283774e754116338')

SQL Query #143

SELECT * 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 (1,0,-1)