SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410726 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410726 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206546,298070,209363,275344,536566,527824,739736,782415,502540,75874,321429,272847,381627,1028415,411657,560707,668658,819231,471485,653664,397749,228569,729473,807750,847176,449663,54995,357765,806786,100846,277678,468627,470584,606289,14293,656537,652600,252909,647529,644502,323697,91813,924772,375284,501544,418755,431604,806339,880826,1010566,812331,427040,608007,258708,853146,179172,743886,727461,159507,362220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]