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','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','emoticons','ranks','reputation_levels','sharelinks','nexus_ads','birthdays','chatting','support_departments' )

SELECT * FROM sessions WHERE id='alexa=a292722d1685b6b50c64f15730d45932_session'

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=5

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 * FROM topic_ratings WHERE rating_tid=5 and rating_member_id=0

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.steamid,pp.*,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 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.topic_id=5 AND p.queued=0 ORDER BY p.pid asc LIMIT 0,20

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='14'

INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('forums','pid',14,0,1357439182,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1357525582;}') 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 s.*, s.id as row_session_id,m.* FROM sessions s LEFT JOIN members m ON ( m.member_id=s.member_id ) WHERE s.id='alexa=b183ddd3787fff29df8835335628856b_session' OR (s.current_appcomponent='forums' AND s.running_time > 1357438282 AND s.in_error=0 AND s.location_1_type='topic' AND s.location_1_id=5)

SELECT * FROM core_like_cache WHERE like_cache_id='8b881bf431267cefc7612e856a0021f8'

SELECT COUNT(*) as nt FROM core_like WHERE like_lookup_id='8b881bf431267cefc7612e856a0021f8' AND like_is_anon=0 AND like_visible=1

SELECT COUNT(*) as nt FROM core_like WHERE like_lookup_id='8b881bf431267cefc7612e856a0021f8' AND like_is_anon!=0 AND like_visible=1

SELECT * FROM core_like WHERE like_lookup_id='8b881bf431267cefc7612e856a0021f8' AND like_is_anon=0 AND like_visible=1 ORDER BY like_added DESC LIMIT 0,5

INSERT INTO core_like_cache (`like_cache_id`,`like_cache_app`,`like_cache_area`,`like_cache_rel_id`,`like_cache_data`,`like_cache_expire`) VALUES('8b881bf431267cefc7612e856a0021f8','forums','topics',5,'a:3:{s:7:\"members\";N;s:5:\"count\";i:0;s:10:\"count_anon\";i:0;}',1357525582) ON DUPLICATE KEY UPDATE like_cache_id=VALUES(like_cache_id),like_cache_app=VALUES(like_cache_app),like_cache_area=VALUES(like_cache_area),like_cache_rel_id=VALUES(like_cache_rel_id),like_cache_data=VALUES(like_cache_data),like_cache_expire=VALUES(like_cache_expire)

SELECT * FROM core_editor_autosave WHERE eas_key='32adb6dad5abb54ac9d8159282f99223'

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

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

SELECT * FROM blog_this WHERE bt_app='forums' AND bt_id1=5