SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503678 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503678 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160444,349452,685623,538514,261427,737019,583134,23340,212565,640241,899078,759136,306359,860848,286718,61575,281816,645106,401464,60666,908367,414403,845221,864969,230362,944598,518430,414076,559991,351276,291705,370170,699719,335364,8595,431702,619337,492099,977013,241738,968531,77471,679426,870702,241935,430243,486542,832418,41903,701913,995412,24641,598977,61629,76604,822726,898172,668134,634501,629416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]