SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439051 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439051 [ RunTime:0.001468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265446,104648,972601,843997,256931,338285,230181,346182,837673,943639,806135,56166,445358,313732,711163,793915,800555,264106,160687,748087,696521,895900,161570,454051,89125,217635,321740,100098,132960,570757,414378,896407,964653,866363,901562,349942,598147,765952,540736,955779,755991,15462,719440,692027,967407,726650,552049,790038,298454,267981,763598,155065,146879,335627,824583,608567,530358,740903,916100,897238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]