SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801566 LIMIT 1 [ RunTime:0.000763s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801566 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491401,359773,558890,688071,793567,55988,696160,905410,927978,13908,709088,343717,69294,461244,199010,396334,287307,316607,240172,17470,741146,592211,16757,721489,616850,224473,12125,740137,180078,652433,376891,512995,29638,257806,109117,1021733,1001710,287654,786565,578888,529623,11147,72877,412669,344567,157099,938113,658262,22131,933261,212307,544262,147461,189689,10351,254049,501002,284138,384780,730137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801566 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801566 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]