SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002499s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473431 LIMIT 1 [ RunTime:0.002210s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473431 [ RunTime:0.002886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811508,690397,236283,264635,470993,525088,765834,753594,453835,244706,347308,9233,240954,664851,448435,493374,521936,409050,1022869,652522,502336,597546,543470,61724,704474,518311,446641,875968,908160,196458,596307,504676,793271,320163,909263,1013458,43135,1027168,973648,188405,190085,527630,1023209,593437,144870,110877,365810,964271,427280,526684,472721,34858,2100,136352,34811,299887,142658,3124,482931,677836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]