SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003533s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402991 LIMIT 1 [ RunTime:0.002111s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402991 [ RunTime:0.003292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034562,312540,389357,502539,56079,618371,810852,606298,259292,1000180,748776,947224,609959,857026,805043,736338,428998,753185,976289,523255,657904,892444,489291,729545,954988,812650,952847,22774,364761,530726,919368,482712,445131,277045,374145,811387,672920,572870,231639,507751,242366,254220,385273,982928,949379,412888,291712,628242,135975,135730,373246,476491,279835,22386,854306,212727,1008626,228307,653593,566331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002367s ]