SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10110 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10110 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98232,836419,851401,284245,259942,523560,118149,197569,344524,931037,107405,110285,287126,449392,801784,109069,492453,980961,908276,969548,1013003,306888,788261,274086,854719,826043,904416,761724,118976,302578,836907,629590,71923,213059,63973,406324,860256,288726,384548,1031185,757944,663756,387644,183009,109203,612353,913848,401358,339535,484579,56832,606688,174593,324030,464944,89427,167541,229373,26177,575112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002848s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]