SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046543 LIMIT 1 [ RunTime:0.000731s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046543 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (717580,411166,482140,206284,1026582,73417,430396,204280,772655,501010,650626,439584,613577,422324,353908,817268,225233,191725,830147,813043,551458,335194,1033225,398110,130135,875529,298703,133075,203999,72928,541576,578594,371505,466773,970593,696096,696822,113151,260529,119824,715725,825985,739777,1031925,369819,931361,967249,163947,492850,709399,814760,310530,160628,771406,467176,584640,322805,634098,861813,143613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002723s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002472s ]