array (
'search_app_filters' =>
array (
'ccs' =>
array (
'searchInKey' => 'database_6',
'database_3' =>
array (
'sortKey' => 'date_added',
),
),
),
)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=038438ad5a657f0ade7ca4ee17dd1067_session'
SELECT * FROM skin_cache WHERE cache_set_id=4 AND cache_type IN ('css', 'replacements')
SELECT * FROM search_sessions WHERE session_id='6a6366cfc1889b56db94771854c17ccd' AND session_member_id=0
INSERT INTO search_sessions (`session_id`,`session_created`,`session_updated`,`session_member_id`,`session_data`) VALUES('5fa52cbafaf1ffd7891e9cdeb34edd47',1357151477,1357151477,0,'a:1:{s:18:\"search_app_filters\";a:1:{s:3:\"ccs\";a:2:{s:11:\"searchInKey\";s:10:\"database_6\";s:10:\"database_3\";a:1:{s:7:\"sortKey\";s:10:\"date_added\";}}}}')
SELECT * FROM cache_store WHERE cs_key IN ( 'ccs_databases','ccs_fields' )
UPDATE sessions SET search_thread_id=95037,search_thread_time=1357151477 WHERE id='alexa=d00a54fd13c62f7b0e902a156b74e7d2_session'
SELECT c.*, c.category_id as catid,r.*,p.* FROM ccs_database_categories c LEFT JOIN ccs_custom_database_6 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=6
SELECT tg.* FROM core_tags tg WHERE tg.tag_meta_area='records-6' AND tg.tag_text IN ('codemasters') ORDER BY tg.tag_id desc
SELECT COUNT(*) as total,xxx.* FROM ccs_custom_database_6 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-6',';',r.primary_id_field)) ) WHERE r.record_approved=1 AND r.primary_id_field=0
SELECT tg.* FROM core_tags tg WHERE tg.tag_meta_area='records-6' AND tg.tag_text IN ('codemasters') ORDER BY tg.tag_id desc
SELECT r.*,xxx.* FROM ccs_custom_database_6 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-6',';',r.primary_id_field)) ) WHERE 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=d00a54fd13c62f7b0e902a156b74e7d2_session'
UPDATE search_sessions SET session_updated=1357151477,session_data='a:1:{s:18:\"search_app_filters\";a:1:{s:3:\"ccs\";a:2:{s:11:\"searchInKey\";s:10:\"database_6\";s:10:\"database_3\";a:1:{s:7:\"sortKey\";s:10:\"date_added\";}}}}' WHERE session_id='5fa52cbafaf1ffd7891e9cdeb34edd47'
DELETE FROM search_sessions WHERE session_updated < 1357065077
SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' )