# Time: 160310 21:41:44
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000003  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000053  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
BEGIN /* DatabaseBase::query (Campaign::getAllCampaignNames) Admin */;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000111  Lock_time: 0.000046  Rows_sent: 3  Rows_examined: 3
# 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=1457664104;
SELECT /* Campaign::getAllCampaignNames Admin */  not_name  FROM `cn_notices`;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000088  Lock_time: 0.000032  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=1457664104;
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: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000056  Lock_time: 0.000020  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000073  Lock_time: 0.000019  Rows_sent: 2  Rows_examined: 2
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  np_project  FROM `cn_notice_projects`   WHERE np_notice_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000010  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000167  Lock_time: 0.000018  Rows_sent: 406  Rows_examined: 406
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  nl_language  FROM `cn_notice_languages`   WHERE nl_notice_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000016  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000111  Lock_time: 0.000033  Rows_sent: 3  Rows_examined: 3
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  nc_country  FROM `cn_notice_countries`   WHERE nc_notice_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000664  Lock_time: 0.000090  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=1457664104;
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: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000462  Lock_time: 0.000059  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=1457664104;
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: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000079  Lock_time: 0.000034  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=1457664104;
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: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000083  Lock_time: 0.000040  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000058  Lock_time: 0.000014  Rows_sent: 1  Rows_examined: 1
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  np_project  FROM `cn_notice_projects`   WHERE np_notice_id = '2';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000056  Lock_time: 0.000014  Rows_sent: 1  Rows_examined: 1
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  nl_language  FROM `cn_notice_languages`   WHERE nl_notice_id = '2';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000064  Lock_time: 0.000018  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  nc_country  FROM `cn_notice_countries`   WHERE nc_notice_id = '2';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000137  Lock_time: 0.000040  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
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: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000145  Lock_time: 0.000030  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=1457664104;
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: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000099  Lock_time: 0.000044  Rows_sent: 1  Rows_examined: 3
# 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=1457664104;
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 = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000088  Lock_time: 0.000042  Rows_sent: 1  Rows_examined: 3
# 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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000057  Lock_time: 0.000015  Rows_sent: 1  Rows_examined: 1
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  np_project  FROM `cn_notice_projects`   WHERE np_notice_id = '3';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000006  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000053  Lock_time: 0.000014  Rows_sent: 1  Rows_examined: 1
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  nl_language  FROM `cn_notice_languages`   WHERE nl_notice_id = '3';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000006  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000049  Lock_time: 0.000012  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  nc_country  FROM `cn_notice_countries`   WHERE nc_notice_id = '3';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000128  Lock_time: 0.000035  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
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 = '3' 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: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000121  Lock_time: 0.000027  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=1457664104;
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 = 'foot!test' AND notice_mixins.nmxn_enabled = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000007  Lock_time: 0.000000  Rows_sent: 3  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* Campaign::getAllCampaignNames Admin */  not_name  FROM `cn_notices`;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000046  Lock_time: 0.000014  Rows_sent: 1  Rows_examined: 3
# 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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000393  Lock_time: 0.000017  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664104;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_archived = '1' WHERE not_name = 'foot!test';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000047  Lock_time: 0.000016  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000232  Lock_time: 0.000085  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664104;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_archived = '0' WHERE not_name = 'Test1';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000170  Lock_time: 0.000056  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000059  Lock_time: 0.000027  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664104;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_archived = '0' WHERE not_name = 'foo*test';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000045  Lock_time: 0.000022  Rows_sent: 3  Rows_examined: 3
# 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=1457664104;
SELECT /* Campaign::getAllCampaignNames Admin */  not_name  FROM `cn_notices`;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000042  Lock_time: 0.000015  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000058  Lock_time: 0.000020  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664104;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_locked = '0' WHERE not_name = 'Test1';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000067  Lock_time: 0.000022  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000083  Lock_time: 0.000039  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664104;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_locked = '0' WHERE not_name = 'foo*test';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000078  Lock_time: 0.000034  Rows_sent: 1  Rows_examined: 3
# 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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000055  Lock_time: 0.000020  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664104;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_locked = '0' WHERE not_name = 'foot!test';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000052  Lock_time: 0.000022  Rows_sent: 3  Rows_examined: 3
# 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=1457664104;
SELECT /* Campaign::getAllCampaignNames Admin */  not_name  FROM `cn_notices`;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000112  Lock_time: 0.000061  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000050  Lock_time: 0.000017  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664104;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_enabled = '0' WHERE not_name = 'Test1';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000049  Lock_time: 0.000016  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000038  Lock_time: 0.000013  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664104;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_enabled = '0' WHERE not_name = 'foo*test';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000049  Lock_time: 0.000021  Rows_sent: 1  Rows_examined: 3
# 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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000038  Lock_time: 0.000014  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664104;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_enabled = '0' WHERE not_name = 'foot!test';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000044  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000036  Lock_time: 0.000013  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664104;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_preferred = '1' WHERE not_name = 'foo*test';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000043  Lock_time: 0.000015  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000036  Lock_time: 0.000012  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664104;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_preferred = '1' WHERE not_name = 'Test1';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000056  Lock_time: 0.000024  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=1457664104;
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: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000073  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000009  Lock_time: 0.000000  Rows_sent: 2  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  np_project  FROM `cn_notice_projects`   WHERE np_notice_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000200  Lock_time: 0.000088  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000026  Lock_time: 0.000000  Rows_sent: 406  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  nl_language  FROM `cn_notice_languages`   WHERE nl_notice_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000101  Lock_time: 0.000047  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000011  Lock_time: 0.000000  Rows_sent: 3  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  nc_country  FROM `cn_notice_countries`   WHERE nc_notice_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000287  Lock_time: 0.000059  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=1457664104;
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: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000163  Lock_time: 0.000051  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=1457664104;
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: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000071  Lock_time: 0.000034  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=1457664104;
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: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000051  Lock_time: 0.000023  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000010  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  np_project  FROM `cn_notice_projects`   WHERE np_notice_id = '2';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000049  Lock_time: 0.000022  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  nl_language  FROM `cn_notice_languages`   WHERE nl_notice_id = '2';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000048  Lock_time: 0.000020  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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000009  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  nc_country  FROM `cn_notice_countries`   WHERE nc_notice_id = '2';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000132  Lock_time: 0.000046  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
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: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000127  Lock_time: 0.000037  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=1457664104;
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: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000060  Lock_time: 0.000025  Rows_sent: 1  Rows_examined: 3
# 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=1457664104;
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 = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000048  Lock_time: 0.000020  Rows_sent: 1  Rows_examined: 3
# 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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  np_project  FROM `cn_notice_projects`   WHERE np_notice_id = '3';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000048  Lock_time: 0.000020  Rows_sent: 1  Rows_examined: 3
# 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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  nl_language  FROM `cn_notice_languages`   WHERE nl_notice_id = '3';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000048  Lock_time: 0.000020  Rows_sent: 1  Rows_examined: 3
# 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=1457664104;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: Yes
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* DatabaseBase::select Admin */  nc_country  FROM `cn_notice_countries`   WHERE nc_notice_id = '3';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000122  Lock_time: 0.000041  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
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 = '3' 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: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000122  Lock_time: 0.000035  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=1457664104;
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 = 'foot!test' AND notice_mixins.nmxn_enabled = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.001910  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
COMMIT /* MediaWiki::preOutputCommit Admin */;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000007  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;


