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','report_cache','report_plugins','ranks','emoticons','reputation_levels','moderators' )
SELECT * FROM sessions WHERE id='39b7879e757bf371c95b30607fab4d07'
SELECT * FROM skin_cache WHERE cache_set_id=1 AND cache_type IN ('css', 'replacements')
SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,s.*,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 sessions s ON ( s.member_id=m.member_id )
LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id=110
SELECT * FROM profile_friends WHERE friends_member_id=110 AND friends_approved=1 ORDER BY friends_approved DESC LIMIT 0,12
SELECT COUNT(*) as total_posts FROM posts WHERE author_id=110
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 COUNT(p.author_id) as f_posts,t.forum_id FROM posts p LEFT JOIN topics t ON ( t.tid=p.topic_id ) WHERE p.author_id=110 AND t.forum_id IN (2) GROUP BY t.forum_id ORDER BY f_posts DESC LIMIT 0,1
SELECT s.*,m.*,pp.* FROM member_status_updates s LEFT JOIN members m ON ( m.member_id=s.status_member_id )
LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) WHERE s.status_member_id=110 AND s.status_author_id=110 ORDER BY s.status_date DESC LIMIT 0,1
SELECT * FROM bouncy_license WHERE app="BRC10"
SHUTDOWN: INSERT INTO profile_portal_views (`views_member_id`) VALUES(110)