SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411311 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411311 [ RunTime:0.004291s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233118,1005281,729270,274266,56404,959516,605196,177494,25470,480029,25322,24025,248069,898627,384666,71561,320962,822640,131593,856827,624337,358893,846646,85720,1016836,350196,371935,275770,618459,837385,319802,482247,452291,157345,987798,932540,230021,156787,1007682,706342,626043,838843,525112,232692,400351,554500,970898,924041,48257,638457,258652,1002968,639347,414528,245121,872792,942528,71635,372282,492354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.030705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001890s ]