SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56148 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56148 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561513,996451,119987,701295,494635,971204,585046,904202,234436,245668,466503,713214,222947,530522,822878,168502,179010,820148,258979,358987,1022222,907730,793075,109554,593648,883249,517839,416178,372219,591393,378758,173653,905863,875745,328481,784399,738273,873794,825712,896079,300319,556646,159681,226605,260256,922049,158268,405665,1012228,497978,606434,611407,349204,350381,709442,659274,304179,140219,416160,434906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]