SELECT * FROM cache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','meta_tags','ipseo_acronyms','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks' )
DELETE FROM sessions WHERE ip_address='54.226.64.30'
SELECT t.*,xxx.* FROM topics t LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid=1845
SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id )
SELECT * FROM skin_cache WHERE cache_set_id=4 AND cache_type IN ('css', 'replacements')
SELECT p.*,m.member_id as mid,m.name,m.member_group_id,m.email,m.joined,m.posts, m.last_visit, m.last_activity,m.login_anonymous,m.title as member_title, m.warn_level, m.warn_lastwarn, m.members_display_name, m.members_seo_name, m.member_banned, m.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,m.m_awards,m.m_awards_display,pp.*,w.wl_id,pc.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache,cca.*,ccb.cache_content as cache_content_sig, ccb.cache_updated as cache_updated_sig FROM ( SELECT pid, post_date FROM posts WHERE topic_id=1845 AND queued=0 ORDER BY pid asc LIMIT 20,20 ) z LEFT JOIN posts p ON ( p.pid=z.pid )
LEFT JOIN members m ON ( m.member_id=p.author_id )
LEFT JOIN profile_portal pp ON ( m.member_id=pp.pp_member_id )
LEFT JOIN members_warn_logs w ON ( w.wl_content_app='forums' and w.wl_content_id1=p.pid )
LEFT JOIN pfields_content pc ON ( pc.member_id=p.author_id )
LEFT JOIN reputation_index rep_index ON ( rep_index.app='forums' AND
rep_index.type='pid' AND
rep_index.type_id=p.pid AND
rep_index.member_id=0 )
LEFT JOIN reputation_cache rep_cache ON ( rep_cache.app='forums' AND rep_cache.type='pid' AND rep_cache.type_id=p.pid )
LEFT JOIN content_cache_posts cca ON ( cca.cache_content_id=p.pid )
LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) ORDER BY z.pid asc
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='26203'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',26203,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT * FROM cache_store WHERE cs_key IN ( 'awards_categories' )
SELECT * FROM cache_store WHERE cs_key IN ( 'awards_awards' )
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='26213'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',26213,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='26226'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',26226,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='26233'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',26233,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='26261'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',26261,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='26296'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',26296,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='26297'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',26297,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='26302'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',26302,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='26303'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',26303,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='26306'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',26306,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='26335'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',26335,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='27328'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',27328,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='27329'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',27329,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='27553'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',27553,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='27561'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',27561,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='27568'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',27568,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='27573'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',27573,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='27866'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',27866,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='27886'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',27886,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM reputation_index r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.app='forums' AND r.type='pid' AND r.type_id='27926'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',27926,0,1548218875,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1548305275;}') ON DUPLICATE KEY UPDATE app=VALUES(app),type=VALUES(type),type_id=VALUES(type_id),rep_points=VALUES(rep_points),cache_date=VALUES(cache_date),rep_like_cache=VALUES(rep_like_cache)
SELECT * FROM core_like_cache WHERE like_cache_id='04d87db1b34e8800d6e4adc841cb66d6'
SELECT f.*,p.* FROM forums f LEFT JOIN permission_index p ON ( p.perm_type_id=f.id AND p.app='forums' AND p.perm_type='forum' ) WHERE f.id=0
SELECT tg.* ,t.*, t.approved, t.title as topic_title, t.posts as topic_posts, t.last_post as topic_last_post,m.*,p.*,xxx.* FROM core_tags tg LEFT JOIN topics t ON (t.tid=tg.tag_meta_id) LEFT JOIN members m ON (last_poster_id=m.member_id) LEFT JOIN profile_portal p ON (p.pp_member_id=m.member_id) LEFT JOIN core_tags_cache xxx ON (xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid))) WHERE tg.tag_meta_app='forums' AND tg.tag_meta_area='topics' AND tg.tag_meta_id !=1845 AND tg.tag_text IN ('spam','word association','games','ftw') AND tg.tag_aai_lookup IN (SELECT tag_perm_aai_lookup FROM core_tags_perms WHERE ( ( FIND_IN_SET(2,tag_perm_text) ) OR ( tag_perm_text='*' ) ) AND tag_perm_visible=1 ) ORDER BY tg.tag_meta_id desc LIMIT 0,100
SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id )
LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id )
LEFT JOIN groups g ON ( g.g_id=m.member_group_id )
LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id IN (310,347)
SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id )
LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id )
LEFT JOIN groups g ON ( g.g_id=m.member_group_id )
LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=248
SHUTDOWN: INSERT INTO sessions (`id`,`member_name`,`member_id`,`member_group`,`login_type`,`running_time`,`ip_address`,`browser`,`in_error`,`current_appcomponent`,`current_module`,`current_section`,`location_1_type`,`location_1_id`,`location_2_type`,`location_2_id`,`location_3_type`,`location_3_id`,`uagent_key`,`uagent_version`,`uagent_type`,`uagent_bypass`) VALUES('02170d0140240b7a5753e2870a58dd73','',0,2,0,1548218875,'54.226.64.30','CCBot/2.0 (https://commoncrawl.org/faq/)',0,'forums','forums','topics','topic',1845,'forum',0,'',0,'__NONE__',0,'',0)
SHUTDOWN: INSERT INTO topic_views (`views_tid`) VALUES(1845)
games, lol, memes, gandalf, is and 12 more...
