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','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks' )
SELECT * FROM sessions WHERE id='07f11204df3d149121339e7b4db05dd3'
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=14
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=1 AND cache_type IN ('css', 'replacements')
SELECT * FROM topic_ratings WHERE rating_tid=14 and rating_member_id=0
SELECT pid FROM posts WHERE topic_id=14 AND queued=0 ORDER BY pid asc LIMIT 0,20
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.has_gallery, m.has_blog, m.members_bitoptions,m.mgroup_others,pp.*,pc.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_like_cache,cca.*,ccb.cache_content as cache_content_sig, ccb.cache_updated as cache_updated_sig FROM posts p 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 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 ) WHERE p.pid IN(15) ORDER BY pid asc
SELECT COUNT(*) as cnt, MIN(last_post) as lastItem FROM topics WHERE forum_id=2 AND approved=1 AND tid NOT IN(14,41,13,12,19,42,7,44,46) AND last_post > 1326154530 AND state != 'link'
SELECT s.member_id, s.member_name, s.member_group, s.id, s.login_type, s.running_time, s.uagent_type, s.current_module, s.seo_name FROM sessions s WHERE s.location_1_type='topic' AND s.location_1_id=14 AND s.running_time > 1328832030 AND s.in_error=0
SELECT * FROM core_like_cache WHERE like_cache_id='692c202848bb84252a07b7ddd29b594d'
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=619
SELECT * FROM core_editor_autosave WHERE eas_key='b506cb57178d53e057f6cc59f268459f'
SELECT * FROM bouncy_license WHERE app="BRC10"
SHUTDOWN: INSERT INTO topic_views (`views_tid`) VALUES(14)
1
