SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001648s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549732 LIMIT 1 [ RunTime:0.000701s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549732 [ RunTime:0.002539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224859,656364,426093,1028013,931154,354010,909188,399186,482869,54344,177610,430903,564362,1046506,920475,1033295,230502,546469,116189,772235,345761,71445,129755,835354,441695,52337,735427,800128,506518,886267,119681,346002,533771,22760,208757,338232,259173,730011,981263,526060,502418,868567,419022,737790,868860,414599,723154,713093,67678,845957,302911,17863,206361,897808,908088,446357,117892,919975,592741,494453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549732 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549732 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]