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','ccs_databases','ccs_fields','ccs_menu','report_cache','report_plugins','emoticons','ranks','attachtypes','reputation_levels','ccs_frontpage','moderators','sharelinks','nexus_ads','birthdays','chatting','support_departments' )
DELETE FROM sessions WHERE ip_address='204.236.226.210' OR id='alexa=6945d4f930a247ebcc9205605d8b5e20_session'
SELECT * FROM skin_cache WHERE cache_set_id=4 AND cache_type IN ('css', 'replacements')
SELECT cache_content FROM ccs_template_cache WHERE cache_type='full'
SELECT * FROM ccs_pages WHERE page_folder='' AND page_seo_name='index.php'
SELECT * FROM ccs_page_templates WHERE template_id=18
SELECT * FROM ccs_database_moderators WHERE moderator_database_id=1
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 r.*,c.*,xxx.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache FROM ccs_custom_database_1 r LEFT JOIN ccs_database_categories c ON ( c.category_id=r.category_id ) LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('ccs',';','records-1',';',r.primary_id_field)) ) LEFT JOIN reputation_index rep_index ON ( rep_index.app='ccs' AND rep_index.type='record_id_1' AND rep_index.type_id=r.primary_id_field AND rep_index.member_id=0 ) LEFT JOIN reputation_cache rep_cache ON ( rep_cache.app='ccs' AND rep_cache.type='record_id_1' AND rep_cache.type_id=r.primary_id_field ) WHERE r.record_approved IN(1) AND r.primary_id_field=2
SELECT * FROM ccs_page_templates WHERE template_id=19
SELECT * FROM ccs_custom_database_3 WHERE primary_id_field IN(6)
SELECT * FROM ccs_pages WHERE (page_content LIKE '%parse database="giochi"%' OR page_content LIKE '%parse database="giochi"%')
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 * FROM ccs_database_moderators WHERE moderator_database_id=3
SELECT * FROM ccs_custom_database_2 WHERE primary_id_field IN(4)
SELECT * FROM ccs_pages WHERE (page_content LIKE '%parse database="video"%' OR page_content LIKE '%parse database="video"%')
SELECT c.*, c.category_id as catid,r.*,p.* FROM ccs_database_categories c LEFT JOIN ccs_custom_database_2 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=2
SELECT * FROM ccs_pages WHERE page_content LIKE '%\{parse articles\}%'
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='ccs' AND r.type='record_id_1' AND r.type_id='2'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('ccs','record_id_1',2,1,1357309854,'a:2:{s:10:\"cache_data\";a:6:{s:3:\"app\";s:3:\"ccs\";s:4:\"type\";s:11:\"record_id_1\";s:2:\"id\";s:1:\"2\";s:5:\"count\";i:1;s:11:\"memberNames\";a:1:{i:3;a:2:{s:1:\"n\";s:7:\"Festano\";s:1:\"s\";s:7:\"festano\";}}s:9:\"memberIds\";a:1:{i:0;s:1:\"3\";}}s:12:\"cache_expire\";i:1357396254;}') 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 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=2
SELECT c.*,m.*,pc.*,pp.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache FROM ccs_database_comments c LEFT JOIN members m ON ( m.member_id=c.comment_user ) LEFT JOIN pfields_content pc ON ( pc.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN reputation_index rep_index ON ( rep_index.app='ccs' AND rep_index.type='comment_id' AND rep_index.type_id=c.comment_id AND rep_index.member_id=0 ) LEFT JOIN reputation_cache rep_cache ON ( rep_cache.app='ccs' AND rep_cache.type='comment_id' AND rep_cache.type_id=c.comment_id ) WHERE c.comment_record_id=2 AND c.comment_approved=1 AND c.comment_database_id=1 ORDER BY c.comment_date asc LIMIT 0,25
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='ccs' AND r.type='comment_id' AND r.type_id='2'
INSERT INTO reputation_cache (`app`,`type`,`type_id`,`rep_points`,`cache_date`,`rep_like_cache`) VALUES('ccs','comment_id',2,0,1357309854,'a:2:{s:10:\"cache_data\";a:0:{}s:12:\"cache_expire\";i:1357396254;}') 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 * FROM core_editor_autosave WHERE eas_key='08d9fcd61642fa46b16ed7998964326b'
SELECT revision_date, revision_member_id FROM ccs_database_revisions WHERE revision_database_id=1 AND revision_record_id=2 AND revision_member_id <> 2
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 (1,12)
SELECT * FROM core_like_cache WHERE like_cache_id='19674297892472fdf7771912238e85ef'
SELECT COUNT(*) as nt FROM core_like WHERE like_lookup_id='19674297892472fdf7771912238e85ef' AND like_is_anon=0 AND like_visible=1
SELECT COUNT(*) as nt FROM core_like WHERE like_lookup_id='19674297892472fdf7771912238e85ef' AND like_is_anon!=0 AND like_visible=1
SELECT * FROM core_like WHERE like_lookup_id='19674297892472fdf7771912238e85ef' AND like_is_anon=0 AND like_visible=1 ORDER BY like_added DESC LIMIT 0,5
SELECT m.*, m.member_id as my_member_id,ccb.cache_content FROM members m LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id IN (3)
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('19674297892472fdf7771912238e85ef','ccs','ccs_custom_database_1_records',2,'a:3:{s:7:\"members\";a:1:{i:3;a:2:{s:1:\"n\";s:7:\"Festano\";s:1:\"s\";s:7:\"festano\";}}s:5:\"count\";i:1;s:10:\"count_anon\";i:0;}',1357396254) 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 ccs_custom_database_2 WHERE primary_id_field IN(4)
SELECT * FROM core_like_cache WHERE like_cache_id='e03c4dc6620490ad1158130a58460b6b'
SELECT COUNT(*) as nt FROM core_like WHERE like_lookup_id='e03c4dc6620490ad1158130a58460b6b' AND like_is_anon=0 AND like_visible=1
SELECT COUNT(*) as nt FROM core_like WHERE like_lookup_id='e03c4dc6620490ad1158130a58460b6b' AND like_is_anon!=0 AND like_visible=1
SELECT * FROM core_like WHERE like_lookup_id='e03c4dc6620490ad1158130a58460b6b' 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('e03c4dc6620490ad1158130a58460b6b','ccs','ccs_custom_database_1_records',4,'a:3:{s:7:\"members\";N;s:5:\"count\";i:0;s:10:\"count_anon\";i:1;}',1357396254) 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 ccs_custom_database_3 WHERE primary_id_field IN(6)
SELECT * FROM core_like_cache WHERE like_cache_id='74eb0dd286437fe1bdf6407e6125f536'
SELECT COUNT(*) as nt FROM core_like WHERE like_lookup_id='74eb0dd286437fe1bdf6407e6125f536' AND like_is_anon=0 AND like_visible=1
SELECT COUNT(*) as nt FROM core_like WHERE like_lookup_id='74eb0dd286437fe1bdf6407e6125f536' AND like_is_anon!=0 AND like_visible=1
SELECT * FROM core_like WHERE like_lookup_id='74eb0dd286437fe1bdf6407e6125f536' 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('74eb0dd286437fe1bdf6407e6125f536','ccs','ccs_custom_database_1_records',6,'a:3:{s:7:\"members\";N;s:5:\"count\";i:0;s:10:\"count_anon\";i:0;}',1357396254) 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 nexus_ads WHERE ad_id=6
UPDATE nexus_ads SET ad_impressions=12279 WHERE ad_id=6
SELECT * FROM cache_store WHERE cs_key IN ( 'promenu' )
1 Commenti
Festano
01 nov 2012 01:20