SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401641 LIMIT 1 [ RunTime:0.000275s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401641 [ RunTime:0.002442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640748,339844,881967,447293,663103,896165,178787,688670,549662,455716,336899,463108,961031,685393,85232,850245,679115,860307,495161,412743,382391,97804,976507,281308,5931,157473,384435,690365,983157,792359,1043157,604785,987137,587810,585743,687403,258058,981974,82784,744492,634246,329337,905185,897457,542943,452491,755440,64421,65021,569218,26724,381253,191503,244330,895372,581648,883509,1013209,926755,427696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001121s ]