SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415428 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415428 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24117,35226,200507,508154,599212,570287,349205,34832,5607,543503,34733,556901,305262,41088,231574,673338,138728,813327,426952,851810,82003,352404,1044510,641494,301131,985964,773721,347853,67825,722389,741021,203923,484641,697437,706367,628360,403090,20954,799558,196289,458574,215817,931662,110686,74728,338623,484354,987697,770794,418312,706161,914431,154603,56744,5194,186423,847775,22405,780816,793653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]