关于 Tensorflow 2 Object Detected 识别之后的结果索引解析 ， JSON以及SQL入库语句

关于JSON信息

[{
 "name": "/m/01g317"
  ,"id": 1
  ,"display_name": "person"
},
{
 "name": "/m/0199g"
  ,"id": 2
  ,"display_name": "bicycle"
},
{
 "name": "/m/0k4j"
  ,"id": 3
  ,"display_name": "car"
},
{
 "name": "/m/04_sv"
  ,"id": 4
  ,"display_name": "motorcycle"
},
{
 "name": "/m/05czz6l"
  ,"id": 5
  ,"display_name": "airplane"
},
{
 "name": "/m/01bjv"
  ,"id": 6
  ,"display_name": "bus"
},
{
 "name": "/m/07jdr"
  ,"id": 7
  ,"display_name": "train"
},
{
 "name": "/m/07r04"
  ,"id": 8
  ,"display_name": "truck"
},
{
 "name": "/m/019jd"
  ,"id": 9
  ,"display_name": "boat"
},
{
 "name": "/m/015qff"
  ,"id": 10
  ,"display_name": "traffic light"
},
{
 "name": "/m/01pns0"
  ,"id": 11
  ,"display_name": "fire hydrant"
},
{
 "name": "/m/02pv19"
  ,"id": 13
  ,"display_name": "stop sign"
},
{
 "name": "/m/015qbp"
  ,"id": 14
  ,"display_name": "parking meter"
},
{
 "name": "/m/0cvnqh"
  ,"id": 15
  ,"display_name": "bench"
},
{
 "name": "/m/015p6"
  ,"id": 16
  ,"display_name": "bird"
},
{
 "name": "/m/01yrx"
  ,"id": 17
  ,"display_name": "cat"
},
{
 "name": "/m/0bt9lr"
  ,"id": 18
  ,"display_name": "dog"
},
{
 "name": "/m/03k3r"
  ,"id": 19
  ,"display_name": "horse"
},
{
 "name": "/m/07bgp"
  ,"id": 20
  ,"display_name": "sheep"
},
{
 "name": "/m/01xq0k1"
  ,"id": 21
  ,"display_name": "cow"
},
{
 "name": "/m/0bwd_0j"
  ,"id": 22
  ,"display_name": "elephant"
},
{
 "name": "/m/01dws"
  ,"id": 23
  ,"display_name": "bear"
},
{
 "name": "/m/0898b"
  ,"id": 24
  ,"display_name": "zebra"
},
{
 "name": "/m/03bk1"
  ,"id": 25
  ,"display_name": "giraffe"
},
{
 "name": "/m/01940j"
  ,"id": 27
  ,"display_name": "backpack"
},
{
 "name": "/m/0hnnb"
  ,"id": 28
  ,"display_name": "umbrella"
},
{
 "name": "/m/080hkjn"
  ,"id": 31
  ,"display_name": "handbag"
},
{
 "name": "/m/01rkbr"
  ,"id": 32
  ,"display_name": "tie"
},
{
 "name": "/m/01s55n"
  ,"id": 33
  ,"display_name": "suitcase"
},
{
 "name": "/m/02wmf"
  ,"id": 34
  ,"display_name": "frisbee"
},
{
 "name": "/m/071p9"
  ,"id": 35
  ,"display_name": "skis"
},
{
 "name": "/m/06__v"
  ,"id": 36
  ,"display_name": "snowboard"
},
{
 "name": "/m/018xm"
  ,"id": 37
  ,"display_name": "sports ball"
},
{
 "name": "/m/02zt3"
  ,"id": 38
  ,"display_name": "kite"
},
{
 "name": "/m/03g8mr"
  ,"id": 39
  ,"display_name": "baseball bat"
},
{
 "name": "/m/03grzl"
  ,"id": 40
  ,"display_name": "baseball glove"
},
{
 "name": "/m/06_fw"
  ,"id": 41
  ,"display_name": "skateboard"
},
{
 "name": "/m/019w40"
  ,"id": 42
  ,"display_name": "surfboard"
},
{
 "name": "/m/0dv9c"
  ,"id": 43
  ,"display_name": "tennis racket"
},
{
 "name": "/m/04dr76w"
  ,"id": 44
  ,"display_name": "bottle"
},
{
 "name": "/m/09tvcd"
  ,"id": 46
  ,"display_name": "wine glass"
},
{
 "name": "/m/08gqpm"
  ,"id": 47
  ,"display_name": "cup"
},
{
 "name": "/m/0dt3t"
  ,"id": 48
  ,"display_name": "fork"
},
{
 "name": "/m/04ctx"
  ,"id": 49
  ,"display_name": "knife"
},
{
 "name": "/m/0cmx8"
  ,"id": 50
  ,"display_name": "spoon"
},
{
 "name": "/m/04kkgm"
  ,"id": 51
  ,"display_name": "bowl"
},
{
 "name": "/m/09qck"
  ,"id": 52
  ,"display_name": "banana"
},
{
 "name": "/m/014j1m"
  ,"id": 53
  ,"display_name": "apple"
},
{
 "name": "/m/0l515"
  ,"id": 54
  ,"display_name": "sandwich"
},
{
 "name": "/m/0cyhj_"
  ,"id": 55
  ,"display_name": "orange"
},
{
 "name": "/m/0hkxq"
  ,"id": 56
  ,"display_name": "broccoli"
},
{
 "name": "/m/0fj52s"
  ,"id": 57
  ,"display_name": "carrot"
},
{
 "name": "/m/01b9xk"
  ,"id": 58
  ,"display_name": "hot dog"
},
{
 "name": "/m/0663v"
  ,"id": 59
  ,"display_name": "pizza"
},
{
 "name": "/m/0jy4k"
  ,"id": 60
  ,"display_name": "donut"
},
{
 "name": "/m/0fszt"
  ,"id": 61
  ,"display_name": "cake"
},
{
 "name": "/m/01mzpv"
  ,"id": 62
  ,"display_name": "chair"
},
{
 "name": "/m/02crq1"
  ,"id": 63
  ,"display_name": "couch"
},
{
 "name": "/m/03fp41"
  ,"id": 64
  ,"display_name": "potted plant"
},
{
 "name": "/m/03ssj5"
  ,"id": 65
  ,"display_name": "bed"
},
{
 "name": "/m/04bcr3"
  ,"id": 67
  ,"display_name": "dining table"
},
{
 "name": "/m/09g1w"
  ,"id": 70
  ,"display_name": "toilet"
},
{
 "name": "/m/07c52"
  ,"id": 72
  ,"display_name": "tv"
},
{
 "name": "/m/01c648"
  ,"id": 73
  ,"display_name": "laptop"
},
{
 "name": "/m/020lf"
  ,"id": 74
  ,"display_name": "mouse"
},
{
 "name": "/m/0qjjc"
  ,"id": 75
  ,"display_name": "remote"
},
{
 "name": "/m/01m2v"
  ,"id": 76
  ,"display_name": "keyboard"
},
{
 "name": "/m/050k8"
  ,"id": 77
  ,"display_name": "cell phone"
},
{
 "name": "/m/0fx9l"
  ,"id": 78
  ,"display_name": "microwave"
},
{
 "name": "/m/029bxz"
  ,"id": 79
  ,"display_name": "oven"
},
{
 "name": "/m/01k6s3"
  ,"id": 80
  ,"display_name": "toaster"
},
{
 "name": "/m/0130jx"
  ,"id": 81
  ,"display_name": "sink"
},
{
 "name": "/m/040b_t"
  ,"id": 82
  ,"display_name": "refrigerator"
},
{
 "name": "/m/0bt_c3"
  ,"id": 84
  ,"display_name": "book"
},
{
 "name": "/m/01x3z"
  ,"id": 85
  ,"display_name": "clock"
},
{
 "name": "/m/02s195"
  ,"id": 86
  ,"display_name": "vase"
},
{
 "name": "/m/01lsmm"
  ,"id": 87
  ,"display_name": "scissors"
},
{
 "name": "/m/0kmg4"
  ,"id": 88
  ,"display_name": "teddy bear"
},
{
 "name": "/m/03wvsk"
  ,"id": 89
  ,"display_name": "hair drier"
},
{
 "name": "/m/012xff"
  ,"id": 90
  ,"display_name": "toothbrush"
}]

