eATM

夭折的软件中写过的mysql代码

/*
Navicat Premium Data Transfer
Source Server         : ti_RDS
Source Server Type    : MySQL
Source Server Version : 80025
Source Host           : rm-uf6vrgf808f9552gzzo.mysql.rds.aliyuncs.com:3306
Source Schema         : ti_database
Target Server Type    : MySQL
Target Server Version : 80025
File Encoding         : 65001
Date: 22/07/2022 22:04:43
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for acc
-- ----------------------------
DROP TABLE IF EXISTS `acc`;
CREATE TABLE `acc`  (
`name` varchar(64) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
`pwd` varchar(64) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
`type` varchar(16) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL DEFAULT '' COMMENT 'query或buy',
`tid` varchar(64) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT '' COMMENT '使用者的tid',
`err` int NOT NULL DEFAULT 0 COMMENT '是否错误账号',
`time` datetime(3) NULL DEFAULT NULL COMMENT '最后使用时间',
PRIMARY KEY (`name`) USING BTREE,
INDEX `type`(`type`) USING BTREE,
INDEX `tid`(`tid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci COMMENT = '账号数据表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of acc
-- ----------------------------
INSERT INTO `acc` VALUES ('3412259@qq.com', 'Aaqwe123', 'buy', 'test_pc_name_3', 0, '2022-01-15 13:06:36.000');
INSERT INTO `acc` VALUES ('rugedeng539580@163.com', 'Aa123456', 'query', '', 0, '2022-01-15 01:56:01.070');
INSERT INTO `acc` VALUES ('shuo37928921735@163.com', 'Lc930130', 'buy', '', 0, '2022-01-15 12:45:54.000');
INSERT INTO `acc` VALUES ('xiamanshang761@163.com', 'Lc930130', 'query', '', 0, '2022-01-15 12:36:29.000');
-- ----------------------------
-- Table structure for cart
-- ----------------------------
DROP TABLE IF EXISTS `cart`;
CREATE TABLE `cart`  (
`cartid` varchar(64) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT '购物车id',
`name` varchar(32) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT '芯片名',
`time` datetime(3) NOT NULL COMMENT '加入时间',
`client_id` varchar(64) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT '客户端ID',
PRIMARY KEY (`cartid`) USING BTREE,
INDEX `cartid`(`cartid`) USING BTREE,
INDEX `name`(`name`) USING BTREE,
INDEX `add_time`(`time`) USING BTREE,
INDEX `client_id`(`client_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of cart
-- ----------------------------
-- ----------------------------
-- Table structure for chip
-- ----------------------------
DROP TABLE IF EXISTS `chip`;
CREATE TABLE `chip`  (
`name` varchar(32) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT '芯片名',
`package` int NULL DEFAULT 0 COMMENT '包装数量',
`scan_time` datetime(3) NULL DEFAULT NULL COMMENT '最后扫描时间',
`client_id` varchar(32) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT '' COMMENT '正在操作的id',
`get_time` datetime(3) NULL DEFAULT NULL COMMENT '客户获取(在线)时间',
`cart_count` int NULL DEFAULT 0 COMMENT '购物车id数量',
PRIMARY KEY (`name`) USING BTREE,
INDEX `package`(`package`) USING BTREE,
INDEX `scan_time`(`scan_time`) USING BTREE,
INDEX `client_id`(`client_id`) USING BTREE,
INDEX `get_time`(`get_time`) USING BTREE,
INDEX `cart_count`(`cart_count`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci COMMENT = '芯片列表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of chip
-- ----------------------------
INSERT INTO `chip` VALUES ('2N7001TDCKR', 3000, '2022-02-14 17:11:44.080', 'scan001', '2022-04-08 22:27:15.000', 0);
INSERT INTO `chip` VALUES ('ADC121S101CIMF/NOPB', 1000, '2022-02-15 01:30:26.603', '', NULL, 0);
INSERT INTO `chip` VALUES ('ADC121S101CIMFX/NOPB', 3000, '2022-02-15 01:30:36.847', '', NULL, 0);
INSERT INTO `chip` VALUES ('ADC128D818CIMT/NOPB', 92, NULL, 'scan001', '2022-02-21 03:24:29.000', 0);
INSERT INTO `chip` VALUES ('ADC128D818CIMTX/NOPB', 2500, NULL, 'scan001', '2022-03-06 13:27:17.293', 0);
INSERT INTO `chip` VALUES ('ADCS7476AIMF/NOPB', 1000, NULL, 'scan001', '2022-03-06 13:27:17.327', 0);
INSERT INTO `chip` VALUES ('ADCS7476AIMFE/NOPB', 250, NULL, 'scan001', '2022-03-06 13:27:17.360', 0);
INSERT INTO `chip` VALUES ('ADS1015BQDGSRQ1', 2500, NULL, 'scan001', '2022-03-06 13:27:17.393', 0);
INSERT INTO `chip` VALUES ('ADS1015IRUGR', 3000, NULL, 'scan001', '2022-03-06 13:27:17.426', 0);
INSERT INTO `chip` VALUES ('ADS1015IRUGT', 250, NULL, 'scan001', '2022-03-06 13:27:17.460', 0);
INSERT INTO `chip` VALUES ('ADS1115IRUGR', 3000, NULL, 'scan001', '2022-03-06 13:27:17.494', 0);
INSERT INTO `chip` VALUES ('ADS1248IPWR', 2000, NULL, 'scan001', '2022-03-06 13:27:17.560', 0);
INSERT INTO `chip` VALUES ('ADS131E08IPAGR', 1500, NULL, 'scan001', '2022-03-06 13:27:17.594', 0);
INSERT INTO `chip` VALUES ('ADS7042IRUGR', 3000, NULL, 'scan001', '2022-03-06 13:27:17.628', 0);
INSERT INTO `chip` VALUES ('ADS7924IRTER', 3000, NULL, 'scan001', '2022-03-06 13:27:17.662', 0);
INSERT INTO `chip` VALUES ('ADS7924IRTET', 250, NULL, 'scan001', '2022-03-06 13:27:17.696', 0);
INSERT INTO `chip` VALUES ('AM26C31IPWR', 2000, NULL, 'scan001', '2022-03-06 13:27:17.730', 0);
INSERT INTO `chip` VALUES ('AM26C32IPWR', 2000, NULL, 'scan001', '2022-03-06 13:27:17.764', 0);
INSERT INTO `chip` VALUES ('AM26LV32EIPWR', 2000, NULL, 'scan001', '2022-03-06 13:27:17.798', 0);
INSERT INTO `chip` VALUES ('AM26LV32EIRGYR', 3000, NULL, 'scan001', '2022-03-06 13:27:17.831', 0);
INSERT INTO `chip` VALUES ('AM3352BZCZ100', 126, NULL, 'scan001', '2022-03-06 13:27:17.865', 0);
INSERT INTO `chip` VALUES ('AM3352BZCZA100', 126, NULL, 'scan001', '2022-03-06 13:27:17.898', 0);
INSERT INTO `chip` VALUES ('AM3352BZCZA60', 126, NULL, 'scan001', '2022-03-06 13:27:17.932', 0);
INSERT INTO `chip` VALUES ('AM3352BZCZD80', 126, NULL, 'scan001', '2022-03-06 13:27:17.966', 0);
INSERT INTO `chip` VALUES ('AM3358BZCZ100', 126, NULL, 'scan001', '2022-03-06 13:27:18.000', 0);
INSERT INTO `chip` VALUES ('AM3358BZCZA100', 126, NULL, 'scan001', '2022-03-06 13:27:18.035', 0);
INSERT INTO `chip` VALUES ('AMC1204BDWVR', 1000, NULL, 'scan001', '2022-03-06 13:27:18.068', 0);
INSERT INTO `chip` VALUES ('AMC1311BDWVR', 1000, NULL, 'scan001', '2022-03-06 13:27:18.102', 0);
INSERT INTO `chip` VALUES ('AMC1311BQDWVRQ1', 1000, NULL, 'scan001', '2022-03-06 13:27:18.136', 0);
INSERT INTO `chip` VALUES ('AMC1311DWVR', 1000, NULL, 'scan001', '2022-03-06 13:27:18.171', 0);
INSERT INTO `chip` VALUES ('AWR2243APBGABLQ1', 176, NULL, 'scan001', '2022-03-06 13:27:18.205', 0);
INSERT INTO `chip` VALUES ('AWR2243APBGABLRQ1', 1000, NULL, 'scan001', '2022-03-06 13:27:18.239', 0);
INSERT INTO `chip` VALUES ('BQ2057WTSTR', 2000, NULL, 'scan001', '2022-03-06 13:27:18.274', 0);
INSERT INTO `chip` VALUES ('BQ21061YFPR', 3000, NULL, 'scan001', '2022-03-06 13:27:18.308', 0);
INSERT INTO `chip` VALUES ('BQ21061YFPT', 250, NULL, 'scan001', '2022-03-06 13:27:18.342', 0);
INSERT INTO `chip` VALUES ('BQ24050DSQR', 3000, NULL, 'scan001', '2022-03-06 13:27:18.376', 0);
INSERT INTO `chip` VALUES ('BQ24050DSQT', 250, NULL, 'scan001', '2022-03-06 13:27:18.409', 0);
INSERT INTO `chip` VALUES ('BQ24073RGTR', 3000, NULL, 'scan001', '2022-03-06 13:27:18.443', 0);
INSERT INTO `chip` VALUES ('BQ24073RGTT', 250, NULL, 'scan001', '2022-03-06 13:27:18.477', 0);
INSERT INTO `chip` VALUES ('BQ24090DGQR', 2500, NULL, 'scan001', '2022-03-06 13:27:18.542', 0);
INSERT INTO `chip` VALUES ('BQ24250RGER', 3000, NULL, 'scan001', '2022-03-06 13:27:18.576', 0);
INSERT INTO `chip` VALUES ('BQ24250RGET', 250, NULL, 'scan001', '2022-03-06 13:27:18.610', 0);
INSERT INTO `chip` VALUES ('BQ24295RGER', 3000, NULL, 'scan001', '2022-03-06 13:27:18.642', 0);
INSERT INTO `chip` VALUES ('BQ24295RGET', 250, NULL, 'scan001', '2022-03-06 13:27:18.677', 0);
INSERT INTO `chip` VALUES ('BQ25703ARSNR', 3000, NULL, 'scan001', '2022-03-06 13:27:18.711', 0);
INSERT INTO `chip` VALUES ('BQ25703ARSNT', 250, NULL, 'scan001', '2022-03-06 13:27:18.745', 0);
INSERT INTO `chip` VALUES ('BQ25713RSNR', 3000, NULL, 'scan001', '2022-03-06 13:27:18.779', 0);
INSERT INTO `chip` VALUES ('BQ25713RSNT', 250, NULL, 'scan001', '2022-03-06 13:27:18.813', 0);
INSERT INTO `chip` VALUES ('BQ27421YZFR-G1A', 3000, NULL, 'scan001', '2022-03-06 13:27:18.847', 0);
INSERT INTO `chip` VALUES ('BQ27421YZFT-G1A', 250, NULL, 'scan001', '2022-03-06 13:27:18.882', 0);
INSERT INTO `chip` VALUES ('BQ27Z561YPHR-R1', 3000, NULL, 'scan001', '2022-03-06 13:27:18.915', 0);
INSERT INTO `chip` VALUES ('BQ76PL455APFCR', 1000, NULL, 'scan001', '2022-03-06 13:27:18.949', 0);
INSERT INTO `chip` VALUES ('BQ76PL455ATPFCRQ1', 1000, NULL, 'scan001', '2022-03-06 13:27:18.983', 0);
INSERT INTO `chip` VALUES ('BQ76PL455ATPFCTQ1', 250, NULL, 'scan001', '2022-03-06 13:27:19.017', 0);
INSERT INTO `chip` VALUES ('CC1190RGVR', 2500, NULL, 'scan001', '2022-03-06 13:27:19.050', 0);
INSERT INTO `chip` VALUES ('CC1190RGVT', 250, NULL, 'scan001', '2022-03-06 13:27:19.084', 0);
INSERT INTO `chip` VALUES ('CC2520RHDR', 3000, NULL, 'scan001', '2022-03-06 13:27:19.118', 0);
INSERT INTO `chip` VALUES ('CC2520RHDT', 250, NULL, 'scan001', '2022-03-06 13:27:19.152', 0);
INSERT INTO `chip` VALUES ('CC2640R2FTWRGZRQ1', 2500, NULL, 'scan001', '2022-03-06 13:27:19.186', 0);
INSERT INTO `chip` VALUES ('CC2640R2FTWRGZTQ1', 250, NULL, 'scan001', '2022-03-06 13:27:19.219', 0);
INSERT INTO `chip` VALUES ('CC2652R1FRGZR', 2500, NULL, 'scan001', '2022-03-06 13:27:19.253', 0);
INSERT INTO `chip` VALUES ('CC2652R1FRGZT', 250, NULL, 'scan001', '2022-03-06 13:27:19.287', 0);
INSERT INTO `chip` VALUES ('CC3100MODR11MAMOBR', 750, NULL, 'scan001', '2022-03-06 13:27:19.321', 0);
INSERT INTO `chip` VALUES ('CC3100MODR11MAMOBT', 250, NULL, 'scan001', '2022-03-06 13:27:19.355', 0);
INSERT INTO `chip` VALUES ('CC3120MODRNMMOBR', 750, NULL, 'scan001', '2022-03-06 13:27:19.390', 0);
INSERT INTO `chip` VALUES ('CDCE913PWR', 2000, NULL, 'scan001', '2022-03-06 13:27:19.424', 0);
INSERT INTO `chip` VALUES ('CDCM6208V1RGZR', 2500, NULL, 'scan001', '2022-03-06 13:27:19.457', 0);
INSERT INTO `chip` VALUES ('CDCM6208V1RGZT', 250, NULL, 'scan001', '2022-03-06 13:27:19.491', 0);
INSERT INTO `chip` VALUES ('CSD16570Q5B', 2500, NULL, 'scan001', '2022-03-06 13:27:19.557', 0);
INSERT INTO `chip` VALUES ('CSD18543Q3A', 2500, NULL, 'scan001', '2022-03-06 13:27:19.592', 0);
INSERT INTO `chip` VALUES ('CSD18543Q3AT', 250, NULL, 'scan001', '2022-03-06 13:27:19.625', 0);
INSERT INTO `chip` VALUES ('CSD95372BQ5M', 2500, NULL, 'scan001', '2022-03-06 13:27:19.659', 0);
INSERT INTO `chip` VALUES ('CSD95372BQ5MC', 2500, NULL, 'scan001', '2022-03-06 13:27:19.693', 0);
INSERT INTO `chip` VALUES ('CSD95372BQ5MCT', 250, NULL, 'scan001', '2022-03-06 13:27:19.727', 0);
INSERT INTO `chip` VALUES ('CSD95372BQ5MT', 250, NULL, 'scan001', '2022-03-06 13:27:19.760', 0);
INSERT INTO `chip` VALUES ('CSD95377Q4M', 2500, NULL, 'scan001', '2022-03-06 13:27:19.794', 0);
INSERT INTO `chip` VALUES ('CSD95490Q5MC', 2500, NULL, 'scan001', '2022-03-06 13:27:19.829', 0);
INSERT INTO `chip` VALUES ('CSD95490Q5MCT', 250, NULL, 'scan001', '2022-03-06 13:27:19.862', 0);
INSERT INTO `chip` VALUES ('CSD95496QVM', 2500, NULL, 'scan001', '2022-03-06 13:27:19.896', 0);
INSERT INTO `chip` VALUES ('CSD97394Q4M', 2500, NULL, 'scan001', '2022-03-06 13:27:19.931', 0);
INSERT INTO `chip` VALUES ('CSD97395Q4M', 2500, NULL, 'scan001', '2022-03-06 13:27:19.964', 0);
INSERT INTO `chip` VALUES ('DAC084S085CISD/NOPB', 1000, NULL, 'scan001', '2022-03-06 13:27:19.998', 0);
INSERT INTO `chip` VALUES ('DAC084S085CISDX/NOPB', 4500, NULL, 'scan001', '2022-03-06 13:27:20.034', 0);
INSERT INTO `chip` VALUES ('DAC7311IDCKR', 3000, NULL, 'scan001', '2022-03-06 13:27:20.067', 0);
INSERT INTO `chip` VALUES ('DAC7760IPWPR', 2000, NULL, 'scan001', '2022-03-06 13:27:20.102', 0);
INSERT INTO `chip` VALUES ('DAC8760IPWPR', 2000, NULL, 'scan001', '2022-03-06 13:27:20.136', 0);
INSERT INTO `chip` VALUES ('DLPA3005DPFDR', 1000, NULL, 'scan001', '2022-03-06 13:27:20.171', 0);
INSERT INTO `chip` VALUES ('DP83620SQ/NOPB', 1000, NULL, 'scan001', '2022-03-06 13:27:20.204', 0);
INSERT INTO `chip` VALUES ('DP83620SQX/NOPB', 2500, NULL, 'scan001', '2022-03-10 10:06:59.776', 0);
INSERT INTO `chip` VALUES ('DP83822HFRHBR', 3000, NULL, 'scan001', '2022-03-10 10:06:59.806', 0);
INSERT INTO `chip` VALUES ('DP83822HFRHBT', 250, NULL, 'scan001', '2022-03-10 10:06:59.837', 0);
INSERT INTO `chip` VALUES ('DP83822HRHBR', 3000, NULL, 'scan001', '2022-03-10 10:06:59.867', 0);
INSERT INTO `chip` VALUES ('DP83822HRHBT', 250, NULL, 'scan001', '2022-03-10 10:06:59.898', 0);
INSERT INTO `chip` VALUES ('DP83822IFRHBR', 3000, NULL, 'scan001', '2022-03-10 10:06:59.929', 0);
INSERT INTO `chip` VALUES ('DP83822IFRHBT', 250, NULL, 'scan001', '2022-03-10 10:06:59.960', 0);
INSERT INTO `chip` VALUES ('DP83822IRHBR', 3000, NULL, 'scan001', '2022-03-10 10:06:59.990', 0);
INSERT INTO `chip` VALUES ('DP83822IRHBT', 250, NULL, 'scan001', '2022-03-10 10:07:00.021', 0);
INSERT INTO `chip` VALUES ('DP83826ERHBR', 3000, NULL, 'scan001', '2022-03-10 10:07:00.052', 0);
INSERT INTO `chip` VALUES ('DP83826ERHBT', 250, NULL, 'scan001', '2022-03-10 10:07:00.083', 0);
INSERT INTO `chip` VALUES ('DP83848QSQ/NOPB', 1000, NULL, 'scan001', '2022-03-10 10:07:00.114', 0);
INSERT INTO `chip` VALUES ('DP83848QSQX/NOPB', 2500, NULL, 'scan001', '2022-03-10 10:07:00.144', 0);
INSERT INTO `chip` VALUES ('DP83867CRRGZR', 2500, NULL, 'scan001', '2022-03-10 10:07:00.174', 0);
INSERT INTO `chip` VALUES ('DP83867CRRGZT', 250, NULL, 'scan001', '2022-03-10 10:07:00.204', 0);
INSERT INTO `chip` VALUES ('DP83867CSRGZR', 2500, NULL, 'scan001', '2022-03-10 10:07:00.235', 0);
INSERT INTO `chip` VALUES ('DP83867CSRGZT', 250, NULL, 'scan001', '2022-03-10 10:07:00.267', 0);
INSERT INTO `chip` VALUES ('DP83867ERGZR', 2500, NULL, 'scan001', '2022-03-10 10:07:00.298', 0);
INSERT INTO `chip` VALUES ('DP83867ERGZT', 250, NULL, 'scan001', '2022-03-10 10:07:00.328', 0);
INSERT INTO `chip` VALUES ('DP83867IRPAPR', 1000, NULL, 'scan001', '2022-03-10 10:07:00.359', 0);
INSERT INTO `chip` VALUES ('DP83867IRPAPT', 250, NULL, 'scan001', '2022-03-10 10:07:00.390', 0);
INSERT INTO `chip` VALUES ('DP83867IRRGZR', 2500, NULL, 'scan001', '2022-03-10 10:07:00.420', 0);
INSERT INTO `chip` VALUES ('DP83867IRRGZT', 250, NULL, 'scan001', '2022-03-10 10:07:00.449', 0);
INSERT INTO `chip` VALUES ('DP83867ISRGZR', 2500, NULL, 'scan001', '2022-03-10 10:07:00.480', 0);
INSERT INTO `chip` VALUES ('DP83867ISRGZT', 250, NULL, 'scan001', '2022-03-10 10:07:00.540', 0);
INSERT INTO `chip` VALUES ('DP83TC811RWRNDRQ1', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('DP83TC811RWRNDTQ1', 250, NULL, 'scan001', '2022-03-10 10:07:00.570', 0);
INSERT INTO `chip` VALUES ('DP83TC811SWRNDRQ1', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('DP83TC811SWRNDTQ1', 250, NULL, 'scan001', '2022-03-10 10:07:00.602', 0);
INSERT INTO `chip` VALUES ('DRV10987SPWPR', 2000, NULL, 'scan001', '2022-03-10 10:07:00.632', 0);
INSERT INTO `chip` VALUES ('DRV110APWR', 2000, NULL, 'scan001', '2022-03-10 10:07:00.662', 0);
INSERT INTO `chip` VALUES ('DRV5011ADDMRR', 3000, NULL, 'scan001', '2022-03-10 10:07:00.692', 0);
INSERT INTO `chip` VALUES ('DRV5011ADDMRT', 250, NULL, 'scan001', '2022-02-21 03:24:28.557', 0);
INSERT INTO `chip` VALUES ('DRV5032FADMRR', 3000, NULL, 'scan001', '2022-03-10 10:07:00.722', 0);
INSERT INTO `chip` VALUES ('DRV5032FADMRT', 250, NULL, 'scan001', '2022-03-10 10:07:00.753', 0);
INSERT INTO `chip` VALUES ('DRV5032FBDBZR', 3000, NULL, 'scan001', '2022-03-10 10:07:00.784', 0);
INSERT INTO `chip` VALUES ('DRV5032FBDBZT', 250, NULL, 'scan001', '2022-03-10 10:07:00.815', 0);
INSERT INTO `chip` VALUES ('DRV5033AJQDBZTQ1', 250, NULL, 'scan001', '2022-03-10 10:07:00.845', 0);
INSERT INTO `chip` VALUES ('DRV5055A1QDBZR', 3000, NULL, 'scan001', '2022-03-10 10:07:00.877', 0);
INSERT INTO `chip` VALUES ('DRV5055A1QDBZT', 250, NULL, 'scan001', '2022-03-10 10:07:00.907', 0);
INSERT INTO `chip` VALUES ('DRV8301DCAR', 2000, NULL, 'scan001', '2022-03-10 10:07:00.937', 0);
INSERT INTO `chip` VALUES ('DRV8302DCAR', 2000, NULL, 'scan001', '2022-03-10 10:07:00.967', 0);
INSERT INTO `chip` VALUES ('DRV8304HRHAR', 2500, NULL, 'scan001', '2022-03-10 10:07:00.998', 0);
INSERT INTO `chip` VALUES ('DRV8304HRHAT', 250, NULL, 'scan001', '2022-03-10 10:07:01.029', 0);
INSERT INTO `chip` VALUES ('DRV8308RHAR', 2500, NULL, 'scan001', '2022-03-10 10:07:01.061', 0);
INSERT INTO `chip` VALUES ('DRV8308RHAT', 250, NULL, 'scan001', '2022-03-10 10:07:01.091', 0);
INSERT INTO `chip` VALUES ('DRV8323HRTAR', 2500, NULL, 'scan001', '2022-03-10 10:07:01.122', 0);
INSERT INTO `chip` VALUES ('DRV8323HRTAT', 250, NULL, 'scan001', '2022-03-10 10:07:01.152', 0);
INSERT INTO `chip` VALUES ('DRV8323RSRGZR', 2500, NULL, 'scan001', '2022-03-10 10:07:01.183', 0);
INSERT INTO `chip` VALUES ('DRV8323RSRGZT', 250, NULL, 'scan001', '2022-03-10 10:07:01.214', 0);
INSERT INTO `chip` VALUES ('DRV8353RSRGZR', 2500, NULL, 'scan001', '2022-03-10 10:07:01.245', 0);
INSERT INTO `chip` VALUES ('DRV8353RSRGZT', 250, NULL, 'scan001', '2022-03-10 10:07:01.276', 0);
INSERT INTO `chip` VALUES ('DRV8711DCPR', 2000, NULL, 'scan001', '2022-03-10 10:07:01.308', 0);
INSERT INTO `chip` VALUES ('DRV8814PWPR', 2000, NULL, 'scan001', '2022-03-10 10:07:01.338', 0);
INSERT INTO `chip` VALUES ('DRV8818PWPR', 2000, NULL, 'scan001', '2022-03-10 10:07:01.369', 0);
INSERT INTO `chip` VALUES ('DRV8833RTYR', 3000, NULL, 'scan001', '2022-03-10 10:07:01.400', 0);
INSERT INTO `chip` VALUES ('DRV8833RTYT', 250, NULL, 'scan001', '2022-03-10 10:07:01.430', 0);
INSERT INTO `chip` VALUES ('DRV8873HPWPR', 2000, NULL, 'scan001', '2022-03-10 10:07:01.461', 0);
INSERT INTO `chip` VALUES ('DRV8873HPWPT', 250, NULL, 'scan001', '2022-03-10 10:07:01.492', 0);
INSERT INTO `chip` VALUES ('DRV8873SPWPRQ1', 2000, NULL, 'scan001', '2022-03-10 10:07:01.553', 0);
INSERT INTO `chip` VALUES ('DRV8885PWPR', 2000, NULL, 'scan001', '2022-03-10 10:07:01.583', 0);
INSERT INTO `chip` VALUES ('DRV8885PWPT', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('DRV8886PWPR', 2000, NULL, 'scan001', '2022-03-10 10:07:01.614', 0);
INSERT INTO `chip` VALUES ('DRV8886PWPT', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('DS90LV047ATMTCX/NOPB', 2500, NULL, 'scan001', '2022-03-10 10:07:01.646', 0);
INSERT INTO `chip` VALUES ('DS90LV048ATMTC/NOPB', 92, NULL, 'scan001', '2022-03-10 10:07:01.677', 0);
INSERT INTO `chip` VALUES ('DS90LV048ATMTCX/NOPB', 2500, NULL, 'scan001', '2022-03-10 10:07:01.708', 0);
INSERT INTO `chip` VALUES ('DS90UB914ATRHSJQ1', 2500, NULL, 'scan001', '2022-03-10 10:07:01.739', 0);
INSERT INTO `chip` VALUES ('DS90UB914ATRHSRQ1', 1000, NULL, 'scan001', '2022-03-10 10:07:01.770', 0);
INSERT INTO `chip` VALUES ('DS90UB914ATRHSTQ1', 250, NULL, 'scan001', '2022-03-10 10:07:01.801', 0);
INSERT INTO `chip` VALUES ('DS90UB935TRHBRQ1', 3000, NULL, 'scan001', '2022-03-10 10:07:01.833', 0);
INSERT INTO `chip` VALUES ('DS90UB949TRGCRQ1', 2000, NULL, 'scan001', '2022-03-10 10:07:01.863', 0);
INSERT INTO `chip` VALUES ('DS90UB949TRGCTQ1', 250, NULL, 'scan001', '2022-03-10 10:07:01.894', 0);
INSERT INTO `chip` VALUES ('DS90UB953TRHBRQ1', 3000, NULL, 'scan001', '2022-03-10 10:07:01.925', 0);
INSERT INTO `chip` VALUES ('DS90UB953TRHBTQ1', 250, NULL, 'scan001', '2022-03-10 10:07:01.956', 0);
INSERT INTO `chip` VALUES ('DS90UB954TRGZRQ1', 2500, NULL, 'scan001', '2022-03-10 10:07:01.986', 0);
INSERT INTO `chip` VALUES ('DS90UB962WRTDTQ1', 250, NULL, 'scan001', '2022-03-10 10:07:02.017', 0);
INSERT INTO `chip` VALUES ('HD3SS3212IRKSR', 3000, NULL, 'scan001', '2022-03-16 03:49:42.342', 0);
INSERT INTO `chip` VALUES ('HD3SS3212IRKST', 250, NULL, 'scan001', '2022-03-16 03:49:42.377', 0);
INSERT INTO `chip` VALUES ('HD3SS3212RKSR', 3000, NULL, 'scan001', '2022-03-16 03:49:42.412', 0);
INSERT INTO `chip` VALUES ('HD3SS3212RKSRQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:42.447', 0);
INSERT INTO `chip` VALUES ('HD3SS3212RKST', 250, NULL, 'scan001', '2022-03-16 03:49:42.482', 0);
INSERT INTO `chip` VALUES ('HD3SS3212RKSTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:42.550', 0);
INSERT INTO `chip` VALUES ('HD3SS3220RNHR', 3000, NULL, 'scan001', '2022-03-16 03:49:42.585', 0);
INSERT INTO `chip` VALUES ('HD3SS3220RNHT', 250, NULL, 'scan001', '2022-03-16 03:49:42.619', 0);
INSERT INTO `chip` VALUES ('HD3SS3412RUAR', 3000, NULL, 'scan001', '2022-03-16 03:49:42.655', 0);
INSERT INTO `chip` VALUES ('HD3SS3412RUAT', 250, NULL, 'scan001', '2022-03-16 03:49:42.690', 0);
INSERT INTO `chip` VALUES ('HD3SS3415RUAR', 3000, NULL, 'scan001', '2022-03-16 03:49:42.724', 0);
INSERT INTO `chip` VALUES ('HD3SS3415RUAT', 250, NULL, 'scan001', '2022-03-16 03:49:42.759', 0);
INSERT INTO `chip` VALUES ('HD3SS460RHRR', 3000, NULL, 'scan001', '2022-03-16 03:49:42.794', 0);
INSERT INTO `chip` VALUES ('HD3SS460RHRT', 250, NULL, 'scan001', '2022-03-16 03:49:42.829', 0);
INSERT INTO `chip` VALUES ('HD3SS6126RUAR', 3000, NULL, 'scan001', '2022-03-16 03:49:42.864', 0);
INSERT INTO `chip` VALUES ('INA149AIDR', 2500, NULL, 'scan001', '2022-03-16 03:49:42.898', 0);
INSERT INTO `chip` VALUES ('INA186A1IDCKR', 3000, NULL, 'scan001', '2022-03-16 03:49:42.932', 0);
INSERT INTO `chip` VALUES ('INA193AQDBVRQ1', 3000, '2022-02-14 14:03:40.960', 'scan001', '2022-02-21 03:24:28.591', 0);
INSERT INTO `chip` VALUES ('INA219BIDCNR', 3000, NULL, 'scan001', '2022-03-16 03:49:42.967', 0);
INSERT INTO `chip` VALUES ('INA219BIDCNT', 250, NULL, 'scan001', '2022-03-16 03:49:43.002', 0);
INSERT INTO `chip` VALUES ('INA226AQDGSRQ1', 2500, NULL, 'scan001', '2022-03-16 03:49:43.037', 0);
INSERT INTO `chip` VALUES ('INA230AIRGTR', 3000, NULL, 'scan001', '2022-03-16 03:49:43.072', 0);
INSERT INTO `chip` VALUES ('INA230AIRGTT', 250, NULL, 'scan001', '2022-03-16 03:49:43.107', 0);
INSERT INTO `chip` VALUES ('INA240A2QPWRQ1', 2000, NULL, 'scan001', '2022-03-16 03:49:43.142', 0);
INSERT INTO `chip` VALUES ('INA300AIDGSR', 2500, NULL, 'scan001', '2022-03-16 03:49:43.177', 0);
INSERT INTO `chip` VALUES ('INA300AIDGST', 250, NULL, 'scan001', '2022-03-16 03:49:43.212', 0);
INSERT INTO `chip` VALUES ('ISO1042BDWVR', 1000, NULL, 'scan001', '2022-03-16 03:49:43.247', 0);
INSERT INTO `chip` VALUES ('ISO1042BQDWVRQ1', 1000, NULL, 'scan001', '2022-03-16 03:49:43.282', 0);
INSERT INTO `chip` VALUES ('ISO1042DWR', 2000, NULL, 'scan001', '2022-03-16 03:49:43.317', 0);
INSERT INTO `chip` VALUES ('ISO1042DWVR', 1000, NULL, 'scan001', '2022-03-16 03:49:43.352', 0);
INSERT INTO `chip` VALUES ('ISO1042QDWRQ1', 2000, NULL, 'scan001', '2022-03-16 03:49:43.387', 0);
INSERT INTO `chip` VALUES ('ISO1176TDWR', 2000, NULL, 'scan001', '2022-03-16 03:49:43.421', 0);
INSERT INTO `chip` VALUES ('ISO1212DBQR', 2500, NULL, 'scan001', '2022-03-16 03:49:43.456', 0);
INSERT INTO `chip` VALUES ('ISO1412DWR', 2000, NULL, 'scan001', '2022-03-16 03:49:43.491', 0);
INSERT INTO `chip` VALUES ('ISO1500DBQR', 2500, NULL, 'scan001', '2022-03-16 03:49:43.559', 0);
INSERT INTO `chip` VALUES ('ISO15DWR', 2000, NULL, 'scan001', '2022-03-16 03:49:43.594', 0);
INSERT INTO `chip` VALUES ('ISO3086DWR', 2000, NULL, 'scan001', '2022-03-16 03:49:43.629', 0);
INSERT INTO `chip` VALUES ('ISO3086TDWR', 2000, NULL, 'scan001', '2022-03-16 03:49:43.664', 0);
INSERT INTO `chip` VALUES ('ISO5452QDWRQ1', 2000, NULL, 'scan001', '2022-03-16 03:49:43.700', 0);
INSERT INTO `chip` VALUES ('ISO5500DWR', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('ISO5851QDWRQ1', 2000, NULL, 'scan001', '2022-03-16 03:49:43.735', 0);
INSERT INTO `chip` VALUES ('ISO7140CCDBQR', 2500, NULL, 'scan001', '2022-03-16 03:49:43.770', 0);
INSERT INTO `chip` VALUES ('ISO7140FCCDBQ', 75, NULL, 'scan001', '2022-03-16 03:49:43.806', 0);
INSERT INTO `chip` VALUES ('ISO7220CDR', 2500, NULL, 'scan001', '2022-03-16 03:49:43.841', 0);
INSERT INTO `chip` VALUES ('ISO7720DR', 2500, NULL, 'scan001', '2022-03-16 03:49:43.876', 0);
INSERT INTO `chip` VALUES ('ISO7720FDR', 2500, NULL, 'scan001', '2022-03-16 03:49:43.911', 0);
INSERT INTO `chip` VALUES ('ISO7720QDRQ1', 2500, NULL, 'scan001', '2022-03-16 03:49:43.945', 0);
INSERT INTO `chip` VALUES ('ISO7721DWVR', 1000, NULL, 'scan001', '2022-03-16 03:49:43.981', 0);
INSERT INTO `chip` VALUES ('ISO7721FDWVR', 1000, NULL, 'scan001', '2022-03-16 03:49:44.016', 0);
INSERT INTO `chip` VALUES ('ISO7731FDBQ', 75, NULL, 'scan001', '2022-03-16 03:49:44.052', 0);
INSERT INTO `chip` VALUES ('ISO7731FDBQR', 2500, NULL, 'scan001', '2022-03-16 03:49:44.086', 0);
INSERT INTO `chip` VALUES ('ISO7741DWR', 2000, NULL, 'scan001', '2022-03-16 03:49:44.121', 0);
INSERT INTO `chip` VALUES ('ISO7741FDWR', 2000, NULL, 'scan001', '2022-03-16 03:49:44.155', 0);
INSERT INTO `chip` VALUES ('ISO7741QDWRQ1', 2000, NULL, 'scan001', '2022-03-16 03:49:44.190', 0);
INSERT INTO `chip` VALUES ('ISO7742DBQR', 2500, NULL, 'scan001', '2022-03-16 03:49:44.224', 0);
INSERT INTO `chip` VALUES ('ISO7760FDBQR', 2500, NULL, 'scan001', '2022-03-16 03:49:44.259', 0);
INSERT INTO `chip` VALUES ('LM22672MRE-ADJ/NOPB', 250, NULL, 'scan001', '2022-03-16 03:49:44.293', 0);
INSERT INTO `chip` VALUES ('LM22672MRX-ADJ/NOPB', 2500, NULL, 'scan001', '2022-03-16 03:49:44.328', 0);
INSERT INTO `chip` VALUES ('LM25066IAPSQ/NOPB', 1000, NULL, 'scan001', '2022-03-16 03:49:44.363', 0);
INSERT INTO `chip` VALUES ('LM25066IAPSQE/NOPB', 250, NULL, 'scan001', '2022-03-16 03:49:44.397', 0);
INSERT INTO `chip` VALUES ('LM25066IAPSQX/NOPB', 4500, NULL, 'scan001', '2022-03-16 03:49:44.433', 0);
INSERT INTO `chip` VALUES ('LM25141QRGERQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:44.467', 0);
INSERT INTO `chip` VALUES ('LM25141QRGETQ1', 250, NULL, 'scan001', '2022-03-16 03:49:44.535', 0);
INSERT INTO `chip` VALUES ('LM25141RGER', 3000, NULL, 'scan001', '2022-03-16 03:49:44.570', 0);
INSERT INTO `chip` VALUES ('LM25141RGET', 250, NULL, 'scan001', '2022-03-16 03:49:44.605', 0);
INSERT INTO `chip` VALUES ('LM25145RGYR', 3000, NULL, 'scan001', '2022-03-16 03:49:44.641', 0);
INSERT INTO `chip` VALUES ('LM25145RGYT', 250, NULL, 'scan001', '2022-03-16 03:49:44.676', 0);
INSERT INTO `chip` VALUES ('LM25180QNGURQ1', 4500, NULL, 'scan001', '2022-03-16 03:49:44.711', 0);
INSERT INTO `chip` VALUES ('LM2675MX-5.0/NOPB', 2500, NULL, 'scan001', '2022-03-16 03:49:44.746', 0);
INSERT INTO `chip` VALUES ('LM2775DSGR', 3000, NULL, 'scan001', '2022-03-16 03:49:44.782', 0);
INSERT INTO `chip` VALUES ('LM2775DSGT', 250, NULL, 'scan001', '2022-03-16 03:49:44.817', 0);
INSERT INTO `chip` VALUES ('LM46001PWP', 90, NULL, 'scan001', '2022-03-16 03:49:44.851', 0);
INSERT INTO `chip` VALUES ('LM46001PWPR', 2000, NULL, 'scan001', '2022-03-16 03:49:44.886', 0);
INSERT INTO `chip` VALUES ('LM46001PWPT', 250, NULL, 'scan001', '2022-03-16 03:49:44.921', 0);
INSERT INTO `chip` VALUES ('LM5008SDC/NOPB', 1000, NULL, 'scan001', '2022-03-16 03:49:44.956', 0);
INSERT INTO `chip` VALUES ('LM5008SDCX/NOPB', 4500, NULL, 'scan001', '2022-03-16 03:49:44.991', 0);
INSERT INTO `chip` VALUES ('LM5017SD/NOPB', 1000, NULL, 'scan001', '2022-03-16 03:49:45.027', 0);
INSERT INTO `chip` VALUES ('LM5017SDX/NOPB', 4500, NULL, 'scan001', '2022-03-16 03:49:45.063', 0);
INSERT INTO `chip` VALUES ('LM5117PMHX/NOPB', 2500, NULL, 'scan001', '2022-03-16 03:49:45.098', 0);
INSERT INTO `chip` VALUES ('LM5145RGYR', 3000, NULL, 'scan001', '2022-03-16 03:49:45.133', 0);
INSERT INTO `chip` VALUES ('LM5145RGYT', 250, NULL, 'scan001', '2022-03-16 03:49:45.168', 0);
INSERT INTO `chip` VALUES ('LM5146QRGYRQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:45.203', 0);
INSERT INTO `chip` VALUES ('LM5146QRGYTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:45.237', 0);
INSERT INTO `chip` VALUES ('LM5150QRUMRQ1', 2000, NULL, 'scan001', '2022-03-16 03:49:45.272', 0);
INSERT INTO `chip` VALUES ('LM5150QRUMTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:45.306', 0);
INSERT INTO `chip` VALUES ('LM51551DSSR', 3000, NULL, 'scan001', '2022-03-16 03:49:45.342', 0);
INSERT INTO `chip` VALUES ('LM51551DSST', 250, NULL, 'scan001', '2022-03-16 03:49:45.376', 0);
INSERT INTO `chip` VALUES ('LM5155DSSR', 3000, NULL, 'scan001', '2022-03-16 03:49:45.411', 0);
INSERT INTO `chip` VALUES ('LM5155QDSSRQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:45.446', 0);
INSERT INTO `chip` VALUES ('LM5155QDSSTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:45.481', 0);
INSERT INTO `chip` VALUES ('LM5157QRTERQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:45.550', 0);
INSERT INTO `chip` VALUES ('LM5160DNTJ', 4500, NULL, 'scan001', '2022-03-16 03:49:45.585', 0);
INSERT INTO `chip` VALUES ('LM5160DNTR', 1000, NULL, 'scan001', '2022-03-16 03:49:45.619', 0);
INSERT INTO `chip` VALUES ('LM5160DNTT', 250, NULL, 'scan001', '2022-03-16 03:49:45.655', 0);
INSERT INTO `chip` VALUES ('LM5161QPWPRQ1', 2500, NULL, 'scan001', '2022-03-16 03:49:45.689', 0);
INSERT INTO `chip` VALUES ('LM5161QPWPTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:45.724', 0);
INSERT INTO `chip` VALUES ('LM5165DRCR', 3000, NULL, 'scan001', '2022-03-16 03:49:45.760', 0);
INSERT INTO `chip` VALUES ('LM5165DRCT', 250, NULL, 'scan001', '2022-03-16 03:49:45.794', 0);
INSERT INTO `chip` VALUES ('LM5165XDRCR', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('LM5165XDRCT', 250, NULL, 'scan001', '2022-03-16 03:49:45.830', 0);
INSERT INTO `chip` VALUES ('LM5165YDRCR', 3000, NULL, 'scan001', '2022-03-16 03:49:45.865', 0);
INSERT INTO `chip` VALUES ('LM5165YDRCT', 250, NULL, 'scan001', '2022-03-16 03:49:45.900', 0);
INSERT INTO `chip` VALUES ('LM5165YQDGSRQ1', 2500, NULL, 'scan001', '2022-03-16 03:49:45.936', 0);
INSERT INTO `chip` VALUES ('LM5165YQDGSTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:45.971', 0);
INSERT INTO `chip` VALUES ('LM5166DRCR', 3000, NULL, 'scan001', '2022-03-16 03:49:46.007', 0);
INSERT INTO `chip` VALUES ('LM5166DRCT', 250, NULL, 'scan001', '2022-03-16 03:49:46.042', 0);
INSERT INTO `chip` VALUES ('LM5176QPWPRQ1', 2000, NULL, 'scan001', '2022-03-16 03:49:46.076', 0);
INSERT INTO `chip` VALUES ('LM5176QPWPTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:46.111', 0);
INSERT INTO `chip` VALUES ('LM5180QNGURQ1', 4500, NULL, 'scan001', '2022-03-16 03:49:46.145', 0);
INSERT INTO `chip` VALUES ('LM5180QNGUTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:46.180', 0);
INSERT INTO `chip` VALUES ('LM536013QDSXRQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:46.215', 0);
INSERT INTO `chip` VALUES ('LM536013QDSXTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:46.251', 0);
INSERT INTO `chip` VALUES ('LM61460AFSQRJRRQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:46.285', 0);
INSERT INTO `chip` VALUES ('LM61480QRPHRQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:46.320', 0);
INSERT INTO `chip` VALUES ('LM73605QRNPRQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:46.355', 0);
INSERT INTO `chip` VALUES ('LM73605QRNPTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:46.390', 0);
INSERT INTO `chip` VALUES ('LM73605RNPR', 3000, NULL, 'scan001', '2022-03-16 03:49:46.424', 0);
INSERT INTO `chip` VALUES ('LM73605RNPT', 250, NULL, 'scan001', '2022-03-16 03:49:46.460', 0);
INSERT INTO `chip` VALUES ('LM73606QRNPRQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:46.495', 0);
INSERT INTO `chip` VALUES ('LM73606QRNPTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:46.564', 0);
INSERT INTO `chip` VALUES ('LM73606RNPR', 3000, NULL, 'scan001', '2022-03-16 03:49:46.599', 0);
INSERT INTO `chip` VALUES ('LM73606RNPT', 250, NULL, 'scan001', '2022-03-16 03:49:46.634', 0);
INSERT INTO `chip` VALUES ('LM74700QDBVRQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:46.668', 0);
INSERT INTO `chip` VALUES ('LM74700QDBVTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:46.704', 0);
INSERT INTO `chip` VALUES ('LM76002QRNPRQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:46.738', 0);
INSERT INTO `chip` VALUES ('LM76002QRNPTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:46.773', 0);
INSERT INTO `chip` VALUES ('LM76002RNPR', 3000, NULL, 'scan001', '2022-03-16 03:49:46.810', 0);
INSERT INTO `chip` VALUES ('LM76002RNPT', 250, NULL, 'scan001', '2022-03-16 03:49:46.845', 0);
INSERT INTO `chip` VALUES ('LM76003QRNPRQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:46.880', 0);
INSERT INTO `chip` VALUES ('LM76003QRNPTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:46.915', 0);
INSERT INTO `chip` VALUES ('LM76003RNPR', 3000, NULL, 'scan001', '2022-03-16 03:49:46.949', 0);
INSERT INTO `chip` VALUES ('LM76003RNPT', 250, NULL, 'scan001', '2022-03-16 03:49:46.984', 0);
INSERT INTO `chip` VALUES ('LM76005QRNPRQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:47.019', 0);
INSERT INTO `chip` VALUES ('LMG1025QDEERQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:47.054', 0);
INSERT INTO `chip` VALUES ('LMK1C1104PWR', 2000, NULL, 'scan001', '2022-03-16 03:49:47.089', 0);
INSERT INTO `chip` VALUES ('LMP91000SD/NOPB', 1000, NULL, 'scan001', '2022-03-16 03:49:47.123', 0);
INSERT INTO `chip` VALUES ('LMP91000SDE/NOPB', 250, NULL, 'scan001', '2022-03-16 03:49:47.158', 0);
INSERT INTO `chip` VALUES ('LMP91000SDX/NOPB', 4500, NULL, 'scan001', '2022-03-16 03:49:47.194', 0);
INSERT INTO `chip` VALUES ('LMR23615QDRRRQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:47.230', 0);
INSERT INTO `chip` VALUES ('LMR23615QDRRTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:47.265', 0);
INSERT INTO `chip` VALUES ('LMR23625CDDAR', 2500, NULL, 'scan001', '2022-03-16 03:49:47.300', 0);
INSERT INTO `chip` VALUES ('LMR23630ADDAR', 2500, NULL, 'scan001', '2022-03-16 03:49:47.335', 0);
INSERT INTO `chip` VALUES ('LMR23630AFDDAR', 2500, NULL, 'scan001', '2022-03-16 03:49:47.371', 0);
INSERT INTO `chip` VALUES ('LMR23630AQDDARQ1', 2500, NULL, 'scan001', '2022-03-16 03:49:47.406', 0);
INSERT INTO `chip` VALUES ('LMR23630DRRR', 3000, NULL, 'scan001', '2022-03-16 03:49:47.441', 0);
INSERT INTO `chip` VALUES ('LMR23630DRRT', 250, NULL, 'scan001', '2022-03-16 03:49:47.476', 0);
INSERT INTO `chip` VALUES ('LMR23630FDRRR', 3000, NULL, 'scan001', '2022-03-16 03:49:47.545', 0);
INSERT INTO `chip` VALUES ('LMR23630FDRRT', 250, NULL, 'scan001', '2022-03-16 03:49:47.581', 0);
INSERT INTO `chip` VALUES ('LMR33620ADDAR', 2500, NULL, 'scan001', '2022-03-16 03:49:47.616', 0);
INSERT INTO `chip` VALUES ('LMR33620BDDA', 75, NULL, 'scan001', '2022-03-16 03:49:47.651', 0);
INSERT INTO `chip` VALUES ('LMR33620BDDAR', 2500, NULL, 'scan001', '2022-03-16 03:49:47.687', 0);
INSERT INTO `chip` VALUES ('LMR33620CRNXR', 3000, NULL, 'scan001', '2022-03-16 03:49:47.722', 0);
INSERT INTO `chip` VALUES ('LMR33630BDDAR', 2500, NULL, 'scan001', '2022-03-16 03:49:47.758', 0);
INSERT INTO `chip` VALUES ('LMR33630CDDAR', 2500, NULL, 'scan001', '2022-03-16 03:49:47.794', 0);
INSERT INTO `chip` VALUES ('LMR33640ADDAR', 2500, NULL, 'scan001', '2022-03-16 03:49:47.829', 0);
INSERT INTO `chip` VALUES ('LMR36506RRPER', 3000, NULL, 'scan001', '2022-03-16 03:49:47.864', 0);
INSERT INTO `chip` VALUES ('LMR36510ADDAR', 2500, NULL, 'scan001', '2022-03-16 03:49:47.899', 0);
INSERT INTO `chip` VALUES ('LMR36520ADDAR', 2500, NULL, 'scan001', '2022-03-16 03:49:47.934', 0);
INSERT INTO `chip` VALUES ('LMR36520FADDAR', 2500, NULL, 'scan001', '2022-03-16 03:49:47.969', 0);
INSERT INTO `chip` VALUES ('LMX2594RHAR', 2500, NULL, 'scan001', '2022-03-16 03:49:48.005', 0);
INSERT INTO `chip` VALUES ('LMX2594RHAT', 250, NULL, 'scan001', '2022-03-16 03:49:48.040', 0);
INSERT INTO `chip` VALUES ('LMZ21700SILR', 3000, NULL, 'scan001', '2022-03-16 03:49:48.075', 0);
INSERT INTO `chip` VALUES ('LMZ21700SILT', 250, NULL, 'scan001', '2022-03-16 03:49:48.110', 0);
INSERT INTO `chip` VALUES ('LMZ31520RLGT', 250, NULL, 'scan001', '2022-03-16 03:49:48.145', 0);
INSERT INTO `chip` VALUES ('LMZ31707RVQR', 500, NULL, 'scan001', '2022-03-16 03:49:48.181', 0);
INSERT INTO `chip` VALUES ('LMZ31707RVQT', 250, NULL, 'scan001', '2022-03-16 03:49:48.216', 0);
INSERT INTO `chip` VALUES ('LMZ31710RVQR', 500, NULL, 'scan001', '2022-03-16 03:49:48.252', 0);
INSERT INTO `chip` VALUES ('LMZ31710RVQT', 250, NULL, 'scan001', '2022-03-16 03:49:48.287', 0);
INSERT INTO `chip` VALUES ('LMZ35003RKGR', 500, NULL, 'scan001', '2022-03-16 03:49:48.322', 0);
INSERT INTO `chip` VALUES ('LMZ35003RKGT', 250, NULL, 'scan001', '2022-03-16 03:49:48.357', 0);
INSERT INTO `chip` VALUES ('LMZ36002RVQR', 500, NULL, 'scan001', '2022-03-16 03:49:48.392', 0);
INSERT INTO `chip` VALUES ('LMZ36002RVQT', 250, NULL, 'scan001', '2022-03-16 03:49:48.428', 0);
INSERT INTO `chip` VALUES ('LMZM23600SILR', 3000, NULL, 'scan001', '2022-03-16 03:49:48.463', 0);
INSERT INTO `chip` VALUES ('LMZM23600SILT', 250, NULL, 'scan001', '2022-03-16 03:49:48.498', 0);
INSERT INTO `chip` VALUES ('LMZM23601SILR', 3000, NULL, 'scan001', '2022-03-16 03:49:48.567', 0);
INSERT INTO `chip` VALUES ('LMZM23601SILT', 250, NULL, 'scan001', '2022-03-16 03:49:48.602', 0);
INSERT INTO `chip` VALUES ('LMZM33602RLRR', 500, NULL, 'scan001', '2022-03-16 03:49:48.638', 0);
INSERT INTO `chip` VALUES ('LMZM33603RLRR', 500, NULL, 'scan001', '2022-03-16 03:49:48.674', 0);
INSERT INTO `chip` VALUES ('LMZM33606RLXR', 500, NULL, 'scan001', '2022-03-16 03:49:48.708', 0);
INSERT INTO `chip` VALUES ('LP2951-33DRGR', 3000, NULL, 'scan001', '2022-03-16 03:49:48.743', 0);
INSERT INTO `chip` VALUES ('LP5009RUKR', 3000, NULL, 'scan001', '2022-03-16 03:49:48.778', 0);
INSERT INTO `chip` VALUES ('LP5012RUKR', 3000, NULL, 'scan001', '2022-03-16 03:49:48.814', 0);
INSERT INTO `chip` VALUES ('LP5018RSMR', 3000, NULL, 'scan001', '2022-03-16 03:49:48.849', 0);
INSERT INTO `chip` VALUES ('LP5024RSMR', 3000, NULL, 'scan001', '2022-03-16 03:49:48.884', 0);
INSERT INTO `chip` VALUES ('LP5036RJVR', 3000, NULL, 'scan001', '2022-03-16 03:49:48.919', 0);
INSERT INTO `chip` VALUES ('LP87524JRNFRQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:48.955', 0);
INSERT INTO `chip` VALUES ('LP87524JRNFTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:48.991', 0);
INSERT INTO `chip` VALUES ('LP87702DRHBRQ1', 3000, NULL, 'scan001', '2022-03-16 03:49:49.026', 0);
INSERT INTO `chip` VALUES ('LP87702DRHBTQ1', 250, NULL, 'scan001', '2022-03-16 03:49:49.061', 0);
INSERT INTO `chip` VALUES ('LP8861QPWPRQ1', 2000, NULL, 'scan001', '2022-03-16 03:49:49.096', 0);
INSERT INTO `chip` VALUES ('LP8867CQPWPRQ1', 2000, NULL, 'scan001', '2022-03-16 03:49:49.132', 0);
INSERT INTO `chip` VALUES ('LP8867QPWPRQ1', 2000, NULL, 'scan001', '2022-03-16 03:49:49.167', 0);
INSERT INTO `chip` VALUES ('LP8869CQPWPRQ1', 2000, NULL, 'scan001', '2022-03-16 03:49:49.202', 0);
INSERT INTO `chip` VALUES ('LSF0108RKSR', 3000, NULL, 'scan001', '2022-03-16 03:49:49.237', 0);
INSERT INTO `chip` VALUES ('MAX3243CDBR', 2000, NULL, 'scan001', '2022-03-16 03:49:49.272', 0);
INSERT INTO `chip` VALUES ('MSP430F5247IRGCR', 2000, NULL, 'scan001', '2022-03-16 03:49:49.306', 0);
INSERT INTO `chip` VALUES ('MSP430F5342IRGZ', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('MSP430F5342IRGZR', 2500, NULL, 'scan001', '2022-03-16 03:49:49.341', 0);
INSERT INTO `chip` VALUES ('MSP430F5342IRGZT', 250, NULL, 'scan001', '2022-04-06 02:48:44.764', 0);
INSERT INTO `chip` VALUES ('MSP430F5528IRGCR', 2000, NULL, 'scan001', '2022-04-06 02:48:44.795', 0);
INSERT INTO `chip` VALUES ('MSP430F5528IRGCT', 250, NULL, 'scan001', '2022-04-06 02:48:44.826', 0);
INSERT INTO `chip` VALUES ('OPA171AIDBVR', 3000, NULL, 'scan001', '2022-04-06 02:48:44.856', 0);
INSERT INTO `chip` VALUES ('OPA171AIDBVT', 250, NULL, 'scan001', '2022-04-06 02:48:44.887', 0);
INSERT INTO `chip` VALUES ('OPA171AQDBVRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:44.916', 0);
INSERT INTO `chip` VALUES ('OPA320AIDBVR', 3000, NULL, 'scan001', '2022-04-06 02:48:44.946', 0);
INSERT INTO `chip` VALUES ('OPA320AIDBVT', 250, NULL, 'scan001', '2022-04-06 02:48:44.976', 0);
INSERT INTO `chip` VALUES ('OPA320AQDBVRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:45.007', 0);
INSERT INTO `chip` VALUES ('OPA320AQDBVTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:45.038', 0);
INSERT INTO `chip` VALUES ('OPA365AQDBVRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:45.068', 0);
INSERT INTO `chip` VALUES ('OPA376AQDBVRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:45.098', 0);
INSERT INTO `chip` VALUES ('OPA4376AIPWR', 2000, NULL, 'scan001', '2022-04-06 02:48:45.128', 0);
INSERT INTO `chip` VALUES ('OPT3001IDNPRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:45.158', 0);
INSERT INTO `chip` VALUES ('OPT3001IDNPTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:45.188', 0);
INSERT INTO `chip` VALUES ('OPT3002DNPR', 3000, NULL, 'scan001', '2022-04-06 02:48:45.218', 0);
INSERT INTO `chip` VALUES ('OPT3002DNPT', 250, NULL, 'scan001', '2022-04-06 02:48:45.249', 0);
INSERT INTO `chip` VALUES ('OPT3004DNPR', 3000, NULL, 'scan001', '2022-04-06 02:48:45.279', 0);
INSERT INTO `chip` VALUES ('PCA9548APWR', 2000, NULL, 'scan001', '2022-04-06 02:48:45.309', 0);
INSERT INTO `chip` VALUES ('PCM1803ADBR', 2000, NULL, 'scan001', '2022-04-06 02:48:45.340', 0);
INSERT INTO `chip` VALUES ('PCM1860DBTR', 2000, NULL, 'scan001', '2022-04-06 02:48:45.370', 0);
INSERT INTO `chip` VALUES ('PCM1862DBTR', 2000, NULL, 'scan001', '2022-04-06 02:48:45.399', 0);
INSERT INTO `chip` VALUES ('PGA281AIPWR', 2000, NULL, 'scan001', '2022-04-06 02:48:45.429', 0);
INSERT INTO `chip` VALUES ('PTN78060WAZ', 36, NULL, 'scan001', '2022-04-06 02:48:45.459', 0);
INSERT INTO `chip` VALUES ('PTN78060WAZT', 250, NULL, 'scan001', '2022-04-06 02:48:45.489', 0);
INSERT INTO `chip` VALUES ('SN6505BDBVR', 3000, NULL, 'scan001', '2022-04-06 02:48:45.547', 0);
INSERT INTO `chip` VALUES ('SN6505BQDBVRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:45.578', 0);
INSERT INTO `chip` VALUES ('SN6505BQDBVTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:45.608', 0);
INSERT INTO `chip` VALUES ('SN65C1168EPWR', 2000, NULL, 'scan001', '2022-04-06 02:48:45.638', 0);
INSERT INTO `chip` VALUES ('SN65DSI84TPAPRQ1', 1000, NULL, 'scan001', '2022-04-06 02:48:45.668', 0);
INSERT INTO `chip` VALUES ('SN65HVD3086EDGSR', 2500, NULL, 'scan001', '2022-04-06 02:48:45.699', 0);
INSERT INTO `chip` VALUES ('SN65HVDA540QDR', 2500, NULL, 'scan001', '2022-04-06 02:48:45.729', 0);
INSERT INTO `chip` VALUES ('SN74AUP1T34DCKR', 3000, NULL, 'scan001', '2022-04-06 02:48:45.759', 0);
INSERT INTO `chip` VALUES ('SN74AVC2T244DQER', 5000, NULL, 'scan001', '2022-04-06 02:48:45.790', 0);
INSERT INTO `chip` VALUES ('SN74AVC32T245NMJR', 1000, NULL, 'scan001', '2022-04-06 02:48:45.820', 0);
INSERT INTO `chip` VALUES ('SN75ALS181NSR', 2000, NULL, 'scan001', '2022-04-06 02:48:45.850', 0);
INSERT INTO `chip` VALUES ('TAS2770RJQR', 3000, NULL, 'scan001', '2022-04-06 02:48:45.880', 0);
INSERT INTO `chip` VALUES ('TAS5411QPWPRQ1', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('TAS5731MPHP', 250, NULL, 'scan001', '2022-04-06 02:48:45.910', 0);
INSERT INTO `chip` VALUES ('TAS5731MPHPR', 1000, NULL, 'scan001', '2022-04-06 02:48:45.940', 0);
INSERT INTO `chip` VALUES ('TAS5754MDCAR', 2000, NULL, 'scan001', '2022-04-06 02:48:45.969', 0);
INSERT INTO `chip` VALUES ('TAS5756MDCAR', 2000, NULL, 'scan001', '2022-04-06 02:48:45.999', 0);
INSERT INTO `chip` VALUES ('TAS5766MDCAR', 2000, NULL, 'scan001', '2022-04-06 02:48:46.029', 0);
INSERT INTO `chip` VALUES ('TAS5825MRHBR', 3000, NULL, 'scan001', '2022-04-06 02:48:46.059', 0);
INSERT INTO `chip` VALUES ('TAS5825MRHBT', 250, NULL, 'scan001', '2022-04-06 02:48:46.089', 0);
INSERT INTO `chip` VALUES ('TCA6408ARGTR', 3000, NULL, 'scan001', '2022-04-06 02:48:46.118', 0);
INSERT INTO `chip` VALUES ('TCA6408ARSVR', 3000, NULL, 'scan001', '2022-04-06 02:48:46.148', 0);
INSERT INTO `chip` VALUES ('TCA6416ARTWR', 3000, NULL, 'scan001', '2022-04-06 02:48:46.179', 0);
INSERT INTO `chip` VALUES ('TCA6424ARGJR', 3000, NULL, 'scan001', '2022-04-06 02:48:46.209', 0);
INSERT INTO `chip` VALUES ('TCA9509DGKR', 2500, NULL, 'scan001', '2022-04-06 02:48:46.239', 0);
INSERT INTO `chip` VALUES ('TCA9548ARGER', 3000, NULL, 'scan001', '2022-04-06 02:48:46.269', 0);
INSERT INTO `chip` VALUES ('TCA9548ARGERQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:46.299', 0);
INSERT INTO `chip` VALUES ('TCAN1042GDRQ1', 2500, NULL, 'scan001', '2022-04-06 02:48:46.330', 0);
INSERT INTO `chip` VALUES ('TCAN1042GVDRBRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:46.360', 0);
INSERT INTO `chip` VALUES ('TCAN1042GVDRQ1', 2500, NULL, 'scan001', '2022-04-06 02:48:46.389', 0);
INSERT INTO `chip` VALUES ('TCAN1042HDRQ1', 2500, NULL, 'scan001', '2022-04-06 02:48:46.419', 0);
INSERT INTO `chip` VALUES ('TCAN1042HGVDRBRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:46.449', 0);
INSERT INTO `chip` VALUES ('TCAN1042HGVDRBTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:46.478', 0);
INSERT INTO `chip` VALUES ('TCAN1042HGVDRQ1', 2500, NULL, 'scan001', '2022-04-06 02:48:46.537', 0);
INSERT INTO `chip` VALUES ('TCAN1042HVDRBRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:46.567', 0);
INSERT INTO `chip` VALUES ('TCAN1042HVDRBTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:46.598', 0);
INSERT INTO `chip` VALUES ('TCAN1042VDRBRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:46.628', 0);
INSERT INTO `chip` VALUES ('TCAN1042VDRBTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:46.658', 0);
INSERT INTO `chip` VALUES ('TCAN1043DMTRQ1', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('TCAN1043DMTTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:46.688', 0);
INSERT INTO `chip` VALUES ('TCAN1043GDMTRQ1', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('TCAN1043GDMTTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:46.719', 0);
INSERT INTO `chip` VALUES ('TCAN1051DRBRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:46.749', 0);
INSERT INTO `chip` VALUES ('TCAN1051GVDRBRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:46.779', 0);
INSERT INTO `chip` VALUES ('TCAN1051GVDRBTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:46.809', 0);
INSERT INTO `chip` VALUES ('TCAN1051GVDRQ1', 2500, NULL, 'scan001', '2022-04-06 02:48:46.839', 0);
INSERT INTO `chip` VALUES ('TCAN1051HDRBTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:46.869', 0);
INSERT INTO `chip` VALUES ('TCAN1051HGDR', 2500, NULL, 'scan001', '2022-04-06 02:48:46.899', 0);
INSERT INTO `chip` VALUES ('TCAN1051HGVDRQ1', 2500, NULL, 'scan001', '2022-04-06 02:48:46.929', 0);
INSERT INTO `chip` VALUES ('TCAN1051HGVDTQ1', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('TCAN1051HVDRBRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:46.959', 0);
INSERT INTO `chip` VALUES ('TCAN1051HVDRBTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:46.988', 0);
INSERT INTO `chip` VALUES ('TCAN1051VDRBRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:47.018', 0);
INSERT INTO `chip` VALUES ('TCAN1051VDRBTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:47.048', 0);
INSERT INTO `chip` VALUES ('TCAN1051VDRQ1', 2500, NULL, 'scan001', '2022-04-06 02:48:47.078', 0);
INSERT INTO `chip` VALUES ('TCAN4550RGYR', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('TCAN4550RGYRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:47.108', 0);
INSERT INTO `chip` VALUES ('TCAN4550RGYT', 250, NULL, 'scan001', '2022-04-06 02:48:47.139', 0);
INSERT INTO `chip` VALUES ('THVD1450DRBR', 3000, NULL, 'scan001', '2022-04-06 02:48:47.169', 0);
INSERT INTO `chip` VALUES ('THVD1450DRBT', 250, NULL, 'scan001', '2022-04-06 02:48:47.200', 0);
INSERT INTO `chip` VALUES ('THVD1451DRBR', 3000, NULL, 'scan001', '2022-04-06 02:48:47.230', 0);
INSERT INTO `chip` VALUES ('THVD1451DRBT', 250, NULL, 'scan001', '2022-04-06 02:48:47.260', 0);
INSERT INTO `chip` VALUES ('THVD1510DR', 2500, NULL, 'scan001', '2022-04-06 02:48:47.290', 0);
INSERT INTO `chip` VALUES ('TIC12400QDCPRQ1', 2000, NULL, 'scan001', '2022-04-06 02:48:47.320', 0);
INSERT INTO `chip` VALUES ('TLC59116FIRHBR', 3000, NULL, 'scan001', '2022-04-06 02:48:47.351', 0);
INSERT INTO `chip` VALUES ('TLC59116IRHBR', 3000, NULL, 'scan001', '2022-04-06 02:48:47.381', 0);
INSERT INTO `chip` VALUES ('TLC5947RHBR', 3000, NULL, 'scan001', '2022-04-06 02:48:47.412', 0);
INSERT INTO `chip` VALUES ('TLC5947RHBT', 250, NULL, 'scan001', '2022-04-06 02:48:47.441', 0);
INSERT INTO `chip` VALUES ('TLC6C598QPWRQ1', 2000, NULL, 'scan001', '2022-04-06 02:48:47.471', 0);
INSERT INTO `chip` VALUES ('TLE4275QKTTRQ1', 500, NULL, 'scan001', '2022-04-06 02:48:47.530', 0);
INSERT INTO `chip` VALUES ('TLIN1024RGYRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:47.560', 0);
INSERT INTO `chip` VALUES ('TLIN1024RGYTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:47.590', 0);
INSERT INTO `chip` VALUES ('TLV1702AIRUGR', 3000, NULL, 'scan001', '2022-04-06 02:48:47.619', 0);
INSERT INTO `chip` VALUES ('TLV320ADC5140IRTWR', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('TLV320AIC3106IRGZR', 2500, NULL, 'scan001', '2022-04-06 02:48:47.649', 0);
INSERT INTO `chip` VALUES ('TLV376IDBVR', 3000, NULL, 'scan001', '2022-04-06 02:48:47.679', 0);
INSERT INTO `chip` VALUES ('TLV376IDBVT', 250, NULL, 'scan001', '2022-04-06 02:48:47.708', 0);
INSERT INTO `chip` VALUES ('TLV62085RLTR', 3000, NULL, 'scan001', '2022-04-06 02:48:47.738', 0);
INSERT INTO `chip` VALUES ('TLV62085RLTT', 250, NULL, 'scan001', '2022-04-06 02:48:47.768', 0);
INSERT INTO `chip` VALUES ('TLV62095RGTR', 3000, NULL, 'scan001', '2022-04-06 02:48:47.798', 0);
INSERT INTO `chip` VALUES ('TLV62095RGTT', 250, NULL, 'scan001', '2022-04-06 02:48:47.828', 0);
INSERT INTO `chip` VALUES ('TLV62150RGTR', 3000, NULL, 'scan001', '2022-04-06 02:48:47.858', 0);
INSERT INTO `chip` VALUES ('TLV62569ADRLR', 3000, NULL, 'scan001', '2022-04-06 02:48:47.888', 0);
INSERT INTO `chip` VALUES ('TLV62569ADRLT', 250, NULL, 'scan001', '2022-04-06 02:48:47.918', 0);
INSERT INTO `chip` VALUES ('TLV62569DRLR', 3000, NULL, 'scan001', '2022-04-06 02:48:47.947', 0);
INSERT INTO `chip` VALUES ('TLV62569PDRLR', 3000, NULL, 'scan001', '2022-04-06 02:48:47.977', 0);
INSERT INTO `chip` VALUES ('TLV62585PDRLR', 3000, NULL, 'scan001', '2022-04-06 02:48:48.008', 0);
INSERT INTO `chip` VALUES ('TLV62585PDRLT', 250, NULL, 'scan001', '2022-04-06 02:48:48.038', 0);
INSERT INTO `chip` VALUES ('TLV62585RWTR', 3000, NULL, 'scan001', '2022-04-06 02:48:48.068', 0);
INSERT INTO `chip` VALUES ('TLV62585RWTT', 250, NULL, 'scan001', '2022-04-06 02:48:48.098', 0);
INSERT INTO `chip` VALUES ('TLV70025DDCR', 3000, NULL, 'scan001', '2022-04-06 02:48:48.128', 0);
INSERT INTO `chip` VALUES ('TLV70030QDCKRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:48.158', 0);
INSERT INTO `chip` VALUES ('TLV70518PYFPR', 3000, NULL, 'scan001', '2022-04-06 02:48:48.187', 0);
INSERT INTO `chip` VALUES ('TLV73333PQDRVRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:48.216', 0);
INSERT INTO `chip` VALUES ('TLV75718PDRVR', 3000, NULL, 'scan001', '2022-04-06 02:48:48.246', 0);
INSERT INTO `chip` VALUES ('TLV75733PDRVR', 3000, NULL, 'scan001', '2022-04-06 02:48:48.277', 0);
INSERT INTO `chip` VALUES ('TLV75801PDRVR', 3000, NULL, 'scan001', '2022-04-06 02:48:48.307', 0);
INSERT INTO `chip` VALUES ('TLV75801PDRVT', 250, NULL, 'scan001', '2022-04-06 02:48:48.336', 0);
INSERT INTO `chip` VALUES ('TLV75901PDRVR', 3000, NULL, 'scan001', '2022-04-06 02:48:48.365', 0);
INSERT INTO `chip` VALUES ('TLV75901PDRVT', 250, NULL, 'scan001', '2022-04-06 02:48:48.395', 0);
INSERT INTO `chip` VALUES ('TLV8542RUGR', 3000, NULL, 'scan001', '2022-04-06 02:48:48.425', 0);
INSERT INTO `chip` VALUES ('TLV9002IDGKR', 2500, NULL, 'scan001', '2022-04-06 02:48:48.455', 0);
INSERT INTO `chip` VALUES ('TLV9002IDSGR', 3000, NULL, 'scan001', '2022-04-06 02:48:48.486', 0);
INSERT INTO `chip` VALUES ('TLV9002IDSGT', 250, NULL, 'scan001', '2022-04-06 02:48:48.545', 0);
INSERT INTO `chip` VALUES ('TLV9004IPWR', 2000, NULL, 'scan001', '2022-04-06 02:48:48.575', 0);
INSERT INTO `chip` VALUES ('TLV9061IDPWR', 3000, NULL, 'scan001', '2022-04-06 02:48:48.605', 0);
INSERT INTO `chip` VALUES ('TLV9064IPWR', 2000, NULL, 'scan001', '2022-04-06 02:48:48.635', 0);
INSERT INTO `chip` VALUES ('TLV9064IPWT', 250, NULL, 'scan001', '2022-04-06 02:48:48.665', 0);
INSERT INTO `chip` VALUES ('TLVH431BQDBZR', 3000, NULL, 'scan001', '2022-04-06 02:48:48.695', 0);
INSERT INTO `chip` VALUES ('TLVH431BQDBZT', 250, NULL, 'scan001', '2022-04-06 02:48:48.725', 0);
INSERT INTO `chip` VALUES ('TM4C1290NCPDTI3R', 1000, NULL, 'scan001', '2022-04-06 02:48:48.755', 0);
INSERT INTO `chip` VALUES ('TMDS171IRGZR', 2500, NULL, 'scan001', '2022-04-06 02:48:48.784', 0);
INSERT INTO `chip` VALUES ('TMDS171IRGZT', 250, NULL, 'scan001', '2022-04-06 02:48:48.814', 0);
INSERT INTO `chip` VALUES ('TMDS181IRGZR', 2500, NULL, 'scan001', '2022-04-06 02:48:48.844', 0);
INSERT INTO `chip` VALUES ('TMDS181IRGZT', 250, NULL, 'scan001', '2022-04-06 02:48:48.873', 0);
INSERT INTO `chip` VALUES ('TMDS181RGZR', 2500, NULL, 'scan001', '2022-04-06 02:48:48.903', 0);
INSERT INTO `chip` VALUES ('TMDS181RGZT', 250, NULL, 'scan001', '2022-04-06 02:48:48.933', 0);
INSERT INTO `chip` VALUES ('TMP1075DGKR', 2500, NULL, 'scan001', '2022-04-06 02:48:48.963', 0);
INSERT INTO `chip` VALUES ('TMP1075DGKT', 250, NULL, 'scan001', '2022-04-06 02:48:48.993', 0);
INSERT INTO `chip` VALUES ('TMP1075DR', 2500, NULL, 'scan001', '2022-04-06 02:48:49.023', 0);
INSERT INTO `chip` VALUES ('TMP421AIDCNR', 3000, NULL, 'scan001', '2022-04-06 02:48:49.053', 0);
INSERT INTO `chip` VALUES ('TMP421AIDCNT', 250, NULL, 'scan001', '2022-04-06 02:48:49.083', 0);
INSERT INTO `chip` VALUES ('TMP422AIDCNR', 3000, NULL, 'scan001', '2022-04-06 02:48:49.113', 0);
INSERT INTO `chip` VALUES ('TMP422AIDCNT', 250, NULL, 'scan001', '2022-04-06 02:48:49.143', 0);
INSERT INTO `chip` VALUES ('TMP431ADGKR', 2500, NULL, 'scan001', '2022-04-06 02:48:49.173', 0);
INSERT INTO `chip` VALUES ('TMP432ADGSR', 2500, NULL, 'scan001', '2022-04-06 02:48:49.203', 0);
INSERT INTO `chip` VALUES ('TMP432ADGST', 250, NULL, 'scan001', '2022-04-06 02:48:49.233', 0);
INSERT INTO `chip` VALUES ('TMP461AIRUNT-S', 250, NULL, 'scan001', '2022-04-06 02:48:49.263', 0);
INSERT INTO `chip` VALUES ('TMS320F28069UPZT', 90, NULL, 'scan001', '2022-04-06 02:48:49.293', 0);
INSERT INTO `chip` VALUES ('TMS320F28075PTPQ', 40, NULL, 'scan001', '2022-04-06 02:48:49.322', 0);
INSERT INTO `chip` VALUES ('TMS320F28075PTPT', 40, NULL, 'scan001', '2022-04-06 02:48:49.352', 0);
INSERT INTO `chip` VALUES ('TMS320F2811PBKA', 90, NULL, 'scan001', '2022-04-06 02:48:49.382', 0);
INSERT INTO `chip` VALUES ('TMUX136MRSER', 3000, NULL, 'scan001', '2022-04-06 02:48:49.412', 0);
INSERT INTO `chip` VALUES ('TPA3111D1QPWPRQ1', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('TPA3118D2QDAPRQ1', 2000, NULL, 'scan001', '2022-04-06 02:48:49.442', 0);
INSERT INTO `chip` VALUES ('TPD1S514-1YZR', 3000, NULL, 'scan001', '2022-04-06 02:48:49.472', 0);
INSERT INTO `chip` VALUES ('TPD2EUSB30ADRTR', 3000, NULL, 'scan001', '2022-04-06 02:48:49.530', 0);
INSERT INTO `chip` VALUES ('TPD3F303DQDR', 3000, NULL, 'scan001', '2022-04-06 02:48:49.559', 0);
INSERT INTO `chip` VALUES ('TPD4S014DSQR', 3000, NULL, 'scan001', '2022-04-06 02:48:49.590', 0);
INSERT INTO `chip` VALUES ('TPD6S300ARUKR', 3000, NULL, 'scan001', '2022-04-06 02:48:49.619', 0);
INSERT INTO `chip` VALUES ('TPD8S300RUKR', 3000, NULL, 'scan001', '2022-04-06 02:48:49.649', 0);
INSERT INTO `chip` VALUES ('TPL0102-100RUCR', 3000, NULL, 'scan001', '2022-04-06 02:48:49.680', 0);
INSERT INTO `chip` VALUES ('TPS16630RGER', 3000, NULL, 'scan001', '2022-04-06 02:48:49.710', 0);
INSERT INTO `chip` VALUES ('TPS16630RGET', 250, NULL, 'scan001', '2022-04-06 02:48:49.740', 0);
INSERT INTO `chip` VALUES ('TPS16632RGER', 3000, NULL, 'scan001', '2022-04-06 02:48:49.770', 0);
INSERT INTO `chip` VALUES ('TPS16632RGET', 250, NULL, 'scan001', '2022-04-06 02:48:49.800', 0);
INSERT INTO `chip` VALUES ('TPS1H100AQPWPRQ1', 2000, NULL, 'scan001', '2022-04-06 02:48:49.829', 0);
INSERT INTO `chip` VALUES ('TPS1H100BQPWPRQ1', 2000, NULL, 'scan001', '2022-04-06 02:48:49.859', 0);
INSERT INTO `chip` VALUES ('TPS1H200AQDGNRQ1', 2500, NULL, 'scan001', '2022-04-06 02:48:49.892', 0);
INSERT INTO `chip` VALUES ('TPS2051CDBVR', 3000, NULL, 'scan001', '2022-04-06 02:48:49.922', 0);
INSERT INTO `chip` VALUES ('TPS2051CDBVT', 250, NULL, 'scan001', '2022-04-06 02:48:49.951', 0);
INSERT INTO `chip` VALUES ('TPS2052BDGNR', 2500, NULL, 'scan001', '2022-04-06 02:48:49.981', 0);
INSERT INTO `chip` VALUES ('TPS2052BDRBR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.011', 0);
INSERT INTO `chip` VALUES ('TPS2052BDRBT', 250, NULL, 'scan001', '2022-04-06 02:48:50.040', 0);
INSERT INTO `chip` VALUES ('TPS2052CDGNR', 2500, NULL, 'scan001', '2022-04-06 02:48:50.070', 0);
INSERT INTO `chip` VALUES ('TPS2069DDBVR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.101', 0);
INSERT INTO `chip` VALUES ('TPS2121RUXR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.131', 0);
INSERT INTO `chip` VALUES ('TPS22920YZPR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.161', 0);
INSERT INTO `chip` VALUES ('TPS22920YZPT', 250, NULL, 'scan001', '2022-04-06 02:48:50.191', 0);
INSERT INTO `chip` VALUES ('TPS22922BYZPR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.221', 0);
INSERT INTO `chip` VALUES ('TPS22925BNYPHR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.251', 0);
INSERT INTO `chip` VALUES ('TPS22925BNYPHT', 250, NULL, 'scan001', '2022-04-06 02:48:50.280', 0);
INSERT INTO `chip` VALUES ('TPS22925BYPHR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.310', 0);
INSERT INTO `chip` VALUES ('TPS22925BYPHT', 250, NULL, 'scan001', '2022-04-06 02:48:50.340', 0);
INSERT INTO `chip` VALUES ('TPS22925CNYPHR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.370', 0);
INSERT INTO `chip` VALUES ('TPS22929DDBVR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.400', 0);
INSERT INTO `chip` VALUES ('TPS22929DDBVT', 250, NULL, 'scan001', '2022-04-06 02:48:50.430', 0);
INSERT INTO `chip` VALUES ('TPS22945DCKR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.459', 0);
INSERT INTO `chip` VALUES ('TPS22948DCKR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.489', 0);
INSERT INTO `chip` VALUES ('TPS22953DQCR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.550', 0);
INSERT INTO `chip` VALUES ('TPS22953DSQR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.581', 0);
INSERT INTO `chip` VALUES ('TPS22962DNYR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.613', 0);
INSERT INTO `chip` VALUES ('TPS22962DNYT', 250, NULL, 'scan001', '2022-04-06 02:48:50.645', 0);
INSERT INTO `chip` VALUES ('TPS22965NQWDSGRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:50.676', 0);
INSERT INTO `chip` VALUES ('TPS22965NQWDSGTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:50.707', 0);
INSERT INTO `chip` VALUES ('TPS22965QWDSGRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:50.738', 0);
INSERT INTO `chip` VALUES ('TPS22965QWDSGTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:50.768', 0);
INSERT INTO `chip` VALUES ('TPS22968DPUR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.798', 0);
INSERT INTO `chip` VALUES ('TPS22968DPUT', 250, NULL, 'scan001', '2022-04-06 02:48:50.827', 0);
INSERT INTO `chip` VALUES ('TPS22968NQDMGRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:50.857', 0);
INSERT INTO `chip` VALUES ('TPS22968QDMGRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:50.888', 0);
INSERT INTO `chip` VALUES ('TPS22968QDMGTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:50.918', 0);
INSERT INTO `chip` VALUES ('TPS22969DNYR', 3000, NULL, 'scan001', '2022-04-06 02:48:50.949', 0);
INSERT INTO `chip` VALUES ('TPS22969DNYT', 250, NULL, 'scan001', '2022-04-06 02:48:50.979', 0);
INSERT INTO `chip` VALUES ('TPS22975DSGR', 3000, NULL, 'scan001', '2022-04-06 02:48:51.009', 0);
INSERT INTO `chip` VALUES ('TPS22975DSGT', 250, NULL, 'scan001', '2022-04-06 02:48:51.039', 0);
INSERT INTO `chip` VALUES ('TPS22976NDPUR', 3000, NULL, 'scan001', '2022-04-06 02:48:51.069', 0);
INSERT INTO `chip` VALUES ('TPS22976NDPUT', 250, NULL, 'scan001', '2022-04-06 02:48:51.099', 0);
INSERT INTO `chip` VALUES ('TPS23751PWPR', 2000, NULL, 'scan001', '2022-04-06 02:48:51.129', 0);
INSERT INTO `chip` VALUES ('TPS23754PWPR', 2000, NULL, 'scan001', '2022-04-06 02:48:51.159', 0);
INSERT INTO `chip` VALUES ('TPS2410PWR', 2000, NULL, 'scan001', '2022-04-06 02:48:51.189', 0);
INSERT INTO `chip` VALUES ('TPS2412DR', 2500, NULL, 'scan001', '2022-04-06 02:48:51.219', 0);
INSERT INTO `chip` VALUES ('TPS2412PWR', 2000, NULL, 'scan001', '2022-04-06 02:48:51.249', 0);
INSERT INTO `chip` VALUES ('TPS2421-2DDA', 75, NULL, 'scan001', '2022-04-06 02:48:51.278', 0);
INSERT INTO `chip` VALUES ('TPS2421-2DDAR', 2500, NULL, 'scan001', '2022-04-06 02:48:51.308', 0);
INSERT INTO `chip` VALUES ('TPS24751RUVR', 3000, NULL, 'scan001', '2022-04-06 02:48:51.338', 0);
INSERT INTO `chip` VALUES ('TPS24751RUVT', 250, NULL, 'scan001', '2022-04-06 02:48:51.368', 0);
INSERT INTO `chip` VALUES ('TPS2490DGS', 80, NULL, 'scan001', '2022-04-06 02:48:51.397', 0);
INSERT INTO `chip` VALUES ('TPS2490DGSR', 2500, NULL, 'scan001', '2022-04-06 02:48:51.427', 0);
INSERT INTO `chip` VALUES ('TPS2491DGS', 80, NULL, 'scan001', '2022-04-06 02:48:51.457', 0);
INSERT INTO `chip` VALUES ('TPS2491DGSR', 2500, NULL, 'scan001', '2022-04-06 02:48:51.487', 0);
INSERT INTO `chip` VALUES ('TPS25200DRVR', 3000, NULL, 'scan001', '2022-04-06 02:48:51.546', 0);
INSERT INTO `chip` VALUES ('TPS25200DRVT', 250, NULL, 'scan001', '2022-04-06 02:48:51.576', 0);
INSERT INTO `chip` VALUES ('TPS25221DBVR', 3000, NULL, 'scan001', '2022-04-06 02:48:51.605', 0);
INSERT INTO `chip` VALUES ('TPS25221DBVT', 250, NULL, 'scan001', '2022-04-06 02:48:51.636', 0);
INSERT INTO `chip` VALUES ('TPS2544RTER', 3000, NULL, 'scan001', '2022-04-06 02:48:51.667', 0);
INSERT INTO `chip` VALUES ('TPS2544RTET', 250, NULL, 'scan001', '2022-04-06 02:48:51.698', 0);
INSERT INTO `chip` VALUES ('TPS2552DDBVR', 3000, NULL, 'scan001', '2022-04-06 02:48:51.729', 0);
INSERT INTO `chip` VALUES ('TPS2552DDBVT', 250, NULL, 'scan001', '2022-04-06 02:48:51.759', 0);
INSERT INTO `chip` VALUES ('TPS2552DRVR', 3000, NULL, 'scan001', '2022-04-06 02:48:51.789', 0);
INSERT INTO `chip` VALUES ('TPS2552DRVT', 250, NULL, 'scan001', '2022-04-06 02:48:51.820', 0);
INSERT INTO `chip` VALUES ('TPS2553DBVR-1', 3000, NULL, 'scan001', '2022-04-06 02:48:51.850', 0);
INSERT INTO `chip` VALUES ('TPS2553DBVT', 250, NULL, 'scan001', '2022-04-06 02:48:51.879', 0);
INSERT INTO `chip` VALUES ('TPS2553DDBVR', 3000, NULL, 'scan001', '2022-04-06 02:48:51.910', 0);
INSERT INTO `chip` VALUES ('TPS2553DDBVT', 250, NULL, 'scan001', '2022-04-06 02:48:51.939', 0);
INSERT INTO `chip` VALUES ('TPS2553DRVR-1', 3000, NULL, 'scan001', '2022-04-06 02:48:51.969', 0);
INSERT INTO `chip` VALUES ('TPS2553DRVT-1', 250, NULL, 'scan001', '2022-04-06 02:48:51.999', 0);
INSERT INTO `chip` VALUES ('TPS2556DRBR', 3000, NULL, 'scan001', '2022-04-06 02:48:52.029', 0);
INSERT INTO `chip` VALUES ('TPS2556DRBT', 250, NULL, 'scan001', '2022-04-06 02:48:52.059', 0);
INSERT INTO `chip` VALUES ('TPS2557DRBR', 3000, NULL, 'scan001', '2022-04-06 02:48:52.088', 0);
INSERT INTO `chip` VALUES ('TPS2557DRBT', 250, NULL, 'scan001', '2022-04-06 02:48:52.118', 0);
INSERT INTO `chip` VALUES ('TPS25810RVCR', 3000, NULL, 'scan001', '2022-04-06 02:48:52.148', 0);
INSERT INTO `chip` VALUES ('TPS25810RVCT', 250, NULL, 'scan001', '2022-04-06 02:48:52.178', 0);
INSERT INTO `chip` VALUES ('TPS25840QWRHBRQ1', 3000, NULL, 'scan001', '2022-04-06 02:48:52.208', 0);
INSERT INTO `chip` VALUES ('TPS25840QWRHBTQ1', 250, NULL, 'scan001', '2022-04-06 02:48:52.238', 0);
INSERT INTO `chip` VALUES ('TPS25910RSAR', 3000, NULL, 'scan001', '2022-04-06 02:48:52.268', 0);
INSERT INTO `chip` VALUES ('TPS259231DRCR', 3000, NULL, 'scan001', '2022-04-06 02:48:52.298', 0);
INSERT INTO `chip` VALUES ('TPS259231DRCT', 250, NULL, 'scan001', '2022-04-06 02:48:52.327', 0);
INSERT INTO `chip` VALUES ('TPS259240DRCR', 3000, NULL, 'scan001', '2022-04-06 02:48:52.357', 0);
INSERT INTO `chip` VALUES ('TPS259240DRCT', 250, NULL, 'scan001', '2022-04-06 02:48:52.386', 0);
INSERT INTO `chip` VALUES ('TPS259241DRCR', 3000, NULL, 'scan001', '2022-04-06 02:48:52.416', 0);
INSERT INTO `chip` VALUES ('TPS259241DRCT', 250, NULL, 'scan001', '2022-04-06 02:48:52.446', 0);
INSERT INTO `chip` VALUES ('TPS259250DRCR', 3000, NULL, 'scan001', '2022-04-06 02:48:52.476', 0);
INSERT INTO `chip` VALUES ('TPS259250DRCT', 250, NULL, 'scan001', '2022-04-06 02:48:52.534', 0);
INSERT INTO `chip` VALUES ('TPS259251DRCR', 3000, NULL, 'scan001', '2022-04-06 02:48:52.564', 0);
INSERT INTO `chip` VALUES ('TPS259251DRCT', 250, NULL, 'scan001', '2022-04-06 02:48:52.594', 0);
INSERT INTO `chip` VALUES ('TPS259260DRCR', 3000, NULL, 'scan001', '2022-04-06 02:48:52.624', 0);
INSERT INTO `chip` VALUES ('TPS259260DRCT', 250, NULL, 'scan001', '2022-04-06 02:48:52.654', 0);
INSERT INTO `chip` VALUES ('TPS259261DRCR', 3000, NULL, 'scan001', '2022-04-06 02:48:52.684', 0);
INSERT INTO `chip` VALUES ('TPS259261DRCT', 250, NULL, 'scan001', '2022-04-07 02:30:26.321', 0);
INSERT INTO `chip` VALUES ('TPS259271DRCR', 3000, NULL, 'scan001', '2022-04-07 02:30:26.354', 0);
INSERT INTO `chip` VALUES ('TPS259271DRCT', 250, NULL, 'scan001', '2022-04-07 02:30:26.387', 0);
INSERT INTO `chip` VALUES ('TPS25940ARVCR', 3000, NULL, 'scan001', '2022-04-07 02:30:26.419', 0);
INSERT INTO `chip` VALUES ('TPS25940ARVCT', 250, NULL, 'scan001', '2022-04-07 02:30:26.452', 0);
INSERT INTO `chip` VALUES ('TPS25942ARVCR', 3000, NULL, 'scan001', '2022-04-07 02:30:26.485', 0);
INSERT INTO `chip` VALUES ('TPS25942ARVCT', 250, NULL, 'scan001', '2022-04-07 02:30:26.549', 0);
INSERT INTO `chip` VALUES ('TPS25942LRVCR', 3000, NULL, 'scan001', '2022-04-07 02:30:26.581', 0);
INSERT INTO `chip` VALUES ('TPS25942LRVCT', 250, NULL, 'scan001', '2022-04-07 02:30:26.614', 0);
INSERT INTO `chip` VALUES ('TPS25944ARVCR', 3000, NULL, 'scan001', '2022-04-07 02:30:26.646', 0);
INSERT INTO `chip` VALUES ('TPS25944ARVCT', 250, NULL, 'scan001', '2022-04-07 02:30:26.679', 0);
INSERT INTO `chip` VALUES ('TPS25944LRVCR', 3000, NULL, 'scan001', '2022-04-07 02:30:26.712', 0);
INSERT INTO `chip` VALUES ('TPS25944LRVCT', 250, NULL, 'scan001', '2022-04-07 02:30:26.744', 0);
INSERT INTO `chip` VALUES ('TPS259520DSGR', 3000, NULL, 'scan001', '2022-04-07 02:30:26.776', 0);
INSERT INTO `chip` VALUES ('TPS259520DSGT', 250, NULL, 'scan001', '2022-04-07 02:30:26.810', 0);
INSERT INTO `chip` VALUES ('TPS259521DSGR', 3000, NULL, 'scan001', '2022-04-07 02:30:26.843', 0);
INSERT INTO `chip` VALUES ('TPS259521DSGT', 250, NULL, 'scan001', '2022-04-07 02:30:26.876', 0);
INSERT INTO `chip` VALUES ('TPS259525DSGR', 3000, NULL, 'scan001', '2022-04-07 02:30:26.909', 0);
INSERT INTO `chip` VALUES ('TPS259525DSGT', 250, NULL, 'scan001', '2022-04-07 02:30:26.941', 0);
INSERT INTO `chip` VALUES ('TPS259530DSGR', 3000, NULL, 'scan001', '2022-04-07 02:30:26.974', 0);
INSERT INTO `chip` VALUES ('TPS259530DSGT', 250, NULL, 'scan001', '2022-04-07 02:30:27.007', 0);
INSERT INTO `chip` VALUES ('TPS259531DSGR', 3000, NULL, 'scan001', '2022-04-07 02:30:27.040', 0);
INSERT INTO `chip` VALUES ('TPS259531DSGT', 250, NULL, 'scan001', '2022-04-07 02:30:27.073', 0);
INSERT INTO `chip` VALUES ('TPS259540DSGR', 3000, NULL, 'scan001', '2022-04-07 02:30:27.106', 0);
INSERT INTO `chip` VALUES ('TPS259540DSGT', 250, NULL, 'scan001', '2022-04-07 02:30:27.138', 0);
INSERT INTO `chip` VALUES ('TPS259571DSGR', 3000, NULL, 'scan001', '2022-04-07 02:30:27.171', 0);
INSERT INTO `chip` VALUES ('TPS259571DSGT', 250, NULL, 'scan001', '2022-04-07 02:30:27.204', 0);
INSERT INTO `chip` VALUES ('TPS259802ONRGER', 3000, NULL, 'scan001', '2022-04-07 02:30:27.237', 0);
INSERT INTO `chip` VALUES ('TPS259804ONRGER', 3000, NULL, 'scan001', '2022-04-07 02:30:27.270', 0);
INSERT INTO `chip` VALUES ('TPS259824ONRGER', 3000, NULL, 'scan001', '2022-04-07 02:30:27.304', 0);
INSERT INTO `chip` VALUES ('TPS259827LNRGER', 3000, NULL, 'scan001', '2022-04-07 02:30:27.337', 0);
INSERT INTO `chip` VALUES ('TPS259827ONRGER', 3000, NULL, 'scan001', '2022-04-07 02:30:27.370', 0);
INSERT INTO `chip` VALUES ('TPS259827ONRGET', 250, NULL, 'scan001', '2022-04-07 02:30:27.403', 0);
INSERT INTO `chip` VALUES ('TPS26600PWPR', 2000, NULL, 'scan001', '2022-04-07 02:30:27.436', 0);
INSERT INTO `chip` VALUES ('TPS26600PWPT', 250, NULL, 'scan001', '2022-04-07 02:30:27.468', 0);
INSERT INTO `chip` VALUES ('TPS26600RHFR', 3000, NULL, 'scan001', '2022-04-07 02:30:27.501', 0);
INSERT INTO `chip` VALUES ('TPS26600RHFT', 250, NULL, 'scan001', '2022-04-07 02:30:27.565', 0);
INSERT INTO `chip` VALUES ('TPS26601RHFR', 3000, NULL, 'scan001', '2022-04-07 02:30:27.598', 0);
INSERT INTO `chip` VALUES ('TPS26601RHFT', 250, NULL, 'scan001', '2022-04-07 02:30:27.632', 0);
INSERT INTO `chip` VALUES ('TPS26602PWPR', 2000, NULL, 'scan001', '2022-04-07 02:30:27.665', 0);
INSERT INTO `chip` VALUES ('TPS26602PWPT', 250, NULL, 'scan001', '2022-04-07 02:30:27.698', 0);
INSERT INTO `chip` VALUES ('TPS26630RGER', 3000, NULL, 'scan001', '2022-04-07 02:30:27.730', 0);
INSERT INTO `chip` VALUES ('TPS26630RGET', 250, NULL, 'scan001', '2022-04-07 02:30:27.764', 0);
INSERT INTO `chip` VALUES ('TPS2H160BQPWPRQ1', 2000, NULL, 'scan001', '2022-04-07 02:30:27.797', 0);
INSERT INTO `chip` VALUES ('TPS3420DDRYR', 5000, NULL, 'scan001', '2022-04-07 02:30:27.829', 0);
INSERT INTO `chip` VALUES ('TPS3420DDRYT', 250, NULL, 'scan001', '2022-04-07 02:30:27.861', 0);
INSERT INTO `chip` VALUES ('TPS3422EGDRYR', 5000, NULL, 'scan001', '2022-04-07 02:30:27.894', 0);
INSERT INTO `chip` VALUES ('TPS3422EGDRYT', 250, NULL, 'scan001', '2022-04-07 02:30:27.927', 0);
INSERT INTO `chip` VALUES ('TPS3700DDCR', 3000, NULL, 'scan001', '2022-04-07 02:30:27.960', 0);
INSERT INTO `chip` VALUES ('TPS3700DDCT', 250, NULL, 'scan001', '2022-04-07 02:30:27.993', 0);
INSERT INTO `chip` VALUES ('TPS3700DSER', 3000, NULL, 'scan001', '2022-04-07 02:30:28.026', 0);
INSERT INTO `chip` VALUES ('TPS386000RGPR', 3000, NULL, 'scan001', '2022-04-07 02:30:28.059', 0);
INSERT INTO `chip` VALUES ('TPS386000RGPT', 250, NULL, 'scan001', '2022-04-07 02:30:28.094', 0);
INSERT INTO `chip` VALUES ('TPS3897ADRYR', 5000, NULL, 'scan001', '2022-04-07 02:30:28.128', 0);
INSERT INTO `chip` VALUES ('TPS3897ADRYT', 250, NULL, 'scan001', '2022-04-07 02:30:28.161', 0);
INSERT INTO `chip` VALUES ('TPS3897PDRYR', 5000, NULL, 'scan001', '2022-04-07 02:30:28.195', 0);
INSERT INTO `chip` VALUES ('TPS3897PDRYT', 250, NULL, 'scan001', '2022-04-07 02:30:28.229', 0);
INSERT INTO `chip` VALUES ('TPS40009DGQR', 2500, NULL, 'scan001', '2022-04-07 02:30:28.262', 0);
INSERT INTO `chip` VALUES ('TPS40055PWPR', 2000, NULL, 'scan001', '2022-04-07 02:30:28.295', 0);
INSERT INTO `chip` VALUES ('TPS40304DRCR', 3000, NULL, 'scan001', '2022-04-07 02:30:28.327', 0);
INSERT INTO `chip` VALUES ('TPS40304DRCT', 250, NULL, 'scan001', '2022-04-07 02:30:28.360', 0);
INSERT INTO `chip` VALUES ('TPS4H000AQPWPRQ1', 2000, NULL, 'scan001', '2022-04-07 02:30:28.393', 0);
INSERT INTO `chip` VALUES ('TPS4H160BQPWPRQ1', 2000, NULL, 'scan001', '2022-04-07 02:30:28.426', 0);
INSERT INTO `chip` VALUES ('TPS51200AQDRCRQ1', 3000, NULL, 'scan001', '2022-04-07 02:30:28.459', 0);
INSERT INTO `chip` VALUES ('TPS51200AQDRCTQ1', 250, NULL, 'scan001', '2022-04-07 02:30:28.492', 0);
INSERT INTO `chip` VALUES ('TPS51219RTER', 3000, NULL, 'scan001', '2022-04-07 02:30:28.557', 0);
INSERT INTO `chip` VALUES ('TPS51285BRUKR', 3000, NULL, 'scan001', '2022-04-07 02:30:28.590', 0);
INSERT INTO `chip` VALUES ('TPS51362RVER', 3000, NULL, 'scan001', '2022-04-07 02:30:28.622', 0);
INSERT INTO `chip` VALUES ('TPS51362RVET', 250, NULL, 'scan001', '2022-04-07 02:30:28.656', 0);
INSERT INTO `chip` VALUES ('TPS51367RVER', 3000, NULL, 'scan001', '2022-04-07 02:30:28.688', 0);
INSERT INTO `chip` VALUES ('TPS51367RVET', 250, NULL, 'scan001', '2022-04-07 02:30:28.720', 0);
INSERT INTO `chip` VALUES ('TPS53219ARGTR', 3000, NULL, 'scan001', '2022-04-07 02:30:28.753', 0);
INSERT INTO `chip` VALUES ('TPS53219ARGTT', 250, NULL, 'scan001', '2022-04-07 02:30:28.786', 0);
INSERT INTO `chip` VALUES ('TPS53314RGFR', 3000, NULL, 'scan001', '2022-04-07 02:30:28.819', 0);
INSERT INTO `chip` VALUES ('TPS53315RGFR', 3000, NULL, 'scan001', '2022-04-07 02:30:28.852', 0);
INSERT INTO `chip` VALUES ('TPS53315RGFT', 250, NULL, 'scan001', '2022-04-07 02:30:28.885', 0);
INSERT INTO `chip` VALUES ('TPS53317RGBR', 3000, NULL, 'scan001', '2022-04-07 02:30:28.918', 0);
INSERT INTO `chip` VALUES ('TPS53317RGBT', 250, NULL, 'scan001', '2022-04-07 02:30:28.951', 0);
INSERT INTO `chip` VALUES ('TPS53318DQPR', 2500, NULL, 'scan001', '2022-04-07 02:30:28.984', 0);
INSERT INTO `chip` VALUES ('TPS53318DQPT', 250, NULL, 'scan001', '2022-04-07 02:30:29.018', 0);
INSERT INTO `chip` VALUES ('TPS53319DQPR', 2500, NULL, 'scan001', '2022-04-07 02:30:29.051', 0);
INSERT INTO `chip` VALUES ('TPS53353DQPR', 2500, NULL, 'scan001', '2022-04-07 02:30:29.084', 0);
INSERT INTO `chip` VALUES ('TPS53353DQPT', 250, NULL, 'scan001', '2022-04-07 02:30:29.117', 0);
INSERT INTO `chip` VALUES ('TPS53355DQPR', 2500, NULL, 'scan001', '2022-04-07 02:30:29.150', 0);
INSERT INTO `chip` VALUES ('TPS53355DQPT', 250, NULL, 'scan001', '2022-04-07 02:30:29.183', 0);
INSERT INTO `chip` VALUES ('TPS53513RVER', 3000, NULL, 'scan001', '2022-04-07 02:30:29.215', 0);
INSERT INTO `chip` VALUES ('TPS53513RVET', 250, NULL, 'scan001', '2022-04-07 02:30:29.248', 0);
INSERT INTO `chip` VALUES ('TPS53515ARVER', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('TPS53515RVER', 3000, NULL, 'scan001', '2022-04-07 02:30:29.282', 0);
INSERT INTO `chip` VALUES ('TPS53515RVET', 250, NULL, 'scan001', '2022-04-07 02:30:29.314', 0);
INSERT INTO `chip` VALUES ('TPS53622RSBR', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('TPS53622RSBT', 250, NULL, 'scan001', '2022-04-07 02:30:29.347', 0);
INSERT INTO `chip` VALUES ('TPS53626RSMR', 3000, NULL, 'scan001', '2022-04-07 02:30:29.380', 0);
INSERT INTO `chip` VALUES ('TPS53626RSMT', 250, NULL, 'scan001', '2022-04-07 02:30:29.413', 0);
INSERT INTO `chip` VALUES ('TPS53681RSBR', 3000, NULL, 'scan001', '2022-04-07 02:30:29.446', 0);
INSERT INTO `chip` VALUES ('TPS53915RVER', 3000, NULL, 'scan001', '2022-04-07 02:30:29.479', 0);
INSERT INTO `chip` VALUES ('TPS53915RVET', 250, NULL, 'scan001', '2022-04-07 02:30:29.544', 0);
INSERT INTO `chip` VALUES ('TPS54020RUWR', 3000, NULL, 'scan001', '2022-04-07 02:30:29.578', 0);
INSERT INTO `chip` VALUES ('TPS54020RUWT', 250, NULL, 'scan001', '2022-04-07 02:30:29.611', 0);
INSERT INTO `chip` VALUES ('TPS54040ADGQR', 2500, NULL, 'scan001', '2022-04-07 02:30:29.645', 0);
INSERT INTO `chip` VALUES ('TPS54061QDRBRQ1', 2500, NULL, 'scan001', '2022-04-07 02:30:29.678', 0);
INSERT INTO `chip` VALUES ('TPS54061QDRBTQ1', 250, NULL, 'scan001', '2022-04-07 02:30:29.711', 0);
INSERT INTO `chip` VALUES ('TPS54116QRTWRQ1', 3000, NULL, 'scan001', '2022-04-07 02:30:29.744', 0);
INSERT INTO `chip` VALUES ('TPS54116QRTWTQ1', 250, NULL, 'scan001', '2022-04-07 02:30:29.777', 0);
INSERT INTO `chip` VALUES ('TPS54140ADGQR', 2500, NULL, 'scan001', '2022-04-07 02:30:29.810', 0);
INSERT INTO `chip` VALUES ('TPS54140DGQR', 2500, NULL, 'scan001', '2022-04-07 02:30:29.844', 0);
INSERT INTO `chip` VALUES ('TPS54218RTER', 3000, NULL, 'scan001', '2022-04-07 02:30:29.878', 0);
INSERT INTO `chip` VALUES ('TPS54228DDAR', 2500, NULL, 'scan001', '2022-04-07 02:30:29.912', 0);
INSERT INTO `chip` VALUES ('TPS54260DRCR', 3000, NULL, 'scan001', '2022-04-07 02:30:29.945', 0);
INSERT INTO `chip` VALUES ('TPS54260DRCT', 250, NULL, 'scan001', '2022-04-07 02:30:29.979', 0);
INSERT INTO `chip` VALUES ('TPS54308DDCR', 3000, NULL, 'scan001', '2022-04-07 02:30:30.012', 0);
INSERT INTO `chip` VALUES ('TPS54308DDCT', 250, NULL, 'scan001', '2022-04-07 02:30:30.045', 0);
INSERT INTO `chip` VALUES ('TPS54320RHLR', 3000, NULL, 'scan001', '2022-04-07 02:30:30.078', 0);
INSERT INTO `chip` VALUES ('TPS54326RGTR', 3000, NULL, 'scan001', '2022-04-07 02:30:30.111', 0);
INSERT INTO `chip` VALUES ('TPS54326RGTT', 250, NULL, 'scan001', '2022-04-07 02:30:30.144', 0);
INSERT INTO `chip` VALUES ('TPS54335ADDAR', 2500, NULL, 'scan001', '2022-04-07 02:30:30.177', 0);
INSERT INTO `chip` VALUES ('TPS54336ADDAR', 2500, NULL, 'scan001', '2022-04-07 02:30:30.209', 0);
INSERT INTO `chip` VALUES ('TPS54340BDDAR', 2500, NULL, 'scan001', '2022-04-07 02:30:30.242', 0);
INSERT INTO `chip` VALUES ('TPS543820RPYR', 3000, NULL, 'scan001', '2022-04-07 02:30:30.275', 0);
INSERT INTO `chip` VALUES ('TPS54394PWPR', 2000, NULL, 'scan001', '2022-04-07 02:30:30.308', 0);
INSERT INTO `chip` VALUES ('TPS543C20RVFR', 2500, NULL, 'scan001', '2022-04-07 02:30:30.340', 0);
INSERT INTO `chip` VALUES ('TPS543C20RVFT', 250, NULL, 'scan001', '2022-04-07 02:30:30.373', 0);
INSERT INTO `chip` VALUES ('TPS54424RNVR', 3000, NULL, 'scan001', '2022-04-07 02:30:30.407', 0);
INSERT INTO `chip` VALUES ('TPS54424RNVT', 250, NULL, 'scan001', '2022-04-07 02:30:30.440', 0);
INSERT INTO `chip` VALUES ('TPS544B20RVFR', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('TPS544B20RVFT', 250, NULL, 'scan001', '2022-04-07 02:30:30.473', 0);
INSERT INTO `chip` VALUES ('TPS544C20RVFR', 2500, NULL, 'scan001', '2022-02-21 03:24:16.445', 0);
INSERT INTO `chip` VALUES ('TPS544C20RVFT', 250, NULL, 'scan001', '2022-02-21 03:24:16.479', 0);
INSERT INTO `chip` VALUES ('TPS54525PWPR', 2000, NULL, 'scan001', '2022-02-21 03:24:16.545', 0);
INSERT INTO `chip` VALUES ('TPS54550PWPR', 2000, NULL, 'scan001', '2022-02-21 03:24:16.579', 0);
INSERT INTO `chip` VALUES ('TPS54618RTER', 3000, NULL, 'scan001', '2022-02-21 03:24:16.613', 0);
INSERT INTO `chip` VALUES ('TPS54618RTET', 250, NULL, 'scan001', '2022-02-21 03:24:16.647', 0);
INSERT INTO `chip` VALUES ('TPS54627DDAR', 2500, NULL, 'scan001', '2022-02-21 03:24:16.680', 0);
INSERT INTO `chip` VALUES ('TPS546D24ARVFR', 2500, NULL, 'scan001', '2022-02-21 03:24:16.714', 0);
INSERT INTO `chip` VALUES ('TPS54824RNVR', 3000, NULL, 'scan001', '2022-02-21 03:24:16.748', 0);
INSERT INTO `chip` VALUES ('TPS54824RNVT', 250, NULL, 'scan001', '2022-02-21 03:24:16.782', 0);
INSERT INTO `chip` VALUES ('TPS548A20RVER', 2500, NULL, 'scan001', '2022-02-21 03:24:16.815', 0);
INSERT INTO `chip` VALUES ('TPS548A20RVET', 250, NULL, 'scan001', '2022-02-21 03:24:16.849', 0);
INSERT INTO `chip` VALUES ('TPS548D22RVFR', 2500, NULL, 'scan001', '2022-02-21 03:24:16.883', 0);
INSERT INTO `chip` VALUES ('TPS548D22RVFT', 250, NULL, 'scan001', '2022-02-21 03:24:16.917', 0);
INSERT INTO `chip` VALUES ('TPS54A24RTWR', 3000, NULL, 'scan001', '2022-02-21 03:24:16.950', 0);
INSERT INTO `chip` VALUES ('TPS552882QRPMRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:16.984', 0);
INSERT INTO `chip` VALUES ('TPS560430X3FDBVR', 3000, NULL, 'scan001', '2022-02-21 03:24:17.018', 0);
INSERT INTO `chip` VALUES ('TPS560430X3FDBVT', 250, NULL, 'scan001', '2022-02-21 03:24:17.052', 0);
INSERT INTO `chip` VALUES ('TPS560430XDBVR', 3000, NULL, 'scan001', '2022-02-21 03:24:17.085', 0);
INSERT INTO `chip` VALUES ('TPS560430XDBVT', 250, NULL, 'scan001', '2022-02-21 03:24:17.118', 0);
INSERT INTO `chip` VALUES ('TPS560430XFDBVR', 3000, NULL, 'scan001', '2022-02-21 03:24:17.152', 0);
INSERT INTO `chip` VALUES ('TPS560430XFDBVT', 250, NULL, 'scan001', '2022-02-21 03:24:17.185', 0);
INSERT INTO `chip` VALUES ('TPS560430YDBVR', 3000, NULL, 'scan001', '2022-02-21 03:24:17.219', 0);
INSERT INTO `chip` VALUES ('TPS560430YDBVT', 250, NULL, 'scan001', '2022-02-21 03:24:17.252', 0);
INSERT INTO `chip` VALUES ('TPS560430YFQDBVRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:17.285', 0);
INSERT INTO `chip` VALUES ('TPS560430YQDBVRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:17.318', 0);
INSERT INTO `chip` VALUES ('TPS56121DQPR', 2500, NULL, 'scan001', '2022-02-21 03:24:17.351', 0);
INSERT INTO `chip` VALUES ('TPS56121DQPT', 250, NULL, 'scan001', '2022-02-21 03:24:17.384', 0);
INSERT INTO `chip` VALUES ('TPS562219ADDFR', 3000, NULL, 'scan001', '2022-02-21 03:24:17.418', 0);
INSERT INTO `chip` VALUES ('TPS562219ADDFT', 250, NULL, 'scan001', '2022-02-21 03:24:17.452', 0);
INSERT INTO `chip` VALUES ('TPS563210ADDFR', 3000, NULL, 'scan001', '2022-02-21 03:24:17.486', 0);
INSERT INTO `chip` VALUES ('TPS563210ADDFT', 250, NULL, 'scan001', '2022-02-21 03:24:17.551', 0);
INSERT INTO `chip` VALUES ('TPS563219ADDFR', 3000, NULL, 'scan001', '2022-02-21 03:24:17.585', 0);
INSERT INTO `chip` VALUES ('TPS563219ADDFT', 250, NULL, 'scan001', '2022-02-21 03:24:17.618', 0);
INSERT INTO `chip` VALUES ('TPS563249DDCR', 3000, NULL, 'scan001', '2022-02-21 03:24:17.651', 0);
INSERT INTO `chip` VALUES ('TPS563249DDCT', 250, NULL, 'scan001', '2022-02-21 03:24:17.685', 0);
INSERT INTO `chip` VALUES ('TPS56339DDCR', 3000, NULL, 'scan001', '2022-02-21 03:24:17.719', 0);
INSERT INTO `chip` VALUES ('TPS56339DDCT', 250, NULL, 'scan001', '2022-02-21 03:24:17.753', 0);
INSERT INTO `chip` VALUES ('TPS564208DDCR', 3000, NULL, 'scan001', '2022-02-21 03:24:17.786', 0);
INSERT INTO `chip` VALUES ('TPS564208DDCT', 250, NULL, 'scan001', '2022-02-21 03:24:17.820', 0);
INSERT INTO `chip` VALUES ('TPS56528DDAR', 2500, NULL, 'scan001', '2022-02-21 03:24:17.854', 0);
INSERT INTO `chip` VALUES ('TPS56628DDAR', 2500, NULL, 'scan001', '2022-02-21 03:24:17.887', 0);
INSERT INTO `chip` VALUES ('TPS56637RPAR', 3000, NULL, 'scan001', '2022-02-21 03:24:17.921', 0);
INSERT INTO `chip` VALUES ('TPS56C20PWPR', 2000, NULL, 'scan001', '2022-02-21 03:24:17.954', 0);
INSERT INTO `chip` VALUES ('TPS56C230RJER', 3000, NULL, 'scan001', '2022-02-21 03:24:17.988', 0);
INSERT INTO `chip` VALUES ('TPS57040QDGQRQ1', 2500, NULL, 'scan001', '2022-02-21 03:24:18.021', 0);
INSERT INTO `chip` VALUES ('TPS57140QDGQRQ1', 2500, NULL, 'scan001', '2022-02-21 03:24:18.054', 0);
INSERT INTO `chip` VALUES ('TPS59632QRHBRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:18.088', 0);
INSERT INTO `chip` VALUES ('TPS59632QRHBTQ1', 250, NULL, 'scan001', '2022-02-21 03:24:18.121', 0);
INSERT INTO `chip` VALUES ('TPS59641RSLR', 2500, NULL, 'scan001', '2022-02-21 03:24:18.154', 0);
INSERT INTO `chip` VALUES ('TPS59641RSLT', 250, NULL, 'scan001', '2022-02-21 03:24:18.188', 0);
INSERT INTO `chip` VALUES ('TPS61025DRCR', 3000, NULL, 'scan001', '2022-02-21 03:24:18.221', 0);
INSERT INTO `chip` VALUES ('TPS61087QDRCRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:18.254', 0);
INSERT INTO `chip` VALUES ('TPS610997YFFR', 3000, NULL, 'scan001', '2022-02-21 03:24:18.287', 0);
INSERT INTO `chip` VALUES ('TPS610997YFFT', 250, NULL, 'scan001', '2022-02-21 03:24:18.320', 0);
INSERT INTO `chip` VALUES ('TPS61161QDRVRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:18.354', 0);
INSERT INTO `chip` VALUES ('TPS61170QDRVRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:18.387', 0);
INSERT INTO `chip` VALUES ('TPS61175PWPR', 2000, NULL, 'scan001', '2022-02-21 03:24:18.421', 0);
INSERT INTO `chip` VALUES ('TPS611781RNWR', 3000, NULL, 'scan001', '2022-02-21 03:24:18.455', 0);
INSERT INTO `chip` VALUES ('TPS611781RNWT', 250, NULL, 'scan001', '2022-02-21 03:24:18.489', 0);
INSERT INTO `chip` VALUES ('TPS61193PWPR', 2000, NULL, 'scan001', '2022-02-21 03:24:18.555', 0);
INSERT INTO `chip` VALUES ('TPS61194PWPR', 2000, NULL, 'scan001', '2022-02-21 03:24:18.589', 0);
INSERT INTO `chip` VALUES ('TPS61221DCKR', 3000, NULL, 'scan001', '2022-02-21 03:24:18.622', 0);
INSERT INTO `chip` VALUES ('TPS61221DCKT', 250, NULL, 'scan001', '2022-02-21 03:24:18.656', 0);
INSERT INTO `chip` VALUES ('TPS62088YFPR', 3000, NULL, 'scan001', '2022-02-21 03:24:18.689', 0);
INSERT INTO `chip` VALUES ('TPS62088YFPT', 250, NULL, 'scan001', '2022-02-21 03:24:18.723', 0);
INSERT INTO `chip` VALUES ('TPS62088YWCR', 3000, NULL, 'scan001', '2022-02-21 03:24:18.758', 0);
INSERT INTO `chip` VALUES ('TPS62095RGTR', 3000, NULL, 'scan001', '2022-02-21 03:24:18.792', 0);
INSERT INTO `chip` VALUES ('TPS62095RGTT', 250, NULL, 'scan001', '2022-02-21 03:24:18.826', 0);
INSERT INTO `chip` VALUES ('TPS62097RWKR', 3000, NULL, 'scan001', '2022-02-21 03:24:18.859', 0);
INSERT INTO `chip` VALUES ('TPS62097RWKT', 250, NULL, 'scan001', '2022-02-21 03:24:18.892', 0);
INSERT INTO `chip` VALUES ('TPS62110RSAR', 3000, NULL, 'scan001', '2022-02-21 03:24:18.926', 0);
INSERT INTO `chip` VALUES ('TPS62125DSGR', 3000, NULL, 'scan001', '2022-02-21 03:24:18.960', 0);
INSERT INTO `chip` VALUES ('TPS62125DSGT', 250, NULL, 'scan001', '2022-02-21 03:24:18.993', 0);
INSERT INTO `chip` VALUES ('TPS62130AQRGTRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:19.027', 0);
INSERT INTO `chip` VALUES ('TPS62130AQRGTTQ1', 250, NULL, 'scan001', '2022-02-21 03:24:19.063', 0);
INSERT INTO `chip` VALUES ('TPS62135RGXR', 3000, NULL, 'scan001', '2022-02-21 03:24:19.096', 0);
INSERT INTO `chip` VALUES ('TPS621361RGXR', 3000, NULL, 'scan001', '2022-02-21 03:24:19.132', 0);
INSERT INTO `chip` VALUES ('TPS621361RGXT', 250, NULL, 'scan001', '2022-02-21 03:24:19.165', 0);
INSERT INTO `chip` VALUES ('TPS62140ARGTR', 3000, NULL, 'scan001', '2022-02-21 03:24:19.199', 0);
INSERT INTO `chip` VALUES ('TPS62140ARGTT', 250, NULL, 'scan001', '2022-02-21 03:24:19.233', 0);
INSERT INTO `chip` VALUES ('TPS62140RGTR', 3000, NULL, 'scan001', '2022-02-21 03:24:19.266', 0);
INSERT INTO `chip` VALUES ('TPS62140RGTT', 250, NULL, 'scan001', '2022-02-21 03:24:19.300', 0);
INSERT INTO `chip` VALUES ('TPS62142RGTR', 3000, NULL, 'scan001', '2022-02-21 03:24:19.335', 0);
INSERT INTO `chip` VALUES ('TPS62142RGTT', 250, NULL, 'scan001', '2022-02-21 03:24:19.368', 0);
INSERT INTO `chip` VALUES ('TPS62143RGTR', 3000, NULL, 'scan001', '2022-02-21 03:24:19.402', 0);
INSERT INTO `chip` VALUES ('TPS62143RGTT', 250, NULL, 'scan001', '2022-02-21 03:24:19.436', 0);
INSERT INTO `chip` VALUES ('TPS62148RGXR', 3000, NULL, 'scan001', '2022-02-21 03:24:19.470', 0);
INSERT INTO `chip` VALUES ('TPS62148RGXT', 250, NULL, 'scan001', '2022-02-21 03:24:19.536', 0);
INSERT INTO `chip` VALUES ('TPS62163DSGR', 3000, NULL, 'scan001', '2022-02-21 03:24:19.570', 0);
INSERT INTO `chip` VALUES ('TPS62163DSGT', 250, NULL, 'scan001', '2022-02-21 03:24:19.604', 0);
INSERT INTO `chip` VALUES ('TPS62170DSGR', 3000, NULL, 'scan001', '2022-02-21 03:24:19.637', 0);
INSERT INTO `chip` VALUES ('TPS62170DSGT', 250, NULL, 'scan001', '2022-02-21 03:24:19.671', 0);
INSERT INTO `chip` VALUES ('TPS62170QDSGRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:19.705', 0);
INSERT INTO `chip` VALUES ('TPS62170QDSGTQ1', 250, NULL, 'scan001', '2022-02-21 03:24:19.739', 0);
INSERT INTO `chip` VALUES ('TPS62172DSGR', 3000, NULL, 'scan001', '2022-02-21 03:24:19.773', 0);
INSERT INTO `chip` VALUES ('TPS62172DSGT', 250, NULL, 'scan001', '2022-02-21 03:24:19.807', 0);
INSERT INTO `chip` VALUES ('TPS62175DQCR', 3000, NULL, 'scan001', '2022-02-21 03:24:19.841', 0);
INSERT INTO `chip` VALUES ('TPS62175DQCT', 250, NULL, 'scan001', '2022-02-21 03:24:19.875', 0);
INSERT INTO `chip` VALUES ('TPS62177DQCR', 3000, NULL, 'scan001', '2022-02-21 03:24:19.908', 0);
INSERT INTO `chip` VALUES ('TPS62237DRYR', 5000, NULL, 'scan001', '2022-02-21 03:24:19.942', 0);
INSERT INTO `chip` VALUES ('TPS62237DRYT', 250, NULL, 'scan001', '2022-02-21 03:24:19.976', 0);
INSERT INTO `chip` VALUES ('TPS62260DDCR', 3000, NULL, 'scan001', '2022-02-21 03:24:20.009', 0);
INSERT INTO `chip` VALUES ('TPS62262TDRVRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:20.043', 0);
INSERT INTO `chip` VALUES ('TPS62290DRVR', 3000, NULL, 'scan001', '2022-02-21 03:24:20.077', 0);
INSERT INTO `chip` VALUES ('TPS62290DRVT', 250, NULL, 'scan001', '2022-02-21 03:24:20.111', 0);
INSERT INTO `chip` VALUES ('TPS62293DRVR', 3000, NULL, 'scan001', '2022-02-21 03:24:20.151', 0);
INSERT INTO `chip` VALUES ('TPS62293DRVT', 250, NULL, 'scan001', '2022-02-21 03:24:20.184', 0);
INSERT INTO `chip` VALUES ('TPS62480RNCR', 3000, NULL, 'scan001', '2022-02-21 03:24:20.218', 0);
INSERT INTO `chip` VALUES ('TPS62480RNCT', 250, NULL, 'scan001', '2022-02-21 03:24:20.253', 0);
INSERT INTO `chip` VALUES ('TPS62745DSSR', 3000, NULL, 'scan001', '2022-02-21 03:24:20.287', 0);
INSERT INTO `chip` VALUES ('TPS62745DSST', 250, NULL, 'scan001', '2022-02-21 03:24:20.320', 0);
INSERT INTO `chip` VALUES ('TPS62801YKAR', 3000, NULL, 'scan001', '2022-02-21 03:24:20.354', 0);
INSERT INTO `chip` VALUES ('TPS62801YKAT', 250, NULL, 'scan001', '2022-02-21 03:24:20.388', 0);
INSERT INTO `chip` VALUES ('TPS62802YKAR', 3000, NULL, 'scan001', '2022-02-21 03:24:20.423', 0);
INSERT INTO `chip` VALUES ('TPS6281020QWRWYRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:20.456', 0);
INSERT INTO `chip` VALUES ('TPS62810QWRWYRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:20.490', 0);
INSERT INTO `chip` VALUES ('TPS6281220QWRWYRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:20.555', 0);
INSERT INTO `chip` VALUES ('TPS62812QWRWYRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:20.589', 0);
INSERT INTO `chip` VALUES ('TPS6281320QWRWYRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:20.622', 0);
INSERT INTO `chip` VALUES ('TPS62813QWRWYRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:20.659', 0);
INSERT INTO `chip` VALUES ('TPS62821DLCR', 3000, NULL, 'scan001', '2022-02-21 03:24:20.694', 0);
INSERT INTO `chip` VALUES ('TPS62821DLCT', 250, NULL, 'scan001', '2022-02-21 03:24:20.727', 0);
INSERT INTO `chip` VALUES ('TPS62826DMQR', 3000, NULL, 'scan001', '2022-02-21 03:24:20.761', 0);
INSERT INTO `chip` VALUES ('TPS62827DMQR', 3000, NULL, 'scan001', '2022-02-21 03:24:20.795', 0);
INSERT INTO `chip` VALUES ('TPS62827DMQT', 250, NULL, 'scan001', '2022-02-21 03:24:20.829', 0);
INSERT INTO `chip` VALUES ('TPS63020DSJR', 3000, NULL, 'scan001', '2022-02-21 03:24:20.862', 0);
INSERT INTO `chip` VALUES ('TPS63020DSJT', 250, NULL, 'scan001', '2022-02-21 03:24:20.896', 0);
INSERT INTO `chip` VALUES ('TPS63030DSKR', 3000, NULL, 'scan001', '2022-02-21 03:24:20.930', 0);
INSERT INTO `chip` VALUES ('TPS63030DSKT', 250, NULL, 'scan001', '2022-02-21 03:24:20.964', 0);
INSERT INTO `chip` VALUES ('TPS63031DSKR', 3000, NULL, 'scan001', '2022-02-21 03:24:20.998', 0);
INSERT INTO `chip` VALUES ('TPS63031DSKT', 250, NULL, 'scan001', '2022-02-21 03:24:21.032', 0);
INSERT INTO `chip` VALUES ('TPS63805YFFR', 3000, NULL, 'scan001', '2022-02-21 03:24:21.066', 0);
INSERT INTO `chip` VALUES ('TPS63806YFFR', 3000, NULL, 'scan001', '2022-02-21 03:24:21.100', 0);
INSERT INTO `chip` VALUES ('TPS65132WRVCR', 3000, NULL, 'scan001', '2022-02-21 03:24:21.140', 0);
INSERT INTO `chip` VALUES ('TPS65145PWPR', 2000, NULL, 'scan001', '2022-02-21 03:24:21.180', 0);
INSERT INTO `chip` VALUES ('TPS65145PWPT', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('TPS65217BRSLR', 2500, NULL, 'scan001', '2022-02-21 03:24:21.213', 0);
INSERT INTO `chip` VALUES ('TPS65217BRSLT', 250, NULL, 'scan001', '2022-02-21 03:24:21.247', 0);
INSERT INTO `chip` VALUES ('TPS65217CRSLR', 2500, NULL, 'scan001', '2022-02-21 03:24:21.281', 0);
INSERT INTO `chip` VALUES ('TPS65217CRSLT', 250, NULL, 'scan001', '2022-02-21 03:24:21.315', 0);
INSERT INTO `chip` VALUES ('TPS65217DRSLR', 2500, NULL, 'scan001', '2022-02-21 03:24:21.348', 0);
INSERT INTO `chip` VALUES ('TPS65217DRSLT', 250, NULL, 'scan001', '2022-02-21 03:24:21.382', 0);
INSERT INTO `chip` VALUES ('TPS65218D0PHPR', 1000, NULL, 'scan001', '2022-02-21 03:24:21.416', 0);
INSERT INTO `chip` VALUES ('TPS65218D0PHPT', 250, NULL, 'scan001', '2022-02-21 03:24:21.450', 0);
INSERT INTO `chip` VALUES ('TPS65261-1RHBR', 3000, NULL, 'scan001', '2022-02-21 03:24:21.483', 0);
INSERT INTO `chip` VALUES ('TPS65261-1RHBT', 250, NULL, 'scan001', '2022-02-21 03:24:21.552', 0);
INSERT INTO `chip` VALUES ('TPS65310AQRVJRQ1', 2000, NULL, 'scan001', '2022-02-21 03:24:21.585', 0);
INSERT INTO `chip` VALUES ('TPS65381AQDAPRQ1', 2000, NULL, 'scan001', '2022-02-21 03:24:21.619', 0);
INSERT INTO `chip` VALUES ('TPS65381AQDAPTQ1', 250, NULL, 'scan001', '2022-02-21 03:24:21.652', 0);
INSERT INTO `chip` VALUES ('TPS65381QDAPRQ1', 2000, NULL, 'scan001', '2022-02-21 03:24:21.686', 0);
INSERT INTO `chip` VALUES ('TPS65910A31A1RSLR', 2500, NULL, 'scan001', '2022-02-21 03:24:21.720', 0);
INSERT INTO `chip` VALUES ('TPS65910A31A1RSLT', 250, NULL, 'scan001', '2022-02-21 03:24:21.754', 0);
INSERT INTO `chip` VALUES ('TPS65910A3A1RSLR', 2500, NULL, 'scan001', '2022-02-21 03:24:21.788', 0);
INSERT INTO `chip` VALUES ('TPS65987DDJRSHR', 2500, NULL, 'scan001', '2022-02-21 03:24:21.821', 0);
INSERT INTO `chip` VALUES ('TPS70933QDBVRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:21.855', 0);
INSERT INTO `chip` VALUES ('TPS70950DBVR', 3000, NULL, 'scan001', '2022-02-21 03:24:21.888', 0);
INSERT INTO `chip` VALUES ('TPS70950DBVT', 250, NULL, 'scan001', '2022-02-21 03:24:21.922', 0);
INSERT INTO `chip` VALUES ('TPS70950QDBVRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:21.956', 0);
INSERT INTO `chip` VALUES ('TPS70950QDRVRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:21.990', 0);
INSERT INTO `chip` VALUES ('TPS71750QDSERQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:22.023', 0);
INSERT INTO `chip` VALUES ('TPS72012DRVR', 3000, NULL, 'scan001', '2022-02-21 03:24:22.057', 0);
INSERT INTO `chip` VALUES ('TPS72012DRVT', 250, NULL, 'scan001', '2022-02-21 03:24:22.091', 0);
INSERT INTO `chip` VALUES ('TPS73601DRBR', 3000, NULL, 'scan001', '2022-02-21 03:24:22.124', 0);
INSERT INTO `chip` VALUES ('TPS73601DRBT', 250, NULL, 'scan001', '2022-02-21 03:24:22.157', 0);
INSERT INTO `chip` VALUES ('TPS73701DRVR', 3000, NULL, 'scan001', '2022-02-21 03:24:22.191', 0);
INSERT INTO `chip` VALUES ('TPS73701DRVT', 250, NULL, 'scan001', '2022-02-21 03:24:22.225', 0);
INSERT INTO `chip` VALUES ('TPS73733DRVR', 3000, NULL, 'scan001', '2022-02-21 03:24:22.259', 0);
INSERT INTO `chip` VALUES ('TPS73801DCQR', 2500, NULL, 'scan001', '2022-02-21 03:24:22.293', 0);
INSERT INTO `chip` VALUES ('TPS74501PDRVR', 3000, NULL, 'scan001', '2022-02-21 03:24:22.326', 0);
INSERT INTO `chip` VALUES ('TPS74501PDRVT', 250, NULL, 'scan001', '2022-02-21 03:24:22.360', 0);
INSERT INTO `chip` VALUES ('TPS74501PQWDRVRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:22.394', 0);
INSERT INTO `chip` VALUES ('TPS74511PQWDRVRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:22.427', 0);
INSERT INTO `chip` VALUES ('TPS74601PBDRVR', 3000, NULL, 'scan001', '2022-02-21 03:24:22.461', 0);
INSERT INTO `chip` VALUES ('TPS74601PBDRVT', 250, NULL, 'scan001', '2022-02-21 03:24:22.495', 0);
INSERT INTO `chip` VALUES ('TPS74601PDRVR', 3000, NULL, 'scan001', '2022-02-21 03:24:22.561', 0);
INSERT INTO `chip` VALUES ('TPS74601PDRVT', 250, NULL, 'scan001', '2022-02-21 03:24:22.595', 0);
INSERT INTO `chip` VALUES ('TPS74601PQWDRVRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:22.628', 0);
INSERT INTO `chip` VALUES ('TPS74701DRCR', 3000, NULL, 'scan001', '2022-02-21 03:24:22.662', 0);
INSERT INTO `chip` VALUES ('TPS74701DRCT', 250, NULL, 'scan001', '2022-02-21 03:24:22.696', 0);
INSERT INTO `chip` VALUES ('TPS78101DRVR', 3000, NULL, 'scan001', '2022-02-21 03:24:22.730', 0);
INSERT INTO `chip` VALUES ('TPS78101DRVT', 250, NULL, 'scan001', '2022-02-21 03:24:22.764', 0);
INSERT INTO `chip` VALUES ('TPS78218DRVR', 3000, NULL, 'scan001', '2022-02-21 03:24:22.797', 0);
INSERT INTO `chip` VALUES ('TPS78218DRVT', 250, NULL, 'scan001', '2022-02-21 03:24:22.831', 0);
INSERT INTO `chip` VALUES ('TPS7A2601DRVR', 3000, NULL, 'scan001', '2022-02-21 03:24:22.865', 0);
INSERT INTO `chip` VALUES ('TPS7A3701DRVR', 3000, NULL, 'scan001', '2022-02-21 03:24:22.899', 0);
INSERT INTO `chip` VALUES ('TPS7A3701DRVT', 250, NULL, 'scan001', '2022-02-21 03:24:22.933', 0);
INSERT INTO `chip` VALUES ('TPS7A4101DGNR', 2500, NULL, 'scan001', '2022-02-21 03:24:22.966', 0);
INSERT INTO `chip` VALUES ('TPS7A4101DGNT', 250, NULL, 'scan001', '2022-02-21 03:24:23.001', 0);
INSERT INTO `chip` VALUES ('TPS7A4201DGNR', 2500, NULL, 'scan001', '2022-02-21 03:24:23.035', 0);
INSERT INTO `chip` VALUES ('TPS7A4201DGNT', 250, NULL, 'scan001', '2022-02-21 03:24:23.068', 0);
INSERT INTO `chip` VALUES ('TPS7A4501KTTR', 500, NULL, 'scan001', '2022-02-21 03:24:23.102', 0);
INSERT INTO `chip` VALUES ('TPS7A5301RPSR', 3000, NULL, 'scan001', '2022-02-21 03:24:23.136', 0);
INSERT INTO `chip` VALUES ('TPS7A5301RPST', 250, NULL, 'scan001', '2022-02-21 03:24:23.170', 0);
INSERT INTO `chip` VALUES ('TPS7A5401QRGRRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:23.204', 0);
INSERT INTO `chip` VALUES ('TPS7A7100RGTR', 3000, NULL, 'scan001', '2022-02-21 03:24:23.237', 0);
INSERT INTO `chip` VALUES ('TPS7A7100RGTT', 250, NULL, 'scan001', '2022-02-21 03:24:23.272', 0);
INSERT INTO `chip` VALUES ('TPS7A7200RGTR', 3000, NULL, 'scan001', '2022-02-21 03:24:23.305', 0);
INSERT INTO `chip` VALUES ('TPS7A7200RGTT', 250, NULL, 'scan001', '2022-02-21 03:24:23.339', 0);
INSERT INTO `chip` VALUES ('TPS7A7200RGWR', 3000, NULL, 'scan001', '2022-02-21 03:24:23.373', 0);
INSERT INTO `chip` VALUES ('TPS7A7200RGWT', 250, NULL, 'scan001', '2022-02-21 03:24:23.407', 0);
INSERT INTO `chip` VALUES ('TPS7A7300RGWR', 3000, NULL, 'scan001', '2022-02-21 03:24:23.441', 0);
INSERT INTO `chip` VALUES ('TPS7A7300RGWT', 250, NULL, 'scan001', '2022-02-21 03:24:23.474', 0);
INSERT INTO `chip` VALUES ('TPS7A8300RGRR', 3000, NULL, 'scan001', '2022-02-21 03:24:23.539', 0);
INSERT INTO `chip` VALUES ('TPS7A8300RGRT', 250, NULL, 'scan001', '2022-02-21 03:24:23.573', 0);
INSERT INTO `chip` VALUES ('TPS7A8400RGRR', 3000, NULL, 'scan001', '2022-02-21 03:24:23.607', 0);
INSERT INTO `chip` VALUES ('TPS7A8400RGRT', 250, NULL, 'scan001', '2022-02-21 03:24:23.640', 0);
INSERT INTO `chip` VALUES ('TPS7A8500ARGRR', 3000, NULL, 'scan001', '2022-02-21 03:24:23.675', 0);
INSERT INTO `chip` VALUES ('TPS7A8500ARGRT', 250, NULL, 'scan001', '2022-02-21 03:24:23.709', 0);
INSERT INTO `chip` VALUES ('TPS7A8500RGRR', 3000, NULL, 'scan001', '2022-02-21 03:24:23.742', 0);
INSERT INTO `chip` VALUES ('TPS7A8500RGRT', 250, NULL, 'scan001', '2022-02-21 03:24:23.776', 0);
INSERT INTO `chip` VALUES ('TPS7A8701RTJR', 3000, NULL, 'scan001', '2022-02-21 03:24:23.811', 0);
INSERT INTO `chip` VALUES ('TPS7A8701RTJT', 250, NULL, 'scan001', '2022-02-21 03:24:23.845', 0);
INSERT INTO `chip` VALUES ('TPS7A8801QRTJRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:23.880', 0);
INSERT INTO `chip` VALUES ('TPS7A8801RTJR', 3000, NULL, 'scan001', '2022-02-21 03:24:23.913', 0);
INSERT INTO `chip` VALUES ('TPS7A8801RTJT', 250, NULL, 'scan001', '2022-02-21 03:24:23.948', 0);
INSERT INTO `chip` VALUES ('TPS7A9001DSKR', 3000, NULL, 'scan001', '2022-02-21 03:24:23.982', 0);
INSERT INTO `chip` VALUES ('TPS7A9001DSKT', 250, NULL, 'scan001', '2022-02-21 03:24:24.015', 0);
INSERT INTO `chip` VALUES ('TPS7A9101DSKR', 3000, NULL, 'scan001', '2022-02-21 03:24:24.050', 0);
INSERT INTO `chip` VALUES ('TPS7A9101DSKT', 250, NULL, 'scan001', '2022-02-21 03:24:24.084', 0);
INSERT INTO `chip` VALUES ('TPS7B4250QDBVRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:24.118', 0);
INSERT INTO `chip` VALUES ('TPS7B4253QDDARQ1', 2500, NULL, 'scan001', '2022-02-21 03:24:24.156', 0);
INSERT INTO `chip` VALUES ('TPS7B4254QDDARQ1', 2500, NULL, 'scan001', '2022-02-21 03:24:24.190', 0);
INSERT INTO `chip` VALUES ('TPS7B6350QPWPRQ1', 2000, NULL, 'scan001', '2022-02-21 03:24:24.224', 0);
INSERT INTO `chip` VALUES ('TPS7B6933DBVR', 3000, NULL, 'scan001', '2022-02-21 03:24:24.258', 0);
INSERT INTO `chip` VALUES ('TPS7B8150QDGNRQ1', 2500, NULL, 'scan001', '2022-02-21 03:24:24.291', 0);
INSERT INTO `chip` VALUES ('TPS7B8233QDRVRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:24.326', 0);
INSERT INTO `chip` VALUES ('TPS7B8250QDGNRQ1', 2500, NULL, 'scan001', '2022-02-21 03:24:24.361', 0);
INSERT INTO `chip` VALUES ('TPS7B8601QDDARQ1', 2500, NULL, 'scan001', '2022-02-21 03:24:24.397', 0);
INSERT INTO `chip` VALUES ('TPS7B8650QDDARQ1', 2500, NULL, 'scan001', '2022-02-21 03:24:24.431', 0);
INSERT INTO `chip` VALUES ('TPS82084SILR', 3000, NULL, 'scan001', '2022-02-21 03:24:24.465', 0);
INSERT INTO `chip` VALUES ('TPS82084SILT', 250, NULL, 'scan001', '2022-02-21 03:24:24.498', 0);
INSERT INTO `chip` VALUES ('TPS82085SILR', 3000, NULL, 'scan001', '2022-02-21 03:24:24.564', 0);
INSERT INTO `chip` VALUES ('TPS82085SILT', 250, NULL, 'scan001', '2022-02-21 03:24:24.599', 0);
INSERT INTO `chip` VALUES ('TPS82130SILR', 3000, NULL, 'scan001', '2022-02-21 03:24:24.634', 0);
INSERT INTO `chip` VALUES ('TPS82130SILT', 250, NULL, 'scan001', '2022-02-21 03:24:24.667', 0);
INSERT INTO `chip` VALUES ('TPS82140SILR', 3000, NULL, 'scan001', '2022-02-21 03:24:24.702', 0);
INSERT INTO `chip` VALUES ('TPS82140SILT', 250, NULL, 'scan001', '2022-02-21 03:24:24.736', 0);
INSERT INTO `chip` VALUES ('TPS92513DGQR', 2500, NULL, 'scan001', '2022-02-21 03:24:24.769', 0);
INSERT INTO `chip` VALUES ('TPS92513DGQT', 250, NULL, 'scan001', '2022-02-21 03:24:24.804', 0);
INSERT INTO `chip` VALUES ('TPS92513HVDGQR', 2500, NULL, 'scan001', '2022-02-21 03:24:24.838', 0);
INSERT INTO `chip` VALUES ('TPS92513HVDGQT', 250, NULL, 'scan001', '2022-02-21 03:24:24.870', 0);
INSERT INTO `chip` VALUES ('TPS92515DGQR', 2500, NULL, 'scan001', '2022-02-21 03:24:24.904', 0);
INSERT INTO `chip` VALUES ('TPS92515HVDGQR', 2500, NULL, 'scan001', '2022-02-21 03:24:24.938', 0);
INSERT INTO `chip` VALUES ('TPS92515HVDGQT', 250, NULL, 'scan001', '2022-02-21 03:24:24.972', 0);
INSERT INTO `chip` VALUES ('TPS92515HVQDGQRQ1', 2500, NULL, 'scan001', '2022-02-21 03:24:25.006', 0);
INSERT INTO `chip` VALUES ('TPS92515HVQDGQTQ1', 250, NULL, 'scan001', '2022-02-21 03:24:25.040', 0);
INSERT INTO `chip` VALUES ('TPS92515QDGQRQ1', 2500, NULL, 'scan001', '2022-02-21 03:24:25.074', 0);
INSERT INTO `chip` VALUES ('TPS92515QDGQTQ1', 250, NULL, 'scan001', '2022-02-21 03:24:25.107', 0);
INSERT INTO `chip` VALUES ('TPS92561DGNR', 2500, NULL, 'scan001', '2022-02-21 03:24:25.141', 0);
INSERT INTO `chip` VALUES ('TPS92611QDGNRQ1', 2500, NULL, 'scan001', '2022-02-21 03:24:25.175', 0);
INSERT INTO `chip` VALUES ('TPS92612DBVR', 3000, NULL, 'scan001', '2022-02-21 03:24:25.209', 0);
INSERT INTO `chip` VALUES ('TPS92612QDBVRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:25.243', 0);
INSERT INTO `chip` VALUES ('TPS92613QNDRRQ1', 1000, NULL, 'scan001', '2022-02-21 03:24:25.276', 0);
INSERT INTO `chip` VALUES ('TPS92638QPWPRQ1', 2000, NULL, 'scan001', '2022-02-21 03:24:25.311', 0);
INSERT INTO `chip` VALUES ('TPS92640PWPT/NOPB', 250, NULL, 'scan001', '2022-02-21 03:24:25.345', 0);
INSERT INTO `chip` VALUES ('TPS92641PWPT/NOPB', 250, NULL, 'scan001', '2022-02-21 03:24:25.380', 0);
INSERT INTO `chip` VALUES ('TPS92662AQPHPRQ1', 1000, NULL, 'scan001', '2022-02-21 03:24:25.414', 0);
INSERT INTO `chip` VALUES ('TPS92662QPHPRQ1', 1000, NULL, 'scan001', '2022-02-21 03:24:25.447', 0);
INSERT INTO `chip` VALUES ('TPS92662QPHPTQ1', 250, NULL, 'scan001', '2022-02-21 03:24:25.482', 0);
INSERT INTO `chip` VALUES ('TPS92682QRHBRQ1', 2000, NULL, 'scan001', '2022-02-21 03:24:25.548', 0);
INSERT INTO `chip` VALUES ('TPS92682QRHMRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:25.582', 0);
INSERT INTO `chip` VALUES ('TPS92691QPWPRQ1', 2000, NULL, 'scan001', '2022-02-21 03:24:25.617', 0);
INSERT INTO `chip` VALUES ('TPS92691QPWPTQ1', 250, NULL, 'scan001', '2022-02-21 03:24:25.651', 0);
INSERT INTO `chip` VALUES ('TPS92692QPWPRQ1', 2000, NULL, 'scan001', '2022-02-21 03:24:25.685', 0);
INSERT INTO `chip` VALUES ('TPS92692QPWPTQ1', 250, NULL, 'scan001', '2022-02-21 03:24:25.720', 0);
INSERT INTO `chip` VALUES ('TPSM53604RDAR', 1000, NULL, 'scan001', '2022-02-21 03:24:25.755', 0);
INSERT INTO `chip` VALUES ('TPSM82480MOPR', 3000, NULL, 'scan001', '2022-02-21 03:24:25.790', 0);
INSERT INTO `chip` VALUES ('TPSM82480MOPT', 250, NULL, 'scan001', '2022-02-21 03:24:25.825', 0);
INSERT INTO `chip` VALUES ('TPSM828221SILR', 3000, NULL, 'scan001', '2022-02-21 03:24:25.859', 0);
INSERT INTO `chip` VALUES ('TPSM82822SILR', 3000, NULL, 'scan001', '2022-02-21 03:24:25.893', 0);
INSERT INTO `chip` VALUES ('TPSM84209RKHR', 3000, NULL, 'scan001', '2022-02-21 03:24:25.927', 0);
INSERT INTO `chip` VALUES ('TPSM84209RKHT', 250, NULL, 'scan001', '2022-02-21 03:24:25.960', 0);
INSERT INTO `chip` VALUES ('TPSM84424MOLR', 500, NULL, 'scan001', '2022-02-21 03:24:25.994', 0);
INSERT INTO `chip` VALUES ('TPSM84624MOLR', 500, NULL, 'scan001', '2022-02-21 03:24:26.029', 0);
INSERT INTO `chip` VALUES ('TPSM84824MOLR', 500, NULL, 'scan001', '2022-02-21 03:24:26.062', 0);
INSERT INTO `chip` VALUES ('TRS3122ERGER', 3000, NULL, 'scan001', '2022-02-21 03:24:26.098', 0);
INSERT INTO `chip` VALUES ('TRS3122ERGET', 250, NULL, 'scan001', '2022-02-21 03:24:26.132', 0);
INSERT INTO `chip` VALUES ('TRS3253EIRSMR', 3000, NULL, 'scan001', '2022-02-21 03:24:26.166', 0);
INSERT INTO `chip` VALUES ('TS3A225ERTER', 3000, NULL, 'scan001', '2022-02-21 03:24:26.201', 0);
INSERT INTO `chip` VALUES ('TS3A27518ETRTWRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:26.235', 0);
INSERT INTO `chip` VALUES ('TS3A44159RGTR', 3000, NULL, 'scan001', '2022-02-21 03:24:26.269', 0);
INSERT INTO `chip` VALUES ('TS3A5017RSVR', 3000, NULL, 'scan001', '2022-02-21 03:24:26.304', 0);
INSERT INTO `chip` VALUES ('TS3L501ERUAR', 3000, NULL, 'scan001', '2022-02-21 03:24:26.338', 0);
INSERT INTO `chip` VALUES ('TS3USB3000MRSER', 3000, NULL, 'scan001', '2022-02-21 03:24:26.372', 0);
INSERT INTO `chip` VALUES ('TS3USB3000RSER', 3000, NULL, 'scan001', '2022-02-21 03:24:26.406', 0);
INSERT INTO `chip` VALUES ('TS3USB3031RMGR', 3000, NULL, 'scan001', '2022-02-21 03:24:26.441', 0);
INSERT INTO `chip` VALUES ('TS3USB31ERSER', 3000, NULL, 'scan001', '2022-02-21 03:24:26.476', 0);
INSERT INTO `chip` VALUES ('TUSB1002ARGER', 3000, NULL, 'scan001', '2022-02-21 03:24:26.542', 0);
INSERT INTO `chip` VALUES ('TUSB1002ARGET', 250, NULL, 'scan001', '2022-02-21 03:24:26.576', 0);
INSERT INTO `chip` VALUES ('TUSB1046A-DCIRNQR', 3000, NULL, 'scan001', '2022-02-21 03:24:26.611', 0);
INSERT INTO `chip` VALUES ('TUSB211QRWBRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:26.645', 0);
INSERT INTO `chip` VALUES ('TUSB211RWBR', 3000, NULL, 'scan001', '2022-02-21 03:24:26.682', 0);
INSERT INTO `chip` VALUES ('TUSB212IRWBR', 3000, NULL, 'scan001', '2022-02-21 03:24:26.717', 0);
INSERT INTO `chip` VALUES ('TUSB212IRWBT', 250, NULL, 'scan001', '2022-02-21 03:24:26.752', 0);
INSERT INTO `chip` VALUES ('TUSB212RWBR', 3000, NULL, 'scan001', '2022-02-21 03:24:26.787', 0);
INSERT INTO `chip` VALUES ('TUSB212RWBT', 250, NULL, 'scan001', '2022-02-21 03:24:26.821', 0);
INSERT INTO `chip` VALUES ('TUSB217RGYRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:26.856', 0);
INSERT INTO `chip` VALUES ('TUSB217RGYTQ1', 250, NULL, 'scan001', '2022-02-21 03:24:26.890', 0);
INSERT INTO `chip` VALUES ('TUSB321AIRWBR', 3000, NULL, 'scan001', '2022-02-21 03:24:26.924', 0);
INSERT INTO `chip` VALUES ('TUSB4041IPAPR', 1000, NULL, 'scan001', '2022-02-21 03:24:26.958', 0);
INSERT INTO `chip` VALUES ('TUSB4041IPAPRQ1', 1000, NULL, 'scan001', '2022-02-21 03:24:26.992', 0);
INSERT INTO `chip` VALUES ('TUSB4041IPAPT', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('TUSB522PRGER', 3000, NULL, 'scan001', '2022-02-21 03:24:27.026', 0);
INSERT INTO `chip` VALUES ('TUSB522PRGET', 250, NULL, 'scan001', '2022-02-21 03:24:27.060', 0);
INSERT INTO `chip` VALUES ('TUSB542RWQR', 3000, NULL, 'scan001', '2022-02-21 03:24:27.093', 0);
INSERT INTO `chip` VALUES ('TUSB544IRNQR', 3000, NULL, 'scan001', '2022-02-21 03:24:27.127', 0);
INSERT INTO `chip` VALUES ('TUSB544IRNQT', 250, NULL, 'scan001', '2022-02-21 03:24:27.164', 0);
INSERT INTO `chip` VALUES ('TUSB8041IRGCR', 2000, NULL, 'scan001', '2022-02-21 03:24:27.199', 0);
INSERT INTO `chip` VALUES ('TUSB8041IRGCT', 250, NULL, 'scan001', '2022-02-21 03:24:27.233', 0);
INSERT INTO `chip` VALUES ('TUSB8041RGCR', 2500, NULL, 'scan001', '2022-02-21 03:24:27.267', 0);
INSERT INTO `chip` VALUES ('TUSB8041RGCT', 250, NULL, 'scan001', '2022-02-21 03:24:27.301', 0);
INSERT INTO `chip` VALUES ('TUSB8042AIRGCR', 2000, NULL, 'scan001', '2022-02-21 03:24:27.335', 0);
INSERT INTO `chip` VALUES ('TXB0104QRGYRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:27.369', 0);
INSERT INTO `chip` VALUES ('TXB0304RUTR', 3000, NULL, 'scan001', '2022-02-21 03:24:27.403', 0);
INSERT INTO `chip` VALUES ('TXS0102QDCURQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:27.436', 0);
INSERT INTO `chip` VALUES ('UCC21520ADWR', 2000, NULL, 'scan001', '2022-02-21 03:24:27.471', 0);
INSERT INTO `chip` VALUES ('UCC21520DWR', 2000, NULL, 'scan001', '2022-02-21 03:24:27.537', 0);
INSERT INTO `chip` VALUES ('UCC21520QDWRQ1', 2000, NULL, 'scan001', '2022-02-21 03:24:27.571', 0);
INSERT INTO `chip` VALUES ('UCC21521DWR', 2000, NULL, 'scan001', '2022-02-21 03:24:27.605', 0);
INSERT INTO `chip` VALUES ('UCC21750QDWRQ1', 2000, NULL, 'scan001', '2022-02-21 03:24:27.639', 0);
INSERT INTO `chip` VALUES ('UCC24624DR', 2500, NULL, 'scan001', '2022-02-21 03:24:27.674', 0);
INSERT INTO `chip` VALUES ('UCC24624DT', 250, NULL, 'scan001', '2022-02-21 03:24:27.708', 0);
INSERT INTO `chip` VALUES ('UCC25600DR', 2500, NULL, 'scan001', '2022-02-21 03:24:27.741', 0);
INSERT INTO `chip` VALUES ('UCC27201AQDDARQ1', 2500, NULL, 'scan001', '2022-02-21 03:24:27.775', 0);
INSERT INTO `chip` VALUES ('UCC27201DRMR', 3000, NULL, 'scan001', '2022-02-21 03:24:27.809', 0);
INSERT INTO `chip` VALUES ('UCC27201DRMT', 250, NULL, 'scan001', '2022-02-21 03:24:27.843', 0);
INSERT INTO `chip` VALUES ('UCC27211ADRMR', 3000, NULL, 'scan001', '2022-02-21 03:24:27.879', 0);
INSERT INTO `chip` VALUES ('UCC27211ADRMT', 250, NULL, 'scan001', '2022-02-21 03:24:27.912', 0);
INSERT INTO `chip` VALUES ('UCC27511DBVR', 3000, NULL, 'scan001', '2022-02-21 03:24:27.948', 0);
INSERT INTO `chip` VALUES ('UCC27511DBVT', 250, NULL, 'scan001', '2022-02-21 03:24:27.982', 0);
INSERT INTO `chip` VALUES ('UCC27524AQDRQ1', 3000, NULL, 'scan001', '2022-02-21 03:24:28.015', 0);
INSERT INTO `chip` VALUES ('UCC27524DGNR', 2500, NULL, 'scan001', '2022-02-21 03:24:28.049', 0);
INSERT INTO `chip` VALUES ('UCC27524DSDR', 3000, NULL, 'scan001', '2022-02-21 03:24:28.083', 0);
INSERT INTO `chip` VALUES ('UCC27524DSDT', 250, NULL, 'scan001', '2022-02-21 03:24:28.117', 0);
INSERT INTO `chip` VALUES ('UCC27714DR', 2500, NULL, 'scan001', '2022-02-21 03:24:28.152', 0);
INSERT INTO `chip` VALUES ('UCC28061DR', 2500, NULL, 'scan001', '2022-02-21 03:24:28.186', 0);
INSERT INTO `chip` VALUES ('UCC28950PWR', 2000, NULL, 'scan001', '2022-02-21 03:24:28.219', 0);
INSERT INTO `chip` VALUES ('UCC28950QPWRQ1', 2000, NULL, 'scan001', '2022-02-21 03:24:28.253', 0);
INSERT INTO `chip` VALUES ('UCC28951PWR', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('UCC28951PWT', 250, NULL, 'scan001', '2022-02-21 03:24:28.288', 0);
INSERT INTO `chip` VALUES ('UCC28951QPWRQ1', 2000, NULL, 'scan001', '2022-02-21 03:24:28.322', 0);
INSERT INTO `chip` VALUES ('UCD90120ARGCR', 2000, NULL, 'scan001', '2022-02-21 03:24:28.356', 0);
INSERT INTO `chip` VALUES ('UCD90120ARGCT', 250, NULL, 'scan001', '2022-02-21 03:24:28.390', 0);
INSERT INTO `chip` VALUES ('UCD9090RGZR', -1, NULL, '', NULL, 0);
INSERT INTO `chip` VALUES ('UCD9090RGZT', 250, NULL, 'scan001', '2022-02-21 03:24:28.423', 0);
INSERT INTO `chip` VALUES ('WL1837MODGIMOCR', 1200, NULL, 'scan001', '2022-02-21 03:24:28.457', 0);
INSERT INTO `chip` VALUES ('WL1837MODGIMOCT', 250, NULL, 'scan001', '2022-02-21 03:24:28.491', 0);
-- ----------------------------
-- Table structure for client
-- ----------------------------
DROP TABLE IF EXISTS `client`;
CREATE TABLE `client`  (
`id` varchar(64) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT '机器+线程名',
`type` varchar(16) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT 'query或buy',
`time` datetime(3) NULL DEFAULT NULL COMMENT '在线时间',
`online` tinyint UNSIGNED NULL DEFAULT NULL COMMENT '是否在线:1在线,0离线',
PRIMARY KEY (`id`) USING BTREE,
INDEX `type`(`type`) USING BTREE,
INDEX `time`(`time`) USING BTREE,
INDEX `online`(`online`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci COMMENT = '客户端列表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of client
-- ----------------------------
INSERT INTO `client` VALUES ('aaabbb', 'buy', '2022-01-15 10:51:52.000', 1);
INSERT INTO `client` VALUES ('scan001', 'scan', '2022-04-08 22:27:15.275', 1);
INSERT INTO `client` VALUES ('test2', 'query', '2022-01-15 01:26:11.899', 1);
INSERT INTO `client` VALUES ('testid', 'scan', '2022-02-13 17:38:03.685', 1);
INSERT INTO `client` VALUES ('test_pc_name_1', 'buy', '2022-01-14 23:08:36.000', 1);
INSERT INTO `client` VALUES ('test_pc_name_2', 'buy', '2022-01-14 23:12:31.000', 1);
INSERT INTO `client` VALUES ('test_pc_name_3', 'buy', '2022-01-15 13:06:25.071', 1);
INSERT INTO `client` VALUES ('test_pc_name_34', 'buy', '2022-01-15 11:27:21.957', 1);
-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config`  (
`name` varchar(1024) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL,
`string` varchar(1024) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT '',
`number` int NULL DEFAULT 0,
`remark` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT '',
PRIMARY KEY (`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES ('虚拟芯片', 'AFE8030IABJ', 0, '用来刷库存的芯片名');
-- ----------------------------
-- Table structure for if_curip
-- ----------------------------
DROP TABLE IF EXISTS `if_curip`;
CREATE TABLE `if_curip`  (
`index` int NULL DEFAULT NULL COMMENT '优先级',
`url` varchar(1024) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT '获取url',
`referer` varchar(1024) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT '' COMMENT '引用页面',
`begin_str` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
`end_str` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL,
PRIMARY KEY (`url`) USING BTREE,
INDEX `index`(`index`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of if_curip
-- ----------------------------
INSERT INTO `if_curip` VALUES (8, 'http://ip.360.cn/IPShare/info', 'http://ip.360.cn/', '\"ip\":\"', '\"');
INSERT INTO `if_curip` VALUES (2, 'http://pv.sohu.com/cityjson', 'http://www.sohu.com/', '\"cip\": \"', '\"');
INSERT INTO `if_curip` VALUES (1, 'http://whois.pconline.com.cn/ipJson.jsp', 'http://whois.pconline.com.cn/', '\"ip\":\"', '\"');
INSERT INTO `if_curip` VALUES (9, 'https://ip.chinaz.com/', 'https://ip.chinaz.com/', 'name=\"ip\" url=\"true\" value=\"', '\"');
INSERT INTO `if_curip` VALUES (12, 'https://tool.lu/ip/', 'https://tool.lu/ip/', '你的外网IP地址是:', '<');
INSERT INTO `if_curip` VALUES (10, 'https://www.taobao.com/help/getip.php', 'https://www.taobao.com/', 'ip:\"', '\"');
-- ----------------------------
-- Table structure for iplist
-- ----------------------------
DROP TABLE IF EXISTS `iplist`;
CREATE TABLE `iplist`  (
`ip` varchar(66) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT 'ip地址与端口x.x.x.x:xxxx',
`port` int NOT NULL COMMENT '端口',
`type` int NULL DEFAULT NULL COMMENT '1:拔号动态,2:阿里云静态',
`exptime` datetime(3) NULL DEFAULT NULL COMMENT '失效时间',
`client_id` varchar(64) CHARACTER SET gbk COLLATE gbk_chinese_ci NULL DEFAULT NULL COMMENT '使用者id',
`get_time` datetime(3) NULL DEFAULT NULL COMMENT '使用者取走时间',
`online` int NOT NULL DEFAULT 0 COMMENT '是否在线',
PRIMARY KEY (`ip`) USING BTREE,
INDEX `type`(`type`) USING BTREE,
INDEX `time`(`exptime`) USING BTREE,
INDEX `client_id`(`client_id`) USING BTREE,
INDEX `get_time`(`get_time`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = gbk COLLATE = gbk_chinese_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of iplist
-- ----------------------------
INSERT INTO `iplist` VALUES ('59.51.113.100', 8860, NULL, NULL, NULL, NULL, 1);
INSERT INTO `iplist` VALUES ('59.51.113.106', 8860, NULL, NULL, NULL, NULL, 1);
INSERT INTO `iplist` VALUES ('59.51.113.11', 49157, NULL, NULL, NULL, NULL, 1);
INSERT INTO `iplist` VALUES ('59.51.113.35', 8860, NULL, '2022-01-28 23:11:45.000', NULL, NULL, 1);
INSERT INTO `iplist` VALUES ('59.51.113.55', 6013, NULL, NULL, NULL, NULL, 1);
-- ----------------------------
-- View structure for 错误包装芯片
-- ----------------------------
DROP VIEW IF EXISTS `错误包装芯片`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `错误包装芯片` AS select `chip`.`name` AS `name`,`chip`.`package` AS `package`,`chip`.`scan_time` AS `scan_time` from `chip` where (`chip`.`package` = -(1));
-- ----------------------------
-- View structure for 需查库存芯片
-- ----------------------------
DROP VIEW IF EXISTS `需查库存芯片`;
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `需查库存芯片` AS select `chip`.`name` AS `name`,`chip`.`package` AS `package`,`chip`.`scan_time` AS `scan_time`,`chip`.`client_id` AS `client_id`,`chip`.`get_time` AS `get_time` from `chip` where ((`chip`.`package` > 0) and ((`chip`.`client_id` = '') or (timestampdiff(MINUTE,`chip`.`get_time`,now(3)) > 1))) order by `chip`.`scan_time`;
-- ----------------------------
-- Function structure for getAuthorFullName
-- ----------------------------
DROP FUNCTION IF EXISTS `getAuthorFullName`;
delimiter ;;
CREATE FUNCTION `getAuthorFullName`(authorID INT)
RETURNS char(45) CHARSET gbk
BEGIN
DECLARE author CHAR(45);
SELECT CONCAT(first, ' ',last) FROM person as fullName
JOIN user ON user.idPerson = fullName.idPerson
WHERE idUser LIKE authorID
INTO author;
RETURN author;
end
;;
delimiter ;
-- ----------------------------
-- Procedure structure for submit_cardid
-- ----------------------------
DROP PROCEDURE IF EXISTS `submit_cardid`;
delimiter ;;
CREATE PROCEDURE `submit_cardid`(IN chipName char(32),IN id char(64))
BEGIN
insert into cart values(id,chipName,now(3));
select ROW_COUNT();
#添加到购物车成功的,提交购物车ID
END
;;
delimiter ;
-- ----------------------------
-- Procedure structure for test
-- ----------------------------
DROP PROCEDURE IF EXISTS `test`;
delimiter ;;
CREATE PROCEDURE `test`(IN id char(32),IN chipName char(32))
BEGIN
END
;;
delimiter ;
-- ----------------------------
-- Procedure structure for 保持客户端在线
-- ----------------------------
DROP PROCEDURE IF EXISTS `保持客户端在线`;
delimiter ;;
CREATE PROCEDURE `保持客户端在线`(IN id char(32),IN type char(64))
BEGIN
select 保持客户端在线_函数(id,type);
#INSERT INTO client(client.id,client.type,client.time,client.`online`) VALUE(id,type,now(3),1) ON DUPLICATE KEY UPDATE client.time=now(3);
#select ROW_COUNT();
END
;;
delimiter ;
-- ----------------------------
-- Function structure for 保持客户端在线_函数
-- ----------------------------
DROP FUNCTION IF EXISTS `保持客户端在线_函数`;
delimiter ;;
CREATE FUNCTION `保持客户端在线_函数`(id char(32),type char(64))
RETURNS int
BEGIN
INSERT INTO client(client.id,client.type,client.time,client.`online`) VALUE(id,type,now(3),1) ON DUPLICATE KEY UPDATE client.time=now(3);
RETURN ROW_COUNT();
END
;;
delimiter ;
-- ----------------------------
-- Procedure structure for 保持扫描在线
-- ----------------------------
DROP PROCEDURE IF EXISTS `保持扫描在线`;
delimiter ;;
CREATE PROCEDURE `保持扫描在线`(IN id char(32),IN chipName char(32))
BEGIN
DECLARE tmp char(128);
set tmp=保持客户端在线_函数(id,"scan");
update chip set get_time=now(3) where `name`=chipName and client_id=id;	
select ROW_COUNT();
END
;;
delimiter ;
-- ----------------------------
-- Procedure structure for 取IP接口
-- ----------------------------
DROP PROCEDURE IF EXISTS `取IP接口`;
delimiter ;;
CREATE PROCEDURE `取IP接口`()
BEGIN
SELECT 
CONCAT('[',
GROUP_CONCAT(
JSON_OBJECT('url',`url`,'referer',`referer`,'begin_str',`begin_str`,'end_str',`end_str`,'index',`index`) ORDER BY `index`
),']'
) AS json
FROM (
SELECT *
FROM `if_curip` ORDER BY `index` DESC
) `temp_table`;
END
;;
delimiter ;
-- ----------------------------
-- Procedure structure for 取扫包装芯片
-- ----------------------------
DROP PROCEDURE IF EXISTS `取扫包装芯片`;
delimiter ;;
CREATE PROCEDURE `取扫包装芯片`()
BEGIN
#Routine body goes here...
SELECT	* FROM	chip WHERE	package =0 LIMIT 1;
END
;;
delimiter ;
-- ----------------------------
-- Procedure structure for 取扫库存芯片
-- ----------------------------
DROP PROCEDURE IF EXISTS `取扫库存芯片`;
delimiter ;;
CREATE PROCEDURE `取扫库存芯片`(IN id char(32))
BEGIN
DECLARE isExit int DEFAULT 1;						#标识是否退出循环
DECLARE chipName char(32) DEFAULT "";		#找到的芯片
DECLARE timeOutMin  int DEFAULT 3;			#扫描端异常离线时间,默认3分钟
#取当前日期
DECLARE curdate datetime default now(3);
#先查询当前id上次异常结束的
update `chip` set get_time=curdate where client_id=id and package>0 limit 1 ;
if(ROW_COUNT()=1) then
set chipName=(select `name` from chip where client_id=id and get_time=curdate);
else
#循环
REPEAT
#先取出需要查的芯片
set chipName=(SELECT `name`	FROM `chip` WHERE package>0 AND (client_id='' or timestampdiff( MINUTE, `get_time`, now( 3 )) > timeOutMin ) ORDER BY scan_time ASC,get_time ASC limit 1);
if not isnull(chipName) then
#标记正在查
update `chip` set client_id=id,get_time=now(3) where `name`=chipName and  (client_id='' or timestampdiff( MINUTE, `get_time`, now( 3 )) > timeOutMin );
if(ROW_COUNT()=1) then
set isExit=1;					#标记成功了退出
end if;
else
set isExit=1;								#没有要查询的退出
end if;
UNTIL isExit=1									#条件满足退出
END REPEAT;
end if;
if not isnull(chipName) then
#select chipName;
select JSON_OBJECT('name',chipName,'type','scan');
end if;
END
;;
delimiter ;
-- ----------------------------
-- Procedure structure for 提交扫描芯片
-- ----------------------------
DROP PROCEDURE IF EXISTS `提交扫描芯片`;
delimiter ;;
CREATE PROCEDURE `提交扫描芯片`(IN id char(32),IN chipName char(32),IN scanSuccess int)
BEGIN
#客户端ID
#芯片名
#是否扫描成功
#						0:未扫描(释放)
#						1:扫描成功-没货
#						2:芯片信息错误
if scanSuccess=1 then																								#扫描成功-没货
update chip set scan_time=now(3),client_id='',get_time=null 
where `name`=chipName and client_id=id;	
elseif scanSuccess=0 then																						#没扫完,释放
update chip set client_id='',get_time=null 
where `name`=chipName and client_id=id;	
elseif scanSuccess=2 then																						#芯片信息错误.
update chip set client_id='',package=-1,scan_time=null 
where `name`=chipName and client_id=id;	
end if;
select ROW_COUNT();
END
;;
delimiter ;
-- ----------------------------
-- Procedure structure for 提交购买信息
-- ----------------------------
DROP PROCEDURE IF EXISTS `提交购买信息`;
delimiter ;;
CREATE PROCEDURE `提交购买信息`(IN clientid char(64),IN id char(64),IN chipname char(32))
BEGIN
update chip set scan_time=now(3),client_id='',cart_count=cart_count+1,get_time=null where name=chipname;
insert into cart(`client_id`,`cartid`,`name`,`time`) values(clientid,id,chipName,now(3));
select ROW_COUNT();
END
;;
delimiter ;
-- ----------------------------
-- Procedure structure for 检测代理过期
-- ----------------------------
DROP PROCEDURE IF EXISTS `检测代理过期`;
delimiter ;;
CREATE PROCEDURE `检测代理过期`(IN `ipaddr` char(64))
BEGIN
DECLARE timeOutMin  int DEFAULT 5;			#IP重新第一次时间,默认5分钟
DECLARE tmpStr VARCHAR(64);
set tmpStr=(SELECT	`ip` FROM	iplist WHERE	`ip`=`ipaddr` and timestampdiff( MINUTE, `exptime`, now( 3 )) < timeOutMin);
if ISNULL(tmpStr) then
select "有效";
else
select "过期";
end if;
END
;;
delimiter ;
-- ----------------------------
-- Procedure structure for 设置代理在线状态
-- ----------------------------
DROP PROCEDURE IF EXISTS `设置代理在线状态`;
delimiter ;;
CREATE PROCEDURE `设置代理在线状态`(IN `ipaddr` char(64),IN portnum int, IN `is_online` int)
BEGIN
INSERT INTO iplist(`ip`,`port`,`online`) VALUE(`ipaddr`,`portnum`,`is_online`) ON DUPLICATE KEY UPDATE `online`=`is_online`,`port`=`portnum`;
#if is_online=1 then
#call 检测代理过期(ipaddr);
#end if;
END
;;
delimiter ;
SET FOREIGN_KEY_CHECKS = 1;

 

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注