SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810651 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810651 [ RunTime:0.002150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318332,165936,667073,224908,272301,749351,12539,98865,111965,1006727,292874,1029741,458010,503676,932844,485574,328444,640711,84688,1762,570606,751289,101485,458079,570575,1024716,35981,187168,728024,13358,841522,296181,197789,505525,342015,22710,428409,872957,981614,104103,50005,684017,266049,964548,220285,917845,626700,615138,1040401,1040253,7432,666209,454281,583560,36998,174684,318362,810389,586748,664275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]