SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534901 LIMIT 1 [ RunTime:0.001313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534901 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393033,1038652,1030242,838141,719455,239826,464639,862127,27918,928184,342321,966838,508099,398510,140355,614338,92310,628779,77769,653204,1047869,618187,580351,12174,3769,839085,592043,823269,525694,792108,747704,278875,479640,21600,716725,79062,332491,161405,463626,426581,886339,253403,658669,350353,86702,908220,429616,590662,922644,684102,92990,586902,495844,669343,506831,514244,686849,862723,841853,596779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]