SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481940 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481940 [ RunTime:0.002613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715182,827486,767352,873129,868330,833920,874499,432488,30161,350978,854507,1008902,385835,686993,869101,532163,1009999,198349,80449,800224,983450,495016,55969,751887,966382,1020667,91973,891666,1047184,77621,98539,915659,288978,367340,476634,636035,578090,866321,884821,308101,938497,497179,584630,104951,867609,736731,464670,393964,1020120,386344,673824,345072,811,878199,610176,875897,786460,250638,109090,349404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000721s ]