SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502909 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502909 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046992,756392,871403,187966,744883,215643,40659,705428,933097,602399,306823,2031,266259,555420,836613,324883,851025,447001,625495,465080,245126,621757,855764,398084,918360,645172,428015,1031556,476886,926709,433517,256933,286462,428699,895333,369677,467816,1019069,257306,544309,135460,538366,998556,551447,148043,301160,419048,589662,338242,343572,384165,590670,325540,962659,771013,407293,466342,619759,1044962,124566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]