SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201738 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201738 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749891,1045256,132742,802806,627213,336997,504382,592944,427937,827655,368294,287839,683004,287419,437333,805055,771318,913364,117870,767306,40746,762229,489075,900687,768611,318238,655587,284439,57765,520031,190184,126686,85227,539286,660853,519487,417798,548391,664369,32613,851545,251017,421009,119170,190020,935106,120170,568697,871886,825716,722826,792536,343321,781215,72706,553889,564463,663279,697144,860298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]