SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335897 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335897 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801207,1003968,294757,809846,257603,847093,876503,118050,797958,1025967,210118,965067,210260,557641,410370,620003,24580,336440,601607,78928,230718,396659,945670,890231,829526,782711,920075,337585,575110,716947,107384,1025093,500531,986712,844207,982085,125295,69438,574187,481740,938733,815921,949475,821578,1010763,115615,851561,1044629,662243,525084,518488,755098,391056,214829,528137,112190,788898,715519,165391,875263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]