SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479841 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479841 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299345,164751,829844,702026,1017097,357294,999946,88465,768608,225256,723070,156416,888891,436795,392560,991317,573358,854395,852978,620909,598082,36995,90189,1031868,565066,295934,1015470,252056,642303,75366,483005,284826,917336,687662,513328,1034589,39302,331818,873014,925648,912425,94052,576411,1031103,1001743,1026069,698843,87742,1040065,772272,419942,771386,215206,497154,512603,282159,916989,484808,265520,956195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]