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` = 1040821 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040821 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239083,472345,51834,422331,367426,193830,715577,911559,79741,26288,669979,1032049,779619,940018,665456,977176,19257,343106,23698,45318,675839,81127,851305,763108,146432,825187,382717,52875,669053,510253,62606,302872,652244,521364,755012,390405,339775,313139,898919,907808,797588,762295,1012304,1018050,275648,863932,385095,867079,676908,845127,504283,707499,238379,10387,286447,126331,232112,766340,558581,14369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]