SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408728 LIMIT 1 [ RunTime:0.000964s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408728 [ RunTime:0.002009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276951,419969,783179,542618,668479,836719,50113,41507,179998,920312,556240,197835,388017,100245,585510,1165,20108,420865,58840,136252,488466,557339,126434,168639,271813,478525,207947,54615,500145,788544,926273,390034,442148,644767,821203,356576,242584,31034,427050,74526,365600,1036521,653012,252320,73945,576206,401165,923801,486995,371361,580625,35631,146336,586844,543759,851466,440942,814314,231487,876804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000970s ]