BEGIN /* DatabaseBase::query (JobQueueDB::doGetSiblingQueuesWithJobs) Admin */;
# User@Host: root[root] @ localhost []
# Thread_id: 49  Schema: mw1  QC_hit: No
# Query_time: 0.000297  Lock_time: 0.000070  Rows_sent: 0  Rows_examined: 0
# 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=1457664104;
SELECT /* JobQueueDB::doGetSiblingQueuesWithJobs Admin */  DISTINCT job_cmd  FROM `job`   WHERE job_cmd IN ('refreshLinks','deleteLinks','htmlCacheUpdate','sendMail','enotifNotify','fixDoubleRedirect','uploadFromUrl','AssembleUploadChunks','PublishStashedFile','ThumbnailRender','recentChangesUpdate','refreshLinksPrioritized','refreshLinksDynamic','activityUpdateJob','categoryMembershipChange','cdnPurge','enqueue','null');
# User@Host: root[root] @ localhost []
# Thread_id: 50  Schema: mw1  QC_hit: No
# Query_time: 0.000004  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 50  Schema: mw1  QC_hit: No
# Query_time: 0.000027  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 50  Schema: mw1  QC_hit: No
# Query_time: 0.000010  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SET /* DatabaseBase::query Admin */ SESSION group_concat_max_len = 10000;
# User@Host: root[root] @ localhost []
# Thread_id: 50  Schema: mw1  QC_hit: No
# Query_time: 0.000006  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
BEGIN /* DatabaseBase::query (IndexPager::buildQueryInfo (CNCampaignPager)) Admin */;
# User@Host: root[root] @ localhost []
# Thread_id: 50  Schema: mw1  QC_hit: Yes
# Query_time: 0.000035  Lock_time: 0.000000  Rows_sent: 3  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* IndexPager::buildQueryInfo (CNCampaignPager) Admin */  notices.not_id,not_name,not_start,not_end,not_enabled,not_preferred,not_throttle,not_geo,not_locked,not_archived,(SELECT  GROUP_CONCAT(nc_country SEPARATOR ',')  FROM `cn_notice_countries`   WHERE nc_notice_id = notices.not_id  ) AS countries,(SELECT  GROUP_CONCAT(nl_language SEPARATOR ',')  FROM `cn_notice_languages`   WHERE nl_notice_id = notices.not_id  ) AS languages,(SELECT  GROUP_CONCAT(np_project SEPARATOR ',')  FROM `cn_notice_projects`   WHERE np_notice_id = notices.not_id  ) AS projects  FROM `cn_notices` `notices`    ORDER BY not_id DESC LIMIT 5001;
# User@Host: root[root] @ localhost []
# Thread_id: 50  Schema: mw1  QC_hit: Yes
# Query_time: 0.000024  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* LinkBatch::doQuery (for Skin::preloadExistence) Admin */  page_id,page_namespace,page_title,page_len,page_is_redirect,page_latest,page_content_model  FROM `page`   WHERE (page_namespace = '2' AND page_title = 'Admin') OR (page_namespace = '3' AND page_title = 'Admin');
# User@Host: root[root] @ localhost []
# Thread_id: 50  Schema: mw1  QC_hit: Yes
# Query_time: 0.000011  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* User::checkNewtalk Admin */  user_id  FROM `user_newtalk`   WHERE user_id = '1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 50  Schema: mw1  QC_hit: Yes
# Query_time: 0.000026  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* ResourceLoaderWikiModule::getTitleInfo Admin */  page_namespace,page_title,rev_len,rev_sha1  FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id))  WHERE (page_namespace = '8' AND page_title IN ('Group-bureaucrat.js','Group-bureaucrat.css','Group-sysop.js','Group-sysop.css','Group-user.js','Group-user.css','Group-autoconfirmed.js','Group-autoconfirmed.css') );
# User@Host: root[root] @ localhost []
# Thread_id: 50  Schema: mw1  QC_hit: Yes
# Query_time: 0.000025  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* ResourceLoaderWikiModule::getTitleInfo Admin */  page_namespace,page_title,rev_len,rev_sha1  FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id))  WHERE (page_namespace = '8' AND page_title IN ('Common.js','Vector.js','Common.css','Vector.css','Print.css') );
# User@Host: root[root] @ localhost []
# Thread_id: 50  Schema: mw1  QC_hit: Yes
# Query_time: 0.000040  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* ResourceLoaderWikiModule::getTitleInfo Admin */  page_namespace,page_title,rev_len,rev_sha1  FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id))  WHERE (page_namespace = '8' AND page_title = 'Noscript.css');
# User@Host: root[root] @ localhost []
# Thread_id: 50  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 51  Schema: mw1  QC_hit: No
# Query_time: 0.000005  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 51  Schema: mw1  QC_hit: No
# Query_time: 0.000034  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 51  Schema: mw1  QC_hit: No
# Query_time: 0.000009  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 51  Schema: mw1  QC_hit: No
# Query_time: 0.000193  Lock_time: 0.000062  Rows_sent: 5  Rows_examined: 5
SET timestamp=1457664104;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('mediawiki.legacy.commonPrint','mediawiki.legacy.shared','mediawiki.pager.tablePager','mediawiki.sectionAnchor','mediawiki.skinning.interface','skins.vector.styles')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 52  Schema: mw1  QC_hit: No
# Query_time: 0.000006  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 52  Schema: mw1  QC_hit: No
# Query_time: 0.000039  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 52  Schema: mw1  QC_hit: No
# Query_time: 0.000011  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 52  Schema: mw1  QC_hit: No
# Query_time: 0.000234  Lock_time: 0.000111  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module = 'startup' AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 52  Schema: mw1  QC_hit: No
# Query_time: 0.002250  Lock_time: 0.000399  Rows_sent: 29  Rows_examined: 29
# 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=1457664104;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('startup','site','noscript','filepage','user.groups','user','user.cssprefs','user.defaults','user.options','user.tokens','mediawiki.language.data','mediawiki.skinning.elements','mediawiki.skinning.content','mediawiki.skinning.interface','mediawiki.skinning.content.parsoid','mediawiki.skinning.content.externallinks','jquery','jquery.accessKeyLabel','jquery.appear','jquery.arrowSteps','jquery.async','jquery.autoEllipsis','jquery.badge','jquery.byteLength','jquery.byteLimit','jquery.checkboxShiftClick','jquery.chosen','jquery.client','jquery.color','jquery.colorUtil','jquery.confirmable','jquery.cookie','jquery.expandableField','jquery.farbtastic','jquery.footHovzer','jquery.form','jquery.fullscreen','jquery.getAttrs','jquery.hidpi','jquery.highlightText','jquery.hoverIntent','jquery.i18n','jquery.localize','jquery.makeCollapsible','jquery.mockjax','jquery.mw-jump','jquery.mwExtension','jquery.placeholder','jquery.qunit','jquery.qunit.completenessTest','jquery.spinner','jquery.jStorage','jquery.suggestions','jquery.tabIndex','jquery.tablesorter','jquery.textSelection','jquery.throttle-debounce','jquery.xmldom','jquery.tipsy','jquery.ui.core','jquery.ui.core.styles','jquery.ui.accordion','jquery.ui.autocomplete','jquery.ui.button','jquery.ui.datepicker','jquery.ui.dialog','jquery.ui.draggable','jquery.ui.droppable','jquery.ui.menu','jquery.ui.mouse','jquery.ui.position','jquery.ui.progressbar','jquery.ui.resizable','jquery.ui.selectable','jquery.ui.slider','jquery.ui.sortable','jquery.ui.spinner','jquery.ui.tabs','jquery.ui.tooltip','jquery.ui.widget','jquery.effects.core','jquery.effects.blind','jquery.effects.bounce','jquery.effects.clip','jquery.effects.drop','jquery.effects.explode','jquery.effects.fade','jquery.effects.fold','jquery.effects.highlight','jquery.effects.pulsate','jquery.effects.scale','jquery.effects.shake','jquery.effects.slide','jquery.effects.transfer','json','moment','mediawiki','mediawiki.apihelp','mediawiki.template','mediawiki.template.mustache','mediawiki.template.regexp','mediawiki.apipretty','mediawiki.api','mediawiki.api.category','mediawiki.api.edit','mediawiki.api.login','mediawiki.api.options','mediawiki.api.parse','mediawiki.api.upload','mediawiki.api.user','mediawiki.api.watch','mediawiki.api.messages','mediawiki.content.json','mediawiki.confirmCloseWindow','mediawiki.debug','mediawiki.debug.init','mediawiki.feedback','mediawiki.feedlink','mediawiki.filewarning','mediawiki.ForeignApi','mediawiki.ForeignApi.core','mediawiki.helplink','mediawiki.hidpi','mediawiki.hlist','mediawiki.htmlform','mediawiki.htmlform.styles','mediawiki.htmlform.ooui.styles','mediawiki.icon','mediawiki.inspect','mediawiki.messagePoster','mediawiki.messagePoster.wikitext','mediawiki.notification','mediawiki.notify','mediawiki.RegExp','mediawiki.pager.tablePager','mediawiki.searchSuggest','mediawiki.sectionAnchor','mediawiki.storage','mediawiki.Title','mediawiki.Upload','mediawiki.ForeignUpload','mediawiki.ForeignStructuredUpload','mediawiki.Upload.Dialog','mediawiki.Upload.BookletLayout','mediawiki.ForeignStructuredUpload.BookletLayout','mediawiki.toc','mediawiki.Uri','mediawiki.user','mediawiki.userSuggest','mediawiki.util','mediawiki.checkboxtoggle','mediawiki.checkboxtoggle.styles','mediawiki.cookie','mediawiki.toolbar','mediawiki.experiments','mediawiki.raggett','mediawiki.action.edit','mediawiki.action.edit.styles','mediawiki.action.edit.collapsibleFooter','mediawiki.action.edit.preview','mediawiki.action.edit.stash','mediawiki.action.history','mediawiki.action.history.diff','mediawiki.action.view.dblClickEdit','mediawiki.action.view.metadata','mediawiki.action.view.categoryPage.styles','mediawiki.action.view.postEdit','mediawiki.action.view.redirect','mediawiki.action.view.redirectPage','mediawiki.action.view.rightClickEdit','mediawiki.action.edit.editWarning','mediawiki.action.view.filepage','mediawiki.language','mediawiki.cldr','mediawiki.libs.pluralruleparser','mediawiki.language.init','mediawiki.jqueryMsg','mediawiki.language.months','mediawiki.language.names','mediawiki.language.specialCharacters','mediawiki.libs.jpegmeta','mediawiki.page.gallery','mediawiki.page.gallery.styles','mediawiki.page.ready','mediawiki.page.startup','mediawiki.page.patrol.ajax','mediawiki.page.watch.ajax','mediawiki.page.image.pagination','mediawiki.special','mediawiki.special.block','mediawiki.special.blocklist','mediawiki.special.changeslist','mediawiki.special.changeslist.legend','mediawiki.special.changeslist.legend.js','mediawiki.special.changeslist.enhanced','mediawiki.special.changeslist.visitedstatus','mediawiki.special.comparepages.styles','mediawiki.special.edittags','mediawiki.special.edittags.styles','mediawiki.special.import','mediawiki.special.movePage','mediawiki.special.movePage.styles','mediawiki.special.pageLanguage','mediawiki.special.pagesWithProp','mediawiki.special.preferences','mediawiki.special.preferences.styles','mediawiki.special.recentchanges','mediawiki.special.search','mediawiki.special.undelete','mediawiki.special.upload','mediawiki.special.userlogin.common.styles','mediawiki.special.userlogin.signup.styles','mediawiki.special.userlogin.login.styles','mediawiki.special.userlogin.signup.js','mediawiki.special.unwatchedPages','mediawiki.special.watchlist','mediawiki.special.version','mediawiki.legacy.config','mediawiki.legacy.commonPrint','mediawiki.legacy.protect','mediawiki.legacy.shared','mediawiki.legacy.oldshared','mediawiki.legacy.wikibits','mediawiki.ui','mediawiki.ui.checkbox','mediawiki.ui.radio','mediawiki.ui.anchor','mediawiki.ui.button','mediawiki.ui.input','mediawiki.ui.icon','mediawiki.ui.text','mediawiki.widgets','mediawiki.widgets.styles','mediawiki.widgets.DateInputWidget','mediawiki.widgets.datetime','mediawiki.widgets.CategorySelector','mediawiki.widgets.UserInputWidget','es5-shim','dom-level2-shim','oojs','oojs-ui','oojs-ui.styles','oojs-ui.styles.icons','oojs-ui.styles.indicators','oojs-ui.styles.textures','oojs-ui.styles.icons-accessibility','oojs-ui.styles.icons-alerts','oojs-ui.styles.icons-content','oojs-ui.styles.icons-editing-advanced','oojs-ui.styles.icons-editing-core','oojs-ui.styles.icons-editing-list','oojs-ui.styles.icons-editing-styling','oojs-ui.styles.icons-interactions','oojs-ui.styles.icons-layout','oojs-ui.styles.icons-location','oojs-ui.styles.icons-media','oojs-ui.styles.icons-moderation','oojs-ui.styles.icons-movement','oojs-ui.styles.icons-user','oojs-ui.styles.icons-wikimedia','skins.vector.styles','skins.vector.styles.responsive','skins.vector.js','jquery.ui.multiselect','ext.centralNotice.adminUi','ext.centralNotice.adminUi.bannerManager','ext.centralNotice.adminUi.bannerEditor','ext.centralNotice.adminUi.campaignManager','ext.centralNotice.startUp','ext.centralNotice.geoIP','ext.centralNotice.choiceData','ext.centralNotice.display','ext.centralNotice.kvStore','ext.centralNotice.kvStoreMaintenance','ext.centralNotice.bannerHistoryLogger','ext.centralNotice.impressionDiet','ext.centralNotice.largeBannerLimit','ext.centralNotice.legacySupport','ext.centralNotice.bannerController','ext.centralNotice.bannerController.mobile','ext.centralNotice.bannerController.mobiledevice','ext.centralNotice.bannerChoiceData','ext.centralNotice.bannerController.lib','ext.eventLogging','ext.eventLogging.subscriber','ext.eventLogging.jsonSchema','schema.CentralNoticeBannerHistory','test.sinonjs','test.mediawiki.qunit.testrunner','test.mediawiki.qunit.suites','ext.eventLogging.tests','ext.centralNotice.testFixtures','ext.centralNotice.geoIP.tests','ext.centralNotice.display.tests')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 52  Schema: mw1  QC_hit: No
# Query_time: 0.000220  Lock_time: 0.000073  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* ResourceLoaderWikiModule::getTitleInfo  */  page_namespace,page_title,rev_len,rev_sha1  FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id))  WHERE (page_namespace = '8' AND page_title IN ('Common.js','Vector.js','Common.css','Vector.css','Print.css') );
# User@Host: root[root] @ localhost []
# Thread_id: 52  Schema: mw1  QC_hit: No
# Query_time: 0.000107  Lock_time: 0.000043  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* ResourceLoaderWikiModule::getTitleInfo  */  page_namespace,page_title,rev_len,rev_sha1  FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id))  WHERE (page_namespace = '8' AND page_title = 'Noscript.css');
# User@Host: root[root] @ localhost []
# Thread_id: 52  Schema: mw1  QC_hit: No
# Query_time: 0.000095  Lock_time: 0.000037  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* ResourceLoaderWikiModule::getTitleInfo  */  page_namespace,page_title,rev_len,rev_sha1  FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id))  WHERE (page_namespace = '8' AND page_title = 'Filepage.css');
# User@Host: root[root] @ localhost []
# Thread_id: 51  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 5  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 52  Schema: mw1  QC_hit: No
# Query_time: 0.000347  Lock_time: 0.000106  Rows_sent: 0  Rows_examined: 3
# 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=1457664104;
SELECT /* ChoiceDataProvider::getChoices  */  notices.not_id,notices.not_name,notices.not_start,notices.not_end,notices.not_preferred,notices.not_throttle,notices.not_geo,notices.not_buckets,assignments.tmp_weight,assignments.asn_bucket,templates.tmp_id,templates.tmp_name,templates.tmp_display_anon,templates.tmp_display_account,templates.tmp_category  FROM `cn_notices` `notices` INNER JOIN `cn_assignments` `assignments` ON ((notices.not_id = assignments.not_id)) INNER JOIN `cn_templates` `templates` ON ((assignments.tmp_id = templates.tmp_id)) INNER JOIN `cn_notice_projects` `notice_projects` ON ((notices.not_id = notice_projects.np_notice_id)) INNER JOIN `cn_notice_languages` `notice_languages` ON ((notices.not_id = notice_languages.nl_notice_id))  WHERE (notices.not_start <= '20160311024144') AND (notices.not_end >= '20160311024144') AND notices.not_enabled = '1' AND notices.not_archived = '0' AND notice_projects.np_project = 'mw1' AND notice_languages.nl_language = 'en';
# User@Host: root[root] @ localhost []
# Thread_id: 52  Schema: mw1  QC_hit: Yes
# Query_time: 0.000030  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* ChoiceDataProvider::getChoices  */  notices.not_id,notices.not_name,notices.not_start,notices.not_end,notices.not_preferred,notices.not_throttle,notices.not_geo,notices.not_buckets,assignments.tmp_weight,assignments.asn_bucket,templates.tmp_id,templates.tmp_name,templates.tmp_display_anon,templates.tmp_display_account,templates.tmp_category  FROM `cn_notices` `notices` INNER JOIN `cn_assignments` `assignments` ON ((notices.not_id = assignments.not_id)) INNER JOIN `cn_templates` `templates` ON ((assignments.tmp_id = templates.tmp_id)) INNER JOIN `cn_notice_projects` `notice_projects` ON ((notices.not_id = notice_projects.np_notice_id)) INNER JOIN `cn_notice_languages` `notice_languages` ON ((notices.not_id = notice_languages.nl_notice_id))  WHERE (notices.not_start <= '20160311024144') AND (notices.not_end >= '20160311024144') AND notices.not_enabled = '1' AND notices.not_archived = '0' AND notice_projects.np_project = 'mw1' AND notice_languages.nl_language = 'en';
# User@Host: root[root] @ localhost []
# Thread_id: 52  Schema: mw1  QC_hit: No
# Query_time: 0.000002  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 53  Schema: mw1  QC_hit: No
# Query_time: 0.000004  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 53  Schema: mw1  QC_hit: No
# Query_time: 0.000068  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 53  Schema: mw1  QC_hit: No
# Query_time: 0.000025  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 53  Schema: mw1  QC_hit: No
# Query_time: 0.000394  Lock_time: 0.000134  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('jquery','mediawiki')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 53  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 54  Schema: mw1  QC_hit: No
# Query_time: 0.000005  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 54  Schema: mw1  QC_hit: No
# Query_time: 0.000037  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 54  Schema: mw1  QC_hit: No
# Query_time: 0.000010  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 54  Schema: mw1  QC_hit: No
# Query_time: 0.000260  Lock_time: 0.000084  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('jquery.accessKeyLabel','jquery.client','mediawiki.RegExp','mediawiki.notify','mediawiki.util','mediawiki.legacy.wikibits')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 54  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 55  Schema: mw1  QC_hit: No
# Query_time: 0.000024  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 55  Schema: mw1  QC_hit: No
# Query_time: 0.000126  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 55  Schema: mw1  QC_hit: No
# Query_time: 0.000013  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 55  Schema: mw1  QC_hit: No
# Query_time: 0.000312  Lock_time: 0.000099  Rows_sent: 0  Rows_examined: 29
# 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=1457664104;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('ext.centralNotice.bannerController','ext.centralNotice.choiceData','ext.centralNotice.geoIP','ext.centralNotice.kvStoreMaintenance','ext.centralNotice.startUp','jquery.cookie','jquery.tabIndex','jquery.throttle-debounce','mediawiki.page.startup','skins.vector.js')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 55  Schema: mw1  QC_hit: Yes
# Query_time: 0.000035  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* ChoiceDataProvider::getChoices  */  notices.not_id,notices.not_name,notices.not_start,notices.not_end,notices.not_preferred,notices.not_throttle,notices.not_geo,notices.not_buckets,assignments.tmp_weight,assignments.asn_bucket,templates.tmp_id,templates.tmp_name,templates.tmp_display_anon,templates.tmp_display_account,templates.tmp_category  FROM `cn_notices` `notices` INNER JOIN `cn_assignments` `assignments` ON ((notices.not_id = assignments.not_id)) INNER JOIN `cn_templates` `templates` ON ((assignments.tmp_id = templates.tmp_id)) INNER JOIN `cn_notice_projects` `notice_projects` ON ((notices.not_id = notice_projects.np_notice_id)) INNER JOIN `cn_notice_languages` `notice_languages` ON ((notices.not_id = notice_languages.nl_notice_id))  WHERE (notices.not_start <= '20160311024144') AND (notices.not_end >= '20160311024144') AND notices.not_enabled = '1' AND notices.not_archived = '0' AND notice_projects.np_project = 'mw1' AND notice_languages.nl_language = 'en';
# User@Host: root[root] @ localhost []
# Thread_id: 55  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: No
# Query_time: 0.000005  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: No
# Query_time: 0.000031  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 57  Schema: mw1  QC_hit: No
# Query_time: 0.000004  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 57  Schema: mw1  QC_hit: No
# Query_time: 0.000023  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: No
# Query_time: 0.000009  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 57  Schema: mw1  QC_hit: No
# Query_time: 0.000007  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: No
# Query_time: 0.000363  Lock_time: 0.000102  Rows_sent: 1  Rows_examined: 29
# 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=1457664104;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('ext.centralNotice.adminUi','ext.centralNotice.adminUi.campaignManager','ext.eventLogging.subscriber','jquery.checkboxShiftClick','jquery.getAttrs','jquery.highlightText','jquery.makeCollapsible','jquery.mw-jump','jquery.placeholder','jquery.suggestions','jquery.ui.multiselect','mediawiki.api','mediawiki.cldr','mediawiki.cookie','mediawiki.jqueryMsg','mediawiki.language','mediawiki.searchSuggest','mediawiki.template','mediawiki.user','mediawiki.api.user','mediawiki.language.data','mediawiki.language.init','mediawiki.libs.pluralruleparser','mediawiki.page.ready','mediawiki.template.mustache','site','user.defaults')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 57  Schema: mw1  QC_hit: No
# Query_time: 0.000251  Lock_time: 0.000113  Rows_sent: 4  Rows_examined: 29
# 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=1457664104;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('jquery.ui.button','jquery.ui.core','jquery.ui.datepicker','jquery.ui.dialog','jquery.ui.draggable','jquery.ui.droppable','jquery.ui.mouse','jquery.ui.position','jquery.ui.resizable','jquery.ui.slider','jquery.ui.sortable','jquery.ui.widget','jquery.ui.core.styles')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 57  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 4  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: Yes
# Query_time: 0.000024  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* ResourceLoaderWikiModule::getTitleInfo  */  page_namespace,page_title,rev_len,rev_sha1  FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id))  WHERE (page_namespace = '8' AND page_title IN ('Common.js','Vector.js','Common.css','Vector.css','Print.css') );
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: No
# Query_time: 0.000202  Lock_time: 0.000077  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* LinkCache::addLinkObj  */  page_id,page_len,page_is_redirect,page_latest,page_content_model  FROM `page`   WHERE page_namespace = '8' AND page_title = 'Common.js'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: No
# Query_time: 0.000343  Lock_time: 0.000121  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* Revision::fetchFromConds  */  rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name  FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user))  WHERE page_namespace = '8' AND page_title = 'Common.js' AND (rev_id=page_latest)  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: No
# Query_time: 0.000140  Lock_time: 0.000048  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* LinkCache::addLinkObj  */  page_id,page_len,page_is_redirect,page_latest,page_content_model  FROM `page`   WHERE page_namespace = '8' AND page_title = 'Vector.js'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: No
# Query_time: 0.000172  Lock_time: 0.000060  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* Revision::fetchFromConds  */  rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name  FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user))  WHERE page_namespace = '8' AND page_title = 'Vector.js' AND (rev_id=page_latest)  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: No
# Query_time: 0.000082  Lock_time: 0.000031  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* LinkCache::addLinkObj  */  page_id,page_len,page_is_redirect,page_latest,page_content_model  FROM `page`   WHERE page_namespace = '8' AND page_title = 'Common.css'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: No
# Query_time: 0.000153  Lock_time: 0.000052  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* Revision::fetchFromConds  */  rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name  FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user))  WHERE page_namespace = '8' AND page_title = 'Common.css' AND (rev_id=page_latest)  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: No
# Query_time: 0.000084  Lock_time: 0.000034  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* LinkCache::addLinkObj  */  page_id,page_len,page_is_redirect,page_latest,page_content_model  FROM `page`   WHERE page_namespace = '8' AND page_title = 'Vector.css'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: No
# Query_time: 0.000166  Lock_time: 0.000057  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* Revision::fetchFromConds  */  rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name  FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user))  WHERE page_namespace = '8' AND page_title = 'Vector.css' AND (rev_id=page_latest)  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: No
# Query_time: 0.000087  Lock_time: 0.000032  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* LinkCache::addLinkObj  */  page_id,page_len,page_is_redirect,page_latest,page_content_model  FROM `page`   WHERE page_namespace = '8' AND page_title = 'Print.css'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: No
# Query_time: 0.000154  Lock_time: 0.000052  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* Revision::fetchFromConds  */  rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name  FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user))  WHERE page_namespace = '8' AND page_title = 'Print.css' AND (rev_id=page_latest)  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 56  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 58  Schema: mw1  QC_hit: No
# Query_time: 0.000006  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 58  Schema: mw1  QC_hit: No
# Query_time: 0.000036  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 58  Schema: mw1  QC_hit: No
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664104;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 58  Schema: mw1  QC_hit: Yes
# Query_time: 0.000034  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664104;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('jquery.tablesorter','mediawiki.language.months')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 58  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664104;
# administrator command: Quit;


