SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380389 LIMIT 1 [ RunTime:0.000760s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380389 [ RunTime:0.002428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (938186,906979,602493,40829,61577,113754,613871,229986,152190,513532,138864,1034341,33117,315843,383450,286462,115020,536088,955076,861788,529529,196357,496271,270488,575836,923118,628731,991537,261563,576225,811786,400804,678863,1025041,631886,106088,245921,982235,168835,343558,447574,2824,534731,827907,58943,559769,510355,290485,269875,537243,1028730,235869,159624,72230,158135,156330,733313,372681,801378,355138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]