SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001952s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 253410 LIMIT 1 [ RunTime:0.000744s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 253410 [ RunTime:0.005755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710318,698150,140396,38564,826780,123125,1041564,589362,500208,361427,114326,587878,32637,341375,695695,622735,915706,419262,865772,428059,757781,374268,614973,1032965,468642,938947,742560,437533,477995,424218,839764,827081,573932,634128,766720,520057,849538,736284,86066,103030,777400,526566,501965,529775,885568,506048,923934,149738,216963,928370,705043,1020707,245325,77815,891947,921196,181179,828056,862056,544898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 253410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 253410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]