SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501983 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501983 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452080,1029775,886023,970731,660311,795004,306272,381778,1025570,627232,924811,783172,289501,835609,365755,962039,922821,741703,714554,269486,927252,170069,77239,547365,390356,806989,1007184,626439,329067,333,896226,907918,938733,63169,433147,213179,531899,527143,28946,160168,1042148,349686,828907,183315,257756,920348,311257,1012795,103446,779677,268469,461765,37327,469325,79835,957138,749896,723755,102624,878786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]