SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428908 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428908 [ RunTime:0.002357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549105,768294,686130,864052,649701,268107,742274,315836,518597,956289,399897,532198,355154,227621,472358,149474,1046327,829443,594683,725070,693461,1000967,350254,202220,1026098,458428,673890,702492,726615,327658,274217,522789,1399,919746,1030596,710396,858313,617906,505227,239415,727757,50350,551791,263287,72326,80049,442154,921117,635236,453426,845811,148377,640296,632931,1036374,727460,541857,1039085,1047410,74887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]