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` = 549160 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549160 [ RunTime:0.002722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (73978,295635,807840,369469,572200,746042,696926,123408,200475,201182,508709,617467,1044083,774224,585199,312091,47306,815952,781398,705211,243897,676870,62989,776709,274835,584479,600243,886151,275639,699631,330023,903139,37296,685043,445522,481548,413733,585818,535123,838925,583923,56090,960020,889440,651825,809778,1041009,990509,543114,150928,641818,197118,857981,324944,694322,953195,530761,830815,425504,241336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]