SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 730563 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 730563 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648099,990381,800393,558298,44337,418202,698284,822251,585561,353404,331308,506893,230273,538186,523358,603368,1027374,831196,338038,786612,433199,323011,456331,578347,128282,800407,555831,277054,811906,1033847,872389,575704,835196,548073,429644,794402,111140,972954,916645,622686,250568,611837,700083,913184,461719,343320,848053,788527,592179,247069,794064,225375,373088,532196,281090,245575,174278,708060,814550,800067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 730563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 730563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]