SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430068 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430068 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125642,545028,981910,590830,301541,809080,313888,334819,107544,204754,1038138,147252,86816,44752,282509,452935,136502,7070,92299,383699,144821,180206,613037,924349,487739,867153,992691,278493,13005,364278,283044,815107,771771,121084,638628,748996,653518,47982,508830,632643,938961,685529,778506,589049,907743,783272,313271,185099,644943,411046,773608,120841,20977,521230,884470,99190,1034454,35694,313203,959782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]