SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446860 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446860 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270913,652513,47446,578300,110910,629767,1044999,997420,983595,305496,30272,954485,90942,817164,274943,608471,1022474,929317,956332,146434,577770,583783,367929,561913,687365,945231,431704,922024,676151,762483,811231,61742,350875,608687,917816,743710,429319,708362,550779,581686,697159,615351,464023,903210,459070,562074,945860,153503,568801,599384,221061,331157,354750,938779,677524,639305,805043,53551,64301,300635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]