SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314797 LIMIT 1 [ RunTime:0.000539s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314797 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473844,46997,455931,108650,46884,830462,360816,416864,695402,353209,831399,985919,841365,376317,236403,234446,833897,404552,281429,938568,22166,722762,296552,924451,72318,899886,407901,281501,748426,1024741,850578,926295,45140,193205,391444,116341,559003,937136,367853,114719,848338,949382,909290,311037,629430,2734,913665,718466,351083,193452,152656,317191,472561,990088,438295,597965,278978,456696,815590,351528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]