SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265703 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265703 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402442,130470,381621,416471,979204,532450,481396,665505,471178,416714,98383,207254,1029334,679864,925442,309291,503859,285376,342169,710586,791676,474434,461467,524490,350997,1046803,171988,106413,275407,128642,556449,790264,438040,858897,449093,793741,641607,532443,682656,173672,393589,930701,551210,51017,1046381,774621,983386,348428,314288,336119,806376,251401,284101,325981,828211,243201,769795,1011745,867814,970942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]