SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596511 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596511 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312866,341146,254492,600374,979882,722506,573740,669229,310441,622510,956084,747637,355391,727238,861572,90750,744431,247162,718356,914630,222419,428623,36930,77351,843594,356284,266407,166112,1018388,361974,42422,302145,234897,801165,494861,195419,741264,678796,124717,1040479,511261,689970,435955,932093,190986,654805,983713,144848,629471,910848,978224,257292,92839,993147,698415,425578,931557,1036237,997046,99273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]