SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39004 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39004 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508333,555481,826647,250538,592789,127159,390601,33717,613868,865363,1035062,191268,765267,557924,384342,60392,676603,774293,101338,969304,613769,502082,904948,852449,994114,554915,433497,46137,723811,586410,204951,715815,567105,341142,33879,296977,198811,370929,511587,63294,1026587,357198,172000,193867,471106,508023,777957,282540,233015,147709,887924,173367,800858,583110,1065,865967,590285,456444,731977,562746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]