SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003841s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814708 LIMIT 1 [ RunTime:0.006471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814708 [ RunTime:0.002312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042858,122091,939145,183578,41324,336482,45641,386500,506354,473228,472188,224446,724809,725082,298515,745715,680821,960844,403427,572298,138706,283639,728739,243630,419171,159834,729529,982752,80486,569859,888579,456048,297165,452310,851848,15121,399772,545412,69990,805691,707787,287375,454204,479376,520379,665005,335718,996906,588769,600654,649612,531703,756325,675307,221301,791146,11637,864098,787526,283340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]