关于SQL入库语句

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for detected_result
-- ----------------------------
DROP TABLE IF EXISTS `detected_result`;
CREATE TABLE `detected_result` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `detected_result_id` varchar(50) NOT NULL DEFAULT '',
  `detected_result_index` int(11) NOT NULL DEFAULT '0',
  `display_name` varchar(50) NOT NULL DEFAULT '',
  `create_time` bigint(20) NOT NULL DEFAULT '0',
  `modify_time` bigint(20) NOT NULL DEFAULT '0',
  `record_status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '是否逻辑删除 1 否 2 是',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of detected_result
-- ----------------------------
INSERT INTO `detected_result` VALUES ('1', '1', '1', 'person', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('2', '2', '2', 'bicycle', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('3', '3', '3', 'car', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('4', '4', '4', 'motorcycle', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('5', '5', '5', 'airplane', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('6', '6', '6', 'bus', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('7', '7', '7', 'train', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('8', '8', '8', 'truck', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('9', '9', '9', 'boat', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('10', '10', '10', 'traffic light', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('11', '11', '11', 'fire hydrant', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('12', '13', '13', 'stop sign', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('13', '14', '14', 'parking meter', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('14', '15', '15', 'bench', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('15', '16', '16', 'bird', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('16', '17', '17', 'cat', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('17', '18', '18', 'dog', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('18', '19', '19', 'horse', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('19', '20', '20', 'sheep', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('20', '21', '21', 'cow', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('21', '22', '22', 'elephant', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('22', '23', '23', 'bear', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('23', '24', '24', 'zebra', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('24', '25', '25', 'giraffe', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('25', '27', '27', 'backpack', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('26', '28', '28', 'umbrella', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('27', '31', '31', 'handbag', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('28', '32', '32', 'tie', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('29', '33', '33', 'suitcase', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('30', '34', '34', 'frisbee', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('31', '35', '35', 'skis', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('32', '36', '36', 'snowboard', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('33', '37', '37', 'sports ball', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('34', '38', '38', 'kite', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('35', '39', '39', 'baseball bat', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('36', '40', '40', 'baseball glove', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('37', '41', '41', 'skateboard', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('38', '42', '42', 'surfboard', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('39', '43', '43', 'tennis racket', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('40', '44', '44', 'bottle', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('41', '46', '46', 'wine glass', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('42', '47', '47', 'cup', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('43', '48', '48', 'fork', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('44', '49', '49', 'knife', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('45', '50', '50', 'spoon', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('46', '51', '51', 'bowl', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('47', '52', '52', 'banana', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('48', '53', '53', 'apple', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('49', '54', '54', 'sandwich', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('50', '55', '55', 'orange', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('51', '56', '56', 'broccoli', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('52', '57', '57', 'carrot', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('53', '58', '58', 'hot dog', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('54', '59', '59', 'pizza', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('55', '60', '60', 'donut', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('56', '61', '61', 'cake', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('57', '62', '62', 'chair', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('58', '63', '63', 'couch', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('59', '64', '64', 'potted plant', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('60', '65', '65', 'bed', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('61', '67', '67', 'dining table', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('62', '70', '70', 'toilet', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('63', '72', '72', 'tv', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('64', '73', '73', 'laptop', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('65', '74', '74', 'mouse', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('66', '75', '75', 'remote', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('67', '76', '76', 'keyboard', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('68', '77', '77', 'cell phone', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('69', '78', '78', 'microwave', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('70', '79', '79', 'oven', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('71', '80', '80', 'toaster', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('72', '81', '81', 'sink', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('73', '82', '82', 'refrigerator', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('74', '84', '84', 'book', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('75', '85', '85', 'clock', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('76', '86', '86', 'vase', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('77', '87', '87', 'scissors', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('78', '88', '88', 'teddy bear', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('79', '89', '89', 'hair drier', '1633411963228', '1633411963228', '1');
INSERT INTO `detected_result` VALUES ('80', '90', '90', 'toothbrush', '1633411963228', '1633411963228', '1');