SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414221 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414221 [ RunTime:0.001461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (887856,506802,337856,447024,1028493,134648,91581,940090,615171,326681,446404,210885,342865,183192,772092,841462,775589,176342,202724,186721,255132,882645,561978,934194,713211,278579,414555,364299,451392,394645,432680,593943,754837,13895,809584,162024,625344,132478,857429,703195,110623,97425,396532,570953,760465,822576,220304,390111,10896,148764,682491,777081,26297,304138,692457,523422,349798,646095,850331,113032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]