You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
456 lines
60 KiB
456 lines
60 KiB
4 months ago
|
2024-06-03 11:15:33 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:15:33 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_worker_info`
|
||
|
|
2024-06-03 11:15:33 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:15:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_worker_info' AND `kcu`.`TABLE_NAME` = 't_worker_info'
|
||
|
|
2024-06-03 11:15:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_worker_info` WHERE `WorkerId`='1'
|
||
|
|
2024-06-03 11:15:33 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:15:33 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_worker_info`
|
||
|
|
2024-06-03 11:15:33 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:15:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_worker_info' AND `kcu`.`TABLE_NAME` = 't_worker_info'
|
||
|
|
2024-06-03 11:15:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_worker_info` WHERE `WorkerId`='1'
|
||
|
|
2024-06-03 11:15:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_sys_config` WHERE `Status`=1
|
||
|
|
2024-06-03 11:15:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_system_entries` WHERE (`SysType`='16') AND (`AuthType`=1)
|
||
|
|
2024-06-03 11:15:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_system_entries` WHERE Id NOT IN(SELECT ParentId from t_system_entries)
|
||
|
|
2024-06-03 11:15:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_worker_info` WHERE `WorkerId`='1'
|
||
|
|
2024-06-03 11:15:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_system_entries` WHERE (`SysType`='16') AND (`AuthType`=2)
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT COUNT(*) FROM `t_merck_policy_hospital` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE (`p`.`status`=1) AND (`p`.`user_type`='1')
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `p`.`id` AS `policyId`, `p`.`region_id` AS `regionId`, `p`.`region_name` AS `regionName`, `p`.`province_id` AS `provinceId`, `p`.`province_name` AS `provinceName`, `p`.`city_id` AS `cityId`, `p`.`city_name` AS `cityName`, `p`.`user_type` AS `userType`, `p`.`self_rate` AS `selfRate`, `p`.`reimburse_type` AS `reimburseType`, `p`.`begin_pay_amount_type` AS `beginPayType`, `p`.`begin_pay_amount` AS `beginPayAmount`, `p`.`begin_pay_content` AS `beginPayContent`, `p`.`reimburse_rate_type` AS `reimburseRateType`, `p`.`reimburse_rate` AS `reimburseRate`, `p`.`reimburse_rate_two` AS `reimburseRateTwo`, `p`.`reimburse_rate_content` AS `reimburseRateContent`, `p`.`payment_limit` AS `paymentLimit`, `p`.`remark` AS `remark`, `p`.`open_status` AS `openStatus`, `p`.`create_worker_id` AS `createWorkerId`, substring(p.created_at,1,10) AS `createdAt`, ifnull(w.WorkerName,"") AS `workerName` FROM `t_merck_policy_hospital` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE (`p`.`status`=1) AND (`p`.`user_type`='1') ORDER BY `policyId` DESC LIMIT 10
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_merck_policy_hospital`
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_merck_policy_hospital' AND `kcu`.`TABLE_NAME` = 't_merck_policy_hospital'
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `begin_pay_amount_type` AS `beginPayType`, `config_type` AS `configType`, `begin_pay_amount` AS `beginPayAmount` FROM `t_merck_policy_hospital_begin_pay_config` WHERE (`policy_id` IN ('432', '431', '430', '426', '425', '424', '416', '415', '414', '410')) AND (`status`=1)
|
||
|
|
2024-06-03 11:15:35 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `reimburse_rate_type` AS `reimburseRateType`, `config_type` AS `configType`, `begin_amount` AS `beginAmount`, `end_amount` AS `endAmount`, `reimburse_rate` AS `reimburseRate` FROM `t_merck_policy_hospital_reimburse_rate_config` WHERE (`policy_id` IN ('432', '431', '430', '426', '425', '424', '416', '415', '414', '410')) AND (`status`=1)
|
||
|
|
2024-06-03 11:15:45 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:15:45 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:15:45 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:15:45 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:15:45 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:15:45 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:15:45 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:15:45 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:15:45 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:15:45 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:15:46 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT COUNT(*) FROM `t_merck_policy_hospital` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE (`p`.`status`=1) AND (`p`.`user_type`='2')
|
||
|
|
2024-06-03 11:15:46 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `p`.`id` AS `policyId`, `p`.`region_id` AS `regionId`, `p`.`region_name` AS `regionName`, `p`.`province_id` AS `provinceId`, `p`.`province_name` AS `provinceName`, `p`.`city_id` AS `cityId`, `p`.`city_name` AS `cityName`, `p`.`user_type` AS `userType`, `p`.`self_rate` AS `selfRate`, `p`.`reimburse_type` AS `reimburseType`, `p`.`begin_pay_amount_type` AS `beginPayType`, `p`.`begin_pay_amount` AS `beginPayAmount`, `p`.`begin_pay_content` AS `beginPayContent`, `p`.`reimburse_rate_type` AS `reimburseRateType`, `p`.`reimburse_rate` AS `reimburseRate`, `p`.`reimburse_rate_two` AS `reimburseRateTwo`, `p`.`reimburse_rate_content` AS `reimburseRateContent`, `p`.`payment_limit` AS `paymentLimit`, `p`.`remark` AS `remark`, `p`.`open_status` AS `openStatus`, `p`.`create_worker_id` AS `createWorkerId`, substring(p.created_at,1,10) AS `createdAt`, ifnull(w.WorkerName,"") AS `workerName` FROM `t_merck_policy_hospital` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE (`p`.`status`=1) AND (`p`.`user_type`='2') ORDER BY `policyId` DESC LIMIT 10
|
||
|
|
2024-06-03 11:15:46 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_merck_policy_hospital`
|
||
|
|
2024-06-03 11:15:46 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_merck_policy_hospital' AND `kcu`.`TABLE_NAME` = 't_merck_policy_hospital'
|
||
|
|
2024-06-03 11:15:46 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `begin_pay_amount_type` AS `beginPayType`, `config_type` AS `configType`, `begin_pay_amount` AS `beginPayAmount` FROM `t_merck_policy_hospital_begin_pay_config` WHERE (`policy_id` IN ('435', '434', '433', '429', '428', '427', '423', '422', '421', '413')) AND (`status`=1)
|
||
|
|
2024-06-03 11:15:46 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `reimburse_rate_type` AS `reimburseRateType`, `config_type` AS `configType`, `begin_amount` AS `beginAmount`, `end_amount` AS `endAmount`, `reimburse_rate` AS `reimburseRate` FROM `t_merck_policy_hospital_reimburse_rate_config` WHERE (`policy_id` IN ('435', '434', '433', '429', '428', '427', '423', '422', '421', '413')) AND (`status`=1)
|
||
|
|
2024-06-03 11:15:55 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:15:56 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:15:56 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:15:56 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:15:56 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:15:55 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:15:56 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:15:56 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:15:56 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:15:56 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:15:56 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `policyId`, `region_id` AS `regionId`, `region_name` AS `regionName`, `province_id` AS `provinceId`, `province_name` AS `provinceName`, `city_id` AS `cityId`, `city_name` AS `cityName`, `user_type` AS `userType`, `self_rate` AS `selfRate`, `reimburse_type` AS `reimburseType`, `begin_pay_amount_type` AS `beginPayType`, `begin_pay_amount` AS `beginPayAmount`, `begin_pay_content` AS `beginPayContent`, `reimburse_rate_type` AS `reimburseRateType`, `reimburse_rate` AS `reimburseRate`, `reimburse_rate_two` AS `reimburseRateTwo`, `reimburse_rate_content` AS `reimburseRateContent`, `payment_limit` AS `paymentLimit`, `remark`, `open_status` AS `openStatus`, `create_worker_id` AS `createWorkerId`, `created_at` AS `createdAt` FROM `t_merck_policy_hospital` WHERE (`status`=1) AND (`id`='435')
|
||
|
|
2024-06-03 11:15:56 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `begin_pay_amount_type` AS `beginPayType`, `config_type` AS `configType`, `begin_pay_amount` AS `beginPayAmount` FROM `t_merck_policy_hospital_begin_pay_config` WHERE (`policy_id`='435') AND (`status`=1)
|
||
|
|
2024-06-03 11:15:56 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `reimburse_rate_type` AS `reimburseRateType`, `config_type` AS `configType`, `begin_amount` AS `beginAmount`, `end_amount` AS `endAmount`, `reimburse_rate` AS `reimburseRate` FROM `t_merck_policy_hospital_reimburse_rate_config` WHERE (`policy_id`='435') AND (`status`=1)
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT COUNT(*) FROM `t_merck_policy_hospital` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE (`p`.`status`=1) AND (`p`.`user_type`='1')
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `p`.`id` AS `policyId`, `p`.`region_id` AS `regionId`, `p`.`region_name` AS `regionName`, `p`.`province_id` AS `provinceId`, `p`.`province_name` AS `provinceName`, `p`.`city_id` AS `cityId`, `p`.`city_name` AS `cityName`, `p`.`user_type` AS `userType`, `p`.`self_rate` AS `selfRate`, `p`.`reimburse_type` AS `reimburseType`, `p`.`begin_pay_amount_type` AS `beginPayType`, `p`.`begin_pay_amount` AS `beginPayAmount`, `p`.`begin_pay_content` AS `beginPayContent`, `p`.`reimburse_rate_type` AS `reimburseRateType`, `p`.`reimburse_rate` AS `reimburseRate`, `p`.`reimburse_rate_two` AS `reimburseRateTwo`, `p`.`reimburse_rate_content` AS `reimburseRateContent`, `p`.`payment_limit` AS `paymentLimit`, `p`.`remark` AS `remark`, `p`.`open_status` AS `openStatus`, `p`.`create_worker_id` AS `createWorkerId`, substring(p.created_at,1,10) AS `createdAt`, ifnull(w.WorkerName,"") AS `workerName` FROM `t_merck_policy_hospital` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE (`p`.`status`=1) AND (`p`.`user_type`='1') ORDER BY `policyId` DESC LIMIT 10
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_merck_policy_hospital`
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_merck_policy_hospital' AND `kcu`.`TABLE_NAME` = 't_merck_policy_hospital'
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `begin_pay_amount_type` AS `beginPayType`, `config_type` AS `configType`, `begin_pay_amount` AS `beginPayAmount` FROM `t_merck_policy_hospital_begin_pay_config` WHERE (`policy_id` IN ('432', '431', '430', '426', '425', '424', '416', '415', '414', '410')) AND (`status`=1)
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `reimburse_rate_type` AS `reimburseRateType`, `config_type` AS `configType`, `begin_amount` AS `beginAmount`, `end_amount` AS `endAmount`, `reimburse_rate` AS `reimburseRate` FROM `t_merck_policy_hospital_reimburse_rate_config` WHERE (`policy_id` IN ('432', '431', '430', '426', '425', '424', '416', '415', '414', '410')) AND (`status`=1)
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT COUNT(*) FROM `t_merck_policy_hospital` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE (`p`.`status`=1) AND (`p`.`user_type`='2')
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `p`.`id` AS `policyId`, `p`.`region_id` AS `regionId`, `p`.`region_name` AS `regionName`, `p`.`province_id` AS `provinceId`, `p`.`province_name` AS `provinceName`, `p`.`city_id` AS `cityId`, `p`.`city_name` AS `cityName`, `p`.`user_type` AS `userType`, `p`.`self_rate` AS `selfRate`, `p`.`reimburse_type` AS `reimburseType`, `p`.`begin_pay_amount_type` AS `beginPayType`, `p`.`begin_pay_amount` AS `beginPayAmount`, `p`.`begin_pay_content` AS `beginPayContent`, `p`.`reimburse_rate_type` AS `reimburseRateType`, `p`.`reimburse_rate` AS `reimburseRate`, `p`.`reimburse_rate_two` AS `reimburseRateTwo`, `p`.`reimburse_rate_content` AS `reimburseRateContent`, `p`.`payment_limit` AS `paymentLimit`, `p`.`remark` AS `remark`, `p`.`open_status` AS `openStatus`, `p`.`create_worker_id` AS `createWorkerId`, substring(p.created_at,1,10) AS `createdAt`, ifnull(w.WorkerName,"") AS `workerName` FROM `t_merck_policy_hospital` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE (`p`.`status`=1) AND (`p`.`user_type`='2') ORDER BY `policyId` DESC LIMIT 10
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_merck_policy_hospital`
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_merck_policy_hospital' AND `kcu`.`TABLE_NAME` = 't_merck_policy_hospital'
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `begin_pay_amount_type` AS `beginPayType`, `config_type` AS `configType`, `begin_pay_amount` AS `beginPayAmount` FROM `t_merck_policy_hospital_begin_pay_config` WHERE (`policy_id` IN ('435', '434', '433', '429', '428', '427', '423', '422', '421', '413')) AND (`status`=1)
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `reimburse_rate_type` AS `reimburseRateType`, `config_type` AS `configType`, `begin_amount` AS `beginAmount`, `end_amount` AS `endAmount`, `reimburse_rate` AS `reimburseRate` FROM `t_merck_policy_hospital_reimburse_rate_config` WHERE (`policy_id` IN ('435', '434', '433', '429', '428', '427', '423', '422', '421', '413')) AND (`status`=1)
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:16:14 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:16:18 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:16:18 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:16:18 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:16:18 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:16:18 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:16:18 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:16:18 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:16:18 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:16:18 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:16:18 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:16:18 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `policyId`, `region_id` AS `regionId`, `region_name` AS `regionName`, `province_id` AS `provinceId`, `province_name` AS `provinceName`, `city_id` AS `cityId`, `city_name` AS `cityName`, `user_type` AS `userType`, `self_rate` AS `selfRate`, `reimburse_type` AS `reimburseType`, `begin_pay_amount_type` AS `beginPayType`, `begin_pay_amount` AS `beginPayAmount`, `begin_pay_content` AS `beginPayContent`, `reimburse_rate_type` AS `reimburseRateType`, `reimburse_rate` AS `reimburseRate`, `reimburse_rate_two` AS `reimburseRateTwo`, `reimburse_rate_content` AS `reimburseRateContent`, `payment_limit` AS `paymentLimit`, `remark`, `open_status` AS `openStatus`, `create_worker_id` AS `createWorkerId`, `created_at` AS `createdAt` FROM `t_merck_policy_hospital` WHERE (`status`=1) AND (`id`='435')
|
||
|
|
2024-06-03 11:16:18 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `begin_pay_amount_type` AS `beginPayType`, `config_type` AS `configType`, `begin_pay_amount` AS `beginPayAmount` FROM `t_merck_policy_hospital_begin_pay_config` WHERE (`policy_id`='435') AND (`status`=1)
|
||
|
|
2024-06-03 11:16:18 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `reimburse_rate_type` AS `reimburseRateType`, `config_type` AS `configType`, `begin_amount` AS `beginAmount`, `end_amount` AS `endAmount`, `reimburse_rate` AS `reimburseRate` FROM `t_merck_policy_hospital_reimburse_rate_config` WHERE (`policy_id`='435') AND (`status`=1)
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT COUNT(*) FROM `t_merck_policy_hospital` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE (`p`.`status`=1) AND (`p`.`user_type`='2')
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `p`.`id` AS `policyId`, `p`.`region_id` AS `regionId`, `p`.`region_name` AS `regionName`, `p`.`province_id` AS `provinceId`, `p`.`province_name` AS `provinceName`, `p`.`city_id` AS `cityId`, `p`.`city_name` AS `cityName`, `p`.`user_type` AS `userType`, `p`.`self_rate` AS `selfRate`, `p`.`reimburse_type` AS `reimburseType`, `p`.`begin_pay_amount_type` AS `beginPayType`, `p`.`begin_pay_amount` AS `beginPayAmount`, `p`.`begin_pay_content` AS `beginPayContent`, `p`.`reimburse_rate_type` AS `reimburseRateType`, `p`.`reimburse_rate` AS `reimburseRate`, `p`.`reimburse_rate_two` AS `reimburseRateTwo`, `p`.`reimburse_rate_content` AS `reimburseRateContent`, `p`.`payment_limit` AS `paymentLimit`, `p`.`remark` AS `remark`, `p`.`open_status` AS `openStatus`, `p`.`create_worker_id` AS `createWorkerId`, substring(p.created_at,1,10) AS `createdAt`, ifnull(w.WorkerName,"") AS `workerName` FROM `t_merck_policy_hospital` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE (`p`.`status`=1) AND (`p`.`user_type`='2') ORDER BY `policyId` DESC LIMIT 10
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_merck_policy_hospital`
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_merck_policy_hospital' AND `kcu`.`TABLE_NAME` = 't_merck_policy_hospital'
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `begin_pay_amount_type` AS `beginPayType`, `config_type` AS `configType`, `begin_pay_amount` AS `beginPayAmount` FROM `t_merck_policy_hospital_begin_pay_config` WHERE (`policy_id` IN ('435', '434', '433', '429', '428', '427', '423', '422', '421', '413')) AND (`status`=1)
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `reimburse_rate_type` AS `reimburseRateType`, `config_type` AS `configType`, `begin_amount` AS `beginAmount`, `end_amount` AS `endAmount`, `reimburse_rate` AS `reimburseRate` FROM `t_merck_policy_hospital_reimburse_rate_config` WHERE (`policy_id` IN ('435', '434', '433', '429', '428', '427', '423', '422', '421', '413')) AND (`status`=1)
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT COUNT(*) FROM `t_merck_policy_hospital` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE (`p`.`status`=1) AND (`p`.`user_type`='1')
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `p`.`id` AS `policyId`, `p`.`region_id` AS `regionId`, `p`.`region_name` AS `regionName`, `p`.`province_id` AS `provinceId`, `p`.`province_name` AS `provinceName`, `p`.`city_id` AS `cityId`, `p`.`city_name` AS `cityName`, `p`.`user_type` AS `userType`, `p`.`self_rate` AS `selfRate`, `p`.`reimburse_type` AS `reimburseType`, `p`.`begin_pay_amount_type` AS `beginPayType`, `p`.`begin_pay_amount` AS `beginPayAmount`, `p`.`begin_pay_content` AS `beginPayContent`, `p`.`reimburse_rate_type` AS `reimburseRateType`, `p`.`reimburse_rate` AS `reimburseRate`, `p`.`reimburse_rate_two` AS `reimburseRateTwo`, `p`.`reimburse_rate_content` AS `reimburseRateContent`, `p`.`payment_limit` AS `paymentLimit`, `p`.`remark` AS `remark`, `p`.`open_status` AS `openStatus`, `p`.`create_worker_id` AS `createWorkerId`, substring(p.created_at,1,10) AS `createdAt`, ifnull(w.WorkerName,"") AS `workerName` FROM `t_merck_policy_hospital` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE (`p`.`status`=1) AND (`p`.`user_type`='1') ORDER BY `policyId` DESC LIMIT 10
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_merck_policy_hospital`
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_merck_policy_hospital' AND `kcu`.`TABLE_NAME` = 't_merck_policy_hospital'
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `begin_pay_amount_type` AS `beginPayType`, `config_type` AS `configType`, `begin_pay_amount` AS `beginPayAmount` FROM `t_merck_policy_hospital_begin_pay_config` WHERE (`policy_id` IN ('432', '431', '430', '426', '425', '424', '416', '415', '414', '410')) AND (`status`=1)
|
||
|
|
2024-06-03 11:16:24 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `configId`, `policy_id` AS `policyId`, `reimburse_rate_type` AS `reimburseRateType`, `config_type` AS `configType`, `begin_amount` AS `beginAmount`, `end_amount` AS `endAmount`, `reimburse_rate` AS `reimburseRate` FROM `t_merck_policy_hospital_reimburse_rate_config` WHERE (`policy_id` IN ('432', '431', '430', '426', '425', '424', '416', '415', '414', '410')) AND (`status`=1)
|
||
|
|
2024-06-03 11:16:25 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:16:25 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:16:25 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:16:25 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:16:25 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:16:33 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:16:33 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:16:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:16:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:16:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:16:33 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:16:33 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:16:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:16:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:16:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:16:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT COUNT(*) FROM `t_merck_policy_pharmacy` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE `p`.`status`=1
|
||
|
|
2024-06-03 11:16:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `p`.`id` AS `policyId`, `p`.`region_id` AS `regionId`, `p`.`region_name` AS `regionName`, `p`.`province_id` AS `provinceId`, `p`.`province_name` AS `provinceName`, `p`.`city_id` AS `cityId`, `p`.`city_name` AS `cityName`, `p`.`open_two_status` AS `openTwoStatus`, `p`.`begin_pay_amount` AS `beginPayAmount`, `p`.`reimburse_rate` AS `reimburseRate`, `p`.`payment_limit` AS `paymentLimit`, `p`.`bring_into_status` AS `bringIntoStatus`, `p`.`remark` AS `remark`, `p`.`open_status` AS `openStatus`, `p`.`create_worker_id` AS `createWorkerId`, substring(p.created_at,1,10) AS `createdAt`, ifnull(w.WorkerName,"") AS `workerName` FROM `t_merck_policy_pharmacy` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE `p`.`status`=1 ORDER BY `policyId` DESC LIMIT 10
|
||
|
|
2024-06-03 11:16:33 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_merck_policy_pharmacy`
|
||
|
|
2024-06-03 11:16:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_merck_policy_pharmacy' AND `kcu`.`TABLE_NAME` = 't_merck_policy_pharmacy'
|
||
|
|
2024-06-03 11:16:33 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `id` AS `fileId`, `policy_id` AS `policyId`, `file_name` AS `fileName`, `file_link_url` AS `fileLinkUrl` FROM `t_merck_policy_pharmacy_file` WHERE (`policy_id` IN ('75', '74', '73', '72', '71', '70', '69', '68', '67', '66')) AND (`status`=1)
|
||
|
|
2024-06-03 11:16:36 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:16:36 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:16:36 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:16:36 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:16:36 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:16:36 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:16:36 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:16:36 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:16:36 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:16:36 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:16:36 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT COUNT(*) FROM `t_merck_policy_serious` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE `p`.`status`=1
|
||
|
|
2024-06-03 11:16:36 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `p`.`id` AS `policyId`, `p`.`region_id` AS `regionId`, `p`.`region_name` AS `regionName`, `p`.`province_id` AS `provinceId`, `p`.`province_name` AS `provinceName`, `p`.`city_id` AS `cityId`, `p`.`city_name` AS `cityName`, `p`.`begin_pay_amount` AS `beginPayAmount`, `p`.`help_rate` AS `helpRate`, `p`.`open_status` AS `openStatus`, `p`.`create_worker_id` AS `createWorkerId`, substring(p.created_at,1,10) AS `createdAt`, ifnull(w.WorkerName,"") AS `workerName` FROM `t_merck_policy_serious` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE `p`.`status`=1 ORDER BY `policyId` DESC LIMIT 10
|
||
|
|
2024-06-03 11:16:36 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_merck_policy_serious`
|
||
|
|
2024-06-03 11:16:36 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_merck_policy_serious' AND `kcu`.`TABLE_NAME` = 't_merck_policy_serious'
|
||
|
|
2024-06-03 11:16:52 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:16:52 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:16:52 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:16:52 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:16:52 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:16:52 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT COUNT(*) FROM `t_merck_policy_serious` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE `p`.`status`=1
|
||
|
|
2024-06-03 11:16:52 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `p`.`id` AS `policyId`, `p`.`region_id` AS `regionId`, `p`.`region_name` AS `regionName`, `p`.`province_id` AS `provinceId`, `p`.`province_name` AS `provinceName`, `p`.`city_id` AS `cityId`, `p`.`city_name` AS `cityName`, `p`.`begin_pay_amount` AS `beginPayAmount`, `p`.`help_rate` AS `helpRate`, `p`.`open_status` AS `openStatus`, `p`.`create_worker_id` AS `createWorkerId`, substring(p.created_at,1,10) AS `createdAt`, ifnull(w.WorkerName,"") AS `workerName` FROM `t_merck_policy_serious` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE `p`.`status`=1 ORDER BY `policyId` DESC LIMIT 10 OFFSET 50
|
||
|
|
2024-06-03 11:16:52 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_merck_policy_serious`
|
||
|
|
2024-06-03 11:16:52 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_merck_policy_serious' AND `kcu`.`TABLE_NAME` = 't_merck_policy_serious'
|
||
|
|
2024-06-03 11:17:03 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 11:17:03 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 11:17:03 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 11:17:03 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 11:17:03 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 11:17:03 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT COUNT(*) FROM `t_merck_policy_serious` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE `p`.`status`=1
|
||
|
|
2024-06-03 11:17:03 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT `p`.`id` AS `policyId`, `p`.`region_id` AS `regionId`, `p`.`region_name` AS `regionName`, `p`.`province_id` AS `provinceId`, `p`.`province_name` AS `provinceName`, `p`.`city_id` AS `cityId`, `p`.`city_name` AS `cityName`, `p`.`begin_pay_amount` AS `beginPayAmount`, `p`.`help_rate` AS `helpRate`, `p`.`open_status` AS `openStatus`, `p`.`create_worker_id` AS `createWorkerId`, substring(p.created_at,1,10) AS `createdAt`, ifnull(w.WorkerName,"") AS `workerName` FROM `t_merck_policy_serious` `p` LEFT JOIN `t_worker_info` `w` ON w.WorkerId=p.create_worker_id WHERE `p`.`status`=1 ORDER BY `policyId` DESC LIMIT 10
|
||
|
|
2024-06-03 11:17:03 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_merck_policy_serious`
|
||
|
|
2024-06-03 11:17:03 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_merck_policy_serious' AND `kcu`.`TABLE_NAME` = 't_merck_policy_serious'
|
||
|
|
2024-06-03 14:10:47 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 14:10:47 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_worker_info`
|
||
|
|
2024-06-03 14:10:47 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 14:10:47 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_worker_info' AND `kcu`.`TABLE_NAME` = 't_worker_info'
|
||
|
|
2024-06-03 14:10:47 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_worker_info` WHERE `WorkerId`='1'
|
||
|
|
2024-06-03 14:10:47 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_worker_info` WHERE `WorkerId`='1'
|
||
|
|
2024-06-03 14:10:47 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT DISTINCT `UiPermItem` FROM `t_auth` WHERE `UiPermGroup`='worker-m-g'
|
||
|
|
2024-06-03 14:10:48 [192.168.65.1][-][f0b90a79fd13889addfed466c9304046][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 14:10:48 [192.168.65.1][-][f0b90a79fd13889addfed466c9304046][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 14:10:48 [192.168.65.1][-][f0b90a79fd13889addfed466c9304046][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 14:10:48 [192.168.65.1][-][f0b90a79fd13889addfed466c9304046][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 14:10:48 [192.168.65.1][-][f0b90a79fd13889addfed466c9304046][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 14:10:48 [192.168.65.1][-][f0b90a79fd13889addfed466c9304046][info][yii\db\Command::query] SELECT COUNT(*) FROM `t_worker_info` WHERE `WorkerStatus`=0
|
||
|
|
2024-06-03 14:10:48 [192.168.65.1][-][f0b90a79fd13889addfed466c9304046][info][yii\db\Command::query] SELECT `WorkerId` AS `workerId`, `WorkerName` AS `workerName`, `Telephone` AS `telephone`, `RolesId` AS `identity`, `IsActive` AS `isActive`, `RegTime` AS `createTime`, `LastActTime` AS `updateTime`, ifnull(LastLoginTime,'') AS `lastLoginTime`, `CreateWorkerId` AS `createWorkerId`, `UpdateWorkerId` AS `updateWorkerId` FROM `t_worker_info` WHERE `WorkerStatus`=0 ORDER BY `workerId` DESC LIMIT 10
|
||
|
|
2024-06-03 14:10:48 [192.168.65.1][-][f0b90a79fd13889addfed466c9304046][info][yii\db\Command::query] SELECT `WorkerId`, `WorkerName` FROM `t_worker_info` WHERE `WorkerId` IN ('14510', '1', '1960', '1', '2')
|
||
|
|
2024-06-03 14:10:48 [192.168.65.1][-][f0b90a79fd13889addfed466c9304046][info][yii\db\Command::query] SELECT `wr`.`WorkerId` AS `workerId`, `wr`.`RoleId` AS `roleId`, `r`.`RoleName` AS `roleName` FROM `t_worker_role` `wr` LEFT JOIN `t_role` `r` ON r.RoleId = wr.RoleId WHERE (`wr`.`WorkerId` IN ('5', '3', '2', '1')) AND (`wr`.`Status`=1)
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_worker_info`
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_worker_info' AND `kcu`.`TABLE_NAME` = 't_worker_info'
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_worker_info` WHERE `WorkerId`='1'
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_worker_info`
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_worker_info' AND `kcu`.`TABLE_NAME` = 't_worker_info'
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_worker_info` WHERE `WorkerId`='1'
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_sys_config` WHERE `Status`=1
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_system_entries` WHERE (`SysType`='16') AND (`AuthType`=1)
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_system_entries` WHERE Id NOT IN(SELECT ParentId from t_system_entries)
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_worker_info` WHERE `WorkerId`='1'
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_system_entries` WHERE (`SysType`='16') AND (`AuthType`=2)
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SHOW FULL COLUMNS FROM `t_worker_info`
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT
|
||
|
|
`kcu`.`CONSTRAINT_NAME` AS `constraint_name`,
|
||
|
|
`kcu`.`COLUMN_NAME` AS `column_name`,
|
||
|
|
`kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`,
|
||
|
|
`kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name`
|
||
|
|
FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc`
|
||
|
|
JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON
|
||
|
|
(
|
||
|
|
`kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR
|
||
|
|
(`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL)
|
||
|
|
) AND
|
||
|
|
`kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND
|
||
|
|
`kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME`
|
||
|
|
WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database()
|
||
|
|
AND `rc`.`TABLE_NAME` = 't_worker_info' AND `kcu`.`TABLE_NAME` = 't_worker_info'
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_worker_info` WHERE `WorkerId`='1'
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT * FROM `t_worker_info` WHERE `WorkerId`='1'
|
||
|
|
2024-06-03 14:10:54 [192.168.65.1][-][-][info][yii\db\Command::query] SELECT DISTINCT `UiPermItem` FROM `t_auth` WHERE `UiPermGroup`='worker-m-g'
|
||
|
|
2024-06-03 14:10:55 [192.168.65.1][-][0c2e343a71f7eac0459cd001105d6d67][info][yii\web\Session::open] Session started
|
||
|
|
2024-06-03 14:10:55 [192.168.65.1][-][0c2e343a71f7eac0459cd001105d6d67][info][yii\db\Connection::open] Opening DB connection: mysql:host=39.106.86.127;dbname=db_merck;port=3306
|
||
|
|
2024-06-03 14:10:55 [192.168.65.1][-][0c2e343a71f7eac0459cd001105d6d67][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchId != 101 and BranchId != 0 and BranchType != 10)
|
||
|
|
2024-06-03 14:10:55 [192.168.65.1][-][0c2e343a71f7eac0459cd001105d6d67][info][yii\db\Command::query] SELECT `BranchId`, `BranchName` FROM `t_branch_info` WHERE (`BranchStatus`=0) AND (BranchType != 10)
|
||
|
|
2024-06-03 14:10:55 [192.168.65.1][-][0c2e343a71f7eac0459cd001105d6d67][info][yii\db\Command::query] SELECT `ConfigValue` FROM `t_config` WHERE `ConfigName`='price_rule'
|
||
|
|
2024-06-03 14:10:55 [192.168.65.1][-][0c2e343a71f7eac0459cd001105d6d67][info][yii\db\Command::query] SELECT COUNT(*) FROM `t_worker_info` WHERE `WorkerStatus`=0
|
||
|
|
2024-06-03 14:10:55 [192.168.65.1][-][0c2e343a71f7eac0459cd001105d6d67][info][yii\db\Command::query] SELECT `WorkerId` AS `workerId`, `WorkerName` AS `workerName`, `Telephone` AS `telephone`, `RolesId` AS `identity`, `IsActive` AS `isActive`, `RegTime` AS `createTime`, `LastActTime` AS `updateTime`, ifnull(LastLoginTime,'') AS `lastLoginTime`, `CreateWorkerId` AS `createWorkerId`, `UpdateWorkerId` AS `updateWorkerId` FROM `t_worker_info` WHERE `WorkerStatus`=0 ORDER BY `workerId` DESC LIMIT 10
|
||
|
|
2024-06-03 14:10:55 [192.168.65.1][-][0c2e343a71f7eac0459cd001105d6d67][info][yii\db\Command::query] SELECT `WorkerId`, `WorkerName` FROM `t_worker_info` WHERE `WorkerId` IN ('14510', '1', '1960', '1', '2')
|
||
|
|
2024-06-03 14:10:55 [192.168.65.1][-][0c2e343a71f7eac0459cd001105d6d67][info][yii\db\Command::query] SELECT `wr`.`WorkerId` AS `workerId`, `wr`.`RoleId` AS `roleId`, `r`.`RoleName` AS `roleName` FROM `t_worker_role` `wr` LEFT JOIN `t_role` `r` ON r.RoleId = wr.RoleId WHERE (`wr`.`WorkerId` IN ('5', '3', '2', '1')) AND (`wr`.`Status`=1)
|