SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016865 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016865 [ RunTime:0.007777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (2081,60883,89000,951226,1033766,72325,724143,734179,545373,284555,233165,383121,169001,168712,719373,622358,151930,597695,496914,597346,656031,938945,292011,512646,336472,320994,743969,282271,281846,911378,928062,801928,690503,503274,92864,667101,160149,501236,185707,487857,109525,1011208,854997,878532,325180,468620,705549,395464,877660,905941,757033,983949,85192,905344,666567,231830,546667,847336,236603,221210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016865 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000818s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016865 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001207s ]