SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496813 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496813 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211328,629379,101139,969158,253659,579179,968716,175026,51760,596930,251211,27069,160391,839525,213389,574861,449257,683284,678068,110407,974321,461735,332168,911001,374179,407325,865990,556890,209902,541696,579694,189780,914514,189728,310174,721686,411160,810689,865648,130155,335866,1042526,286469,753178,297750,596527,378855,559052,550512,728338,979816,178144,223999,957143,986583,603234,143588,127023,508013,461333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000769s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002298s ]