SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319977 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319977 [ RunTime:0.002181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427557,241220,308030,1016805,641744,900998,862712,367305,673309,517476,257788,831318,592236,884659,779037,139543,991841,763247,440246,235072,1036267,44380,549231,115294,848867,438162,837503,846920,559813,750838,469165,409566,467209,330749,409908,295325,504545,269752,857371,611980,944670,154258,668232,471885,643787,664523,726587,463706,790235,105812,547780,591599,606469,170922,222674,908216,760587,349476,693061,997436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319977 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319977 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]