SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51412 LIMIT 1 [ RunTime:0.000955s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51412 [ RunTime:0.001450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031313,20020,656985,575157,931860,339840,278257,1012372,498064,921557,660911,27506,873249,493183,268027,918155,668208,773425,1033920,188694,925977,181452,597110,806526,754898,275616,322981,276459,803657,243462,285345,123090,216760,468912,840012,175785,270287,477700,349178,554015,711605,17927,418163,493387,536489,958337,530598,307004,247495,79649,323054,465561,278676,127645,406154,248101,1008612,758280,918451,258703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]