SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473613 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473613 [ RunTime:0.005313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647812,189464,490610,229428,982191,433191,361322,626932,839886,51392,481568,497413,731070,497154,154219,294615,237261,41833,232960,931338,214304,717479,470001,960007,657188,542486,306382,182518,716679,660946,270978,587063,504138,1008129,89711,400320,283479,955534,37577,938231,832345,218280,1038973,431419,587993,347146,851551,1370,442005,708252,799471,891076,217371,298446,422717,831057,261497,138400,411660,5751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]