SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 33179 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 33179 [ RunTime:0.003003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241967,558318,358395,978890,555331,44076,197485,446458,236018,268100,555717,113461,244933,698958,364056,733253,324401,620051,46968,1017475,45208,961648,837743,284361,77092,507214,85736,267986,223083,268902,648083,662637,1046349,891888,819260,782338,254118,99420,721441,962024,415585,739046,294472,282359,750546,754650,741306,60280,1023948,976917,108910,17140,212340,696534,121473,411702,642786,3789,982344,831168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001821s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 33179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 33179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]