SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35230 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35230 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540077,826309,327041,345851,662047,892426,110457,715634,900698,172016,886711,889618,789429,662484,563136,449777,610386,183804,890988,782071,463772,187219,79754,562016,248001,239189,33465,641037,629252,283980,303036,649445,900069,691518,731972,520803,135669,850892,794674,489823,918882,448428,947293,513342,378365,489624,501614,740647,284895,55448,1040174,351695,915064,699696,185624,720278,539889,558501,646916,173513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]