# Time: 160310 21:42:02
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000004  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000027  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000006  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
BEGIN /* DatabaseBase::query (Campaign::getAllCampaignNames) Admin */;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000030  Lock_time: 0.000000  Rows_sent: 3  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* Campaign::getAllCampaignNames Admin */  not_name  FROM `cn_notices`;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
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: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 2  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  np_project  FROM `cn_notice_projects`   WHERE np_notice_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000009  Lock_time: 0.000000  Rows_sent: 406  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  nl_language  FROM `cn_notice_languages`   WHERE nl_notice_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000012  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 3  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  nc_country  FROM `cn_notice_countries`   WHERE nc_notice_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000015  Lock_time: 0.000000  Rows_sent: 10  Rows_examined: 0
SET timestamp=1457664122;
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: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000020  Lock_time: 0.000000  Rows_sent: 12  Rows_examined: 0
SET timestamp=1457664122;
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: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000007  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
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: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000004  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000005  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  np_project  FROM `cn_notice_projects`   WHERE np_notice_id = '2';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000004  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000005  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  nl_language  FROM `cn_notice_languages`   WHERE nl_notice_id = '2';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000025  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000021  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  nc_country  FROM `cn_notice_countries`   WHERE nc_notice_id = '2';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000014  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
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: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000009  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
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: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000007  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
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 = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000009  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000007  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  np_project  FROM `cn_notice_projects`   WHERE np_notice_id = '3';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000009  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  nl_language  FROM `cn_notice_languages`   WHERE nl_notice_id = '3';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000009  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000007  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  nc_country  FROM `cn_notice_countries`   WHERE nc_notice_id = '3';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000013  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
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 = '3' 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: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000011  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
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 = 'foot!test' AND notice_mixins.nmxn_enabled = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000009  Lock_time: 0.000000  Rows_sent: 3  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* Campaign::getAllCampaignNames Admin */  not_name  FROM `cn_notices`;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000399  Lock_time: 0.000151  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664122;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_archived = '1' WHERE not_name = 'foot!test';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000312  Lock_time: 0.000092  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000185  Lock_time: 0.000078  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664122;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_archived = '0' WHERE not_name = 'Test1';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000177  Lock_time: 0.000069  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000138  Lock_time: 0.000051  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664122;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_archived = '0' WHERE not_name = 'foo*test';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000144  Lock_time: 0.000078  Rows_sent: 3  Rows_examined: 3
# 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=1457664122;
SELECT /* Campaign::getAllCampaignNames Admin */  not_name  FROM `cn_notices`;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000145  Lock_time: 0.000060  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000126  Lock_time: 0.000051  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664122;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_locked = '0' WHERE not_name = 'Test1';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000129  Lock_time: 0.000054  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000121  Lock_time: 0.000052  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664122;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_locked = '0' WHERE not_name = 'foo*test';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000230  Lock_time: 0.000107  Rows_sent: 1  Rows_examined: 3
# 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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000120  Lock_time: 0.000043  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664122;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_locked = '0' WHERE not_name = 'foot!test';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000103  Lock_time: 0.000042  Rows_sent: 3  Rows_examined: 3
# 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=1457664122;
SELECT /* Campaign::getAllCampaignNames Admin */  not_name  FROM `cn_notices`;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000122  Lock_time: 0.000042  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000214  Lock_time: 0.000039  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664122;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_enabled = '1' WHERE not_name = 'foo*test';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000111  Lock_time: 0.000039  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000090  Lock_time: 0.000033  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664122;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_enabled = '1' WHERE not_name = 'Test1';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000101  Lock_time: 0.000035  Rows_sent: 1  Rows_examined: 3
# 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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000100  Lock_time: 0.000030  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664122;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_enabled = '0' WHERE not_name = 'foot!test';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000091  Lock_time: 0.000030  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000080  Lock_time: 0.000030  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664122;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_preferred = '1' WHERE not_name = 'foo*test';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000111  Lock_time: 0.000042  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000092  Lock_time: 0.000035  Rows_sent: 0  Rows_examined: 3
SET timestamp=1457664122;
UPDATE /* DatabaseBase::update Admin */  `cn_notices` SET not_preferred = '1' WHERE not_name = 'Test1';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000187  Lock_time: 0.000050  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=1457664122;
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: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000125  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000026  Lock_time: 0.000000  Rows_sent: 2  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  np_project  FROM `cn_notice_projects`   WHERE np_notice_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000139  Lock_time: 0.000054  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000032  Lock_time: 0.000000  Rows_sent: 406  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  nl_language  FROM `cn_notice_languages`   WHERE nl_notice_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000206  Lock_time: 0.000069  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000022  Lock_time: 0.000000  Rows_sent: 3  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  nc_country  FROM `cn_notice_countries`   WHERE nc_notice_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000555  Lock_time: 0.000112  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=1457664122;
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: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000422  Lock_time: 0.000119  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=1457664122;
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: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000144  Lock_time: 0.000059  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'Test1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000124  Lock_time: 0.000049  Rows_sent: 1  Rows_examined: 1
SET timestamp=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_id = '1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000532  Lock_time: 0.000336  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=1457664122;
SHOW /* DatabaseBase::query Admin */ COLUMNS FROM `cn_notice_log` LIKE 'notlog_comment';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.001921  Lock_time: 0.000117  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
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 ('20160311024202','1','modified','1','Test1','','20150302215300','20160519225300','0','1','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','1','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: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000182  Lock_time: 0.000069  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=1457664122;
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: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000110  Lock_time: 0.000041  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000025  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  np_project  FROM `cn_notice_projects`   WHERE np_notice_id = '2';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000131  Lock_time: 0.000048  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000012  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  nl_language  FROM `cn_notice_languages`   WHERE nl_notice_id = '2';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000069  Lock_time: 0.000022  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000015  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  nc_country  FROM `cn_notice_countries`   WHERE nc_notice_id = '2';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000273  Lock_time: 0.000081  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
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: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000233  Lock_time: 0.000050  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=1457664122;
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: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000084  Lock_time: 0.000030  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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foo*test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000075  Lock_time: 0.000029  Rows_sent: 1  Rows_examined: 1
SET timestamp=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_name  FROM `cn_notices`   WHERE not_id = '2'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000436  Lock_time: 0.000255  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=1457664122;
SHOW /* DatabaseBase::query Admin */ COLUMNS FROM `cn_notice_log` LIKE 'notlog_comment';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000182  Lock_time: 0.000055  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
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 ('20160311024202','1','modified','2','foo*test','','20150925013500','20150925023500','0','1','0','0','0','1','100','mw1','aa','','[]','[]','20150925013500','20150925023500','1','1','0','0','0','1','100','mw1','aa','','[]','[]');
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000089  Lock_time: 0.000045  Rows_sent: 1  Rows_examined: 3
# 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=1457664122;
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 = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000043  Lock_time: 0.000015  Rows_sent: 1  Rows_examined: 3
# 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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000007  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  np_project  FROM `cn_notice_projects`   WHERE np_notice_id = '3';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000058  Lock_time: 0.000021  Rows_sent: 1  Rows_examined: 3
# 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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000009  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  nl_language  FROM `cn_notice_languages`   WHERE nl_notice_id = '3';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000054  Lock_time: 0.000018  Rows_sent: 1  Rows_examined: 3
# 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=1457664122;
SELECT /* DatabaseBase::selectRow Admin */  not_id  FROM `cn_notices`   WHERE not_name = 'foot!test'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* DatabaseBase::select Admin */  nc_country  FROM `cn_notice_countries`   WHERE nc_notice_id = '3';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000142  Lock_time: 0.000042  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
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 = '3' 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: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000128  Lock_time: 0.000031  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=1457664122;
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 = 'foot!test' AND notice_mixins.nmxn_enabled = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.001700  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
COMMIT /* MediaWiki::preOutputCommit Admin */;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000016  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
BEGIN /* DatabaseBase::query (JobQueueDB::doGetSiblingQueuesWithJobs) Admin */;
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: Yes
# Query_time: 0.000036  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* JobQueueDB::doGetSiblingQueuesWithJobs Admin */  DISTINCT job_cmd  FROM `job`   WHERE job_cmd IN ('refreshLinks','deleteLinks','htmlCacheUpdate','sendMail','enotifNotify','fixDoubleRedirect','uploadFromUrl','AssembleUploadChunks','PublishStashedFile','ThumbnailRender','recentChangesUpdate','refreshLinksPrioritized','refreshLinksDynamic','activityUpdateJob','categoryMembershipChange','cdnPurge','enqueue','null');
# User@Host: root[root] @ localhost []
# Thread_id: 59  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 60  Schema: mw1  QC_hit: No
# Query_time: 0.000002  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 60  Schema: mw1  QC_hit: No
# Query_time: 0.000030  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 60  Schema: mw1  QC_hit: No
# Query_time: 0.000007  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SET /* DatabaseBase::query Admin */ SESSION group_concat_max_len = 10000;
# User@Host: root[root] @ localhost []
# Thread_id: 60  Schema: mw1  QC_hit: No
# Query_time: 0.000004  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
BEGIN /* DatabaseBase::query (IndexPager::buildQueryInfo (CNCampaignPager)) Admin */;
# User@Host: root[root] @ localhost []
# Thread_id: 60  Schema: mw1  QC_hit: No
# Query_time: 0.000403  Lock_time: 0.000085  Rows_sent: 3  Rows_examined: 418
# Full_scan: Yes  Full_join: No  Tmp_table: Yes  Tmp_table_on_disk: No
# Filesort: No  Filesort_on_disk: No  Merge_passes: 0  Priority_queue: No
SET timestamp=1457664122;
SELECT /* IndexPager::buildQueryInfo (CNCampaignPager) Admin */  notices.not_id,not_name,not_start,not_end,not_enabled,not_preferred,not_throttle,not_geo,not_locked,not_archived,(SELECT  GROUP_CONCAT(nc_country SEPARATOR ',')  FROM `cn_notice_countries`   WHERE nc_notice_id = notices.not_id  ) AS countries,(SELECT  GROUP_CONCAT(nl_language SEPARATOR ',')  FROM `cn_notice_languages`   WHERE nl_notice_id = notices.not_id  ) AS languages,(SELECT  GROUP_CONCAT(np_project SEPARATOR ',')  FROM `cn_notice_projects`   WHERE np_notice_id = notices.not_id  ) AS projects  FROM `cn_notices` `notices`    ORDER BY not_id DESC LIMIT 5001;
# User@Host: root[root] @ localhost []
# Thread_id: 60  Schema: mw1  QC_hit: Yes
# Query_time: 0.000027  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* LinkBatch::doQuery (for Skin::preloadExistence) Admin */  page_id,page_namespace,page_title,page_len,page_is_redirect,page_latest,page_content_model  FROM `page`   WHERE (page_namespace = '2' AND page_title = 'Admin') OR (page_namespace = '3' AND page_title = 'Admin');
# User@Host: root[root] @ localhost []
# Thread_id: 60  Schema: mw1  QC_hit: Yes
# Query_time: 0.000022  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* User::checkNewtalk Admin */  user_id  FROM `user_newtalk`   WHERE user_id = '1'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 60  Schema: mw1  QC_hit: Yes
# Query_time: 0.000024  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ResourceLoaderWikiModule::getTitleInfo Admin */  page_namespace,page_title,rev_len,rev_sha1  FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id))  WHERE (page_namespace = '8' AND page_title IN ('Group-bureaucrat.js','Group-bureaucrat.css','Group-sysop.js','Group-sysop.css','Group-user.js','Group-user.css','Group-autoconfirmed.js','Group-autoconfirmed.css') );
# User@Host: root[root] @ localhost []
# Thread_id: 60  Schema: mw1  QC_hit: Yes
# Query_time: 0.000060  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ResourceLoaderWikiModule::getTitleInfo Admin */  page_namespace,page_title,rev_len,rev_sha1  FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id))  WHERE (page_namespace = '8' AND page_title IN ('Common.js','Vector.js','Common.css','Vector.css','Print.css') );
# User@Host: root[root] @ localhost []
# Thread_id: 60  Schema: mw1  QC_hit: Yes
# Query_time: 0.000041  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ResourceLoaderWikiModule::getTitleInfo Admin */  page_namespace,page_title,rev_len,rev_sha1  FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id))  WHERE (page_namespace = '8' AND page_title = 'Noscript.css');
# User@Host: root[root] @ localhost []
# Thread_id: 60  Schema: mw1  QC_hit: No
# Query_time: 0.000004  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 61  Schema: mw1  QC_hit: No
# Query_time: 0.000005  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 61  Schema: mw1  QC_hit: No
# Query_time: 0.000031  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 61  Schema: mw1  QC_hit: No
# Query_time: 0.000007  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 61  Schema: mw1  QC_hit: Yes
# Query_time: 0.000034  Lock_time: 0.000000  Rows_sent: 5  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('mediawiki.legacy.commonPrint','mediawiki.legacy.shared','mediawiki.pager.tablePager','mediawiki.sectionAnchor','mediawiki.skinning.interface','skins.vector.styles')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 62  Schema: mw1  QC_hit: No
# Query_time: 0.000005  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 62  Schema: mw1  QC_hit: No
# Query_time: 0.000036  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 62  Schema: mw1  QC_hit: No
# Query_time: 0.000008  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 62  Schema: mw1  QC_hit: Yes
# Query_time: 0.000042  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module = 'startup' AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 62  Schema: mw1  QC_hit: Yes
# Query_time: 0.000051  Lock_time: 0.000000  Rows_sent: 29  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('startup','site','noscript','filepage','user.groups','user','user.cssprefs','user.defaults','user.options','user.tokens','mediawiki.language.data','mediawiki.skinning.elements','mediawiki.skinning.content','mediawiki.skinning.interface','mediawiki.skinning.content.parsoid','mediawiki.skinning.content.externallinks','jquery','jquery.accessKeyLabel','jquery.appear','jquery.arrowSteps','jquery.async','jquery.autoEllipsis','jquery.badge','jquery.byteLength','jquery.byteLimit','jquery.checkboxShiftClick','jquery.chosen','jquery.client','jquery.color','jquery.colorUtil','jquery.confirmable','jquery.cookie','jquery.expandableField','jquery.farbtastic','jquery.footHovzer','jquery.form','jquery.fullscreen','jquery.getAttrs','jquery.hidpi','jquery.highlightText','jquery.hoverIntent','jquery.i18n','jquery.localize','jquery.makeCollapsible','jquery.mockjax','jquery.mw-jump','jquery.mwExtension','jquery.placeholder','jquery.qunit','jquery.qunit.completenessTest','jquery.spinner','jquery.jStorage','jquery.suggestions','jquery.tabIndex','jquery.tablesorter','jquery.textSelection','jquery.throttle-debounce','jquery.xmldom','jquery.tipsy','jquery.ui.core','jquery.ui.core.styles','jquery.ui.accordion','jquery.ui.autocomplete','jquery.ui.button','jquery.ui.datepicker','jquery.ui.dialog','jquery.ui.draggable','jquery.ui.droppable','jquery.ui.menu','jquery.ui.mouse','jquery.ui.position','jquery.ui.progressbar','jquery.ui.resizable','jquery.ui.selectable','jquery.ui.slider','jquery.ui.sortable','jquery.ui.spinner','jquery.ui.tabs','jquery.ui.tooltip','jquery.ui.widget','jquery.effects.core','jquery.effects.blind','jquery.effects.bounce','jquery.effects.clip','jquery.effects.drop','jquery.effects.explode','jquery.effects.fade','jquery.effects.fold','jquery.effects.highlight','jquery.effects.pulsate','jquery.effects.scale','jquery.effects.shake','jquery.effects.slide','jquery.effects.transfer','json','moment','mediawiki','mediawiki.apihelp','mediawiki.template','mediawiki.template.mustache','mediawiki.template.regexp','mediawiki.apipretty','mediawiki.api','mediawiki.api.category','mediawiki.api.edit','mediawiki.api.login','mediawiki.api.options','mediawiki.api.parse','mediawiki.api.upload','mediawiki.api.user','mediawiki.api.watch','mediawiki.api.messages','mediawiki.content.json','mediawiki.confirmCloseWindow','mediawiki.debug','mediawiki.debug.init','mediawiki.feedback','mediawiki.feedlink','mediawiki.filewarning','mediawiki.ForeignApi','mediawiki.ForeignApi.core','mediawiki.helplink','mediawiki.hidpi','mediawiki.hlist','mediawiki.htmlform','mediawiki.htmlform.styles','mediawiki.htmlform.ooui.styles','mediawiki.icon','mediawiki.inspect','mediawiki.messagePoster','mediawiki.messagePoster.wikitext','mediawiki.notification','mediawiki.notify','mediawiki.RegExp','mediawiki.pager.tablePager','mediawiki.searchSuggest','mediawiki.sectionAnchor','mediawiki.storage','mediawiki.Title','mediawiki.Upload','mediawiki.ForeignUpload','mediawiki.ForeignStructuredUpload','mediawiki.Upload.Dialog','mediawiki.Upload.BookletLayout','mediawiki.ForeignStructuredUpload.BookletLayout','mediawiki.toc','mediawiki.Uri','mediawiki.user','mediawiki.userSuggest','mediawiki.util','mediawiki.checkboxtoggle','mediawiki.checkboxtoggle.styles','mediawiki.cookie','mediawiki.toolbar','mediawiki.experiments','mediawiki.raggett','mediawiki.action.edit','mediawiki.action.edit.styles','mediawiki.action.edit.collapsibleFooter','mediawiki.action.edit.preview','mediawiki.action.edit.stash','mediawiki.action.history','mediawiki.action.history.diff','mediawiki.action.view.dblClickEdit','mediawiki.action.view.metadata','mediawiki.action.view.categoryPage.styles','mediawiki.action.view.postEdit','mediawiki.action.view.redirect','mediawiki.action.view.redirectPage','mediawiki.action.view.rightClickEdit','mediawiki.action.edit.editWarning','mediawiki.action.view.filepage','mediawiki.language','mediawiki.cldr','mediawiki.libs.pluralruleparser','mediawiki.language.init','mediawiki.jqueryMsg','mediawiki.language.months','mediawiki.language.names','mediawiki.language.specialCharacters','mediawiki.libs.jpegmeta','mediawiki.page.gallery','mediawiki.page.gallery.styles','mediawiki.page.ready','mediawiki.page.startup','mediawiki.page.patrol.ajax','mediawiki.page.watch.ajax','mediawiki.page.image.pagination','mediawiki.special','mediawiki.special.block','mediawiki.special.blocklist','mediawiki.special.changeslist','mediawiki.special.changeslist.legend','mediawiki.special.changeslist.legend.js','mediawiki.special.changeslist.enhanced','mediawiki.special.changeslist.visitedstatus','mediawiki.special.comparepages.styles','mediawiki.special.edittags','mediawiki.special.edittags.styles','mediawiki.special.import','mediawiki.special.movePage','mediawiki.special.movePage.styles','mediawiki.special.pageLanguage','mediawiki.special.pagesWithProp','mediawiki.special.preferences','mediawiki.special.preferences.styles','mediawiki.special.recentchanges','mediawiki.special.search','mediawiki.special.undelete','mediawiki.special.upload','mediawiki.special.userlogin.common.styles','mediawiki.special.userlogin.signup.styles','mediawiki.special.userlogin.login.styles','mediawiki.special.userlogin.signup.js','mediawiki.special.unwatchedPages','mediawiki.special.watchlist','mediawiki.special.version','mediawiki.legacy.config','mediawiki.legacy.commonPrint','mediawiki.legacy.protect','mediawiki.legacy.shared','mediawiki.legacy.oldshared','mediawiki.legacy.wikibits','mediawiki.ui','mediawiki.ui.checkbox','mediawiki.ui.radio','mediawiki.ui.anchor','mediawiki.ui.button','mediawiki.ui.input','mediawiki.ui.icon','mediawiki.ui.text','mediawiki.widgets','mediawiki.widgets.styles','mediawiki.widgets.DateInputWidget','mediawiki.widgets.datetime','mediawiki.widgets.CategorySelector','mediawiki.widgets.UserInputWidget','es5-shim','dom-level2-shim','oojs','oojs-ui','oojs-ui.styles','oojs-ui.styles.icons','oojs-ui.styles.indicators','oojs-ui.styles.textures','oojs-ui.styles.icons-accessibility','oojs-ui.styles.icons-alerts','oojs-ui.styles.icons-content','oojs-ui.styles.icons-editing-advanced','oojs-ui.styles.icons-editing-core','oojs-ui.styles.icons-editing-list','oojs-ui.styles.icons-editing-styling','oojs-ui.styles.icons-interactions','oojs-ui.styles.icons-layout','oojs-ui.styles.icons-location','oojs-ui.styles.icons-media','oojs-ui.styles.icons-moderation','oojs-ui.styles.icons-movement','oojs-ui.styles.icons-user','oojs-ui.styles.icons-wikimedia','skins.vector.styles','skins.vector.styles.responsive','skins.vector.js','jquery.ui.multiselect','ext.centralNotice.adminUi','ext.centralNotice.adminUi.bannerManager','ext.centralNotice.adminUi.bannerEditor','ext.centralNotice.adminUi.campaignManager','ext.centralNotice.startUp','ext.centralNotice.geoIP','ext.centralNotice.choiceData','ext.centralNotice.display','ext.centralNotice.kvStore','ext.centralNotice.kvStoreMaintenance','ext.centralNotice.bannerHistoryLogger','ext.centralNotice.impressionDiet','ext.centralNotice.largeBannerLimit','ext.centralNotice.legacySupport','ext.centralNotice.bannerController','ext.centralNotice.bannerController.mobile','ext.centralNotice.bannerController.mobiledevice','ext.centralNotice.bannerChoiceData','ext.centralNotice.bannerController.lib','ext.eventLogging','ext.eventLogging.subscriber','ext.eventLogging.jsonSchema','schema.CentralNoticeBannerHistory','test.sinonjs','test.mediawiki.qunit.testrunner','test.mediawiki.qunit.suites','ext.eventLogging.tests','ext.centralNotice.testFixtures','ext.centralNotice.geoIP.tests','ext.centralNotice.display.tests')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 61  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 5  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 62  Schema: mw1  QC_hit: Yes
# Query_time: 0.000027  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ResourceLoaderWikiModule::getTitleInfo  */  page_namespace,page_title,rev_len,rev_sha1  FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id))  WHERE (page_namespace = '8' AND page_title IN ('Common.js','Vector.js','Common.css','Vector.css','Print.css') );
# User@Host: root[root] @ localhost []
# Thread_id: 62  Schema: mw1  QC_hit: Yes
# Query_time: 0.000012  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ResourceLoaderWikiModule::getTitleInfo  */  page_namespace,page_title,rev_len,rev_sha1  FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id))  WHERE (page_namespace = '8' AND page_title = 'Noscript.css');
# User@Host: root[root] @ localhost []
# Thread_id: 62  Schema: mw1  QC_hit: Yes
# Query_time: 0.000009  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ResourceLoaderWikiModule::getTitleInfo  */  page_namespace,page_title,rev_len,rev_sha1  FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id))  WHERE (page_namespace = '8' AND page_title = 'Filepage.css');
# User@Host: root[root] @ localhost []
# Thread_id: 62  Schema: mw1  QC_hit: No
# Query_time: 0.000362  Lock_time: 0.000097  Rows_sent: 4  Rows_examined: 9
# 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=1457664122;
SELECT /* ChoiceDataProvider::getChoices  */  notices.not_id,notices.not_name,notices.not_start,notices.not_end,notices.not_preferred,notices.not_throttle,notices.not_geo,notices.not_buckets,assignments.tmp_weight,assignments.asn_bucket,templates.tmp_id,templates.tmp_name,templates.tmp_display_anon,templates.tmp_display_account,templates.tmp_category  FROM `cn_notices` `notices` INNER JOIN `cn_assignments` `assignments` ON ((notices.not_id = assignments.not_id)) INNER JOIN `cn_templates` `templates` ON ((assignments.tmp_id = templates.tmp_id)) INNER JOIN `cn_notice_projects` `notice_projects` ON ((notices.not_id = notice_projects.np_notice_id)) INNER JOIN `cn_notice_languages` `notice_languages` ON ((notices.not_id = notice_languages.nl_notice_id))  WHERE (notices.not_start <= '20160311024202') AND (notices.not_end >= '20160311024202') AND notices.not_enabled = '1' AND notices.not_archived = '0' AND notice_projects.np_project = 'mw1' AND notice_languages.nl_language = 'en';
# User@Host: root[root] @ localhost []
# Thread_id: 62  Schema: mw1  QC_hit: No
# Query_time: 0.000120  Lock_time: 0.000045  Rows_sent: 3  Rows_examined: 3
SET timestamp=1457664122;
SELECT /* ChoiceDataProvider::getChoices  */  notices.not_id,notice_countries.nc_country  FROM `cn_notices` `notices` INNER JOIN `cn_notice_countries` `notice_countries` ON ((notices.not_id = notice_countries.nc_notice_id))  WHERE notices.not_geo = '1' AND notices.not_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 62  Schema: mw1  QC_hit: No
# Query_time: 0.000216  Lock_time: 0.000064  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=1457664122;
SELECT /* Campaign::getCampaignMixins  */  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: 62  Schema: mw1  QC_hit: No
# Query_time: 0.000761  Lock_time: 0.000096  Rows_sent: 10  Rows_examined: 5
# 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=1457664122;
SELECT /* ChoiceDataProvider::getChoices  */  template_devices.tmp_id,known_devices.dev_name  FROM `cn_template_devices` `template_devices` INNER JOIN `cn_known_devices` `known_devices` ON ((template_devices.dev_id = known_devices.dev_id))  WHERE template_devices.tmp_id IN ('1','2','4','3');
# User@Host: root[root] @ localhost []
# Thread_id: 62  Schema: mw1  QC_hit: Yes
# Query_time: 0.000029  Lock_time: 0.000000  Rows_sent: 4  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ChoiceDataProvider::getChoices  */  notices.not_id,notices.not_name,notices.not_start,notices.not_end,notices.not_preferred,notices.not_throttle,notices.not_geo,notices.not_buckets,assignments.tmp_weight,assignments.asn_bucket,templates.tmp_id,templates.tmp_name,templates.tmp_display_anon,templates.tmp_display_account,templates.tmp_category  FROM `cn_notices` `notices` INNER JOIN `cn_assignments` `assignments` ON ((notices.not_id = assignments.not_id)) INNER JOIN `cn_templates` `templates` ON ((assignments.tmp_id = templates.tmp_id)) INNER JOIN `cn_notice_projects` `notice_projects` ON ((notices.not_id = notice_projects.np_notice_id)) INNER JOIN `cn_notice_languages` `notice_languages` ON ((notices.not_id = notice_languages.nl_notice_id))  WHERE (notices.not_start <= '20160311024202') AND (notices.not_end >= '20160311024202') AND notices.not_enabled = '1' AND notices.not_archived = '0' AND notice_projects.np_project = 'mw1' AND notice_languages.nl_language = 'en';
# User@Host: root[root] @ localhost []
# Thread_id: 62  Schema: mw1  QC_hit: Yes
# Query_time: 0.000017  Lock_time: 0.000000  Rows_sent: 3  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ChoiceDataProvider::getChoices  */  notices.not_id,notice_countries.nc_country  FROM `cn_notices` `notices` INNER JOIN `cn_notice_countries` `notice_countries` ON ((notices.not_id = notice_countries.nc_notice_id))  WHERE notices.not_geo = '1' AND notices.not_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 62  Schema: mw1  QC_hit: Yes
# Query_time: 0.000018  Lock_time: 0.000000  Rows_sent: 12  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* Campaign::getCampaignMixins  */  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: 62  Schema: mw1  QC_hit: Yes
# Query_time: 0.000015  Lock_time: 0.000000  Rows_sent: 10  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ChoiceDataProvider::getChoices  */  template_devices.tmp_id,known_devices.dev_name  FROM `cn_template_devices` `template_devices` INNER JOIN `cn_known_devices` `known_devices` ON ((template_devices.dev_id = known_devices.dev_id))  WHERE template_devices.tmp_id IN ('1','2','4','3');
# User@Host: root[root] @ localhost []
# Thread_id: 62  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 10  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 63  Schema: mw1  QC_hit: No
# Query_time: 0.000004  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 63  Schema: mw1  QC_hit: No
# Query_time: 0.000033  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 63  Schema: mw1  QC_hit: No
# Query_time: 0.000007  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 63  Schema: mw1  QC_hit: Yes
# Query_time: 0.000031  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('jquery','mediawiki')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 63  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 64  Schema: mw1  QC_hit: No
# Query_time: 0.000005  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 64  Schema: mw1  QC_hit: No
# Query_time: 0.000034  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 64  Schema: mw1  QC_hit: No
# Query_time: 0.000007  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 64  Schema: mw1  QC_hit: Yes
# Query_time: 0.000040  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('jquery.accessKeyLabel','jquery.client','mediawiki.RegExp','mediawiki.notify','mediawiki.util','mediawiki.legacy.wikibits')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 65  Schema: mw1  QC_hit: No
# Query_time: 0.000009  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 65  Schema: mw1  QC_hit: No
# Query_time: 0.000040  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 65  Schema: mw1  QC_hit: No
# Query_time: 0.000011  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 65  Schema: mw1  QC_hit: No
# Query_time: 0.000323  Lock_time: 0.000098  Rows_sent: 1  Rows_examined: 29
# 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=1457664122;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('ext.centralNotice.bannerController','ext.centralNotice.bannerHistoryLogger','ext.centralNotice.choiceData','ext.centralNotice.display','ext.centralNotice.geoIP','ext.centralNotice.kvStore','ext.centralNotice.kvStoreMaintenance','ext.centralNotice.legacySupport','ext.centralNotice.startUp','jquery.cookie','jquery.tabIndex','jquery.throttle-debounce','mediawiki.Uri','mediawiki.template','mediawiki.page.startup','mediawiki.template.regexp','skins.vector.js')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 65  Schema: mw1  QC_hit: Yes
# Query_time: 0.000028  Lock_time: 0.000000  Rows_sent: 4  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ChoiceDataProvider::getChoices  */  notices.not_id,notices.not_name,notices.not_start,notices.not_end,notices.not_preferred,notices.not_throttle,notices.not_geo,notices.not_buckets,assignments.tmp_weight,assignments.asn_bucket,templates.tmp_id,templates.tmp_name,templates.tmp_display_anon,templates.tmp_display_account,templates.tmp_category  FROM `cn_notices` `notices` INNER JOIN `cn_assignments` `assignments` ON ((notices.not_id = assignments.not_id)) INNER JOIN `cn_templates` `templates` ON ((assignments.tmp_id = templates.tmp_id)) INNER JOIN `cn_notice_projects` `notice_projects` ON ((notices.not_id = notice_projects.np_notice_id)) INNER JOIN `cn_notice_languages` `notice_languages` ON ((notices.not_id = notice_languages.nl_notice_id))  WHERE (notices.not_start <= '20160311024202') AND (notices.not_end >= '20160311024202') AND notices.not_enabled = '1' AND notices.not_archived = '0' AND notice_projects.np_project = 'mw1' AND notice_languages.nl_language = 'en';
# User@Host: root[root] @ localhost []
# Thread_id: 65  Schema: mw1  QC_hit: Yes
# Query_time: 0.000019  Lock_time: 0.000000  Rows_sent: 3  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ChoiceDataProvider::getChoices  */  notices.not_id,notice_countries.nc_country  FROM `cn_notices` `notices` INNER JOIN `cn_notice_countries` `notice_countries` ON ((notices.not_id = notice_countries.nc_notice_id))  WHERE notices.not_geo = '1' AND notices.not_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 65  Schema: mw1  QC_hit: Yes
# Query_time: 0.000026  Lock_time: 0.000000  Rows_sent: 12  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* Campaign::getCampaignMixins  */  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: 64  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 65  Schema: mw1  QC_hit: Yes
# Query_time: 0.000020  Lock_time: 0.000000  Rows_sent: 10  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ChoiceDataProvider::getChoices  */  template_devices.tmp_id,known_devices.dev_name  FROM `cn_template_devices` `template_devices` INNER JOIN `cn_known_devices` `known_devices` ON ((template_devices.dev_id = known_devices.dev_id))  WHERE template_devices.tmp_id IN ('1','2','4','3');
# User@Host: root[root] @ localhost []
# Thread_id: 66  Schema: mw1  QC_hit: No
# Query_time: 0.000006  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 66  Schema: mw1  QC_hit: No
# Query_time: 0.000036  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 66  Schema: mw1  QC_hit: No
# Query_time: 0.000038  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 66  Schema: mw1  QC_hit: Yes
# Query_time: 0.000167  Lock_time: 0.000000  Rows_sent: 4  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('jquery.ui.button','jquery.ui.core','jquery.ui.datepicker','jquery.ui.dialog','jquery.ui.draggable','jquery.ui.droppable','jquery.ui.mouse','jquery.ui.position','jquery.ui.resizable','jquery.ui.slider','jquery.ui.sortable','jquery.ui.widget','jquery.ui.core.styles')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 65  Schema: mw1  QC_hit: Yes
# Query_time: 0.000049  Lock_time: 0.000000  Rows_sent: 4  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ChoiceDataProvider::getChoices  */  notices.not_id,notices.not_name,notices.not_start,notices.not_end,notices.not_preferred,notices.not_throttle,notices.not_geo,notices.not_buckets,assignments.tmp_weight,assignments.asn_bucket,templates.tmp_id,templates.tmp_name,templates.tmp_display_anon,templates.tmp_display_account,templates.tmp_category  FROM `cn_notices` `notices` INNER JOIN `cn_assignments` `assignments` ON ((notices.not_id = assignments.not_id)) INNER JOIN `cn_templates` `templates` ON ((assignments.tmp_id = templates.tmp_id)) INNER JOIN `cn_notice_projects` `notice_projects` ON ((notices.not_id = notice_projects.np_notice_id)) INNER JOIN `cn_notice_languages` `notice_languages` ON ((notices.not_id = notice_languages.nl_notice_id))  WHERE (notices.not_start <= '20160311024202') AND (notices.not_end >= '20160311024202') AND notices.not_enabled = '1' AND notices.not_archived = '0' AND notice_projects.np_project = 'mw1' AND notice_languages.nl_language = 'en';
# User@Host: root[root] @ localhost []
# Thread_id: 65  Schema: mw1  QC_hit: Yes
# Query_time: 0.000045  Lock_time: 0.000000  Rows_sent: 3  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ChoiceDataProvider::getChoices  */  notices.not_id,notice_countries.nc_country  FROM `cn_notices` `notices` INNER JOIN `cn_notice_countries` `notice_countries` ON ((notices.not_id = notice_countries.nc_notice_id))  WHERE notices.not_geo = '1' AND notices.not_id = '1';
# User@Host: root[root] @ localhost []
# Thread_id: 65  Schema: mw1  QC_hit: Yes
# Query_time: 0.000045  Lock_time: 0.000000  Rows_sent: 12  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* Campaign::getCampaignMixins  */  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: 67  Schema: mw1  QC_hit: No
# Query_time: 0.000004  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 67  Schema: mw1  QC_hit: No
# Query_time: 0.000031  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 65  Schema: mw1  QC_hit: Yes
# Query_time: 0.000013  Lock_time: 0.000000  Rows_sent: 10  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ChoiceDataProvider::getChoices  */  template_devices.tmp_id,known_devices.dev_name  FROM `cn_template_devices` `template_devices` INNER JOIN `cn_known_devices` `known_devices` ON ((template_devices.dev_id = known_devices.dev_id))  WHERE template_devices.tmp_id IN ('1','2','4','3');
# User@Host: root[root] @ localhost []
# Thread_id: 67  Schema: mw1  QC_hit: No
# Query_time: 0.000032  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 67  Schema: mw1  QC_hit: No
# Query_time: 0.000876  Lock_time: 0.000335  Rows_sent: 1  Rows_examined: 29
# 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=1457664122;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('ext.centralNotice.adminUi','ext.centralNotice.adminUi.campaignManager','ext.eventLogging.subscriber','jquery.checkboxShiftClick','jquery.getAttrs','jquery.highlightText','jquery.makeCollapsible','jquery.mw-jump','jquery.placeholder','jquery.suggestions','jquery.ui.multiselect','mediawiki.api','mediawiki.cldr','mediawiki.cookie','mediawiki.jqueryMsg','mediawiki.language','mediawiki.searchSuggest','mediawiki.user','mediawiki.api.user','mediawiki.language.data','mediawiki.language.init','mediawiki.libs.pluralruleparser','mediawiki.page.ready','mediawiki.template.mustache','site','user.defaults')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 67  Schema: mw1  QC_hit: Yes
# Query_time: 0.000026  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ResourceLoaderWikiModule::getTitleInfo  */  page_namespace,page_title,rev_len,rev_sha1  FROM `page` INNER JOIN `revision` ON ((page_latest=rev_id))  WHERE (page_namespace = '8' AND page_title IN ('Common.js','Vector.js','Common.css','Vector.css','Print.css') );
# User@Host: root[root] @ localhost []
# Thread_id: 67  Schema: mw1  QC_hit: Yes
# Query_time: 0.000024  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* LinkCache::addLinkObj  */  page_id,page_len,page_is_redirect,page_latest,page_content_model  FROM `page`   WHERE page_namespace = '8' AND page_title = 'Common.js'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 67  Schema: mw1  QC_hit: Yes
# Query_time: 0.000018  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* Revision::fetchFromConds  */  rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name  FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user))  WHERE page_namespace = '8' AND page_title = 'Common.js' AND (rev_id=page_latest)  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 67  Schema: mw1  QC_hit: Yes
# Query_time: 0.000013  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* LinkCache::addLinkObj  */  page_id,page_len,page_is_redirect,page_latest,page_content_model  FROM `page`   WHERE page_namespace = '8' AND page_title = 'Vector.js'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 67  Schema: mw1  QC_hit: Yes
# Query_time: 0.000015  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* Revision::fetchFromConds  */  rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name  FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user))  WHERE page_namespace = '8' AND page_title = 'Vector.js' AND (rev_id=page_latest)  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 67  Schema: mw1  QC_hit: Yes
# Query_time: 0.000012  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* LinkCache::addLinkObj  */  page_id,page_len,page_is_redirect,page_latest,page_content_model  FROM `page`   WHERE page_namespace = '8' AND page_title = 'Common.css'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 67  Schema: mw1  QC_hit: Yes
# Query_time: 0.000031  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* Revision::fetchFromConds  */  rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name  FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user))  WHERE page_namespace = '8' AND page_title = 'Common.css' AND (rev_id=page_latest)  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 67  Schema: mw1  QC_hit: Yes
# Query_time: 0.000029  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* LinkCache::addLinkObj  */  page_id,page_len,page_is_redirect,page_latest,page_content_model  FROM `page`   WHERE page_namespace = '8' AND page_title = 'Vector.css'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 67  Schema: mw1  QC_hit: Yes
# Query_time: 0.000026  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* Revision::fetchFromConds  */  rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name  FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user))  WHERE page_namespace = '8' AND page_title = 'Vector.css' AND (rev_id=page_latest)  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 67  Schema: mw1  QC_hit: Yes
# Query_time: 0.000027  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* LinkCache::addLinkObj  */  page_id,page_len,page_is_redirect,page_latest,page_content_model  FROM `page`   WHERE page_namespace = '8' AND page_title = 'Print.css'  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 67  Schema: mw1  QC_hit: Yes
# Query_time: 0.000033  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* Revision::fetchFromConds  */  rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name  FROM `revision` INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user))  WHERE page_namespace = '8' AND page_title = 'Print.css' AND (rev_id=page_latest)  LIMIT 1;
# User@Host: root[root] @ localhost []
# Thread_id: 67  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 65  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 10  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Quit;
# User@Host: root[root] @ localhost []
# Thread_id: 68  Schema: mw1  QC_hit: No
# Query_time: 0.000005  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Init DB;
# User@Host: root[root] @ localhost []
# Thread_id: 68  Schema: mw1  QC_hit: No
# Query_time: 0.000039  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
SET group_concat_max_len = 262144, sql_mode = '';
# User@Host: root[root] @ localhost []
# Thread_id: 68  Schema: mw1  QC_hit: No
# Query_time: 0.000010  Lock_time: 0.000000  Rows_sent: 0  Rows_examined: 0
SET timestamp=1457664122;
BEGIN /* DatabaseBase::query (ResourceLoader::preloadModuleInfo)  */;
# User@Host: root[root] @ localhost []
# Thread_id: 68  Schema: mw1  QC_hit: Yes
# Query_time: 0.000034  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
SELECT /* ResourceLoader::preloadModuleInfo  */  md_module,md_deps  FROM `module_deps`   WHERE md_module IN ('jquery.tablesorter','mediawiki.language.months')  AND md_skin = 'vector|en';
# User@Host: root[root] @ localhost []
# Thread_id: 68  Schema: mw1  QC_hit: No
# Query_time: 0.000001  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
SET timestamp=1457664122;
# administrator command: Quit;