MEMBER: last_visit: / --

MEMBER: uagent_key: alexa

MEMBER: uagent_type: search

MEMBER: uagent_version: 0

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','attachtypes','nexus_ads','birthdays','chatting','support_departments' )

SELECT * FROM sessions WHERE id='alexa=5b5e8f2e586e4a9f757bd2cb3bdecfee_session'

DELETE FROM sessions WHERE id='alexa=5b5e8f2e586e4a9f757bd2cb3bdecfee_session' OR ip_address='204.236.226.210' OR id='alexa=3ac39f78a82f6db0a7e6907084b98ebc_session'

SELECT * FROM skin_cache WHERE cache_set_id=4 AND cache_type IN ('css', 'replacements')

INSERT INTO search_sessions (`session_id`,`session_created`,`session_updated`,`session_member_id`,`session_data`) VALUES('acee811f153b919d488e85a7f87e6baa',1357971345,1357971345,0,'a:1:{s:18:\"search_app_filters\";N;}')

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 )

UPDATE sessions SET search_thread_id=10742,search_thread_time=1357971345 WHERE id='alexa=3ac39f78a82f6db0a7e6907084b98ebc_session'

SELECT tg.* FROM core_tags tg WHERE tg.tag_meta_parent_id IN (2,4,6) AND tg.tag_meta_app='forums' AND tg.tag_meta_area='topics' AND tg.tag_text IN ('adsadasa') 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_id desc LIMIT 0,250

SELECT t.tid as id, t.tid as topic_id, t.title, t.posts, t.views, t.last_post,p.pid FROM topics t LEFT JOIN posts p ON ( p.pid=t.topic_firstpost ) WHERE t.tid IN (3) ORDER BY t.topic_firstpost desc LIMIT 0,201

SELECT t.*,p.*,m.member_id, m.members_display_name, m.members_seo_name,cca.*,ccb.cache_content as cache_content_sig, ccb.cache_updated as cache_updated_sig,xxx.* FROM topics t LEFT JOIN posts p ON ( p.pid=t.topic_firstpost ) LEFT JOIN members m ON ( m.member_id=p.author_id ) LEFT JOIN content_cache_posts cca ON ( cca.cache_content_id=p.pid ) LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=p.author_id ) LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE t.tid IN( 3)

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 (3)

SELECT author_id, topic_id FROM posts WHERE queued=0 AND author_id=0 AND topic_id IN(3)

UPDATE sessions SET search_thread_id=0,search_thread_time=0 WHERE id='alexa=3ac39f78a82f6db0a7e6907084b98ebc_session'

UPDATE search_sessions SET session_updated=1357971345,session_data='a:1:{s:18:\"search_app_filters\";N;}' WHERE session_id='acee811f153b919d488e85a7f87e6baa'

DELETE FROM search_sessions WHERE session_updated < 1357884945

SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' )