SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016323 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016323 [ RunTime:0.002235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323291,215783,321405,1010140,911739,311148,961197,598245,879312,1019642,117565,28807,290224,315486,960003,785415,402478,97425,794305,315919,463730,997702,488763,160304,594561,420141,934837,788647,961247,261216,750993,938890,681143,798865,645892,167246,841555,477106,105136,425839,718374,217112,178206,453500,167380,200857,760952,853469,301567,579274,847786,359711,729592,187015,787599,913468,410108,941497,215530,110700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]