yuanchengpasc/runtime/log/201811/23_cli.log

[ 2018-11-23T13:22:31+08:00 ][ info ] [ DB ] INIT mysql
[ info ] [ LOG ] INIT File
[ 2018-11-23T13:22:31+08:00 ][ sql ] [ DB ] CONNECT:[ UseTime:0.029211s ] mysql:host=47.104.6.21;port=3306;dbname=pacsonline;charset=utf8
[ 2018-11-23T13:22:31+08:00 ][ sql ] [ SQL ] CREATE TABLE if not exists `version` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `version` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; [ RunTime:0.212094s ]
[ 2018-11-23T13:22:31+08:00 ][ sql ] [ SQL ] SHOW COLUMNS FROM `version` [ RunTime:0.022169s ]
[ 2018-11-23T13:22:31+08:00 ][ sql ] [ SQL ] SELECT `version` FROM `version` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.017003s ]
[ 2018-11-23T13:22:31+08:00 ][ sql ] [ SQL ] INSERT INTO `version` (`id` , `version`) VALUES (1 , '1') [ RunTime:0.020878s ]
[ 2018-11-23T13:22:31+08:00 ][ info ] [ CACHE ] INIT File
[ 2018-11-23T13:22:31+08:00 ][ sql ] [ SQL ] UPDATE `version`  SET `version`='2'  WHERE  `id` = 1 [ RunTime:0.019120s ]
[ 2018-11-23T13:24:05+08:00 ][ info ] [ DB ] INIT mysql
[ info ] [ LOG ] INIT File
[ 2018-11-23T13:24:05+08:00 ][ sql ] [ DB ] CONNECT:[ UseTime:0.031827s ] mysql:host=47.104.6.21;port=3306;dbname=pacsonline;charset=utf8
[ 2018-11-23T13:24:05+08:00 ][ sql ] [ SQL ] CREATE TABLE if not exists `version` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `version` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; [ RunTime:0.020022s ]
[ 2018-11-23T13:24:05+08:00 ][ sql ] [ SQL ] SHOW COLUMNS FROM `version` [ RunTime:0.018273s ]
[ 2018-11-23T13:24:05+08:00 ][ sql ] [ SQL ] SELECT `version` FROM `version` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.016617s ]
[ 2018-11-23T14:46:11+08:00 ][ info ] [ DB ] INIT mysql
[ info ] [ LOG ] INIT File
[ 2018-11-23T14:46:11+08:00 ][ sql ] [ DB ] CONNECT:[ UseTime:0.003198s ] mysql:host=127.0.0.1;port=3306;dbname=pacsonline;charset=utf8
[ 2018-11-23T14:46:12+08:00 ][ sql ] [ SQL ] CREATE TABLE if not exists `version` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `version` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; [ RunTime:0.014711s ]
[ 2018-11-23T14:46:12+08:00 ][ sql ] [ SQL ] SHOW COLUMNS FROM `version` [ RunTime:0.001671s ]
[ 2018-11-23T14:46:12+08:00 ][ sql ] [ SQL ] SELECT `version` FROM `version` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.000587s ]
[ 2018-11-23T14:46:12+08:00 ][ sql ] [ SQL ] INSERT INTO `version` (`id` , `version`) VALUES (1 , '1') [ RunTime:0.002352s ]
[ 2018-11-23T14:50:42+08:00 ][ info ] [ DB ] INIT mysql
[ info ] [ LOG ] INIT File
[ 2018-11-23T14:50:42+08:00 ][ sql ] [ DB ] CONNECT:[ UseTime:0.002102s ] mysql:host=127.0.0.1;port=3306;dbname=pacsonline;charset=utf8
[ 2018-11-23T14:50:42+08:00 ][ sql ] [ SQL ] CREATE TABLE if not exists `version` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `version` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; [ RunTime:0.000625s ]
[ 2018-11-23T14:50:42+08:00 ][ sql ] [ SQL ] SHOW COLUMNS FROM `version` [ RunTime:0.001182s ]
[ 2018-11-23T14:50:42+08:00 ][ sql ] [ SQL ] SELECT `version` FROM `version` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.000661s ]
[ 2018-11-23T14:52:20+08:00 ][ info ] [ DB ] INIT mysql
[ info ] [ LOG ] INIT File
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ DB ] CONNECT:[ UseTime:0.002025s ] mysql:host=127.0.0.1;port=3306;dbname=pacsonline;charset=utf8
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] CREATE TABLE if not exists `version` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `version` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; [ RunTime:0.000448s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] SHOW COLUMNS FROM `version` [ RunTime:0.000863s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] SELECT `version` FROM `version` WHERE  `id` = 1 LIMIT 1 [ RunTime:0.000397s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] CREATE TABLE  if not exists `oss_callbacks`(
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `md5` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `region` varchar(255) NOT NULL,
  `bucket` varchar(255) NOT NULL,
  `size` int(11) NOT NULL,
  `hospital_id` varchar(255) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `remark` varchar(255) DEFAULT NULL,
  `x_real_ip` varchar(255) DEFAULT NULL,
  `x_forwarded_for_ip` varchar(255) DEFAULT NULL,
  `request_date` varchar(255) DEFAULT NULL,
  `x_oss_request_id` varchar(255) DEFAULT NULL,
  `x_oss_requester` varchar(255) DEFAULT NULL,
  `x_oss_pub_key_url` varchar(255) DEFAULT NULL,
  `authorization` varchar(255) DEFAULT NULL,
  `content_md5` varchar(255) DEFAULT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `md5_index` (`md5`),
  UNIQUE KEY `url_index` (`url`),
  KEY `oss_callbacks_hospital_id` (`hospital_id`),
  KEY `oss_callbacks_bucket` (`bucket`),
  KEY `oss_callbacks_status` (`status`),
  KEY `oss_callbacks_x_real_ip` (`x_real_ip`),
  KEY `oss_callbacks_region` (`region`),
  KEY `oss_callbacks_x_forwarded_for_ip` (`x_forwarded_for_ip`),
  KEY `oss_callbacks_x_oss_request_id` (`x_oss_request_id`),
  KEY `oss_callbacks_x_oss_requester` (`x_oss_requester`),
  KEY `oss_callbacks_authorization` (`authorization`),
  KEY `oss_callbacks_x_oss_pub_key_url` (`x_oss_pub_key_url`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 [ RunTime:0.031823s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `constant`  ADD  INDEX constant_value (  `constant_value`  ) [ RunTime:0.003346s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `doctors`  ADD  INDEX doc_username (  `username`  ) [ RunTime:0.007343s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `dr_cla_permission`  ADD  INDEX dr_pass (  `pass`  ) [ RunTime:0.097371s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `dr_cla_permission`  ADD  INDEX dr_type (  `type`  ) [ RunTime:0.022712s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `exams`  ADD  INDEX exam_report (  `exam_report`  ) [ RunTime:0.009256s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `exams`  ADD  INDEX exam_project (  `exam_project`  ) [ RunTime:0.008067s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `exams`  ADD  INDEX exam_device (  `device`  ) [ RunTime:0.009660s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `exams`  ADD  INDEX exam_body (  `body_part`  ) [ RunTime:0.007005s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `exams`  ADD  INDEX exams_exam_datetime (  `exam_datetime`  ) [ RunTime:0.010779s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `exams`  ADD  INDEX exams_exam_class (  `exam_class`  ) [ RunTime:0.010665s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `exams`  ADD  INDEX exams_exam_status (  `exam_status`  ) [ RunTime:0.007958s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `exams`  ADD  INDEX exams_patient_num (  `patient_num`  ) [ RunTime:0.011570s ]
[ 2018-11-23T14:52:20+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `exams`  ADD  INDEX exams_patient_id (  `patient_id`  ) [ RunTime:0.009958s ]
[ 2018-11-23T14:52:23+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `images`  ADD  size varchar(255) [ RunTime:2.915925s ]
[ 2018-11-23T14:52:26+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `images`  ADD  institution_id varchar(100) [ RunTime:3.021239s ]
[ 2018-11-23T14:52:29+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `images`  ADD  INDEX series_id_index (  `series_id`  ) [ RunTime:3.577174s ]
[ 2018-11-23T14:52:32+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `images`  ADD  INDEX images_owner (  `owner`  ) [ RunTime:3.007711s ]
[ 2018-11-23T14:52:36+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `images`  ADD  INDEX images_institution_id (  `institution_id`  ) [ RunTime:3.187477s ]
[ 2018-11-23T14:52:39+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `images`  ADD  INDEX images_url (  `url`  ) [ RunTime:3.209628s ]
[ 2018-11-23T14:52:42+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `images`  ADD  INDEX images_series_id (  `series_id`  ) [ RunTime:3.464437s ]
[ 2018-11-23T14:52:42+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `operating`  ADD  INDEX month (  `month`  ) [ RunTime:0.005178s ]
[ 2018-11-23T14:52:42+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `patient_infos`  ADD  INDEX card_num (  `card_num`  ) [ RunTime:0.181470s ]
[ 2018-11-23T14:52:43+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `patient_infos`  ADD  INDEX patient_infos_institution_id (  `institution_id`  ) [ RunTime:0.196848s ]
[ 2018-11-23T14:52:43+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `series`  ADD  INDEX series_modality (  `modality`  ) [ RunTime:0.036118s ]
[ 2018-11-23T14:52:43+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `series`  ADD  INDEX series_study_id (  `study_id`  ) [ RunTime:0.018842s ]
[ 2018-11-23T14:52:43+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `studies`  ADD  INDEX studies_institution_name (  `institution_name`  ) [ RunTime:0.004949s ]
[ 2018-11-23T14:52:43+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `studies`  ADD  INDEX studies_patient_id (  `patient_id`  ) [ RunTime:0.005717s ]
[ 2018-11-23T14:52:43+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `studies`  ADD  INDEX studies_studydate (  `studydate`  ) [ RunTime:0.004887s ]
[ 2018-11-23T14:52:43+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `studies`  ADD  INDEX studies_modality (  `modality`  ) [ RunTime:0.007247s ]
[ 2018-11-23T14:52:43+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `studies`  ADD  INDEX studies_status (  `status`  ) [ RunTime:0.005158s ]
[ 2018-11-23T14:52:43+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `studies`  ADD  INDEX studies_studyid (  `studyid`  ) [ RunTime:0.005362s ]
[ 2018-11-23T14:52:43+08:00 ][ sql ] [ SQL ] 
ALTER  TABLE  `studies`  ADD  INDEX studies_accession_num (  `accession_num`  ) [ RunTime:0.005669s ]
[ 2018-11-23T14:52:43+08:00 ][ sql ] [ SQL ] 
delete from patient_infos where id not in (select patient_id from exams) [ RunTime:0.320357s ]
[ 2018-11-23T14:52:43+08:00 ][ info ] [ CACHE ] INIT File
[ 2018-11-23T14:52:43+08:00 ][ sql ] [ SQL ] UPDATE `version`  SET `version`='2'  WHERE  `id` = 1 [ RunTime:0.002164s ]