SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200560 LIMIT 1 [ RunTime:0.000569s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200560 [ RunTime:0.003482s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396898,55422,506169,1048514,878466,581585,367863,622529,803954,156166,463035,198449,168677,369566,33176,404320,1019728,455366,621801,49065,160093,866128,115300,587065,279768,249161,27472,942880,577576,372432,259063,551989,1036002,524430,833339,956675,48799,1020154,982542,628297,178338,123342,422604,273536,263232,782298,1046670,112644,761769,115463,450561,711456,522329,503737,433961,66052,681113,17991,181891,102743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]