SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001570s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901515 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901515 [ RunTime:0.002018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491018,773686,1006087,255985,586017,166700,1029655,741033,1025436,277555,785472,287956,594703,72060,3479,1019148,279028,191111,33656,110163,1031682,923725,225624,691323,625559,116881,583064,575823,36965,900808,952985,479053,233966,764157,178384,379171,641820,939381,466474,609885,362570,1043783,288588,678862,126231,391384,838392,623058,1023992,209004,564158,1011717,739129,670747,958667,224565,175517,110245,104190,392260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]