SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280516 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280516 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117786,486957,696171,909152,287482,200836,662987,896178,12593,790598,397060,643505,183143,939379,330222,956297,1005244,32736,1037060,839963,938989,626927,1208,136440,88617,885088,447302,186181,524820,289388,534964,955566,982581,872685,249228,567497,501309,576694,199268,788483,790031,878667,891896,33031,829802,173797,485493,481934,472512,176171,593558,242721,168567,923346,446556,270873,25398,567478,568093,303327) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000807s ]