SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416807 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416807 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988894,3874,37350,952998,849751,242242,835515,681054,1007422,987465,331254,902198,580366,625652,206592,276229,761861,701244,452614,638935,275516,522295,855262,529997,452354,14741,967855,636918,807640,568600,443629,266056,905252,757866,784185,21072,620768,321672,617112,585295,629417,479567,380423,757529,1035837,169245,601856,523561,602395,913991,416234,683807,1044088,381083,356822,649574,463686,860830,658931,1034191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]