# Time: 160316 20:27:58 # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000005 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1458174478; # administrator command: Init DB; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000032 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1458174478; SET group_concat_max_len = 262144, sql_mode = ''; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000006 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1458174478; BEGIN /* DatabaseBase::query (Campaign::getCampaignSettings) Admin */; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000150 Lock_time: 0.000060 Rows_sent: 1 Rows_examined: 2 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* Campaign::getCampaignSettings Admin */ not_id,not_start,not_end,not_enabled,not_preferred,not_locked,not_archived,not_geo,not_buckets,not_throttle FROM `cn_notices` `notices` WHERE not_name = 'foo*test' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000054 Lock_time: 0.000018 Rows_sent: 1 Rows_examined: 2 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_id FROM `cn_notices` WHERE not_name = 'foo*test' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: Yes # Query_time: 0.000028 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 SET timestamp=1458174478; SELECT /* DatabaseBase::select Admin */ np_project FROM `cn_notice_projects` WHERE np_notice_id = '2'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: Yes # Query_time: 0.000008 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_id FROM `cn_notices` WHERE not_name = 'foo*test' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: Yes # Query_time: 0.000008 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 SET timestamp=1458174478; SELECT /* DatabaseBase::select Admin */ nl_language FROM `cn_notice_languages` WHERE nl_notice_id = '2'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: Yes # Query_time: 0.000007 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_id FROM `cn_notices` WHERE not_name = 'foo*test' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: Yes # Query_time: 0.000009 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1458174478; SELECT /* DatabaseBase::select Admin */ nc_country FROM `cn_notice_countries` WHERE nc_notice_id = '2'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000164 Lock_time: 0.000046 Rows_sent: 0 Rows_examined: 0 SET timestamp=1458174478; SELECT /* Banner::getCampaignBanners Admin */ tmp_name,tmp_weight,tmp_display_anon,tmp_display_account,tmp_category,not_name,not_preferred,asn_bucket,not_buckets,not_throttle,dev_name FROM `cn_notices` `notices`,`cn_templates` `templates`,`cn_known_devices` `known_devices`,`cn_assignments` `assignments` LEFT JOIN `cn_template_devices` `template_devices` ON ((template_devices.tmp_id = assignments.tmp_id)) WHERE notices.not_id = '2' AND (notices.not_id = assignments.not_id) AND (known_devices.dev_id = template_devices.dev_id) AND (assignments.tmp_id = templates.tmp_id); # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000172 Lock_time: 0.000038 Rows_sent: 0 Rows_examined: 18 # Full_scan: Yes Full_join: Yes Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* Campaign::getCampaignMixins Admin */ notice_mixins.nmxn_mixin_name,notice_mixins.nmxn_enabled,notice_mixin_params.nmxnp_param_name,notice_mixin_params.nmxnp_param_value FROM `cn_notices` `notices` INNER JOIN `cn_notice_mixins` `notice_mixins` ON ((notices.not_id = notice_mixins.nmxn_not_id)) LEFT OUTER JOIN `cn_notice_mixin_params` `notice_mixin_params` ON ((notice_mixins.nmxn_id = notice_mixin_params.nmxnp_notice_mixin_id)) WHERE notices.not_name = 'foo*test' AND notice_mixins.nmxn_enabled = '1'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000074 Lock_time: 0.000025 Rows_sent: 1 Rows_examined: 2 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_name FROM `cn_notices` WHERE not_name = 'foo*test' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000237 Lock_time: 0.000075 Rows_sent: 0 Rows_examined: 3 SET timestamp=1458174478; UPDATE /* DatabaseBase::update Admin */ `cn_notices` SET not_enabled = '1' WHERE not_name = 'foo*test'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000181 Lock_time: 0.000063 Rows_sent: 1 Rows_examined: 2 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* Campaign::getCampaignSettings Admin */ not_id,not_start,not_end,not_enabled,not_preferred,not_locked,not_archived,not_geo,not_buckets,not_throttle FROM `cn_notices` `notices` WHERE not_name = 'foo*test' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000120 Lock_time: 0.000039 Rows_sent: 1 Rows_examined: 2 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_id FROM `cn_notices` WHERE not_name = 'foo*test' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: Yes # Query_time: 0.000027 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 SET timestamp=1458174478; SELECT /* DatabaseBase::select Admin */ np_project FROM `cn_notice_projects` WHERE np_notice_id = '2'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000043 Lock_time: 0.000015 Rows_sent: 1 Rows_examined: 2 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_id FROM `cn_notices` WHERE not_name = 'foo*test' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: Yes # Query_time: 0.000007 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 SET timestamp=1458174478; SELECT /* DatabaseBase::select Admin */ nl_language FROM `cn_notice_languages` WHERE nl_notice_id = '2'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000038 Lock_time: 0.000013 Rows_sent: 1 Rows_examined: 2 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_id FROM `cn_notices` WHERE not_name = 'foo*test' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: Yes # Query_time: 0.000011 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1458174478; SELECT /* DatabaseBase::select Admin */ nc_country FROM `cn_notice_countries` WHERE nc_notice_id = '2'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000162 Lock_time: 0.000048 Rows_sent: 0 Rows_examined: 0 SET timestamp=1458174478; SELECT /* Banner::getCampaignBanners Admin */ tmp_name,tmp_weight,tmp_display_anon,tmp_display_account,tmp_category,not_name,not_preferred,asn_bucket,not_buckets,not_throttle,dev_name FROM `cn_notices` `notices`,`cn_templates` `templates`,`cn_known_devices` `known_devices`,`cn_assignments` `assignments` LEFT JOIN `cn_template_devices` `template_devices` ON ((template_devices.tmp_id = assignments.tmp_id)) WHERE notices.not_id = '2' AND (notices.not_id = assignments.not_id) AND (known_devices.dev_id = template_devices.dev_id) AND (assignments.tmp_id = templates.tmp_id); # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000490 Lock_time: 0.000127 Rows_sent: 0 Rows_examined: 18 # Full_scan: Yes Full_join: Yes Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* Campaign::getCampaignMixins Admin */ notice_mixins.nmxn_mixin_name,notice_mixins.nmxn_enabled,notice_mixin_params.nmxnp_param_name,notice_mixin_params.nmxnp_param_value FROM `cn_notices` `notices` INNER JOIN `cn_notice_mixins` `notice_mixins` ON ((notices.not_id = notice_mixins.nmxn_not_id)) LEFT OUTER JOIN `cn_notice_mixin_params` `notice_mixin_params` ON ((notice_mixins.nmxn_id = notice_mixin_params.nmxnp_notice_mixin_id)) WHERE notices.not_name = 'foo*test' AND notice_mixins.nmxn_enabled = '1'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000157 Lock_time: 0.000062 Rows_sent: 1 Rows_examined: 2 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_id FROM `cn_notices` WHERE not_name = 'foo*test' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000050 Lock_time: 0.000019 Rows_sent: 1 Rows_examined: 1 SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_name FROM `cn_notices` WHERE not_id = '2' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000283 Lock_time: 0.000180 Rows_sent: 1 Rows_examined: 1 # Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: Yes # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SHOW /* DatabaseBase::query Admin */ COLUMNS FROM `cn_notice_log` LIKE 'notlog_comment'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000125 Lock_time: 0.000050 Rows_sent: 0 Rows_examined: 0 SET timestamp=1458174478; INSERT /* DatabaseBase::insert Admin */ INTO `cn_notice_log` (notlog_timestamp,notlog_user_id,notlog_action,notlog_not_id,notlog_not_name,notlog_comment,notlog_begin_start,notlog_begin_end,notlog_begin_enabled,notlog_begin_preferred,notlog_begin_locked,notlog_begin_archived,notlog_begin_geo,notlog_begin_buckets,notlog_begin_throttle,notlog_begin_projects,notlog_begin_languages,notlog_begin_countries,notlog_begin_banners,notlog_begin_mixins,notlog_end_start,notlog_end_end,notlog_end_enabled,notlog_end_preferred,notlog_end_locked,notlog_end_archived,notlog_end_geo,notlog_end_buckets,notlog_end_throttle,notlog_end_projects,notlog_end_languages,notlog_end_countries,notlog_end_banners,notlog_end_mixins) VALUES ('20160317002758','1','modified','2','foo*test','','20150925013500','20150925023500','0','0','0','0','0','1','100','mw1','aa','','[]','[]','20150925013500','20150925023500','1','0','0','0','0','1','100','mw1','aa','','[]','[]'); # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000067 Lock_time: 0.000025 Rows_sent: 1 Rows_examined: 1 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* Campaign::getCampaignSettings Admin */ not_id,not_start,not_end,not_enabled,not_preferred,not_locked,not_archived,not_geo,not_buckets,not_throttle FROM `cn_notices` `notices` WHERE not_name = 'Test1' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000065 Lock_time: 0.000035 Rows_sent: 1 Rows_examined: 1 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_id FROM `cn_notices` WHERE not_name = 'Test1' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: Yes # Query_time: 0.000027 Lock_time: 0.000000 Rows_sent: 2 Rows_examined: 0 SET timestamp=1458174478; SELECT /* DatabaseBase::select Admin */ np_project FROM `cn_notice_projects` WHERE np_notice_id = '1'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000064 Lock_time: 0.000034 Rows_sent: 1 Rows_examined: 1 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_id FROM `cn_notices` WHERE not_name = 'Test1' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: Yes # Query_time: 0.000009 Lock_time: 0.000000 Rows_sent: 406 Rows_examined: 0 SET timestamp=1458174478; SELECT /* DatabaseBase::select Admin */ nl_language FROM `cn_notice_languages` WHERE nl_notice_id = '1'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000103 Lock_time: 0.000048 Rows_sent: 1 Rows_examined: 1 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_id FROM `cn_notices` WHERE not_name = 'Test1' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: Yes # Query_time: 0.000011 Lock_time: 0.000000 Rows_sent: 3 Rows_examined: 0 SET timestamp=1458174478; SELECT /* DatabaseBase::select Admin */ nc_country FROM `cn_notice_countries` WHERE nc_notice_id = '1'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000231 Lock_time: 0.000046 Rows_sent: 10 Rows_examined: 24 # Full_scan: Yes Full_join: Yes Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* Banner::getCampaignBanners Admin */ tmp_name,tmp_weight,tmp_display_anon,tmp_display_account,tmp_category,not_name,not_preferred,asn_bucket,not_buckets,not_throttle,dev_name FROM `cn_notices` `notices`,`cn_templates` `templates`,`cn_known_devices` `known_devices`,`cn_assignments` `assignments` LEFT JOIN `cn_template_devices` `template_devices` ON ((template_devices.tmp_id = assignments.tmp_id)) WHERE notices.not_id = '1' AND (notices.not_id = assignments.not_id) AND (known_devices.dev_id = template_devices.dev_id) AND (assignments.tmp_id = templates.tmp_id); # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000136 Lock_time: 0.000036 Rows_sent: 12 Rows_examined: 18 # Full_scan: Yes Full_join: Yes Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* Campaign::getCampaignMixins Admin */ notice_mixins.nmxn_mixin_name,notice_mixins.nmxn_enabled,notice_mixin_params.nmxnp_param_name,notice_mixin_params.nmxnp_param_value FROM `cn_notices` `notices` INNER JOIN `cn_notice_mixins` `notice_mixins` ON ((notices.not_id = notice_mixins.nmxn_not_id)) LEFT OUTER JOIN `cn_notice_mixin_params` `notice_mixin_params` ON ((notice_mixins.nmxn_id = notice_mixin_params.nmxnp_notice_mixin_id)) WHERE notices.not_name = 'Test1' AND notice_mixins.nmxn_enabled = '1'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000047 Lock_time: 0.000018 Rows_sent: 1 Rows_examined: 1 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_name FROM `cn_notices` WHERE not_name = 'Test1' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000057 Lock_time: 0.000020 Rows_sent: 0 Rows_examined: 3 SET timestamp=1458174478; UPDATE /* DatabaseBase::update Admin */ `cn_notices` SET not_enabled = '1' WHERE not_name = 'Test1'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000056 Lock_time: 0.000021 Rows_sent: 1 Rows_examined: 1 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* Campaign::getCampaignSettings Admin */ not_id,not_start,not_end,not_enabled,not_preferred,not_locked,not_archived,not_geo,not_buckets,not_throttle FROM `cn_notices` `notices` WHERE not_name = 'Test1' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000065 Lock_time: 0.000033 Rows_sent: 1 Rows_examined: 1 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_id FROM `cn_notices` WHERE not_name = 'Test1' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: Yes # Query_time: 0.000029 Lock_time: 0.000000 Rows_sent: 2 Rows_examined: 0 SET timestamp=1458174478; SELECT /* DatabaseBase::select Admin */ np_project FROM `cn_notice_projects` WHERE np_notice_id = '1'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000075 Lock_time: 0.000038 Rows_sent: 1 Rows_examined: 1 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_id FROM `cn_notices` WHERE not_name = 'Test1' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: Yes # Query_time: 0.000010 Lock_time: 0.000000 Rows_sent: 406 Rows_examined: 0 SET timestamp=1458174478; SELECT /* DatabaseBase::select Admin */ nl_language FROM `cn_notice_languages` WHERE nl_notice_id = '1'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000392 Lock_time: 0.000156 Rows_sent: 1 Rows_examined: 1 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_id FROM `cn_notices` WHERE not_name = 'Test1' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: Yes # Query_time: 0.000048 Lock_time: 0.000000 Rows_sent: 3 Rows_examined: 0 SET timestamp=1458174478; SELECT /* DatabaseBase::select Admin */ nc_country FROM `cn_notice_countries` WHERE nc_notice_id = '1'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000300 Lock_time: 0.000073 Rows_sent: 10 Rows_examined: 24 # Full_scan: Yes Full_join: Yes Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* Banner::getCampaignBanners Admin */ tmp_name,tmp_weight,tmp_display_anon,tmp_display_account,tmp_category,not_name,not_preferred,asn_bucket,not_buckets,not_throttle,dev_name FROM `cn_notices` `notices`,`cn_templates` `templates`,`cn_known_devices` `known_devices`,`cn_assignments` `assignments` LEFT JOIN `cn_template_devices` `template_devices` ON ((template_devices.tmp_id = assignments.tmp_id)) WHERE notices.not_id = '1' AND (notices.not_id = assignments.not_id) AND (known_devices.dev_id = template_devices.dev_id) AND (assignments.tmp_id = templates.tmp_id); # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000184 Lock_time: 0.000055 Rows_sent: 12 Rows_examined: 18 # Full_scan: Yes Full_join: Yes Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* Campaign::getCampaignMixins Admin */ notice_mixins.nmxn_mixin_name,notice_mixins.nmxn_enabled,notice_mixin_params.nmxnp_param_name,notice_mixin_params.nmxnp_param_value FROM `cn_notices` `notices` INNER JOIN `cn_notice_mixins` `notice_mixins` ON ((notices.not_id = notice_mixins.nmxn_not_id)) LEFT OUTER JOIN `cn_notice_mixin_params` `notice_mixin_params` ON ((notice_mixins.nmxn_id = notice_mixin_params.nmxnp_notice_mixin_id)) WHERE notices.not_name = 'Test1' AND notice_mixins.nmxn_enabled = '1'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000216 Lock_time: 0.000111 Rows_sent: 1 Rows_examined: 1 # Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_id FROM `cn_notices` WHERE not_name = 'Test1' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000170 Lock_time: 0.000071 Rows_sent: 1 Rows_examined: 1 SET timestamp=1458174478; SELECT /* DatabaseBase::selectRow Admin */ not_name FROM `cn_notices` WHERE not_id = '1' LIMIT 1; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000657 Lock_time: 0.000333 Rows_sent: 1 Rows_examined: 1 # Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: Yes # Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No SET timestamp=1458174478; SHOW /* DatabaseBase::query Admin */ COLUMNS FROM `cn_notice_log` LIKE 'notlog_comment'; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000406 Lock_time: 0.000157 Rows_sent: 0 Rows_examined: 0 SET timestamp=1458174478; INSERT /* DatabaseBase::insert Admin */ INTO `cn_notice_log` (notlog_timestamp,notlog_user_id,notlog_action,notlog_not_id,notlog_not_name,notlog_comment,notlog_begin_start,notlog_begin_end,notlog_begin_enabled,notlog_begin_preferred,notlog_begin_locked,notlog_begin_archived,notlog_begin_geo,notlog_begin_buckets,notlog_begin_throttle,notlog_begin_projects,notlog_begin_languages,notlog_begin_countries,notlog_begin_banners,notlog_begin_mixins,notlog_end_start,notlog_end_end,notlog_end_enabled,notlog_end_preferred,notlog_end_locked,notlog_end_archived,notlog_end_geo,notlog_end_buckets,notlog_end_throttle,notlog_end_projects,notlog_end_languages,notlog_end_countries,notlog_end_banners,notlog_end_mixins) VALUES ('20160317002758','1','modified','1','Test1','','20150302215300','20160519225300','0','3','0','0','1','4','100','mw1, mw2','aa, ab, ace, aeb, aeb-arab, aeb-latn, af, ak, aln, als, am, an, ang, anp, ar, arc, arn, arq, ary, arz, as, ast, av, avk, ay, az, azb, ba, bar, bat-smg, bbc, bbc-latn, bcc, bcl, be, be-tarask, be-x-old, bg, bgn, bh, bho, bi, bjn, bm, bn, bo, bpy, bqi, br, brh, bs, bto, bug, bxr, ca, cbk-zam, cdo, ce, ceb, ch, cho, chr, chy, ckb, co, cps, cr, crh, crh-cyrl, crh-latn, cs, csb, cu, cv, cy, da, de, de-at, de-ch, de-formal, diq, dsb, dtp, dv, dz, ee, egl, el, eml, en, en-ca, en-gb, eo, es, et, eu, ext, fa, ff, fi, fit, fiu-vro, fj, fo, fr, frc, frp, frr, fur, fy, ga, gag, gan, gan-hans, gan-hant, gd, gl, glk, gn, gom-latn, got, grc, gsw, gu, gv, ha, hak, haw, he, hi, hif, hif-latn, hil, ho, hr, hrx, hsb, ht, hu, hy, hz, ia, id, ie, ig, ii, ik, ike-cans, ike-latn, ilo, inh, io, is, it, iu, ja, jam, jbo, jut, jv, ka, kaa, kab, kbd, kbd-cyrl, kg, khw, ki, kiu, kj, kk, kk-arab, kk-cn, kk-cyrl, kk-kz, kk-latn, kk-tr, kl, km, kn, ko, ko-kp, koi, kr, krc, kri, krj, ks, ks-arab, ks-deva, ksh, ku, ku-arab, ku-latn, kv, kw, ky, la, lad, lb, lbe, lez, lfn, lg, li, lij, liv, lmo, ln, lo, loz, lrc, lt, ltg, lus, lv, lzh, lzz, mai, map-bms, mdf, mg, mh, mhr, mi, min, mk, ml, mn, mo, mr, mrj, ms, mt, mus, mwl, my, myv, mzn, na, nah, nan, nap, nb, nds, nds-nl, ne, new, ng, niu, nl, nl-informal, nn, no, nov, nrm, nso, nv, ny, oc, om, or, os, pa, pag, pam, pap, pcd, pdc, pdt, pfl, pi, pih, pl, pms, pnb, pnt, prg, ps, pt, pt-br, qu, qug, rgn, rif, rm, rmy, rn, ro, roa-rup, roa-tara, ru, rue, rup, ruq, ruq-cyrl, ruq-latn, rw, sa, sah, sat, sc, scn, sco, sd, sdc, se, sei, ses, sg, sgs, sh, shi, shi-latn, shi-tfng, si, simple, sk, sl, sli, sm, sma, sn, so, sq, sr, sr-ec, sr-el, srn, ss, st, stq, su, sv, sw, szl, ta, tcy, te, tet, tg, tg-cyrl, tg-latn, th, ti, tk, tl, tly, tn, to, tokipona, tpi, tr, tru, ts, tt, tt-cyrl, tt-latn, tum, tw, ty, tyv, tzm, udm, ug, ug-arab, ug-latn, uk, ur, uz, uz-cyrl, uz-latn, ve, vec, vep, vi, vls, vmf, vo, vot, vro, wa, war, wo, wuu, xal, xh, xmf, yi, yo, yue, za, zea, zh, zh-classical, zh-cn, zh-hans, zh-hant, zh-hk, zh-min-nan, zh-mo, zh-my, zh-sg, zh-tw, zh-yue, zu','CA, DZ, IT','{\"Banner_1\":{\"weight\":25,\"bucket\":0},\"Smallbanneree\":{\"weight\":25,\"bucket\":2},\"Banner_2\":{\"weight\":25,\"bucket\":1},\"Smallbanerieie\":{\"weight\":25,\"bucket\":3}}','{\"bannerHistoryLogger\":{\"maxEntries\":8,\"maxEntryAge\":2,\"rate\":1,\"waitLogNoSendBeacon\":300},\"legacySupport\":{\"bannersNotGuaranteedToDisplay\":true,\"setSRISampleRate\":true,\"sriSampleRate\":1}}','20150302215300','20160519225300','1','3','0','0','1','4','100','mw1, mw2','aa, ab, ace, aeb, aeb-arab, aeb-latn, af, ak, aln, als, am, an, ang, anp, ar, arc, arn, arq, ary, arz, as, ast, av, avk, ay, az, azb, ba, bar, bat-smg, bbc, bbc-latn, bcc, bcl, be, be-tarask, be-x-old, bg, bgn, bh, bho, bi, bjn, bm, bn, bo, bpy, bqi, br, brh, bs, bto, bug, bxr, ca, cbk-zam, cdo, ce, ceb, ch, cho, chr, chy, ckb, co, cps, cr, crh, crh-cyrl, crh-latn, cs, csb, cu, cv, cy, da, de, de-at, de-ch, de-formal, diq, dsb, dtp, dv, dz, ee, egl, el, eml, en, en-ca, en-gb, eo, es, et, eu, ext, fa, ff, fi, fit, fiu-vro, fj, fo, fr, frc, frp, frr, fur, fy, ga, gag, gan, gan-hans, gan-hant, gd, gl, glk, gn, gom-latn, got, grc, gsw, gu, gv, ha, hak, haw, he, hi, hif, hif-latn, hil, ho, hr, hrx, hsb, ht, hu, hy, hz, ia, id, ie, ig, ii, ik, ike-cans, ike-latn, ilo, inh, io, is, it, iu, ja, jam, jbo, jut, jv, ka, kaa, kab, kbd, kbd-cyrl, kg, khw, ki, kiu, kj, kk, kk-arab, kk-cn, kk-cyrl, kk-kz, kk-latn, kk-tr, kl, km, kn, ko, ko-kp, koi, kr, krc, kri, krj, ks, ks-arab, ks-deva, ksh, ku, ku-arab, ku-latn, kv, kw, ky, la, lad, lb, lbe, lez, lfn, lg, li, lij, liv, lmo, ln, lo, loz, lrc, lt, ltg, lus, lv, lzh, lzz, mai, map-bms, mdf, mg, mh, mhr, mi, min, mk, ml, mn, mo, mr, mrj, ms, mt, mus, mwl, my, myv, mzn, na, nah, nan, nap, nb, nds, nds-nl, ne, new, ng, niu, nl, nl-informal, nn, no, nov, nrm, nso, nv, ny, oc, om, or, os, pa, pag, pam, pap, pcd, pdc, pdt, pfl, pi, pih, pl, pms, pnb, pnt, prg, ps, pt, pt-br, qu, qug, rgn, rif, rm, rmy, rn, ro, roa-rup, roa-tara, ru, rue, rup, ruq, ruq-cyrl, ruq-latn, rw, sa, sah, sat, sc, scn, sco, sd, sdc, se, sei, ses, sg, sgs, sh, shi, shi-latn, shi-tfng, si, simple, sk, sl, sli, sm, sma, sn, so, sq, sr, sr-ec, sr-el, srn, ss, st, stq, su, sv, sw, szl, ta, tcy, te, tet, tg, tg-cyrl, tg-latn, th, ti, tk, tl, tly, tn, to, tokipona, tpi, tr, tru, ts, tt, tt-cyrl, tt-latn, tum, tw, ty, tyv, tzm, udm, ug, ug-arab, ug-latn, uk, ur, uz, uz-cyrl, uz-latn, ve, vec, vep, vi, vls, vmf, vo, vot, vro, wa, war, wo, wuu, xal, xh, xmf, yi, yo, yue, za, zea, zh, zh-classical, zh-cn, zh-hans, zh-hant, zh-hk, zh-min-nan, zh-mo, zh-my, zh-sg, zh-tw, zh-yue, zu','CA, DZ, IT','{\"Banner_1\":{\"weight\":25,\"bucket\":0},\"Smallbanneree\":{\"weight\":25,\"bucket\":2},\"Banner_2\":{\"weight\":25,\"bucket\":1},\"Smallbanerieie\":{\"weight\":25,\"bucket\":3}}','{\"bannerHistoryLogger\":{\"maxEntries\":8,\"maxEntryAge\":2,\"rate\":1,\"waitLogNoSendBeacon\":300},\"legacySupport\":{\"bannersNotGuaranteedToDisplay\":true,\"setSRISampleRate\":true,\"sriSampleRate\":1}}'); # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.008953 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1458174478; COMMIT /* MediaWiki::preOutputCommit Admin */; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000018 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1458174478; BEGIN /* DatabaseBase::query (JobQueueDB::doGetSiblingQueuesWithJobs) Admin */; # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: Yes # Query_time: 0.000038 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1458174478; SELECT /* JobQueueDB::doGetSiblingQueuesWithJobs Admin */ DISTINCT job_cmd FROM `job` WHERE job_cmd IN ('refreshLinks','deleteLinks','htmlCacheUpdate','sendMail','enotifNotify','fixDoubleRedirect','AssembleUploadChunks','PublishStashedFile','ThumbnailRender','recentChangesUpdate','refreshLinksPrioritized','refreshLinksDynamic','activityUpdateJob','categoryMembershipChange','cdnPurge','enqueue','null'); # User@Host: root[root] @ localhost [] # Thread_id: 60 Schema: mw1 QC_hit: No # Query_time: 0.000001 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 SET timestamp=1458174478; # administrator command: Quit;