SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 712160 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 712160 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510434,934313,48060,702566,491330,109109,745120,258566,453352,694583,414965,537388,1014601,987683,539387,735082,688687,746146,448946,30775,901245,646371,301802,1035228,368507,853658,886451,565103,910187,237251,420575,361537,993887,175611,508058,963199,43916,797393,928073,336178,1658,996836,145249,1031087,908121,308676,464743,471533,239960,969325,150980,228228,274837,78842,104516,138291,441526,1034516,314813,692731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 712160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 712160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]