SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20047 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20047 [ RunTime:0.005284s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58943,487253,837472,187711,1021840,1016091,819283,869147,1040448,833693,63508,588468,514690,152913,335365,959237,415696,658398,834632,202760,876435,57412,289504,612850,243847,731035,414237,943865,408031,850639,140796,589477,268623,597446,723709,204402,300814,193560,204071,941489,870795,96090,448704,520325,183249,272027,409302,438848,752001,84091,515557,780659,391516,670875,572789,640262,402008,195211,546428,978282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20047 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20047 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000728s ]