array ( 'search_app_filters' => NULL, )
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=8e0fffb1eb9d8682172e80b9b94ea3ff_session'
DELETE FROM sessions WHERE id='alexa=8e0fffb1eb9d8682172e80b9b94ea3ff_session' OR ip_address='204.236.226.210' OR id='alexa=39b163daa0ea7b7ad16ca666bf8acdff_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('2abf02bb58f3a3a053f4bb610be72462',1357152226,1357152226,0,'a:1:{s:18:\"search_app_filters\";N;}')
SELECT * FROM cache_store WHERE cs_key IN ( 'ccs_databases','ccs_fields' )
UPDATE sessions SET search_thread_id=95074,search_thread_time=1357152226 WHERE id='alexa=39b163daa0ea7b7ad16ca666bf8acdff_session'
SELECT c.*, c.category_id as catid,r.*,p.* FROM ccs_database_categories c LEFT JOIN ccs_custom_database_1 r ON ( r.primary_id_field=c.category_last_record_id AND r.record_approved=1 ) LEFT JOIN permission_index p ON ( p.perm_type='categories' AND p.app='ccs' AND p.perm_type_id=c.category_id ) WHERE c.category_database_id=1
SELECT tg.* FROM core_tags tg WHERE tg.tag_meta_parent_id IN (1,18,25,2,6,10,14,3,4,7,8,11,12,15,16,31,36,41,42,32,33,37,38) AND tg.tag_meta_area='records-1' AND tg.tag_text IN ('codemasters') ORDER BY tg.tag_id desc
SELECT COUNT(*) as total,xxx.* FROM ccs_custom_database_1 r LEFT JOIN ccs_database_categories cat ON ( r.category_id=cat.category_id ) LEFT JOIN permission_index p ON ( p.app='ccs' AND p.perm_type='categories' AND p.perm_type_id=cat.category_id ) LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('ccs',';','records-1',';',r.primary_id_field)) ) WHERE r.category_id IN(1,18,25,2,6,10,14,3,4,7,8,11,12,15,16,31,36,41,42,32,33,37,38) AND (cat.category_has_perms=0 OR p.perm_view REGEXP ',2,|\\*') AND r.record_approved=1 AND r.primary_id_field=0
SELECT tg.* FROM core_tags tg WHERE tg.tag_meta_parent_id IN (1,18,25,2,6,10,14,3,4,7,8,11,12,15,16,31,36,41,42,32,33,37,38) AND tg.tag_meta_area='records-1' AND tg.tag_text IN ('codemasters') ORDER BY tg.tag_id desc
SELECT r.*,xxx.* FROM ccs_custom_database_1 r LEFT JOIN ccs_database_categories cat ON ( r.category_id=cat.category_id ) LEFT JOIN permission_index p ON ( p.app='ccs' AND p.perm_type='categories' AND p.perm_type_id=cat.category_id ) LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('ccs',';','records-1',';',r.primary_id_field)) ) WHERE r.category_id IN(1,18,25,2,6,10,14,3,4,7,8,11,12,15,16,31,36,41,42,32,33,37,38) AND (cat.category_has_perms=0 OR p.perm_view REGEXP ',2,|\\*') AND r.record_approved=1 AND r.primary_id_field=0 ORDER BY record_saved desc LIMIT 0,25
UPDATE sessions SET search_thread_id=0,search_thread_time=0 WHERE id='alexa=39b163daa0ea7b7ad16ca666bf8acdff_session'
UPDATE search_sessions SET session_updated=1357152226,session_data='a:1:{s:18:\"search_app_filters\";N;}' WHERE session_id='2abf02bb58f3a3a053f4bb610be72462'
DELETE FROM search_sessions WHERE session_updated < 1357065826
SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' )