SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334482 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334482 [ RunTime:0.001196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419726,707376,130400,484414,126065,216015,1032520,19744,634392,318018,472701,631345,918215,416506,123997,433478,208459,271628,399297,180721,779192,149729,1024886,553600,670619,561179,181765,946895,245702,337496,158840,653319,108969,259305,976584,22332,290513,380706,816432,747647,654662,169207,817068,886503,925994,422495,904012,662850,684080,232221,584171,126433,1018321,992442,59565,954520,842238,643273,798259,391241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]