SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437881 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437881 [ RunTime:0.003243s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862225,854906,279946,964208,426378,861979,475022,82492,486121,1040827,175745,954456,895489,329087,556363,897982,173672,953866,706994,558130,621182,350448,417856,152036,437856,461233,412880,532751,760212,738915,879569,129311,226430,747260,507347,642610,438059,328075,266015,670885,157826,976000,6243,438736,262943,214080,398988,706124,839504,645308,756385,411884,1022401,307663,458723,895444,734748,480899,654934,489485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000880s ]