SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841938 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841938 [ RunTime:0.001703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614409,1005673,197960,207170,1022137,246490,912011,299923,967623,847391,881446,1008715,30953,604218,662179,526934,83846,919316,201500,686113,805838,1032484,163083,1031735,91398,457584,592600,809400,927015,784668,534531,611186,242584,246909,248080,478736,906970,511525,461935,194319,760013,649777,727386,340419,274317,809978,545615,549766,113357,322719,740024,697435,664507,159284,443084,834355,576695,1044634,901927,726093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]