SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537958 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537958 [ RunTime:0.005706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249177,848100,877573,224123,586410,507537,145653,33461,729363,590858,853197,572703,177090,157537,1018744,310453,42677,871531,634370,754286,980927,851127,526107,1032130,413178,392602,762413,404187,397087,632400,483182,516084,1022967,168497,972725,388223,188939,744311,745088,782742,99052,168365,1019895,439294,654759,1037764,472172,705301,767595,909386,7887,519829,449063,613678,129454,692042,96650,1031164,440746,200331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]