SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108012 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108012 [ RunTime:0.002231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768583,182414,515050,185590,655306,275547,765413,593999,375952,341731,1005815,280155,457652,485670,83849,104759,406591,1025212,481416,869225,818234,496236,846669,31472,995381,902878,90703,489986,620331,276194,829844,808492,794179,845917,679431,148005,434127,7811,276703,464617,554644,334042,266190,285335,94611,709585,626898,19154,257597,28248,807110,560290,123857,828450,588130,160823,769204,605946,288580,27457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]