SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197626 LIMIT 1 [ RunTime:0.000990s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197626 [ RunTime:0.002013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (636983,361416,601525,884085,962339,25356,103667,331818,608286,37718,329363,183282,150063,689363,356947,711045,457558,630540,327363,896656,61345,794759,952302,662994,1011428,767035,434775,284107,718318,420576,595189,372548,978066,10590,142195,516136,256535,243973,950164,665475,966377,587183,1028483,864411,471413,804145,84745,131055,968750,213664,596756,130935,296534,187319,191797,482193,541971,412242,417986,124730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]