SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338554 LIMIT 1 [ RunTime:0.001464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338554 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144807,939007,685679,323131,34604,870949,825088,921927,1016191,289320,556157,563602,294264,600596,1000672,216578,778223,607358,417182,339994,981140,364296,1048066,472320,228790,246712,362270,155208,854752,38183,613141,444500,250175,888155,753797,499496,680973,96834,865790,148033,608560,648494,691632,469957,604345,123886,831364,538497,604977,515614,106626,127597,54028,190355,169737,893033,596369,213392,1004744,1015334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000965s ]