SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399871 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399871 [ RunTime:0.001391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527230,871472,217894,448023,198984,606794,135741,428025,5098,225380,653377,942933,978835,597996,297624,365404,811473,318156,73241,1007378,260851,743140,164578,915529,662219,442703,569970,207709,337192,566179,929700,506576,529596,378666,730205,201136,638312,887339,750174,212009,292032,644801,997082,606919,26732,895313,174458,634765,759985,179078,801123,612341,420727,361223,243458,310869,189626,21156,464629,270872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]