SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 680921 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 680921 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022417,538377,692306,482931,1004710,614080,27204,11920,10896,297184,530166,409137,951103,213464,590974,728424,649670,62458,961397,124011,735218,969154,88278,273461,125173,344234,242755,230919,1027677,692858,782668,223647,464811,836877,984866,278653,1033318,779329,560895,158293,560225,864664,714410,847092,108901,471105,777874,477489,360003,818394,529691,462412,863430,932421,1018943,976014,348613,541105,1037434,708894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 680921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 680921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002089s ]