SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001633s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681721 LIMIT 1 [ RunTime:0.000781s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681721 [ RunTime:0.002153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145571,108123,857648,924495,511061,466463,806763,398975,444912,513193,365162,611096,979709,796378,260333,556563,372294,542208,757325,1009245,729973,215634,331532,286008,1006853,945831,562689,572388,949171,411320,693324,859600,272660,876820,992122,219007,299785,973775,901204,912605,108778,449055,566157,798947,886089,584603,364472,811470,828837,886270,238400,490768,856426,224579,819770,464757,810109,756291,770845,945861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003080s ]