SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471980 LIMIT 1 [ RunTime:0.001767s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471980 [ RunTime:0.003143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377588,162908,637567,175572,882082,215255,395927,872851,490774,3370,869756,796060,1009858,697930,65157,644911,750506,824948,255164,424387,893891,982009,472028,550231,130914,249546,656248,1032024,820013,414535,147925,831329,123241,261003,198999,353199,80446,873605,957166,406056,494040,535447,33419,377345,212491,292768,118311,198634,315095,109357,233135,543889,1000789,677802,766529,544727,46295,766865,34501,278783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001739s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]