SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201150 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201150 [ RunTime:0.002256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247745,836530,45355,882236,231654,740764,387277,247113,232052,78861,905050,886597,1044399,792584,929097,618277,170377,97369,564025,955507,621674,210901,593387,504798,732030,465015,821263,707343,895787,573159,147322,890157,343027,509455,729868,446010,412065,306571,279060,924024,390639,666438,231687,688262,124439,78613,639594,508556,79552,947858,461631,704571,549098,850847,1026599,124049,420357,553758,323803,424191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001829s ]