SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502958 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502958 [ RunTime:0.001938s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682165,751901,425732,584349,111284,70955,225186,958666,929831,540552,332970,646943,297206,436353,394656,53706,395654,200486,575749,496320,830342,78075,564529,844745,1019450,98707,58815,333416,285466,263405,587333,130051,933432,682489,346235,704801,505060,932504,570590,624338,246116,590900,336162,953468,181617,149013,1021150,122919,105729,160121,55590,528621,670427,684937,135481,799824,272976,503277,728509,931974) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002314s ]