SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316528 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316528 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221203,112303,506150,175679,294109,181310,774899,673945,637975,668159,198248,555657,785182,997567,268728,599654,200713,868323,514504,321460,584594,818667,759889,88653,967325,421515,243916,871929,37118,227207,865014,245877,1018497,715422,767374,531204,568176,792940,211050,56826,151852,262046,809064,442843,438212,14434,361762,32067,490617,362868,850201,334730,523916,122009,86893,1031253,658203,59449,976351,989475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]