SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018000 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018000 [ RunTime:0.001607s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28855,916844,110544,492503,387355,653865,219300,604497,532973,219949,341006,1007095,1003418,661715,589568,92010,292020,840829,999307,755543,933941,85767,472298,603030,773409,472533,301387,462116,1005550,861031,108101,495125,413522,661848,1040200,99846,702398,685350,1043691,232886,650564,955295,616691,590476,153126,707434,995657,597202,118140,729854,165522,67815,61117,396100,30455,424660,202548,31944,531065,234913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]