SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197399 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197399 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146017,229304,296757,205849,812893,669761,165679,773367,532353,510327,336220,376484,651800,897098,50416,641382,395042,198141,433247,355953,790205,103885,308899,183021,890686,629431,572517,59521,1007304,78446,680804,128791,293994,878715,510054,408383,505471,844676,932009,56587,962999,582333,692655,763847,962309,784937,459691,783912,546418,125298,260042,215370,374526,691514,337188,211656,605553,81603,674097,144258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]