SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002009s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508040 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508040 [ RunTime:0.002065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399344,462046,349757,804840,170433,462609,615260,867560,398247,677320,648705,653106,1019282,1045949,438624,88433,561450,662395,287809,140815,276733,138810,732378,903921,975898,366249,382111,117707,212703,314924,485733,871878,516129,806162,497227,952322,176171,70792,198402,497513,913734,465140,120242,179192,299222,676979,805985,825902,834806,659283,485954,893360,595367,835396,227659,50823,677204,431089,758021,221568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]