SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801074 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801074 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599188,275810,895942,995605,993537,615419,123943,1041695,395728,128160,576732,639437,916804,60134,1041688,992280,540262,129456,298020,952726,77277,604042,971662,1041206,51239,325943,340621,813602,857207,586348,346208,909117,937491,506281,923284,209716,642884,495712,930077,284404,1550,108518,846530,479201,739486,919197,436532,824986,283669,54376,980682,681025,820854,293639,741472,669021,399679,361772,1002426,607403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002038s ]