SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201901 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201901 [ RunTime:0.001387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004599,146722,693013,639303,135933,663416,346013,138672,357118,413668,198116,19996,608611,565089,54060,438112,422321,1005071,744845,189096,611936,509012,349750,743521,767845,109573,336577,664377,15005,545676,55677,824633,759424,856486,429556,384758,719684,291959,123095,954016,999294,247616,958097,145087,634156,194122,630564,847058,145564,198511,139994,986822,911335,252460,1005768,998712,114552,596916,1027480,949481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]