SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412984 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412984 [ RunTime:0.002224s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (139419,714288,542979,1046652,995425,594320,973184,78385,711401,698821,15350,624319,125887,335220,476291,876236,746878,738082,320730,340257,768408,411051,804320,491147,107874,449057,403852,991192,369176,805351,578309,485110,793183,531587,351082,101909,671152,1036970,695619,997214,395188,446010,438496,832662,12332,743107,45369,600366,219146,134321,409516,328852,997111,253543,534891,418789,267659,492330,515814,958149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]