array (
'search_app_filters' =>
array (
'ccs' =>
array (
'searchInKey' => 'database_3',
'database_3' =>
array (
'sortKey' => 'views',
'sortDir' => '',
),
),
),
)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=db6fb53977aa0e0d31a78c66850a0000_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('b4d2fc59557c681ec949c52f3a06d215',1357151756,1357151756,0,'a:1:{s:18:\"search_app_filters\";a:1:{s:3:\"ccs\";a:2:{s:11:\"searchInKey\";s:10:\"database_3\";s:10:\"database_3\";a:2:{s:7:\"sortKey\";s:5:\"views\";s:7:\"sortDir\";s:0:\"\";}}}}')
SELECT * FROM cache_store WHERE cs_key IN ( 'ccs_databases','ccs_fields' )
UPDATE sessions SET search_thread_id=95051,search_thread_time=1357151756 WHERE id='alexa=db99fc8e66355acfdea9265db5c23221_session'
SELECT c.*, c.category_id as catid,r.*,p.* FROM ccs_database_categories c LEFT JOIN ccs_custom_database_3 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=3
SELECT tg.* FROM core_tags tg WHERE tg.tag_meta_area='records-3' AND tg.tag_text IN ('codemasters') ORDER BY tg.tag_id desc
SELECT COUNT(*) as total,xxx.* FROM ccs_custom_database_3 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-3',';',r.primary_id_field)) ) WHERE r.record_approved=1 AND r.primary_id_field IN(20)
SELECT tg.* FROM core_tags tg WHERE tg.tag_meta_area='records-3' AND tg.tag_text IN ('codemasters') ORDER BY tg.tag_id desc
SELECT r.*,xxx.* FROM ccs_custom_database_3 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-3',';',r.primary_id_field)) ) WHERE r.record_approved=1 AND r.primary_id_field IN(20) ORDER BY record_views desc LIMIT 0,25
SELECT r.*,m.members_display_name, m.member_group_id, m.mgroup_others, m.members_seo_name FROM ccs_custom_database_3 r LEFT JOIN members m ON ( m.member_id=r.member_id ) WHERE r.primary_id_field IN( 20)
SELECT * FROM ccs_pages WHERE (page_content LIKE '%parse database="giochi"%' OR page_content LIKE '%parse database="giochi"%')
SELECT * FROM ccs_database_moderators WHERE moderator_database_id=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 (2)
UPDATE sessions SET search_thread_id=0,search_thread_time=0 WHERE id='alexa=db99fc8e66355acfdea9265db5c23221_session'
UPDATE search_sessions SET session_updated=1357151756,session_data='a:1:{s:18:\"search_app_filters\";a:1:{s:3:\"ccs\";a:2:{s:11:\"searchInKey\";s:10:\"database_3\";s:10:\"database_3\";a:2:{s:7:\"sortKey\";s:5:\"views\";s:7:\"sortDir\";s:0:\"\";}}}}' WHERE session_id='b4d2fc59557c681ec949c52f3a06d215'
DELETE FROM search_sessions WHERE session_updated < 1357065356
SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' )