SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002774s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200932 LIMIT 1 [ RunTime:0.000641s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200932 [ RunTime:0.002497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550988,399959,800631,455816,66043,323765,152210,328245,585663,882718,837351,868810,429216,814123,906964,238377,31971,402991,155612,426318,1042094,842897,338120,283967,314347,912995,1021135,218110,812659,698046,585034,514326,44768,1022494,262143,493887,58704,201445,758442,231820,999266,195160,653738,171281,598448,308194,150249,931968,295334,543057,532068,502871,758614,511907,1014279,176660,15229,829705,853828,625501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200932 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200932 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]