SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489006 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489006 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425965,545235,408333,237253,718083,789625,149697,708102,175901,950798,672136,355275,613951,1037161,210430,73178,610577,601812,66882,1032662,403366,986324,934540,954167,413913,782108,702615,64845,699062,939444,69771,271159,315136,349731,268681,714031,499595,804827,888545,621595,466114,728575,348176,873248,122607,661599,61869,631125,573420,453131,585669,696938,151584,751461,797100,17558,105979,522360,1412,259591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001892s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001752s ]