SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382716 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382716 [ RunTime:0.002512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745075,564667,956134,971534,981706,834974,142741,396991,358838,221907,967381,461482,943125,872425,744495,646140,238826,776447,1013338,601786,275005,989328,177376,543068,301481,718411,668224,1011442,42485,89850,878011,195092,724783,195768,811089,529649,547304,40641,279008,515607,861272,73108,217775,556801,889108,295029,147829,297643,940075,327166,529482,161062,101153,883736,307101,200197,269711,237085,437829,960052) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002846s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382716 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382716 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]