SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317958 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317958 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29204,887462,501168,337253,1009827,934713,371147,828525,488289,430801,575053,442772,88418,328255,991230,841161,158018,955424,931950,211149,171616,261632,740766,171470,799338,11003,481237,1041548,3890,453456,925257,106566,365135,658389,35717,477077,387835,423877,419044,899762,567489,431438,264738,72472,1008313,316125,594736,301774,159696,540682,732944,557334,24247,612539,865511,777215,451866,54053,683681,715028) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]