SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489283 LIMIT 1 [ RunTime:0.002224s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489283 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111681,890937,478927,179804,1005543,399864,722509,539401,641318,839206,247556,747286,419204,321493,119885,148224,705669,122699,484741,677764,553622,904771,514979,585981,63765,108402,515996,626752,80355,692082,718911,81746,284363,652311,656000,990785,797780,299098,622333,711,770518,111425,931075,708530,777878,1028500,876229,54960,191313,963189,933590,144552,587945,928180,177190,271188,565835,1024065,159823,982894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]