SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528951 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528951 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847143,812908,712702,658533,493480,286689,147042,665878,686310,169811,143281,589150,1016852,807512,513499,574882,71813,549660,348619,414066,208014,903568,6060,322260,545305,520338,401843,14454,301540,626267,187508,40491,483225,338659,245292,348661,423967,705965,314355,831568,127135,507169,916472,854717,343850,791866,213321,473665,562401,874897,268577,554727,186945,811342,1044560,1009419,749886,323573,712568,940008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528951 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528951 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]