SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453728 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453728 [ RunTime:0.002413s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428823,765285,156583,474495,561812,677694,153029,778394,1006675,490727,595909,455886,840596,929902,683946,1000118,953502,75497,980992,331209,246283,33933,829172,900456,677160,184135,541694,359194,82999,650092,397017,250213,700099,790564,592834,179964,553492,176988,666689,502890,625261,13024,717494,946970,588480,451743,258618,468043,750846,56334,355515,215633,689847,191953,549796,632561,1036117,962291,693276,452207) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]