SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290518 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290518 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838588,529510,577612,464144,768057,239920,812117,571324,897911,1010216,47969,419262,787659,760355,504054,665643,723350,649939,298190,107022,332635,785708,266524,812508,117293,254574,864006,1004048,946731,661806,998217,385702,321432,628512,675109,430271,198293,462742,623986,281095,531434,775568,217118,148136,292530,511064,645767,556615,966894,612791,970871,906999,6016,367551,84342,919269,171715,315629,148648,76682) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]