SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54689 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54689 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670223,847706,781400,789663,551405,371251,706911,687920,859244,689201,949151,399559,334022,45967,79071,8129,448709,624890,733835,704106,216209,583965,330762,516222,1040587,458968,646917,354319,604496,155594,586523,130023,208315,529604,105888,781895,164318,485705,315125,126989,937031,428728,886755,830403,934267,452660,193015,56308,524064,350973,524080,266227,394225,1004606,870142,702081,598445,257663,459743,90633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54689 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54689 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000372s ]